|
From: Fabiano PS B. <fa...@pe...> - 2011-12-06 13:56:32
|
Do you have enought control over the DDL generation process to 'bypass' unkown mappings? Or it is entirelly processed by hibernate? Ex: I think it would be better to have a script with invalid colums types wich we could finish manually than to have nothing. create table test ( id NUMERIC(15,4) /*unable to map - using original mapping*/, ... I will fill the feature request as you suggested. Regards, Fabiano On Tue, Dec 6, 2011 at 9:26 AM, Robert Manning <rob...@gm...> wrote: > 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 > > |
