Mysql DATA TOO LONG

Bug #263896 reported by David P
2
Affects Status Importance Assigned to Milestone
TobFlow
New
High
Eric Fesler
1.4
Fix Released
High
Eric Fesler

Bug Description

When I add a field like this one :

<field attributeName="Immeuble" type="sqlLookup" defaultMode="E" top="7" left="824" width="176" height="19">
         <description></description>
         <label language="FR">Immeuble</label>
         <label language="EN">??</label>

         <param name="dbURL">jdbc:oracle:thin:@localhost:1521:compiere</param>
         <param name="dbDriver">oracle.jdbc.driver.OracleDriver</param>
         <param name="dbLogin">comp302</param>
         <param name="dbPassword">compiere</param>

         <param name="dbQuery">aaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaa aaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaa
         aaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaa aaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaa aaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaa aaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaa aaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaa aaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaa aaaaaaaaaaaaaaaaaaaa</param>

         <param name="cols">value;name;</param>
         <param name="updates">Immeuble=2;</param>

      <param name="hiddencols">ad_org_id;value</param>
      <param name="hiddenupdates">Immeuble_value=1;Immeuble_value=2;</param>
     </field>

I've got with Tobflow with MySQL this exception :

Exception invoking listener method uploadModel of component admin/ModelAdmin: Failure invoking listener method 'public void com.audaxis.tobflow.tapestry.page.admin.ModelAdmin.uploadModel()' on $ModelAdmin_176@3c1[admin/ModelAdmin]: (HibernateTemplate): encountered SQLException [Data truncation: Data too long for column 'value' at row 1]; nested exception is java.sql.BatchUpdateException: Data truncation: Data too long for column 'value' at row 1

Revision history for this message
Eric Fesler (efesler) wrote :

I will put a default SQL schema in the repository taking this into account

Eric Fesler (efesler)
Changed in tobflow:
assignee: nobody → glaurung
importance: Undecided → High
Revision history for this message
David P (klessou) wrote :
To post a comment you must log in.
This report contains Public information  
Everyone can see this information.

Other bug subscribers

Remote bug watches

Bug watches keep track of this bug in other bug trackers.