You are viewing a plain text version of this content. The canonical link for it is here.
Posted to user-java@ibatis.apache.org by Daniel Benedykt <da...@benedykt.com> on 2007/11/16 18:15:01 UTC
ibatis - db2 problem
Hi
I currently have a problem with an Ibatis-db2 call.
Basically if I call a store procedure that returns a Date fields, I get
an error. (If it doesn't have a Date fields, it works fine)
Here is the trace:
[Nov15 17:52:44] [ExecuteThread: '24' for queue:
'weblogic.kernel.Default'] ERROR
com.bdoc.mtier.xmlgenerator.base.DataListDao > Error DataList Dao :
SqlMapClient operation; uncategorized SQLException for SQL []; SQL state
[HY000]; error code [0];
--- The error occurred in configxml/sqlconfig/xmlDAO.xml.
--- The error occurred while applying a result map.
--- Check the ATUPSTAT-AutoResultMap.
--- Check the result mapping for the 'D_REQST' property.
--- Cause: java.sql.SQLException: [BEA][DB2 JDBC Driver]Transliteration
failed, reason: invalid UTF8 data; nested exception is
com.ibatis.common.jdbc.exception.NestedSQLException:
--- The error occurred in configxml/sqlconfig/xmlDAO.xml.
--- The error occurred while applying a result map.
--- Check the ATUPSTAT-AutoResultMap.
--- Check the result mapping for the 'D_REQST' property.
--- Cause: java.sql.SQLException: [BEA][DB2 JDBC Driver]Transliteration
failed, reason: invalid UTF8 data
[Nov15 17:52:44] [ExecuteThread: '24' for queue:
'weblogic.kernel.Default'] ERROR
com.bdoc.web.presentation.actions.templates.ProduceDocumentAction >
Error while generating xml datastream
org.springframework.jdbc.UncategorizedSQLException: SqlMapClient
operation; uncategorized SQLException for SQL []; SQL state [HY000];
error code [0];
--- The error occurred in configxml/sqlconfig/xmlDAO.xml.
--- The error occurred while applying a result map.
--- Check the ATUPSTAT-AutoResultMap.
--- Check the result mapping for the 'D_REQST' property.
--- Cause: java.sql.SQLException: [BEA][DB2 JDBC Driver]Transliteration
failed, reason: invalid UTF8 data; nested exception is
com.ibatis.common.jdbc.exception.NestedSQLException:
--- The error occurred in configxml/sqlconfig/xmlDAO.xml.
--- The error occurred while applying a result map.
--- Check the ATUPSTAT-AutoResultMap.
--- Check the result mapping for the 'D_REQST' property.
--- Cause: java.sql.SQLException: [BEA][DB2 JDBC Driver]Transliteration
failed, reason: invalid UTF8 data
com.ibatis.common.jdbc.exception.NestedSQLException:
--- The error occurred in configxml/sqlconfig/xmlDAO.xml.
--- The error occurred while applying a result map.
--- Check the ATUPSTAT-AutoResultMap.
--- Check the result mapping for the 'D_REQST' property.
--- Cause: java.sql.SQLException: [BEA][DB2 JDBC Driver]Transliteration
failed, reason: invalid UTF8 data
Caused by: java.sql.SQLException: [BEA][DB2 JDBC Driver]Transliteration
failed, reason: invalid UTF8 data
Versions:
Db2 8.1
WebLogic 8.1 SP6
Ibatis 2.1.7.597
JDK 1.4.2
Thanks
Daniel
Re: a primitive question
Posted by Larry Meadors <lm...@apache.org>.
Yes, you can use the $ syntax instead of the # to do that.
Larry
On Nov 20, 2007 9:54 AM, Arora, Parvinder <PA...@att.com> wrote:
> Can I dynamically bind the table name ?
>
> ~Parvinder
>
>
> -----Original Message-----
> From: larry.meadors@gmail.com [mailto:larry.meadors@gmail.com] On Behalf
> Of Larry Meadors
> Sent: Monday, November 19, 2007 11:20 PM
> To: Arora, Parvinder; user-java@ibatis.apache.org
> Subject: Re: a primitive question
>
> You can probably use an insert or update to do that.
>
> Larry
>
>
> On Nov 19, 2007 4:39 PM, Arora, Parvinder <PA...@att.com> wrote:
> > A primitive question: How do I create tables using ibatis?
> >
> > I want to be able to do something like this
> >
> > Create table <XX> as
> > Select ...
> > From ...
>
RE: a primitive question
Posted by "Arora, Parvinder" <PA...@att.com>.
Can I dynamically bind the table name ?
~Parvinder
-----Original Message-----
From: larry.meadors@gmail.com [mailto:larry.meadors@gmail.com] On Behalf
Of Larry Meadors
Sent: Monday, November 19, 2007 11:20 PM
To: Arora, Parvinder; user-java@ibatis.apache.org
Subject: Re: a primitive question
You can probably use an insert or update to do that.
Larry
On Nov 19, 2007 4:39 PM, Arora, Parvinder <PA...@att.com> wrote:
> A primitive question: How do I create tables using ibatis?
>
> I want to be able to do something like this
>
> Create table <XX> as
> Select ...
> From ...
Re: a primitive question
Posted by Larry Meadors <lm...@apache.org>.
You can probably use an insert or update to do that.
Larry
On Nov 19, 2007 4:39 PM, Arora, Parvinder <PA...@att.com> wrote:
> A primitive question: How do I create tables using ibatis?
>
> I want to be able to do something like this
>
> Create table <XX> as
> Select ...
> From ...
Re: ibatis - db2 problem
Posted by Larry Meadors <lm...@apache.org>.
That's a new one...I'd google for that "Transliteration failed,
reason: invalid UTF8 data" message.
Might want to write a simple test using JDBC directly - I suspect
you'll have the same issue.
Larry
On Nov 16, 2007 10:15 AM, Daniel Benedykt <da...@benedykt.com> wrote:
> Hi
>
> I currently have a problem with an Ibatis-db2 call.
> Basically if I call a store procedure that returns a Date fields, I get
> an error. (If it doesn't have a Date fields, it works fine)
>
> Here is the trace:
>
> [Nov15 17:52:44] [ExecuteThread: '24' for queue:
> 'weblogic.kernel.Default'] ERROR
> com.bdoc.mtier.xmlgenerator.base.DataListDao > Error DataList Dao :
> SqlMapClient operation; uncategorized SQLException for SQL []; SQL state
> [HY000]; error code [0];
> --- The error occurred in configxml/sqlconfig/xmlDAO.xml.
> --- The error occurred while applying a result map.
> --- Check the ATUPSTAT-AutoResultMap.
> --- Check the result mapping for the 'D_REQST' property.
> --- Cause: java.sql.SQLException: [BEA][DB2 JDBC Driver]Transliteration
> failed, reason: invalid UTF8 data; nested exception is
> com.ibatis.common.jdbc.exception.NestedSQLException:
> --- The error occurred in configxml/sqlconfig/xmlDAO.xml.
> --- The error occurred while applying a result map.
> --- Check the ATUPSTAT-AutoResultMap.
> --- Check the result mapping for the 'D_REQST' property.
> --- Cause: java.sql.SQLException: [BEA][DB2 JDBC Driver]Transliteration
> failed, reason: invalid UTF8 data
> [Nov15 17:52:44] [ExecuteThread: '24' for queue:
> 'weblogic.kernel.Default'] ERROR
> com.bdoc.web.presentation.actions.templates.ProduceDocumentAction >
> Error while generating xml datastream
> org.springframework.jdbc.UncategorizedSQLException: SqlMapClient
> operation; uncategorized SQLException for SQL []; SQL state [HY000];
> error code [0];
> --- The error occurred in configxml/sqlconfig/xmlDAO.xml.
> --- The error occurred while applying a result map.
> --- Check the ATUPSTAT-AutoResultMap.
> --- Check the result mapping for the 'D_REQST' property.
> --- Cause: java.sql.SQLException: [BEA][DB2 JDBC Driver]Transliteration
> failed, reason: invalid UTF8 data; nested exception is
> com.ibatis.common.jdbc.exception.NestedSQLException:
> --- The error occurred in configxml/sqlconfig/xmlDAO.xml.
> --- The error occurred while applying a result map.
> --- Check the ATUPSTAT-AutoResultMap.
> --- Check the result mapping for the 'D_REQST' property.
> --- Cause: java.sql.SQLException: [BEA][DB2 JDBC Driver]Transliteration
> failed, reason: invalid UTF8 data
> com.ibatis.common.jdbc.exception.NestedSQLException:
> --- The error occurred in configxml/sqlconfig/xmlDAO.xml.
> --- The error occurred while applying a result map.
> --- Check the ATUPSTAT-AutoResultMap.
> --- Check the result mapping for the 'D_REQST' property.
> --- Cause: java.sql.SQLException: [BEA][DB2 JDBC Driver]Transliteration
> failed, reason: invalid UTF8 data
> Caused by: java.sql.SQLException: [BEA][DB2 JDBC Driver]Transliteration
> failed, reason: invalid UTF8 data
>
> Versions:
> Db2 8.1
> WebLogic 8.1 SP6
> Ibatis 2.1.7.597
> JDK 1.4.2
>
> Thanks
>
> Daniel
>