UNIX for Advanced & Expert Users

I am facing the following issue when using db2. The JDBC prepared statement command is sending an incorrect value to the database for search. I did a truss on the app and here is the log. I want to know what is the value that is getting passed. is it possible.

26867/68: send(62, 0x02354050, 310, 0) = 310
26867/68: \0 ND0 Q\001\0 H \r\0 D !13C4C2F2C4 @ @ @ @ @ @ @ @ @ @ @ @ @ @
26867/68: D5E4D3D3C9C4 @ @ @ @ @ @ @ @ @ @ @ @E2E8E2E2C8F2F0F0 @ @ @ @ @ @
26867/68: @ @ @ @ S Y S L V L 0 1\006\018D0 S\001\012 $ P\0\n W I T H H
26867/68: O L D \0\0\0D0D003\001\0CA $14\0C2 S E L E C T I D _ A P P L
.
.
. I removed the SQL Query
.
.
26867/68: _ S Y S T F O R F E T C H O N L Y\0\0
26867/10: poll(0xF997FD18, 0, 50) = 0
26867/68: recv(62, 0x0234C040, 32767, 0) = 86
26867/68: \0 VD003\001\0 P $\b\0\0\0\0\0 0 0 0 0 0 D S N \0 E T S
26867/68: D B 2 D \0\0\0\0\0\0\0\0\0\0\0\0 A &88FE\0
26867/68: \0\0\0\0\0\0\0 \0\0\0\0
26867/68: send(62, 0x02354050, 144, 0) = 144
26867/68: \0 \D0 Q\001\0 V \f\0 D !13C4C2F2C4 @ @ @ @ @ @ @ @ @ @ @ @ @ @
26867/68: D5E4D3D3C9C4 @ @ @ @ @ @ @ @ @ @ @ @E2E8E2E2C8F2F0F0 @ @ @ @ @ @
26867/68: @ @ @ @ S Y S L V L 0 1\006\0\b !14\0\07FFF\006 ! AFFFF\0 4D003
26867/68: \001\0 . $12\013\010\t vD005\002 ?7FFF06 qE4D0\001\01714 z\0\002
26867/68: \t\0\0\f T T _ P L U M I C I N G
26867/68: recv(62, 0x0234C040, 32767, 0) = 200
26867/68: \0 D0 R\001\01A "05\00611 I\0\0\006 !02 $17\005 !1FF1\005 ! P01
26867/68: \013D0 S\001\0\r\0 /D8E3C4E2D8D3F3F7F0\01CD0 S\001\016\0 5\00611
26867/68: 9C01F4\006119D\0\0\006119E01F4\0 "D0 S\001\01C $1A\t vD0 3\0\n 3
26867/68: \014\t qE0 T\001D0\00106 qF0E0\0\0\0 WD003\001\0 Q $1B\0\0\0\0 d
26867/68: F0F2F0F0F0C4E2D5E7D9C6D5 @\0C5E3E2C4C2F2C4 @ @ @ @ @ @ @ @ @ @ @
26867/68: FFFFFF92\0\0\0\0\0\0\0\0FFFFFFFF\0\0\0\0\0\0\0\0 @ @ @ @ @ @ @ @
26867/68: @ @ @\0\0\0\0FF
26867/68: write(46, 0xC857BF40, 965) = 965
26867/68: 1 0 / 2 0 / 2 0 0 6 1 1 : 0 2 : 3 9 : 8 1 2 2 [ E x e c u
26867/68: t e T h r e a d : ' 5 6 ' f o r q u e u e : ' d e f a u

how about printing out the values that you passed to your prepared statement? Its much easier this way.

ya, as ghostdog74 said,

it would be very easier to have the statements printed and to make it sure, execute the statement in your test with samples prior to statements being prepared,

would be helpful many a times to avoid any crash..