inserting number into oracle sql - using jython

Question

I have this insert command where iam trying to insert a number to be taken from loop

i=0
for line in column:
    myStmt.executeQuery("INSERT INTO REVERSE_COL
( TABLE_NAME,COL_NAME,POS) values 
(,'test','"+column[i]+"','"+i+"'")
i=i+1

POS IS NUMBER DATATYPE

but it works if i hard code as 1

i=0
for line in column:
    myStmt.executeQuery("INSERT INTO REVERSE_COL
( TABLE_NAME,COL_NAME,POS) values 
(,'test','"+column[i]+"',1")

I have tried only i , +i+ and other method but its not working any suggestion how to solve this .

Thanks everyone .

Answer 1

I have no jython experience, but I will still try to offer my personal approach and advice. Take from it what you will.

The first thing that I would look into, and perhaps this is something someone else knows offhand, is the way that a number is concatenated to the string. I'm speaking from a C++ background here, but a number i may well be converted to the ASCII character representing that value, and not necessarily the character that you intend.

For example, if i is 9, it may be placing a TAB into the string and not the number 9, which would be an ASCII value 57.

Again, I'm not telling you this IS the answer...but it's the first thing that pops into my mind. Good luck!