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

[Edson Tirelli (JIRA)]

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

Edson Tirelli updated JBRULES-1651:
-----------------------------------

    Fix Version/s: 5.1.0.M1
                       (was: 5.0.1.FINAL)


> 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.1.0.M1
>
>         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