|
From: Andreas O. <cpt...@gm...> - 2011-12-06 11:39:52
|
Hi Fabiano, perhaps you should try to use a "real" JDBC driver for dbase? You probably will have better chances for metadata retrieval with a real JDBC driver. You can download one free for trial at http://software.filestube.com/download,e13cb438,StelsDBF+JDBC+Driver.html I haven't found an open source driver yet but I shall keep my eyes open. Andreas Am 06.12.2011 11:02, schrieb Fabiano PS Bonin: > 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 > |
