shell scripting with HSQLDB
Attempting to execute sql scripts against HSQLDB database using windows shell, but to no avail. I'm trying to use to RC file or config file to authenticate
db connection. Unfortunately, I don't know how to make the shell visible to determine what error I'm receving, since it's using the method (non-interactive). I've tried the /i switch to make interactive.
I've successfully used inline authentication, e.g.,
java -jar path\to\hsqldb.jar --inlineRc URL=jdbc:hsqldb:fileath/to/database/db1,USER=sa
Here's a sample of what I've done:
in config file, i have the following:
in windows batch file, i have the following:
java -jar /path/to/database/db1 personal /path/to/script/script1.sql
Lastly, I've tried "/" as well "\", neither has worked.
any help is appreciated.
By kevin3306 in forum VB Classic
Last Post: 09-15-2005, 06:32 PM
By none_none in forum C++
Last Post: 04-19-2005, 05:20 PM
By Larry Rebich in forum dotnet.announcements
Last Post: 10-15-2002, 01:20 PM
By Anh Ly-Hang in forum Enterprise
Last Post: 10-19-2001, 05:15 AM
By Juergen Thuemmler in forum VB Classic
Last Post: 06-22-2000, 04:12 AM
Top DevX Stories
Easy Web Services with SQL Server 2005 HTTP Endpoints
JavaOne 2005: Java Platform Roadmap Focuses on Ease of Development, Sun Focuses on the "Free" in F.O.S.S.
Wed Yourself to UML with the Power of Associations
Microsoft to Add AJAX Capabilities to ASP.NET
IBM's Cloudscape Versus MySQL