The following jar files is missing from the classpath: hsqldb.jar

#29086

Hi,

I'm just setting up on a new PC and I'm encountering the following error message.

Fatal Error: one of the following jar files is missing from the classpath:
   hsqldb.jar
Please make sure you run the application from the shortcut that was
installed on your desktop or on the Start menu when you upgraded.

I've not come across these before but I also got some regarding jfreechart and jcommon which I seemed to overcome by downloading and pasting into the appropriate folder. I cant seem to get this one sorted though. Any ideas?

Thanks
David

btw12342001

#29088

You don't mention if you actually have the file.  The default location in in the &#92;jts directory.

Show quoted text

--- In TWSAPI@..., "DavidP" <af402469@...> wrote:

Hi,

I'm just setting up on a new PC and I'm encountering the following error message.

Fatal Error: one of the following jar files is missing from the classpath:
   hsqldb.jar
Please make sure you run the application from the shortcut that was
installed on your desktop or on the Start menu when you upgraded.

I've not come across these before but I also got some regarding jfreechart and jcommon which I seemed to overcome by downloading and pasting into the appropriate folder. I cant seem to get this one sorted though. Any ideas?

Thanks
David

vanx23_alias

#29091

Hi David,

I do format one of the computer's partitions and re-install everything from scratch every 6 months. I stumble into this error each time.

At first, I was puzzled with this and was wondering what I was doing wrong. I couldn't pinpoint the root cause of this, but I found out that running another web based java application will miraculously make the web based TWS find everything it needs.

This bug is easy to reproduce:

1) Format partition
2) Install OS and all required updates (In my case: Windows Server 2008 R2-x64)
3) Install latest Java Virtual machine (In my case: Java x86)
4) Make sure the Java plugging is working fine, by using the "Java Version Verifier" on the Java web site.
5) Finally, try lauching TWS from the InteractiveBrokers web site.

Result: Boom! The missing jar's components will appears.

After running the TMX's QuoteStream java web application, from QuoteMedia, everything will work fine for TWS.

This is NOT something new. As far as I remember, I've been having this error for at least 2 years now. I've always wanted to report this bug to IB. Then, having the burden to prove IB the bug is on their side, kept my procrastinating to report it. As far as I have a work around, I keep procrastinating.

I'm surprised that not much people have come across this bug. On the other hand, I guess not much people run TWS, as the first Java application, right of the bat, after having re-install and setup the OS.

I know it's not a solution per say. But it may help you to stop searching for something wrong in your installation, which I'm sure is perfectly fine.

As a side note:

Although I've been silently monitoring this forum for more than a year now, I would like to take the opportunity of this first post/reply to salute all the contributors. Comments on this forum are always constructive, which is much appreciated.

Regards, Mike

--- In TWSAPI@..., "DavidP" <af402469@...> wrote:

Hi,

I'm just setting up on a new PC and I'm encountering the following error message.

Fatal Error: one of the following jar files is missing from the classpath:
   hsqldb.jar
Please make sure you run the application from the shortcut that was
installed on your desktop or on the Start menu when you upgraded.

I've not come across these before but I also got some regarding jfreechart and jcommon which I seemed to overcome by downloading and pasting into the appropriate folder. I cant seem to get this one sorted though. Any ideas?

Thanks
David

#29089

Thanks for the reply, yes the file is in C:&#92;jts. The file I am using is hsqldb-1.7.3.3 I also have the folder hsqldb-2.3.0 with its contents as downloaded off the web. I run sampleIBControllerStart and then it brings up the error message.

Show quoted text

--- In TWSAPI@..., "btw12342001" <newguy@...> wrote:

You don't mention if you actually have the file.  The default location in in the &#92;jts directory.

--- In TWSAPI@..., "DavidP" <af402469@> wrote:

Hi,

I'm just setting up on a new PC and I'm encountering the following error message.

Fatal Error: one of the following jar files is missing from the classpath:
   hsqldb.jar
Please make sure you run the application from the shortcut that was
installed on your desktop or on the Start menu when you upgraded.

I've not come across these before but I also got some regarding jfreechart and jcommon which I seemed to overcome by downloading and pasting into the appropriate folder. I cant seem to get this one sorted though. Any ideas?

Thanks
David

btw12342001

#29090

