Thread: link to Jsp

link to Jsp

From
"Shavonne Marietta Wijesinghe"
Date:
Hello
 
I'm trying to connect to my postgresql db from a JSP page but my db is on one computer and the jsp in another..
 
Has anyone done something like this before??
 
 private synchronized Connection getConnection() throws ClassNotFoundException,
      SQLException {
    final String DRIVER = "org.postgresql.Driver";
    final String URL = "jdbc:postgresql:FormAjax";
    final String USERNAME = "postgres";
    final String PASSWORD = "form";
 
    Class.forName(DRIVER);
 
    return DriverManager.getConnection(URL, USERNAME, PASSWORD);
 }
 
Thanks
 
Shavonne Wijesinghe

Re: link to Jsp

From
Craig Ringer
Date:
Shavonne Marietta Wijesinghe wrote:
> Hello
> 
> I'm trying to connect to my postgresql db from a JSP page but my db is on one computer and the jsp in another.. 
> 
> Has anyone done something like this before??
> 
>  private synchronized Connection getConnection() throws ClassNotFoundException,
>       SQLException {
>     final String DRIVER = "org.postgresql.Driver";
>     final String URL = "jdbc:postgresql:FormAjax";

Read the documentation for the PostgreSQL JDBC layer, particularly the
part about the JDBC URL. I quote:

------------
The JDBC URL

In JDBC all url's begin with jdbc:protocol: This is the standard. After
this is driver specific, and no two drivers are the same.

So our url? It's one of the following:
   jdbc:postgresql:database   jdbc:postgresql://host/database   jdbc:postgresql://host:port/database

where database is the database to connect to, host the server to connect
to, and port the port number.

If left out, host defaults to localhost (not 127.0.0.1 see applets!) and
port to 5432 (configurable at build time).
-----------

--
Craig Ringer