Hi,
Following is the error report:
org.apache.jasper.JasperException: Unable to compile class for JSP:
An error occurred at line: 13 in the jsp file: /jsp/pgtest.jsp
Properties cannot be resolved to a type
10: {
11: Class.forName("org.postgresql.Driver");
12: String url = "jdbc:postgresql://localhost:5432/postgres?user=postgres&password=major";
13: Properties props = new Properties();
14: props.setProperty("loglevel","2");
15: Connection conn = DriverManager.getConnection(url, props);
16: }
Thanks
On Wed, Mar 10, 2010 at 4:02 AM, Mark Kirkwood
<mark.kirkwood@catalyst.net.nz> wrote:
Major Services wrote:
I am trying to connect to PostgreSQL database on my local system.
The code is:
Class.forName("org.postgresql.Driver");
String url = "jdbc:postgresql://localhost:5432/postgres?user=postgres&password=major";
Connection conn = DriverManager.getConnection(url);
Running the code I get:
org.postgresql.util.PSQLException: Protocol error. Session setup failed.
Using postgresql-8.4-701.jdbc3 on PostgreSql 8.4
Try adding some debug info (will help us see what is going on) - e.g:
Class.forName("org.postgresql.Driver");
String url = "jdbc:postgresql://localhost:5432/postgres?user=postgres&password=major";
Properties props = new Properties();
props.setProperty("loglevel","2");
Connection conn = DriverManager.getConnection(url, props);
regards
Mark