java.sql.SQLSyntaxErrorException: Syntax error: Encountered "(" at line

Question

I'm executing the following:

private void createTable() {
    try {       
        PreparedStatement psCreateTable = con.prepareStatement("CREATE TABLE     COMPANIES(" +
                "name VARCHAR(50), " +
                "location VARCHAR(50), " +
                "address VARCHAR(50), " +
                "website VARCHAR(50), " +
                "pit VARCHAR(50), " +
                "asset_class VARCHAR(50), " +
                "telephone INTEGER, " +
                "shares INTEGER, " +
                "value DOUBLE(,2) UNSIGNED)");
        psCreateTable.execute();
    } catch (SQLException e) {
        System.out.println("already exists");
        e.printStackTrace();
        ; //bestaat al
    }
}

And I get the following error: java.sql.SQLSyntaxErrorException: Syntax error: Encountered "(" at line 1, column 195.

Not really sure what to do now, as the SQL query seems valid to me and rechecked it.

John Woo · Accepted Answer · 2012-10-24 01:52:56Z

1

remove (,2) in the double data type.

CREATE Table Companies
(
    ....,
    value DOUBLE UNSIGNED
)

See Demonstration

edited Oct 24, 2012 at 1:52

answered Oct 24, 2012 at 1:41

John Woo

265k70 gold badges509 silver badges500 bronze badges

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

9 Comments

Marvin Effing Over a year ago

Ok, I tried that, but now I get the following error: java.sql.SQLSyntaxErrorException: Syntax error: Encountered "UNSIGNED" at line 1, column 196.

Marvin Effing Over a year ago

Removed the 'UNSIGNED' parameter, seems to work, but now I get the following error: java.sql.SQLException: At least one parameter to the current statement is uninitialized.

John Woo Over a year ago

@MarvinEffing but it's working on sql fiddle. did you click the link?

John Woo Over a year ago

@MarvinEffing the code you posted above is the one you are using? why is hat it shows error message At least one parameter to the current statement is uninitialized.? do you have a parameterized query othjer than that?

Marvin Effing Over a year ago

Yeah ok works now, I always end up forgetting the tiniest things.

|

Sujay · Accepted Answer · 2012-10-24 01:41:31Z

0

Your SQL query has an error: "value DOUBLE(,2) UNSIGNED)");

Change your PreparedStatement to something like this:

PreparedStatement psCreateTable = con.prepareStatement("CREATE TABLE COMPANIES(" +
                "name VARCHAR(50), " +
                "location VARCHAR(50), " +
                "address VARCHAR(50), " +
                "website VARCHAR(50), " +
                "pit VARCHAR(50), " +
                "asset_class VARCHAR(50), " +
                "telephone INTEGER, " +
                "shares INTEGER, " +
                "value DOUBLE UNSIGNED)");

answered Oct 24, 2012 at 1:41

Sujay

6,7812 gold badges32 silver badges49 bronze badges

Comments

Drogba · Accepted Answer · 2012-10-24 01:44:59Z

0

DOUBLE(,2)

This is wrong.

You may try

DOUBLE(5,2)

answered Oct 24, 2012 at 1:44

Drogba

4,3564 gold badges27 silver badges32 bronze badges

Collectives™ on Stack Overflow

java.sql.SQLSyntaxErrorException: Syntax error: Encountered "(" at line

3 Answers 3

9 Comments

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

9 Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related