Re: HSQLDB Sqltool with JTrac
Arthur Martinson <[email protected]> Mon, 30 Nov 2020 17:44:17 -0600
| Newsgroups | gmane.comp.java.hsqldb.user |
|---|---|
| Message-ID | <CACnSchZGz4xpCU_5XLdPj=KSwtA+e2qMpm_=_2h1_UsRiP34SA@mail.gmail.com> |
I WAS looking for an ERD tool and I failed with 7, make that 8. I have given up. I can use DBMSwing for selects and it works fine, but no matter what I do I cannot get sqltool and sqltool.rc file to work. I know that it's a CLI. I am obviously not intelligent enough to get any of the other 8 viz tools to work, but I'd like to get sqltool working. For about a decade I used ddtssql (a proprietary CLI with Rational's DDTS). I could even use join. At the top level of my jetty server (I moved the JTrac.war into jetty) I have the hsqldb jar and I run my dbmswing.bat file from there, with the jtrac.script here: /home/marti/Downloads/Apps/jetty/data/db/jtrac.script My sqltool.rc failed on 3 diff iterations. I get nothing to work. Any help on getting sqltool to work in this enviro/setup will be appreciated. On 11/30/20, Blaine Simpson <[email protected]> wrote: > I thought you were looking for a visual tool? SqlTool isn't a visual tool. > > I used to use JTrac and managed the embedded database with SqlTool. I had > it start a Server from the Tomcat JVM and then connected up with hsql and > hsqls protocols. > > On Mon, Nov 30, 2020 at 4:33 PM Arthur Martinson <[email protected]> > wrote: > >> I have failed with SEVEN other query apps: SchemaSpy, SchemaCrawler, >> SQLeo, JSqlTool, DataCleaner, Lite Weight Reporter, and Query2Report >> (the last 2 are WAR apps). There was an 8th with ERD in the title but >> it also involved plantuml..... >> >> This question is SPECIFICALLY about getting the command line sqltool >> to work with an app called JTrac. I have the DatabaseManagerSwing >> working with it (for query only) because I found specific instructions >> on how to run it against JTrac. (I do know how to do select statements >> but I am not a DBA). >> >> I have failed in 7 other apps because I am obviously NOT getting >> something correct in the driver, connections, url, etc. >> >> If someone has SPECIFIC knowledge on how to get it to work with the >> JTrac environment, please reply if you have the time. I tried 3 >> iterations of the sqltool.rc file and THEY have all failed. >> >> Thank you. >> >> >> _______________________________________________ >> Hsqldb-user mailing list >> [email protected] >> https://lists.sourceforge.net/lists/listinfo/hsqldb-user >> >