How to mount a Sybase database using Java code in NetBeans?

Question

I want to connect remote Sybase from my Java code written in NetBeans . So far I have prepared the code as shown below:

 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); } } 

and I got the error:

 java.lang.ClassNotFoundException: com.sybase.jdbc3.jdbc.SybDriver 

I downloaded the jconn3.jar library.

Answer 1

Install Sybase drivers through a Java application.

Sybase: installing jConnect for JDBC