• 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

Problem with storing document as blob

 
Greenhorn
Posts: 2
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
I have a system where the user can upload different type of files/documents and they are stored as blobs in oracle db. Everything works fine in my develop system. WinXP java 1.5 and tomcat 5.5.2.

When I move the system to our production environment, Win2k3 Java 1.5 and tomcat 5.5.2 I can only upload and store *.txt files but no word or excel doc.

the exception I get is:

java.sql.SQLException: Io exception: Connection reset by peer: socket write error
oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:124)
oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:161)
oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:273)
oracle.jdbc.driver.T4CConnection.putBytes(T4CConnection.java:1526)
oracle.sql.BLOB.setBytes(BLOB.java:658)
 
Ranch Hand
Posts: 1143
1
Eclipse IDE Oracle Java
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
AG,
Pardon me for asking a silly question, but are you using the same Oracle database and JDBC driver in both development and production systems?
And are you sure the code is exactly the same in both?
And is the Tomcat configuration exactly the same in both?
According to the details you posted, your environments do run on different operating systems.

Good Luck,
Avi.
 
Jonas Giron
Greenhorn
Posts: 2
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
There are no silly questions in ths case.

Yes the os is different. But this system was working just fine about three weeks ago.

About the oracel driver! yes it is the same. I'm using oracle10-driver12.jar.

is this a security poblem?

If I create a new excel/word doc and don't write any thing init, then it works fine. As soon as I write some thing in it, then it stop working
 
Avi Abrami
Ranch Hand
Posts: 1143
1
Eclipse IDE Oracle Java
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
Jonas,
So if you go back to the old JDBC driver, it still works?
I would go to Oracle Support, then.

Good Luck,
Avi.
 
Don't get me started about those stupid light bulbs.
reply
    Bookmark Topic Watch Topic
  • New Topic