4 Replies Latest reply on Sep 9, 2002 5:33 PM by Dain Sundstrom

    JBoss cannot find table when schema name is included!

    Alexey Maslov Newbie

      We have an application that uses Oracle 9i database. We had to add schema name to table names to use schema that differs from the user's login name. Now table declaration for entity bean looks this way:
      SCHEMA_NAME.TABLE_NAME
      so we have the following line in jbosscmp-jdbc.xml:
      <table-name>SCHEMA_NAME.TABLE_NAME</table-name>
      instead of
      <table-name>TABLE_NAME</table-name>
      But it doesn't seem to work properly. During startup JBoss tries to create this table. If we remove SCHEMA_NAME everything works fine but we have to use user login identical to schema name and that's not possible! :(
      Under WebLogic 7.0 everything works fine either with schema name or without it.
      Please, help. I don't know how to handle this situation. Seems that we'll have to go back to WebLogic :(

      P.S. We're using JBoss 3.0.2, Oracle 9i rel. 2, Oracle JDBC driver.