[求助]JAVA连Sybase数据库报这个错，帮忙看看

hunter_z · 2006-8-27 23:22:17

马上注册，结交更多好友，享用更多功能，让你轻松玩转社区。

您需要登录才可以下载或查看，没有账号？站点注册

×

import java.sql.*;public class SampleCode {  public static void main(String args[]) {   try {    /*     * Open the connection. May throw a SQLException.     */    DriverManager.registerDriver((Driver) Class.forName(      "com.sybase.jdbc3.jdbc.SybDriver").newInstance());    Connection con = DriverManager.getConnection(      "jdbc:sybase:Tds:STUDIO:5000", "sa", "11111111");    /*     * Create a statement object, the container for the SQL statement.     * May throw a SQLException.     */    Statement stmt = con.createStatement();    /*     * Create a result set object by executing the query. May throw a     * SQLException.     */    ResultSet rs = stmt.executeQuery("Select * from client");    /*     * Process the result set.     */    if (rs.next()) {     //int value = rs.getInt(1);     String name = rs.getString("user_name");     System.out.println("user_name " + name);     //System.out.println("Fetched value " + value);    }    rs.close();    stmt.close();    con.close();   }// end try   /*    * Exception handling.    */  catch (SQLException sqe) {    System.out.println("Unexpected exception : " + sqe.toString()      + ", sqlstate = " + sqe.getSQLState());    System.exit(1);   }// end catch????   catch (Exception e) {    e.printStackTrace();    System.exit(1);   }// end catch   System.exit(0);  } }

复制代码

报这个错，怎么处理呢？连了这么多种数据库，只有这一个没连上的！

Unexpected exception : com.sybase.jdbc3.jdbc.SybSQLException: client not found. Specify owner.objectname or use sp_help to check whether the object exists (sp_help may produce lots of output).
, sqlstate = 42000

hunter_z · 2006-8-27 23:23:32

Connection con = DriverManager.getConnection(
"jdbc:sybase:Tds:localhost:5000", "sa", "11111111");

改成这样又出这个错

Unexpected exception : java.sql.SQLException: JZ006: 捕获到 IO 例外:java.net.ConnectException: Connection refused: connect, sqlstate = JZ006

flybean · 2006-8-28 17:27:04

Unexpected exception : com.sybase.jdbc3.jdbc.SybSQLException: client not found. Specify owner.objectname or use sp_help to check whether the object exists (sp_help may produce lots of output).
, sqlstate = 42000

翻译成中文,大意是:client这个对象（表或视图）不存在，希望楼上提问前先查查字典，懒一点的话，用金山词霸也可以．

账号		站点注册	自动登录	找回密码
密码			站点注册