Monday, 2010-07-12

*** Alex| has joined #ingres00:05
*** ChanServ sets mode: +o Alex|00:05
*** Dejan has joined #ingres00:26
*** bonro01 has joined #ingres00:49
*** atrofast has joined #ingres03:25
Dejanhello everybody04:39
pboroheya04:39
*** rossand has joined #ingres05:36
*** ChanServ sets mode: +o rossand05:36
*** mull has joined #ingres06:12
*** toumi01 has joined #ingres06:24
*** javahorn has joined #ingres06:59
*** javahorn has left #ingres07:00
*** cthibert has joined #ingres07:11
*** Alex| has quit IRC07:26
*** grantc has quit IRC07:42
*** grantc has joined #ingres08:33
*** KermitTheFragger has joined #ingres08:34
*** Alex| has joined #ingres09:26
*** ChanServ sets mode: +o Alex|09:26
*** grantc has quit IRC10:18
Dejantime to go home10:19
Dejansee you tomorrow guys10:19
*** Dejan has quit IRC10:19
*** clach04 has quit IRC10:24
*** Mud has quit IRC10:25
*** Mud has joined #ingres10:30
*** cthibert1 has joined #ingres10:31
*** grantc has joined #ingres10:31
*** cthibert1 has left #ingres10:31
*** KermitTheFragger has quit IRC10:33
*** clach04 has joined #ingres10:34
*** grantc has quit IRC11:01
*** toumi01 has quit IRC11:25
*** toumi01 has joined #ingres11:45
*** Mud has quit IRC12:55
*** toumi01 has left #ingres13:12
*** grantc has joined #ingres13:27
atrofastHey pboro when dealing with JDBC and LOBs  on insert/update do you have to do any special handling with INgres/13:51
pborohmm not that I remember13:51
atrofastOr is setBytes(col#, byte[]) okay?13:51
atrofastSo it's only really reading that's the hassle then?13:51
atrofastI.e. gotta use that InputStream13:51
pborostream will be more efficient, but if the data is small then setbytes is ok13:52
*** grantc has quit IRC13:53
atrofastHow do you use streams on writing?13:54
pboroon writing? you mean when doing update or insert?13:54
atrofastYeah13:55
pborowell... 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, setAsciiStream13:56
atrofastWhat about in the case of a byte[]?13:57
pborowell then you would reserve an array size of the file, read the data into the array and pass the array to the statement, using setBytes13:58
atrofastwill setBytes work even if I pass it a byte[] array larger than 32000 bytes?13:59
pborohmm, good question, I would expect so, but I haven't tried13:59
pborofor jdbc, setBytes and setBinaryStream/setAsciiStream are simply alternatives, afaik they should work alike, streams just prevent reading the whole data in memory14:01
atrofastOkay that's good to know... I can do either14:01
*** cthibert has left #ingres14:02
atrofastThanks a lot pboro14:02
pborono prob14:03
*** Alex| has quit IRC14:07
*** mull has quit IRC15:05
*** atrofast has quit IRC16:53
*** cytrinox_ has joined #ingres19:21
*** cytrinox has quit IRC19:24
*** cytrinox_ is now known as cytrinox19:24
*** rossand has quit IRC20:12
*** Alex| has joined #ingres22:40
*** ChanServ sets mode: +o Alex|22:40
*** grantc has joined #ingres23:06
*** Alex| has quit IRC23:13
*** grantc has quit IRC23:33
*** grantc has joined #ingres23:33
*** Alex| has joined #ingres23:54
*** ChanServ sets mode: +o Alex|23:54

Generated by irclog2html.py 2.7 by Marius Gedminas - find it at mg.pov.lt!