I have changed the default table and column names that were causing issues.
https://jira.jboss.org/jira/browse/JBRULES-2448 If there are additional issues, please add a comment on this JIRA. Kris Quoting wytten <[email protected]>: > > The changes I made for Oracle were: > 1. Add ojdbc5 11.1.0.7.0 to classpath > 2. Change the hibernate.dialect in persistence.xml to > org.hibernate.dialect.Oracle9Dialect > 3. Use oracle.jdbc.xa.client.OracleXADataSource for the > PoolingDataSource > class name > > The tables will be created depending on how you have persistence.xml > configured (I used hibernate.hbm2ddl.auto value 'create') > However, I did experience a problem with the eventTypes member of > ProcessInstanceInfo: > 'create table ProcessInstanceInfo_eventTypes' yields the error > 'ORA-00972: > identifier is too long'. > > The team is aware of this but I haven't seen a fix yet. > > Hope this helps. > > > ramram wrote: > > > > Hi All, > > > > I have been using the H2 in memory database to test all my Drools > Flow > > scenarios using Guvnor and Gwt Console provided. And I have some > questions > > to ask and was wondering if someone can help. The main plan now is > to > > switch > > from using the H2 in memory database to Persist using the Oracle > database. > > > > 1- What are the files that should be affected in this switch? or > where > > should I be looking into? > > 2- Are the tables created dynamically? and under which schema? > > 3- is there any test case implemented using this technology? > > > > Thnx in advance for your help > > > > Regards, > > Ram > > > -- > View this message in context: > http://n3.nabble.com/Persistence-issue-using-Oracle-tp417257p422087.html > Sent from the Drools - User mailing list archive at Nabble.com. > _______________________________________________ > rules-users mailing list > [email protected] > https://lists.jboss.org/mailman/listinfo/rules-users > Disclaimer: http://www.kuleuven.be/cwis/email_disclaimer.htm _______________________________________________ rules-users mailing list [email protected] https://lists.jboss.org/mailman/listinfo/rules-users
