[jboss-jira] [JBoss JIRA] Commented: (JBAS-6305) Error installing KeyGeneratorFactory with some databases

[Martin Malina (JIRA)]

    [ https://jira.jboss.org/jira/browse/JBAS-6305?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=12450280#action_12450280 ] 

Martin Malina commented on JBAS-6305:
-------------------------------------

Rajesh, you are right, the cause is probably similar as in the case of JBAS-6304. This time the table is defined in server/all/deploy/uuid-key-generator.sar/META-INF/jboss-service.xml . I will try to check the Oracle log to see what is the problem with the table type.

> Error installing KeyGeneratorFactory with some databases
> --------------------------------------------------------
>
>                 Key: JBAS-6305
>                 URL: https://jira.jboss.org/jira/browse/JBAS-6305
>             Project: JBoss Application Server
>          Issue Type: Bug
>      Security Level: Public(Everyone can see) 
>          Components: JCA service
>    Affects Versions: JBossAS-5.0.0.GA
>         Environment: Oracle10g, DB2 v9
>            Reporter: Martin Malina
>            Assignee: Martin Malina
>             Fix For: JBossAS-5.1.0.Beta1
>
>         Attachments: oracle10g.log
>
>
> After setting up Oracle10g as the DefaultDS using this docs: http://www.jboss.org/file-access/default/members/jbossas/freezone/docs/Installation_And_Getting_Started_Guide/5/html_single/index.html#Configuring_a_datasource_for_Oracle_DB 
> and starting the AS instance with "all" config, this error occured: 
> 07:21:29,553 ERROR [AbstractKernelController] Error installing to Start: name=jboss:service=KeyGeneratorFactory,type=HiLo state=Create mode=Manual requiredState=Installed
> java.sql.SQLException: ORA-00942: table or view does not exist
> 	at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:112)
> 	at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:331)
> ....
> *** CONTEXTS IN ERROR: Name -> Error
> jboss:service=KeyGeneratorFactory,type=HiLo -> java.sql.SQLException: ORA-00942: table or view does not exist
> Similar thing happens with DB2 v9.

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