2 Replies Latest reply on Feb 17, 2003 5:22 AM by Jesper Knudsen

    Firebird and "Cannot transliterate..." error

    Brian Macy Newbie

      Not sure why this is showing up....

      ERROR:
      2002-08-17 18:58:36,574 ERROR [org.jboss.ejb.plugins.LogInterceptor] TransactionRolledbackException, causedBy:
      java.sql.SQLException: fetch problem: org.firebirdsql.gds.GDSException: arithmetic exception, numeric overflow, or string truncation
      Cannot transliterate character between character sets
      at org.firebirdsql.jdbc.FBResultSet$FBStatementFetcher.next(FBResultSet.java:2535)
      at org.firebirdsql.jdbc.FBResultSet.next(FBResultSet.java:157)
      at org.jboss.ejb.plugins.cmp.jdbc.JDBCLoadEntityCommand.execute(JDBCLoadEntityCommand.java:122)
      at org.jboss.ejb.plugins.cmp.jdbc.JDBCLoadEntityCommand.execute(JDBCLoadEntityCommand.java:62)
      at org.jboss.ejb.plugins.cmp.jdbc.JDBCStoreManager.loadEntity(JDBCStoreManager.java:572)
      at org.jboss.ejb.plugins.CMPPersistenceManager.loadEntity(CMPPersistenceManager.java:410)
      at org.jboss.resource.connectionmanager.CachedConnectionInterceptor.loadEntity(CachedConnectionInterceptor.java:353)
      .
      .
      .
      at $Proxy48.getOwner(Unknown Source) // This returns a String object


      QUERY (from JAWS debug log):
      "SELECT id,disabled, owner, startAttempt, endAttempt, lastSuccess, config, processorType, className, name, alertGroup FROM ALERTSOURCE WHERE (id=?) OR (id=?)"

      TABLE:
      SQL> show table alertsource;
      ID INTEGER Not Null
      DISABLED SMALLINT Not Null
      OWNER VARCHAR(1024) Nullable
      STARTATTEMPT NUMERIC(18, 0) Nullable
      ENDATTEMPT NUMERIC(18, 0) Nullable
      LASTSUCCESS NUMERIC(18, 0) Nullable
      CONFIG VARCHAR(2000) Nullable
      PROCESSORTYPE INTEGER Not Null
      CLASSNAME VARCHAR(1024) Nullable
      NAME VARCHAR(1024) Nullable
      ALERTGROUP INTEGER Nullable
      CONSTRAINT PK_ALERTSOURCE:
      Primary key (ID)