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

[raj raval]

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]

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]

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]

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

import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.PreparedStatement;
import java.sql.SQLException;
import java.sql.Statement;


public class DJBCExample 
{
	public static void main(String[] args) throws SQLException,ClassNotFoundException
	{
		Connection con =prepareConnection();
		
		Statement st=con.createStatement();
		
		String query="create table mytable (col1 varcahr2(20),col2 number, col3 number(10,2))";
		
		st.executeUpdate(query);
		
		System.out.println("table created successfully");
		con.close();
	}

	public static Connection prepareConnection()throws SQLException,ClassNotFoundException
	{		
		String driverClassName="oracle.jdbc.driver.OracleDriver";
		
		
		String url="jdbc:oracle:thin:@localhost:1521:XE";
		
		String username="system";
		String password="manager";
		
		Class.forName(driverClassName);
		
		Connection con=DriverManager.getConnection(url,username,password);
		return con;
		
	}
}

[James Boswell]

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

[Suvendu Panda]

thanks james boswell sir.

[Campbell Ritchie]

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