When you subtract two dates the result already is a number.
Using to_number on the result will make Oracle do an implicit conversion
to CHAR and then trying to convert it back again. Depending on your
NLS-parameters that implicit conversion will break stuff.
Regards,
Joakim
On Sat, 2008-08-23
Joakim Olsson napisaÅ(a):
I have had this problem since switching to Geronimo from a clean
Tomcat-environment too.
The problem is that Geronimo uses a newer version of CGLIB than iBatis
is
supporting.
I solved the problem by putting the correct version of cglib.jar in my
webapps lib-dir
Are you by chance using Oracle from Geronimo?
I had exactly this problem when I switched to Geronimo. The cause was some
problem in the DBPool-setup.
Shutdown Geronimo, edit the file geronimo-root/var/config/config.xml. In
the gbean for your DBPool, add attribute
And of course I sent my reply to Larry directly instead of the list :-D
On tis, 2005-06-28 at 20:33 +0200, Joakim Olsson wrote:
That shouldn't happen since sequence.currval is limited to the current
session and only valid until the data has been commit:ed or rolled back
if I remember correctly