hi all


i want to insert a blob object in database with hiber blob object.

thats successfully done in tomcat, but in OC4J app server i can't do it and
it return this exception :

operation not allowed: streams type cannot be used in batching


i set this property in system properties too

hibernate.jdbc.use_streams_for_binary = true



anyone have idea ???????????

please help me

thanks all

<property name="hibernate.jdbc.batch_size">0</property>

use this setting in the hibernate.cfg.xml.

hi all

thanks shrimon.

my problem was oracle application server (OC4J).

i solve the problem with replacing classes12.jar in OC4J library.

thanks agin

Hi ,


Can you tell me how you inserted a blob into the database

How did you map the column in the mapping file.
and what code did you use in the object setter and getter.

I keep getting the following error.

java.sql.SQLException: No more data to read from socket

at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:170)

my mapping file is :

<hibernate-mapping>
<class name="MyEntity" table="GENV_REPORT_GENERATOR" >
<property name="obj"
type="serializable"
not-null="true"
column="REG_REPORT_DESIGN"/>
</class>
</hibernate-mapping>


and in my persisteable class i have a serializeable class :

class MyEntity {
private Serializeable obj;
....
}

Thanks a lot.

But i have one more doubt

So your REG_REPORT_DESIGN is a Blob column

How did you write the setter and getter for that column in the MyEntity Class.
Hope i am not disturbing you.


Thanks in advance

Shrimon

hi agin

yep that column is a blob column.

my setter and getter method is :

public ReportBLOB getReportDesign() {
return reportDesign;
}

public void setReportDesign(ReportBLOB reportDesign) {
this.reportDesign = reportDesign;
}


i just save an serialized object. that is just simple setter and getter.

Thanks shams

I will try again with this info.

public ReportBLOB getReportDesign() {
return reportDesign;
}

i assume that ReportBLOB is nothing but an ordinary java.sql.Blob.

Please correct me if i am wrong.

Thanks.
Shrimon.

ReportBlob just is an Simple Object
but its implemented "java.io.Serializeable"


i wanna save on object to db. (that is not a file ) it's just a java Object.

i hope success

Hi shams,


I have the same problem, thats successfully done in Jdev, but in OC4J app server that return an exception :

operation not allowed: streams type cannot be used in batching.


So I had hibernate.jdbc.use_streams_for_binary = true in "hibernate.cfg"

And I try to change classes12.jar, but it does'nt work.

Where are you find your classes12.jar and where are you change it in OC4J.


thanks

Hi Wolf

if you have oracle10g installed in yor computer you can find classes12.jar
in its jdbc library

i have an oracle client in my pc and i found classes12.jar in this path :

E:\Oracle\product\10.1.0\Client\jdbc\lib

when you found this library you most do following jobs :

go to your application server jdbc library

path is : E:\Oracle\OracleAS10g\jdbc\lib

in this folder you found you most delete or move two file
1 - classes12.jar
2 - classes12dms.jar

then copy your classes12.jar twice in this library and rename second of them to classes12dms.jar
(in otherhand you have one file with diferent name first name is : classes12.jar and second names is classes12dms.jar)

i hope that you understand this tips.

sorry about my poor english

No problem for your english, mine is so bad too (i'm french ...).


It work perfectly.

My application work fine, but now, it's OC4J app server that have some problem.


The administration access on app server is down or work badly.

Have you seen any kind of problem after this modification ?


thanks again.

hi wolf

after replacing this files in my application servers i test it on Windwos Server

and United Server - Suse linux . it work successfull and i have no problem until tody. ;)