Message-ID: <BAY116-F225E3F283C4CDBAD9909F8D07F0@phx.gbl>
In-Reply-To: <44A11AC2.3070104@email.it>
From: "Robert Wimmer" <seppwimmer@hotmail.com>
To: matteo.traina@email.it, pgsql-interfaces@postgresql.org
Subject: Re: jdbc windows
Date: Wed, 28 Jun 2006 17:40:09 +0000
Mime-Version: 1.0
Content-Type: text/plain; charset=iso-8859-1; format=flowed

>From: Matteo Traina <matteo.traina@email.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