Re: RES: [JDBC] Java access pgsql sample : Solution!!!

Hi (Olá) Elielson!

Thanks for all!

After last tips I move my db to other machine compile and execute fine.

Other libs in my machine?
I don't encounter.

Feedback to others:

jsdk1.4.1
PostgreSQL 7.2

My /etc/profile:
=========================
JAVA_HOME="/usr/java/jsdk"
J2EE_HOME="/usr/java/j2ee"
CLASSPATH=.:$JAVA_HOME/jre/lib/ext/pgjdbc2.jar:$JAVA_HOME/lib:$JAVA_HOME/jre/lib:/usr/java/jsdk/corejava/corejava.zip
J2EE_CLASSPATH=$CLASSPATH
PATH="$PATH:$JAVA_HOME/bin:$J2EE_HOME/bin"
export JAVA_HOME J2EE_HOME CLASSPATH J2EE_CLASSPATH

My sample:
=========================
import java.sql.*;
public class SQLStatement {
public static void main(String args[]) {
String url = "jdbc:postgresql://10.0.1.53:5432/javatest";
Connection con;
//String query = "select col1 from test";
Statement stmt;
try {
Class.forName("org.postgresql.Driver");
} catch(java.lang.ClassNotFoundException e) {
System.err.print("ClassNotFoundException: ");
System.err.println(e.getMessage());
}
try {
con = DriverManager.getConnection(url,"postgres", "postgres");
stmt = con.createStatement();
ResultSet rs = stmt.executeQuery("select col1 from test");
ResultSetMetaData rsmd = rs.getMetaData();
int numberOfColumns = rsmd.getColumnCount();
int rowCount = 1;
while (rs.next()) {
System.out.println("Linha " + rowCount + ": ");
for (int i = 1; i <= numberOfColumns; i++) {
System.out.print(" Coluna " + i + ": ");
System.out.println(rs.getString(i));
}
System.out.println("");
rowCount++;
}
stmt.close();
con.close();

} catch(SQLException ex) {
System.err.print("SQLException: ");
System.err.println(ex.getMessage());
}
}
}
==========================

Thank you, thank you very mutch!