Re: hsqldb transfer tool

IchBin wrote: 
Dave Brown wrote:

IchBin wrote:

Dave Brown wrote:

I'm looking for some kinda gui to speed data transfers up for me from mySQL to a standalone hsqldb file. I noticed in the docs for hsqldb there is supposed to be a Transfer tool but I cant find it in the version i download a few days ago.

Anyone any thoughts on this please ?


Rgds, 


Look at the docs at http://hsqldb.org/web/hsqlDocsFrame.html

You can also invoke the transfer program from the runManagerSwing.bat or the runManager.bat under HSQLDB-HOME\demo. You can find it under the menu item 'Tools' \ 'Transfer' for either



Those bat files dont work, first thing they try and do is a CD ..\DATA, in the latest version there is no ..\DATA so I did what the bat file would do manually and got the swing app running. However going to the transfer tool I get a ClassNotFound Exception.

After further investigation of unzipping the hsqldb.jar and looking at the classes, there is no TransferTool class. it doesnt exist.

Seems like its something they've taken out but havent updated their gui tool.


I am using HSQLDB 1.8.0.1. The error for ..\DATA should not be a problem. Looking at the source there is a Transfer.java. I do not see that in the hsqldb.jar file. Not sure what is going on because I am running it with no problem.

You may want to post to the HSQLDB newsgroups and you will get a very quick answer from Fred, I suspect.

http://sourceforge.net/forum/forum.php?forum_id=73674

Only difference I see is that I have an environment var defined as
HSQLDB_HOME as C:\Program Files\hsqldb\lib\hsqldb.jar

and have it added to my classpath as %HSQLDB_HOME%




Hi,

Thanks for that pointer, There was a very recent post from someone having exactly the same problem, it appears the transfer tool is excluded from the build of hsqldb.jar. Why I dont know, No Idea, cant seem to find any answer but I've put up a post requesting a version that includes it, tried doing the build myself but made a bigger balls of it all so with a bit of luck someone will have a built version which works.

Thanks again.

.

Relevant Pages

  • Re: hsqldb transfer tool
    ... I noticed in the docs for hsqldb there is supposed to be a Transfer tool but I cant find it in the version i download a few days ago. ... in the latest version there is no ..\DATA so I did what the bat file would do manually and got the swing app running. ...
    (comp.lang.java.databases)
  • Re: hsqldb transfer tool
    ... I noticed in the docs for hsqldb there is supposed to be a Transfer tool but I cant find it in the version i download a few days ago. ... in the latest version there is no ..\DATA so I did what the bat file would do manually and got the swing app running. ...
    (comp.lang.java.databases)
  • Re: hsqldb transfer tool
    ... It allows me to connect to any JDBC engine I give it the class for, and works with HSQLDB in standalone mode, its not quite a transfer tool as such but its made my life easier in the sense I can easily manage the standalone ... I noticed in the docs for hsqldb there is supposed to be a Transfer tool but I cant find it in the version i download a few days ago. ...
    (comp.lang.java.databases)
  • Re: hsqldb transfer tool
    ... mySQL to a standalone hsqldb file. ... I noticed in the docs for hsqldb there is supposed to be a Transfer tool but I cant find it in the version i download a few days ago. ...
    (comp.lang.java.databases)
  • Re: hsqldb transfer tool
    ... mySQL to a standalone hsqldb file. ... I noticed in the docs for hsqldb there is supposed to be a Transfer tool but I cant find it in the version i download a few days ago. ...
    (comp.lang.java.databases)