Presuming you aren't getting any exceptions.
I can think of 2 options,
1) I have heard about debugging statements have you tried using one of those and seeing the actual string that is being used by the JDBC, then try running that yourself and see if it works.
2) you aren't comitting the work to the database, We can't see your connection, so you may have turned off autocomit, or not turned it on.
Wendy Gibbons wrote:Presuming you aren't getting any exceptions.
I can think of 2 options,
1) I have heard about debugging statements have you tried using one of those and seeing the actual string that is being used by the JDBC, then try running that yourself and see if it works.
2) you aren't comitting the work to the database, We can't see your connection, so you may have turned off autocomit, or not turned it on.
Wendy Gibbons wrote:Presuming you aren't getting any exceptions.
I can think of 2 options,
1) I have heard about debugging statements have you tried using one of those and seeing the actual string that is being used by the JDBC, then try running that yourself and see if it works.
2) you aren't comitting the work to the database, We can't see your connection, so you may have turned off autocomit, or not turned it on.
Thank's.
autocommit=true.
I tried this:
all the same does not work ...
In the example above you are setting autocommit=false, so turning it off oops.
Wendy Gibbons wrote:In the example above you are setting autocommit=false, so turning it off oops.
But in the example above, commit is used too. It should work the same. I assume Victor was just trying it the other way just for sure.
I'm slightly suspicious of binding date values as Strings. Is the inputData.period column a VARCHAR or other text format? If it is actually declared as DATE, an implicit conversion takes place, which is prone to problems.
Wendy Gibbons wrote:In the example above you are setting autocommit=false, so turning it off oops.
But in the example above, commit is used too. It should work the same. I assume Victor was just trying it the other way just for sure.
I'm slightly suspicious of binding date values as Strings. Is the inputData.period column a VARCHAR or other text format? If it is actually declared as DATE, an implicit conversion takes place, which is prone to problems.
You would be much easier to understand if you took that bucket off of your head. And that goes for the tiny ad too!
a bit of art, as a gift, the permaculture playing cards