[jboss-jira] [JBoss JIRA] Assigned: (JBAS-2113) Tables creation problem on Oracle

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.1 Final, JBossAS-4.0.2 Final, JBossAS-4.0.2RC1, JBossAS-4.0.1 SP1, JBossAS-4.0.3RC1 Environment: WindowsXp, Oracle 9i Reporter: Martin Cerba Assigned To: Dimitris Andreadis 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.