MySQL Connection Pool in Jboss 3.0.0

[coughlam]

Hi,
Could anybody tell me how to configure a MySQL database connection pool in JBoss 3.0.0 ?

What xml files to modify etc...


Thanks in advance !

Mick

[juha]

There are examples under docs/examples/jca did you check those?

[coughlam]

Hi juha,
Thanks for your help.
I tried this, but when I try to do an JNDI lookup for the Datasource I get a "NameNotFoundException".

In the Agent view, in the jboss.jca area, I can see that it has created the following:

service=LocalTxCM,name=MySqlDataSource
service=LocalTxDS,name=MySqlDataSource
service=LocalTxPool,name=MySqlDataSource


Despite this, I still get the JNDI lookup error.

[coughlam]

Hi juha,
Thanks for your help.
I tried this, but when I try to do an JNDI lookup for the Datasource I get a "NameNotFoundException".

In the Agent view, in the jboss.jca area, I can see that it has created the following:

service=LocalTxCM,name=MySqlDataSource
service=LocalTxDS,name=MySqlDataSource
service=LocalTxPool,name=MySqlDataSource


Despite this, I still get the JNDI lookup error.

[coughlam]

Hi juha,
Thanks for your help.
I tried this, but when I try to do an JNDI lookup for the Datasource I get a "NameNotFoundException".

In the Agent view, in the jboss.jca area, I can see that it has created the following:

service=LocalTxCM,name=MySqlDataSource
service=LocalTxDS,name=MySqlDataSource
service=LocalTxPool,name=MySqlDataSource


Despite this, I still get the JNDI lookup error.

[coughlam]

Hi juha,
Thanks for your help.
I tried this, but when I try to do an JNDI lookup for the Datasource I get a "NameNotFoundException".

In the Agent view, in the jboss.jca area, I can see that it has created the following:

service=LocalTxCM,name=MySqlDataSource
service=LocalTxDS,name=MySqlDataSource
service=LocalTxPool,name=MySqlDataSource


Despite this, I still get the JNDI lookup error.

[coughlam]

Hi juha,
Thanks for your help.
I tried this, but when I try to do an JNDI lookup for the Datasource I get a "NameNotFoundException".

In the Agent view, in the jboss.jca area, I can see that it has created the following:

service=LocalTxCM,name=MySqlDataSource
service=LocalTxDS,name=MySqlDataSource
service=LocalTxPool,name=MySqlDataSource


Despite this, I still get the JNDI lookup error.

[ewen]

lookup("java:/MySqlDS");
justlike this. try it.

[coughlam]

Hi,
I got it working, I was trying to do the lookup from a different VM, so as soon as I wrapped the functionality in an EJB, it worked fine.


Thanks guys for you help.

Mick