From: | "Robert Wimmer" <seppwimmer(at)hotmail(dot)com> |
---|---|
To: | matteo(dot)traina(at)email(dot)it, pgsql-interfaces(at)postgresql(dot)org |
Subject: | Re: jdbc windows |
Date: | 2006-06-28 17:40:09 |
Message-ID: | BAY116-F225E3F283C4CDBAD9909F8D07F0@phx.gbl |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-interfaces |
>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
From | Date | Subject | |
---|---|---|---|
Next Message | Dirk Heinrichs | 2006-06-28 18:00:36 | plPerl: How to iterate over $_TD->{new} in a trigger function? |
Previous Message | Tom Lane | 2006-06-28 14:59:45 | Re: Creating a new type |