Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

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

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Database Systems An Application Oriented Approach Complete Version

Authors: Michael Kifer, Arthur Bernstein, Richard Lewis

2nd Edition

0321268458, 978-0321268457

More Books

Students also viewed these Databases questions

Question

What is the basis for Security Concerns in Cloud Computing?

Answered: 1 week ago

Question

Describe the three main Cloud Computing Environments.

Answered: 1 week ago