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#...
Reply to the post :
http://www.jboss.com/index.html?module=bb&op=posting&mode=reply&a...