Win a copy of The Little Book of Impediments (e-book only) this week in the Agile and Other Processes forum!
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

java.sql.SQLException: Non supported character set: oracle-character-set-178

 
Mic Paul
Ranch Hand
Posts: 34
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Hi When i am passing Oracle Array type value into Stored procedure from java in TOMCAT 6.0 and getting "Non supported character set: oracle-character-set-178". for Character set error i tried to add orai18n.jar into Tomcat Library too. but didn't get any clue. it would be great help if you can share your ideas or suggestion or solution for this issue.



Thanks in advance
 
Brian Tkatch
Bartender
Posts: 567
25
Linux Notepad Oracle
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Google has quite a few hits for Non supported character set: oracle-character-set-178. The problems seems to be with mismatched drivers. Try this thread on the Oracle forums.
 
Mic Paul
Ranch Hand
Posts: 34
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Thanks Brian

When I tried updating ojdbc14.jar & orai18n.jar with exact version which supports to my Oracle version and i am getting below error, I have no clue

exception
javax.servlet.ServletException: oracle.i18n.text.converter.CharacterConverterOGS.getInstance(I)Loracle/sql/converter/CharacterConverters;
org.apache.catalina.security.SecurityUtil.execute(SecurityUtil.java:294)
org.apache.catalina.security.SecurityUtil.doAsPrivilege(SecurityUtil.java:162)
org.apache.catalina.security.SecurityUtil.doAsPrivilege(SecurityUtil.java:115)
org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:102)
org.apache.catalina.valves.AccessLogValve.invoke(AccessLogValve.java:568)
org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:286)
org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:845)
org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:583)
org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:447)
java.lang.Thread.run(Thread.java:619)

root cause
java.lang.NoSuchMethodError: oracle.i18n.text.converter.CharacterConverterOGS.getInstance(I)Loracle/sql/converter/CharacterConverters;
oracle.sql.converter.CharacterConverterFactoryOGS.make(CharacterConverterFactoryOGS.java:48)
oracle.sql.CharacterSetWithConverter.getInstance(CharacterSetWithConverter.java:92)
oracle.sql.CharacterSetFactoryThin.make(CharacterSetFactoryThin.java:123)
oracle.sql.CharacterSet.make(CharacterSet.java:443)
oracle.jdbc.driver.DBConversion.init(DBConversion.java:153)

 
Brian Tkatch
Bartender
Posts: 567
25
Linux Notepad Oracle
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Mic, this is beyond my forte. I suggest you post to the Oracle forums, as they support both Oracle and Java, and has the experts who ought to be able to help you.
 
Mic Paul
Ranch Hand
Posts: 34
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
sure Thanks Brian
 
Mic Paul
Ranch Hand
Posts: 34
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Resolved my issue with following solution: replaced ojdbc14.jar with exact versions of ojdbc6.jar & orai18n.jar which supports my oracle 11.2.0.2.
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic