0 Replies Latest reply on Jul 6, 2006 10:32 PM by knaveofhearts

    JBoss AS/Firebird: Hibernate Dialect must be explicitly set?

    knaveofhearts Newbie

      I am trying to get JBoss to run the most simple Titan example (4.1) in Burke & Monson-Haefel, Enterprise Java Beans 3.0 using Firebird 1.5. The JBoss version is 4.0.4.GA.

      Any help would be appreciated in addressing the following problem:


      --- MBEANS THAT ARE THE ROOT CAUSE OF THE PROBLEM ---
      ObjectName: persistence.units:jar=titan.jar,unitName=titan
      State: FAILED
      Reason: org.hibernate.HibernateException: Hibernate Dialect must be explicitly set for database: Firebird 1.5>LI-V1.5.3.4870 Firebird 1.5/tcp (mulder.vorticityCorp.com)/P10
      I Depend On:
      jboss.jca:service=ManagedConnectionFactory,name=FIrebirdDS
      Depends On Me:
      jboss.j2ee:jar=titan.jar,name=TravelAgentBean,service=EJB3


      The persistence.xml file:

      <?xml version="1.0" encoding="UTF-8"?>
      <persistence>
      <persistence-unit name="titan">
      <jta-data-source>java:/FirebirdDS</jta-data-source>
      <properties>
      <property name="hibernate.hbm2ddl.auto" value="create-drop"/>
      </properties>
      </persistence-unit>
      </persistence>


      The titandb-ds.xml file:
      <?xml version="1.0" encoding="UTF-8"?>

      <connection-factories>

      <mbean code="org.firebirdsql.management.FBManager" name="jboss.jca:service=FirebirdManager">
      <attribute name="FileName">/vc/db/firebird/titan.fdb</attribute>
      <attribute name="UserName">jboss</attribute>
      <attribute name="Password">XXX</attribute>
      <attribute name="CreateOnStart">true</attribute>
      <attribute name="DropOnStop">false</attribute>
      </mbean>

      <tx-connection-factory>
      <jndi-name>FirebirdDS</jndi-name>
      <xa-transaction/>
      <track-connection-by-tx/>
      <rar-name>jaybird-2.0.1.rar</rar-name>
      <connection-definition>javax.sql.DataSource</connection-definition>
      <config-property name="Database" type="java.lang.String">localhost/3050:/vc/db/firebird/titan.fdb</config-property>
      <user-name>jboss</user-name>
      <password>XXX</password>
      <min-pool-size>0</min-pool-size>
      <metadata>
      <type-mapping>Firebird</type-mapping>
      </metadata>
      </tx-connection-factory>

      </connection-factories>