BLOB/CLOB Issue with SAP J2EE engine 6.40

[Former Member]

Hi,

We are in the process of porting weblogic J2EE based application into SAP WAS6.40. We have a problem with BLOB/CLOB data types; Backend is oracle 9i.

Our Bean CMP is defined as follows (field mapping)

Fieldname: metaData

FieldType : java.lang.String

Column Name: meta_data;

-

---

In the Oracle database, it is defined as follows:

Column name: meta_data;

Column type : CLOB

-

---

We have created the datasource as follows:

Created a data-source include the following attributes:

oracle.jdbc.xa.client.OracleXADataSource;

Vendor SQL selected.

We are able to connect to the database; No problem;

-

---

The generated code looks like this:

try{

iLoadStatement = conn.prepareStatement("select \"HMS_PROPERTY\".\"P_NAME\", \"HMS_PROPERTY\".\"DESCRIPTION\", \"HMS_PROPERTY\".\"META_DATA\" from \"HMS_PROPERTY\" where \"P_NAME\" = ? ");

iLoadStatement.setString(1, ejb_pkObject.name);

rset = iLoadStatement.executeQuery();

if (!rset.next()) {

beanPM = null;

BaseReliableNoSuchEntityException toThrow = new BaseReliableNoSuchEntityException(NEED_REFRESH);

toThrow.trace( LOCATION );

throw toThrow;

}

extract(rset);

}

// Extracts all data from the ResultSet

// CMR fields are initialized from their caches

public void extract(ResultSet rs) throws SQLException {

Object pk = null;

description = rs.getString("description");

metaData = rs.getString("meta_data");

loaded = true;

}

metaData is declared as java.lang.string type.

-

---

As you notice, metaData variable is of type string. According to J2EE documentation, this is perfectly fine to declare this way.

But, it is not working;

Do we have to do anything special for CLOB/BLOB data types?

Please advise.

Thank You,

cSoftgroup, Inc

www.csoftgroup.com

[katarzyna_fecht]

Hi Kumar,

- which tool has generated the code?

- which db driver do you use?

regards, Katarzyna Fecht

[Vlado]

The problem is resolved in thread.

Regards

Vladimir