Need help with Hibernate? Read this first:
http://www.hibernate.org/ForumMailingli ... AskForHelp

Hibernate version:2.0

Mapping documents:n/a

Code between sessionFactory.openSession() and session.close():n/a

Name and version of the database you are using:db2 8.1

Debug level Hibernate log excerpt:n/a


Can any one get me the sample program to store and retrieve blob datatype in db2 database. I tried with oracle its working fine. But when i tried with db2, i am not even able get session from the session factory.



with regards,

So show you exceptions!

hi Emanuel,

thanks for ur response


now i able to get the session a object.

can u get me some sample example to store and retrieve blob datatype value in db2 database.....


[color = red]In case of oracle:[/color]

The code i used is:


SessionFactory sf =new Configuration().configure().buildSessionFactory();
Session session = null;
Transaction tx = null;

session=sf.openSession();
tx = session.beginTransaction();
ai.setAttachBlob(Hibernate.createBlob(new String(" ").getBytes()));
session.save(ai);
tx.commit();
session.close();

session=sf.openSession();
tx = session.beginTransaction();
AttachmentInfo attachmentInfo = (AttachmentInfo)session.load(AttachmentInfo.class,new Integer(ai.getId()),LockMode.UPGRADE);
BLOB blob = (BLOB) attachmentInfo.getAttachBlob();
OutputStream os = blob.getBinaryOutputStream();
os.write(attachObject);
os.close();
tx.commit();
session.close();


when i use the same code for db2....

BLOB blob = (BLOB) attachmentInfo.getAttachBlob();
OutputStream os = blob.getBinaryOutputStream();

blob.getBinaryOutputStream();

is not possible thats for oracle

how do i write? or get me some code or some url to get the information

with regard,

viswa





[/u]

Please post your hibernate.cfg.xml file, the mappings for the relevant object, the stack trace etc.

hi emmanuel,


I have added db2jcc.jar,license.jar in the class path


[color = red]This is hibernate.cfg.xml[/color]

<?xml version='1.0' encoding='utf-8'?>
<!DOCTYPE hibernate-configuration
PUBLIC "-//Hibernate/Hibernate Configuration DTD//EN"
"http://hibernate.sourceforge.net/hibernate-configuration-2.0.dtd">
<hibernate-configuration>
<session-factory>

<property name="connection.driver_class">com.ibm.db2.jcc.DB2Driver</property>
<property name="connection.url">jdbc:db2://wstzion:50000/wsd_m1_x</property>
<property name="connection.username">db2admin</property>
<property name="connection.password">db2admin</property>
<property name="show_sql">true</property>
<property name="dialect">net.sf.hibernate.dialect.OracleDialect</property>


<mapping resource="Attachments.hbm"/>


</session-factory>
</hibernate-configuration>


[color = red]This is Attachments.hbm[/color]

<?xml version="1.0"?>
<!DOCTYPE hibernate-mapping PUBLIC
"-//Hibernate/Hibernate Mapping DTD 2.0//EN"
"http://hibernate.sourceforge.net/hibernate-mapping-2.0.dtd" >

<hibernate-mapping>

<class
name="AttachmentInfo"
table="test_attachments"
>

<id
name="id"
type="int"
column="id"
>
<generator class="increment" />
</id>

<property
name="attachBlob"
type="blob"
column="attach_blob"
/>
</class>
</hibernate-mapping>


[color = red]This is AttachmentInfo.java[/color]



import java.io.Serializable;
import java.sql.Blob;



public class AttachmentInfo implements Serializable{

private int id;
private Blob attachBlob = null;

public AttachmentInfo(){

} //for Hibernate by Baskar


/**
* @return Returns the attachBlob.
*/
public Blob getAttachBlob() {
return attachBlob;
}
/**
* @param attachBlob The attachBlob to set.
*/
public void setAttachBlob(Blob attachBlob) {
this.attachBlob = attachBlob;
}
/**
* @return Returns the id.
*/
public int getId() {
return id;
}
/**
* @param id The id to set.
*/
public void setId(int id) {
this.id = id;
}


}

Your SQL dialect is still set to Oracle dialect not DB2 dialect. Change it to net.sf.hibernate.dialect.DB2Dialect

sorry emmanuel,

i have now changed oracle dialect to db2 dialect... then how could i store and retrieve....

Before we get to that I think there's another issue that needs to be covered. As your dialect was set incorrectly the table generate by hbm2ddl may be incorrect. If you do use auto ddl generation you need to regenerate the DB2 tables.

Then it should be something along the lines of



Where PersistedObject would have an attribute of type BLOB[/code]

hai,

the hint that u have given:

PersistedObject po=(PersistedObject)session.load(PersistedObject.class, 1)
OutputStream os = po.getBLOB.getOutputStream() ;



when i tried

AttachmentInfo attachmentInfo = (AttachmentInfo)session.load(AttachmentInfo.class,new Integer(ai.getId()),LockMode.UPGRADE);
OutputStream os = attachmentInfo.getAttachBlob.getOutputStream();


here

attachmentInfo.getAttachBlob.getOutputStream();

i am getting method getOutputStream() is undefined for the type Blob

please tell me wat to do next...

Well the best thing to do when this happens is to stop trusting the random man on the internet and double check the methods of Blob.

After I did this I noticed that BLOB actually has the method getBinaryStream() [Retrieves the BLOB designated by this Blob instance as a stream.]

So you were lead off track by a strange man who doesn't check things he thought he remembered but you also forgot that you can't believe everything.