Re: jdbc windows

["Robert Wimmer" <seppwimmer(at)hotmail(dot)com>]

> 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