• Post Reply Bookmark Topic Watch Topic
  • New Topic
programming forums Java Mobile Certification Databases Caching Books Engineering Micro Controllers OS Languages Paradigms IDEs Build Tools Frameworks Application Servers Open Source This Site Careers Other Pie Elite all forums
this forum made possible by our volunteer staff, including ...
Marshals:
  • Campbell Ritchie
  • Jeanne Boyarsky
  • Ron McLeod
  • Paul Clapham
  • Liutauras Vilda
Sheriffs:
  • paul wheaton
  • Rob Spoor
  • Devaka Cooray
Saloon Keepers:
  • Stephan van Hulst
  • Tim Holloway
  • Carey Brown
  • Frits Walraven
  • Tim Moores
Bartenders:
  • Mikalai Zaikin

Oracle Datasource Connection

 
Ranch Hand
Posts: 105
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
I have this page that is used to upload images into a database. The problem is with my image capture page. When I connect using my oracle-ds.xml using an oci connection url as follows:



I can successfully Insert, Retrieve and Delete Images from my Oracle Database.

When I use this connection:



I cannot insert images into my oracle DB. I get the following error message:



Unfotunately I cannot dictate the connection that my organization uses. I am stuck with the thin connection.

Any suggestions on how to succesfully insert images into my Database without getting that error.

By the way I have also tested my code with an MS SQL-ds connection it works there.

HELP!!!

As an After thought, heres my code that does the actual insert.

[ October 05, 2005: Message edited by: Ola Daniel ]
 
Ranch Hand
Posts: 293
Mac OS X Netbeans IDE Java
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
What is the field type that you are trying to insert into? Is it a String or a Blob?

In Oracle String has a max size of 4000 so you need to use a blob field.
 
I suggest huckleberry pie. But the only thing on the gluten free menu is this tiny ad:
a bit of art, as a gift, that will fit in a stocking
https://gardener-gift.com
reply
    Bookmark Topic Watch Topic
  • New Topic