Thread: JSP to PostgreSql

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:postgresql://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:postgresql://192.168.2.3:8080/formajax?user=postgres&password=form

Yours,
Laurenz Albe

"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:postgresql://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:postgresql://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

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

wrong:
jdbc:postgresql://192.168.2.3:8080/database/FormAjax?user=postgres&password=form

right:
jdbc:postgresql://192.168.2.3:8080/formajax?user=postgres&password=form