File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
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
JavaRanch » Java Forums » Databases » JDBC and Relational Databases
Bookmark "Unable to connect Postgres useing unixODBC" Watch "Unable to connect Postgres useing unixODBC" New topic

Unable to connect Postgres useing unixODBC

Nagurva Reddy

Joined: Jul 10, 2001
Posts: 7
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[]){
Connection con=DriverManager.getConnection("JDBC:ODB:PostgreSQL","author","coursesafe");
Statement st=con.createStatement();
ResultSet rs=st.executeQuery("select * from usermaster");
}catch(Exception exp){ exp.printStackTrace();}

i got SQLException NoSutableDriver

pl help me.....

I agree. Here's the link:
subject: Unable to connect Postgres useing unixODBC
jQuery in Action, 3rd edition