Hi,
i am reading an SQL query from a properties file and turning into a PreparedStatement.
The line from the properties file:
Code:
IN_ANSWERING_IDS= SELECT pk_msgId FROM EMail WHERE inReplyTo=?;
I use the Jakarta Commons PropertiesConfiguration class and i read the property like this:
Code:
PreparedStatement psIN_REPLY_SENDER_IDS;
psIN_REPLY_SENDER_IDS=con_.prepareStatement(props_.getString("IN_REPLY_SENDER_IDS"));
While debugging however, i see, that only "IN_ANSWERING_IDS= SELECT pk_msgId" has been read...
Same with the "OUT_INCOM_REFERENCES=UPDATE EMail SET incomingReferences=CONCAT(incomingReferences\, ?)\, inRefCounter=inRefCounter+1 WHERE pk_msgId=?;"
query. Only
"UPDATE EMail SET incomingReferences=CONCAT(incomingReferences" is read.
Any ideas?