LinuxQuestions.org
Help answer threads with 0 replies.
Home Forums Tutorials Articles Register
Go Back   LinuxQuestions.org > Forums > Non-*NIX Forums > Programming
User Name
Password
Programming This forum is for all programming questions.
The question does not have to be directly related to Linux and any language is fair game.

Notices


Reply
  Search this Thread
Old 01-08-2008, 01:38 PM   #1
kpachopoulos
Member
 
Registered: Feb 2004
Location: Athens, Greece
Distribution: Gentoo,FreeBSD, Debian
Posts: 705

Rep: Reputation: 30
java: SQL query falsely read from properties file


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?
 
  


Reply



Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off



Similar Threads
Thread Thread Starter Forum Replies Last Post
java: SQL duplicate key exception or query for key is faster kpachopoulos Programming 1 01-06-2008 04:32 AM
properties file in java sajith Programming 1 12-16-2007 11:28 AM
Error in SQL Query.. gobi_dgm Linux - Software 1 02-03-2007 09:41 AM
Java File Processing using Scanner; Can't get it to read file in running directory xemous Programming 2 09-26-2006 06:13 PM
can't read from file in java alaios Programming 2 04-24-2004 05:34 AM

LinuxQuestions.org > Forums > Non-*NIX Forums > Programming

All times are GMT -5. The time now is 04:27 AM.

Main Menu
Advertisement
My LQ
Write for LQ
LinuxQuestions.org is looking for people interested in writing Editorials, Articles, Reviews, and more. If you'd like to contribute content, let us know.
Main Menu
Syndicate
RSS1  Latest Threads
RSS1  LQ News
Twitter: @linuxquestions
Open Source Consulting | Domain Registration