my dog learned polymorphism*
The moose likes JDBC and the fly likes [ODBC driver for Oracle][Oracle]ORA-00907 Error Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login


Win a copy of Java 8 in Action this week in the Java 8 forum!
JavaRanch » Java Forums » Databases » JDBC
Bookmark "[ODBC driver for Oracle][Oracle]ORA-00907 Error" Watch "[ODBC driver for Oracle][Oracle]ORA-00907 Error" New topic
Author

[ODBC driver for Oracle][Oracle]ORA-00907 Error

raj raval
Greenhorn

Joined: Nov 03, 2008
Posts: 7
I have some problem regarding the connectivity with ODBC driver.

I can open my web application but when I am trying to perform some action at that time they give me the error like missing right paranthisis.
and give an error java.sql.SQLEXCEPTION [ODBC driver for Oracle][Oracle]ORA-00907. Also when I am trying to do on MS access then they give me an error like java.sql.SQLException: [Microsoft][ODBC Microsoft Access Driver] Syntax error in CREATE TABLE statement.

So, can any one suggest me what I have to do to remove this error. My program run good but during operation they give me these errors.

Thanks in advance.
Vijitha Kumara
Bartender

Joined: Mar 24, 2008
Posts: 3775

raj raval wrote:... give an error java.sql.SQLEXCEPTION [ODBC driver for Oracle][Oracle]ORA-00907. Also when I am trying to do on MS access then they give me an error like java.sql.SQLException: [Microsoft][ODBC Microsoft Access Driver] Syntax error in CREATE TABLE statement...

Looks like some SQL syntax errors in your code and you are running some DDL code in there. It's easy to correct it if you post your "CREATE TABLE.." statement with the code? And the complete stack trace if more errors are there?

SCJP 5 | SCWCD 5
[How to ask questions] [Twitter]
Stephan Mueller
Ranch Hand

Joined: May 05, 2010
Posts: 50
http://ora-code.com/ is a wonderfull resource for all things "ORA"-error related.
For your code there's this nice short-description:
ORA-00907: missing right parenthesis


Anyway, you should follow Vijitha's advice and
... post your "CREATE TABLE.." statement with the code And the complete stack trace if more errors are there


1. Make it run - 2. Make it run correctly - 3. Make it pretty OR fast/small - 4. ??? - 5. Profit
Suvendu Panda
Greenhorn

Joined: Mar 17, 2013
Posts: 4
I am new in jdbc so while executing there is an exception arises by saying
"Exception in thread "main" java.sql.SQLException: ORA-00907: missing right parenthesis" can any one help me why it happens and how can i avoid it.

Here is the code




James Boswell
Bartender

Joined: Nov 09, 2011
Posts: 973
    
    5

Not sure if you pasted the code directly but in your create statement, varcahr2 should be varchar2.
Suvendu Panda
Greenhorn

Joined: Mar 17, 2013
Posts: 4
thanks james boswell sir.
Campbell Ritchie
Sheriff

Joined: Oct 13, 2005
Posts: 36590
    
  16
Welcome to the Ranch

Please don’t add a new question to an old thread; your question may be moved to a new thread. Please use code tags; since you are new I have added them and you can see how much better the post looks
 
I agree. Here's the link: http://aspose.com/file-tools
 
subject: [ODBC driver for Oracle][Oracle]ORA-00907 Error
 
Similar Threads
Oracle 10g Driver error
java.sql.SQLException: [Oracle][ODBC][Ora]ORA-12640:
Error
TNS protocol adapter error
Record(s) cannot be read; no read permission on 'tblDts'.