• Post Reply Bookmark Topic Watch Topic
  • New Topic

Inserting/Updating BLOBs in Oracle8i using JDBC thin driver  RSS feed

 
Pakhi Tyagi
Greenhorn
Posts: 1
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Anyone who has worked on this please help it is urgent
 
Alastair Rae
Greenhorn
Posts: 7
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
update mytable set x = EMPTY_BLOB() where ...
select x from mytable where ...
update mytable set x = ? where ...
This last one is a prepared statement and you do:
((oracle.sql.BLOB)b).putBytes(1, ...)
Ugly!
 
Jamie Robertson
Ranch Hand
Posts: 1879
MySQL Database Suse
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
have you bothered looking at the Oracle documentation? It is some of the best around! Have a look at the Oracle9i JDBC Developer's Guide and Reference, specifically Chapter 8 - Working with LOBs and BFILEs
Jamie
[ November 24, 2003: Message edited by: Jamie Robertson ]
 
  • Post Reply Bookmark Topic Watch Topic
  • New Topic
Boost this thread!