• Post Reply Bookmark Topic Watch Topic
  • New Topic

hsqldb's sqltool

 
wrapping duke
Greenhorn
Posts: 1
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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
Sheriff
Posts: 36031
432
Eclipse IDE Java VI Editor
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
"wrapping duke",
Please check your private messages about an important administrative matter.
 
my overalls have superpowers - they repel people who think fashion is important. Tiny ad:
the new thread boost feature brings a LOT of attention to your favorite threads
https://coderanch.com/t/674455/Thread-Boost-feature
  • Post Reply Bookmark Topic Watch Topic
  • New Topic
Boost this thread!