I am inserting pstmt.setTimestamp(5,java.sql.Timestamp) and setting some varchars as strings in the table throught prepared statement which is calling a procedure. and getting exception ORA-01461: can bind a LONG value only for insert into a LONG column I am using weblogic 5.0 and oracle 8.17. Please help me fast. I saw a few issues discussed on this site about this exception but no one comes near to the problem. For convience I am providing the code underneth.
pstmt = conn.prepareStatement(procedure name);
pstmt.setString(1, product.toUpperCase()); pstmt.setInt(2, csr_id); pstmt.setString(3, shard); pstmt.setTimestamp(4, timestamp); pstmt.setString(5, source); pstmt.setString(6, currentAcc); pstmt.setString(7, id); pstmt.setString(8, persona); pstmt.setString(9, content); pstmt.setString(10, currentLoc); pstmt.setInt(11, playerID); pstmt.setString(12, target1id); pstmt.setString(13, target1persona); pstmt.setString(14, subType); pstmt.executeUpdate(); all the above are member vareiables of the class declared as
/** xml event */ private String xmlEvent;
/** This keeps the name of the product */ private String product;
/** This keeps the source */ private String source;
/** This keeps the shard */ private String shard;
/** The persona attribute of the event that is currently being parsed. */ private String currentAcc;
/** The target1 account */ private String target1account;
/** The target1 persona for the currently read event. */ private String target1persona;
/** The target1 id for the currently read event */ private String target1id;
/** The location attribute of the event that is currently being parsed. */ private String currentLoc;
/** Holds id of the event */ private String id;
/** Holds content of event */ private String content;
/** Holds current persona name */ private String persona;
/** sysop event sub type */ private String subType;
/** The event date for the currently read event */ private String eventDate;
/** The event date for the currently read event */ private String eventTime;
/** Timestamp constructed from date and time */ private Timestamp timestamp;
/** a kind of boolean value identifying if the events is generated by the CSR or DEVELOPER */ private String iscsr;
/** csr_id of the events generator */ private int csr_id;
Previous Topic
