Win a copy of The Little Book of Impediments (e-book only) this week in the Agile and Other Processes forum!
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

Attachment functionality is not working when project is running on oracle10g

 
anuradha Java
Greenhorn
Posts: 5
  • Mark post as helpful
  • send pies
  • 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
  • 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
  • Quote
  • Report post to moderator
In this project we are using struts, hibernate. Is there any thing to change in hibernate for attachment
 
Jesper de Jong
Java Cowboy
Saloon Keeper
Posts: 15643
47
Android IntelliJ IDE Java Scala Spring
  • Mark post as helpful
  • send pies
  • 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
  • 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?
 
Jeanne Boyarsky
author & internet detective
Marshal
Posts: 35279
384
Eclipse IDE Java VI Editor
  • Mark post as helpful
  • send pies
  • 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.
 
Gajen Pingalkar
Ranch Hand
Posts: 37
  • Mark post as helpful
  • send pies
  • 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.
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic