Thanks Jai.....
I have deleted localDB.backup, localDB.data, localDB.lck, localDB.log files from the data/hypersonic -- folder leaving localDB.properties and localDB.script. I started the server.... now i got different error messages..
=======================================================================
15:42:15,120 INFO [SimpleThreadPool] Job execution threads will use class loader of
thread: main
15:42:15,199 INFO [QuartzScheduler] Quartz Scheduler v.1.5.2 created.
15:42:15,239 INFO [RAMJobStore] RAMJobStore initialized.
15:42:15,239 INFO [StdSchedulerFactory] Quartz scheduler 'DefaultQuartzScheduler' initialized from default resource file in Quartz package: 'quartz.properties'
15:42:15,239 INFO [StdSchedulerFactory] Quartz scheduler version: 1.5.2
15:42:15,240 INFO [QuartzScheduler] Scheduler DefaultQuartzScheduler_$_NON_CLUSTERED started.
15:42:18,126 ERROR [STDERR] java.lang.IndexOutOfBoundsException
15:42:18,416 ERROR [STDERR] at java.nio.Buffer.checkBounds(Buffer.java:454)
15:42:18,416 ERROR [STDERR] at java.nio.ByteBuffer.get(ByteBuffer.java:648)
15:42:18,416 ERROR [STDERR] at java.nio.DirectByteBuffer.get(DirectByteBuffer.java:233)
15:42:18,416 ERROR [STDERR] at org.hsqldb.persist.NIOScaledRAFile.read(Unknown Source)
15:42:18,417 ERROR [STDERR] at org.hsqldb.persist.DataFileCache.readObject(Unknown Source)
15:42:18,417 ERROR [STDERR] at org.hsqldb.persist.DataFileCache.get(Unknown Source)
15:42:18,448 ERROR [STDERR] at org.hsqldb.Table$RowStore.get(Unknown Source)
15:42:18,448 ERROR [STDERR] at org.hsqldb.Table.setIndexRoots(Unknown Source)
15:42:18,448 ERROR [STDERR] at org.hsqldb.Table.setIndexRoots(Unknown Source)
15:42:19,668 ERROR [STDERR] at $Proxy5.deploy(Unknown Source)
15:42:19,668 ERROR [STDERR] at org.jboss.system.server.ServerImpl.doStart(ServerImpl.java:482)
15:42:19,668 ERROR [STDERR] at org.jboss.system.server.ServerImpl.start(ServerImpl.java:362)
15:42:19,668 ERROR [STDERR] at org.jboss.Main.boot(Main.java:200)
15:42:19,699 ERROR [STDERR] at org.jboss.Main$1.run(Main.java:464)
15:42:19,700 ERROR [STDERR] at java.lang.Thread.run(Thread.java:595)
15:42:20,412 WARN [ServiceController] Problem starting service jboss:service=Hypersonic,database=localDB
java.sql.SQLException: error in script file line: 78 S1000 General error java.lang.IndexOutOfBoundsException in statement [SET TABLE JMS_MESSAGES INDEX'46727824 46727824 46727824 0']
at org.hsqldb.jdbc.Util.sqlException(Unknown Source)
at org.hsqldb.jdbc.jdbcConnection.<init>(Unknown Source)
at org.hsqldb.jdbcDriver.getConnection(Unknown Source)
at org.hsqldb.jdbcDriver.connect(Unknown Source)
at java.sql.DriverManager.getConnection(DriverManager.java:525)
at java.sql.DriverManager.getConnection(DriverManager.java:171)
at org.jboss.jdbc.HypersonicDatabase.getConnection(HypersonicDatabase.java:761)
at org.jboss.jdbc.HypersonicDatabase.startStandaloneDatabase(HypersonicDatabase.java:611)
at org.jboss.jdbc.HypersonicDatabase.startService(HypersonicDatabase.java:557)
at org.jboss.system.ServiceMBeanSupport.jbossInternalStart(ServiceMBeanSupport.java:289)
at org.jboss.system.ServiceMBeanSupport.jbossInternalLifecycle(ServiceMBeanSupport.java:245)
at sun.reflect.GeneratedMethodAccessor3.invoke(Unknown Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
at java.lang.reflect.Method.invoke(Method.java:585)
at org.jboss.mx.interceptor.ReflectedDispatcher.invoke(ReflectedDispatcher.java:155)
at org.jboss.mx.server.Invocation.dispatch(Invocation.java:94)
at org.jboss.mx.server.Invocation.invoke(Invocation.java:86)
at org.jboss.mx.server.AbstractMBeanInvoker.invoke(AbstractMBeanInvoker.java:264)
at org.jboss.mx.server.MBeanServerImpl.invoke(MBeanServerImpl.java:659)
at org.jboss.system.ServiceController$ServiceProxy.invoke(ServiceController.java:978)
at $Proxy0.start(Unknown Source)
at org.jboss.system.ServiceController.start(ServiceController.java:417)
at sun.reflect.GeneratedMethodAccessor6.invoke(Unknown Source)
at org.jboss.system.server.ServerImpl.start(ServerImpl.java:362)
at org.jboss.Main.boot(Main.java:200)
at org.jboss.Main$1.run(Main.java:464)
at java.lang.Thread.run(Thread.java:595)
15:42:21,401 INFO [ConnectionFactoryBindingService] Bound ConnectionManager 'jboss.jca:service=ConnectionFactoryBinding,name=JmsXA' to JNDI name 'java:JmsXA'
15:42:22,558 INFO [ConnectionFactoryBindingService] Bound ConnectionManager 'jboss.jca:service=DataSourceBinding,name=MySqlDS' to JNDI name 'java:MySqlDS'
15:42:22,611 INFO [ConnectionFactoryBindingService] Bound ConnectionManager 'jboss.jca:service=DataSourceBinding,name=MySqlTS' to JNDI name 'java:MySqlTS'
15:42:22,647 INFO [ConnectionFactoryBindingService] Bound ConnectionManager 'jboss.jca:service=DataSourceBinding,name=MySqlEmployee' to JNDI name 'java:MySqlEmployee'
15:42:23,215 INFO [TomcatDeployer] deploy, ctxPath=/jmx-console, warUrl=.../deploy/jmx-console.war/
15:42:23,542 INFO [EARDeployer] Init
J2EE application: file:/usr/local/PROJECT INSIDE/jboss-4.0.4/server/default/deploy/projectinside.ear/
15:42:25,342 INFO [EjbModule] Deploying OrganizationEJB
15:42:25,836 INFO [EjbModule] Deploying PIUserEJB
15:42:25,878 INFO [EjbModule] Deploying ConnectionPoolEJB
15:42:25,919 INFO [EjbModule] Deploying LoggedInUserStateEJB
15:42:28,547 INFO [Ejb3Deployment] EJB3 deployment time took: 2046
15:42:28,922 INFO [ProxyFactory] Bound EJB Home 'OrganizationEJB' to jndi 'OrganizationEJB'
15:42:28,955 WARN [EntityContainer] Could not restore ejb timers
javax.management.RuntimeMBeanException
at org.jboss.mx.interceptor.ReflectedDispatcher.handleInvocationExceptions(ReflectedDispatcher.java:176)
at org.jboss.mx.interceptor.ReflectedDispatcher.invoke(ReflectedDispatcher.java:163)
at org.jboss.mx.server.Invocation.dispatch(Invocation.java:94)
at org.jboss.mx.server.Invocation.invoke(Invocation.java:86)
at org.jboss.mx.server.AbstractMBeanInvoker.invoke(AbstractMBeanInvoker.java:264)
at org.jboss.mx.server.MBeanServerImpl.invoke(MBeanServerImpl.java:659)
============================================================================
thanks,
Andy
efaultDS'
