• 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
  • Ron McLeod
  • Paul Clapham
  • Rob Spoor
  • Liutauras Vilda
Sheriffs:
  • Jeanne Boyarsky
  • Junilu Lacar
  • Tim Cooke
Saloon Keepers:
  • Tim Holloway
  • Piet Souris
  • Stephan van Hulst
  • Tim Moores
  • Carey Brown
Bartenders:
  • Frits Walraven
  • Himai Minh

Attachment functionality is not working when project is running on oracle10g

 
Greenhorn
Posts: 5
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
My Project is working well with oracel9i but when i connected it with oracle 10g and trying to attach files then it is giving the error:

 
anuradha Java
Greenhorn
Posts: 5
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
I have place the jar files ojdbc14 and ojdbc14_g at Program Files\Java\jdk1.5.0_12\jre\lib\ext
 
anuradha Java
Greenhorn
Posts: 5
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
In this project we are using struts, hibernate. Is there any thing to change in hibernate for attachment
 
Java Cowboy
Posts: 16084
88
Android Scala IntelliJ IDE Spring Java
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
First, check your private messages for an administrative matter from JavaRanch.

Did you try Googling for "ORA-22993"?

http://ora-22993.ora-code.com/
http://www-css.fnal.gov/dsg/external/oracle_dcm/9iv2/appdev.920/a96591/adl06faq.htm

It looks like this has something to do with inserting a BLOB or CLOB the wrong way, where you specify the size of the object you are inserted wrongly. Without seeing your source code, it's hard to tell what exactly is wrong with your program.
 
anuradha Java
Greenhorn
Posts: 5
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
But it is working fine with oracle 9i.
This problem is with oracle10g only.

Do you have any idea that what should be changes specifically oracle10g?
 
author & internet detective
Posts: 40726
827
Eclipse IDE VI Editor Java
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator

Did you try Googling for "ORA-22993"?


This is good advice. I notice you didn't reply to it.

Just because something worked in a previous version doesn't mean you are home free. It could have been a bug in the previous release. It could be a system change. It could be almost anything. You have to pursue it as a new problem until you know more.
 
Ranch Hand
Posts: 37
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
Sorry Jeanne,
We did googling for "ORA-22993" , but not get satisfied answer.
Here is our code for saving file by JDBC.


Thanks in advance.
 
Mo-om! You're embarassing me! Can you just read a tiny ad like a normal person?
the value of filler advertising in 2021
https://coderanch.com/t/730886/filler-advertising
reply
    Bookmark Topic Watch Topic
  • New Topic