[
http://jira.jboss.com/jira/browse/JBESB-1127?page=comments#action_12384041 ]
Jiri Pechanec commented on JBESB-1127:
--------------------------------------
Hi,
it should be probably better to put this issue under SOA project but leave it is as.
Check uuid-key-generator.sar/META-INF/jboss-service.xml.
There is an attribute named TableName. During the startup this service tries to do select
on this table and if it exists in different schema then it succeds (maybe global synonyms
or whatever). So it will not create table in current schema and subsequent SQL statements
fails.
If you will change the table name to username.tablename then this service runs smoothly as
the probe select will fail and new table in current schema is created.
UUID service startup fails when using Oracle database
-----------------------------------------------------
Key: JBESB-1127
URL:
http://jira.jboss.com/jira/browse/JBESB-1127
Project: JBoss ESB
Issue Type: Bug
Security Level: Public(Everyone can see)
Components: Configuration, Documentation
Affects Versions: 4.2.1 IR1
Reporter: Jiri Pechanec
Assigned To: Kurt Stam
Priority: Minor
Fix For: 4.2.1
If the UUID service should create the table for UUID generators and in another schema in
the same database the table exists then it is false identified as already existing in
current user scheme. The workaround is to use table name in jboss-service.xml file fully
qualified inluding schema name.
This fact should be stated in the comment of the file or in the documentation.
--
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators:
http://jira.jboss.com/jira/secure/Administrators.jspa
-
For more information on JIRA, see:
http://www.atlassian.com/software/jira