JBoss 5.1.0.GA multiple datasource problem

[Lorenzo Rep]

Hello all,
I'm porting two web app from JB 4.0.4.GA to JB 5.1.0.GA.
The two apps (WAR) use hibernate for persistence.
The first uses a single datasource (waspDS) and works correctly.
The seconduses two different datasources (waspDS and waspAllineamentiDS) because it has to connect to two different DB.

While in JB 4 I have no problem at all, now in JB 5 the second app give me an error every time I try to login.

These are the datasources configurations in the "deploy" folder:

the wasp-oracle-ds.xml file

<?xml version="1.0" encoding="UTF-8"?>
<datasources>
  <local-tx-datasource>
    <jndi-name>jdbc/waspDS</jndi-name>
    <connection-url>jdbc:oracle:thin:@192.168.0.94:1521:WASP</connection-url>
    <driver-class>oracle.jdbc.driver.OracleDriver</driver-class>
    <user-name>user1</user-name>
    <password>password</password>
    <min-pool-size>10</min-pool-size>
    <max-pool-size>20</max-pool-size>
    <blocking-timeout-millis>8000</blocking-timeout-millis>
    <idle-timeout-minutes>10</idle-timeout-minutes>    
    <exception-sorter-class-name>org.jboss.resource.adapter.jdbc.vendor.OracleExceptionSorter</exception-sorter-class-name>
    <metadata>
       <type-mapping>Oracle11g</type-mapping>
    </metadata>
  </local-tx-datasource>
</datasources>

and the waspAllineamenti-oracle-ds.xml

<?xml version="1.0" encoding="UTF-8"?>
<datasources>
  <local-tx-datasource>
    <jndi-name>jdbc/waspAllineamentiDS</jndi-name>
    <connection-url>jdbc:oracle:thin:@192.168.0.94:1521:WASP</connection-url>
    <driver-class>oracle.jdbc.driver.OracleDriver</driver-class>
    <user-name>user2</user-name>
    <password>password</password>
	<min-pool-size>10</min-pool-size>
    <max-pool-size>20</max-pool-size>
    <blocking-timeout-millis>8000</blocking-timeout-millis>
    <idle-timeout-minutes>10</idle-timeout-minutes>
    <exception-sorter-class-name>org.jboss.resource.adapter.jdbc.vendor.OracleExceptionSorter</exception-sorter-class-name>
    <metadata>
       <type-mapping>Oracle11g</type-mapping>
    </metadata>
  </local-tx-datasource>
</datasources>

The jboss-web.xml is this:

<?xml version="1.0" encoding="UTF-8"?>
<jboss-web>
    <resource-ref>
        <res-ref-name>jdbc/waspAllineamentiDS</res-ref-name>
        <res-type>javax.sql.DataSource</res-type>
        <jndi-name>java:jdbc/waspAllineamentiDS</jndi-name>
    </resource-ref>
    <resource-ref>
        <res-ref-name>jdbc/waspDS</res-ref-name>
        <res-type>javax.sql.DataSource</res-type>
        <jndi-name>java:jdbc/waspDS</jndi-name>
    </resource-ref>
</jboss-web>

and I have two hibernate config files, the first:

<?xml version="1.0" encoding="UTF-8"?>
<!DOCTYPE hibernate-configuration PUBLIC "-//Hibernate/Hibernate Configuration DTD 3.0//EN" "http://hibernate.sourceforge.net/hibernate-configuration-3.0.dtd">
<hibernate-configuration>
  <session-factory>
    <!-- Database connection settings -->
    <property name="connection.datasource">java:comp/env/jdbc/waspAllineamentiDS</property>
    <!-- LOB persisters -->
    <property name="webratio.lob.blobPersister">com.webratio.rtx.lob.OracleBlobPersister</property>
    <property name="webratio.lob.clobPersister">com.webratio.rtx.lob.OracleClobPersister</property>
    <property name="webratio.format_number">to_char(?1)</property>
    <property name="webratio.format_date">to_char(?1, 'YYYY-MM-DD')</property>
    <property name="webratio.format_time">to_char(?1, 'HH24:MI:SS')</property>
    <property name="webratio.format_timestamp">to_char(?1, 'YYYY-MM-DD HH24:MI:SS') || '.0'</property>
    <property name="webratio.extract_time">to_char(?1, 'HH24:MI:SS')</property>
    <property name="webratio.inClauseMaxCardinality">1000</property>
    <!-- SQL dialect -->
    <property name="dialect">org.hibernate.dialect.Oracle9iDialect</property>
    <!-- Enable Hibernate's automatic session context management -->
    <property name="current_session_context_class">thread</property>
    <!-- Disable the second-level cache  -->
    <property name="cache.provider_class">org.hibernate.cache.NoCacheProvider</property>
    <!-- Echo all executed SQL to stdout -->
    <property name="show_sql">false</property>
    <property name="format_sql">true</property>
    <mapping resource="com/webratio/webapp/DbOliWASP.hbm.xml"/>
