<data-sources>
<!--To Config Oracle -->
<data-source>
<set-property property="driverClass" value="oracle.jdbc.driver.OracleDriver"/>
<set-property property="description" value="OracleDB Connection"/>
<set-property property="url" value="jdbc:oracle:thin:@IP:1521:SID"/>
<set-property property="user" value="XXX" />
<set-property property="password" value="XXX"/>
<set-property property="autoCommit" value="false"/>
<set-property property="maxCount" value="5"/>
<set-property property="minCount" value="0"/>
<set-property property="loginTimeout" value="180"/>
</data-source>
<!--To Config Sqlserver(ver:Sql2000 if Sql2005,driverClass and url are different) -->
<data-source key="sqlDB">
<set-property property="driverClass" value="com.microsoft.jdbc.sqlserver.SQLServerDriver"/>
<set-property property="description" value="SqlServerDB Connection"/>
<set-property property="url" value="jdbc:microsoft:sqlserver://IP:1433;DatabaseName=XXXX"/>
<set-property property="user" value="XXX" />
<set-property property="password" value="XXX"/>
<set-property property="autoCommit" value="false"/>
<set-property property="maxCount" value="5"/>
<set-property property="minCount" value="0"/>
<set-property property="loginTimeout" value="180"/>
</data-source>
</data-sources>
Microsoft SQL Server 2005 JDBC Driver: sqljdbc.jar
Microsoft SQL Server 2000 JDBC Driver: msbase.jar mssqlserver.jar msutil.jar
2000时,需要以上3个JAR文件。2005时,只需一个JAR文件。而且配置2000和2005的data-sources时,
driverClass和url的格式是不同的。需要注意。
写连接代码时需要注意2000和2005的不同:
1、连接SqlServer2000
Class.forName("com.microsoft.jdbc.sqlserver.SQLServerDriver").newInstance();
URL = "jdbc:microsoft:sqlserver://localhost:1433;DatabaseName=tempdb";
2、连接SqlServer2005
Class.forName("com.microsoft.sqlserver.jdbc.SQLServerDriver").newInstance();
URL = "jdbc:sqlserver://localhost:1433;DatabaseName=tempdb";