Hibernate Community • View topic

View unanswered posts | View active topics

Board index » Hibernate & Java Persistence » Hibernate Users

All times are UTC - 5 hours [ DST ]

Oracle Blob

Page 1 of 1

[ 3 posts ]

Previous topic | Next topic

Author

Message

osoe

Post subject: Oracle Blob

Posted: Tue Jun 01, 2004 4:08 pm

Newbie

Joined: Tue Jun 01, 2004 4:01 pm
Posts: 3

I read the Wiki article at

http://www.hibernate.org/56.html

and modified the code accordingly. Here is the code snippet

hibernate.cfg.xml file

Code:

<property
           name="attachmentContent"
         type="java.sql.Blob"
         column="ATTACHMENT_CONTENT"  
         not-null="false"      
    />

Calling Code:

Code:

File file = new File(FILE_NAME);      
      FileInputStream in = new FileInputStream(file);
      attament.setAttachmentContent(Hibernate.createBlob(in));

But I get the following error

Code:

ERROR [Jun 01 2004 03:05:51 PM] [JDBCExceptionReporter]  (logExceptions) - No more data to read from socket
ERROR [Jun 01 2004 03:05:52 PM] [JDBCExceptionReporter]  (logExceptions) - No more data to read from socket
ERROR [Jun 01 2004 03:05:52 PM] [JDBCExceptionReporter]  (logExceptions) - No more data to read from socket
ERROR [Jun 01 2004 03:05:52 PM] [JDBCException]  (<init>) - could not insert: [org.ifmc.email.EmailAttachment#1]
java.sql.SQLException: No more data to read from socket
   at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:134)
   at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:179)
   at oracle.jdbc.dbaccess.DBError.check_error(DBError.java:1160)
   at oracle.jdbc.ttc7.MAREngine.unmarshalUB1(MAREngine.java:963)
   at oracle.jdbc.ttc7.MAREngine.unmarshalSB1(MAREngine.java:893)
   at oracle.jdbc.ttc7.Oall7.receive(Oall7.java:375)

If I use the file less than 4000, it works fine as expected. I use Oracle 9.X.

Thanks for your help
Osoe

Top

osoe

Post subject:

Posted: Tue Jun 01, 2004 5:44 pm

Newbie

Joined: Tue Jun 01, 2004 4:01 pm
Posts: 3

This is the second block of code from the WIKI page

Code:

s = sf.openSession();
tx = s.beginTransaction();
foo = new Foo();
foo.setClob( Hibernate.createClob(" ") );
s.save(foo);
s.flush();
s.refresh(foo, LockMode.UPGRADE); //grabs an Oracle CLOB
oracle.sql.CLOB clob = (oracle.sql.CLOB) foo.getClob();
java.io.Writer pw = clob.getCharacterOutputStream();
pw.write([color=red]content[/color]);
pw.close();
tx.commit();
s.close();

I pass the inputstream to Hibernate.createClob() and where does the 'content' come from.

Osoe

Top

osoe

Post subject: Need Help

Posted: Wed Jun 02, 2004 8:55 am

Newbie

Joined: Tue Jun 01, 2004 4:01 pm
Posts: 3

Please I need some help.

http://www.hibernate.org/56.html

I am trying making the BLOB work the similar way mentioned in the above URL for CLOB.

But Hibernate.createBlob() does not take a String. Also I could not understand where does the content come from. Could any one post the example for BLOB.

Thanks
Osoe

Top

Page 1 of 1

[ 3 posts ]

Board index » Hibernate & Java Persistence » Hibernate Users

All times are UTC - 5 hours [ DST ]

You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum