aspose file tools
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 RabbitMQ in Depth this week in the Open Source 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
 
With a little knowledge, a cast iron skillet is non-stick and lasts a lifetime.
 
subject: Unable to connect Postgres useing unixODBC