users@glassfish.java.net

Re: Internal Exception: java.sql.SQLSyntaxErrorException: Table/View 'WEB_

From: Wolfram Rittmeyer <w.rittmeyer_at_jsptutorial.org>
Date: Sat, 09 May 2009 11:33:46 +0200

glassfish_at_javadesktop.org wrote:
> Hi Marina:
>
> Thanks for your response. So I ran ant create-tables in books, and got the following error message:
>
> Microsoft Windows XP [Version 5.1.2600]
> (C) Copyright 1985-2001 Microsoft Corp.
>
> C:\Documents and Settings\Owner>cd c:\javaeetutorial5\examples\web\books
>
> C:\javaeetutorial5\examples\web\books> ant create-tables
> Unable to locate tools.jar. Expected to find it in C:\Program Files\Java\jre6\li
> b\tools.jar
> Buildfile: build.xml
>

This message means that ant uses a JRE and no JDK. But ant needs to
access tools of the full JDK (e.g. javac).

I guess you have to set JAVA_HOME to a path where a full Java 5-JDK is
installed.

e.g.
SET JAVA_HOME="c:\Program Files\Java\jdk1.5.0_6"
ant create-tables


--
Wolfram Rittmeyer