Errors Migrating no-tx-datasource from 4.0.5 to 4.2.2

[jantzen]

Hi All,

I'm trying to run a couple applications in 4.2.2. These work fine in 4.05., but I'm seeing errors at startup now:

--- MBeans waiting for other MBeans ---
ObjectName: persistence.units:ear=DatabaseImport.ear,jar=DatabaseImport.jar,unitName=MediaWikiDBImporterRole
 State: FAILED
 Reason: javax.naming.NoInitialContextException: Need to specify class name in environment or system property, or as an applet parameter, or in an application resource file: java.naming.factory.initial
 I Depend On:
 jboss.jca:service=DataSourceBinding,name=MediaWikiDBImporterRoleDS

--- MBEANS THAT ARE THE ROOT CAUSE OF THE PROBLEM ---
ObjectName: persistence.units:ear=DatabaseImport.ear,jar=DatabaseImport.jar,unitName=MediaWikiDBImporterRole
 State: FAILED
 Reason: javax.naming.NoInitialContextException: Need to specify class name in environment or system property, or as an applet parameter, or in an application resource file: java.naming.factory.initial
 I Depend On:
 jboss.jca:service=DataSourceBinding,name=MediaWikiDBImporterRoleDS

Here's my MySQL DS file:

<?xml version="1.0" encoding="UTF-8"?>

<datasources>

 <no-tx-datasource>
 <jndi-name>MediaWikiDBImporterRoleDS</jndi-name>
 <connection-url>jdbc:mysql://localhost:3306/MediaWikiDB</connection-url>
 <driver-class>com.mysql.jdbc.Driver</driver-class>
 <user-name>username</user-name>
 <password>password</password>
 </no-tx-datasource>

</datasources>

And here's my persistence.xml:

 <persistence-unit name="MediaWikiDBImporterRole">
 <provider>org.hibernate.ejb.HibernatePersistence</provider>
 <!-- FIXME this should be non-jta-data-source but can't due to a JBoss bug http://jira.jboss.com/jira/browse/EJBTHREE-433 -->
 <jta-data-source>java:/MediaWikiDBImporterRoleDS</jta-data-source>
 <properties>
 <property name="jboss.entity.manager.factory.jndi.name" value="java:/PersistenceUnits/MediaWikiDBImporterRole"/>
 <property name="hibernate.dialect" value="org.hibernate.dialect.MySQL5Dialect"/>
 <property name="hibernate.show_sql" value="false" />
 <property name="hibernate.cache.provider_class" value="org.hibernate.cache.NoCacheProvider"/>
 </properties>
 </persistence-unit>

In 4.0.5 I had to make this a jta-data-source as that bug alludes to. In 4.2.2 it won't work either as jta or non-jta. Any ideas?

Thanks.

[vickyk]

"jantzen" wrote:

--- MBeans waiting for other MBeans ---
ObjectName: persistence.units:ear=DatabaseImport.ear,jar=DatabaseImport.jar,unitName=MediaWikiDBImporterRole

The above line indicates that there is some issue with the DatabaseImport.ear.
Can you verify if the plain MySQL DS file works properly , this should not have any issues ?

[jantzen]

The identical EAR works fine (loads and runs) in 4.0.5 and in 4.2.1. I also see the same error coming out of a fundamentally identical PostgreSQL DS file.

Did something change in 4.2.2 regarding no-tx-datasources?

[jantzen]

Ok, I've got the datasources working in a different EAR, so it's not those. Something else is wonky with this EAR.

[vickyk]

"jantzen" wrote:

Did something change in 4.2.2 regarding no-tx-datasources?

No , looks something wrong in your environment (Jboss where you are deploying the EAR).