]
Dimitris Andreadis updated JBAS-2113:
-------------------------------------
Component/s: Scheduling/Timers
(was: EJB2)
Fix Version/s: (was: JBossAS-4.2.0.CR1)
Tables creation problem on Oracle
---------------------------------
Key: JBAS-2113
URL:
http://jira.jboss.com/jira/browse/JBAS-2113
Project: JBoss Application Server
Issue Type: Bug
Security Level: Public(Everyone can see)
Components: Scheduling/Timers
Affects Versions: JBossAS-4.0.3RC1, JBossAS-4.0.2 Final, JBossAS-4.0.2RC1,
JBossAS-4.0.1 SP1, JBossAS-4.0.1 Final
Environment: WindowsXp, Oracle 9i
Reporter: Martin Cerba
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.
--
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators: