|
From: Robert M. <rob...@gm...> - 2011-12-06 11:26:37
|
At the moment there is no quick work-around for this. It's questionable how helpful this would be given that the JDBC-ODBC bridge is considered "experimental" and "unsupported". In other words, this driver could very well be giving nonsense values for field types, lengths, precision, scale, null-ability, etc. In any case, you can submit a feature request here, and I will look into beefing up the generic dialect (which is used when no other dialect is appropriate): http://sourceforge.net/tracker/?atid=393417&group_id=28383 Rob On Tue, Dec 6, 2011 at 5:02 AM, Fabiano PS Bonin < fa...@pe...> wrote: > 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 > > > ------------------------------------------------------------------------------ > Cloud Services Checklist: Pricing and Packaging Optimization > This white paper is intended to serve as a reference, checklist and point > of > discussion for anyone considering optimizing the pricing and packaging > model > of a cloud services business. Read Now! > http://www.accelacomm.com/jaw/sfnl/114/51491232/ > _______________________________________________ > Squirrel-sql-users mailing list > Squ...@li... > https://lists.sourceforge.net/lists/listinfo/squirrel-sql-users > |
