Thanks, I took a look and indeed, that`s nothing I can use... We already have something that works with SQLite, and we`re trying to move away precisely from that...
Denis > From: [email protected] > To: [email protected] > Date: Wed, 16 Jun 2010 14:48:05 +1200 > Subject: Re: [Jprogramming] bulk insert with ODBC (into MySQL db) > > > From: Denis Samson > > Sent: Wednesday, 16 June 2010 12:34 > > > > I'm having lots of fun porting an old, huge J application still > > running on J5.03 (!) and using a SQLite database. The goal is 1- to > > get it to use MySQL 5.x instead through an ODBC connection, then 2- > > move the whole thing to J6.02... > ... > > > > 3- Does anyone ever bulkinserts into MySQL or anywhere else (and if so, > > how?) > > As a SQLite user you are probably familiar with the data/sqlite addon in JAL, > but in case you're not it has routines for doing bulk inserts. > http://www.jsoftware.com/jwiki/Addons/data/sqlite > http://www.jsoftware.com/svn/addons/trunk/data/sqlite/test/bench.ijs > > It doesn't use an ODBC connection though, so I'm not sure how much it will > help you with transferring your data to MySQL. > > ---------------------------------------------------------------------- > For information about J forums see http://www.jsoftware.com/forums.htm _________________________________________________________________ Game on: Challenge friends to great games on Messenger http://go.microsoft.com/?linkid=9734387 ---------------------------------------------------------------------- For information about J forums see http://www.jsoftware.com/forums.htm
