[Squirrel-sql-users] Error in 'create table' script

[Fabiano PS B. <fa...@pe...>]

Hi all!

I´m using Squirrel to connect to a legacy DBASE IV database using
"JDBC ODBC Bridge", provided with Squirrel.

My plan is to get the DDL (create table) of the tables in the legacy
database and recreate them in my own database (Firebird), and later
have an ETL tool populating these tables with fresh data.

When i try to get the create table script, i get this error:

JDBC-ODBC Bridge doesn't provide all of the necessary metadata. The
script may be incomplete.
org.hibernate.MappingException: No Dialect mapping for JDBC type: 8

The problem is happening with 'numeric' colums (at least).

So my questions are:

* Can i override this mapping somehow?
* Is there some fast workaround available?
* If changing hibernate dialect works, where should i put the
hibernate.cfg.xml file so Squirrel loads it, and which dialect should
i use to be able to have this mapping working?

Regards,

Fabiano