8:19 a.m.
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: Jesper Pedersen
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
8:19 a.m.
New subject: [JBoss JIRA] Updated: (JBAS-6305) Error installing KeyGeneratorFactory with some databases
[
https://jira.jboss.org/jira/browse/JBAS-6305?page=com.atlassian.jira.plug...
]
Martin Malina updated JBAS-6305:
--------------------------------
Attachment: oracle10g.log
Attached the AS output log.
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: Jesper Pedersen
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
2:38 p.m.
New subject: [JBoss JIRA] Assigned: (JBAS-6305) Error installing KeyGeneratorFactory with some databases
[
https://jira.jboss.org/jira/browse/JBAS-6305?page=com.atlassian.jira.plug...
]
Rajesh Rajasekaran reassigned JBAS-6305:
----------------------------------------
Assignee: Martin Malina (was: Jesper Pedersen)
Martin, can you give a shot at fixing the example file?
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
10:09 a.m.
New subject: [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:
-------------------------------------
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/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
8:31 a.m.
New subject: [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
11:30 p.m.
New subject: [JBoss JIRA] Updated: (JBAS-6305) Error installing KeyGeneratorFactory with some databases
[
https://jira.jboss.org/jira/browse/JBAS-6305?page=com.atlassian.jira.plug...
]
Jason T. Greene updated JBAS-6305:
----------------------------------
Fix Version/s: JBossAS-5.1.0.CR1
(was: JBossAS-5.1.0.Beta1)
Moving to CR1.
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.CR1
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
1:48 p.m.
New subject: [JBoss JIRA] Updated: (JBAS-6305) Error installing KeyGeneratorFactory with some databases
[
https://jira.jboss.org/jira/browse/JBAS-6305?page=com.atlassian.jira.plug...
]
Jason T. Greene updated JBAS-6305:
----------------------------------
Affects Version/s: No Release
(was: JBossAS-5.0.0.GA)
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: 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/jira/secure/Administrators.jspa
-
For more information on JIRA, see: http://www.atlassian.com/software/jira
1:48 p.m.
New subject: [JBoss JIRA] Closed: (JBAS-6305) Error installing KeyGeneratorFactory with some databases
[
https://jira.jboss.org/jira/browse/JBAS-6305?page=com.atlassian.jira.plug...
]
Jason T. Greene closed JBAS-6305.
---------------------------------
Fix Version/s: No Release
(was: JBossAS-5.1.0.CR1)
Resolution: Cannot Reproduce Bug
This looks like an Oracle permissions issue. Reopen if a code problem is actually found.
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: 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/jira/secure/Administrators.jspa
-
For more information on JIRA, see: http://www.atlassian.com/software/jira
4:12 a.m.
New subject: [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
5858
days inactive
6425
days old
8 comments
4 participants
participants (4)
-
Jason T. Greene (JIRA) -
Martin Malina (JIRA)
-
Nitesh S (JIRA)
-
Rajesh Rajasekaran (JIRA)