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

Thu Jun 19 09:11:37 EDT 2008

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: http://jira.jboss.com/jira/browse/JBRULES-1651
             Project: JBoss Drools
          Issue Type: Bug
      Security Level: Public (Everyone can see)
         Environment: weblogic, oracle, jdk1.5, windows
            Reporter: santosh gadkari
         Assigned To: Mark Proctor

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

-- 
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators: http://jira.jboss.com/jira/secure/Administrators.jspa
-
For more information on JIRA, see: http://www.atlassian.com/software/jira