[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=12450842#action_12450842 ] 

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

The failure occurs in server/src/main/org/jboss/ejb/plugins/keygenerator/hilo/HiLoKeyGeneratorFactory.java. It is trying to read from the table while the service is being started (method initSequence). 

The table should have been created in this method:

   private void createTableIfNotExists(String tableName)
      throws SQLException, DeploymentException
   {
      Connection con = null;
      Statement st = null;
      try
      {
         if(!SQLUtil.tableExists(tableName, ds))
         {
            log.debug("Executing DDL: " + createTableDdl);
...

For some reason the condition is evaluated incorrectly and the table is not created. (I confirmed that after removing the condition, the service starts correctly.)


> 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