3 Replies Latest reply on Jun 4, 2009 4:56 AM by arjun purushothaman

    Problem with HSQLDB in JBoss ESB 4.4.GA

    arjun purushothaman Newbie

      Hi,

      Iam new to JBoss ESB. Iam using JBoss ESB 4.4 GA version. Iam facing some issue while executing the sample program available in ESB Server ("samples\quickstarts\helloworld_tx_sql_action") . When i ran "ant select" from command line, iam getting the below exception.

      org.h2.jdbc.JdbcSQLException: Connection is broken [90067-68]
      at org.h2.message.Message.getSQLException(Message.java:91)
      at org.h2.message.Message.getSQLException(Message.java:95)
      at org.h2.message.Message.getSQLException(Message.java:73)
      at org.h2.message.Message.getSQLException(Message.java:116)
      at org.h2.engine.SessionRemote.checkClosed(SessionRemote.java:250)
      at org.h2.engine.SessionRemote.connect(SessionRemote.java:218)
      at org.h2.engine.SessionRemote.(SessionRemote.java:160)
      at org.h2.engine.SessionRemote.createSession(SessionRemote.java:155)
      at org.h2.jdbc.JdbcConnection.(JdbcConnection.java:967)
      at org.h2.jdbc.JdbcConnection.(JdbcConnection.java:957)
      at org.h2.Driver.connect(Driver.java:57)
      at org.apache.tools.ant.taskdefs.JDBCTask.getConnection(JDBCTask.java:31
      9)
      at org.apache.tools.ant.taskdefs.SQLExec.execute(SQLExec.java:429)
      at org.apache.tools.ant.UnknownElement.execute(UnknownElement.java:288)
      at sun.reflect.GeneratedMethodAccessor1.invoke(Unknown Source)
      at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAcces
      sorImpl.java:25)
      at java.lang.reflect.Method.invoke(Method.java:597)
      at org.apache.tools.ant.dispatch.DispatchUtils.execute(DispatchUtils.jav
      a:106)
      at org.apache.tools.ant.Task.perform(Task.java:348)
      at org.apache.tools.ant.Target.execute(Target.java:357)
      at org.apache.tools.ant.Target.performTasks(Target.java:385)
      at org.apache.tools.ant.Project.executeSortedTargets(Project.java:1337)
      at org.apache.tools.ant.Project.executeTarget(Project.java:1306)
      at org.apache.tools.ant.helper.DefaultExecutor.executeTargets(DefaultExe


      Please help me to resolve this issue.

      Thanks in Advance,
      Arjun

        • 1. Re: Problem with HSQLDB in JBoss ESB 4.4.GA
          Daniel Bevenius Master

          Hi,

          Are you seeing this after you've deployed the quickstart?

          The quickstart deployes the database and upon undeployment 'ant select' will fail with the error message you posted.
          If you still get this error when the quickstart is deployed then please let me know and I'll take a look.

          Regards,

          /Daniel

          • 2. Re: Problem with HSQLDB in JBoss ESB 4.4.GA
            arjun purushothaman Newbie

            Hi Daniel,

            I was missing "ant deploy". Now iam able to deploy it successfully and "ant select" is showing SQL statements executed succesfully.
            But when i excute "ant run", iam getting the following exceptions. But "ant runtest" from another console is successful.
            Below is the exception of "ant run" (exception is preety big, so iam not pasting all ).

            run:
            [echo] Launching Quickstart in standalone mode...
            [qsjava] +----------------------------------------------------------+
            [qsjava] | |
            [qsjava] | Starting JBossESB... |
            [qsjava] | |
            [qsjava] +----------------------------------------------------------+
            [qsjava] Reading config from C:\softwares\jbossesb-server-4.4.GA\samples\quic
            kstarts\helloworld_tx_sql_action\jboss-esb.xml
            [qsjava] 17:27:11,781 INFO [main][SimpleThreadPool] Job execution threads wi
            ll use class loader of thread: main
            [qsjava] 17:27:11,828 INFO [main][QuartzScheduler] Quartz Scheduler v.1.5.2
            created.
            [qsjava] 17:27:11,843 INFO [main][RAMJobStore] RAMJobStore initialized.
            [qsjava] 17:27:11,843 INFO [main][StdSchedulerFactory] Quartz scheduler 'Def
            aultQuartzScheduler' initialized from an externally provided properties instance
            .
            [qsjava] 17:27:11,859 INFO [main][StdSchedulerFactory] Quartz scheduler vers
            ion: 1.5.2
            [qsjava] 17:27:13,531 ERROR [main][JDBCEprDBResourceFactory] Problem resolvin
            g DataSource through JNDI
            [qsjava] javax.naming.NameNotFoundException: HelloworldTxSqlDB not bound
            [qsjava] at org.jnp.server.NamingServer.getBinding(NamingServer.java:529)

            [qsjava] at org.jnp.server.NamingServer.getBinding(NamingServer.java:537)

            [qsjava] at org.jnp.server.NamingServer.getObject(NamingServer.java:543)
            [qsjava] at org.jnp.server.NamingServer.lookup(NamingServer.java:296)
            [qsjava] at sun.reflect.GeneratedMethodAccessor79.invoke(Unknown Source)
            [qsjava] at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMet
            hodAccessorImpl.java:25)
            [qsjava] at java.lang.reflect.Method.invoke(Method.java:597)
            [qsjava] at sun.rmi.server.UnicastServerRef.dispatch(UnicastServerRef.jav
            a:305)
            [qsjava] at sun.rmi.transport.Transport$1.run(Transport.java:159)
            [qsjava] at java.security.AccessController.doPrivileged(Native Method)
            [qsjava] at sun.rmi.transport.Transport.serviceCall(Transport.java:155)
            [qsjava] at sun.rmi.transport.tcp.TCPTransport.handleMessages(TCPTranspor
            t.java:535)
            [qsjava] at sun.rmi.transport.tcp.TCPTransport$ConnectionHandler.run0(TCP
            Transport.java:790)
            [qsjava] at sun.rmi.transport.tcp.TCPTransport$ConnectionHandler.run(TCPT
            ransport.java:649)
            [qsjava] at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(Thread
            PoolExecutor.java:885)
            [qsjava] at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPool
            Executor.java:907)
            [qsjava] at java.lang.Thread.run(Thread.java:619)
            [qsjava] at sun.rmi.transport.StreamRemoteCall.exceptionReceivedFromServe
            r(StreamRemoteCall.java:255)
            [qsjava] at sun.rmi.transport.StreamRemoteCall.executeCall(StreamRemoteCa




            When i execute "ant create", then iam getting the below exception. (This was given in Readme.txt file that once we deploy then execute this command)


            create:
            [echo] create table tx_esb_messages
            [sql] Executing commands
            [sql] Failed to execute: create table tx_esb_messages(MESSAGE_ID varchar
            , STATUS_COL varchar NOT NULL, TIMESTAMP_COL bigint, DATA_COL varchar NOT NULL)

            BUILD FAILED
            org.h2.jdbc.JdbcSQLException: Table TX_ESB_MESSAGES already exists [42101-68]
            at org.h2.message.Message.getSQLException(Message.java:91)
            at org.h2.message.Message.getSQLException(Message.java:95)
            at org.h2.message.Message.getSQLException(Message.java:73)
            at org.h2.command.ddl.CreateTable.update(CreateTable.java:112)
            at org.h2.command.CommandContainer.update(CommandContainer.java:69)
            at org.h2.command.Command.executeUpdate(Command.java:197)
            at org.h2.server.TcpServerThread.process(TcpServerThread.java:248)
            at org.h2.server.TcpServerThread.run(TcpServerThread.java:104)
            at java.lang.Thread.run(Thread.java:619)

            at org.h2.engine.SessionRemote.done(SessionRemote.java:295)
            at org.h2.command.CommandRemote.executeUpdate(CommandRemote.java:172)
            at org.h2.jdbc.JdbcStatement.execute(JdbcStatement.java:154)
            at org.apache.tools.ant.taskdefs.SQLExec.execSQL(SQLExec.java:565)
            at org.apache.tools.ant.taskdefs.SQLExec.runStatements(SQLExec.java:535)

            at org.apache.tools.ant.taskdefs.SQLExec$Transaction.runTransaction(SQLE
            xec.java:764)
            at org.apache.tools.ant.taskdefs.SQLExec$Transaction.access$000(SQLExec.

            Thanks in Advance,
            Arjun

            • 3. Re: Problem with HSQLDB in JBoss ESB 4.4.GA
              arjun purushothaman Newbie

              Hi All,

              Please help me on this issue as still iam not able to resolve it.

              Thanks,
              Arjun