Data source lookup returns null for mysql

[emwamba]

I have installed jboss 4.0.4.GA and have configured a MySQL datasource, named "qmmsDB", as I did in jboss 4.0.2. However, when my code attempts to look up the data source, a null value is returned and no exeception is returned. The code is as follows:

Context ctx = new InitialContext();
DataSource ds = (DataSource)ctx.lookup("java:/qmmsDB");

The value of ds is always null, yet the same code and mysql-ds.xml worked in 4.0.2. The following are extracts from mysql-ds.xml:

<jndi-name>qmmsDB</jndi-name>
<connection-url>jdbc:mysql://localhost:3306/qmmsDB?autoReconnect=true</connection-url>
<driver-class>com.mysql.jdbc.Driver</driver-class>

Help anyone out there!

[tefron]

Do you have isolation on?

[emwamba]

"tefron" wrote:
Do you have isolation on?

Sorry, I am not an expert user of JBoss. I don't know whether or not I have isolation enabled. How do I check and what effect would that have?

[tefron]

Check these:
Isolation is set using flags in your configuration or jboss_web/app files.


The benefit is that every application has its own class loding space and you can avoid lots of wierd problems. The down side is that isolation can affect jndi lookup in general, and lookup data source specifically.

To read about isolation and class loding use the following:


http://wiki.jboss.org/wiki/Wiki.jsp?page=JBossClassLoadingUseCases

http://wiki.jboss.org/wiki/Wiki.jsp?page=ClassLoadingConfiguration


Please let me know if you can get both isolation and datasource lookup work at the same time.


Thanks,
TEFRON