Yes. Exactly! Thanks so much for pointing this out!
Haitao
On Wed, 4 Aug 2004 08:53:28 -0500 (CDT), Mark Matthews <[EMAIL PROTECTED]> wrote:
>
>
> > Hi,
> >
> > I have following code to insert a row into a table - schema follows:
> > :
> > PreparedStatement insertData = targetConnection.prepareStatement("insert
> > into CompanyParticipationLevel
> > (siteId,nodeId,companyId,editionId,participation
> > LevelId,participationText,participationLogo) values (?, ?, ?, ?, ?, ?,
> > ?)");
> >
> > Statement sourceData = sourceConnection.createStatement();
> > ResultSet sourceResultSet = sourceData.executeQuery("select
> > cpl.siteId,
> > isnull(cpl.nodeId,0) as nodeId, cpl.companyId, cpl.editionId,
> > cpl.participationL
> > evelId, cpl.participationText, cpl.participationLogo FROM
> > CompanyParticipationLe
> > vel cpl where cpl.siteId=8 and cpl.participationLevelTypeId=1");
> > Object value = null;
> > while (sourceResultSet.next()) {
> > insertData.clearParameters();
> > System.out.print("processing (");
> >
> > for(int i = 1; i <= 7; i++){
> > value = sourceResultSet.getObject(i);
> > insertData.setObject(i, value);
> > System.out.print("("+value+")");
> > }
> > System.out.println(")");
> > insertData.executeUpdate();
> > }
> >
> > +----------------------+---------------------+------+-----+---------+-------+
> > | Field | Type | Null | Key | Default |
> > Extra |
> > +----------------------+---------------------+------+-----+---------+-------+
> > | siteId | int(10) unsigned | | PRI | 0 |
> > |
> > | nodeId | int(10) unsigned | | PRI | 0 |
> > |
> > | companyId | int(10) unsigned | | PRI | 0 |
> > |
> > | editionId | int(10) unsigned | | PRI | 0 |
> > |
> > | participationLevelId | tinyint(3) unsigned | | PRI | 0 |
> > |
> > | participationText | text | YES | | NULL |
> > |
> > | participationLogo | varchar(128) | YES | | NULL |
> > |
> > +----------------------+---------------------+------+-----+---------+-------+
> >
> > The output of the program:
> > processing ((8)(0)(56361)(0)(4)(null)( ))
> > Exception in thread "main" java.sql.SQLException: Column 'siteId' cannot
> > be null
> >
> > at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:2551)
> > at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1443)
> > at
> > com.mysql.jdbc.ServerPreparedStatement.serverExecute(ServerPreparedSt
> > atement.java:1239)
> > at
> > com.mysql.jdbc.ServerPreparedStatement.executeInternal(ServerPrepared
> > Statement.java:903)
> > at
> > com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:1871)
> > at
> > com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:1796)
> > at com.mysql.jdbc.PreparedStatement.executeUpdate
> > (PreparedStatement.java:1658)
> >
> > It is obvious that I did setObject correctly, there are 7 columns and
> > I have 7 value supplied. But JDBC complains that first column is null.
> >
> > Is it a bug or someone can tell me what is going on?
> >
> > Thanks
> >
> > Haitao
>
> What version of Connector/J are you using? This looks like a bug that was
> fixed in 3.1.3.
>
>
> -Mark
>
>
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
