Hello, I am a new user using the Postgre-sql for the first time please help me in establishing the connection between JDBC and POSTGRE. POSTGRE >> 7.2.1JAVA >> 1.4.1_01LINUX >> 7.3 Having the CLASSPATH::/usr/share/pgsql/jdbc7.2dev-1.2.jar:/usr/lib/pgsql/pg72jdbc2.jar:/usr/java/j2sdk1.4.1_01/lib/*.jar I got ERROR asSub : java.lang.ClassNotFoundException: org.postgresql:DriverRohit : java.sql.SQLException: No suitable driver Here is my CODE "JDBC_POSTGRE.java"import java.sql.*; class JDBC_POSTGRE { public static void main(String args[]) { Statement stmt1; ResultSet rs1; DatabaseMetaData dbmd1; try { try { Class.forName("org.postgresql.Driver"); //Driver for POSTGRE-SQL :pg72jdbc2.jar } catch(Exception ex) { System.out.println("Sub : " + ex); } Connection conn1 = DriverManager.getConnection("jdbc:postgresql:AirTel_RTL", "", ""); //AirTel_RTL is a database, user='', password='' stmt1 = conn1.createStatement(); rs1 = stmt1.executeQuery("Select * from tonedata"); // 'tonedata' is a table in database while(rs1.next()) { System.out.println(rs1.getInt("toneid") + "," + rs1.getString("tone_name") ); } } catch(Exception e) { System.out.println("Rohit : "+e); } } } I am not professional in Linux.Hoping you will replay me very soon. With regards,Rohit
-- Scot P. Floess - 27 Lake Royale - Louisburg, NC 27549 - 252-478-8087 Open Source Home Page -------------------------------------- http://javapim.sourceforge.net http://jplate.sourceforge.net http://jwaretechniques.sourceforge.net Open Source Project Host ----------------------------------------------- http://sourceforge.net/projects/javapim http://sourceforge.net/projects/jplate http://sourceforge.net/projects/jwaretechniques
pgsql-jdbc by date:
Соглашаюсь с условиями обработки персональных данных