I have a Web Application deployed on WAS 6.1.it uses Hibernate for Persistence.
When I am using Struct Descriptor and creating objects in Java they are being shown as
???.I was able to fix this issue by adding orai18.jar in TomCat but in WAS I am not able to fix it.
Below is my code.
Code:
Connection conn1= session.connection(); //This is the Proxy Connection from Hibernate
Connection conn = BorrowedConnectionProxy.getWrappedConnection(conn1); Extracting from the Proxy connection
Connection nativeConnection = (Connection)WSJdbcUtil.getNativeConnection((WSJdbcConnection)conn);//getting the Native connection.In this case it comes as LogicalConnection
structDesc = StructDescriptor.createDescriptor("XXX.ESN_DATA_TYPE", nativeConnection);
arrayDesc = ArrayDescriptor.createDescriptor("XXX.ESN_DATA_TABLE", nativeConnection);
row=new Objectcount[5];
STRUCT rowStruct = new STRUCTcount;
List<STRUCT> allRows= new ArrayList<STRUCT>();
for(int i=0;i<count;i++)
{
dataDTO = (EsnDataDTO)datalist.get(i);
row[i][0]=dataDTO.getEngineSerialNumber();
//I even tried this row[i][0]=new CHAR(dataDTO.getEngineSerialNumber(), CharacterSet.make(CharacterSet.WE8ISO8859P9_CHARSET));
row[i][1]=dataDTO.getDescription();
row[i][2]=dataDTO.getTransactionDate();
row[i][3]=null;
row[i][4]=dataDTO.getUploadedBy();
rowStruct[i] = new STRUCT(structDesc,nativeConnection,row[i]);
/* Step 6 */
allRows.add(rowStruct[i]); //At this point when I inspect rowStruct variable I can see data as ??? instead of values.
}
Can you plz provide any pointers for the same.orai18 jar is not working..
WAS6.1 and Jdk 1.5 is the runtime environment
Following are the JARS that I am using
Manifest-Version: 1.0
Class-Path: jars/antlr-2.7.2.jar
jars/asm-attrs.jar
jars/asm.jar
jars/cglib-2.1.3.jar
jars/commons-beanutils-1.8.0.jar
jars/commons-chain-1.2.jar
jars/commons-collections-3.2.1.jar
jars/commons-digester-1.8.jar
jars/commons-fileupload-1.1.1.jar
jars/commons-io-1.1.jar
jars/commons-lang-2.5.jar
jars/commons-logging-1.0.4.jar
jars/commons-validator-1.3.1.jar
jars/ehcache-1.2.3.jar
jars/ezmorph-1.0.6.jar
jars/hibernate3.jar
jars/javax.servlet-5.1.12.jar
jars/json-lib-2.3-jdk13.jar
jars/jta.jar
jars/junit.jar
jars/log4j-1.2.16.jar
jars/mail.jar
jars/oro-2.0.8.jar
jars/struts-core-1.3.8.jar
jars/struts-extras-1.3.8.jar
jars/struts-taglib-1.3.8.jar
jars/struts-tiles-1.3.8.jar
jars/orai18n.jar
jars/dom4j-1.6.1.jar
jars/ooxml-schemas-1.0.jar
jars/poi-3.8-20120326.jar
jars/poi-ooxml-3.8-20120326.jar
jars/stax-api-1.0.1.jar
jars/xmlbeans-2.3.0.jar
is it because of some conflict between Server Run time Jars and my Jars. Because in Tomcat it did not give any problems after adding oi18n.jar
Regards,
Ankur