Problem with HSQLDB in JBoss ESB 4.4.GA

[arjunpnair]

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

[beve]

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

[arjunpnair]

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

[arjunpnair]

Hi All,

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

Thanks,
Arjun