在路上

CRM 收Gmail 邮件设置

    <container name="javamail-container" class="org.ofbiz.service.mail.JavaMailContainer">
        <property name="delegator-name" value="default"/>
        <property name="dispatcher-name" value="JavaMailDispatcher"/>
        <property name="run-as-user" value="system"/>
        <property name="poll-delay" value="300000"/>
        <property name="delete-mail" value="false"/>
        <property name="maxSize" value="10000000"/>
        <property name="default-listener" value="store-listener">
            <property name="mail.store.protocol" value="pop3s"/>
            <property name="mail.host" value="pop.gmail.com"/>
            <property name="mail.user" value=""/>
            <property name="mail.pass" value=""/>
            <property name="mail.pop3.socketFactory.class" value="javax.net.ssl.SSLSocketFactory"/>
            <property name="mail.pop3.socketFactory.fallback" value="false"/>
            <property name="mail.port" value="995"/>
            <property name="mail.pop3.socketFactory.port" value="995"/>
            <property name="mail.pop3.timeout" value="300000"/>
            <property name="mail.debug" value="Y"/>
        </property>
    </container>

posted @ 2010-11-26 18:14 alexyang911 阅读(71) 评论(0) 编辑

平常用的上的一些SQL

简单统计表信息

create table #temp
(name varchar(255),
 rowcnt int,
 reserved varchar(20),
 data varchar(20),
 idx_size varchar(20),
 unused varchar(20))
exec sp_MSforeachtable "insert into #temp exec sp_spaceused '?'"
select * from #temp
drop table #temp

杀掉数据库进程

Create Proc proc_KillDeadlockSPID
@DBName varchar(50)
As
Begin
use master
Declare @Sql nvarchar(max)
Declare @SPID int
Declare cur Cursor For Select SPID From SysProcesses Where DBID=DB_ID(@DBName)
Open cur
Fetch Next From cur Into @SPID
While @@Fetch_Status=0
BEGIN
Set @Sql='kill '+rtrim(@SPID)
exec(@Sql)
Fetch Next From cur Into @SPID
END
Close cur
Deallocate cur
End

posted @ 2010-11-25 18:07 alexyang911 阅读(70) 评论(0) 编辑

多线程HtttpRequest 一定要记得关闭reponse

public static bool WebFileExistsWithClose(string url, int timeoutSeconds)
{
    HttpWebResponse response = null;
    bool flag;
    try
    {
        HttpWebRequest request = (HttpWebRequest) WebRequest.Create(url);
        request.Timeout = timeoutSeconds * 1000；

       request.AllowAutoRedirect = true;
        request.MaximumAutomaticRedirections = 200;
        response = (HttpWebResponse) request.GetResponse();
        if (response.StatusCode == HttpStatusCode.OK)
        {
            return true;
        }
        flag = false;
    }
    catch (WebException)
    {
        flag = false;
    }
    catch (Exception exception)
    {
        throw exception;
    }
    finally
    {
        if (response != null)
        {
            response.Close();
        }
    }
    return flag;
}

posted @ 2010-11-24 18:21 alexyang911 阅读(81) 评论(0) 编辑