Re: JTOpen 2.0 problem -- JAVA400-L


Two things could be going on here.

First, the check-for-truncation default was changed from false to true in
JTOpen 2.0.  In v4r5 and earlier, this flag defaulted to false so you
wouldn't know your data was being truncated unless your program set the
flag to true.  We think it is better (and will match the native JDBC
driver) to default the other way.  In JTOpen 2.0 we tell you your data is
being truncated unless you tell us you don't want to know.  So, one
possibility is your data was always truncated.  In v4r5 and before, since
the default is no warning, we wrote the data anyway.  Now with the default
being true, we throw an exception when data is truncated.  To go back to
the old behavior, set the flag to false -- ";data truncation=false" on your
URL.  (Also feel free to let us know if you agree with the change).

Second, once we set the default to true we found a couple places where we
threw exceptions when we shouldn't have (data was not truncated).  We fixed
these places (SQLReal, SQLDouble and SQLFloat).  The fixes will be out in
the next open source drop.

David Wall
AS/400 Toolbox for Java


"Franco Biaggi" <fbiaggi@ticino.com>@midrange.com on 01/10/2001 01:21:34 AM

Please respond to JAVA400-L@midrange.com

Sent by:  owner-java400-l@midrange.com


To:   "JAVA400-L@midrange.com" <JAVA400-L@midrange.com>
cc:
Subject:  JTOpen 2.0 problem



Hello,
following error with JTOpen 2.0 (The application work fine with the JTOpen
shipped with VAJ Enterprise).
(There is no data truncation...)

com.ibm.vap.common.VapPrepareFailureException: Prepare failure; nested
exception is:
        java.sql.DataTruncation: Data truncation
com.ibm.vap.common.VapPrepareFailureException: Prepare failure; nested
exception is:
        java.sql.DataTruncation: Data truncation
java.sql.DataTruncation: Data truncation at
com.ibm.as400.access.AS400JDBCPreparedStatement.testDataTruncationAS400JDBCPreparedStatement.java:1891)

        at
com.ibm.as400.access.AS400JDBCPreparedStatement.setValue(AS400JDBCPreparedStatement.java:1871)

        at
com.ibm.as400.access.AS400JDBCPreparedStatement.setObject(AS400JDBCPreparedStatement.java:1551)

        at
com.ibm.ivj.db.base.DatabaseStringField.setFieldObject(DatabaseStringField.java)

        at
com.ibm.ivj.db.base.DatabaseTypeField.setObject(DatabaseTypeField.java)
        at
com.ibm.ivj.db.base.DatabaseConnection.setInputValues(DatabaseConnection.java)

        at
com.ibm.ivj.db.base.DatabaseConnection.executeQuerySpecWithValues(DatabaseConnection.java)

        at
com.ibm.ivj.db.base.DatabaseQuerySpec.executeOnConnection(DatabaseQuerySpecjava)

        at
com.ibm.vap.RelationalPersistence.SqlQuery.executeNonSelectWith(SqlQuery.java)

        at
com.ibm.vap.RelationalPersistence.SqlQuery.execute(SqlQuery.java)
        at
com.ibm.vap.RelationalPersistence.SqlQuery.execute(SqlQuery.java)
        at
com.ibm.vap.RelationalPersistence.RelationalServiceObject.executeQuery(RelationalServiceObject.java)

        at
com.ibm.vap.RelationalPersistence.RelationalServiceObject.executeOneInsert(RelationalServiceObject.java)

        at
com.ibm.vap.RelationalPersistence.RelationalServiceObject.executeInsert(RelationalServiceObject.java)

        at com.ibm.vap.Persistence.ServiceObject.insert(ServiceObject.java)
        at com.ibm.vap.Persistence.ServiceObject.insert(ServiceObject.java)
        at
com.ibm.vap.Persistence.PersistentHomeCollection.executeInsert(PersistentHomeCollection.java)

        at
com.ibm.vap.Persistence.NewPersistentState.synchronize(NewPersistentState.java)

        at com.ibm.vap.Transactions.Version.synchronize(Version.java)
        at
com.ibm.vap.Persistence.Resource.synchronizeVersions(Resource.java)
        at com.ibm.vap.Persistence.Resource.primPrepare(Resource.java)
        at
com.ibm.vap.Persistence.ActiveResourceState.prepare(ActiveResourceState.java)

        at com.ibm.vap.Persistence.Resource.prepare(Resource.java)
        at
com.ibm.vap.Persistence.ResourceManager.prepareResources(ResourceManager.java)

        at
com.ibm.vap.Persistence.ResourceManager.synchronize(ResourceManager.java)
        at
com.ibm.vap.Transactions.Transaction.synchronizeToResources(Transaction.java)

        at
com.ibm.vap.Transactions.Transaction.primCommit(Transaction.java)
        at
com.ibm.vap.Transactions.ActiveTransactionState.primCommit(ActiveTransactionState.java)

        at
com.ibm.vap.Transactions.ActiveTransactionState.commit(ActiveTransactionState.java)

        at com.ibm.vap.Transactions.Transaction.commit(Transaction.java)


<html>

<head>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">
<meta name="Author" content="Franco Biaggi">
<meta name="GENERATOR" content="Franco Biaggi">
</head>

<body>

<p>&nbsp; </p>

<table BORDER="1" COLS="1" WIDTH="452" BGCOLOR="#FFFF00">
  <tr>
    <td width="446"><font face="Comic Sans MS"><small><small><br>
    <font color="#3333FF"><a href="http://www.ticino.com/usr/fbiaggi/
">Franco Biaggi</a></font><small><br>
    <font color="#3333FF"><a href="http://www.sisa.ch">SISA Studio
Informatica SA</a></font><small><small><small> <br>
    </small></small></small><font color="#3333FF">R&amp;D
Services</font><small><small><small>
    <br>
    </small></small></small><font color="#3333FF">Via Carvina
1</font><small><small><small> <br>
    </small></small></small><font color="#3333FF">CH-6807
Taverne</font><small><small><small> <br>
    </small></small></small><font color="#3333FF">Tel. +41 91 935 75
35&nbsp; Fax. +41 91 935
    75 30</font></small></small></small><br>
    </small></small></small><font color="
#3333FF">ICQ:59714125(disabled)</font><small><small><small> <br>
</font></td>
  </tr>
</table>
</body>
</html>



+---
| This is the JAVA/400 Mailing List!
| To submit a new message, send your mail to JAVA400-L@midrange.com.
| To subscribe to this list send email to JAVA400-L-SUB@midrange.com.
| To unsubscribe from this list send email to JAVA400-L-UNSUB@midrange.com.
| Questions should be directed to the list owner: joe@zappie.net
+---



+---
| This is the JAVA/400 Mailing List!
| To submit a new message, send your mail to JAVA400-L@midrange.com.
| To subscribe to this list send email to JAVA400-L-SUB@midrange.com.
| To unsubscribe from this list send email to JAVA400-L-UNSUB@midrange.com.
| Questions should be directed to the list owner: joe@zappie.net
+---