Something must be going around today...
This is not a JCA problem.
Reason: org.hibernate.HibernateException: Hibernate Dialect must be explicitly set for database: F
Basically Hibernate (the underlying Entity persistence manager) is telling you that you need to specify the Hibernate dialect in your persistence.xml file.
With all due respect:
(1) these were exactly the kinds of questions that were considered JCA problems when this forum was created--I know that, because I posted here on a couple occasions at that time and obtained helpful answers;
(2) a search of the forums for this Firebird database connection problems shows that they *only* appear in this forum;
(3) it is in the nature of this kind of question that where the solution lies is not obvious--JCA is certainly involved here; and
(4) I still have no idea how to fix the problem, nor where to go for an answer.
I followed all the instructions about how to set this up both in Burke's book and on the Firebird website. Why is Hibernate intruding here at all since the JCA connection being made is to Firebird via the two XML files? How does one specify the Hibernate dialect in a persistence.xml file, or find out how to do so? Thank you.
<?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"/> <property name="hibernate.dialect" value="org.hibernate.dialect.FirebirdDialect"/> </properties> </persistence-unit> </persistence>
The reason Hibernate is 'intruding' is the your Persistence Provider, *Hibernate*, is telling you that he cannot automatically obtain type mappings and metadata for your platform of choice: *Firebird*.
Also, I believe the mechanism for the Firebird JDBC configuration has changed recently, but I have to confirm this.
Thank you for your reply. That seems to have fixed the problem. If you do learn something about a change to the Firebird configuration (due to the anticipated FB 2.0 release possibly?), perhaps you could post it to this forum.
I will be looking at is as an update for the JCA handling of the Firebird driver. Any updates will be posted to the Wiki along with documentation changes. I just have to find the time to check it all in :-)