Re: Java access pgsql sample
От | Yuva Chandolu |
---|---|
Тема | Re: Java access pgsql sample |
Дата | |
Msg-id | A0F24737FCB34F489EC955D143BDD8510173E0D7@exchange-sf1.corp.ebates.com обсуждение исходный текст |
Ответ на | Java access pgsql sample ("Ribamar FS" <ribafs@myrealbox.com>) |
Список | pgsql-jdbc |
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@myrealbox.com] Sent: Thursday, July 25, 2002 12:11 PM To: pgsql-jdbc@postgresql.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@postgresql.org so that your message can get through to the mailing list cleanly
В списке pgsql-jdbc по дате отправления: