I have installed ColdFusion 9 and ColdFusion Builder 1 and Firebird 2.1.2, Jaybird 2.1.6

Using CF9's Administrator, I have been able to set up two data sources, one ODBC and one JDBC, that each connect to my FB databases, and they appear in the CFB1's IDE and they connect ok, and I can see the table names, column names, I can even retrieve data, all in design time. However, when I try to "Run" the application, Hibernate throws an error, (for both types of connection... ODBC and JDBC) and the error is the same, which is:

Hibernate Dialect must be explicitly set for database: Firebird 2.11WI-V2.1.2.18118 Firebird 2.1/tcp (KALMIA-001)/P10

Franticly searching the Internet for a solution, all I could determine is that some how, I'm supposed to put this string somewhere:

org.hibernate.dialect.FirebirdDialect

I cannot find any Hibernate configuration files on my PC. I'm using Jaybird (Firebird's JDBC connector). Can some one load up CF9 and tell me what file or setting I am supposed to change or where I'm to put the ".dialect." line? I'm hoping this will solve the problem for both the ODBC and JDBC connection problems. Thanks in advance.

Please see the page:

http://forums.adobe.com/thread/497876?tstart=0

Use your browser's "Find" function to locate the following file name on the page:

CF9_FB2_DataSource_2009-SEP-26.pdf

These are the instructions I typed up to help all CF9, CFB1 "newbies" (like me) to start building ColdFusion applications with a Firebird back end.