|
From: Fabiano PS B. <fa...@pe...> - 2011-12-06 13:50:59
|
Wow! A JDBC driver for DBASE! Amazing! I downloaded, registered in Squirrel, etc..., and i can browse the DBASE database using it. Now the column which was NUMERIC (type 8) with JDBC-ODBC bridge is INTEGER (type 4), and it is working. BUT when i try to generate the 'create table' script, i get this error: Driver class jstels.jdbc.dbf.DBFDriver2 successfully registered for driver definition: DBASE org.hibernate.MappingException: No Dialect mapping for JDBC type: 8 Type 8 is now associated with a column of DOUBLE type name. Regards, Fabiano On Tue, Dec 6, 2011 at 9:39 AM, Andreas Oswald <cpt...@gm...> wrote: > 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 >> > > > ------------------------------------------------------------------------------ > 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 |
