hsqldb transfer tool

Thread view:

Dave Brown - 18 Jul 2005 17:07 GMT

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,

Reply to this Message

IchBin - 18 Jul 2005 17:33 GMT

> 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
[quoted text clipped - 4 lines]
>
> 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

Signature

Thanks in Advance...
IchBin, Pocono Lake, Pa, USA http://weconsultants.servebeer.com
__________________________________________________________________________

' If there is one, Knowledge is the "Fountain of Youth"'
-William E. Taylor, Regular Guy (1952-)

Reply to this Message

Dave Brown - 18 Jul 2005 18:16 GMT

>> 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
[quoted text clipped - 10 lines]
> 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.

Reply to this Message

IchBin - 18 Jul 2005 19:33 GMT

>>> 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
[quoted text clipped - 21 lines]
> 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%

Signature

Reply to this Message

Dave Brown - 18 Jul 2005 22:37 GMT

>>>> 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
[quoted text clipped - 36 lines]
>
> 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.

Reply to this Message

IchBin - 18 Jul 2005 23:39 GMT

>>>>> 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
[quoted text clipped - 47 lines]
>
> Thanks again.

I have been able to build it using Eclipse. Not sure why I am not having
the same problem. I saw your post to the HSQLDB forum.

Signature

Reply to this Message

Dave Brown - 19 Jul 2005 13:16 GMT

This morning I downloaded and tried DBVisualizer. 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
hsqldb, and do import/export etc..

>>>>>> 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
[quoted text clipped - 51 lines]
> I have been able to build it using Eclipse. Not sure why I am not having
> the same problem. I saw your post to the HSQLDB forum.

Reply to this Message

hsqldb transfer tool

Free Magazines