Re: Inserting packed values into a DB2/400 table via JDBC

You are making things way too difficult.  The SQL processor on the 400 
will take care of packing the data for you.  Just create an SQL string 
containing:

INSERT INTO IT005P (ITEM_NUMBER) VALUES(47001)

and execute it.
===
Marshall Dunbar
DPS, Inc.
marshall@xxxxxxxxxxx
direct:(828)635-5561
main office:(317)574-4300 (800)654-4689
====



EDoxtator <doc6502@xxxxxxxxx> 
Sent by: java400-l-bounces@xxxxxxxxxxxx
10/28/2004 10:37 AM
Please respond to
Java Programming on and around the iSeries / AS400 
<java400-l@xxxxxxxxxxxx>


To
java400-l@xxxxxxxxxxxx
cc

Subject
Inserting packed values into a DB2/400 table via JDBC






Hi All

I've got a table that has several packed columns.  How do I insert packed
values into this table from a Windows PC via JDBC?  I'm using JTOpen 4.5.

Here is a snippet of the code I'm using to try and create the value:

Connection con = null;
com.ibm.as400.access.AS400PackedDecimal a = new 
     com.ibm.as400.access.AS400PackedDecimal( 7, 0 );

::: snipped connection code :::

   // Create and execute SQL Insert 
   Statement stmt = con.createStatement();
   byte[] b = a.toBytes( new BigDecimal( 47001 ) );
   String value = b.toString();

   String SQLStmt =
                 "INSERT INTO IT005P " +
        "(ITEM_NUMBER) " +
        "VALUES(\"" + value + "\")";

   ResultSet rs = con.execute( SQLStmt );

::: remainder of program snipped :::

Of course, what I see if I log the SQL statement is:

SQL Statement = INSERT INTO IT005P (ITEM_NUMBER) VALUES("[B@16672d6")

Error: [SQL0206] Column "[B@16672d6" not in specified tables.

If anyone has any ideas, I'd really appreciate it.

Thanks!

-Ed


--
This is the Java Programming on and around the iSeries / AS400 (JAVA400-L) 
mailing list
To post a message email: JAVA400-L@xxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/mailman/listinfo/java400-l
or email: JAVA400-L-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives
at http://archive.midrange.com/java400-l.