I am having trouble using the microsoft jdbc driver for sqlserver to connect to the datasource.
The configuration is as follows:
JDBC Provider:
Implementation class:
com.microsoft.sqlserver.SQLServerDataSource
Classpath:
/opt/msSQLjdbc-new/lib/mssqlserver.jar:/opt/msSQLjdbc-new/lib/msutil.jar:/opt/msSQLjdbc-new/lib/msbase.jar:/opt/WebSphere/AppServer/lib/j2ee.jar
(the jar file mssqlserver.jar contains the SQLServerDataSource.class file)
The DataSource is configured as follows:
JNDI Name: jdbc/DatabaseName
UserID: someuser
Password: somepassword
Custom Properties:
serverName: myserver
portNumber: 1433
databaseName: ICPC
When I try to access the datasource in a jsp file through the lines
javax.sql.DataSource ds = (javax.sql.DataSource)ctx.lookup("jdbc/DatabaseName"); java.sql.Connection conn = ds.getConnection();
ds.getConnection() returns a null even though 'ds' has the correct properties(Data source ds is: WebSphere DataSource:CMProperties for DataSource "jdbc/DatabaseName" Using underlying DataSource class: com.microsoft.sqlserver.SQLServerDataSource
Data Source Properties: {serverName=myserver, portNumber=1433, databaseName=DatabaseName}
Connection Pool Properties: user = someuser
minConnectionPoolSize = 1
maxConnectionPoolSize = 10 connTimeout = 180 idleTimeout = 1800
orphanTimeout = 1800
maxStatementCacheSize = 100 autoConnectionCleanupDisabled= false errorMap = null informixLockModeWait = 0)
The error statement is as follows:
Unrecognized database or driver com.microsoft.sqlserver.SQLServerDataSource; using generic settings
Source: com.ibm.ejs.cm.portability.PortabilityLayerFactory
Could not find the property PortNumber on class com.microsoft.jdbcx.sqlserver.SQLServerDataSource
Source: com.ibm.ejs.cm.portability.PortabilityLayerImpl
1. Please let me know if I have missed any of the JDBC configuration steps.
2. "I am able to obtain connection to the database when i used the com.microsoft.jdbc.sqlserver.SQLServerDriver class " using DriverManager.getConnection(..URL..)
3. Which other jdbc drivers for SQL server 2000 with connection pooling are available freely.
4. I got a TCP/IP errror; connection reset by peer when i used the merant sequelink jdbc driver provided with WAS4.0
Thanks,
Rajesh
