jQuery in Action, 3rd edition
The moose likes JDBC and Relational Databases 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


Win a copy of Customer Requirements for Developers this week in the Jobs Discussion forum!
JavaRanch » Java Forums » Databases » JDBC and Relational Databases
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
 
It's not a secret anymore!