Re: [Bsf4oorexx-support] How to use prepared statements in ooRexx with bsf4oorexx and db2

[Roger B. <sf...@bi...>]

Hi Rony,

found a sample fort he box function and test it, but got the same error

 

    47 *-* stmt3 = con~prepareStatement("INSERT INTO test VALUES(:name,
:place)"

)

       >V>   CON => "com.ibm.db2.jcc.uw.UWConnection@59824bc"

       >L>   "INSERT INTO test VALUES(:name, :place)"

       >A>   "INSERT INTO test VALUES(:name, :place)"

       >M>   "PREPARESTATEMENT" => "com.ibm.db2.jcc.am.jo@2dcb4eaa"

       >>>   "com.ibm.db2.jcc.am.jo@2dcb4eaa"

       >=>   STMT3 <= "com.ibm.db2.jcc.am.jo@2dcb4eaa"

    48 *-* name = 'Roger Bilau'

       >L>   "Roger Bilau"

       >>>   "Roger Bilau"

       >=>   NAME <= "Roger Bilau"

    49 *-* place = 'Bonn'

       >L>   "Bonn"

       >>>   "Bonn"

       >=>   PLACE <= "Bonn"

    50 *-* name = box('string', name)

       >L>   "string"

       >A>   "string"

       >V>   NAME => "Roger Bilau"

       >A>   "Roger Bilau"

       >F>   BOX => "java.lang.String@7e999262"

       >>>   "java.lang.String@7e999262"

       >=>   NAME <= "java.lang.String@7e999262"

    51 *-* place = box('string', place)

       >L>   "string"

       >A>   "string"

       >V>   PLACE => "Bonn"

       >A>   "Bonn"

       >F>   BOX => "java.lang.String@1459a0dd"

       >>>   "java.lang.String@1459a0dd"

       >=>   PLACE <= "java.lang.String@1459a0dd"

    52 *-* stmt3~setJccStringAtName("name", name)

       >V>   STMT3 => "com.ibm.db2.jcc.am.jo@2dcb4eaa"

       >L>   "name"

       >A>   "name"

       >V>   NAME => "java.lang.String@7e999262"

       >A>   "java.lang.String@7e999262"

    93 *-* syntax:

    94 *-* trace o

jexc~toString: org.apache.bsf.BSFException: /// Java-exception (RexxAndJava)
occ

urred: [java.lang.reflect.InvocationTargetException], getCause():
[com.ibm.db2.j

cc.am.SqlSyntaxErrorException: [jcc][10448][12695][3.64.106] Ung³ltiges
Argument

: Parametermarke 'name' war in der SQL-Zeichenfolge nicht vorhanden.
ERRORCODE=-

4461, SQLSTATE=42815] \\\

BSF4ooRexx subfunction "invoke": object 'com.ibm.db2.jcc.am.jo@2dcb4eaa' -
metho

d [SETJCCSTRINGATNAME], method not found or error (exception) executing
method!

jobj~toString: java.lang.reflect.InvocationTargetException

 

regards

Roger