You are viewing a plain text version of this content. The canonical link for it is here.
Posted to users@activemq.apache.org by David Borja <ad...@gmail.com> on 2006/09/28 23:00:58 UTC
Problems with activemq + c-jdbc
*2006-09-28 16:02:16,806 WARN controller.RequestManager.myDB SQLException
while
executing distributed write request.
java.sql.SQLException: Request 0 failed:
BackendThread activemq1528 failed (Table/View 'ACTIVEMQ_MSGS' already exists
in
Schema 'ACTIVEMQ'.)
BackendThread activemq1527 failed (Table/View 'ACTIVEMQ_MSGS' already exists
in
Schema 'ACTIVEMQ'.)
at
org.objectweb.cjdbc.common.exceptions.SQLExceptionFactory.getSQLExcep
tion(SQLExceptionFactory.java:94)
at
org.objectweb.cjdbc.controller.loadbalancer.raidb1.RAIDb1.execWriteRe
quest(RAIDb1.java:582)
at
org.objectweb.cjdbc.controller.loadbalancer.raidb1.RAIDb1.execWriteRe
quest(RAIDb1.java:350)
at
org.objectweb.cjdbc.controller.requestmanager.RequestManager.loadBala
nceExecWriteRequest(RequestManager.java:689)
at
org.objectweb.cjdbc.controller.virtualdatabase.protocol.ExecWriteRequ
est.executeScheduledRequest(ExecWriteRequest.java:79)
at
org.objectweb.cjdbc.controller.virtualdatabase.DistributedVirtualData
base.handleMessageMultiThreaded(DistributedVirtualDatabase.java:831)
at org.objectweb.tribe.adapters.MulticastRequestAdapterThread.run
(Multic
astRequestAdapterThread.java:79)
java.io.NotSerializableException: org.apache.derby.client.net.NetSqlca
at java.io.ObjectOutputStream.writeObject0(Unknown Source)
at java.io.ObjectOutputStream.defaultWriteFields(Unknown Source)
at java.io.ObjectOutputStream.writeSerialData(Unknown Source)
at java.io.ObjectOutputStream.writeOrdinaryObject(Unknown Source)
at java.io.ObjectOutputStream.writeObject0(Unknown Source)
at java.io.ObjectOutputStream.defaultWriteFields(Unknown Source)
at java.io.ObjectOutputStream.writeSerialData(Unknown Source)
at java.io.ObjectOutputStream.writeOrdinaryObject(Unknown Source)
at java.io.ObjectOutputStream.writeObject0(Unknown Source)
at java.io.ObjectOutputStream.defaultWriteFields(Unknown Source)
at java.io.ObjectOutputStream.writeSerialData(Unknown Source)
at java.io.ObjectOutputStream.writeOrdinaryObject(Unknown Source)
at java.io.ObjectOutputStream.writeObject0(Unknown Source)
at java.io.ObjectOutputStream.defaultWriteFields(Unknown Source)
at java.io.ObjectOutputStream.writeSerialData(Unknown Source)
at java.io.ObjectOutputStream.writeOrdinaryObject(Unknown Source)
at java.io.ObjectOutputStream.writeObject0(Unknown Source)
at java.io.ObjectOutputStream.defaultWriteFields(Unknown Source)
at java.io.ObjectOutputStream.writeSerialData(Unknown Source)
at java.io.ObjectOutputStream.writeOrdinaryObject(Unknown Source)
at java.io.ObjectOutputStream.writeObject0(Unknown Source)
at java.io.ObjectOutputStream.defaultWriteFields(Unknown Source)
at java.io.ObjectOutputStream.writeSerialData(Unknown Source)
at java.io.ObjectOutputStream.writeOrdinaryObject(Unknown Source)
at java.io.ObjectOutputStream.writeObject0(Unknown Source)
at java.io.ObjectOutputStream.writeObject(Unknown Source)
at java.util.ArrayList.writeObject(Unknown Source)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
at java.lang.reflect.Method.invoke(Unknown Source)
at java.io.ObjectStreamClass.invokeWriteObject(Unknown Source)
at java.io.ObjectOutputStream.writeSerialData(Unknown Source)
at java.io.ObjectOutputStream.writeOrdinaryObject(Unknown Source)
at java.io.ObjectOutputStream.writeObject0(Unknown Source)
at java.io.ObjectOutputStream.defaultWriteFields(Unknown Source)
at java.io.ObjectOutputStream.writeSerialData(Unknown Source)
at java.io.ObjectOutputStream.writeOrdinaryObject(Unknown Source)
at java.io.ObjectOutputStream.writeObject0(Unknown Source)
at java.io.ObjectOutputStream.writeObject(Unknown Source)
at org.objectweb.tribe.messages.ChannelMessage.getByteArray
(ChannelMessa
ge.java:173)
at org.objectweb.tribe.channel.JGroupsReliableChannelWithGms.send
(JGroup
sReliableChannelWithGms.java:245)
at org.objectweb.tribe.channel.ReliableGroupChannel.send
(ReliableGroupCh
annel.java:148)
at org.objectweb.tribe.adapters.PullPushAdapter.send(
PullPushAdapter.jav
a:158)
at org.objectweb.tribe.adapters.MulticastRequestAdapterThread.run
(Multic
astRequestAdapterThread.java:97)
Any Ideas??
Alvaro David Borja
Solutions Architect
*
Re: Problems with activemq + c-jdbc
Posted by Hiram Chirino <hi...@hiramchirino.com>.
Not really. It ignores any errors that it gets when it tries to
create the table. So look past the table creation related errors. :)
On 9/29/06, David Borja <ad...@gmail.com> wrote:
> Hi Hiram ...
>
> But ActiveMQ is creating the ACTIVEMQ_MSG table each time that runs, this is
> not an ActiveMQ problem?, does`nt exist something like
> setAutoCreationTables(false)?
>
> Thanx!!
>
>
> On 9/29/06, Hiram Chirino <hi...@hiramchirino.com> wrote:
> >
> > you might want to post this to the cjdbc guys. If they tell you
> > what's causing the error, we may be able to help some more.
> >
> > On 9/28/06, David Borja <ad...@gmail.com> wrote:
> > > *2006-09-28 16:02:16,806 WARN controller.RequestManager.myDBSQLException
> > > while
> > > executing distributed write request.
> > > java.sql.SQLException: Request 0 failed:
> > > BackendThread activemq1528 failed (Table/View 'ACTIVEMQ_MSGS' already
> > exists
> > > in
> > > Schema 'ACTIVEMQ'.)
> > > BackendThread activemq1527 failed (Table/View 'ACTIVEMQ_MSGS' already
> > exists
> > > in
> > > Schema 'ACTIVEMQ'.)
> > >
> > > at
> > > org.objectweb.cjdbc.common.exceptions.SQLExceptionFactory.getSQLExcep
> > > tion(SQLExceptionFactory.java:94)
> > > at
> > > org.objectweb.cjdbc.controller.loadbalancer.raidb1.RAIDb1.execWriteRe
> > > quest(RAIDb1.java:582)
> > > at
> > > org.objectweb.cjdbc.controller.loadbalancer.raidb1.RAIDb1.execWriteRe
> > > quest(RAIDb1.java:350)
> > > at
> > > org.objectweb.cjdbc.controller.requestmanager.RequestManager.loadBala
> > > nceExecWriteRequest(RequestManager.java:689)
> > > at
> > > org.objectweb.cjdbc.controller.virtualdatabase.protocol.ExecWriteRequ
> > > est.executeScheduledRequest(ExecWriteRequest.java:79)
> > > at
> > > org.objectweb.cjdbc.controller.virtualdatabase.DistributedVirtualData
> > > base.handleMessageMultiThreaded(DistributedVirtualDatabase.java:831)
> > > at
> > org.objectweb.tribe.adapters.MulticastRequestAdapterThread.run
> > > (Multic
> > > astRequestAdapterThread.java:79)
> > > java.io.NotSerializableException: org.apache.derby.client.net.NetSqlca
> > > at java.io.ObjectOutputStream.writeObject0(Unknown Source)
> > > at java.io.ObjectOutputStream.defaultWriteFields(Unknown Source)
> > > at java.io.ObjectOutputStream.writeSerialData(Unknown Source)
> > > at java.io.ObjectOutputStream.writeOrdinaryObject(Unknown
> > Source)
> > > at java.io.ObjectOutputStream.writeObject0(Unknown Source)
> > > at java.io.ObjectOutputStream.defaultWriteFields(Unknown Source)
> > > at java.io.ObjectOutputStream.writeSerialData(Unknown Source)
> > > at java.io.ObjectOutputStream.writeOrdinaryObject(Unknown
> > Source)
> > > at java.io.ObjectOutputStream.writeObject0(Unknown Source)
> > > at java.io.ObjectOutputStream.defaultWriteFields(Unknown Source)
> > > at java.io.ObjectOutputStream.writeSerialData(Unknown Source)
> > > at java.io.ObjectOutputStream.writeOrdinaryObject(Unknown
> > Source)
> > > at java.io.ObjectOutputStream.writeObject0(Unknown Source)
> > > at java.io.ObjectOutputStream.defaultWriteFields(Unknown Source)
> > > at java.io.ObjectOutputStream.writeSerialData(Unknown Source)
> > > at java.io.ObjectOutputStream.writeOrdinaryObject(Unknown
> > Source)
> > > at java.io.ObjectOutputStream.writeObject0(Unknown Source)
> > > at java.io.ObjectOutputStream.defaultWriteFields(Unknown Source)
> > > at java.io.ObjectOutputStream.writeSerialData(Unknown Source)
> > > at java.io.ObjectOutputStream.writeOrdinaryObject(Unknown
> > Source)
> > > at java.io.ObjectOutputStream.writeObject0(Unknown Source)
> > > at java.io.ObjectOutputStream.defaultWriteFields(Unknown Source)
> > > at java.io.ObjectOutputStream.writeSerialData(Unknown Source)
> > > at java.io.ObjectOutputStream.writeOrdinaryObject(Unknown
> > Source)
> > > at java.io.ObjectOutputStream.writeObject0(Unknown Source)
> > > at java.io.ObjectOutputStream.writeObject(Unknown Source)
> > > at java.util.ArrayList.writeObject(Unknown Source)
> > > at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
> > > at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)
> > > at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown
> > Source)
> > > at java.lang.reflect.Method.invoke(Unknown Source)
> > > at java.io.ObjectStreamClass.invokeWriteObject(Unknown Source)
> > > at java.io.ObjectOutputStream.writeSerialData(Unknown Source)
> > > at java.io.ObjectOutputStream.writeOrdinaryObject(Unknown
> > Source)
> > > at java.io.ObjectOutputStream.writeObject0(Unknown Source)
> > > at java.io.ObjectOutputStream.defaultWriteFields(Unknown Source)
> > > at java.io.ObjectOutputStream.writeSerialData(Unknown Source)
> > > at java.io.ObjectOutputStream.writeOrdinaryObject(Unknown
> > Source)
> > > at java.io.ObjectOutputStream.writeObject0(Unknown Source)
> > > at java.io.ObjectOutputStream.writeObject(Unknown Source)
> > > at org.objectweb.tribe.messages.ChannelMessage.getByteArray
> > > (ChannelMessa
> > > ge.java:173)
> > > at
> > org.objectweb.tribe.channel.JGroupsReliableChannelWithGms.send
> > > (JGroup
> > > sReliableChannelWithGms.java:245)
> > > at org.objectweb.tribe.channel.ReliableGroupChannel.send
> > > (ReliableGroupCh
> > > annel.java:148)
> > > at org.objectweb.tribe.adapters.PullPushAdapter.send(
> > > PullPushAdapter.jav
> > > a:158)
> > > at
> > org.objectweb.tribe.adapters.MulticastRequestAdapterThread.run
> > > (Multic
> > > astRequestAdapterThread.java:97)
> > >
> > > Any Ideas??
> > >
> > > Alvaro David Borja
> > > Solutions Architect
> > >
> > > *
> > >
> > >
> >
> >
> > --
> > Regards,
> > Hiram
> >
> > Blog: http://hiramchirino.com
> >
>
>
--
Regards,
Hiram
Blog: http://hiramchirino.com
Re: Problems with activemq + c-jdbc
Posted by David Borja <ad...@gmail.com>.
Hi James ...
Where can i set that property ???? in broker URL ??
String borkerURL = "tcp://localhost:61616?createTablesOnStartup=false"
or something like that??
Thanx !
On 9/29/06, James Strachan <ja...@gmail.com> wrote:
>
> ActiveMQ tries to auto-create tables on startup but as you say you
> can disable that if you wish via the createTablesOnStartup property.
>
> On 9/29/06, David Borja <ad...@gmail.com> wrote:
> > Hi Hiram ...
> >
> > But ActiveMQ is creating the ACTIVEMQ_MSG table each time that runs,
> this is
> > not an ActiveMQ problem?, does`nt exist something like
> > setAutoCreationTables(false)?
> >
> > Thanx!!
> >
> >
> > On 9/29/06, Hiram Chirino <hi...@hiramchirino.com> wrote:
> > >
> > > you might want to post this to the cjdbc guys. If they tell you
> > > what's causing the error, we may be able to help some more.
> > >
> > > On 9/28/06, David Borja <ad...@gmail.com> wrote:
> > > > *2006-09-28 16:02:16,806 WARN
> controller.RequestManager.myDBSQLException
> > > > while
> > > > executing distributed write request.
> > > > java.sql.SQLException: Request 0 failed:
> > > > BackendThread activemq1528 failed (Table/View 'ACTIVEMQ_MSGS'
> already
> > > exists
> > > > in
> > > > Schema 'ACTIVEMQ'.)
> > > > BackendThread activemq1527 failed (Table/View 'ACTIVEMQ_MSGS'
> already
> > > exists
> > > > in
> > > > Schema 'ACTIVEMQ'.)
> > > >
> > > > at
> > > >
> org.objectweb.cjdbc.common.exceptions.SQLExceptionFactory.getSQLExcep
> > > > tion(SQLExceptionFactory.java:94)
> > > > at
> > > >
> org.objectweb.cjdbc.controller.loadbalancer.raidb1.RAIDb1.execWriteRe
> > > > quest(RAIDb1.java:582)
> > > > at
> > > >
> org.objectweb.cjdbc.controller.loadbalancer.raidb1.RAIDb1.execWriteRe
> > > > quest(RAIDb1.java:350)
> > > > at
> > > >
> org.objectweb.cjdbc.controller.requestmanager.RequestManager.loadBala
> > > > nceExecWriteRequest(RequestManager.java:689)
> > > > at
> > > >
> org.objectweb.cjdbc.controller.virtualdatabase.protocol.ExecWriteRequ
> > > > est.executeScheduledRequest(ExecWriteRequest.java:79)
> > > > at
> > > >
> org.objectweb.cjdbc.controller.virtualdatabase.DistributedVirtualData
> > > > base.handleMessageMultiThreaded(DistributedVirtualDatabase.java:831)
> > > > at
> > > org.objectweb.tribe.adapters.MulticastRequestAdapterThread.run
> > > > (Multic
> > > > astRequestAdapterThread.java:79)
> > > > java.io.NotSerializableException:
> org.apache.derby.client.net.NetSqlca
> > > > at java.io.ObjectOutputStream.writeObject0(Unknown Source)
> > > > at java.io.ObjectOutputStream.defaultWriteFields(Unknown
> Source)
> > > > at java.io.ObjectOutputStream.writeSerialData(Unknown
> Source)
> > > > at java.io.ObjectOutputStream.writeOrdinaryObject(Unknown
> > > Source)
> > > > at java.io.ObjectOutputStream.writeObject0(Unknown Source)
> > > > at java.io.ObjectOutputStream.defaultWriteFields(Unknown
> Source)
> > > > at java.io.ObjectOutputStream.writeSerialData(Unknown
> Source)
> > > > at java.io.ObjectOutputStream.writeOrdinaryObject(Unknown
> > > Source)
> > > > at java.io.ObjectOutputStream.writeObject0(Unknown Source)
> > > > at java.io.ObjectOutputStream.defaultWriteFields(Unknown
> Source)
> > > > at java.io.ObjectOutputStream.writeSerialData(Unknown
> Source)
> > > > at java.io.ObjectOutputStream.writeOrdinaryObject(Unknown
> > > Source)
> > > > at java.io.ObjectOutputStream.writeObject0(Unknown Source)
> > > > at java.io.ObjectOutputStream.defaultWriteFields(Unknown
> Source)
> > > > at java.io.ObjectOutputStream.writeSerialData(Unknown
> Source)
> > > > at java.io.ObjectOutputStream.writeOrdinaryObject(Unknown
> > > Source)
> > > > at java.io.ObjectOutputStream.writeObject0(Unknown Source)
> > > > at java.io.ObjectOutputStream.defaultWriteFields(Unknown
> Source)
> > > > at java.io.ObjectOutputStream.writeSerialData(Unknown
> Source)
> > > > at java.io.ObjectOutputStream.writeOrdinaryObject(Unknown
> > > Source)
> > > > at java.io.ObjectOutputStream.writeObject0(Unknown Source)
> > > > at java.io.ObjectOutputStream.defaultWriteFields(Unknown
> Source)
> > > > at java.io.ObjectOutputStream.writeSerialData(Unknown
> Source)
> > > > at java.io.ObjectOutputStream.writeOrdinaryObject(Unknown
> > > Source)
> > > > at java.io.ObjectOutputStream.writeObject0(Unknown Source)
> > > > at java.io.ObjectOutputStream.writeObject(Unknown Source)
> > > > at java.util.ArrayList.writeObject(Unknown Source)
> > > > at sun.reflect.NativeMethodAccessorImpl.invoke0(Native
> Method)
> > > > at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown
> Source)
> > > > at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown
> > > Source)
> > > > at java.lang.reflect.Method.invoke(Unknown Source)
> > > > at java.io.ObjectStreamClass.invokeWriteObject(Unknown
> Source)
> > > > at java.io.ObjectOutputStream.writeSerialData(Unknown
> Source)
> > > > at java.io.ObjectOutputStream.writeOrdinaryObject(Unknown
> > > Source)
> > > > at java.io.ObjectOutputStream.writeObject0(Unknown Source)
> > > > at java.io.ObjectOutputStream.defaultWriteFields(Unknown
> Source)
> > > > at java.io.ObjectOutputStream.writeSerialData(Unknown
> Source)
> > > > at java.io.ObjectOutputStream.writeOrdinaryObject(Unknown
> > > Source)
> > > > at java.io.ObjectOutputStream.writeObject0(Unknown Source)
> > > > at java.io.ObjectOutputStream.writeObject(Unknown Source)
> > > > at org.objectweb.tribe.messages.ChannelMessage.getByteArray
> > > > (ChannelMessa
> > > > ge.java:173)
> > > > at
> > > org.objectweb.tribe.channel.JGroupsReliableChannelWithGms.send
> > > > (JGroup
> > > > sReliableChannelWithGms.java:245)
> > > > at org.objectweb.tribe.channel.ReliableGroupChannel.send
> > > > (ReliableGroupCh
> > > > annel.java:148)
> > > > at org.objectweb.tribe.adapters.PullPushAdapter.send(
> > > > PullPushAdapter.jav
> > > > a:158)
> > > > at
> > > org.objectweb.tribe.adapters.MulticastRequestAdapterThread.run
> > > > (Multic
> > > > astRequestAdapterThread.java:97)
> > > >
> > > > Any Ideas??
> > > >
> > > > Alvaro David Borja
> > > > Solutions Architect
> > > >
> > > > *
> > > >
> > > >
> > >
> > >
> > > --
> > > Regards,
> > > Hiram
> > >
> > > Blog: http://hiramchirino.com
> > >
> >
> >
>
>
> --
>
> James
> -------
> http://radio.weblogs.com/0112098/
>
Re: Problems with activemq + c-jdbc
Posted by James Strachan <ja...@gmail.com>.
ActiveMQ tries to auto-create tables on startup but as you say you
can disable that if you wish via the createTablesOnStartup property.
On 9/29/06, David Borja <ad...@gmail.com> wrote:
> Hi Hiram ...
>
> But ActiveMQ is creating the ACTIVEMQ_MSG table each time that runs, this is
> not an ActiveMQ problem?, does`nt exist something like
> setAutoCreationTables(false)?
>
> Thanx!!
>
>
> On 9/29/06, Hiram Chirino <hi...@hiramchirino.com> wrote:
> >
> > you might want to post this to the cjdbc guys. If they tell you
> > what's causing the error, we may be able to help some more.
> >
> > On 9/28/06, David Borja <ad...@gmail.com> wrote:
> > > *2006-09-28 16:02:16,806 WARN controller.RequestManager.myDBSQLException
> > > while
> > > executing distributed write request.
> > > java.sql.SQLException: Request 0 failed:
> > > BackendThread activemq1528 failed (Table/View 'ACTIVEMQ_MSGS' already
> > exists
> > > in
> > > Schema 'ACTIVEMQ'.)
> > > BackendThread activemq1527 failed (Table/View 'ACTIVEMQ_MSGS' already
> > exists
> > > in
> > > Schema 'ACTIVEMQ'.)
> > >
> > > at
> > > org.objectweb.cjdbc.common.exceptions.SQLExceptionFactory.getSQLExcep
> > > tion(SQLExceptionFactory.java:94)
> > > at
> > > org.objectweb.cjdbc.controller.loadbalancer.raidb1.RAIDb1.execWriteRe
> > > quest(RAIDb1.java:582)
> > > at
> > > org.objectweb.cjdbc.controller.loadbalancer.raidb1.RAIDb1.execWriteRe
> > > quest(RAIDb1.java:350)
> > > at
> > > org.objectweb.cjdbc.controller.requestmanager.RequestManager.loadBala
> > > nceExecWriteRequest(RequestManager.java:689)
> > > at
> > > org.objectweb.cjdbc.controller.virtualdatabase.protocol.ExecWriteRequ
> > > est.executeScheduledRequest(ExecWriteRequest.java:79)
> > > at
> > > org.objectweb.cjdbc.controller.virtualdatabase.DistributedVirtualData
> > > base.handleMessageMultiThreaded(DistributedVirtualDatabase.java:831)
> > > at
> > org.objectweb.tribe.adapters.MulticastRequestAdapterThread.run
> > > (Multic
> > > astRequestAdapterThread.java:79)
> > > java.io.NotSerializableException: org.apache.derby.client.net.NetSqlca
> > > at java.io.ObjectOutputStream.writeObject0(Unknown Source)
> > > at java.io.ObjectOutputStream.defaultWriteFields(Unknown Source)
> > > at java.io.ObjectOutputStream.writeSerialData(Unknown Source)
> > > at java.io.ObjectOutputStream.writeOrdinaryObject(Unknown
> > Source)
> > > at java.io.ObjectOutputStream.writeObject0(Unknown Source)
> > > at java.io.ObjectOutputStream.defaultWriteFields(Unknown Source)
> > > at java.io.ObjectOutputStream.writeSerialData(Unknown Source)
> > > at java.io.ObjectOutputStream.writeOrdinaryObject(Unknown
> > Source)
> > > at java.io.ObjectOutputStream.writeObject0(Unknown Source)
> > > at java.io.ObjectOutputStream.defaultWriteFields(Unknown Source)
> > > at java.io.ObjectOutputStream.writeSerialData(Unknown Source)
> > > at java.io.ObjectOutputStream.writeOrdinaryObject(Unknown
> > Source)
> > > at java.io.ObjectOutputStream.writeObject0(Unknown Source)
> > > at java.io.ObjectOutputStream.defaultWriteFields(Unknown Source)
> > > at java.io.ObjectOutputStream.writeSerialData(Unknown Source)
> > > at java.io.ObjectOutputStream.writeOrdinaryObject(Unknown
> > Source)
> > > at java.io.ObjectOutputStream.writeObject0(Unknown Source)
> > > at java.io.ObjectOutputStream.defaultWriteFields(Unknown Source)
> > > at java.io.ObjectOutputStream.writeSerialData(Unknown Source)
> > > at java.io.ObjectOutputStream.writeOrdinaryObject(Unknown
> > Source)
> > > at java.io.ObjectOutputStream.writeObject0(Unknown Source)
> > > at java.io.ObjectOutputStream.defaultWriteFields(Unknown Source)
> > > at java.io.ObjectOutputStream.writeSerialData(Unknown Source)
> > > at java.io.ObjectOutputStream.writeOrdinaryObject(Unknown
> > Source)
> > > at java.io.ObjectOutputStream.writeObject0(Unknown Source)
> > > at java.io.ObjectOutputStream.writeObject(Unknown Source)
> > > at java.util.ArrayList.writeObject(Unknown Source)
> > > at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
> > > at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)
> > > at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown
> > Source)
> > > at java.lang.reflect.Method.invoke(Unknown Source)
> > > at java.io.ObjectStreamClass.invokeWriteObject(Unknown Source)
> > > at java.io.ObjectOutputStream.writeSerialData(Unknown Source)
> > > at java.io.ObjectOutputStream.writeOrdinaryObject(Unknown
> > Source)
> > > at java.io.ObjectOutputStream.writeObject0(Unknown Source)
> > > at java.io.ObjectOutputStream.defaultWriteFields(Unknown Source)
> > > at java.io.ObjectOutputStream.writeSerialData(Unknown Source)
> > > at java.io.ObjectOutputStream.writeOrdinaryObject(Unknown
> > Source)
> > > at java.io.ObjectOutputStream.writeObject0(Unknown Source)
> > > at java.io.ObjectOutputStream.writeObject(Unknown Source)
> > > at org.objectweb.tribe.messages.ChannelMessage.getByteArray
> > > (ChannelMessa
> > > ge.java:173)
> > > at
> > org.objectweb.tribe.channel.JGroupsReliableChannelWithGms.send
> > > (JGroup
> > > sReliableChannelWithGms.java:245)
> > > at org.objectweb.tribe.channel.ReliableGroupChannel.send
> > > (ReliableGroupCh
> > > annel.java:148)
> > > at org.objectweb.tribe.adapters.PullPushAdapter.send(
> > > PullPushAdapter.jav
> > > a:158)
> > > at
> > org.objectweb.tribe.adapters.MulticastRequestAdapterThread.run
> > > (Multic
> > > astRequestAdapterThread.java:97)
> > >
> > > Any Ideas??
> > >
> > > Alvaro David Borja
> > > Solutions Architect
> > >
> > > *
> > >
> > >
> >
> >
> > --
> > Regards,
> > Hiram
> >
> > Blog: http://hiramchirino.com
> >
>
>
--
James
-------
http://radio.weblogs.com/0112098/
Re: Problems with activemq + c-jdbc
Posted by David Borja <ad...@gmail.com>.
Hi Hiram ...
But ActiveMQ is creating the ACTIVEMQ_MSG table each time that runs, this is
not an ActiveMQ problem?, does`nt exist something like
setAutoCreationTables(false)?
Thanx!!
On 9/29/06, Hiram Chirino <hi...@hiramchirino.com> wrote:
>
> you might want to post this to the cjdbc guys. If they tell you
> what's causing the error, we may be able to help some more.
>
> On 9/28/06, David Borja <ad...@gmail.com> wrote:
> > *2006-09-28 16:02:16,806 WARN controller.RequestManager.myDBSQLException
> > while
> > executing distributed write request.
> > java.sql.SQLException: Request 0 failed:
> > BackendThread activemq1528 failed (Table/View 'ACTIVEMQ_MSGS' already
> exists
> > in
> > Schema 'ACTIVEMQ'.)
> > BackendThread activemq1527 failed (Table/View 'ACTIVEMQ_MSGS' already
> exists
> > in
> > Schema 'ACTIVEMQ'.)
> >
> > at
> > org.objectweb.cjdbc.common.exceptions.SQLExceptionFactory.getSQLExcep
> > tion(SQLExceptionFactory.java:94)
> > at
> > org.objectweb.cjdbc.controller.loadbalancer.raidb1.RAIDb1.execWriteRe
> > quest(RAIDb1.java:582)
> > at
> > org.objectweb.cjdbc.controller.loadbalancer.raidb1.RAIDb1.execWriteRe
> > quest(RAIDb1.java:350)
> > at
> > org.objectweb.cjdbc.controller.requestmanager.RequestManager.loadBala
> > nceExecWriteRequest(RequestManager.java:689)
> > at
> > org.objectweb.cjdbc.controller.virtualdatabase.protocol.ExecWriteRequ
> > est.executeScheduledRequest(ExecWriteRequest.java:79)
> > at
> > org.objectweb.cjdbc.controller.virtualdatabase.DistributedVirtualData
> > base.handleMessageMultiThreaded(DistributedVirtualDatabase.java:831)
> > at
> org.objectweb.tribe.adapters.MulticastRequestAdapterThread.run
> > (Multic
> > astRequestAdapterThread.java:79)
> > java.io.NotSerializableException: org.apache.derby.client.net.NetSqlca
> > at java.io.ObjectOutputStream.writeObject0(Unknown Source)
> > at java.io.ObjectOutputStream.defaultWriteFields(Unknown Source)
> > at java.io.ObjectOutputStream.writeSerialData(Unknown Source)
> > at java.io.ObjectOutputStream.writeOrdinaryObject(Unknown
> Source)
> > at java.io.ObjectOutputStream.writeObject0(Unknown Source)
> > at java.io.ObjectOutputStream.defaultWriteFields(Unknown Source)
> > at java.io.ObjectOutputStream.writeSerialData(Unknown Source)
> > at java.io.ObjectOutputStream.writeOrdinaryObject(Unknown
> Source)
> > at java.io.ObjectOutputStream.writeObject0(Unknown Source)
> > at java.io.ObjectOutputStream.defaultWriteFields(Unknown Source)
> > at java.io.ObjectOutputStream.writeSerialData(Unknown Source)
> > at java.io.ObjectOutputStream.writeOrdinaryObject(Unknown
> Source)
> > at java.io.ObjectOutputStream.writeObject0(Unknown Source)
> > at java.io.ObjectOutputStream.defaultWriteFields(Unknown Source)
> > at java.io.ObjectOutputStream.writeSerialData(Unknown Source)
> > at java.io.ObjectOutputStream.writeOrdinaryObject(Unknown
> Source)
> > at java.io.ObjectOutputStream.writeObject0(Unknown Source)
> > at java.io.ObjectOutputStream.defaultWriteFields(Unknown Source)
> > at java.io.ObjectOutputStream.writeSerialData(Unknown Source)
> > at java.io.ObjectOutputStream.writeOrdinaryObject(Unknown
> Source)
> > at java.io.ObjectOutputStream.writeObject0(Unknown Source)
> > at java.io.ObjectOutputStream.defaultWriteFields(Unknown Source)
> > at java.io.ObjectOutputStream.writeSerialData(Unknown Source)
> > at java.io.ObjectOutputStream.writeOrdinaryObject(Unknown
> Source)
> > at java.io.ObjectOutputStream.writeObject0(Unknown Source)
> > at java.io.ObjectOutputStream.writeObject(Unknown Source)
> > at java.util.ArrayList.writeObject(Unknown Source)
> > at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
> > at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)
> > at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown
> Source)
> > at java.lang.reflect.Method.invoke(Unknown Source)
> > at java.io.ObjectStreamClass.invokeWriteObject(Unknown Source)
> > at java.io.ObjectOutputStream.writeSerialData(Unknown Source)
> > at java.io.ObjectOutputStream.writeOrdinaryObject(Unknown
> Source)
> > at java.io.ObjectOutputStream.writeObject0(Unknown Source)
> > at java.io.ObjectOutputStream.defaultWriteFields(Unknown Source)
> > at java.io.ObjectOutputStream.writeSerialData(Unknown Source)
> > at java.io.ObjectOutputStream.writeOrdinaryObject(Unknown
> Source)
> > at java.io.ObjectOutputStream.writeObject0(Unknown Source)
> > at java.io.ObjectOutputStream.writeObject(Unknown Source)
> > at org.objectweb.tribe.messages.ChannelMessage.getByteArray
> > (ChannelMessa
> > ge.java:173)
> > at
> org.objectweb.tribe.channel.JGroupsReliableChannelWithGms.send
> > (JGroup
> > sReliableChannelWithGms.java:245)
> > at org.objectweb.tribe.channel.ReliableGroupChannel.send
> > (ReliableGroupCh
> > annel.java:148)
> > at org.objectweb.tribe.adapters.PullPushAdapter.send(
> > PullPushAdapter.jav
> > a:158)
> > at
> org.objectweb.tribe.adapters.MulticastRequestAdapterThread.run
> > (Multic
> > astRequestAdapterThread.java:97)
> >
> > Any Ideas??
> >
> > Alvaro David Borja
> > Solutions Architect
> >
> > *
> >
> >
>
>
> --
> Regards,
> Hiram
>
> Blog: http://hiramchirino.com
>
Re: Problems with activemq + c-jdbc
Posted by Hiram Chirino <hi...@hiramchirino.com>.
you might want to post this to the cjdbc guys. If they tell you
what's causing the error, we may be able to help some more.
On 9/28/06, David Borja <ad...@gmail.com> wrote:
> *2006-09-28 16:02:16,806 WARN controller.RequestManager.myDB SQLException
> while
> executing distributed write request.
> java.sql.SQLException: Request 0 failed:
> BackendThread activemq1528 failed (Table/View 'ACTIVEMQ_MSGS' already exists
> in
> Schema 'ACTIVEMQ'.)
> BackendThread activemq1527 failed (Table/View 'ACTIVEMQ_MSGS' already exists
> in
> Schema 'ACTIVEMQ'.)
>
> at
> org.objectweb.cjdbc.common.exceptions.SQLExceptionFactory.getSQLExcep
> tion(SQLExceptionFactory.java:94)
> at
> org.objectweb.cjdbc.controller.loadbalancer.raidb1.RAIDb1.execWriteRe
> quest(RAIDb1.java:582)
> at
> org.objectweb.cjdbc.controller.loadbalancer.raidb1.RAIDb1.execWriteRe
> quest(RAIDb1.java:350)
> at
> org.objectweb.cjdbc.controller.requestmanager.RequestManager.loadBala
> nceExecWriteRequest(RequestManager.java:689)
> at
> org.objectweb.cjdbc.controller.virtualdatabase.protocol.ExecWriteRequ
> est.executeScheduledRequest(ExecWriteRequest.java:79)
> at
> org.objectweb.cjdbc.controller.virtualdatabase.DistributedVirtualData
> base.handleMessageMultiThreaded(DistributedVirtualDatabase.java:831)
> at org.objectweb.tribe.adapters.MulticastRequestAdapterThread.run
> (Multic
> astRequestAdapterThread.java:79)
> java.io.NotSerializableException: org.apache.derby.client.net.NetSqlca
> at java.io.ObjectOutputStream.writeObject0(Unknown Source)
> at java.io.ObjectOutputStream.defaultWriteFields(Unknown Source)
> at java.io.ObjectOutputStream.writeSerialData(Unknown Source)
> at java.io.ObjectOutputStream.writeOrdinaryObject(Unknown Source)
> at java.io.ObjectOutputStream.writeObject0(Unknown Source)
> at java.io.ObjectOutputStream.defaultWriteFields(Unknown Source)
> at java.io.ObjectOutputStream.writeSerialData(Unknown Source)
> at java.io.ObjectOutputStream.writeOrdinaryObject(Unknown Source)
> at java.io.ObjectOutputStream.writeObject0(Unknown Source)
> at java.io.ObjectOutputStream.defaultWriteFields(Unknown Source)
> at java.io.ObjectOutputStream.writeSerialData(Unknown Source)
> at java.io.ObjectOutputStream.writeOrdinaryObject(Unknown Source)
> at java.io.ObjectOutputStream.writeObject0(Unknown Source)
> at java.io.ObjectOutputStream.defaultWriteFields(Unknown Source)
> at java.io.ObjectOutputStream.writeSerialData(Unknown Source)
> at java.io.ObjectOutputStream.writeOrdinaryObject(Unknown Source)
> at java.io.ObjectOutputStream.writeObject0(Unknown Source)
> at java.io.ObjectOutputStream.defaultWriteFields(Unknown Source)
> at java.io.ObjectOutputStream.writeSerialData(Unknown Source)
> at java.io.ObjectOutputStream.writeOrdinaryObject(Unknown Source)
> at java.io.ObjectOutputStream.writeObject0(Unknown Source)
> at java.io.ObjectOutputStream.defaultWriteFields(Unknown Source)
> at java.io.ObjectOutputStream.writeSerialData(Unknown Source)
> at java.io.ObjectOutputStream.writeOrdinaryObject(Unknown Source)
> at java.io.ObjectOutputStream.writeObject0(Unknown Source)
> at java.io.ObjectOutputStream.writeObject(Unknown Source)
> at java.util.ArrayList.writeObject(Unknown Source)
> at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
> at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)
> at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
> at java.lang.reflect.Method.invoke(Unknown Source)
> at java.io.ObjectStreamClass.invokeWriteObject(Unknown Source)
> at java.io.ObjectOutputStream.writeSerialData(Unknown Source)
> at java.io.ObjectOutputStream.writeOrdinaryObject(Unknown Source)
> at java.io.ObjectOutputStream.writeObject0(Unknown Source)
> at java.io.ObjectOutputStream.defaultWriteFields(Unknown Source)
> at java.io.ObjectOutputStream.writeSerialData(Unknown Source)
> at java.io.ObjectOutputStream.writeOrdinaryObject(Unknown Source)
> at java.io.ObjectOutputStream.writeObject0(Unknown Source)
> at java.io.ObjectOutputStream.writeObject(Unknown Source)
> at org.objectweb.tribe.messages.ChannelMessage.getByteArray
> (ChannelMessa
> ge.java:173)
> at org.objectweb.tribe.channel.JGroupsReliableChannelWithGms.send
> (JGroup
> sReliableChannelWithGms.java:245)
> at org.objectweb.tribe.channel.ReliableGroupChannel.send
> (ReliableGroupCh
> annel.java:148)
> at org.objectweb.tribe.adapters.PullPushAdapter.send(
> PullPushAdapter.jav
> a:158)
> at org.objectweb.tribe.adapters.MulticastRequestAdapterThread.run
> (Multic
> astRequestAdapterThread.java:97)
>
> Any Ideas??
>
> Alvaro David Borja
> Solutions Architect
>
> *
>
>
--
Regards,
Hiram
Blog: http://hiramchirino.com