Solved

error while runing table creation code

Posted on 2012-03-25
2
281 Views
Last Modified: 2012-03-25
Is there anythng wrong wid the following code-
stmt.execute("create table order(ORDER_INDEX INTEGER not null GENERATED ALWAYS AS IDENTITY CONSTRAINT orderno_pk primary key,ONAME VARCHAR(30),DESC VARCHAR(30),CUSTOMER VARCHAR(30),PHONE INTEGER,ORDERDATE VARCHAR(30),DELIVERYDATE VARCHAR(30),ADVANCE DECIMAL(20,2),BAL DECIMAL(20,2))");
i am getting the attached error..pls help..
run.txt
0
Comment
Question by:daydreamer6565
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
2 Comments
 
LVL 83

Accepted Solution

by:
Dave Baldwin earned 500 total points
ID: 37764433
'order' is a reserved word in MySQL and should not be used for table or column names.
0
 

Author Closing Comment

by:daydreamer6565
ID: 37764440
The table is created..Thanks ..
0

Featured Post

Free Tool: Site Down Detector

Helpful to verify reports of your own downtime, or to double check a downed website you are trying to access.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Programmer's Notepad is, one of the best free text editing tools available, simply because the developers appear to have second-guessed every weird problem or issue a programmer is likely to run into. One of these problems is selecting and deleti…
Update (December 2011): Since this article was published, the things have changed for good for Android native developers. The Sequoyah Project (http://www.eclipse.org/sequoyah/) automates most of the tasks discussed in this article. You can even fin…
The viewer will learn how to use NetBeans IDE 8.0 for Windows to connect to a MySQL database. Open Services Panel: Create a new connection using New Connection Wizard: Create a test database called eetutorial: Create a new test tabel called ee…
The viewer will learn how to synchronize PHP projects with a remote server in NetBeans IDE 8.0 for Windows.

733 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question