This week's book / license giveaways are in the JDBC and Relational Databases and Java in General forums.
We're giving away four copies each of PostGIS in Action and Java Advanced Topics Training and have the authors on-line!
See this thread and this one for details.
The moose likes JDBC and Relational Databases and the fly likes Insert a date to Oracle - an Example please!!! Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login

JavaRanch » Java Forums » Databases » JDBC and Relational Databases
Bookmark "Insert a date to Oracle - an Example please!!!" Watch "Insert a date to Oracle - an Example please!!!" New topic

Insert a date to Oracle - an Example please!!!

John Tyll

Joined: Feb 06, 2003
Posts: 10
Yes I am new to Java and dates are driving me nuts
Anyway, here's the background:
I am selecting information from one Oracle DB, doing a little manipulation and inserting to a different Oracle DB.
My problem:
Several of the columns I select are dates and need to be inserted to this other Oracle DB. I have tried 5 or 6 different ways and end up with as many errors (java won't compile 'unclosed character literal', Oracle thinks it is a the column name not a date, Oracle say's format is to long, etc...).
My display in Java shows the date as '2003-02-25 16:13:19.0'. I have removed the .0 with substring and stringTokenizer, but still didn't get it to work.
Show me an example of how you would insert this type of date from a variable (NOT hard coded) to Oracle.
NOTE: My code works just fine if I plug a date but I need the one I selected from the other DB.
Many Thanks!
Dirk Schreckmann

Joined: Dec 10, 2001
Posts: 7023
Have you tried to use a PreparedStatement? It has a setDate method that takes a java.sql.Date argument and would seem to be pretty easy to use.
[ March 26, 2003: Message edited by: Dirk Schreckmann ]

[How To Ask Good Questions] [JavaRanch FAQ Wiki] [JavaRanch Radio]
Leslie Chaim
Ranch Hand

Joined: May 22, 2002
Posts: 336
Use a PreparedStatement as Dirk suggested, and...
the SQL should be:

say you have your clean value (with the '.0' removed) in dateString:

The rest, I hope, is simple.

Normal is in the eye of the beholder
SJ Adnams
Ranch Hand

Joined: Sep 28, 2001
Posts: 925
You've misunderstood what Dirk is saying.
insert into some_table(some_data_column)values(?)
stmt.setDate(1, myDateObject);
there is no reason to parse date strings!
John Tyll

Joined: Feb 06, 2003
Posts: 10
Thanks, That is just what I needed...
I agree. Here's the link:
subject: Insert a date to Oracle - an Example please!!!