Can you start TWS normally without using IBController?  I don't use that so am not sure how it works.  The command I use to start TWS is the default from the installation script.

C:&#92;WINDOWS&#92;system32&#92;javaw.exe -cp jts.jar;hsqldb.jar;jcommon-1.0.12.jar;jfreechart-1.0.9.jar;jhall.jar;other.jar;rss.jar -Dsun.java2d.noddraw=true -Xmx512M -XX:MaxPermSize=128M jclient/LoginFrame C:&#92;jts

Show quoted text

--- In TWSAPI@..., "DavidP" <af402469@...> wrote:

Thanks for the reply, yes the file is in C:&#92;jts. The file I am using is hsqldb-1.7.3.3 I also have the folder hsqldb-2.3.0 with its contents as downloaded off the web. I run sampleIBControllerStart and then it brings up the error message.

--- In TWSAPI@..., "btw12342001" <newguy@> wrote:

You don't mention if you actually have the file.  The default location in in the &#92;jts directory.

--- In TWSAPI@..., "DavidP" <af402469@> wrote:

Hi,

I'm just setting up on a new PC and I'm encountering the following error message.

Fatal Error: one of the following jar files is missing from the classpath:
   hsqldb.jar
Please make sure you run the application from the shortcut that was
installed on your desktop or on the Start menu when you upgraded.

I've not come across these before but I also got some regarding jfreechart and jcommon which I seemed to overcome by downloading and pasting into the appropriate folder. I cant seem to get this one sorted though. Any ideas?

Thanks
David

BeeJay (GMX)

#29092

If you post the the command you use to start the TWS, you should also mention the TWS version number, cause this command is for older TWS versions.

Most JAR files are now stored in one single JAR file: "total.2012.jar".

A more recent command is:

C:&#92;WINDOWS&#92;system32&#92;javaw.exe -cp jts.jar;total.2012.jar -Dsun.java2d.noddraw=true -Dswing.boldMetal=false -Dsun.locale.formatasdefault=true -Xmx768M -XX:MaxPermSize=128M jclient/LoginFrame C:&#92;Jts

Show quoted text

Can you start TWS normally without using IBController?  I don't use
that so am not sure how it works.  The command I use to start TWS is
the default from the installation script.

C:&#92;WINDOWS&#92;system32&#92;javaw.exe -cp
jts.jar;hsqldb.jar;jcommon-1.0.12.jar;jfreechart-1.0.9.jar;jhall.jar;other.jar;rss.jar
-Dsun.java2d.noddraw=true -Xmx512M -XX:MaxPermSize=128M
jclient/LoginFrame C:&#92;jts

--- In TWSAPI@..., "DavidP" <af402469@...> wrote:

Thanks for the reply, yes the file is in C:&#92;jts. The file I am
using is hsqldb-1.7.3.3 I also have the folder hsqldb-2.3.0 with
its contents as downloaded off the web. I run
sampleIBControllerStart and then it brings up the error message.

--- In TWSAPI@..., "btw12342001" <newguy@> wrote:

You don't mention if you actually have the file.  The default
location in in the &#92;jts directory.

--- In TWSAPI@..., "DavidP" <af402469@> wrote:

Hi,

I'm just setting up on a new PC and I'm encountering the
following error message.

Fatal Error: one of the following jar files is missing from the
classpath: hsqldb.jar Please make sure you run the application
from the shortcut that was installed on your desktop or on the
Start menu when you upgraded.

I've not come across these before but I also got some regarding
jfreechart and jcommon which I seemed to overcome by
downloading and pasting into the appropriate folder. I cant
seem to get this one sorted though. Any ideas?

Thanks David



------------------------------------

Yahoo! Groups Links

btw12342001

#29096

Thanks for the info.  I'm using 927.7. I don't usually upgrade as long as everything is working and IB doesn't force me to.

Show quoted text

--- In TWSAPI@..., "BeeJay (GMX)" <bee_jay61@...> wrote:

If you post the the command you use to start the TWS, you should also
mention the TWS version number, cause this command is for older TWS
versions.

Most JAR files are now stored in one single JAR file: "total.2012.jar".

A more recent command is:

C:&#92;WINDOWS&#92;system32&#92;javaw.exe -cp jts.jar;total.2012.jar
-Dsun.java2d.noddraw=true -Dswing.boldMetal=false
-Dsun.locale.formatasdefault=true -Xmx768M -XX:MaxPermSize=128M
jclient/LoginFrame C:&#92;Jts

#29098

Thanks for your assistance with this. I tried starting TWS from the IB website. The script seemed to run a litle further after that as the username and password were entered and a log in attempt was made but then the same hsqldb message came up.

I'm using TWS 938.1 which starts and runs flawlessly if I open it by using the TWS icon on the desktop. I'm also using IBControllerV2-9-0 with the default command line. I must admit I don't even know where the command line can be found. I opened various files and did not see anything which looks like what has been posted in this thread. Which file contains the command line?

I do see the total.2012.jar file in C:&#92;jts directory.

Thanks
David

Show quoted text

--- In TWSAPI@..., "BeeJay (GMX)" <bee_jay61@...> wrote:

If you post the the command you use to start the TWS, you should also
mention the TWS version number, cause this command is for older TWS
versions.

Most JAR files are now stored in one single JAR file: "total.2012.jar".

A more recent command is:

C:&#92;WINDOWS&#92;system32&#92;javaw.exe -cp jts.jar;total.2012.jar
-Dsun.java2d.noddraw=true -Dswing.boldMetal=false
-Dsun.locale.formatasdefault=true -Xmx768M -XX:MaxPermSize=128M
jclient/LoginFrame C:&#92;Jts


Can you start TWS normally without using IBController?  I don't use
that so am not sure how it works.  The command I use to start TWS is
the default from the installation script.

C:&#92;WINDOWS&#92;system32&#92;javaw.exe -cp
jts.jar;hsqldb.jar;jcommon-1.0.12.jar;jfreechart-1.0.9.jar;jhall.jar;other.jar;rss.jar
-Dsun.java2d.noddraw=true -Xmx512M -XX:MaxPermSize=128M
jclient/LoginFrame C:&#92;jts

--- In TWSAPI@..., "DavidP" <af402469@> wrote:

Thanks for the reply, yes the file is in C:&#92;jts. The file I am
using is hsqldb-1.7.3.3 I also have the folder hsqldb-2.3.0 with
its contents as downloaded off the web. I run
sampleIBControllerStart and then it brings up the error message.

--- In TWSAPI@..., "btw12342001" <newguy@> wrote:

You don't mention if you actually have the file.  The default
location in in the &#92;jts directory.

--- In TWSAPI@..., "DavidP" <af402469@> wrote:

Hi,

I'm just setting up on a new PC and I'm encountering the
following error message.

Fatal Error: one of the following jar files is missing from the
classpath: hsqldb.jar Please make sure you run the application
from the shortcut that was installed on your desktop or on the
Start menu when you upgraded.

I've not come across these before but I also got some regarding
jfreechart and jcommon which I seemed to overcome by
downloading and pasting into the appropriate folder. I cant
seem to get this one sorted though. Any ideas?

Thanks David



------------------------------------

Yahoo! Groups Links

btw12342001

#29100

Which file contains the command line?Right click the shortcut icon and select properties.

BeeJay (GMX)

#29105

I'm using TWS 938.1 which starts and runs flawlessly if I open it by
using the TWS icon on the desktop. I'm also using IBControllerV2-9-0
with the default command line. I must admit I don't even know where
the command line can be found. I opened various files and did not see
anything which looks like what has been posted in this thread. Which
file contains the command line?Sorry, I dont use IBController. But there are a lot of users here which can help you how to change the classpath for the TWS in IBController.

I do see the total.2012.jar file in C:&#92;jts directory.

Thanks David

--- In TWSAPI@..., "BeeJay (GMX)" <bee_jay61@...> wrote:

If you post the the command you use to start the TWS, you should
also mention the TWS version number, cause this command is for
older TWS versions.

Most JAR files are now stored in one single JAR file:
"total.2012.jar".

A more recent command is:

C:&#92;WINDOWS&#92;system32&#92;javaw.exe -cp jts.jar;total.2012.jar
-Dsun.java2d.noddraw=true -Dswing.boldMetal=false
-Dsun.locale.formatasdefault=true -Xmx768M -XX:MaxPermSize=128M
jclient/LoginFrame C:&#92;Jts


Can you start TWS normally without using IBController?  I don't
use that so am not sure how it works.  The command I use to start
TWS is the default from the installation script.