...
    <mapping resource="com/webratio/webapp/StatoNodo.hbm.xml"/>
  </session-factory>
</hibernate-configuration>

and the second:

<?xml version="1.0" encoding="UTF-8"?>
<!DOCTYPE hibernate-configuration PUBLIC "-//Hibernate/Hibernate Configuration DTD 3.0//EN" "http://hibernate.sourceforge.net/hibernate-configuration-3.0.dtd">
<hibernate-configuration>
  <session-factory>
    <!-- Database connection settings -->
    <property name="connection.datasource">java:comp/env/jdbc/waspDS</property>
    <!-- LOB persisters -->
    <property name="webratio.lob.blobPersister">com.webratio.rtx.lob.OracleBlobPersister</property>
    <property name="webratio.lob.clobPersister">com.webratio.rtx.lob.OracleClobPersister</property>
    <property name="webratio.format_number">to_char(?1)</property>
    <property name="webratio.format_date">to_char(?1, 'YYYY-MM-DD')</property>
    <property name="webratio.format_time">to_char(?1, 'HH24:MI:SS')</property>
    <property name="webratio.format_timestamp">to_char(?1, 'YYYY-MM-DD HH24:MI:SS') || '.0'</property>
    <property name="webratio.extract_time">to_char(?1, 'HH24:MI:SS')</property>
    <property name="webratio.inClauseMaxCardinality">1000</property>
    <!-- SQL dialect -->
    <property name="dialect">org.hibernate.dialect.Oracle9iDialect</property>
    <!-- Enable Hibernate's automatic session context management -->
    <property name="current_session_context_class">thread</property>
    <!-- Disable the second-level cache  -->
    <property name="cache.provider_class">org.hibernate.cache.NoCacheProvider</property>
    <!-- Echo all executed SQL to stdout -->
    <property name="show_sql">false</property>
    <property name="format_sql">true</property>
    <mapping resource="com/webratio/webapp/User.hbm.xml"/>
...
    <mapping resource="com/webratio/webapp/Module.hbm.xml"/>
  </session-factory>
</hibernate-configuration>

The exception I get is:

