Granny's Programming Pearls
"inside of every large program is a small program struggling to get out"
The moose likes JDBC and Relational Databases and the fly likes New at JDBC programming - need help 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 "New at JDBC programming - need help" Watch "New at JDBC programming - need help" New topic

New at JDBC programming - need help

Joao Freitas

Joined: Dec 05, 2012
Posts: 1
Hello to all,

I'm a new member and I have almost no experience in Java and JDBC, I've only programmed in C. I have an assignment for my Database course and I've been struggling for some days with a problem I can't fix.

After running the code in the Eclipse IDE I get the error ORA-00936: missing expression tips. I've used the debugger and I guess the problem is in this part of the code:

The idea is to use prepared statements to then pass a parameter to the query at the execution time. This parameter is a number which correspondes to the CourseID of a given course in the COURSE table. Can you spot any problem?

Thank you very much in advance.


Joao Freitas
Jayesh A Lalwani
Saloon Keeper

Joined: Jan 17, 2008
Posts: 2708

Please wrap your code in code tags to make it easier to read

Your SQL is wrong. It should be

You have extra commas

ETA: It's helpful to run your queries through database before putting them in code. Usually I use SQL developer to build and test my queries before dropping them in code. It gives you the line and col number where your SQL is wrong
I agree. Here's the link:
subject: New at JDBC programming - need help
jQuery in Action, 3rd edition