commons-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Konstantinos Pachopoulos <kostaspa...@yahoo.gr>
Subject SQL query falsely read from properties file
Date Tue, 08 Jan 2008 18:57:36 GMT
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=?;
[/code]

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"));
[/code]

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?


      ___________________________________________________________
Support the World Aids Awareness campaign this month with Yahoo! For Good http://uk.promotions.yahoo.com/forgood/

---------------------------------------------------------------------
To unsubscribe, e-mail: user-unsubscribe@commons.apache.org
For additional commands, e-mail: user-help@commons.apache.org


Mime
View raw message