jConnect, Sybase SQL Server, Servlets

[Manfred Specht]

What is wrong in here? Need some help.

code:
...
try {

// JDBC-Treiber laden
Class.forName("com.sybase.jdbc.SybDriver");

// Datenbank öffnen
Connection con = null;
String m_proxy = "PSYCHE:8000";
Properties db_connect = new Properties();
db_connect.put("user", "gast");
db_connect.put("password", "rtl");
db_connect.put("proxy", m_proxy);
con =
DriverManager.getConnection("com:sybase:tds:psyche:3024",db_connect);

// Statement erzeugen
Statement stmt = con.createStatement();

// Anfang: SQL-Anweisung
String sql = "SELECT *" +
"FROM pubtune1..authors";
// Ende: SQL-Anweisung

// Statement setzen
ResultSet rs = stmt.executeQuery(sql);

// Anfang: Ergebnistabelle
ResultSetMetaData rsmd = rs.getMetaData();
int columns = rsmd.getColumnCount();
...

result:

No suitable driver
java.sql.SQLException: No suitable driver
at java.sql.DriverManager.getConnection(Compiled Code)
at java.sql.DriverManager.getConnection(DriverManager.java:106)
at Db1Servlet.doGet(Compiled Code)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:499)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:588)
at
sun.servlet.http.HttpServerHandler.sendResponse(HttpServerHandler.java:165)

at sun.servlet.http.HttpServerHandler.handleConnection(Compiled
Code)
at sun.servlet.http.HttpServerHandler.run(Compiled Code)
at java.lang.Thread.run(Thread.java:479)

Thanx for your help.

[Brian McGiverin]

Manfred Specht wrote:
>
> What is wrong in here? Need some help.
>
> code:
> ...

> con =
> DriverManager.getConnection("com:sybase:tds:psyche:3024",db_connect);

The above line should be:
con =
DriverManager.getConnection("jdbc:sybase:tds:psyche:3024",db_connect);

jConnect fails to recognize the "com" protocol, and fails.

- Brian