jQuery in Action, 3rd edition
The moose likes JDBC and Relational Databases and the fly likes hsqldb's sqltool Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login
JavaRanch » Java Forums » Databases » JDBC and Relational Databases
Bookmark "hsqldb Watch "hsqldb New topic

hsqldb's sqltool

wrapping duke

Joined: Apr 02, 2008
Posts: 1

i'm attempting to use windows batch files to run sql scripts against hsqldb database. I would like to use a RC file for authentication. I've placed the sqltool.rc file in the same path as hsqldb.jar to use hsqldb's import/export utility. I've successfully used inline authentication to execute sql scripts using essentially the same methods. Here's a sample of I've done:

In the RC file I have the following

# A personal, local, persistent database.
urlid personal
url jdbc:hsqldb:file:/Mydb/personal;shutdown=true
username sa

The batch has the following statement:

java -jar /pathtojar/hsqldb.jar personal script1.sql

Unfortunately, I don't know how to get the windows shell to show to examine what errors I'm receiving since I'm in non-interactive mode. I've tried the /i switch to make interactive.

any help is appreciated.
[ April 02, 2008: Message edited by: wrapping duke ]
Jeanne Boyarsky
author & internet detective

Joined: May 26, 2003
Posts: 33130

"wrapping duke",
Please check your private messages about an important administrative matter.

[OCA 8 book] [Blog] [JavaRanch FAQ] [How To Ask Questions The Smart Way] [Book Promos]
Other Certs: SCEA Part 1, Part 2 & 3, Core Spring 3, TOGAF part 1 and part 2
I agree. Here's the link: http://aspose.com/file-tools
subject: hsqldb's sqltool
It's not a secret anymore!