UTF8 conversion - send mails from database : failUTF8Conv

2002-10-18 Thread Anoop Kumar V
Hi All,

We have an application which checks an oracle database and a servlet sends
out the mails at regular intervals based on the status whether the message
was sent or not.
The application has been running fine until now for abt 10 months. But today
morning we noticed that all mailing services had stopped. When we
investigated further we found that there was one message which was holding
the entire queue and none of the mails posted after that were being sent.
On checking the logs we found this error.  "Fail to convert between UTF8 and
UCS2: failUTF8Conv"
Apparently it talks abt chracter set conversion in the database. The message
that was blocking was in some other language other than english, possibly
french. And we use Oracle 8 thin drivers to connect to the database and the
jdk version is jdk1.2.2.

Has somebody faced the same problem and is there any solution to this.. I
did check each of the sites Google fished out to me.. but they only talk
more about the problem rather than the solution to the problem.
Please help me with this problem..

Here is the content of the log file..

java.sql.SQLException: Fail to convert between UTF8 and UCS2: failUTF8Conv
at java.lang.Throwable.fillInStackTrace(Native Method)
at java.lang.Throwable.fillInStackTrace(Compiled Code)
at java.lang.Throwable.(Compiled Code)
at java.lang.Exception.(Compiled Code)
at java.sql.SQLException.(SQLException.java:43)
at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:114)
at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:156)
at oracle.jdbc.dbaccess.DBError.check_error(DBError.java:775)
at
oracle.jdbc.dbaccess.DBConversion.failUTF8Conv(DBConversion.java:1746)
at oracle.jdbc.dbaccess.DBConversion.utf8BytesToJavaChars(Compiled
Code)
at oracle.jdbc.dbaccess.DBConversion.utf8BytesToString(Compiled
Code)
at oracle.jdbc.dbaccess.DBConversion.CharBytesToString(Compiled
Code)
at oracle.jdbc.driver.OracleStatement.getStringValue(Compiled Code)
at oracle.jdbc.driver.OracleStatement.getObjectValue(Compiled Code)
at oracle.jdbc.driver.OracleStatement.getObjectValue(Compiled Code)
at oracle.jdbc.driver.OracleResultSetImpl.getObject(Compiled Code)
at sun.jdbc.rowset.CachedRowSet.populate(Compiled Code)
at com.sapient.core.sql.SQLCachedRowSet.populate(Compiled Code)
at com.sapient.core.sql.SQLWrapper.executeQueryStoredProc(Compiled
Code)
at com.sapient.core.sql.SQLWrapper.executeQueryStoredProc(Compiled
Code)
at com.edward.mailwrapper.MailUtil.getUnsentMailsParameters(Compiled
Code)
at com.edward.mailwrapper.MailService.performScheduledTask(Compiled
Code)
at atg.service.scheduler.ScheduledJob.runJobs(Compiled Code)
at atg.service.scheduler.Scheduler$2$handler.run(Scheduler.java:694)
Message>Fail to convert between UTF8 and UCS2: failUTF8Conv
SQLCode>17037   SQLState>   null
--Thu Oct 17 18:42:24 GMT+01:00 2002--mailWrapper--
com.edward.mailwrapper--MailService--performScheduledTask--Mail
Wrapper--1--com.sapient.core.sql.GeneralSQLException
ERRORID>608 PACKAGE>com.sapient.core.sqlMODULE>
CORECLASS>  SQLCachedRowSet FUNC
TION>   populate(ResultSet rset) throws GeneralSQLException
ERRORTEXT: Exception occured using SQLCachedRowSet. EXTRAMESSAGE: Unable
to populate the CachedRowSet from the ResultSetINCOMING:
java.sql.SQLException: Fail to convert between UTF8 and UCS2: failUTF8Conv

===
To unsubscribe: mailto [EMAIL PROTECTED] with body: "signoff JSP-INTEREST".
For digest: mailto [EMAIL PROTECTED] with body: "set JSP-INTEREST DIGEST".
Some relevant FAQs on JSP/Servlets can be found at:

 http://archives.java.sun.com/jsp-interest.html
 http://java.sun.com/products/jsp/faq.html
 http://www.esperanto.org.nz/jsp/jspfaq.jsp
 http://www.jguru.com/faq/index.jsp
 http://www.jspinsider.com



Re: UTF8 conversion - send mails from database : failUTF8Conv

2002-10-18 Thread KEITH KOSMICKI
Actually I think it's Japanese, try this site Looks like good info:
http://tech.ymirlink.co.jp/perl/cpan/Unicode-Japanese-0.03/Japanese.html 
Let me know how it turns out. sounds interesting.
 
 
 
Keith E. Kosmicki
Applications Consultant
State of IL Human Services
STL Technology Partners

