create-main-database gives MySQLSyntaxErrorException

[GoogleCodeExporter]

C:\projects\webapps\internal\keys>ant create-main-database
Buildfile: build.xml
[savantinit] Initializing Savant - reading project.xml file
[savantinit] Done initializing Savant - project is
[texturemedia.com|keys|1.0-A1
]

-init-params-mysql:
     [echo] Project requires database
     [echo] Project contains domain objects

-compile-init-main:

-compile-main-conf:

compile-main:

-compile-init-test-unit:

-compile-test-unit-conf:

compile-test-unit:

-compile-init-test-integration:

-compile-test-integration-conf:

compile-test-integration:

compile:

jar:
  [publish] Published [keys-1.0-A1-IB20080212063431327.jar] to [LocalCache
at C:
\Documents and
Settings\Steve\.savant_repository\texturemedia.com/keys/keys-1.0-
A1-IB20080212063431327.jar]
  [publish] Published [keys-1.0-A1-IB20080212063431327.jar] to [Maven
repository
 at C:\Documents and
Settings\Steve\.maven\repository/keys/jars/keys-1.0-A1-IB20
080212063431327.jar]
  [publish] Published the artifactMetaData for the artifact
[texturemedia.com|ke
ys|keys-1.0-A1-IB20080212063431327.jar] to [LocalCache at C:\Documents and
Setti
ngs\Steve\.savant_repository\texturemedia.com/keys/keys-1.0-A1-IB200802120634313
27.jar.amd]
  [publish] Published the artifactMetaData for the artifact
[texturemedia.com|ke
ys|keys-1.0-A1-IB20080212063431327.jar] to [Maven repository at
C:\Documents and
 Settings\Steve\.maven\repository/keys/jars/keys-1.0-A1-IB20080212063431327.jar.
amd]
  [publish] Published [keys-1.0-A1-IB20080212063431327-src.jar] to
[LocalCache a
t C:\Documents and
Settings\Steve\.savant_repository\texturemedia.com/keys/keys-
1.0-A1-IB20080212063431327-src.jar]
  [publish] Published [keys-1.0-A1-IB20080212063431327-src.jar] to [Maven
reposi
tory at C:\Documents and
Settings\Steve\.maven\repository/keys/jars/keys-1.0-A1-
IB20080212063431327-src.jar]

-init-database:

create-main-database:
     [echo] Creating database keys...
     [echo] -- Dropping db
      [sql] Executing commands
      [sql] Failed to execute:  DROP DATABASE IF EXISTS keys

BUILD FAILED
C:\projects\tools\texturemedia-ant\plugins-jcatapult\mysql\1.0\mysql.xml:92:
The
 following error occurred while executing this line:
C:\projects\tools\texturemedia-ant\plugins-jcatapult\mysql\1.0\mysql.xml:126:
co
m.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: You have an error
in yo
ur SQL syntax; check the manual that corresponds to your MySQL server
version fo
r the right syntax to use near 'keys' at line 1

Total time: 8 seconds

What version of the product are you using? On what operating system?
jCatapult source download. Win2k, MySQL 5.5.

Please provide any additional information below.

Original issue reported on code.google.com by pokneet...@gmail.com on 12 Feb 2008 at 6:36

[GoogleCodeExporter]

C:\projects\webapps\internal\keys>mysql --version
mysql  Ver 14.12 Distrib 5.0.51a, for Win32 (ia32)

Original comment by pokneet...@gmail.com on 12 Feb 2008 at 6:39

[GoogleCodeExporter]

I think this might be a reserved word or something. Steve any more insight?

Original comment by bpontare...@gmail.com on 18 Mar 2008 at 3:53

[GoogleCodeExporter]

I'm closing this issue since it's I believe it's related to a reserved word 
issue. 
If the original poster is still having problems and disagrees then they can 
resubmit.

Original comment by leafkn...@gmail.com on 24 Mar 2008 at 7:36

• Changed state: Invalid