[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.

Sun Oct 5 22:36:21 EDT 2008

     [ https://jira.jboss.org/jira/browse/JBRULES-1651?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Mark Proctor updated JBRULES-1651:
----------------------------------

      Component/s: drools-guvnor
    Fix Version/s: 5.0.0.M3
         Assignee: Michael Neale  (was: Mark Proctor)


> 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/jira/browse/JBRULES-1651
>             Project: JBoss 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.0.0.M3
>
>         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

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