MySQL: Is database name must in connection URL?

[P Lavti]

Hi All,

I am using mysql with Jboss AS.

Is it required to give the the database name in connection URL?
<connection-url>jdbc:mysql://hostname:port/<I>database-name</I></connection-url>

My application is using 2 databases, to connect to both the databases, do I need to have two JNDI names declared in mysql-ds.xml?

Or is there any way to avoid having two JNDI names declaration and still I can connect to both the databases?

Thanks!

[Praful Thakare]

Or is there any way to avoid having two JNDI names declaration and still I can connect to both the databases?    

why you want to avoid it?

I dont think this is possible unless you have to hardcode it in your code.

-P

[Scott Selikoff]

Originally posted by P Lavti:
Or is there any way to avoid having two JNDI names declaration and still I can connect to both the databases?

No, unless you don't use mysql-ds.xml.