aspose file tools*
The moose likes JDBC 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
Bookmark "hsqldb Watch "hsqldb New topic
Author

hsqldb's sqltool

wrapping duke
Greenhorn

Joined: Apr 02, 2008
Posts: 1
hello,

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
password

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
Marshal

Joined: May 26, 2003
Posts: 31062
    
232

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


[Blog] [JavaRanch FAQ] [How To Ask Questions The Smart Way] [Book Promos]
Blogging on Certs: SCEA Part 1, Part 2 & 3, Core Spring 3, OCAJP, OCPJP beta, TOGAF part 1 and part 2
 
Don't get me started about those stupid light bulbs.
 
subject: hsqldb's sqltool