[jboss-user] [Persistence, JBoss/CMP, Hibernate, Database] - Firebird Portal Problem

[visnaidu]

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>


View the original post : http://www.jboss.com/index.html?module=bb&op=viewtopic&p=4042928#4042928

Reply to the post : http://www.jboss.com/index.html?module=bb&op=posting&mode=reply&p=4042928