Re: MySQL 'text' datatype mapping

[Eric VanWieren]

Oh my word. Ok, I am a dolt. since i was requesting 'desc' it was calling desc as in desc table.

Oops.

Thanks though,

Eric

On 8/10/06, Eric VanWieren <[EMAIL PROTECTED]> wrote:

Christian,

This is the declaration of the SourceClinic class

private String notes;

There are the appropriate getters and setters.

Here is the code for my SqlMap

<sqlMap namespace="SourceClinic">
   
    <select id="getSourceClinic" parameterClass="int" resultClass="com.test.test.SourceClinic">
        SELECT
            ID             as id,
            NAME        as name,
            VISIBLE        as visible,
            DESC        as notes
        FROM SOURCECLINIC
        WHERE ID = #value#
    </select>
   
</sqlMap>

This is the desc from the mysql database
mysql> desc sourceclinic;
+---------+-------------+------+-----+---------+----------------+
| Field   | Type        | Null | Key | Default | Extra          |
+---------+-------------+------+-----+---------+----------------+
| id      | int(11)     |      | PRI | NULL    | auto_increment |
| name    | varchar(50) |      | UNI |         |                |
| desc    | text        | YES  |     | NULL    |                |
| visible | tinyint(1)  |      |     | 1       |                |
+---------+-------------+------+-----+---------+----------------+
4 rows in set (0.00 sec)

mysql>

Thanks for any help you can give me.

Eric

On 8/10/06, Poitras Christian <[EMAIL PROTECTED]> wrote:

Can you send you sqlmap file?

I use text fields with MySQL. So it is probably a config problem.

 

Christian

---

From: Eric VanWieren [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, 09 August 2006 11:22
To: user-java@ibatis.apache.org
Subject: MySQL 'text' datatype mapping

Hello,

I have a field in one of my tables that is of type 'text' in my MySQL database. I am trying to map it back to a type of java.lang.String, but it keeps coming back telling me there is an error in my syntax.

Am I missing something here? I can grab all the other values out of the table, just not the one for the field of type 'text'

Thanks in advance.

Eric
-- iBatis newbie --