You are viewing a plain text version of this content. The canonical link for it is here.
Posted to users@tomcat.apache.org by "Wong, Connie" <co...@lmco.com> on 2001/03/02 19:37:44 UTC
Sybase (ASA7.0.2) connection question
Hi,
I have trouble using the URL on Sybase. I hope someone can help me.
Configurations:
NT
Sybase ASA7.0.2
Tomcat 3.1
DriverName = "com.sybase.jdbc2.jdbc.SybDriver"
The following files are in my CLASSPATH:
c:\Program Files\Sybase\SQL Anywhere 7\jConnect\classes
c:\Program Files\Sybase\SQL Anywhere 7\java\jdbcdrv.zip
c:\Program Files\Sybase\Shared\jConnect-5_2\classes\jconn2.jar
Scenarios:
Case 1. Set URL = "jdbc:sybase:Tds:localhost:2638"
I got the IOException error:
java.sql.SQLException: JZ006: Caught IOException: java.net.ConnectException:
Connection refused: no further information at
com.sybase.jdbc2.jdbc.ErrorMessage.raiseError(ErrorMessage.java:423) at
com.sybase.jdbc2.tds.Tds.handleIOE(Tds.java:2780) at
com.sybase.jdbc2.tds.Tds.login(Tds.java:338) at
com.sybase.jdbc2.jdbc.SybConnection.tryLogin(SybConnection.java:213) at
com.sybase.jdbc2.jdbc.SybConnection.regularConnect(SybConnection.java:190)
at com.sybase.jdbc2.jdbc.SybConnection.(SybConnection.java:169) at
com.sybase.jdbc2.jdbc.SybConnection.(SybConnection.java:122) at
com.sybase.jdbc2.jdbc.SybDriver.connect(SybDriver.java:175) at
java.sql.DriverManager.getConnection(DriverManager.java:517) at
java.sql.DriverManager.getConnection(DriverManager.java:146) at
Benchmark_sybase.query(Benchmark_sybase.java:94) at
Benchmark_sybase.doGet(Benchmark_sybase.java:48) at
javax.servlet.http.HttpServlet.service(HttpServlet.java:740) at
javax.servlet.http.HttpServlet.service(HttpServlet.java:853) at
org.apache.tomcat.core.ServletWrapper.handleRequest(ServletWrapper.java:503)
at
org.apache.tomcat.core.ServletWrapper.handleRequest(ServletWrapper.java:597)
at
org.apache.tomcat.servlets.InvokerServlet.service(InvokerServlet.java:257)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:853) at
org.apache.tomcat.core.ServletWrapper.handleRequest(ServletWrapper.java:503)
at org.apache.tomcat.core.ContextManager.service(ContextManager.java:559) at
org.apache.tomcat.service.http.HttpConnectionHandler.processConnection(HttpC
onnectionHandler.java:160) at
org.apache.tomcat.service.TcpConnectionThread.run(SimpleTcpEndpoint.java:338
) at java.lang.Thread.run(Thread.java:484)
Case 2: same URL (URL = "jdbc:sybase:Tds:localhost:2638"), I have to
connect the database from Sybase central in order for my program to run.
Case 3: set URL = "jdbc:sybase:asademo" -- I created my table in asademo
database.
I got the following Exception.:
java.sql.SQLException: JZ0D5: Error loading protocol
com.sybase.jdbc2.asademo.asademo. at
com.sybase.jdbc2.jdbc.ErrorMessage.raiseError(ErrorMessage.java:423) at
com.sybase.jdbc2.jdbc.ProtocolManager.getProtocol(ProtocolManager.java:102)
at com.sybase.jdbc2.jdbc.SybUrlManager.loadProtocol(SybUrlManager.java:191)
at com.sybase.jdbc2.jdbc.SybUrlManager.init(SybUrlManager.java:133) at
com.sybase.jdbc2.jdbc.SybUrlManager.getUrlProvider(SybUrlManager.java:110)
at com.sybase.jdbc2.jdbc.SybDriver.connect(SybDriver.java:167) at
java.sql.DriverManager.getConnection(DriverManager.java:517) at
java.sql.DriverManager.getConnection(DriverManager.java:146) at
Benchmark_sybase.query(Benchmark_sybase.java:99) at
Benchmark_sybase.doGet(Benchmark_sybase.java:53) at
javax.servlet.http.HttpServlet.service(HttpServlet.java:740) at
javax.servlet.http.HttpServlet.service(HttpServlet.java:853) at
org.apache.tomcat.core.ServletWrapper.handleRequest(ServletWrapper.java:503)
at
org.apache.tomcat.core.ServletWrapper.handleRequest(ServletWrapper.java:597)
at
org.apache.tomcat.servlets.InvokerServlet.service(InvokerServlet.java:257)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:853) at
org.apache.tomcat.core.ServletWrapper.handleRequest(ServletWrapper.java:503)
at org.apache.tomcat.core.ContextManager.service(ContextManager.java:559) at
org.apache.tomcat.service.http.HttpConnectionHandler.processConnection(HttpC
onnectionHandler.java:160) at
org.apache.tomcat.service.TcpConnectionThread.run(SimpleTcpEndpoint.java:338
) at java.lang.Thread.run(Thread.java:484)
Thanks,
Connie
Re: Sybase (ASA7.0.2) connection question
Posted by anonymous <an...@jquint.com>.
I don't know if this helps, since I use ASE on Linux not ASA on NT but here
goes:
import com.sybase.jdbcx.*;
// ....
public String sServer = "198.151.254.121:1433";
// ...
public String url = "jdbc:sybase:Tds:"; // + sServer
The only real difference I can see between my code and your code is you're
using "localhost" whereas I supply a real IP address. The only other
suggestion is check the port # that ASA is listening on. I've usually only
seen tcp endpoint errors when a client app is unable to establish a
connection on with a server app because of socket# or ip addr issues. I've
used this code for ASE & web server running on one machine and ASE & web
server on separate machines.
----- Original Message -----
From: "Wong, Connie" <co...@lmco.com>
To: <to...@jakarta.apache.org>
Sent: Friday, March 02, 2001 10:37 AM
Subject: Sybase (ASA7.0.2) connection question
> Hi,
>
> I have trouble using the URL on Sybase. I hope someone can help me.
>
> Configurations:
>
> NT
> Sybase ASA7.0.2
> Tomcat 3.1
> DriverName = "com.sybase.jdbc2.jdbc.SybDriver"
>
> The following files are in my CLASSPATH:
> c:\Program Files\Sybase\SQL Anywhere 7\jConnect\classes
> c:\Program Files\Sybase\SQL Anywhere 7\java\jdbcdrv.zip
> c:\Program Files\Sybase\Shared\jConnect-5_2\classes\jconn2.jar
>
>
> Scenarios:
>
> Case 1. Set URL = "jdbc:sybase:Tds:localhost:2638"
>
> I got the IOException error:
>
> java.sql.SQLException: JZ006: Caught IOException:
java.net.ConnectException:
> Connection refused: no further information at
> com.sybase.jdbc2.jdbc.ErrorMessage.raiseError(ErrorMessage.java:423) at
> com.sybase.jdbc2.tds.Tds.handleIOE(Tds.java:2780) at
> com.sybase.jdbc2.tds.Tds.login(Tds.java:338) at
> com.sybase.jdbc2.jdbc.SybConnection.tryLogin(SybConnection.java:213) at
> com.sybase.jdbc2.jdbc.SybConnection.regularConnect(SybConnection.java:190)
> at com.sybase.jdbc2.jdbc.SybConnection.(SybConnection.java:169) at
> com.sybase.jdbc2.jdbc.SybConnection.(SybConnection.java:122) at
> com.sybase.jdbc2.jdbc.SybDriver.connect(SybDriver.java:175) at
> java.sql.DriverManager.getConnection(DriverManager.java:517) at
> java.sql.DriverManager.getConnection(DriverManager.java:146) at
> Benchmark_sybase.query(Benchmark_sybase.java:94) at
> Benchmark_sybase.doGet(Benchmark_sybase.java:48) at
> javax.servlet.http.HttpServlet.service(HttpServlet.java:740) at
> javax.servlet.http.HttpServlet.service(HttpServlet.java:853) at
>
org.apache.tomcat.core.ServletWrapper.handleRequest(ServletWrapper.java:503)
> at
>
org.apache.tomcat.core.ServletWrapper.handleRequest(ServletWrapper.java:597)
> at
> org.apache.tomcat.servlets.InvokerServlet.service(InvokerServlet.java:257)
> at javax.servlet.http.HttpServlet.service(HttpServlet.java:853) at
>
org.apache.tomcat.core.ServletWrapper.handleRequest(ServletWrapper.java:503)
> at org.apache.tomcat.core.ContextManager.service(ContextManager.java:559)
at
>
org.apache.tomcat.service.http.HttpConnectionHandler.processConnection(HttpC
> onnectionHandler.java:160) at
>
org.apache.tomcat.service.TcpConnectionThread.run(SimpleTcpEndpoint.java:338
> ) at java.lang.Thread.run(Thread.java:484)
>
>
>
> Case 2: same URL (URL = "jdbc:sybase:Tds:localhost:2638"), I have to
> connect the database from Sybase central in order for my program to run.
>
>
> Case 3: set URL = "jdbc:sybase:asademo" -- I created my table in asademo
> database.
>
> I got the following Exception.:
>
> java.sql.SQLException: JZ0D5: Error loading protocol
> com.sybase.jdbc2.asademo.asademo. at
> com.sybase.jdbc2.jdbc.ErrorMessage.raiseError(ErrorMessage.java:423) at
>
com.sybase.jdbc2.jdbc.ProtocolManager.getProtocol(ProtocolManager.java:102)
> at
com.sybase.jdbc2.jdbc.SybUrlManager.loadProtocol(SybUrlManager.java:191)
> at com.sybase.jdbc2.jdbc.SybUrlManager.init(SybUrlManager.java:133) at
> com.sybase.jdbc2.jdbc.SybUrlManager.getUrlProvider(SybUrlManager.java:110)
> at com.sybase.jdbc2.jdbc.SybDriver.connect(SybDriver.java:167) at
> java.sql.DriverManager.getConnection(DriverManager.java:517) at
> java.sql.DriverManager.getConnection(DriverManager.java:146) at
> Benchmark_sybase.query(Benchmark_sybase.java:99) at
> Benchmark_sybase.doGet(Benchmark_sybase.java:53) at
> javax.servlet.http.HttpServlet.service(HttpServlet.java:740) at
> javax.servlet.http.HttpServlet.service(HttpServlet.java:853) at
>
org.apache.tomcat.core.ServletWrapper.handleRequest(ServletWrapper.java:503)
> at
>
org.apache.tomcat.core.ServletWrapper.handleRequest(ServletWrapper.java:597)
> at
> org.apache.tomcat.servlets.InvokerServlet.service(InvokerServlet.java:257)
> at javax.servlet.http.HttpServlet.service(HttpServlet.java:853) at
>
org.apache.tomcat.core.ServletWrapper.handleRequest(ServletWrapper.java:503)
> at org.apache.tomcat.core.ContextManager.service(ContextManager.java:559)
at
>
org.apache.tomcat.service.http.HttpConnectionHandler.processConnection(HttpC
> onnectionHandler.java:160) at
>
org.apache.tomcat.service.TcpConnectionThread.run(SimpleTcpEndpoint.java:338
> ) at java.lang.Thread.run(Thread.java:484)
>
> Thanks,
> Connie
>
>
>
>
>
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: tomcat-user-unsubscribe@jakarta.apache.org
> For additional commands, email: tomcat-user-help@jakarta.apache.org
>