JDBC and Oracle data type error.. please help

Im having trouble with a SQL query of mine. Im trying to get a timestamp using JDBC from an oracle database however i get the following error:

java.sql.SQLException: ORA-00932: inconsistent datatypes: expected %s got %s

Now when i put the java.util.timestamp into the DB it appears to change.

When I printout the value of the timestamp in my console it prints the following:

07-06-26 17:28:09.414

When i check the value from SQL PLUS it gives me this value

07-06-26 17:28:09,000000

Does anyone have any idea why this happens? and more importantly how I can retrieve the timestamp again.

Im using BEA workshop which means i dont have any means of manipulating the data before presenting to the frontend.

The database is Oracle 9.2.0.1

[810 byte] By [Zamiela] at [2007-11-27 9:00:12]
# 1
What data type have you declared for the column holding the timestamp? If you have declared it as a DATE, it will not store any millisecond information. You need to declare the field as a TIMESTAMP.
aniseeda at 2007-7-12 21:28:36 > top of Java-index,Database Connectivity,Java Database Connectivity (JDBC)...
# 2
http://www.databasejournal.com/features/oracle/article.php/2234501
aniseeda at 2007-7-12 21:28:36 > top of Java-index,Database Connectivity,Java Database Connectivity (JDBC)...