Hai.. i am working on Redhat Linux 7.0. I have installed PostgreSQL and unixODBC in my system.I am able to to create DSN through ODBCConfig and i am able to retrive data from the database through odbctest tool. But i am not able to connect through java program.
import java.sql.*; public class OdbcTest{ public static void main(String arg[]){ try{ Class.forName("sun.jdbc.odbc.JdbcOdbcDriver"); Connection con=DriverManager.getConnection("JDBC:ODB:PostgreSQL","author","coursesafe"); Statement st=con.createStatement(); ResultSet rs=st.executeQuery("select * from usermaster"); while(rs.next()){ System.out.println("Name"+rs.getString(1)); } }catch(Exception exp){ exp.printStackTrace();} } }