[jboss-jira] [JBoss JIRA] Commented: (JBAS-6305) Error installing KeyGeneratorFactory with some databases
[
https://jira.jboss.org/browse/JBAS-6305?page=com.atlassian.jira.plugin.sy...
]
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/In...
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