C:&#92;WINDOWS&#92;system32&#92;javaw.exe -cp
jts.jar;hsqldb.jar;jcommon-1.0.12.jar;jfreechart-1.0.9.jar;jhall.jar;other.jar;rss.jar

-Dsun.java2d.noddraw=true -Xmx512M -XX:MaxPermSize=128M
jclient/LoginFrame C:&#92;jts

--- In TWSAPI@..., "DavidP" <af402469@> wrote:

Thanks for the reply, yes the file is in C:&#92;jts. The file I am
using is hsqldb-1.7.3.3 I also have the folder hsqldb-2.3.0
with its contents as downloaded off the web. I run
sampleIBControllerStart and then it brings up the error
message.

--- In TWSAPI@..., "btw12342001" <newguy@> wrote:

You don't mention if you actually have the file.  The
default location in in the &#92;jts directory.

--- In TWSAPI@..., "DavidP" <af402469@> wrote:

Hi,

I'm just setting up on a new PC and I'm encountering the
following error message.

Fatal Error: one of the following jar files is missing from
the classpath: hsqldb.jar Please make sure you run the
application from the shortcut that was installed on your
desktop or on the Start menu when you upgraded.

I've not come across these before but I also got some
regarding jfreechart and jcommon which I seemed to overcome
by downloading and pasting into the appropriate folder. I
cant seem to get this one sorted though. Any ideas?

Thanks David



------------------------------------

Yahoo! Groups Links




------------------------------------

Yahoo! Groups Links

#29109

The defaults classpath in the TWS 938.1h shortcut is C:&#92;Windows&#92;system32&#92;javaw.exe -cp jts.jar;total.2012.jar -Dsun.java2d.noddraw=true -Dswing.boldMetal=false -Dsun.locale.formatasdefault=true -Xmx768M -XX:MaxPermSize=128M jclient/LoginFrame C:&#92;Jts

I tried replacing that classpath with this one from earlier in the thread,
C:&#92;WINDOWS&#92;system32&#92;javaw.exe -cp jts.jar;total.2012.jar
-Dsun.java2d.noddraw=true -Dswing.boldMetal=false
-Dsun.locale.formatasdefault=true -Xmx768M -XX:MaxPermSize=128M
jclient/LoginFrame C:&#92;JtsI was unable to get the shorcut to work after that so I put it back to the default classpath.

I did also add -hsqldb.jar into the classpath to see what would happen, but it would not run like that.

#29110

If you were typing that command in a terminal window it will not work
unless you first make the default directory C:&#92;Jts.  Doing that allows you
to specify the jar files without specifying the entire path.  So to make a
long story short, what if you try using the whole path for the jars in your
command line.

Instead of specifying the jar files like this:

-cp jts.jar;total.2012.jar

Do this:

-cp C:&#92;&#92;Jts&#92;jts.jar;C:&#92;&#92;Jts&#92;total.2012.jar


On Fri, Jul 12, 2013 at 6:56 PM, DavidP <af402469@...> wrote:

**


The defaults classpath in the TWS 938.1h shortcut is
C:&#92;Windows&#92;system32&#92;javaw.exe -cp jts.jar;total.2012.jar
-Dsun.java2d.noddraw=true -Dswing.boldMetal=false
-Dsun.locale.formatasdefault=true -Xmx768M -XX:MaxPermSize=128M
jclient/LoginFrame C:&#92;Jts

I tried replacing that classpath with this one from earlier in the thread,
C:&#92;WINDOWS&#92;system32&#92;javaw.exe -cp jts.jar;total.2012.jar
-Dsun.java2d.noddraw=true -Dswing.boldMetal=false
-Dsun.locale.formatasdefault=true -Xmx768M -XX:MaxPermSize=128M
jclient/LoginFrame C:&#92;JtsI was unable to get the shorcut to work after that so I put it back to the
default classpath.

I did also add -hsqldb.jar into the classpath to see what would happen,
but it would not run like that.



[Non-text portions of this message have been removed]

#29112

Thanks everyone for your help with this. I tried some older versions of TWS and IBController and have come up with a working pair. I think I'll just stick with that until I'm forced to upgrade.

Thanks again.
David

开云体育

The following jar files is missing from the classpath: hsqldb.jar