[jboss-jira] [JBoss JIRA] Assigned: (JBAS-2113) Tables creation problem on Oracle
Dimitris Andreadis (JIRA)
jira-events at lists.jboss.org
Fri Apr 13 07:16:58 EDT 2007
[ http://jira.jboss.com/jira/browse/JBAS-2113?page=all ]
Dimitris Andreadis reassigned JBAS-2113:
----------------------------------------
Assignee: Dimitris Andreadis
> 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.
--
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
More information about the jboss-jira
mailing list