JPA + Hibernate + Oracle + FireBird

Erro com o JPA conectando em dois bancos : Oracle e Firebird

Pessoal,
estou com um problema na minha aplicação, estou utilizando o jpa onde conecto com 2 bancos Oracle e firebird. A conexão com o Oracle está ok , mas quando eu coloco o Firebird na jogada me gera o seguinte erro:

Exception in thread “main” javax.persistence.PersistenceException: org.hibernate.HibernateException: Hibernate Dialect must be explicitly set for database: Interbase
at org.hibernate.ejb.Ejb3Configuration.buildEntityManagerFactory (Ejb3Configuration.java:698)
at org.hibernate.ejb.HibernatePersistence.createEntityManagerFactory(HibernatePersistence.java:121)
at javax.persistence.Persistence.createEntityManagerFactory(Persistence.java:51)
at javax.persistence.Persistence.createEntityManagerFactory(Persistence.java:33)
at siace.web.teste.TesteOracle.main(TesteOracle.java:25)
Caused by: org.hibernate.HibernateException: Hibernate Dialect must be explicitly set for database: Interbase
at org.hibernate.dialect.DialectFactory.determineDialect(DialectFactory.java:62)
at org.hibernate.dialect.DialectFactory.buildDialect(DialectFactory.java:39)
at org.hibernate.cfg.SettingsFactory.determineDialect (SettingsFactory.java:409)
at org.hibernate.cfg.SettingsFactory.buildSettings(SettingsFactory.java:119)
at org.hibernate.cfg.Configuration.buildSettings(Configuration.java:1933)
at org.hibernate.cfg.Configuration.buildSessionFactory (Configuration.java:1216)
at org.hibernate.ejb.Ejb3Configuration.buildEntityManagerFactory(Ejb3Configuration.java:691)
… 4 more

segue a minha persistence.xml

<?xml version="1.0 " encoding=“UTF-8”?>
<persistence xmlns=“http://java.sun.com/xml/ns/persistence"
xmlns:xsi=” http://www.w3.org/2001/XMLSchema-instnce"
xsi:schemaLocation="http://jsvs.sun.com/xml/ns/persistence
http://java.sun.com/xml/ns/persistence/persistence_1_0.xsd"
version=“1.0”>

&lt;persistence-unit name="analisePU"
    transaction-type="RESOURCE_LOCAL"&gt;
    &lt;provider&gt;org.hibernate.ejb.HibernatePersistence&lt;/provider&gt;
    &lt;properties&gt;
        &lt;property name="hibernate.connection.driver_class"
            value=" oracle.jdbc.driver.OracleDriver" /&gt;
        &lt;property name="hibernate.connection.username"
            value="xxxxxx" /&gt;
        &lt;property name="hibernate.connection.password "
            value="aaaaaaaa" /&gt;
        &lt;property name="hibernate.connection.url"
            value="jdbc:oracle:thin:@172.30.9.66:1521:siace01" /&gt;
        &lt;property name=" hibernate.connection.dialect"
            value="org.hibernate.dialect.Oracle9Dialect" /&gt;
        &lt;property name="hibernate.show_sql" value="true" /&gt;
    &lt;/properties&gt;
&lt;/persistence-unit&gt;

&lt;persistence-unit name="remessaPU"
    transaction-type="RESOURCE_LOCAL"&gt;
    &lt;provider&gt;org.hibernate.ejb.HibernatePersistence&lt;/provider&gt;
    &lt;properties&gt;
        &lt;property name="hibernate.connection.driver_class"
            value="org.firebirdsql.jdbc.FBDriver" /&gt;
        &lt;property name=" hibernate.connection.username"
            value="sysdba" /&gt;
        &lt;property name="hibernate.connection.password"
            value="masterkey" /&gt;
        &lt;property name=" hibernate.connection.url"
            value="jdbc:firebirdsql:localhost/3050:C:\\master.gdb" /&gt;
         &lt;property name="hibernate.connection.dialect"
            value=" org.hibernate.dialect.FirebirdDialect" /&gt;
        &lt;property name="hibernate.show_sql" value="true" /&gt;
    &lt;/properties&gt;
&lt;/persistence-unit&gt;

</persistence>

Será que alguém sabe o que está acontecendo?
Já não sei mais o q fazer com o firebird…

Abraços

Marcelo

Tente usar este modelo, está configuração funciona OK com o toplink da oracle (Que também implenta a JPA)

Troce as conf. do topLink pelos do hibernate

		&lt;properties&gt;
			&lt;property name=&quot;toplink.jdbc.driver&quot; value=&quot;org.firebirdsql.jdbc.FBDriver&quot; /&gt;
			&lt;property name=&quot;toplink.jdbc.url&quot; value=&quot;jdbc&#58;firebirdsql&#58;localhost/3050&#58;C&#58;/java/banco/locadora.fdb&quot; /&gt;
			&lt;property name=&quot;toplink.jdbc.user&quot; value=&quot;SYSDBA&quot; /&gt;
			&lt;property name=&quot;toplink.jdbc.password&quot; value=&quot;masterkey&quot; /&gt;
			&lt;property name=&quot;toplink.logging.level&quot; value=&quot;INFO&quot; /&gt;
		&lt;/properties&gt;

Gilberto,
valeu deu certo com o topLink.

Engraçado com o Hobernate não vai nem por reza brava.

Muito obrigado