>>> [EMAIL PROTECTED] 10/18/02 08:45AM >>>
Hi All,

We have an application which checks an oracle database and a servlet sends
out the mails at regular intervals based on the status whether the message
was sent or not.
The application has been running fine until now for abt 10 months. But today
morning we noticed that all mailing services had stopped. When we
investigated further we found that there was one message which was holding
the entire queue and none of the mails posted after that were being sent.
On checking the logs we found this error.  "Fail to convert between UTF8 and
UCS2: failUTF8Conv"
Apparently it talks abt chracter set conversion in the database. The message
that was blocking was in some other language other than english, possibly
french. And we use Oracle 8 thin drivers to connect to the database and the
jdk version is jdk1.2.2.

Has somebody faced the same problem and is there any solution to this.. I
did check each of the sites Google fished out to me.. but they only talk
more about the problem rather than the solution to the problem.
Please help me with this problem..

Here is the content of the log file..

java.sql.SQLException: Fail to convert between UTF8 and UCS2: failUTF8Conv
at java.lang.Throwable.fillInStackTrace(Native Method)
at java.lang.Throwable.fillInStackTrace(Compiled Code)
at java.lang.Throwable.(Compiled Code)
at java.lang.Exception.(Compiled Code)
at java.sql.SQLException.(SQLException.java:43)
at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:114)
at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:156)
at oracle.jdbc.dbaccess.DBError.check_error(DBError.java:775)
at
oracle.jdbc.dbaccess.DBConversion.failUTF8Conv(DBConversion.java:1746)
at oracle.jdbc.dbaccess.DBConversion.utf8BytesToJavaChars(Compiled
Code)
at oracle.jdbc.dbaccess.DBConversion.utf8BytesToString(Compiled
Code)
at oracle.jdbc.dbaccess.DBConversion.CharBytesToString(Compiled
Code)
at oracle.jdbc.driver.OracleStatement.getStringValue(Compiled Code)
at oracle.jdbc.driver.OracleStatement.getObjectValue(Compiled Code)
at oracle.jdbc.driver.OracleStatement.getObjectValue(Compiled Code)
at oracle.jdbc.driver.OracleResultSetImpl.getObject(Compiled Code)
at sun.jdbc.rowset.CachedRowSet.populate(Compiled Code)
at com.sapient.core.sql.SQLCachedRowSet.populate(Compiled Code)
at com.sapient.core.sql.SQLWrapper.executeQueryStoredProc(Compiled
Code)
at com.sapient.core.sql.SQLWrapper.executeQueryStoredProc(Compiled
Code)
at com.edward.mailwrapper.MailUtil.getUnsentMailsParameters(Compiled
Code)
at com.edward.mailwrapper.MailService.performScheduledTask(Compiled
Code)
at atg.service.scheduler.ScheduledJob.runJobs(Compiled Code)
at atg.service.scheduler.Scheduler$2$handler.run(Scheduler.java:694)
Message>Fail to convert between UTF8 and UCS2: failUTF8Conv
SQLCode>17037   SQLState>   null
--Thu Oct 17 18:42:24 GMT+01:00 2002--mailWrapper--
com.edward.mailwrapper--MailService--performScheduledTask--Mail
Wrapper--1--com.sapient.core.sql.GeneralSQLException
ERRORID>608 PACKAGE>com.sapient.core.sqlMODULE>
CORECLASS>  SQLCachedRowSet FUNC
TION>   populate(ResultSet rset) throws GeneralSQLException
ERRORTEXT: Exception occured using SQLCachedRowSet. EXTRAMESSAGE: Unable
to populate the CachedRowSet from the ResultSetINCOMING:
java.sql.SQLException: Fail to convert between UTF8 and UCS2: failUTF8Conv

===
To unsubscribe: mailto [EMAIL PROTECTED] with body: "signoff JSP-INTEREST".
For digest: mailto [EMAIL PROTECTED] with body: "set JSP-INTEREST DIGEST".
Some relevant FAQs on JSP/Servlets can be found at:

http://archives.java.sun.com/jsp-interest.html 
http://java.sun.com/products/jsp/faq.html 
http://www.esperanto.org.nz/jsp/jspfaq.jsp 
http://www.jguru.com/faq/index.jsp 
http://www.jspinsider.com 

==To 
unsubscribe: mailto [EMAIL PROTECTED] with body: "signoff JSP-INTEREST".
For digest: mailto [EMAIL PROTECTED] with body: "set JSP-INTEREST DIGEST".
Some relevant FAQs on JSP/Servlets can be found at:

 http://archives.java.sun.com/jsp-interest.html
 http://java.sun.com/products/jsp/faq.html
 http://www.esperanto.org.nz/jsp/jspfaq.jsp
 http://www.jguru.com/faq/index.jsp
 http://www.jspinsider.com