-
1. Re: BLOBs and Transactions
sbrbot Aug 20, 2004 4:45 AM (in response to ceh)It seems that we're talkink about typo! Look at your column indicies of prepared statement (AFAIK the PreparedStatement is the only way for inserting BLOB/CLOB fields).
-
2. Re: BLOBs and Transactions
ceh Aug 20, 2004 9:04 AM (in response to ceh)I am not using PreparedStatement. I am using the setter, i.e. myobj.setGraphic(g) and myobj.setAudio(a) where g and a are byte[]. Please keep in mind, this works just fine outside of an explicit transaction. If there were a typo, this would not be true.
-
3. Re: BLOBs and Transactions
sbrbot Aug 22, 2004 2:26 PM (in response to ceh)Then something wierd is happenong there, sounds like a bug but send something more ...
-
4. Re: BLOBs and Transactions
ceh Aug 23, 2004 9:08 AM (in response to ceh)Yes, it seems very wierd to me and feels like it could be a bug. I was hoping to find someone here who knew more about this than I. It does not seem I am doing something that out of the ordinary - updating 2 BLOBs at once. What additional information would help? There are no errors being generated, so no trace stack to send. Not sure where to go from here.
-
5. Re: BLOBs and Transactions
ceh Aug 24, 2004 5:22 PM (in response to ceh)Additional information as my testing continues: if I update the blobs directly using PreparedStatement, SQL, etc. the problem does not manifest. From this I conclude that my JDBC drivers and DB (Oracle) are not the culprit but that it is a bug in JBoss.
-
6. Re: BLOBs and Transactions
ceh Aug 30, 2004 3:00 PM (in response to ceh)Turns out this is an Oracle JDBC bug, found in 10.0.1.