This week's book giveaway is in the General Computing forum.
We're giving away four copies of Arduino in Action and have Martin Evans, Joshua Noble, and Jordan Hochenbaum on-line!
See this thread for details.
The moose likes JDBC and the fly likes Help appriciated. SQLServer 2000 JDBC exception. Big Moose Saloon
  Search | Java FAQ | Recent Topics
Register / Login


Win a copy of Arduino in Action this week in the General Computing forum!

A special promo: Enter your blog post or vote on a blogger to be featured in an upcoming Journal
JavaRanch » Java Forums » Databases » JDBC
Reply Bookmark "Help appriciated. SQLServer 2000 JDBC exception." Watch "Help appriciated. SQLServer 2000 JDBC exception." New topic
Author

Help appriciated. SQLServer 2000 JDBC exception.

vishwanath nadimpally
Ranch Hand

Joined: Jan 25, 2005
Posts: 116
posted private message
0
Quote
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
Ranch Hand

Joined: Jan 25, 2005
Posts: 116
posted private message
0
Quote
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
internet detective
Marshal

Joined: May 26, 2003
Posts: 26499
    
  78

I like...
Eclipse IDE Java VI Editor
posted private message
0
Quote
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!

[Blog] [JavaRanch FAQ] [How To Ask Questions The Smart Way] [Book Promos]
Blogging on Certs: SCEA Part 1, Part 2 & 3, Core Spring 3, OCAJP, OCPJP beta, TOGAF part 1 and part 2
vishwanath nadimpally
Ranch Hand

Joined: Jan 25, 2005
Posts: 116
posted private message
0
Quote
Thanks.
DeepakGupta Gupta
Greenhorn

Joined: May 17, 2006
Posts: 2
posted private message
0
Quote
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
Greenhorn

Joined: Jul 27, 2006
Posts: 1
posted private message
0
Quote
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.

write to odjo.fak@gmx.ch
 
I agree. Here's the link: http://zeroturnaround.com/jrebel - it saves me about five hours per week
 
subject: Help appriciated. SQLServer 2000 JDBC exception.
 
Similar Threads
jdbc + max(field)
Cannot create JDBC driver of class '' for connect URL 'null'
Trouble connecting to JDBC
max(field)
Resource element in Tomcat 5.5 -- help needed