Hello,
I just now installed Postgresql-6.5.1 on my RH6.0 system. It is working
fine.
Then I downloaded jdbc6.5.1-2.jar file from the repturs site. I renamed
it postgresql.jar and kept it in /usr/local/pgsql/lib directory and
exported the classpath as:
export
CLASSPATH=\/usr/local/lib/finder.jar:/usr/local/postgresql.jar:.java.uk.org.retep.finder.Main
Once this is done I tried to make connection to my driver by this
program..
import java.net.URL;
import java.sql.*;
class SimpleSelect {
public static void main (String args[]) {
String url = ".java.uk.org.retep.finder.Main";
String query = "SELECT * FROM emp";
try {
Class.forName ("postgresql.Driver");
DriverManager.setLogStream(System.out);
Connection con = DriverManager.getConnection (url,
"postgres","postgres");
checkForWarning (con.getWarnings ());
DatabaseMetaData dma = con.getMetaData ();
System.out.println("\nConnected to " + dma.getURL());
System.out.println("Driver " +
dma.getDriverName());
System.out.println("Version " +
dma.getDriverVersion());
System.out.println("");
Statement stmt = con.createStatement ();
ResultSet rs = stmt.executeQuery (query);
dispResultSet (rs);
rs.close();
stmt.close();
con.close();
}
catch (SQLException ex)
{
System.out.println ("\n*** SQLException caught ***\n");
while (ex != null) {
System.out.println ("SQLState: " +ex.getSQLState ());
System.out.println ("Message: " + ex.getMessage ());
System.out.println ("Vendor: " +ex.getErrorCode ());
ex = ex.getNextException ();
System.out.println ("");
}
}
catch (java.lang.Exception ex)
{
ex.printStackTrace ();
}
}
private static boolean checkForWarning (SQLWarning warn) throws
SQLException
{
boolean rc = false;
if (warn != null)
{
System.out.println ("\n *** Warning ***\n");
rc = true;
while (warn != null)
{
System.out.println ("SQLState: " +warn.getSQLState ());
System.out.println ("Message: " +warn.getMessage ());
System.out.println ("Vendor: " +warn.getErrorCode ());
System.out.println ("");
warn = warn.getNextWarning ();
}
}
return rc;
}
private static void dispResultSet (ResultSet rs) throws SQLException{
int i;
ResultSetMetaData rsmd = rs.getMetaData ();
int numCols = rsmd.getColumnCount ();
for (i=1; i<=numCols; i++)
{
if (i > 1) System.out.print(",");
System.out.print(rsmd.getColumnLabel(i));
} System.out.println("");
boolean more = rs.next (); while (more) {
for (i=1; i<=numCols; i++)
{
if (i > 1) System.out.print(",");
System.out.print(rs.getString(i));
}
System.out.println("");
more = rs.next (); }}
}
Is there some mistake in the program??
Also, is the driver placed correctly or I need to manually need to
recompile the driver??
I am using Java-1.2.
Please suggest the modification in the code as well as driver
installation, as I am new to this.
Thanking YOu all,
Alpesh
===
KOTHARI ALPESH D.
STUDENT M. TECH.
CEDT
INDIAN INSTITUTE OF SCIENCE
BANGALORE-560 012
INDIA
__________________________________________________
Do You Yahoo!?
Bid and sell for free at http://auctions.yahoo.com
************