17 gen 2012 15:43:02,340  ERROR [ajp-192.168.0.88-8209-1]  (com.webratio.rtx.core.ServiceProvider:226) - [db1u.hibernate]Error creating service: db1u.hibernate - db1u.hibernate
 org.hibernate.HibernateException: Could not find datasource
	at org.hibernate.connection.DatasourceConnectionProvider.configure(DatasourceConnectionProvider.java:79)
	at org.hibernate.connection.ConnectionProviderFactory.newConnectionProvider(ConnectionProviderFactory.java:137)
	at org.hibernate.connection.ConnectionProviderFactory.newConnectionProvider(ConnectionProviderFactory.java:79)
	at org.hibernate.cfg.SettingsFactory.createConnectionProvider(SettingsFactory.java:448)
	at org.hibernate.cfg.SettingsFactory.buildSettings(SettingsFactory.java:89)
	at org.hibernate.cfg.Configuration.buildSettings(Configuration.java:2101)
	at org.hibernate.cfg.Configuration.buildSessionFactory(Configuration.java:1325)
	at com.webratio.rtx.db.HibernateService.<init>(HibernateService.java:85)
	at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
	at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:39)
	at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:27)
	at java.lang.reflect.Constructor.newInstance(Constructor.java:513)
	at com.webratio.rtx.core.ServiceProvider.createServiceFromClass(ServiceProvider.java:113)
	at com.webratio.rtx.core.DefaultRTXManager.getService(DefaultRTXManager.java:385)
	at com.webratio.rtx.db.AbstractDBService.getHibernateService(AbstractDBService.java:45)
	at com.webratio.rtx.db.AccessService.<init>(AccessService.java:61)
	at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
	at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:39)
	at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:27)
	at java.lang.reflect.Constructor.newInstance(Constructor.java:513)
	at com.webratio.rtx.core.ServiceProvider.createServiceFromClass(ServiceProvider.java:113)
	at com.webratio.rtx.core.ServiceProvider.createService(ServiceProvider.java:75)
	at com.webratio.rtx.core.DefaultRTXManager.getService(DefaultRTXManager.java:367)
	at com.webratio.rtx.core.DefaultRTXManager.getAccessService(DefaultRTXManager.java:467)
	at com.webratio.rtx.core.DefaultPageService.<init>(DefaultPageService.java:282)
	at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
	at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:39)
	at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:27)
	at java.lang.reflect.Constructor.newInstance(Constructor.java:513)
	at com.webratio.rtx.core.ServiceProvider.createServiceFromClass(ServiceProvider.java:113)
	at com.webratio.rtx.core.ServiceProvider.createService(ServiceProvider.java:75)
	at com.webratio.rtx.core.DefaultRTXManager.getService(DefaultRTXManager.java:367)
	at com.webratio.rtx.core.DefaultRTXManager.getPageService(DefaultRTXManager.java:399)
	at com.webratio.struts.actions.PageAction.execute(PageAction.java:65)
	at org.apache.struts.chain.commands.servlet.ExecuteAction.execute(ExecuteAction.java:58)
	at org.apache.struts.chain.commands.AbstractExecuteAction.execute(AbstractExecuteAction.java:67)
	at org.apache.struts.chain.commands.ActionCommandBase.execute(ActionCommandBase.java:51)
	at org.apache.commons.chain.impl.ChainBase.execute(ChainBase.java:190)
	at org.apache.commons.chain.generic.LookupCommand.execute(LookupCommand.java:304)
	at org.apache.commons.chain.impl.ChainBase.execute(ChainBase.java:190)
	at org.apache.struts.chain.ComposableRequestProcessor.process(ComposableRequestProcessor.java:283)
	at org.apache.struts.action.ActionServlet.process(ActionServlet.java:1913)
	at com.webratio.struts.servlets.WRActionServlet.doGet(WRActionServlet.java:70)
	at javax.servlet.http.HttpServlet.service(HttpServlet.java:617)
	at javax.servlet.http.HttpServlet.service(HttpServlet.java:717)
	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290)
	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
	at org.jboss.web.tomcat.filters.ReplyHeaderFilter.doFilter(ReplyHeaderFilter.java:96)
	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
	at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:235)
	at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:191)
	at org.jboss.web.tomcat.security.SecurityAssociationValve.invoke(SecurityAssociationValve.java:190)
	at org.jboss.web.tomcat.security.JaccContextValve.invoke(JaccContextValve.java:92)
	at org.jboss.web.tomcat.security.SecurityContextEstablishmentValve.process(SecurityContextEstablishmentValve.java:126)
	at org.jboss.web.tomcat.security.SecurityContextEstablishmentValve.invoke(SecurityContextEstablishmentValve.java:70)
	at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:127)
	at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:102)
	at org.jboss.web.tomcat.service.jca.CachedConnectionValve.invoke(CachedConnectionValve.java:158)
	at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109)
	at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:330)
	at org.apache.coyote.ajp.AjpProcessor.process(AjpProcessor.java:436)
	at org.apache.coyote.ajp.AjpProtocol$AjpConnectionHandler.process(AjpProtocol.java:384)
	at org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:447)
	at java.lang.Thread.run(Thread.java:662)
Caused by: java.lang.ClassCastException: org.jboss.resource.adapter.jdbc.WrapperDataSource cannot be cast to javax.sql.DataSource
	at org.hibernate.connection.DatasourceConnectionProvider.configure(DatasourceConnectionProvider.java:75)
	... 64 more

Can you help me please?
Thanks a lot, regards

Lorenzo

[Lorenzo Rep]

I found in the war the "classes12.jar".

Removing it resolved the issues.