Re: PostgreSQL-JDBC correct URL

This is what I use for JDBC:

(There are other ways. Read the jdbc documentation OR the source
directly. There are MANY examples, and the docs are more than enough.

Did you read them ?!

)

final public static String DBURL =
"jdbc:postgresql://host.domain:5432/dbname";

final public static String driverName =
"postgresql.Driver";

            // The postgresql.jar must be in classpath
Class.forName(driverName);

java.sql.Connection connection =
DriverManager.getConnection(DBURL,username,password);

...

Cheers, Silvio


On Mon, 10 Apr 2000, Haroldo Stenger wrote:

> Hello nice people,
>
> /* I'm a GeneXus programmer (www.genexus.com), a RAD tool. They support natively
> Oracle, Informix, DB2 & MS SQL Server. I'm taking steps to use and encourage use
> by others, of PostgreSQL, which I thing is the most amazing DBMS out there these
> days. Java is the language I chose to generate my future applications using
> GeneXus.
> */
>
> GeneXus asks me for the driver name, and for the URL of the JDBC driver. Then,
> when trying to connect to the database, a Java java.lang.ClassNotFoundException
> appears. I seem to be failing to tell the right name of the driver. I tried
> gnu.postgres95.PGDriver, and others like this. And for the URL, I used
> jdbc:postgres95:template1?user=haroldo&password=haroldo
>
> With this template:
> jdbc:driver://host:port/database?option=value&user=userid&password=password  I
> wonder what 'driver' must be, if either postgres95 or postgresql or postgreSQL.
>
> I'm using the Postgresql 6.5 JDK1.1.x JDBC driver. Does it use the same URL
> format as earlier versions, i.e. postgres95 versions?
>
> I'd like to thank in advance to Peter Mount, o whoever answers this.
>
>

--
``````````` Silvio Emanuel Nunes Barbosa de Macedo (PhD Std) '''''''''''''
smacedo@ic.ac.uk                                         smacedo@inescn.pt
Intelligent and Interactive Systems                Telecom. and Multimedia
Imperial College, University of London                         INESC Porto
Exhibition Road,                                       Pc da Republica, 93
London SW7 2AZ, England                            4050-497 Porto Portugal
Tel:+44 171 5946323                                    Tel:+351 22 2094220