title: How to connect Sybase database using Java code in NetBeans?
body: <p>I want to connect remote <code>Sybase</code> from my <code>Java</code> code written in <code>NetBeans</code>. So far I have prepared a code as below:</p>
  
  <pre><code>public static void connect()
  {
     String host = "192.168.150.11";
     String url = "jdbc:sybase:Tds:"+host+":4100";
     String username = "sa";
     String password ="";
     SybDriver sybDriver = null;
     Connection conn;
  
     try 
     {
        sybDriver=(SybDriver)Class.forName("com.sybase.jdbc3.jdbc.SybDriver").newInstance();
        System.out.println("Driver Loaded");
        conn = DriverManager.getConnection(url,username,password);
        Statement stmt = conn.createStatement();
        ResultSet rs = stmt.executeQuery("select * from zxdbl_888..account_0");
        rs.next();
        System.out.println(rs.getString(2));
  
     } 
     catch (InstantiationException ex) 
     {
        Logger.getLogger(Offline_charge.class.getName()).log(Level.SEVERE, null, ex);
     } 
     catch (IllegalAccessException ex) 
     {
        Logger.getLogger(Offline_charge.class.getName()).log(Level.SEVERE, null, ex);
     } 
     catch (ClassNotFoundException ex) 
     {
        Logger.getLogger(Offline_charge.class.getName()).log(Level.SEVERE, null, ex);
     } 
     catch (SQLException ex) 
     {
        Logger.getLogger(Offline_charge.class.getName()).log(Level.SEVERE, null, ex);
     }
  }
  </code></pre>
  
  <p>and the error I got is:</p>
  
  <pre><code>java.lang.ClassNotFoundException: com.sybase.jdbc3.jdbc.SybDriver
  </code></pre>
  
  <p>I have loaded <code>jconn3.jar</code> library.</p>