start_hypersonic

[suja]

Hi

I can't able to start the hypersonic database for Pentaho. I am using

jakarta-tomcat-5.5.9
jdk1.5
pentaho_j2ee_deployments-1.1.4.239.zip for java deployment.
Linux

After creating the penthaho.war; I had attempted to start hypersonic
database, but it generate following error.

$ sh start_hypersonic.sh

: command not found: line 7:
: command not found: line 9:
[Server@241fa0]: [Thread[main,5,main]]: checkRunning(false) entered
[Server@241fa0]: [Thread[main,5,main]]: checkRunning(false) exited
[Server@241fa0]: Startup sequence initiated from main() method
[Server@241fa0]: Loaded properties from
[/pentaho_try/pentaho-data/server.properties]
[Server@241fa0]: Initiating startup sequence...
[Server@241fa0]: Server socket opened successfully in 1 ms.
[Server@241fa0]: [Thread[HSQLDB Server @241fa0,5,main]]: Database
[index=0db=file:sampledata/sampledata, alias=sampledata] did not open:
org.hsqldb.HsqlException: General error: java.lang.Error: Not implemented
[Server@241fa0]: [Thread[HSQLDB Server @241fa0,5,main]]: Database
[index=1db=file:shark/shark, alias=shark] did not open:
org.hsqldb.HsqlException: General error: java.lang.Error: Not implemented
[Server@241fa0]: [Thread[HSQLDB Server @241fa0,5,main]]: Database
[index=2db=file:hibernate/hibernate, alias=hibernate] did not open:
org.hsqldb.HsqlException: General error: java.lang.Error: Not implemented
[Server@241fa0]: [Thread[HSQLDB Server @241fa0,5,main]]: Database
[index=3db=file:quartz/quartz, alias=quartz] did not open:
org.hsqldb.HsqlException: General error: java.lang.Error: Not implemented
[Server@241fa0]: [Thread[HSQLDB Server @241fa0,5,main]]:
run()/openDatabases():
[Server@241fa0]: Initiating shutdown sequence...
[Server@241fa0]: Shutdown sequence completed in 1 ms.
[Server@241fa0]: 2006-05-11 06:48:50.186 SHUTDOWN : System.exit() is called
next


But I can able do the same in Windows machine. The error is occurred when
trying with Linux machine.
Can anyone help me?
Thank you in advance.

Suja.

[ocho79]

I just can guess, but are the file permissions are set correctly for the files and folders in the hypersonic folder?

[suja]

Hi

The file permissions are set correctly.

[dearprasan]

hi,
if you have figured out solution to your problem, I would be glad to know it.

Thanks,

[hboy]

I dunno if this is the valid place to post this or if I should have posted another topic, but since this looks dead and my problem is almost identitcal i think posting it here is a good idea.

When I run just the start_hypersonic.sh script it gives me this output. Very similiar to the suja's problem. The funny thing though is that yesterday I had gotten everything up and running from the preconfigure instalation on unix. But today when i started it it gave me this error. I had restarted the server and everything. I then tried to uninstall and reinstall and that didnt help.

Any help is greatly appreciated.

[root@casanl3edmapp data]# ./start_hypersonic.sh
[Server@1f1fa0]: [Thread[main,5,main]]: checkRunning(false) entered
[Server@1f1fa0]: [Thread[main,5,main]]: checkRunning(false) exited
[Server@1f1fa0]: Startup sequence initiated from main() method
[Server@1f1fa0]: Loaded properties from [/opt/pentaho-demo/data/server.properties]
[Server@1f1fa0]: Initiating startup sequence...
[Server@1f1fa0]: Server socket opened successfully in 4 ms.
[Server@1f1fa0]: [Thread[HSQLDB Server @1f1fa0,5,main]]: Database [index=0db=file:sampledata/sampledata, alias=sampledata] did not open: org.hsqldb.HsqlException: General error: java.lang.Error: Not implemented
[Server@1f1fa0]: [Thread[HSQLDB Server @1f1fa0,5,main]]: Database [index=1db=file:shark/shark, alias=shark] did not open: org.hsqldb.HsqlException: General error: java.lang.Error: Not implemented
[Server@1f1fa0]: [Thread[HSQLDB Server @1f1fa0,5,main]]: Database [index=2db=file:hibernate/hibernate, alias=hibernate] did not open: org.hsqldb.HsqlException: General error: java.lang.Error: Not implemented
[Server@1f1fa0]: [Thread[HSQLDB Server @1f1fa0,5,main]]: Database [index=3db=file:quartz/quartz, alias=quartz] did not open: org.hsqldb.HsqlException: General error: java.lang.Error: Not implemented
[Server@1f1fa0]: [Thread[HSQLDB Server @1f1fa0,5,main]]: run()/openDatabases():
[Server@1f1fa0]: Initiating shutdown sequence...
[Server@1f1fa0]: Shutdown sequence completed in 5 ms.
[Server@1f1fa0]: 2006-08-31 13:08:19.331 SHUTDOWN : System.exit() is called next

[mbatchelor]

I can't say exactly what's going wrong, but I suspect two things:

a- Your path includes an old version of java (I suspect this the strongest).

b- Somewhere on your classpath is an old version of the hypersonic .jar file (I somewhat doubt this because of the -cp in the command).

I think it's one or the other.

So, to try to debug this, I recommend the following:

1- Modify the start_hypersonic.sh to add the following after the java command:

-showversion -verbose

So, the command will look something like this:

java -showversion -verbose -cp lib/hsqldb.jar org.hsqldb.Server -database.0 sampledata/sampledata -dbname.0 s(... rest of the line here )

2- Restart your machine and run the shell script.


The -showversion should show you the java version that is running the command. My guess is that it's a 1.1.x version of java.

Please let us know what you find,

Marc

[elsalazar]

My english is bad, but i try:

use other version de java. if you linux is debian you should get the java from blankdown-linux, try to use 1.4 version . check JAVA_HOME in start_hypersonic.sh and modify the path of the hsqldb.jar file (check the path)



In this moment i try install pentaho in Linux-debian etch version, i find some problems.

Bye

[elsalazar]

My english is bad, but i try:

use other version de java. if you linux is debian you should get the java from blankdown-linux, try to use 1.4 version . check JAVA_HOME in start_hypersonic.sh and modify the path of the hsqldb.jar file (check the path)



In this moment i try install pentaho in Linux-debian etch version, i find some problems.

Bye

[elsalazar]

My english is bad, but i try:

use other version de java. if you linux is debian you should get the java from blankdown-linux, try to use 1.4 version . check JAVA_HOME in start_hypersonic.sh and modify the path of the hsqldb.jar file (check the path)



In this moment i try install pentaho in Linux-debian etch version, i find some problems.

Bye

[johnsona]

Marc Batchelor wrote:

a- Your path includes an old version of java (I suspect this the strongest).


I can confirm that this was the problem on my Centos 4.3 install. editing start_hypersonic.sh to specify the path to the correct java version solved the problem for me.

Al.