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)
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)
[10/23/03 9:40:10:214 CDT] 6e899fa1 SecurityManag X SECJ0135A: Illegal
System.exit() attempted
[10/23/03 9:40:10:245 CDT] 6e899fa1 SecurityManag A SECJ0135A: Illegal
System.exit() attempted
[10/23/03 9:40:10:261 CDT] 6e899fa1 WebGroup X Servlet Error: :
java.lang.SecurityException
at com.ibm.ejs.security.SecurityManager.checkExit(SecurityManag-
er.java:123)
at java.lang.Runtime.exit(Runtime.java:119)
at java.lang.System.exit(System.java:746)
at com.mmm.jdbc.JavaDatabaseTestServlet.doGet(JavaDatabaseTestS-
ervlet.java:103)
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)
pl help
Thanks.
--
Posted via http://dbforums.com
Frederic
"vdstmx" <membe...@dbforums.com> wrote in message
news:3515425.1...@dbforums.com...