Question: I am trying to run some INSERT INTO SQL command in OpenOffice Base and i get the error message below 1: Wrong data type: java.lang.IllegalArgumentException)

I am trying to run some INSERT INTO SQL command in OpenOffice Base and i get the error message below

1: Wrong data type: java.lang.IllegalArgumentException)

The Create table code is as below:

create table Books

(

BookId integer PRIMARY KEY,

SequenceNumber integer,

Title char(50),

ISBN char(14),

Author char(30),

cost decimal(7,2),

publication_date date

);

And the INSERT INTO commands are:

insert into Books values(1,1,'Alice in Wonderland','1441435840','Lewis Corell',7.95,'5/1/1997');

insert into Books values(2,1,'A First Course in Database Systems','978-0136006374','Jeffrey Ullman',99.49,'10/6/2007');

insert into Books values(3,1,'Database Systems Concepts','978-0073523323','Abrahm Silberchatz',119.67,'01/27/2010');

Any advice?

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!