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 -~----------~----~----~----~------~----~------~--~---
