Hi all,
does anybody have a link to some document comparing where and when to use prepared statements?
Can anyone say what are the main points where prepared statements are better?
I've got an app where I haven't used any prepared statments at all and I think I need to implement a better framework for my database access.
Currently every database op has the SQL statement in two strings, one for Oracle and one for mySQL and the appropriate
string is chosen depending on the config.
I don't really like this because I always did apps where I can use stored procedures and I don't need any SQL in my
Java code.
If it turns into a big app, and we get a seperate database administrator, then he'll have to start diving into the java source files whenever he changes the database. Are there any other frameworks I can use?
Thanks!
Adam
I have seen things you people would not believe, attack ships on fire off the shoulder of Orion, c-beams sparkling in the dark near the Tennhauser Gate. All these moments will be lost in time, like tears in the rain.