Subject | Strange character sets or.........u figure it out |
---|---|
Author | bkdc |
Post date | 2002-06-27T10:28:02Z |
Well, thats the error i get:
___________________________________________________________________
Cant Open Query
SQL :: SELECT
*
FROM
TEXTS
WHERE
TXT_NDX = '439'
Exception Type:: java.sql.SQLException
Exception Message :: fetch problem: org.firebirdsql.gds.GDSException:
arithmetic exception, numeric overflow, or string truncation
Cannot transliterate character between character sets
Exception StackTrace ::
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$FBCachedFetcher.<init>(FBResultSet.java:25=
90)
at org.firebirdsql.jdbc.FBResultSet.<init>(FBResultSet.java:124)
at
org.firebirdsql.jdbc.FBStatement.getCachedResultSet(FBStatement.java:539)
at
org.firebirdsql.jdbc.FBStatement.executeQuery(FBStatement.java:102)
at com.evermind._wq.executeQuery(Unknown Source)
at com.evermind._wq.executeQuery(Unknown Source)
at com.evermind._wq.executeQuery(Unknown Source)
at com.kondiment.dblayer.DBQuery.openQuery(DBQuery.java:209)
at com.kondiment.dblayer.DBTable.readTableByKey(DBTable.java:177)
at com.kondiment.dblayer.DBTable.readTableByKey(DBTable.java:146)
at com.topsport.dblayer.TTexts.readTableByKey(TTexts.java:38)
at
com.topsport.jsp.view.PParser.getArticleContent(PParser.java:2170)
at com.topsport.jsp.view.PParser.handleParse(PParser.java:2585)
at com.kondiment.jsp.JspUtils.parseString(JspUtils.java:534)
at
com.topsport.jsp.view.PParser.getCategoryContent(PParser.java:1433)
at
com.topsport.jsp.view.PPageView.handleRequest(PPageView.java:193)
at
__jspPage1_categories_jsp._jspService(__jspPage1_categories_jsp.java:30)
at com.orionserver.http.OrionHttpJspPage.service(Unknown Source)
at com.evermind._ah._rad(Unknown Source)
at com.evermind.server.http.JSPServlet.service(Unknown Source)
at com.evermind._cxb._abe(Unknown Source)
at com.evermind._cxb._uec(Unknown Source)
at com.evermind._cxb.forward(Unknown Source)
at com.evermind._hmb.forward(Unknown Source)
at
com.evermind.server.http.EvermindPageContext.forward(Unknown Source)
at __jspPage0_index_jsp._jspService(__jspPage0_index_jsp.java:25)
at com.orionserver.http.OrionHttpJspPage.service(Unknown Source)
at com.evermind._ah._rad(Unknown Source)
at com.evermind.server.http.JSPServlet.service(Unknown Source)
at com.evermind._cxb._abe(Unknown Source)
at com.evermind._cxb._uec(Unknown Source)
at com.evermind._io._twc(Unknown Source)
at com.evermind._io._gc(Unknown Source)
at com.evermind._if.run(Unknown Source)
___________________________________________________________________
and this is the debug info i get:
____________________________________________________________________
[FBManagedConnection,DEBUG] preparing sql: SELECT
*
FROM
TEXTS
WHERE
TXT_NDX = '439'
[GDS_Impl,DEBUG] op_prepare_statement
[GDS_Impl,DEBUG] sent
[GDS_Impl,DEBUG] op_response
[GDS_Impl,DEBUG] op_response resp_object: 0
[GDS_Impl,DEBUG] op_response resp_blob_id: 0
[XdrInputStream,DEBUG] Available: 1036 trying to read to: 1024 at: 0
[GDS_Impl,DEBUG] op_response resp_data size: 1024
[GDS_Impl,DEBUG] readStatusVector int: 0
[GDS_Impl,DEBUG] received
[GDS_Impl,DEBUG] parseSqlInfo started
[GDS_Impl,DEBUG] parseSqlInfo: first 2 bytes are 1796 or: 4, 7
[GDS_Impl,DEBUG] xsqlda.sqln read as 5
[GDS_Impl,DEBUG] new xsqlvar 0
[GDS_Impl,DEBUG] isc_info_sql_type 496
[GDS_Impl,DEBUG] isc_info_sql_sub_type 0
[GDS_Impl,DEBUG] isc_info_sql_scale 0
[GDS_Impl,DEBUG] isc_info_sql_length 4
[GDS_Impl,DEBUG] isc_info_sql_field TXT_NDX
[GDS_Impl,DEBUG] isc_info_sql_relation TEXTS
[GDS_Impl,DEBUG] isc_info_sql_owner TOPSPORT
[GDS_Impl,DEBUG] isc_info_sql_alias TXT_NDX
[GDS_Impl,DEBUG] new xsqlvar 1
[GDS_Impl,DEBUG] isc_info_sql_type 452
[GDS_Impl,DEBUG] isc_info_sql_sub_type 0
[GDS_Impl,DEBUG] isc_info_sql_scale 0
[GDS_Impl,DEBUG] isc_info_sql_length 1
[GDS_Impl,DEBUG] isc_info_sql_field TXT_PROCESSED
[GDS_Impl,DEBUG] isc_info_sql_relation TEXTS
[GDS_Impl,DEBUG] isc_info_sql_owner TOPSPORT
[GDS_Impl,DEBUG] isc_info_sql_alias TXT_PROCESSED
[GDS_Impl,DEBUG] new xsqlvar 2
[GDS_Impl,DEBUG] isc_info_sql_type 448
[GDS_Impl,DEBUG] isc_info_sql_sub_type 0
[GDS_Impl,DEBUG] isc_info_sql_scale 0
[GDS_Impl,DEBUG] isc_info_sql_length 8192
[GDS_Impl,DEBUG] isc_info_sql_field TXT_RAWDATA
[GDS_Impl,DEBUG] isc_info_sql_relation TEXTS
[GDS_Impl,DEBUG] isc_info_sql_owner TOPSPORT
[GDS_Impl,DEBUG] isc_info_sql_alias TXT_RAWDATA
[GDS_Impl,DEBUG] new xsqlvar 3
[GDS_Impl,DEBUG] isc_info_sql_type 448
[GDS_Impl,DEBUG] isc_info_sql_sub_type 0
[GDS_Impl,DEBUG] isc_info_sql_scale 0
[GDS_Impl,DEBUG] isc_info_sql_length 8192
[GDS_Impl,DEBUG] isc_info_sql_field TXT_PREZDATA
[GDS_Impl,DEBUG] isc_info_sql_relation TEXTS
[GDS_Impl,DEBUG] isc_info_sql_owner TOPSPORT
[GDS_Impl,DEBUG] isc_info_sql_alias TXT_PREZDATA
[GDS_Impl,DEBUG] new xsqlvar 4
[GDS_Impl,DEBUG] isc_info_sql_type 452
[GDS_Impl,DEBUG] isc_info_sql_sub_type 0
[GDS_Impl,DEBUG] isc_info_sql_scale 0
[GDS_Impl,DEBUG] isc_info_sql_length 1
[GDS_Impl,DEBUG] isc_info_sql_field TXT_TYPE
[GDS_Impl,DEBUG] isc_info_sql_relation TEXTS
[GDS_Impl,DEBUG] isc_info_sql_owner TOPSPORT
[GDS_Impl,DEBUG] isc_info_sql_alias TXT_TYPE
[GDS_Impl,DEBUG] parseSqlInfo ended
[GDS_Impl,DEBUG] op_execute
[GDS_Impl,DEBUG] sent
[GDS_Impl,DEBUG] op_response
[GDS_Impl,DEBUG] op_response resp_object: 1
[GDS_Impl,DEBUG] op_response resp_blob_id: 0
[GDS_Impl,DEBUG] op_response resp_data size: 0
[GDS_Impl,DEBUG] readStatusVector int: 0
[GDS_Impl,DEBUG] received
[GDS_Impl,DEBUG] op_fetch
[GDS_Impl,DEBUG] sent
[GDS_Impl,DEBUG] op_response
[GDS_Impl,DEBUG] op_response resp_object: 0
[GDS_Impl,DEBUG] op_response resp_blob_id: 0
[GDS_Impl,DEBUG] op_response resp_data size: 0
[GDS_Impl,DEBUG] readStatusVector int: 335544321
[GDS_Impl,DEBUG] readStatusVector int: 335544565
[FBManagedConnection,DEBUG] End called:
org.firebirdsql.jca.FBLocalTransaction$FBLocalXid@40b8fd
[FBManagedConnection,DEBUG] Commit called:
org.firebirdsql.jca.FBLocalTransaction$FBLocalXid@40b8fd
[GDS_Impl,DEBUG] op_commit
[GDS_Impl,DEBUG] tr.rtr_id: 1
[GDS_Impl,DEBUG] sent
[GDS_Impl,DEBUG] op_response
[GDS_Impl,DEBUG] op_response resp_object: 0
[GDS_Impl,DEBUG] op_response resp_blob_id: 0
[GDS_Impl,DEBUG] op_response resp_data size: 0
[GDS_Impl,DEBUG] readStatusVector int: 0
[GDS_Impl,DEBUG] received
[GDS_Impl,DEBUG] op_free_statement
[GDS_Impl,DEBUG] sent
[GDS_Impl,DEBUG] op_response
[GDS_Impl,DEBUG] op_response resp_object: -1
[GDS_Impl,DEBUG] op_response resp_blob_id: 0
[GDS_Impl,DEBUG] op_response resp_data size: 0
[GDS_Impl,DEBUG] readStatusVector int: 0
[GDS_Impl,DEBUG] received
____________________________________________________________________
Both TXT_RAWDATA and TXTPREZDATA fields contain the following
text(without quotes):
"Presedintele LPF l-a indicat pe Dragos, fiul fostului presedinte
dinamovist Vasile Ianul, drept martor la o discutie în care Cornel
Dinu a recunoscut "mocirla" de la Piatra Neamt. Martorul este mîna
dreaptã a lui Gigi Becali"
___________________________________________________________________
Cant Open Query
SQL :: SELECT
*
FROM
TEXTS
WHERE
TXT_NDX = '439'
Exception Type:: java.sql.SQLException
Exception Message :: fetch problem: org.firebirdsql.gds.GDSException:
arithmetic exception, numeric overflow, or string truncation
Cannot transliterate character between character sets
Exception StackTrace ::
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$FBCachedFetcher.<init>(FBResultSet.java:25=
90)
at org.firebirdsql.jdbc.FBResultSet.<init>(FBResultSet.java:124)
at
org.firebirdsql.jdbc.FBStatement.getCachedResultSet(FBStatement.java:539)
at
org.firebirdsql.jdbc.FBStatement.executeQuery(FBStatement.java:102)
at com.evermind._wq.executeQuery(Unknown Source)
at com.evermind._wq.executeQuery(Unknown Source)
at com.evermind._wq.executeQuery(Unknown Source)
at com.kondiment.dblayer.DBQuery.openQuery(DBQuery.java:209)
at com.kondiment.dblayer.DBTable.readTableByKey(DBTable.java:177)
at com.kondiment.dblayer.DBTable.readTableByKey(DBTable.java:146)
at com.topsport.dblayer.TTexts.readTableByKey(TTexts.java:38)
at
com.topsport.jsp.view.PParser.getArticleContent(PParser.java:2170)
at com.topsport.jsp.view.PParser.handleParse(PParser.java:2585)
at com.kondiment.jsp.JspUtils.parseString(JspUtils.java:534)
at
com.topsport.jsp.view.PParser.getCategoryContent(PParser.java:1433)
at
com.topsport.jsp.view.PPageView.handleRequest(PPageView.java:193)
at
__jspPage1_categories_jsp._jspService(__jspPage1_categories_jsp.java:30)
at com.orionserver.http.OrionHttpJspPage.service(Unknown Source)
at com.evermind._ah._rad(Unknown Source)
at com.evermind.server.http.JSPServlet.service(Unknown Source)
at com.evermind._cxb._abe(Unknown Source)
at com.evermind._cxb._uec(Unknown Source)
at com.evermind._cxb.forward(Unknown Source)
at com.evermind._hmb.forward(Unknown Source)
at
com.evermind.server.http.EvermindPageContext.forward(Unknown Source)
at __jspPage0_index_jsp._jspService(__jspPage0_index_jsp.java:25)
at com.orionserver.http.OrionHttpJspPage.service(Unknown Source)
at com.evermind._ah._rad(Unknown Source)
at com.evermind.server.http.JSPServlet.service(Unknown Source)
at com.evermind._cxb._abe(Unknown Source)
at com.evermind._cxb._uec(Unknown Source)
at com.evermind._io._twc(Unknown Source)
at com.evermind._io._gc(Unknown Source)
at com.evermind._if.run(Unknown Source)
___________________________________________________________________
and this is the debug info i get:
____________________________________________________________________
[FBManagedConnection,DEBUG] preparing sql: SELECT
*
FROM
TEXTS
WHERE
TXT_NDX = '439'
[GDS_Impl,DEBUG] op_prepare_statement
[GDS_Impl,DEBUG] sent
[GDS_Impl,DEBUG] op_response
[GDS_Impl,DEBUG] op_response resp_object: 0
[GDS_Impl,DEBUG] op_response resp_blob_id: 0
[XdrInputStream,DEBUG] Available: 1036 trying to read to: 1024 at: 0
[GDS_Impl,DEBUG] op_response resp_data size: 1024
[GDS_Impl,DEBUG] readStatusVector int: 0
[GDS_Impl,DEBUG] received
[GDS_Impl,DEBUG] parseSqlInfo started
[GDS_Impl,DEBUG] parseSqlInfo: first 2 bytes are 1796 or: 4, 7
[GDS_Impl,DEBUG] xsqlda.sqln read as 5
[GDS_Impl,DEBUG] new xsqlvar 0
[GDS_Impl,DEBUG] isc_info_sql_type 496
[GDS_Impl,DEBUG] isc_info_sql_sub_type 0
[GDS_Impl,DEBUG] isc_info_sql_scale 0
[GDS_Impl,DEBUG] isc_info_sql_length 4
[GDS_Impl,DEBUG] isc_info_sql_field TXT_NDX
[GDS_Impl,DEBUG] isc_info_sql_relation TEXTS
[GDS_Impl,DEBUG] isc_info_sql_owner TOPSPORT
[GDS_Impl,DEBUG] isc_info_sql_alias TXT_NDX
[GDS_Impl,DEBUG] new xsqlvar 1
[GDS_Impl,DEBUG] isc_info_sql_type 452
[GDS_Impl,DEBUG] isc_info_sql_sub_type 0
[GDS_Impl,DEBUG] isc_info_sql_scale 0
[GDS_Impl,DEBUG] isc_info_sql_length 1
[GDS_Impl,DEBUG] isc_info_sql_field TXT_PROCESSED
[GDS_Impl,DEBUG] isc_info_sql_relation TEXTS
[GDS_Impl,DEBUG] isc_info_sql_owner TOPSPORT
[GDS_Impl,DEBUG] isc_info_sql_alias TXT_PROCESSED
[GDS_Impl,DEBUG] new xsqlvar 2
[GDS_Impl,DEBUG] isc_info_sql_type 448
[GDS_Impl,DEBUG] isc_info_sql_sub_type 0
[GDS_Impl,DEBUG] isc_info_sql_scale 0
[GDS_Impl,DEBUG] isc_info_sql_length 8192
[GDS_Impl,DEBUG] isc_info_sql_field TXT_RAWDATA
[GDS_Impl,DEBUG] isc_info_sql_relation TEXTS
[GDS_Impl,DEBUG] isc_info_sql_owner TOPSPORT
[GDS_Impl,DEBUG] isc_info_sql_alias TXT_RAWDATA
[GDS_Impl,DEBUG] new xsqlvar 3
[GDS_Impl,DEBUG] isc_info_sql_type 448
[GDS_Impl,DEBUG] isc_info_sql_sub_type 0
[GDS_Impl,DEBUG] isc_info_sql_scale 0
[GDS_Impl,DEBUG] isc_info_sql_length 8192
[GDS_Impl,DEBUG] isc_info_sql_field TXT_PREZDATA
[GDS_Impl,DEBUG] isc_info_sql_relation TEXTS
[GDS_Impl,DEBUG] isc_info_sql_owner TOPSPORT
[GDS_Impl,DEBUG] isc_info_sql_alias TXT_PREZDATA
[GDS_Impl,DEBUG] new xsqlvar 4
[GDS_Impl,DEBUG] isc_info_sql_type 452
[GDS_Impl,DEBUG] isc_info_sql_sub_type 0
[GDS_Impl,DEBUG] isc_info_sql_scale 0
[GDS_Impl,DEBUG] isc_info_sql_length 1
[GDS_Impl,DEBUG] isc_info_sql_field TXT_TYPE
[GDS_Impl,DEBUG] isc_info_sql_relation TEXTS
[GDS_Impl,DEBUG] isc_info_sql_owner TOPSPORT
[GDS_Impl,DEBUG] isc_info_sql_alias TXT_TYPE
[GDS_Impl,DEBUG] parseSqlInfo ended
[GDS_Impl,DEBUG] op_execute
[GDS_Impl,DEBUG] sent
[GDS_Impl,DEBUG] op_response
[GDS_Impl,DEBUG] op_response resp_object: 1
[GDS_Impl,DEBUG] op_response resp_blob_id: 0
[GDS_Impl,DEBUG] op_response resp_data size: 0
[GDS_Impl,DEBUG] readStatusVector int: 0
[GDS_Impl,DEBUG] received
[GDS_Impl,DEBUG] op_fetch
[GDS_Impl,DEBUG] sent
[GDS_Impl,DEBUG] op_response
[GDS_Impl,DEBUG] op_response resp_object: 0
[GDS_Impl,DEBUG] op_response resp_blob_id: 0
[GDS_Impl,DEBUG] op_response resp_data size: 0
[GDS_Impl,DEBUG] readStatusVector int: 335544321
[GDS_Impl,DEBUG] readStatusVector int: 335544565
[FBManagedConnection,DEBUG] End called:
org.firebirdsql.jca.FBLocalTransaction$FBLocalXid@40b8fd
[FBManagedConnection,DEBUG] Commit called:
org.firebirdsql.jca.FBLocalTransaction$FBLocalXid@40b8fd
[GDS_Impl,DEBUG] op_commit
[GDS_Impl,DEBUG] tr.rtr_id: 1
[GDS_Impl,DEBUG] sent
[GDS_Impl,DEBUG] op_response
[GDS_Impl,DEBUG] op_response resp_object: 0
[GDS_Impl,DEBUG] op_response resp_blob_id: 0
[GDS_Impl,DEBUG] op_response resp_data size: 0
[GDS_Impl,DEBUG] readStatusVector int: 0
[GDS_Impl,DEBUG] received
[GDS_Impl,DEBUG] op_free_statement
[GDS_Impl,DEBUG] sent
[GDS_Impl,DEBUG] op_response
[GDS_Impl,DEBUG] op_response resp_object: -1
[GDS_Impl,DEBUG] op_response resp_blob_id: 0
[GDS_Impl,DEBUG] op_response resp_data size: 0
[GDS_Impl,DEBUG] readStatusVector int: 0
[GDS_Impl,DEBUG] received
____________________________________________________________________
Both TXT_RAWDATA and TXTPREZDATA fields contain the following
text(without quotes):
"Presedintele LPF l-a indicat pe Dragos, fiul fostului presedinte
dinamovist Vasile Ianul, drept martor la o discutie în care Cornel
Dinu a recunoscut "mocirla" de la Piatra Neamt. Martorul este mîna
dreaptã a lui Gigi Becali"