Re: jdbc windows

>From: Matteo Traina <matteo(dot)traina(at)email(dot)it>

>i don't understand about use jdbc driver with windows...how do i do for use
>it, sorry but i need a little guide/trial because i find it only for linux.

the usage of jdbc does not depend on the underlying OS.

here is some example code - that also works in windows

package at.wiro.sql;

import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;

public class Postgres {

public static void printException(String query,SQLException e)
{
System.out.println("query : <" + query + ">");
System.out.println("SQL-error : " + e.getErrorCode());
System.out.println("SQL-state : " + e.getSQLState());
System.out.println("SQL-message : " + e.getMessage());
e.printStackTrace();
System.exit(1);
}

public static Connection connect(String host,String db, String user,
String pwd)
{
String pg_driver = "org.postgresql.Driver";
Connection conn = null;
try { Class.forName(pg_driver); }
catch (Exception e) {
System.out.println("can't load postgres driver '" + pg_driver + "'
...");
System.exit(1);
}
try { conn = DriverManager.getConnection("jdbc:postgresql://" + host +
"/" + db,user,pwd); }
catch (SQLException e) {
System.out.println("can't connect to db '"+db+"' as user '" + user +
"' ...");
printException("Connection Error : ",e);
System.out.println("system halted ...");
System.exit(1);
}
return conn;
}

public static ResultSet query(Connection conn,String query)
{
ResultSet rs = null;
try {
Statement st =
conn.createStatement(ResultSet.TYPE_SCROLL_INSENSITIVE,ResultSet.CONCUR_UPDATABLE);
rs = st.executeQuery(query);
}
catch (SQLException e) { printException(query,e);}
return rs;
}

....

regards sepp