Java EE5 Tutorial - 'ant create-tables' BUILD FAILED

[Paul Mac]

Hi,

Appologies, this is quite a begineers question, hopefully it's an easy one to answer. I've searched for the last few hours regarding this issue,
trying things and searched the forums here with no similar issue. As you can see below, I cannot create the tables for the bookstore1 application using 'ant'.

I am getting a FileNotFoundException however the delete.sql and tutorial.sql files are at this location C:\javaee\javaeetutorial5\examples\common\sql\javadb\
I have also made sure that the files have read and write access. I know their could be some permissions issues using vista if I installed at C:/ProgramFiles, so everything is in C:/

Another thing I have tried is using the ant command directly even though the PATH is in my enviroment variables, just incase another version was conflicting, as I read about people having such issues.

"C:\Sun\AppServer\lib\ant\bin\ant create-tables" => This gave the same error as below. Im not sure what other information may help you help me here, so just ask.

Annoying thing is, this example worked fine when I set up the environment on my work laptop (which I have no access to now) earlier, I didn't have this issue.

Thanks for your help.

/Paul.

c:\javaee\javaeetutorial5\examples\web\bookstore1>ant create-tables
Buildfile: build.xml

-pre-init:

init:

check:

tools:

start-db:
     [exec] Database already started on host localhost, port 1527.
     [exec] Command start-database executed successfully.

delete-tables:
      [sql] Executing file: C:\javaee\javaeetutorial5\examples\web\bookstore1\=C:\javaee\javaeetutorial5\examples\common\sql\javadb\delete.sql

BUILD FAILED
C:\javaee\javaeetutorial5\examples\bp-project\database-ant.xml:48: java.io.FileNotFoundException: C:\javaee\javaeetutorial5\examples\web\bookstore1\=C
:\javaee\javaeetutorial5\examples\common\sql\javadb\delete.sql (The filename, directory name, or volume label syntax is incorrect)

Total time: 21 seconds
c:\javaee\javaeetutorial5\examples\web\bookstore1>

[Paul Sturrock]

Ant appears to be looking for a file called "C:\javaee\javaeetutorial5\examples\web\bookstore1\=C:\javaee\javaeetutorial5\examples\common\sql\javadb\delete.sql" - can you post your target?

[Martijn Verburg]

And welcome to Javaranch Paul!

[Paul Mac]

Paul Sturrock wrote:Ant appears to be looking for a file called "C:\javaee\javaeetutorial5\examples\web\bookstore1\=C:\javaee\javaeetutorial5\examples\common\sql\javadb\delete.sql" - can you post your target?

Thanks for replies and the welcome. [Yea, I know it's says it's looking for that file, but it exists in C:\javaee\javaeetutorial5\examples\common\sql\javadb\ and I also copied delete.sql to C:\javaee\javaeetutorial5\examples\web\bookstore1\

I am working locally on Windows Vista. Thanks for help]

Edit - looking through my build properties I found 'javaee.tutorial.home==C:/javaee/javaeetutorial5'. I must have copied a second equals sign while copying directory path. It now works as expected.
Many thanks, I can now continue the tutorial