[jboss-user] [Datasource Configuration] - Re: MySQL problem with multiple instances of JBOSS

[Unmesh Kulkarni]

Unmesh Kulkarni [http://community.jboss.org/people/unmesh_kulkarni] created the discussion

"Re: MySQL problem with multiple instances of JBOSS"

To view the discussion, visit: http://community.jboss.org/message/584608#584608

--------------------------------------------------------------
Hi Wolf-Dieter Fink,

Thanks for your reply.

No... Its not typo.

I am starting MySQL Server on 192.168.6.128 on port 3306.

There are two databases testenv1 & testenv2 on MySQL server.

testenv1 user is having all rights on testenv1 database
testenv2 user is having all rights on testenv2 database

One thing I noticed.......

I removed MySQL server binding on 192.168.6.128 ( so that it will get bound on 0.0.0.0 by default ) and changed connection-url  jdbc:mysql://192.168.6.*129*:3306/testenv2

After that connection was successful.

Not very sure why it fails if I bind MySQL server on one IP
--------------------------------------------------------------

Reply to this message by going to Community
[http://community.jboss.org/message/584608#584608]

Start a new discussion in Datasource Configuration at Community
[http://community.jboss.org/choose-container!input.jspa?contentType=1&containerType=14&container=2077]

-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.jboss.org/pipermail/jboss-user/attachments/20110201/b1d98dd9/attachment-0001.html