夢想號黃包車wei.lee net-home

          Have my best life at SZ....................

            BlogJava :: 首頁 :: 新隨筆 :: 聯(lián)系 :: 聚合  :: 管理 ::
            6 隨筆 :: 3 文章 :: 6 評論 :: 0 Trackbacks

          2006年3月29日 #

          這段時間有機會接觸DOT NET方面的項目,開始DOT NET的新生涯.學習DOT NET首先當然要從microsoft的官方例子學起哦,我首先選擇了petshop和vs2003自帶的Duwamish 7.0(可以在vs安裝的路徑上找到的\Microsoft Visual Studio .NET 2003\Enterprise Samples).當然我會選擇喜歡的C#版本來學習.萬事起頭難,我一裝petshop,事情就來了,但是小小的問題是難不著我的.

          安裝配置:
          ?OS :? WIN2003
          DEV:? VS2003
          IIS6.0
          SQLSERVER2000 Enterprise version

          Duwamish 7.0的安裝完運行沒問題,但是petshop安裝后出現(xiàn)SQLException,我完全安裝ReadMe.rtf的步驟來安裝的,安裝過程中輸入的sql帳號密碼都是沒錯的,因為數(shù)據(jù)庫MSPetShop,MSPetShopOrders能夠在sqlserver2000看到.具體錯誤如下:
          petshop_sqlexception.png

          我查看過安裝路徑下的:\ConfigTool里的App.config文件發(fā)現(xiàn)配置文件的user和password都沒有在sqlserver配置到,所以我在sqlserver2000里的安全性-->登陸里添加兩個用戶:MSPetShop 和 MSPetShopOrders; 密碼都是:password;同時分配該用戶訪問上面的兩個數(shù)據(jù)庫,這樣重新運行petshop,一切都很正常地跑起來了...........:)
          petshop_sqlsetting.png


          petshop_sqlsetting2.png?

          輸入http://localhost/MSPetShop/?
          petshop_0.png


          petshop_1.png?
          輸入http://localhost/Duwamish7/
          Duwamish7.png
          開始學習DOT NET?拉,真是激動!就算獻身給microsoft一輩子都是值得的:)
          posted @ 2006-05-12 15:16 Wei.Lee 閱讀(892) | 評論 (0)編輯 收藏

               摘要: Item1#: Repository 組件在不同版本的不同之處? Answer : Repository ...  閱讀全文
          posted @ 2006-05-08 19:16 Wei.Lee 閱讀(855) | 評論 (0)編輯 收藏

          一般我們都會使用數(shù)據(jù)庫和文件作為log的輸出介質(zhì),下面是我在項目實踐中總結(jié)到的經(jīng)驗:
          1 .ADONetAppender
          ( 1 )、 MS SQL Server
          define the table such as:
          CREATE TABLE [dbo].[Log] (?
          ?[Id] [int] IDENTITY (1, 1) NOT NULL,
          ?[Date] [datetime] NOT NULL,
          ?????? [Thread] [varchar] (255) NOT NULL,
          ?????? [Level] [varchar] (50) NOT NULL,
          ?????? [Logger] [varchar] (255) NOT NULL,
          ?????? [Message] [varchar] (4000) NOT NULL,
          ?????? [Exception] [varchar] (2000) NULL
          )

          <appender name="AdoNetAppender" type="log4net.Appender.AdoNetAppender">
          ?????? <bufferSize value="100" />
          ?????? <connectionType value="System.Data.SqlClient.SqlConnection, System.Data, Version=1.0.3300.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" />
          ?????? <connectionString value="data source=[database server];initial catalog=[database name];integrated security=false;persist security info=True;User ID=[user];Password=[password]" />
          ?????? <commandText value="INSERT INTO Log ([Date],[Thread],[Level],[Logger],[Message],[Exception]) VALUES (@log_date, @thread, @log_level, @logger, @message, @exception)" />
          ?????? <parameter>
          ????????????? <parameterName value="@log_date" />
          ????????????? <dbType value="DateTime" />
          ????????????? <layout type="log4net.Layout.RawTimeStampLayout" />
          ?????? </parameter>
          ?????? <parameter>
          ????????????? <parameterName value="@thread" />
          ????????????? <dbType value="String" />
          ????????????? <size value="255" />
          ????????????? <layout type="log4net.Layout.PatternLayout">
          ???????????????????? <conversionPattern value="%thread" />
          ????????????? </layout>
          ?????? </parameter>
          ?????? <parameter>
          ????????????? <parameterName value="@log_level" />
          ????????????? <dbType value="String" />
          ????????????? <size value="50" />
          ????????????? <layout type="log4net.Layout.PatternLayout">
          ???????????????????? <conversionPattern value="%level" />
          ????????????? </layout>
          ?????? </parameter>
          ?????? <parameter>
          ????????????? <parameterName value="@logger" />
          ????????????? <dbType value="String" />
          ????????????? <size value="255" />
          ????????????? <layout type="log4net.Layout.PatternLayout">
          ???????????????????? <conversionPattern value="%logger" />
          ????????????? </layout>
          ?????? </parameter>
          ?????? <parameter>
          ????????????? <parameterName value="@message" />
          ????????????? <dbType value="String" />
          ????????????? <size value="4000" />
          ????????????? <layout type="log4net.Layout.PatternLayout">
          ???????????????????? <conversionPattern value="%message" />
          ????????????? </layout>
          ?????? </parameter>
          ?????? <parameter>
          ????????????? <parameterName value="@exception" />
          ????????????? <dbType value="String" />
          ????????????? <size value="2000" />
          ????????????? <layout type="log4net.Layout.ExceptionLayout" />
          ?????? </parameter>
          </appender>
          ( 2 )、 MS Access? please reference the SDK of Log4net document???
          ( 3 )、 Oracle9i???????????????????????????????????? log4net/release/config-examples.html
          ( 4 )、 Oracle8i
          ( 5 )、 DB2

          2 、 FileAppender
          <appender name="FileAppender" type="log4net.Appender.FileAppender">
          ????? <file value="log-file.txt" />
          ???? <appendToFile value="true" />
          ???? <layout type="log4net.Layout.PatternLayout">
          ???? <conversionPattern value="%date [%thread] %-5level %logger [%property{NDC}] - %message%newline" />
          </layout>
          </appender>

          4.? RemotingAppender
          傳送日志事件到達一個特定的接受器,sink定義了這個接受器的地址,lossy定義了沒有丟棄事件,bufferSize 定義了一個black的由95個事件打包發(fā)送的,而onlyFixPartialEventData可以忽律一些特定的事件。
          <appender name="RemotingAppender" type="log4net.Appender.RemotingAppender" >
          ?????? <sink value="tcp://localhost:8085/LoggingSink" />
          ?????? <lossy value="false" />
          ?????? <bufferSize value="95" />
          ????? <onlyFixPartialEventData value="true" />
          </appender>

          5.? RollingFileAppender
          由于定義了staticLogFileName 為true,以我的理解就是定位保存的log文件個數(shù)為10個(maxSizeRollBackups),同時設定了每個文件的大小為100KB,所以一直都保持有10個文件。RollingStyle設定rolling的觸發(fā)器。
          Eg1:
          <appender name="RollingFileAppender" type="log4net.Appender.RollingFileAppender">
          ???? <file value="log.txt" />
          ??? <appendToFile value="true" />
          ??? <rollingStyle value="Size" />
          ?? <maxSizeRollBackups value="10" />
          ?? <maximumFileSize value="100KB" />
          ?? <staticLogFileName value="true" />
          ?? <layout type="log4net.Layout.PatternLayout">
          ?? <conversionPattern value="%date [%thread] %-5level %logger [%property{NDC}] - %message%newline" /> </layout>
          </appender>

          ? eg2:?
          <appender name="RollingLogFileAppender" type="log4net.Appender.RollingFileAppender">
          ?????? <file value="logfile" />
          ?????? <appendToFile value="true" />
          ?????? <rollingStyle value="Date" />
          ?????? <datePattern value="yyyyMMdd-HHmm" />
          ?????? <layout type="log4net.Layout.PatternLayout">
          ????????????? <conversionPattern value="%date [%thread] %-5level %logger [%property{NDC}] - %message%newline" />
          ?????? </layout>
          </appender>

          eg3:

          <appender name="RollingLogFileAppender" type="log4net.Appender.RollingFileAppender">
          ?????? <file value="logfile" />
          ?????? <appendToFile value="true" />
          ?????? <rollingStyle value="Composite" />
          ?????? <datePattern value="yyyyMMdd" />
          ?????? <maxSizeRollBackups value="10" />
          ?????? <maximumFileSize value="1MB" />
          ?????? <layout type="log4net.Layout.PatternLayout">
          ????????????? <conversionPattern value="%date [%thread] %-5level %logger [%property{NDC}] - %message%newline" />
          ????? </layout>
          </appender>

          6.? UdpAppender
          可以發(fā)送到遠程地址的特定端口
          <appender name="UdpAppender" type="log4net.Appender.UdpAppender">
          ?????? <localPort value="8080" />
          ?????? <remoteAddress value="224.0.0.1" />
          ?????? <remotePort value="8080" />
          ?????? <layout type="log4net.Layout.PatternLayout, log4net">
          ????????????? <conversionPattern value="%-5level %logger [%property{NDC}] - %message%newline" />
          ?????? </layout>
          </appender>?
          log4net?的學習暫時告一段落了,希望能夠進一步對log4j學習,現(xiàn)在我越來越喜歡.net的東西了,再也不會感覺到很別扭!希望自己可以很快地強大起來!!!?

          posted @ 2006-03-29 18:22 Wei.Lee 閱讀(1287) | 評論 (0)編輯 收藏

          主站蜘蛛池模板: 凌源市| 双峰县| 新田县| 思南县| 青州市| 盐池县| 龙里县| 河津市| 肇庆市| 八宿县| 攀枝花市| 文化| 德保县| 遂平县| 罗甸县| 渝北区| 陕西省| 布尔津县| 碌曲县| 双峰县| 甘南县| 滦南县| 六枝特区| 锦屏县| 彰武县| 岳普湖县| 汶上县| 利辛县| 留坝县| 柳河县| 水城县| 芷江| 高要市| 沙湾县| 正定县| 金寨县| 肥城市| 东源县| 双峰县| 东安县| 邵阳县|