Hi Julian, thanks for your tip. we did imported our data over an odbc-bridge from a access-database.
I guess, the solution to solve that problem is to have a second look on the import. Peter -----Urspr�ngliche Nachricht----- Von: Julian L�ffelhardt [mailto:[EMAIL PROTECTED]] Gesendet: Dienstag, 9. April 2002 21:48 An: [EMAIL PROTECTED] Betreff: Re: [castor-dev] failUTF8Conv Hi, I used to have the same problems, when I populated some tables using the oracle sqlloader. Experimenting with the NLS_LANG settings (for the insert procedure) solved the problems for me. How did you insert the values into the database? ----- Original Message ----- From: "Peter Kalmbach" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Tuesday, April 09, 2002 8:08 PM Subject: [castor-dev] failUTF8Conv > Hi, > i have some problems with special german characters > eg. '�', '�', '�' > > When retrieving record containing these characters, the following error is > thrown. > > java.sql.SQLException: Konvertierung zwischen UTF8 und UCS2 nicht > erfolgreich: failUTF8Conv > 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.jdbc.dbaccess.DBConversion.failUTF8Conv(DBConversion.java:1746) > at > oracle.jdbc.dbaccess.DBConversion.utf8BytesToJavaChars(DBConversion.java:158 > 5) > at > oracle.jdbc.dbaccess.DBConversion.utf8BytesToString(DBConversion.java:1445) > at > oracle.jdbc.dbaccess.DBConversion.CharBytesToString(DBConversion.java:384) > at > oracle.jdbc.driver.OracleStatement.getStringValue(OracleStatement.java:2571) > at > oracle.jdbc.driver.OracleResultSetImpl.getString(OracleResultSetImpl.java:30 > 5) > at org.exolab.castor.jdo.engine.SQLTypes.getObject(SQLTypes.java:316) > at > org.exolab.castor.jdo.engine.SQLEngine$SQLQuery.loadSingleField(SQLEngine.ja > va:1708) > at > org.exolab.castor.jdo.engine.SQLEngine$SQLQuery.loadRow(SQLEngine.java:1774) > at > org.exolab.castor.jdo.engine.SQLEngine$SQLQuery.fetchRaw(SQLEngine.java:1847 > ) > at > org.exolab.castor.jdo.engine.SQLEngine$SQLQuery.nextIdentity(SQLEngine.java: > 1655) > at > org.exolab.castor.persist.QueryResults.nextIdentity(QueryResults.java:173) > at > org.exolab.castor.jdo.engine.OQLQueryImpl$OQLEnumeration.hasMore(OQLQueryImp > l.java:571) > at > org.exolab.castor.jdo.engine.OQLQueryImpl$OQLEnumeration.hasMore(OQLQueryImp > l.java:557) > > The JDBC driver that we are implmenting is jdbc-oci-oracle817-jdk12 > > The following database.xml is beeing used: > > <!DOCTYPE databases PUBLIC "-//EXOLAB/Castor JDO Configuration DTD Version > 1.0//EN" > "http://castor.exolab.org/jdo-conf.dtd";> > > <database name="oracleDB" engine="oracle"> > <driver class-name="oracle.jdbc.driver.OracleDriver" > url="jdbc:oracle:thin:@mars:1521:ISORCL"> > <param name="user" value="agis22_ets" /> > <param name="password" value="agis22_ets" /> > </driver> > <mapping href="mapping.xml" /> > </database> > > Thanks for your cooperation, > Peter > > > ----------------------------------------------------------- If you wish to unsubscribe from this mailing, send mail to [EMAIL PROTECTED] with a subject of: unsubscribe castor-dev ----------------------------------------------------------- If you wish to unsubscribe from this mailing, send mail to [EMAIL PROTECTED] with a subject of: unsubscribe castor-dev
