?
Solved

error while runing table creation code

Posted on 2012-03-25
2
Medium Priority
?
284 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 84

Accepted Solution

by:
Dave Baldwin earned 2000 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: SSL Checker

Scans your site and returns information about your SSL implementation and certificate. Helpful for debugging and validating your SSL configuration.

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

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…
Here is a helpful source code for C++ Builder programmers that allows you to manage and manipulate HTML content from C++ code, while also handling HTML events like onclick, onmouseover, ... Some objects defined and used in this source include: …
This tutorial covers a step-by-step guide to install VisualVM launcher in eclipse.
The viewer will learn how to synchronize PHP projects with a remote server in NetBeans IDE 8.0 for Windows.
Suggested Courses

719 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