|
Chris,
now i am getting
Cause: java.sql.SQLException: JZ0TE: Attempted
conversion between an illegal pair of types. Valid database datatypes are:
'varbinay, long binary, binary, image
Where should i be changing the datatype in POJO or
resultMap?
here is the code (msg field is defined as Text
datatype in db).
public class Email
{
private String from_addr;
private String to_addr;
private String subject;
//private String msg;
private byte[] msg;
public
byte[] getMsg() {
return
msg;
}
public void setMsg(byte[] bs)
{
msg = bs;
}
----------------------------------------------------------------------------------------------
<resultMap class="Email"
id="EmailResult">
<result
column="from_addr" property="from_addr"
/>
<result column="to_addr"
property="to_addr" />
<result column="subject" property="subject"
/>
<result column="msg"
property="msg" jdbcType="CLOB" />
</resultMap>
<select id="getEmailById"
parameterClass="int"
resultMap="EmailResult">
SELECT from_addr, to_addr, subject,
msg
FROM
email_store
WHERE
id_email = #VALUE#
</select>
------------------------------------------------------------------------------------------------------
Thanks
Balaji
----- Original Message -----
Sent: Wednesday, March 22, 2006 4:18
PM
Subject: Re: Sybase JConnect 5.5 &
CLOB
You should be reading the CLOB out of the database into a byte[] rather
than a String. From there you can convert it into a String and apply any
encoding that might be necessary.
Chris Mathrusse
[EMAIL PROTECTED]
Sybase,
Inc
One Sybase Drive
Dublin, CA 94568
(925) 236-5553
When i try to read a 'TEXT' datatype field from Sybase 12.0
database &
JConnect 5.5,
- datatype in POJO is String (also
tried java.sql.Clob)
- jdbcType in resultMap is 'CLOB'
i get the
following error message shown below. Looks like getClob(string)
is
not implemented in Jconnect yet.
Does anyone know how to get this to
work, any
workaround?
Thanks
Balaji
/***************************************************************************
*********************/
ERROR
MESSAGE
/***************************************************************************
*********************/
Caused
by:
java.lang.UnsupportedOperationException: The
method
com.sybase.jdbc2.jdbc.SybResultSet.getClob(String) is not supported
and
should not be
called.
at
com.sybase.jdbc2.jdbc.ErrorMessage.raiseRuntimeException(ErrorMessage.java:7
63)
at
com.sybase.jdbc2.utils.Debug.notSupported(Debug.java:366)
at
com.sybase.jdbc2.jdbc.SybResultSet.getClob(SybResultSet.java:1371)
at
com.ibatis.sqlmap.engine.type.ResultGetterImpl.getClob(ResultGetterImpl.java
:108)
at
com.ibatis.sqlmap.engine.type.ClobTypeHandlerCallback.getResult(ClobTypeHand
lerCallback.java:28)
at
com.ibatis.sqlmap.engine.type.CustomTypeHandler.getResult(CustomTypeHandler.
java:52)
at
com.ibatis.sqlmap.engine.mapping.result.BasicResultMap.getPrimitiveResultMap
pingValue(BasicResultMap.java:552)
at
com.ibatis.sqlmap.engine.mapping.result.BasicResultMap.getResults(BasicResul
tMap.java:311)
at
com.ibatis.sqlmap.engine.execution.SqlExecutor.handleResults(SqlExecutor.jav
a:390)
at
com.ibatis.sqlmap.engine.execution.SqlExecutor.executeQuery(SqlExecutor.java
:184)
at
com.ibatis.sqlmap.engine.mapping.statement.GeneralStatement.sqlExecuteQuery(
GeneralStatement.java:205)
at
com.ibatis.sqlmap.engine.mapping.statement.GeneralStatement.executeQueryWith
Callback(GeneralStatement.java:173)
at
com.ibatis.sqlmap.engine.mapping.statement.GeneralStatement.executeQueryForO
bject(GeneralStatement.java:104)
at
com.ibatis.sqlmap.engine.impl.SqlMapExecutorDelegate.queryForObject(SqlMapEx
ecutorDelegate.java:561)
at
com.ibatis.sqlmap.engine.impl.SqlMapExecutorDelegate.queryForObject(SqlMapEx
ecutorDelegate.java:536)
at
com.ibatis.sqlmap.engine.impl.SqlMapSessionImpl.queryForObject(SqlMapSession
Impl.java:93)
at
com.ibatis.sqlmap.engine.impl.SqlMapClientImpl.queryForObject(SqlMapClientIm
pl.java:70)
-----
Original Message -----
From: "Nathan Maves"
<[EMAIL PROTECTED]>
To:
<[email protected]>
Sent: Tuesday, March 21, 2006 5:51
PM
Subject: Re: multiple setters
> Ahhh yeah... not
good don't have them. :)
>
> They are against the java bean
specification.
>
> Nathan
> On Mar 21, 2006, at 4:38 PM, Ben
Munat wrote:
>
> > Hey All... I seem to remember someone
talking recently about
> > difficulties with a property set by ibatis
having multiple setters.
> > Does this ring a bell?
>
>
> >
b
>
>
>
|
