Jboss and mysql

[Iede Snoek]

Hello out there.

Maybe this has been asked before but I have a problem with configuring
mysql and jboss. I configure a mysql-ds.xml as follows:

<?xml version="1.0" encoding="UTF-8"?>
<datasources>
<local-tx-datasource>
<jndi-name>jdbc/UserDatabaseMySQL</jndi-name>
<connection-url>jdbc:mysql://grappa.fredhopper.com:3306/bizmanuser</connection-url>
<driver-class>com.jdbc.mysql.Driver</driver-class>
<user-name>bizuser</user-name>
<password>bizz11</password>
</local-tx-datasource>

</datasources>

When I try to make a connection using JNDI it seems that JBoss keeps
thinking it i s a Postgres database it is connecting to (there is
another datasource, for a postgres connection). How can I solve this?
If you need more info, or better yet, if you have an answer, I would
be very grateful.

Thx in advance,

Iede

 

[Sudsy]

Iede Snoek wrote:

When I try to make a connection using JNDI it seems that JBoss keeps
thinking it i s a Postgres database it is connecting to (there is
another datasource, for a postgres connection). How can I solve this?
If you need more info, or better yet, if you have an answer, I would
be very grateful.

Sounds like you're missing the datasource-mapping element in the
META-INF/jbosscmp-jdbc.xml file. I had similar difficulties when
trying to use Oracle but the solution was easier to implement by
using Eclipse along with JBoss-IDE and Xdoclets.

 

[Bryce]

Hello out there.

Maybe this has been asked before but I have a problem with configuring
mysql and jboss. I configure a mysql-ds.xml as follows:

<?xml version="1.0" encoding="UTF-8"?>
<datasources>
<local-tx-datasource>
<jndi-name>jdbc/UserDatabaseMySQL</jndi-name>
<connection-url>jdbc:mysql://grappa.fredhopper.com:3306/bizmanuser</connection-url>
<driver-class>com.jdbc.mysql.Driver</driver-class>
<user-name>bizuser</user-name>
<password>bizz11</password>
</local-tx-datasource>

</datasources>

That looks ok. What does your application's deployment descriptors
look like? And what are you doing when you get that error message? And
could you please post the entire error message.

 

[robintan]

If the JNDI name is "jdbc/UserDatabaseMySQL", then ur datasource needs to look
for "jdbc:/jdbc/UserDatabaseMySQL".