Re: JTOpen 2.0 problem

Sorry,
foget to indicate that ,
the program runs on Win2000 to an AS/400 at V4R3M0 with SUN JDK1.3


On Thu, 11 Jan 2001 10:09:57 -0600, Dave Wall wrote:

>
>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
>+---
>


<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
+---