Uploaded image for project: 'Application Server 3  4  5 and 6'
  1. Application Server 3 4 5 and 6
  2. JBAS-2113

Tables creation problem on Oracle

XMLWordPrintable

      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.

              dandread1@redhat.com Dimitrios Andreadis
              alkalimero Martin Cerba (Inactive)
              Votes:
              0 Vote for this issue
              Watchers:
              0 Start watching this issue

                Created:
                Updated:
                Resolved: