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)