SEO

#1 (**permalink**) 04-16-2008, 01:00 AM

Hello. I'm trying to connect my jsp page to read a database on a windows 2003 server.

<%@ page language="java" import="java.sql.*" %>
<body>
<%
Class.forName("org.postgresql.Driver");
Connection myConn=DriverManager.getConnection("jdbc

ostgresq l://XXX.XXX.X.X/database/FormAjax?user=postgres&password=form");
%>
</body>

But when i run this i get an "Exception report" error

org.apache.jasper.JasperException: Exception in JSP: /jsp/pgtest.jsp:10
7:
8: Class.forName("org.postgresql.Driver");
9:
10: Connection myConn=DriverManager.getConnection("jdbc

ostgresq l://192.168.2.3:8080/database/FormAjax?user=postgres&password=form");
11:
12: %>
13: </body>

Any idea anyone?
Thank you.
Shavonne

#2 (**permalink**) 04-16-2008, 01:00 AM

Shavonne Marietta Wijesinghe wrote:
> Hello. I'm trying to connect my jsp page to read a database
> on a windows 2003 server.
>
> Class.forName("org.postgresql.Driver");
> Connection myConn=DriverManager.getConnection("jdbc

ostgresq l://192.168.2.3:8080/database/FormAjax?user=postgres&password=form");
>
> But when i run this i get an "Exception report" error
>
> org.apache.jasper.JasperException: Exception in JSP:

My first instinct is to say: this is no exception generated by PostgreSQL.
Ask somewhere else!

But then I see the URL you use, and it looks wrong.
Given that your database name is "formajax", you should connect with the URL:

jdbc

ostgresql://192.168.2.3:8080/formajax?user=postgres&password=form

Yours,
Laurenz Albe

--
Sent via pgsql-jdbc mailing list (pgsql-jdbc@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-jdbc

#3 (**permalink**) 04-16-2008, 01:00 AM

"Albe Laurenz" <laurenz.albe 'at' wien.gv.at> writes:

> Shavonne Marietta Wijesinghe wrote:
>> Hello. I'm trying to connect my jsp page to read a database
>> on a windows 2003 server.
>>
>> Class.forName("org.postgresql.Driver");
>> Connection myConn=DriverManager.getConnection("jdbc

ostgresq l://192.168.2.3:8080/database/FormAjax?user=postgres&password=form");
>>
>> But when i run this i get an "Exception report" error
>>
>> org.apache.jasper.JasperException: Exception in JSP:
>
> My first instinct is to say: this is no exception generated by PostgreSQL.
> Ask somewhere else!
>
> But then I see the URL you use, and it looks wrong.
> Given that your database name is "formajax", you should connect with the URL:
>
> jdbc

ostgresql://192.168.2.3:8080/formajax?user=postgres&password=form

Well, we can also have doubts that postgres is really listening
on port 8080..

--
Guillaume Cottenceau, MNC Mobile News Channel SA, an Alcatel-Lucent Company
Av. de la Gare 10, 1003 Lausanne, Switzerland - direct +41 21 317 50 36

--
Sent via pgsql-jdbc mailing list (pgsql-jdbc@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-jdbc

#4 (**permalink**) 04-16-2008, 01:00 AM

Thanks Laurenz . I changed the address as you said and it worked.

wrong:
jdbc

ostgresql://192.168.2.3:8080/database/FormAjax?user=postgres&password=form

right:
jdbc

ostgresql://192.168.2.3:8080/formajax?user=postgres&password=form

--
Sent via pgsql-jdbc mailing list (pgsql-jdbc@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-jdbc

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

SEO

JSP to PostgreSql