You are viewing a plain text version of this content. The canonical link for it is here.
Posted to users@tomcat.apache.org by Jose Gargallo <j....@dysmatica.es> on 2007/08/03 11:40:52 UTC
JDBC problem: PreparedStatement.setTimestamp function ignores milliseconds
in TOMCAT + ddbb Oracle
Hi all,
I have a J2EE application that runs in Oracle and Postgres databases and
OC4J and Tomcat servers. I've got a problem using the
PreparedStatement.setTimestamp function runing TOMCAT 5.5 + Oracle 9i
becouse it ignores the milliseconds. It works fine runing in OC4J 10.1.3
and Oracle 9i. ¿Why?
Any answer will be welcome!
Thanks
---------------------------------------------------------------------
To start a new topic, e-mail: users@tomcat.apache.org
To unsubscribe, e-mail: users-unsubscribe@tomcat.apache.org
For additional commands, e-mail: users-help@tomcat.apache.org
Re: [OT] JDBC problem: PreparedStatement.setTimestamp function ignores
milliseconds in TOMCAT + ddbb Oracle
Posted by Christopher Schultz <ch...@christopherschultz.net>.
-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1
Jose,
I marked this as off-topic because it doesn't have anything to do with
Tomcat. Tomcat doesn't do anything to your SQL queries, etc. See below.
Jose Gargallo wrote:
> I have a J2EE application that runs in Oracle and Postgres databases
> and OC4J and Tomcat servers. I've got a problem using the
> PreparedStatement.setTimestamp function runing TOMCAT 5.5 + Oracle 9i
> becouse it ignores the milliseconds. It works fine runing in OC4J
> 10.1.3 and Oracle 9i. ¿Why?
Can you post your code that calls PreparedStatement.setTimestmp? Include
the declarations of any Date objects and anytime you assign the
reference or modify the object itself.
- -chris
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.4.7 (MingW32)
Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org
iD8DBQFGuHnE9CaO5/Lv0PARAtxwAJ0axxRuz8UtfBvjLwJ6hdkthFkHNwCaA4rF
IPsKktptiSW47HDFx1dNoCU=
=k9SW
-----END PGP SIGNATURE-----
---------------------------------------------------------------------
To start a new topic, e-mail: users@tomcat.apache.org
To unsubscribe, e-mail: users-unsubscribe@tomcat.apache.org
For additional commands, e-mail: users-help@tomcat.apache.org
Re: JDBC problem: PreparedStatement.setTimestamp function ignores
milliseconds in TOMCAT + ddbb Oracle
Posted by Jose Gargallo <j....@dysmatica.es>.
I still have te same problem, any help?
Jose Gargallo escribió:
> Hi all,
>
> I have a J2EE application that runs in Oracle and Postgres databases
> and OC4J and Tomcat servers. I've got a problem using the
> PreparedStatement.setTimestamp function runing TOMCAT 5.5 + Oracle 9i
> becouse it ignores the milliseconds. It works fine runing in OC4J
> 10.1.3 and Oracle 9i. ¿Why?
>
> Any answer will be welcome!
>
> Thanks
>
> ---------------------------------------------------------------------
> To start a new topic, e-mail: users@tomcat.apache.org
> To unsubscribe, e-mail: users-unsubscribe@tomcat.apache.org
> For additional commands, e-mail: users-help@tomcat.apache.org
>
>
---------------------------------------------------------------------
To start a new topic, e-mail: users@tomcat.apache.org
To unsubscribe, e-mail: users-unsubscribe@tomcat.apache.org
For additional commands, e-mail: users-help@tomcat.apache.org