0 Replies Latest reply on May 3, 2007 1:39 PM by Vis Naidu

    Firebird Portal Problem

    Vis Naidu Newbie

      Hello all,

      I changed the PortalDS from the default Hypersonic to Firebird. I also forced the dialect in the hibernate.cfg.xml for Instance, Portal, Portlet, User and CMS to FirebirdDialect. The datasource deploys fine but the tables required for Portal are not created automatically at startup as they should be.

      However I can go to the JMX console (http://localhost:8080/jmx-console/) and call up each one of the following MBeans :
      # service=Hibernate
      # service=Hibernate,type=CMS
      # service=Hibernate,type=Instance
      # service=Hibernate,type=PortalObject
      # service=Hibernate,type=Portlet
      and then invoke createSchema() and createContent() by clicking on the respective buttons. This action creates the required schemas and populates the tables with data and all is well.

      Is this approach correct for Firebird as a datasource or should the schemas be created at startup.

      Thank you.

      ====
      JBoss Portal 2.4.0 and 2.6.0-CR1 bundled downloads
      Firebird 2.0.1
      Jaybird 2.1.1
      JDK1.5.0_10
      Windows XP SP2
      ====
      portal-firebird-ds.xml

      <local-tx-datasource>
      <jndi-name>PortalDS</jndi-name> <connection-url>jdbc:firebirdsql://vsn-nx7010:3050/${jboss.server.data.dir}${/}fbtest.fdb</connection-url>
      <driver-class>org.firebirdsql.jdbc.FBDriver</driver-class>
      <user-name>SYSDBA</user-name>
      masterkey
      <min-pool-size>5</min-pool-size>
      <max-pool-size>20</max-pool-size>
      <track-statements/>

      <type-mapping>Firebird</type-mapping>

      </local-tx-datasource>