Re: Problem with inserting blob


Well, I got it working. The problem was the jdbc driver.

But it is indeed strange, I was using the driver file ojdbc14.jar (the
one for version Oracle 9i), and it was throwing exception while
inserting Blob. I downloaded the new jar file for Oracle 10g (which is
supposed to be backward compatible) and its working with the 9i DB now.
No code change whatsoever.

Thank you for all your replies!



aditya2507@xxxxxxxxx wrote:
Thomas Kellerer wrote:

This works fine for me. But it might be a driver issue. My experience is that
older drivers do not implement the setBinaryStream() stuff correctly. Download
the latest 10g driver (will work with 9i without problems) and try it with that one.

Right, could be that. Someone else too tried the code that I put here
and it seemed to work fine for him. So I guess there's nothing wrong
with the code. Also, I think if the OCI driver is used, this would work
-- I read that somewhere in a forum but it could be speculation, so I
can't be sure of that. Anyway, I got nothing to loose, will try the 10g
driver as well. Thank you for your reply Thomas, appreciate it.

.

Relevant Pages

  • Re: Problem with Mech Mercenaries - Memory Errors -
    ... Driver file: nvapu.sys ... Driver size: 320,640 bytes ... PRIMARYMONO: Yes ... AGP texture memory: 65,011,711 bytes ...
    (microsoft.public.windowsxp.games)
  • Re: "Invalid column name" inserting a row with weblogic/oracle
    ... > support was to download the latest ojdbc14.jar file from Oracle and make ... > sure it is at the front of the classpath. ... So you've added the latest oracle thin driver so it comes ...
    (comp.lang.java.databases)
  • Re: Oracle Client
    ... provider as well as the Oracle .Net driver from MSFT, ...  Access to Oracle8 Database or higher. ... To the second part of your question - More specifically, you SHOULD download ...
    (microsoft.public.dotnet.framework.adonet)
  • Re: ASP.net and Oracle error System.Data.OleDb.OleDbException
    ... uninstalled and reinstalled Oracle and now it works. ... > It sounds like you need to download the oraoledb driver from oracle and ... > The oledb driver is not part of the 'standard' oracle client install ...
    (microsoft.public.dotnet.framework.aspnet)
  • Re: Windows XP PCs Regularly Shutting Down
    ... I did a search on the PC and the driver file is present in the ... What you say does seem logical i.e. it calls for the driver but considering ... just to DETECT that there are no PS/2 devices? ... BIOS does not let me to disable the keyboard. ...
    (microsoft.public.windowsxp.help_and_support)