Help appriciated. SQLServer 2000 JDBC exception.

[vishwanath nadimpally]

I would really appriciate if someone can help me fix my problem. I have 2 instances of Tomcat running. One is a Tomcat 5.5.12 and the others a 5.5.15.

I have a JDBC application which queries a SQLSERVER 2000 and writes the tables to an OracleDataSource. I have both the datasources in my
'\conf\Catalina\localhost\"webapp".xml file.The 5.5.15 instance runs fine and does the job but the Tomcat 5.5.12 throws an exception when I query the SQLSERVER.Part of the stack trace :

org.apache.tomcat.dbcp.dbcp.SQLNestedException: Cannot create PoolableConnectionFactory ([Microsoft][SQLServer 2000 Driver for JDB
C]Error establishing socket.)
at org.apache.tomcat.dbcp.dbcp.BasicDataSource.createDataSource(BasicDataSource.java:855)
at org.apache.tomcat.dbcp.dbcp.BasicDataSource.getConnection(BasicDataSource.java:540)
at com.oneok.db.connection.Tomcat55PoolConnectionImpl.getConnection(Tomcat55PoolConnectionImpl.java:33)
at com.oneok.db.DBFactory.getConnection(DBFactory.java:53)
at com.oneok.db.DBConnection.getConnection(DBConnection.java:127)
at com.oneok.db.DBConnection.getConnection(DBConnection.java:118)
at com.oneok.dbLoader.scripts.OngDailyScriptLoader.runSql(OngDailyScriptLoader.java:214)
at com.oneok.dbLoader.scripts.OngDailyScriptLoader.Run(OngDailyScriptLoader.java:474)
at com.oneok.dbLoader.scripts.OngDailyScriptLoader.run(OngDailyScriptLoader.java:495)
at org.apache.jsp.authorized.ongDailyReport_jsp._jspService(org.apache.jsp.authorized.ongDailyReport_jsp:196)
at org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:97)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:802)
at org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:322)
at org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:314)
at org.apache.jasper.servlet.JspServlet.service(JspServlet.java:264)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:802)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:252)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173)
at com.oneok.wmrs.security.AuthorizationFilter.doFilter(AuthorizationFilter.java:43)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:202)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173)
at com.oneok.security.AuthenticationFilter.login(AuthenticationFilter.java:190)
at com.oneok.security.AuthenticationFilter.doFilter(AuthenticationFilter.java:95)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:202)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173)
at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:213)
at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:178)
at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:126)
at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:105)
at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:107)
at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:148)
at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:868)
at org.apache.coyote.http11.Http11BaseProtocol$Http11ConnectionHandler.processConnection(Http11BaseProtocol.java:663)
at org.apache.tomcat.util.net.PoolTcpEndpoint.processSocket(PoolTcpEndpoint.java:527)
at org.apache.tomcat.util.net.LeaderFollowerWorkerThread.runIt(LeaderFollowerWorkerThread.java:80)
at org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:684)
at java.lang.Thread.run(Thread.java:595)
Caused by: java.sql.SQLException: [Microsoft][SQLServer 2000 Driver for JDBC]Error establishing socket.
at com.microsoft.jdbc.base.BaseExceptions.createException(Unknown Source)
at com.microsoft.jdbc.base.BaseExceptions.getException(Unknown Source)
at com.microsoft.jdbc.base.BaseExceptions.getException(Unknown Source)
at com.microsoft.jdbc.sqlserver.tds.TDSConnection.<init>(Unknown Source)
at com.microsoft.jdbc.sqlserver.SQLServerImplConnection.open(Unknown Source)
at com.microsoft.jdbc.base.BaseConnection.getNewImplConnection(Unknown Source)
at com.microsoft.jdbc.base.BaseConnection.open(Unknown Source)
at com.microsoft.jdbc.base.BaseDriver.connect(Unknown Source)
at org.apache.tomcat.dbcp.dbcp.DriverConnectionFactory.createConnection(DriverConnectionFactory.java:37)
at org.apache.tomcat.dbcp.dbcp.PoolableConnectionFactory.makeObject(PoolableConnectionFactory.java:290)
at org.apache.tomcat.dbcp.dbcp.BasicDataSource.validateConnectionFactory(BasicDataSource.java:877)
at org.apache.tomcat.dbcp.dbcp.BasicDataSource.createDataSource(BasicDataSource.java:851)
... 36 more
java.sql.SQLException: Unable to get the connection to jdbc/ONG_PGAS
at com.oneok.db.connection.Tomcat55PoolConnectionImpl.getConnection(Tomcat55PoolConnectionImpl.java:38)
at com.oneok.db.DBFactory.getConnection(DBFactory.java:53)
at com.oneok.db.DBConnection.getConnection(DBConnection.java:127)
at com.oneok.db.DBConnection.getConnection(DBConnection.java:118)
at com.oneok.dbLoader.scripts.OngDailyScriptLoader.runSql(OngDailyScriptLoader.java:214)
at com.oneok.dbLoader.scripts.OngDailyScriptLoader.Run(OngDailyScriptLoader.java:474)
at com.oneok.dbLoader.scripts.OngDailyScriptLoader.run(OngDailyScriptLoader.java:495)
at org.apache.jsp.authorized.ongDailyReport_jsp._jspService(org.apache.jsp.authorized.ongDailyReport_jsp:196)
at org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:97)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:802)
at org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:322)
at org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:314)
at org.apache.jasper.servlet.JspServlet.service(JspServlet.java:264)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:802)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:252)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173)
at com.oneok.wmrs.security.AuthorizationFilter.doFilter(AuthorizationFilter.java:43)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:202)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173)
at com.oneok.security.AuthenticationFilter.login(AuthenticationFilter.java:190)
at com.oneok.security.AuthenticationFilter.doFilter(AuthenticationFilter.java:95)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:202)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173)
at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:213)
at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:178)
at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:126)
at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:105)
at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:107)
at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:148)
at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:868)
at org.apache.coyote.http11.Http11BaseProtocol$Http11ConnectionHandler.processConnection(Http11BaseProtocol.java:663)
at org.apache.tomcat.util.net.PoolTcpEndpoint.processSocket(PoolTcpEndpoint.java:527)
at org.apache.tomcat.util.net.LeaderFollowerWorkerThread.runIt(LeaderFollowerWorkerThread.java:80)
at org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:684)
at java.lang.Thread.run(Thread.java:595)...

I have tried everything I could think of.. and I need help please.

I am not aware if someone already posted a similar question. If this is already posted, Please point me to the topic.

Thanks.
-Vishwanath

[vishwanath nadimpally]

I see no one's interested in helping a newbie.. That's OK..

I got the solution.. Its the JDBC URL.. I am using a fully qualified URL and it works now..

[Jeanne Boyarsky]

Vishwanath,
It's not that nobody is interested in helping - some problems are hard to derive from the error message. Thanks for posting the solution to help others who encounter the problem in the future.

And if nobody has already said this yet: Welcome to JavaRanch!

[vishwanath nadimpally]

Thanks.

[DeepakGupta Gupta]

hi vishwanath can you please provide some more information like what complete path you have used. I am facing the same problem. thanks in advance

cheers
deepak

[Gracio monnom]

I have the same problem. I just have to change the url of the datasource in the struts-config.xml, using localhost in the place of my computername.
instead of
<set-property property="url" value = "jdbc:microsoft:sqlserver://mypc_name:1433;databasename=alesi" />
i used
<set-property property="url" value = "jdbc:microsoft:sqlserver://localhost:1433;databasename=alesi" />

PS: see you errorlog file under Tomcat to get the right reason why the action could not be proced.