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 OCA Java SE 8 Programmer I Study Guide 1Z0-808 this week in the OCAJP 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