*** Alex| has joined #ingres | 00:05 | |
*** ChanServ sets mode: +o Alex| | 00:05 | |
*** Dejan has joined #ingres | 00:26 | |
*** bonro01 has joined #ingres | 00:49 | |
*** atrofast has joined #ingres | 03:25 | |
Dejan | hello everybody | 04:39 |
---|---|---|
pboro | heya | 04:39 |
*** rossand has joined #ingres | 05:36 | |
*** ChanServ sets mode: +o rossand | 05:36 | |
*** mull has joined #ingres | 06:12 | |
*** toumi01 has joined #ingres | 06:24 | |
*** javahorn has joined #ingres | 06:59 | |
*** javahorn has left #ingres | 07:00 | |
*** cthibert has joined #ingres | 07:11 | |
*** Alex| has quit IRC | 07:26 | |
*** grantc has quit IRC | 07:42 | |
*** grantc has joined #ingres | 08:33 | |
*** KermitTheFragger has joined #ingres | 08:34 | |
*** Alex| has joined #ingres | 09:26 | |
*** ChanServ sets mode: +o Alex| | 09:26 | |
*** grantc has quit IRC | 10:18 | |
Dejan | time to go home | 10:19 |
Dejan | see you tomorrow guys | 10:19 |
*** Dejan has quit IRC | 10:19 | |
*** clach04 has quit IRC | 10:24 | |
*** Mud has quit IRC | 10:25 | |
*** Mud has joined #ingres | 10:30 | |
*** cthibert1 has joined #ingres | 10:31 | |
*** grantc has joined #ingres | 10:31 | |
*** cthibert1 has left #ingres | 10:31 | |
*** KermitTheFragger has quit IRC | 10:33 | |
*** clach04 has joined #ingres | 10:34 | |
*** grantc has quit IRC | 11:01 | |
*** toumi01 has quit IRC | 11:25 | |
*** toumi01 has joined #ingres | 11:45 | |
*** Mud has quit IRC | 12:55 | |
*** toumi01 has left #ingres | 13:12 | |
*** grantc has joined #ingres | 13:27 | |
atrofast | Hey pboro when dealing with JDBC and LOBs on insert/update do you have to do any special handling with INgres/ | 13:51 |
pboro | hmm not that I remember | 13:51 |
atrofast | Or is setBytes(col#, byte[]) okay? | 13:51 |
atrofast | So it's only really reading that's the hassle then? | 13:51 |
atrofast | I.e. gotta use that InputStream | 13:51 |
pboro | stream will be more efficient, but if the data is small then setbytes is ok | 13:52 |
*** grantc has quit IRC | 13:53 | |
atrofast | How do you use streams on writing? | 13:54 |
pboro | on writing? you mean when doing update or insert? | 13:54 |
atrofast | Yeah | 13:55 |
pboro | well... in case of a file, you simply open the file, but don't read it into a byte array or similar... instead, you pass the inputstream of the file to set, for example, setAsciiStream | 13:56 |
atrofast | What about in the case of a byte[]? | 13:57 |
pboro | well then you would reserve an array size of the file, read the data into the array and pass the array to the statement, using setBytes | 13:58 |
atrofast | will setBytes work even if I pass it a byte[] array larger than 32000 bytes? | 13:59 |
pboro | hmm, good question, I would expect so, but I haven't tried | 13:59 |
pboro | for jdbc, setBytes and setBinaryStream/setAsciiStream are simply alternatives, afaik they should work alike, streams just prevent reading the whole data in memory | 14:01 |
atrofast | Okay that's good to know... I can do either | 14:01 |
*** cthibert has left #ingres | 14:02 | |
atrofast | Thanks a lot pboro | 14:02 |
pboro | no prob | 14:03 |
*** Alex| has quit IRC | 14:07 | |
*** mull has quit IRC | 15:05 | |
*** atrofast has quit IRC | 16:53 | |
*** cytrinox_ has joined #ingres | 19:21 | |
*** cytrinox has quit IRC | 19:24 | |
*** cytrinox_ is now known as cytrinox | 19:24 | |
*** rossand has quit IRC | 20:12 | |
*** Alex| has joined #ingres | 22:40 | |
*** ChanServ sets mode: +o Alex| | 22:40 | |
*** grantc has joined #ingres | 23:06 | |
*** Alex| has quit IRC | 23:13 | |
*** grantc has quit IRC | 23:33 | |
*** grantc has joined #ingres | 23:33 | |
*** Alex| has joined #ingres | 23:54 | |
*** ChanServ sets mode: +o Alex| | 23:54 |
Generated by irclog2html.py 2.7 by Marius Gedminas - find it at mg.pov.lt!