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”>
<persistence-unit name="analisePU"
transaction-type="RESOURCE_LOCAL">
<provider>org.hibernate.ejb.HibernatePersistence</provider>
<properties>
<property name="hibernate.connection.driver_class"
value=" oracle.jdbc.driver.OracleDriver" />
<property name="hibernate.connection.username"
value="xxxxxx" />
<property name="hibernate.connection.password "
value="aaaaaaaa" />
<property name="hibernate.connection.url"
value="jdbc:oracle:thin:@172.30.9.66:1521:siace01" />
<property name=" hibernate.connection.dialect"
value="org.hibernate.dialect.Oracle9Dialect" />
<property name="hibernate.show_sql" value="true" />
</properties>
</persistence-unit>
<persistence-unit name="remessaPU"
transaction-type="RESOURCE_LOCAL">
<provider>org.hibernate.ejb.HibernatePersistence</provider>
<properties>
<property name="hibernate.connection.driver_class"
value="org.firebirdsql.jdbc.FBDriver" />
<property name=" hibernate.connection.username"
value="sysdba" />
<property name="hibernate.connection.password"
value="masterkey" />
<property name=" hibernate.connection.url"
value="jdbc:firebirdsql:localhost/3050:C:\\master.gdb" />
<property name="hibernate.connection.dialect"
value=" org.hibernate.dialect.FirebirdDialect" />
<property name="hibernate.show_sql" value="true" />
</properties>
</persistence-unit>
</persistence>
Será que alguém sabe o que está acontecendo?
Já não sei mais o q fazer com o firebird…
Abraços
Marcelo