[jboss-jira] [JBoss JIRA] Commented: (JBAS-6305) Error installing KeyGeneratorFactory with some databases
[
https://jira.jboss.org/jira/browse/JBAS-6305?page=com.atlassian.jira.plug...
]
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/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/jira/secure/Administrators.jspa
-
For more information on JIRA, see: http://www.atlassian.com/software/jira