2 Replies Latest reply on Apr 29, 2008 10:40 PM by Fazreil Amreen Abdul Jalil

    own portlet's table is not build in oracle

    Fazreil Amreen Abdul Jalil Newbie

      Hi, I used jboss portal 2.6.3 and Jboss AS 4.2. Running on windows XP sp2 and using Oracle10g XE as my db.

      I don't use SYSTEM for the db instead my portal ds looks like this:

      <datasources>
       <local-tx-datasource>
       <jndi-name>PortalDS</jndi-name>
       <connection-url>jdbc:oracle:thin:fab/password@localhost:1521:XE</connection-url>
       <driver-class>oracle.jdbc.driver.OracleDriver</driver-class>
       <user-name>fab</user-name>
       <password>password</password>
       </local-tx-datasource>
      </datasources>
      


      in the logfile, hibernates always look for tables from SYSTEM
      like:
      SYSTEM.jbp_table1
      instead of:
      FAB.jbp_table1

      this problem occurs for portlets that I made. inside the FAB's db are all JBoss tables.