• Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

Unable to connect Postgres useing unixODBC

 
Nagurva Reddy
Greenhorn
Posts: 7
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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();}
}
}

i got SQLException NoSutableDriver

pl help me.....
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic