trouble getting a connection from MS SQL Server 2000 database server from WSAD

From: vdstmx (member45427_at_dbforums.com)
Date: 10/23/03

Next message: John Muñoz: "dxf Class reader database"
Previous message: John Muñoz: "Hi!"
Next in thread: Frederic Pepin: "Re: trouble getting a connection from MS SQL Server 2000 database server from WSAD"
Reply: Frederic Pepin: "Re: trouble getting a connection from MS SQL Server 2000 database server from WSAD"
Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]

Date: Thu, 23 Oct 2003 11:07:15 -0400

Hi ,

I have java servlet that creates a connection from connection pool .

and I am getting the following errror.I am working on WSAD 4.x.

I am using Microsoft SQL Server 2000 JDBC Driver Implementation class:
com.microsoft.jdbcx.sqlserver.SQLServerDataSource and

provided all the required jar files located at. C:\Program
Files\Microsoft SQL Server 2000 Driver for JDBC\lib.also i have given
the resoure properties.

WebSphere DataSource:CMProperties for DataSource "MSSQLServerConDev"

  DataSource Properties
  [com.microsoft.jdbcx.sqlserver.SQLServerDataSource]: {user=sa;passwor-
  d=XXXXXXXX;selectMethod=cursor;portNumber=1433;databaseName=FREDTest;-
  serverName=JADE;}

Connection Pool Properties:

dataBaseVersion = 0

minConnectionPoolSize = 1

maxConnectionPoolSize = 10

connTimeout = 180

idleTimeout = 1800

orphanTimeout = 1800

.......................................

[10/23/03 9:40:10:058 CDT] 6e899fa1 SystemOut U SQL exception

java.sql.SQLException: [Microsoft][SQLServer 2000 Driver for JDBC]

[SQLServer]Login failed for user 'sa'.

at com.microsoft.jdbc.base.BaseExceptions.createException(Unk-
nown Source)

at com.microsoft.jdbc.base.BaseExceptions.getException(Unk-
nown Source)

at com.microsoft.jdbc.sqlserver.tds.TDSRequest.processErrorToke-
n(Unknown Source)

at com.microsoft.jdbc.sqlserver.tds.TDSRequest.processReplyToke-
n(Unknown Source)

at com.microsoft.jdbc.sqlserver.tds.TDSLoginRequest.processRepl-
yToken(Unknown Source)

at com.microsoft.jdbc.sqlserver.tds.TDSRequest.processReply(Unk-
nown Source)

at com.microsoft.jdbc.sqlserver.SQLServerImplConnection.open(Un-
known Source)

at com.microsoft.jdbc.base.BaseConnection.getNewImplConnection(-
Unknown Source)

at com.microsoft.jdbc.base.BaseConnection.open(Unknown Source)

at com.microsoft.jdbcx.base.BaseDataSource.getBaseConnection(Un-
known Source)

at com.microsoft.jdbcx.base.BaseDataSource.getConnection(Unk-
nown Source)

at com.ibm.ejs.cm.portability.PortabilityLayerImpl.getInstance(-
PortabilityLayerImpl.java:964)

at com.ibm.ejs.cm.portability.PortabilityLayerFactory.getPortab-
ilityLayer(PortabilityLayerFactory.java:90)

at com.ibm.ejs.cm.JDBC1PhaseRF.createConnectionFactory(JDBC1Pha-
seRF.java:57)

at com.ibm.ejs.cm.DataSourceImpl$3.run(DataSourceImpl.java:219)

at java.security.AccessController.doPrivileged(Native Method)

at com.ibm.ejs.cm.DataSourceImpl.getSource(DataSourceImpl-
.java:217)

at com.ibm.ejs.cm.DataSourceImpl$1.run(DataSourceImpl.java:135)

at java.security.AccessController.doPrivileged(Native Method)

at com.ibm.ejs.cm.DataSourceImpl.getConnection(DataSourceImpl-
.java:133)

at com.ibm.ejs.cm.DataSourceImpl.getConnection(DataSourceImpl-
.java:102)

at com.mmm.jdbc.JavaDatabaseTestServlet.doGet(JavaDatabaseTestS-
ervlet.java:62)

at javax.servlet.http.HttpServlet.service(HttpServlet.java:740)

at javax.servlet.http.HttpServlet.service(HttpServlet.java:853)

at com.ibm.servlet.engine.webapp.StrictServletInstance.doServic-
e(ServletManager.java:827)

at com.ibm.servlet.engine.webapp.StrictLifecycleServlet._servic-
e(StrictLifecycleServlet.java:167)

at com.ibm.servlet.engine.webapp.IdleServletState.service(Stric-
tLifecycleServlet.java:297)

at com.ibm.servlet.engine.webapp.StrictLifecycleServlet.service-
(StrictLifecycleServlet.java:110)

at com.ibm.servlet.engine.webapp.ServletInstance.service(Servle-
tManager.java:472)

at com.ibm.servlet.engine.webapp.ValidServletReferenceState.dis-
patch(ServletManager.java:1012)

at com.ibm.servlet.engine.webapp.ServletInstanceReference.dispa-
tch(ServletManager.java:913)

at com.ibm.servlet.engine.webapp.WebAppRequestDispatcher.handle-
WebAppDispatch(WebAppRequestDispatcher.java:721)

at com.ibm.servlet.engine.webapp.WebAppRequestDispatcher.dispat-
ch(WebAppRequestDispatcher.java:374)

at com.ibm.servlet.engine.webapp.WebAppRequestDispatcher.forwar-
d(WebAppRequestDispatcher.java:118)

at com.ibm.servlet.engine.srt.WebAppInvoker.doForward(WebAppInv-
oker.java:134)

at com.ibm.servlet.engine.srt.WebAppInvoker.handleInvocationHoo-
k(WebAppInvoker.java:239)

at com.ibm.servlet.engine.invocation.CachedInvocation.handleInv-
ocation(CachedInvocation.java:67)

at com.ibm.servlet.engine.invocation.CacheableInvocationContext-
.invoke(CacheableInvocationContext.java:106)

at com.ibm.servlet.engine.srp.ServletRequestProcessor.dispatchB-
yURI(ServletRequestProcessor.java:154)

at com.ibm.servlet.engine.oselistener.OSEListenerDispatcher.ser-
vice(OSEListener.java:317)

at com.ibm.servlet.engine.http11.HttpConnection.handleRequest(H-
ttpConnection.java:60)

at com.ibm.ws.http.HttpConnection.readAndHandleRequest(HttpConn-
ection.java:391)

at com.ibm.ws.http.HttpConnection.run(HttpConnection.java:274)

at com.ibm.ws.util.CachedThread.run(ThreadPool.java:144)

java.lang.NumberFormatException: null

at java.lang.Integer.parseInt(Integer.java(Compiled Code))

at java.lang.Integer.<init>(Integer.java:558)

at com.mmm.jdbc.JavaDatabaseTestServlet.doGet(JavaDatabaseTestS-
ervlet.java:72)