Win a copy of Re-engineering Legacy Software this week in the Refactoring forum
or Docker in Action in the Cloud/Virtualization forum!
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

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

 
raj raval
Greenhorn
Posts: 7
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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
Posts: 3913
9
Chrome Fedora Hibernate
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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?
 
Stephan Mueller
Ranch Hand
Posts: 50
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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
 
Suvendu Panda
Greenhorn
Posts: 4
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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
Posts: 1051
5
Chrome Eclipse IDE Hibernate
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Not sure if you pasted the code directly but in your create statement, varcahr2 should be varchar2.
 
Suvendu Panda
Greenhorn
Posts: 4
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
thanks james boswell sir.
 
Campbell Ritchie
Sheriff
Posts: 48448
56
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic