sql query in web.xml or property file

[Ankur Bohra]

Hello,

anyone who can help me with some code example of writing a sql query in web.xml or property file.
as i am developing a application with a variable sql query which may change any time.

Select query
Update query
Insert Query

[Ulf Dittmer]

I would put it into a properties file. That way you can write code to reload the file contents at runtime when a particular URL is hit. That's not possible if you put it into web.xml (for which you'd need to reload the whole web application).

[Ankur Bohra]

But how can i write a insert query in property, where each time my parameters changes

[Hussein Baghdadi]

But how can i write a insert query in property, where each time my parameters changes

How a property file would differ from web.xml if you are hard coding your SQL into them?

[Ben Souther]

If you use prepared statements you can list your parameters as '?' symbols.

[Bear Bibeault]

Originally posted by John Todd:


How a property file would differ from web.xml if you are hard coding your SQL into them?

Because property files can be reloaded at any time.

[Radhakrishna Bhat]

Here is what i do in my applications.

use context-param to store connection strings.

use properties file for Queries.