| Author |
sqlserver datasource configuration
|
Rajesh Balla
Greenhorn
Joined: Feb 21, 2002
Posts: 3
|
|
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
|
 |
Guy Barden
Greenhorn
Joined: Jan 09, 2003
Posts: 5
|
|
Hi, I looked at your query hoping to find the solution to mine. I believe your problem is a simple typo. You are specifying the DataSource class as com.microsoft.sqlserver.SQLServerDataSource when it should be com.microsoft.jdbcx.sqlserver.SQLServerDataSource. Regards Guy [ January 09, 2003: Message edited by: Guy Barden ]
|
 |
Tony Ngo
Greenhorn
Joined: Nov 14, 2003
Posts: 1
|
|
Hi Guy, I am having the toughest time to register MS SQL Server DB with JNDI. Would you please show me the best way of doing this? Thanks
|
 |
Laura Mike
Greenhorn
Joined: Nov 13, 2003
Posts: 17
|
|
|
Me too have the sameproblem anyone there to help me?
|
 |
 |
|
|
subject: sqlserver datasource configuration
|
|
|