Yes, I created a database named "quickstart" before running the script. A
database is the same as a schema.
Can you successfully run the script with your MySql?
Lewis
----- Original Message -----
From: "Musachy Barroso" <[EMAIL PROTECTED]>
To: "Struts Users Mailing List" <user@struts.apache.org>
Sent: Tuesday, November 20, 2007 9:59 PM
Subject: Re: Problem running the MySQL script in "Struts 2 + Spring 2 + JPA
+ AJAX" tutorial
Do you have a "quickstart" schema in your db?
musachy
On Nov 20, 2007 12:43 AM, Lewis Li <[EMAIL PROTECTED]> wrote:
Hi! I'm doing the tutorial "Struts 2 + Spring 2 + JPA + AJAX" located at
http://struts.apache.org/2.0.11/docs/struts-2-spring-2-jpa-ajax.html.
I have installed and configured MySQL and created a database named
"quickstart". But I get a syntax error when running this script:
CREATE TABLE 'quickstart'.'Person' (
'id' INTEGER UNSIGNED NOT NULL AUTO_INCREMENT,
'firstName' VARCHAR(45) NOT NULL,
'lastName' VARCHAR(45) NOT NULL,
PRIMARY KEY('id')
)
ENGINE = InnoDB;This is exactly the same script from the tutorial. The
error
report reported by MySQL Query Browser is:
You have an error in your SQL syntax; check the manual that corresponds
to
your MySQL server version for the right syntax to use near
''quickstart'.'Person' (
'id' INTEGER UNSIGNED NOT NULL AUTO_INCREMENT,
'fi' at line 1
I really can't figure out what's wrong with the script. I'm running this
version of MySQL on a Windows XP computer:
Server version: 5.0.41-community-nt MySQL Community Edition (GPL)
I'd really appreciate it if anyone could help me out. Thank you.
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]