aspose file tools*
The moose likes Websphere and the fly likes Character Set issue while using StructDescriptor in WAS6.1 Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login
JavaRanch » Java Forums » Products » Websphere
Bookmark "Character Set issue while using StructDescriptor in WAS6.1" Watch "Character Set issue while using StructDescriptor in WAS6.1" New topic
Author

Character Set issue while using StructDescriptor in WAS6.1

Ankur Luthra
Ranch Hand

Joined: Dec 13, 2010
Posts: 36
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.
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 please provide any pointers for the same.orai18 jar is not working..
WAS6.1 and Jdk 1.5 is the runtime environment

I am attaching the snapshot of the same.

Regards,
Ankur


[Download untitled.TIF] Download

Ankur Luthra
Ranch Hand

Joined: Dec 13, 2010
Posts: 36
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
 
 
subject: Character Set issue while using StructDescriptor in WAS6.1