Problem with connecting with Postgresql using JDBC
От | jo raj |
---|---|
Тема | Problem with connecting with Postgresql using JDBC |
Дата | |
Msg-id | 20040218122943.44260.qmail@web8303.mail.in.yahoo.com обсуждение исходный текст |
Ответы |
Re: Problem with connecting with Postgresql using JDBC
|
Список | pgsql-jdbc |
Hai everybody, I am a newbie to PostgreSQL and I am a student doing a project based on Postgresql for my completion of my studies. I can't get to my carefully set-up database through java with a program. I think I've hit most of the required set-up points. I've got all the postgresql packages installed (checked with rpm -qa | grep -i postgres; they're there, including the jdbc one). I set tcpip_socket = true in /var/lib/pgsql/data/postgresql.conf. I also updated /etc/rc.d/init.d/. When executing the "pg_ctl -D /var/lib/pgsql/data status" the output was pg_ctl: postmaster is running (pid: 7245) Command line was: /usr/bin/postmaster '-p' '5432' I have the right driver in the classpath (I passed in export CLASSPATH=$CLASSPATH:/usr/share/pgsql/pg73b1jdbc3.jar when compiling and running). I added the lines "host all 127.0.0.1 255.255.255.255 trust" /var/lib/pgsql/data/pg_hba.conf I created a new database, "skylab" I added the user "root" with the password "redhat" to the database, and verified by logging into psql with -U xxx (had pg_hba.conf set to password so was challenged and succeeded) With all of this, my java program has these lines: import java.sql.*; public class jdbc{ public static void main(String args[]){ String url = "jdbc:postgresql://redhat:5432/skylab"; Connection con=null; //String tab = " " ; Statement stmt ; String query1 = "select * from netprint" ; try { //here we load jdbc driver Class.forName("org.postgresql.Driver"); } catch(java.lang.ClassNotFoundException e) { System.out.println("ClassNotFoundException: " + e.getMessage()); } System.out.println("Got class.forName"); try { //here iam connecting to my database System.out.println("Trying for connection A" ); DriverManager.setLogStream(System.out); System.out.println("Trying for connection B" ); con = DriverManager.getConnection(url, "root", "redhat"); System.out.println("Didn't fault on connection."); stmt = con.createStatement() ; ResultSet rs ; stmt.executeUpdate("insert into netprint values('bosc' ,'redhat1','lp2','10.21.31.21','2004/02/09','16:00:05' )"); rs = stmt.executeQuery(query1) ; con.close(); } catch (SQLException ex) { System.err.println("SQLException: " + ex.getMessage()) ; ex.printStackTrace(); } } I get the error Got class.forName Trying for connection A Trying for connection B SQLException: Driver not found for URL: jdbc:postgresql://redhat:5432/skylab java.sql.SQLException: Driver not found for URL: jdbc:postgresql://redhat:5432/skylab at 0x40268e17: java.lang.Throwable.Throwable(java.lang.String) (/usr/lib/./libgcj.so.3) at 0x4025bcd2: java.lang.Exception.Exception(java.lang.String) (/usr/lib/./libgcj.so.3) at 0x402fce64: java.sql.SQLException.SQLException(java.lang.String, java.lang.String, int) (/usr/lib/./libgcj.so.3) at 0x402fce14: java.sql.SQLException.SQLException(java.lang.String) (/usr/lib/./libgcj.so.3) at 0x402fccd2: java.sql.DriverManager.getConnection(java.lang.String, java.util.Properties) (/usr/lib/./libgcj.so.3) at 0x402fcc0e: java.sql.DriverManager.getConnection(java.lang.String, java.lang.String, java.lang.String) (/usr/lib/./libgcj.so.3) at 0x403831e7: ffi_call_SYSV (/usr/lib/./libgcj.so.3) at 0x403831a7: ffi_raw_call (/usr/lib/./libgcj.so.3) at 0x402306e8: _Jv_InterpMethod.continue1(_Jv_InterpMethodInvocation) (/usr/lib/./libgcj.so.3) at 0x40230ff4: _Jv_InterpMethod.run(ffi_cif, void, ffi_raw, _Jv_InterpMethodInvocation) (/usr/lib/./libgcj.so.3) at 0x4022e504: _Jv_InterpMethod.run_normal(ffi_cif, void, ffi_raw, void) (/usr/lib/./libgcj.so.3) at 0x4038305c: ?? (??:0) at 0x40242dd8: gnu.gcj.runtime.FirstThread.call_main() (/usr/lib/./libgcj.so.3) at 0x402ad02d: gnu.gcj.runtime.FirstThread.run() (/usr/lib/./libgcj.so.3) at 0x4024fc4c: _Jv_ThreadRun(java.lang.Thread) (/usr/lib/./libgcj.so.3) at 0x4021c8ac: _Jv_RunMain(java.lang.Class, byte const, int, byte const, boolean) (/usr/lib/./libgcj.so.3) at 0x08048910: ?? (??:0) at 0x42015574: __libc_start_main (/lib/tls/libc.so.6) at 0x080486c1: ?? (??:0) (Note it's finding the driver with the forName() method call).I've tried using jdbc:postgresql://redhat:5432/skylab.Any suggestion you have would be extremely useful for my completion of the project. ===== Bye from JOE ________________________________________________________________________ Yahoo! India Insurance Special: Be informed on the best policies, services, tools and more. Go to: http://in.insurance.yahoo.com/licspecial/index.html
В списке pgsql-jdbc по дате отправления: