[jboss-jira] [JBoss JIRA] Updated: (JBRULES-1651) deploying BRMS web app - drools-jbrms.war throws java.sql.SQLException: ORA-00902: invalid datatype Exception when used with Oracle database.

deploying BRMS web app - drools-jbrms.war throws java.sql.SQLException: ORA-00902: invalid datatype Exception when used with Oracle database. ---------------------------------------------------------------------------------------------------------------------------------------------- Key: JBRULES-1651 URL: https://jira.jboss.org/browse/JBRULES-1651 Project: Drools Issue Type: Bug Security Level: Public(Everyone can see) Components: drools-guvnor Environment: weblogic, oracle, jdk1.5, windows Reporter: santosh gadkari Assignee: Michael Neale Fix For: 5.1.0.CR1 Attachments: repository.xml Original Estimate: 30 minutes Remaining Estimate: 30 minutes We want to move from filebased darby database to our Oracle database to store rules. We made the changes in the repository.xml and provided url,connection string etc. but after that we came across "java.sql.SQLException: ORA-00902: invalid datatype" Exceptions. Please provide suitable solution for the same. find the stack trace as below, <19-Jun-2008 21:04:31 o'clock SGT> <Error> <Deployer> <BEA-149231> <Unable to set the activation state to true for the application 'brms'. weblogic.application.ModuleException: at weblogic.servlet.internal.WebAppModule.startContexts(WebAppModule.java:894) at weblogic.servlet.internal.WebAppModule.start(WebAppModule.java:336) at weblogic.application.internal.flow.ModuleStateDriver$3.next(ModuleStateDriver.java:204) at weblogic.application.utils.StateMachineDriver.nextState(StateMachineDriver.java:26) at weblogic.application.internal.flow.ModuleStateDriver.start(ModuleStateDriver.java:60) Truncated. see log file for complete stacktrace java.sql.SQLException: ORA-00902: invalid datatype at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:112) at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:331) at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:288) at oracle.jdbc.driver.T4C8Oall.receive(T4C8Oall.java:743) at oracle.jdbc.driver.T4CStatement.doOall8(T4CStatement.java:207) Truncated. see log file for complete stacktrace