Thanks, Thomas,
May I suggest that it might save this question in future if this info is
added to the FAQ under
How to Connect to a Database?
Paul Fraser
Thomas Mueller wrote:
> Hi,
>
>
>> Using JRuby and Sequel:-
>> Sequel connect code uses the single parameter form of get connection.
>> Mysql works OK with the single parameter form
>> "jdbc:h2:~/test?user=myuser&password=mypwd"
>> H2 in this form just considers the database name to be
>> "test?user=sa&password=sa"
>> Can h2 use the single parameter method?
>>
>
> Yes, see http://www.h2database.com/html/features.html#passwords:
>
> "Passing the User Name and/or Password in the URL
>
> Instead of passing the user name as a separate parameter as in
> Connection conn = DriverManager. getConnection("jdbc:h2:~/test", "sa",
> "123"); the user name (and/or password) can be supplied in the URL
> itself: Connection conn = DriverManager.
> getConnection("jdbc:h2:~/test;USER=sa;PASSWORD=123"); The settings in
> the URL override the settings passed as a separate parameter."
>
> Regards,
> Thomas
>
> >
>
>
--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups "H2
Database" group.
To post to this group, send email to [email protected]
To unsubscribe from this group, send email to
[email protected]
For more options, visit this group at
http://groups.google.com/group/h2-database?hl=en
-~----------~----~----~----~------~----~------~--~---
