Non supported character set: oracle-character-set-96 
Author Message
 Non supported character set: oracle-character-set-96

Hi,

I have deployed my webapplication in WSAD 5.0 (WebSphere Studio
Application studio) and i have configured Datasource for my Oracle
database through JDBC thick drivers. I am successfully able to get a
connection from Datasource but when i tried to execute any store
procedure i get following SQL Exception.

Below is log trace.
****************************************************************************************************************************************************************
java.sql.SQLException: Non supported character set:
oracle-character-set-96
        at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:168)
        at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:210)
        at oracle.jdbc.dbaccess.DBError.check_error(DBError.java:829)
        at oracle.sql.CharacterSetUnknown.failCharsetUnknown(CharacterSetFactoryThin.java:150)
        at oracle.sql.CharacterSetUnknown.convert(CharacterSetFactoryThin.java:114)
        at oracle.sql.CHAR.<init>(CHAR.java:109)
        at oracle.sql.CHAR.<init>(CHAR.java:133)
        at oracle.jdbc.oracore.OracleTypeCHAR.toDatum(OracleTypeCHAR.java:143)
        at oracle.sql.StructDescriptor.toOracleArray(StructDescriptor.java:385)
        at oracle.sql.StructDescriptor.toOracleArray(StructDescriptor.java:230)
        at oracle.sql.StructDescriptor.toJdbc2SQLInput(StructDescriptor.java:346)
        at oracle.sql.STRUCT.toClass(STRUCT.java:416)
        at oracle.sql.STRUCT.toJdbc(STRUCT.java:366)
        at oracle.jdbc.oracore.OracleTypeUPT.unpickle81UPT(OracleTypeUPT.java:403)
        at oracle.jdbc.oracore.OracleTypeUPT.unpickle81rec(OracleTypeUPT.java:353)
        at oracle.jdbc.oracore.OracleTypeCOLLECTION.unpickle81_imgBody_elems(OracleTypeCOLLECTION.java:902)
        at oracle.jdbc.oracore.OracleTypeCOLLECTION.unpickle81_imgBody(OracleTypeCOLLECTION.java:846)
        at oracle.jdbc.oracore.OracleTypeCOLLECTION.unpickle81(OracleTypeCOLLECTION.java:678)
        at oracle.jdbc.oracore.OracleTypeCOLLECTION.unlinearize(OracleTypeCOLLECTION.java:209)
        at oracle.sql.ArrayDescriptor.toJavaArray(ArrayDescriptor.java:501)
        at oracle.sql.ARRAY.getArray(ARRAY.java:214)
        at com.ncm.framework.business.viewtransaction.utils.ListBuyerFinDataSPDBUtil.getBuyerFinForByr(ListBuyerFinDataSPDBUtil.java:128)
        at com.ncm.framework.business.viewtransaction.sp.ListBuyerFinDataSPImpl.getBuyerFinForByr(ListBuyerFinDataSPImpl.java:77)
        at com.ncm.reqproc.viewtransactions.ViewFinDataResultReqProc.getBuyerFinData(ViewFinDataResultReqProc.java:212)
        at com.ncm.reqproc.viewtransactions.ViewFinDataResultReqProc.processRequest(ViewFinDataResultReqProc.java:138)
        at com.thbs.webo.container.WebAppContainer.doPost(WebAppContainer.java:385)
        at com.ncm.webo.container.NCMAppContainer.doPost(NCMAppContainer.java:392)
        at javax.servlet.http.HttpServlet.service(HttpServlet.java:760)
        at javax.servlet.http.HttpServlet.service(HttpServlet.java:853)
        at com.ibm.ws.webcontainer.servlet.StrictServletInstance.doService(StrictServletInstance.java:110)
        at com.ibm.ws.webcontainer.servlet.StrictLifecycleServlet._service(StrictLifecycleServlet.java:174)
        at com.ibm.ws.webcontainer.servlet.IdleServletState.service(StrictLifecycleServlet.java:313)
        at com.ibm.ws.webcontainer.servlet.StrictLifecycleServlet.service(StrictLifecycleServlet.java:116)
        at com.ibm.ws.webcontainer.servlet.ServletInstance.service(ServletInstance.java:258)
        at com.ibm.ws.webcontainer.servlet.ValidServletReferenceState.dispatch(ValidServletReferenceState.java:42)
        at com.ibm.ws.webcontainer.servlet.ServletInstanceReference.dispatch(ServletInstanceReference.java:40)
        at com.ibm.ws.webcontainer.webapp.WebAppRequestDispatcher.handleWebAppDispatch(WebAppRequestDispatcher.java:872)
        at com.ibm.ws.webcontainer.webapp.WebAppRequestDispatcher.dispatch(WebAppRequestDispatcher.java:491)
        at com.ibm.ws.webcontainer.webapp.WebAppRequestDispatcher.forward(WebAppRequestDispatcher.java:173)
        at com.ibm.ws.webcontainer.srt.WebAppInvoker.doForward(WebAppInvoker.java:79)
        at com.ibm.ws.webcontainer.srt.WebAppInvoker.handleInvocationHook(WebAppInvoker.java:199)
        at com.ibm.ws.webcontainer.cache.invocation.CachedInvocation.handleInvocation(CachedInvocation.java:71)
        at com.ibm.ws.webcontainer.srp.ServletRequestProcessor.dispatchByURI(ServletRequestProcessor.java:182)
        at com.ibm.ws.webcontainer.oselistener.OSEListenerDispatcher.service(OSEListener.java:331)
        at com.ibm.ws.webcontainer.http.HttpConnection.handleRequest(HttpConnection.java:56)
        at com.ibm.ws.http.HttpConnection.readAndHandleRequest(HttpConnection.java:432)
        at com.ibm.ws.http.HttpConnection.run(HttpConnection.java:343)
        at com.ibm.ws.util.ThreadPool$Worker.run(ThreadPool.java:592)

****************************************************************************************************************************************************************



Sun, 25 Dec 2005 01:25:03 GMT
 Non supported character set: oracle-character-set-96


Quote:
> java.sql.SQLException: Non supported character set

Not sur but check out
http://groups.google.com/groups?q=java.sql.SQLException%
3A+Non+supported+character+set

Esp threads with more than one article :)

Lordy



Sun, 25 Dec 2005 07:36:54 GMT
 
 [ 2 post ] 

 Relevant Pages 

1. db character set & N character set

2. error: Non Supported Character Set

3. Setting the Oracle character set

4. Characters beyond ASCII in database ( US7ASCII and UTF8 character set )

5. Specifying Non-Unicode Character Set during remote install of SQL 7 on Win2kPro

6. ANSI non English character set translated to English

7. How to set character-set NLS_language to show chinese at PC client

8. Setting character set in sybperl

9. Change set order and character set in SQL 6.5

10. Is It Too Late to Set Character Set?

11. Character set and set order in SQL Server 6.5

12. Help: How to set the character set??


 
Powered by phpBB® Forum Software