Срд, 16 Июн 2010, Denis Samson писал(а): > > > > Bill Lam said: > > >> So I'd be a very happy camper if anyone could answer the following: > >> > >> 1- Does ddins work? (and 1.1- why does it overtake varchars so max size?) > >> > >> 2- Has anyone been using it, with MySQL or any other database? > >> > >> 3- Does anyone ever bulkinserts into MySQL or anywhere else (and if so, > >> how?) > > > > >1. it works for me > > >1.1 I'm lazy. > > >2. it tested ok with ms-access, ms sqlsvr, firebird > > >3. I don't know, you better ask in their forum (but it seems you have > > already done that). > > > I suggest you first verify ddins working properly ms-access or ms sqlsvr. > >If that doesn't work, try again with J602 and use the original odbc package. > > > Bill, thanks for the quick answer... I did follow your suggestion, and > tried <ddins> > on a stock, original, fresh install of J6.02. > Turns out <ddins> just doesn't work on a 64bit system: it uses a little > verb, <iad> from packages/odbc/odbc.ijs, (same module as ins) which returns > the address of the first [byte of] data in a variable. > Now, this verb obviously still assumes 32-bit adresses and integers, so it > does not work in j64: it reads the 2nd integer at offset 4 rather than 8 and > returns an 8-byte address with the LSW and MSW swapped, which gives huuuuge > addresses! > > I can`t see any way ddins could work with this verb! (btw, iad is used > by a couple of other utility verbs, so perhaps these don`t get used a lot > either!) > > And, If I correct <iad>, the call to SQLExecDirect a bit later does > return a 070001 error, about not all parameters being bound. Which is pretty > normal, since ddins does bother to SQLBindParam only later! > > How long ago have you checked ;-P it did work for you? And I`d like to know > the rationale for using SQLExecDirect there rather than wait and use SQLExec > after the binds? >
I haven't actually test it for a few years, but it have been used in production on a daily base. If it does not work, I should receive complaint within a few hours. for 64-bit J, what is value of SZI you found? you might also need to update the base library using pacman. -- regards, ==================================================== GPG key 1024D/4434BAB3 2008-08-24 gpg --keyserver subkeys.pgp.net --recv-keys 4434BAB3 ---------------------------------------------------------------------- For information about J forums see http://www.jsoftware.com/forums.htm
