Re: jdbc url

Marin Dimitrov wrote:

>hi,
>
>can I pass the username and password for the connection as part of the JDBC
>url?
>
>having read some docs it seems that this is not possible, i.e. I can't use
>the getConnection(String url) method but I should use the
>getConnection(String url, String user, String password) one
>

    With the devpgjdbc2 jar, I've been able to use

jdbc:postgresql://linuxmxm/bfdb?user=<username>&password=<password>

(substituting in <username> and <password>.)
    I think I found that from digging through the source.  Don't know
exactly which versions support this, though.  (Also, I'm assuming that
you're using the old-style java.sql.Driver methods, which is what I've
been using.)
    Josh

>
>thanx,
>
>    Marin
>
>----
>"...what you brought from your past, is of no use in your present. When
>you must choose a new path, do not bring old experiences with you.
>Those who strike out afresh, but who attempt to retain a little of the
>old life, end up torn apart by their own memories. "
>
>
>
>
>---------------------------(end of broadcast)---------------------------
>TIP 2: you can get off all lists at once with the unregister command
>    (send "unregister YourEmailAddressHere" to majordomo@postgresql.org)
>
>
--
Josh Burdick
jburdick@gradient.cis.upenn.edu
http://www.cis.upenn.edu/~jburdick