-
Bug
-
Resolution: Done
-
Major
-
JBossAS-4.0.1 Final, JBossAS-4.0.1 SP1, JBossAS-4.0.2RC1, JBossAS-4.0.2 Final, JBossAS-4.0.3RC1
-
None
When Jboss is configured to use Oracle 9i DB for tables TIMERS table is not created when user for logging is changed.
I found problem in org.jboss.ejb.plugins.cmp.jdbc.SQLUtil class in function
public static boolean tableExists(String tableName, DataSource dataSource)
This function use JDBC3 functionality getTables(catalog, schema, tableName, null) to check for table existence where schema parameter is set to null.
On Oracle this function check all schemas (users) for table existence (user had DBA privilegies set) and may find TIMERS table under different user.
Then jboss assume TIMERS as existing.
I put username to schema parameter and it repairs problem on oracle but then it not works under hypersonic.
- is blocked by
-
JBAS-4042 Allow configuration of timers table name (and schema)
- Closed
- relates to
-
JBPAPP-132 Error creating TIMERS and HILOSEQUENCES table when the same table exists under a different schema in Oracle9i
- Closed