Can any one tell me what must be the driver name, Url,pwd for postgresql and java connectivity in linux.
The driver:sun.jdbc.odbc.JdbcOdbcDriver is working but the error is as follows for the statement
line 27: Connection con=Driver.getConnection("jdbcostgresql:testdb","postgresql","postgresql");

[root@localhost Java]# javac dbtest.java
[root@localhost Java]# java dbtest
Loading driver
Driver Loaded
Getting Connection
Cannot establish connection
Generated Exception java.sql.SQLException: No suitable driver
java.sql.SQLException: No suitable driver
at java.sql.DriverManager.getConnection(DriverManager .java:532)
at java.sql.DriverManager.getConnection(DriverManager .java:171)
at dbtest.main(dbtest.java:27)
[root@localhost Java]#

please help me immediately i am stuck ..........