0 Replies Latest reply on Oct 4, 2007 7:32 AM by Evgeny Dontsov

    Error dialect Firebird (Hibernate)

    Evgeny Dontsov Newbie

      Sorry bad English.
      Put driver jaybird-2.1.1.jar in directory .\server\default\lib\.
      Put portal-firebird-ds.xml in server\default\deploy\.

      <datasources>
      <local-tx-datasource>
      <jndi-name>PortalDS</jndi-name>
      <connection-url>jdbc:firebirdsql:localhost:d:\\test.fdb</connection-url>
      <driver-class>org.firebirdsql.jdbc.FBDriver</driver-class>
      <user-name>sysdba</user-name>
      <password>masterkey</password>
      </local-tx-datasource>
      </datasources>
      

      Modifide jboss-portal.sar/conf/hibernate/[module]/hibernate.cfg.xml
      <!--
      <property name="dialect">org.hibernate.dialect.PostgreSQLDialect</property>
      -->

      to
      <property name="dialect">org.hibernate.dialect.FirebirdDialect</property>


      JBossPortal error:
      Hibernate Dialect must be explicitly set for database: Firebird 1.55WI-V1.5.3.4870 Firebird 1.5/tcp