This week's giveaway is in the Android forum.
We're giving away four copies of Android Security Essentials Live Lessons and have Godfrey Nolan on-line!
See this thread for details.
The moose likes JDBC and the fly likes MqSQL to Oracle Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login

Win a copy of Android Security Essentials Live Lessons this week in the Android forum!
JavaRanch » Java Forums » Databases » JDBC
Bookmark "MqSQL to Oracle" Watch "MqSQL to Oracle" New topic

MqSQL to Oracle

Chuan Ren
Ranch Hand

Joined: Aug 04, 2003
Posts: 42
I have a small program that uses mySQL and I am thinking to move it to Oracle. There are a few conversion issues and I appreciate your input and suggestions:
1. In mySQL there is auto_increment function but not in Oracle 9i. In my JSP sql (that uses mySQL) I could have just use
insert into t_emp (id, name) value ('', 'Joe Black');

In oracle I uses sequence and the sql looks like:
insert into t_emp values (emp_seq.nextval, 'Joe Black');
How could I use just 1 type of sql for both databases?
2. If I use NOW() in the DATETIME in mySQL in some INSERT statement, what should I replace with in Oracle.
Actually, what is the best way to develop this type of program so that it could be deploy between mySQL(during development) and Oracle (production)?
Thank you.
Harry Lin

Joined: Nov 10, 2003
Posts: 1
the answer of the second question

you can use sysdate to get the db's time
[ November 24, 2003: Message edited by: Harry Lin ]
Consider Paul's rocket mass heater.
subject: MqSQL to Oracle
Similar Threads
How to store & retrieve a video file from database?
How to insert enum type entity in MySQL with JPA
why my oracle sequence id increases by 2 when I use hibernate to insert
MySQL and PHP : valuable in resume ?
I'm stumped!