aspose file tools*
The moose likes JDBC and the fly likes Unable to connect Postgres useing unixODBC Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login
JavaRanch » Java Forums » Databases » JDBC
Bookmark "Unable to connect Postgres useing unixODBC" Watch "Unable to connect Postgres useing unixODBC" New topic
Author

Unable to connect Postgres useing unixODBC

Nagurva Reddy
Greenhorn

Joined: Jul 10, 2001
Posts: 7
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.....

Nagurva
 
I agree. Here's the link: http://aspose.com/file-tools
 
subject: Unable to connect Postgres useing unixODBC