Problem: [PWS0004] Required parameter was not provided. -- JAVA400-L

Hello,
I receive following strange error executing a prepared statement (work fine on 
DB2 UDB 7.1):
Using JTOpen under Win2k and OS/400 V4R3M0

java.sql.SQLException: [PWS0004] Required parameter was not provided.
        at com.ibm.as400.access.JDError.throwSQLException(JDError.java:339)
        at 
com.ibm.as400.access.AS400JDBCStatement.commonExecute(AS400JDBCStatement.java:521)
        at 
com.ibm.as400.access.AS400JDBCPreparedStatement.executeUpdate(AS400JDBCPreparedStatement.java:888)
        at sisaBase.Countries.performSQLInsert(Countries.java:248)

The code:
        ....
        try {
                // If needed prepare the insertCountry Statement
                if ( insertCountry == null )
                        insertCountry = 
User.getSQLConnection().prepareStatement( " INSERT INTO " + getSQLTableName() +
                                " ( SHORTNAME, ISOCODE, PTTCODE ) VALUES ( ?, 
?, ? )" );

                insertCountry.setString( 1, obj.getShortName() );               
                insertCountry.setString( 2, obj.getIsoCode() );         
                insertCountry.setString( 3, obj.getPttCode() );         
                
                insertCountry.executeUpdate();
        }
        catch (Throwable th) {
                sisaUtil.misc.Tools.handleException(th);
        }

Thanks for help.

<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 mailing list archive is Copyright 1997-2025 by midrange.com and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available on our policy page. If you have questions about this, please contact [javascript protected email address].

Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.