Re: Java access pgsql sample

Hi,

Please check your jdbc url, it looks wrong to me. It should be in the form

jdbc:postgresql://<database server ip or hostname>:<database port>/<instance
name>

Eg. jdbc:postgresql://123.123.123.123:5432/javatest

Where 123.123.123.123 is the server on which you are running postgres
database and 5432 is it's default port, change port if you have specified a
diff one. javatest is the instance name in your case.

Thanks
Yuva

-----Original Message-----
From: Ribamar FS [mailto:ribafs(at)myrealbox(dot)com]
Sent: Thursday, July 25, 2002 12:11 PM
To: pgsql-jdbc(at)postgresql(dot)org
Subject: [JDBC] Java access pgsql sample

Hi!

Help me with this sample. It don't work:

Linux Conectiva
Postgresql 7.2.1
pgjdbc2.jar

/etc/profile
JAVA_HOME="/usr/java/jsdk"
J2EE_HOME="/usr/java/j2ee"
CLASSPATH=".:$JAVA_HOME/lib:$J2EE_HOME/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

import java.sql.*;
public class SQLStatement {
public static void main(String args[]) {
String url = "jdbc:postgresql: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(query);
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());
}
}
}

Errors:
ClassNotFoundException: org/postgresql/Driver
SQLException: driver not found: jdbc:postgresql:javatest

Thank you for attention. Sorry ny english (brasilian).

---------------------------(end of broadcast)---------------------------
TIP 3: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to majordomo(at)postgresql(dot)org so that your
message can get through to the mailing list cleanly