File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
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: 32811

"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:
subject: hsqldb's sqltool
It's not a secret anymore!