[mrman]

Previous post had some formatting error. Repeated here for clarity.

Kevin. I don't think it's the data source as all the other tables are being created properly on start-up. I just think whatever changes have been made since the previous version; regarding SQL scripts, are the root cause. However, for completeness, I'm including my -ds.xml file below. We are currently using Oracle 10g.

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

<datasources>
 <local-tx-datasource>
 <jndi-name>DefaultDS</jndi-name>
 <connection-url>jdbc:oracle:thin:@xx.xx.xx.xx:1521:MYSID</connection-url>
 <driver-class>oracle.jdbc.driver.OracleDriver</driver-class>
 <user-name>username</user-name>
 <password>pwd</password>
 <exception-sorter-class-name>org.jboss.resource.adapter.jdbc.vendor.OracleExceptionSorter</exception-sorter-class-name>
 <check-valid-connection-sql>select count(*) from jbm_user</check-valid-connection-sql>

 <metadata>
 <type-mapping>Oracle9i</type-mapping>
 </metadata>
 </local-tx-datasource>
</datasources>

[kconner]

"mrman" wrote:
Kevin. I don't think it's the data source as all the other tables are being created properly on start-up.

I am sure you are right but it helps to have a more complete picture.

Kev

[wollint]

Is there any update on this?

[kconner]

Sorry, we have all been busy preparing and attending J1.

We are now back, so I should have time to investigate this week.

Kev

[kconner]

Apologies for the delay in responding.

I have just been through our current drools integration and removed a number of drools jars, including some which rely on hibernate persistence. https://jira.jboss.org/jira/browse/JBESB-2736 contains a list of the jars which have been removed.

Two of those jars specifically interfere with the deployment of EJBs and may be relevant to your issue. We will soon be releasing ESB 4.6, would you be able to try this out to see if it fixes your issue?

Thanks,
Kev

[mrman]

Kev,

I've tested the new release of the ESB [4.6] and everything appears to be working fine. No more drools and Oracle issues.

Cheers