java.sql.SQLSyntaxErrorException:: ORA-00907: missing right parenthesis error

Question

import java.sql.DriverManager;

import java.sql.Connection;

import java.sql.Statement;

public class Create

{

    public static void main( String [] args)throws Exception
    {
        Connection con=DriverManager.getConnection("jdbc:oracle:thin:@localhost:1522/orcl1","scott","sada");
        System.out.println("connection is createad");
        Statement stmt=con.createStatement();
        System.out.println("statemnt of object is createad");
        stmt.executeUpdate("create table iteam(iteamno number(3)primarykey,iteamname number(15),price number(4))");
        System.out.println("table is created ");
        con.close();
        stmt.close();
        System.out.println("conncetion closed");
    }
}

Every thing executed successfully but after Statement object it will show this error when my program executes:

java.sql.SQLSyntaxErrorException: ORA-00907: missing right parenthesis Error

I think you are missing some spaces before and after the word primary: create table iteam(iteamno number(3) primary key — Glenn
– Glenn, Commented Apr 16, 2016 at 19:03

hd1 · Accepted Answer · 2016-04-16 19:05:45Z

1

A spacing error. Fixed below; you'd do well to try your statements in a fiddle before posting a question here, @sada:

import java.sql.DriverManager;

import java.sql.Connection;

import java.sql.Statement;

public class Create

{

    public static void main( String [] args)throws Exception
    {
        Connection con=DriverManager.getConnection("jdbc:oracle:thin:@localhost:1522/orcl1","scott","sada");
        System.out.println("connection is createad");
        Statement stmt=con.createStatement();
        System.out.println("statemnt of object is createad");
        stmt.executeUpdate("create table iteam(iteamno number(3) primary key,iteamname number(15),price number(4))");
        System.out.println("table is created ");
        con.close();
        stmt.close();
        System.out.println("conncetion closed");
    }
}

answered Apr 16, 2016 at 19:05

hd1

34.9k5 gold badges83 silver badges95 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

java.sql.SQLSyntaxErrorException:: ORA-00907: missing right parenthesis error

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related