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

[Nitesh S (JIRA)]

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

Nitesh S commented on JBAS-6305:
--------------------------------

I faced same issue on oracle with JBoss 5.1.0.GA

The problem is that....
SQLUtil.tableExists(tableName, ds) returns true if table "HILOSEQUENCES" 
is present on same oracle host but on some another schema.

SQLUtil.tableExists() method uses following query to find out 
db table existence...

SELECT NULL AS table_cat,
       o.owner AS table_schem,
       o.object_name AS table_name,
       o.object_type AS table_type,
       NULL AS remarks
  FROM all_objects o
  WHERE o.owner LIKE :1 ESCAPE '/'
    AND o.object_name LIKE :2 ESCAPE '/'
    AND o.object_type IN ('TABLE', 'SYNONYM', 'VIEW')
  ORDER BY table_type, table_schem, table_name


In HiLoKeyGeneratorFactory.createTableIfNotExists(String tableName) ....
tableName is "HILOSEQUENCES" instead of "#SCHEMA#.HILOSEQUENCES"


> Error installing KeyGeneratorFactory with some databases
> --------------------------------------------------------
>
>                 Key: JBAS-6305
>                 URL: https://jira.jboss.org/browse/JBAS-6305
>             Project: JBoss Application Server
>          Issue Type: Bug
>      Security Level: Public(Everyone can see) 
>          Components: JCA service
>    Affects Versions: No Release
>         Environment: Oracle10g, DB2 v9
>            Reporter: Martin Malina
>            Assignee: Martin Malina
>             Fix For: No Release
>
>         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/secure/Administrators.jspa
-
For more information on JIRA, see: http://www.atlassian.com/software/jira