This week's giveaway is in the Android forum.
We're giving away four copies of Android Security Essentials Live Lessons and have Godfrey Nolan on-line!
See this thread for details.
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


Win a copy of Android Security Essentials Live Lessons this week in the Android forum!
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
Greenhorn

Joined: Dec 13, 2010
Posts: 28
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
Greenhorn

Joined: Dec 13, 2010
Posts: 28
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
 
It is sorta covered in the JavaRanch Style Guide.
 
subject: Character Set issue while using StructDescriptor in WAS6.1
 
Similar Threads
Passing array of Oracle colection objects from java to PL SQL
Passing in array parameter to an Oracle stored procedure
problem streaming with mms:// protocol
Oracle Vs Access ! updateString isnt working
WAS 6.1 server1 as windows service is not working