Menu
▾
▴
openjms-user
|
From: <lly...@co...> - 2014-03-23 03:15:26
|
I am using derby standalone server 10.9.1.0 along with jms 0.7.7 beta.
When I start the JMS server I get the following exception. I have also included the corresponding Derby error log output.
Has anyone seen this or know of a fix or work-around?
Here's the Derby log segment, notice the offending insert statement in to the destinations table:
Thu Mar 20 08:15:24 EDT 2014 Thread[DRDAConnThread_3,5,main] (XID = 412), (SESSIONID = 10), (DATABASE = openjmsdb), (DRDAID = ????????.???-939562076942445192{9}), Failed Statement is: insert into destinations (name, isqueue, destinationid) values (?, ?, ?) with 3 parameters begin parameter #1: gndcon_q :end parameter begin parameter #2: true :end parameter begin parameter #3: 1 :end parameter
ERROR 22001: A truncation error was encountered trying to shrink CHAR 'true' to length 1.
at org.apache.derby.iapi.error.StandardException.newException(Unknown Source)
at org.apache.derby.iapi.types.SQLChar.hasNonBlankChars(Unknown Source)
at org.apache.derby.iapi.types.SQLChar.normalize(Unknown Source)
at org.apache.derby.iapi.types.SQLChar.normalize(Unknown Source)
at org.apache.derby.iapi.types.DataTypeDescriptor.normalize(Unknown Source)
at org.apache.derby.impl.sql.execute.NormalizeResultSet.normalizeColumn(Unknown Source)
at org.apache.derby.impl.sql.execute.NormalizeResultSet.normalizeRow(Unknown Source)
at org.apache.derby.impl.sql.execute.NormalizeResultSet.getNextRowCore(Unknown Source)
at org.apache.derby.impl.sql.execute.DMLWriteResultSet.getNextRowCore(Unknown Source)
at org.apache.derby.impl.sql.execute.InsertResultSet.open(Unknown Source)
at org.apache.derby.impl.sql.GenericPreparedStatement.executeStmt(Unknown Source)
at org.apache.derby.impl.sql.GenericPreparedStatement.execute(Unknown Source)
at org.apache.derby.impl.jdbc.EmbedStatement.executeStatement(Unknown Source)
at org.apache.derby.impl.jdbc.EmbedPreparedStatement.executeStatement(Unknown Source)
at org.apache.derby.impl.jdbc.EmbedPreparedStatement.execute(Unknown Source)
at org.apache.derby.impl.drda.DRDAStatement.execute(Unknown Source)
at org.apache.derby.impl.drda.DRDAConnThread.parseEXCSQLSTTobjects(Unknown Source)
at org.apache.derby.impl.drda.DRDAConnThread.parseEXCSQLSTT(Unknown Source)
at org.apache.derby.impl.drda.DRDAConnThread.processCommands(Unknown Source)
at org.apache.derby.impl.drda.DRDAConnThread.run(Unknown Source)
It appears that parameter 2 was meant to be a boolean value.
Here's the exception from JMS:
OpenJMS 0.7.7-beta-1
The OpenJMS Group. (C) 1999-2007. All rights reserved.
http://openjms.sourceforge.net
23:13:21.720 ERROR [main] - Failed to create persistent destination topic1
org.exolab.jms.persistence.PersistenceException: Destinations.add failed with ja
va.sql.SQLDataException: A truncation error was encountered trying to shrink CHA
R 'false' to length 1.
at org.exolab.jms.persistence.Destinations.add(Destinations.java:134)
at org.exolab.jms.persistence.RDBMSAdapter.addDestination(RDBMSAdapter.j
ava:583)
at org.exolab.jms.messagemgr.DestinationManagerImpl.createPersistentDest
ination(DestinationManagerImpl.java:620)
at org.exolab.jms.messagemgr.DestinationManagerImpl.createDestination(De
stinationManagerImpl.java:278)
at org.exolab.jms.messagemgr.DestinationConfigurator.configureTopics(Des
tinationConfigurator.java:149)
at org.exolab.jms.messagemgr.DestinationConfigurator.doStart(Destination
Configurator.java:129)
at org.exolab.jms.service.Service.start(Service.java:97)
at org.exolab.jms.service.ServiceManager.doStart(ServiceManager.java:176
)
at org.exolab.jms.service.Service.start(Service.java:97)
at org.exolab.jms.server.JmsServer.init(JmsServer.java:146)
at org.exolab.jms.server.JmsServer.main(JmsServer.java:178)
23:13:21.726 ERROR [main] - Failed to register persistent topic topic1
javax.jms.JMSException: Failed to create persistent destination topic1: Destinat
ions.add failed with java.sql.SQLDataException: A truncation error was encounter
ed trying to shrink CHAR 'false' to length 1.
at org.exolab.jms.messagemgr.DestinationManagerImpl.cleanup(DestinationM
anagerImpl.java:784)
at org.exolab.jms.messagemgr.DestinationManagerImpl.createPersistentDest
ination(DestinationManagerImpl.java:623)
at org.exolab.jms.messagemgr.DestinationManagerImpl.createDestination(De
stinationManagerImpl.java:278)
at org.exolab.jms.messagemgr.DestinationConfigurator.configureTopics(Des
tinationConfigurator.java:149)
at org.exolab.jms.messagemgr.DestinationConfigurator.doStart(Destination
Configurator.java:129)
at org.exolab.jms.service.Service.start(Service.java:97)
at org.exolab.jms.service.ServiceManager.doStart(ServiceManager.java:176
)
at org.exolab.jms.service.Service.start(Service.java:97)
at org.exolab.jms.server.JmsServer.init(JmsServer.java:146)
at org.exolab.jms.server.JmsServer.main(JmsServer.java:178)
23:13:21.740 ERROR [main] - Failed to create persistent destination queue1
org.exolab.jms.persistence.PersistenceException: Destinations.add failed with ja
va.sql.SQLDataException: A truncation error was encountered trying to shrink CHA
R 'true' to length 1.
at org.exolab.jms.persistence.Destinations.add(Destinations.java:134)
at org.exolab.jms.persistence.RDBMSAdapter.addDestination(RDBMSAdapter.j
ava:583)
at org.exolab.jms.messagemgr.DestinationManagerImpl.createPersistentDest
ination(DestinationManagerImpl.java:620)
at org.exolab.jms.messagemgr.DestinationManagerImpl.createDestination(De
stinationManagerImpl.java:278)
at org.exolab.jms.messagemgr.DestinationConfigurator.configureQueues(Des
tinationConfigurator.java:180)
at org.exolab.jms.messagemgr.DestinationConfigurator.doStart(Destination
Configurator.java:130)
at org.exolab.jms.service.Service.start(Service.java:97)
at org.exolab.jms.service.ServiceManager.doStart(ServiceManager.java:176
)
at org.exolab.jms.service.Service.start(Service.java:97)
at org.exolab.jms.server.JmsServer.init(JmsServer.java:146)
at org.exolab.jms.server.JmsServer.main(JmsServer.java:178)
23:13:21.751 ERROR [main] - Failed to register persistent queue queue1
javax.jms.JMSException: Failed to create persistent destination queue1: Destinat
ions.add failed with java.sql.SQLDataException: A truncation error was encounter
ed trying to shrink CHAR 'true' to length 1.
at org.exolab.jms.messagemgr.DestinationManagerImpl.cleanup(DestinationM
anagerImpl.java:784)
at org.exolab.jms.messagemgr.DestinationManagerImpl.createPersistentDest
ination(DestinationManagerImpl.java:623)
at org.exolab.jms.messagemgr.DestinationManagerImpl.createDestination(De
stinationManagerImpl.java:278)
at org.exolab.jms.messagemgr.DestinationConfigurator.configureQueues(Des
tinationConfigurator.java:180)
at org.exolab.jms.messagemgr.DestinationConfigurator.doStart(Destination
Configurator.java:130)
at org.exolab.jms.service.Service.start(Service.java:97)
at org.exolab.jms.service.ServiceManager.doStart(ServiceManager.java:176
)
at org.exolab.jms.service.Service.start(Service.java:97)
at org.exolab.jms.server.JmsServer.init(JmsServer.java:146)
at org.exolab.jms.server.JmsServer.main(JmsServer.java:178)
23:13:21.772 ERROR [main] - Failed to create persistent destination queue2
org.exolab.jms.persistence.PersistenceException: Destinations.add failed with ja
va.sql.SQLDataException: A truncation error was encountered trying to shrink CHA
R 'true' to length 1.
at org.exolab.jms.persistence.Destinations.add(Destinations.java:134)
at org.exolab.jms.persistence.RDBMSAdapter.addDestination(RDBMSAdapter.j
ava:583)
at org.exolab.jms.messagemgr.DestinationManagerImpl.createPersistentDest
ination(DestinationManagerImpl.java:620)
at org.exolab.jms.messagemgr.DestinationManagerImpl.createDestination(De
stinationManagerImpl.java:278)
at org.exolab.jms.messagemgr.DestinationConfigurator.configureQueues(Des
tinationConfigurator.java:180)
at org.exolab.jms.messagemgr.DestinationConfigurator.doStart(Destination
Configurator.java:130)
at org.exolab.jms.service.Service.start(Service.java:97)
at org.exolab.jms.service.ServiceManager.doStart(ServiceManager.java:176
)
at org.exolab.jms.service.Service.start(Service.java:97)
at org.exolab.jms.server.JmsServer.init(JmsServer.java:146)
at org.exolab.jms.server.JmsServer.main(JmsServer.java:178)
23:13:21.782 ERROR [main] - Failed to register persistent queue queue2
javax.jms.JMSException: Failed to create persistent destination queue2: Destinat
ions.add failed with java.sql.SQLDataException: A truncation error was encounter
ed trying to shrink CHAR 'true' to length 1.
at org.exolab.jms.messagemgr.DestinationManagerImpl.cleanup(DestinationM
anagerImpl.java:784)
at org.exolab.jms.messagemgr.DestinationManagerImpl.createPersistentDest
ination(DestinationManagerImpl.java:623)
at org.exolab.jms.messagemgr.DestinationManagerImpl.createDestination(De
stinationManagerImpl.java:278)
at org.exolab.jms.messagemgr.DestinationConfigurator.configureQueues(Des
tinationConfigurator.java:180)
at org.exolab.jms.messagemgr.DestinationConfigurator.doStart(Destination
Configurator.java:130)
at org.exolab.jms.service.Service.start(Service.java:97)
at org.exolab.jms.service.ServiceManager.doStart(ServiceManager.java:176
)
at org.exolab.jms.service.Service.start(Service.java:97)
at org.exolab.jms.server.JmsServer.init(JmsServer.java:146)
at org.exolab.jms.server.JmsServer.main(JmsServer.java:178)
23:13:21.792 ERROR [main] - Failed to create persistent destination queue3
org.exolab.jms.persistence.PersistenceException: Destinations.add failed with ja
va.sql.SQLDataException: A truncation error was encountered trying to shrink CHA
R 'true' to length 1.
at org.exolab.jms.persistence.Destinations.add(Destinations.java:134)
at org.exolab.jms.persistence.RDBMSAdapter.addDestination(RDBMSAdapter.j
ava:583)
at org.exolab.jms.messagemgr.DestinationManagerImpl.createPersistentDest
ination(DestinationManagerImpl.java:620)
at org.exolab.jms.messagemgr.DestinationManagerImpl.createDestination(De
stinationManagerImpl.java:278)
at org.exolab.jms.messagemgr.DestinationConfigurator.configureQueues(Des
tinationConfigurator.java:180)
at org.exolab.jms.messagemgr.DestinationConfigurator.doStart(Destination
Configurator.java:130)
at org.exolab.jms.service.Service.start(Service.java:97)
at org.exolab.jms.service.ServiceManager.doStart(ServiceManager.java:176
)
at org.exolab.jms.service.Service.start(Service.java:97)
at org.exolab.jms.server.JmsServer.init(JmsServer.java:146)
at org.exolab.jms.server.JmsServer.main(JmsServer.java:178)
23:13:21.802 ERROR [main] - Failed to register persistent queue queue3
javax.jms.JMSException: Failed to create persistent destination queue3: Destinat
ions.add failed with java.sql.SQLDataException: A truncation error was encounter
ed trying to shrink CHAR 'true' to length 1.
at org.exolab.jms.messagemgr.DestinationManagerImpl.cleanup(DestinationM
anagerImpl.java:784)
at org.exolab.jms.messagemgr.DestinationManagerImpl.createPersistentDest
ination(DestinationManagerImpl.java:623)
at org.exolab.jms.messagemgr.DestinationManagerImpl.createDestination(De
stinationManagerImpl.java:278)
at org.exolab.jms.messagemgr.DestinationConfigurator.configureQueues(Des
tinationConfigurator.java:180)
at org.exolab.jms.messagemgr.DestinationConfigurator.doStart(Destination
Configurator.java:130)
at org.exolab.jms.service.Service.start(Service.java:97)
at org.exolab.jms.service.ServiceManager.doStart(ServiceManager.java:176
)
at org.exolab.jms.service.Service.start(Service.java:97)
at org.exolab.jms.server.JmsServer.init(JmsServer.java:146)
at org.exolab.jms.server.JmsServer.main(JmsServer.java:178)
23:13:21.813 ERROR [main] - Failed to create persistent destination refinery_q
org.exolab.jms.persistence.PersistenceException: Destinations.add failed with ja
va.sql.SQLDataException: A truncation error was encountered trying to shrink CHA
R 'true' to length 1.
at org.exolab.jms.persistence.Destinations.add(Destinations.java:134)
at org.exolab.jms.persistence.RDBMSAdapter.addDestination(RDBMSAdapter.j
ava:583)
at org.exolab.jms.messagemgr.DestinationManagerImpl.createPersistentDest
ination(DestinationManagerImpl.java:620)
at org.exolab.jms.messagemgr.DestinationManagerImpl.createDestination(De
stinationManagerImpl.java:278)
at org.exolab.jms.messagemgr.DestinationConfigurator.configureQueues(Des
tinationConfigurator.java:180)
at org.exolab.jms.messagemgr.DestinationConfigurator.doStart(Destination
Configurator.java:130)
at org.exolab.jms.service.Service.start(Service.java:97)
at org.exolab.jms.service.ServiceManager.doStart(ServiceManager.java:176
)
at org.exolab.jms.service.Service.start(Service.java:97)
at org.exolab.jms.server.JmsServer.init(JmsServer.java:146)
at org.exolab.jms.server.JmsServer.main(JmsServer.java:178)
23:13:21.831 ERROR [main] - Failed to register persistent queue refinery_q
javax.jms.JMSException: Failed to create persistent destination refinery_q: Dest
inations.add failed with java.sql.SQLDataException: A truncation error was encou
ntered trying to shrink CHAR 'true' to length 1.
at org.exolab.jms.messagemgr.DestinationManagerImpl.cleanup(DestinationM
anagerImpl.java:784)
at org.exolab.jms.messagemgr.DestinationManagerImpl.createPersistentDest
ination(DestinationManagerImpl.java:623)
at org.exolab.jms.messagemgr.DestinationManagerImpl.createDestination(De
stinationManagerImpl.java:278)
at org.exolab.jms.messagemgr.DestinationConfigurator.configureQueues(Des
tinationConfigurator.java:180)
at org.exolab.jms.messagemgr.DestinationConfigurator.doStart(Destination
Configurator.java:130)
at org.exolab.jms.service.Service.start(Service.java:97)
at org.exolab.jms.service.ServiceManager.doStart(ServiceManager.java:176
)
at org.exolab.jms.service.Service.start(Service.java:97)
at org.exolab.jms.server.JmsServer.init(JmsServer.java:146)
at org.exolab.jms.server.JmsServer.main(JmsServer.java:178)
23:13:21.841 ERROR [main] - Failed to create persistent destination gndcon_q
org.exolab.jms.persistence.PersistenceException: Destinations.add failed with ja
va.sql.SQLDataException: A truncation error was encountered trying to shrink CHA
R 'true' to length 1.
at org.exolab.jms.persistence.Destinations.add(Destinations.java:134)
at org.exolab.jms.persistence.RDBMSAdapter.addDestination(RDBMSAdapter.j
ava:583)
at org.exolab.jms.messagemgr.DestinationManagerImpl.createPersistentDest
ination(DestinationManagerImpl.java:620)
at org.exolab.jms.messagemgr.DestinationManagerImpl.createDestination(De
stinationManagerImpl.java:278)
at org.exolab.jms.messagemgr.DestinationConfigurator.configureQueues(Des
tinationConfigurator.java:180)
at org.exolab.jms.messagemgr.DestinationConfigurator.doStart(Destination
Configurator.java:130)
at org.exolab.jms.service.Service.start(Service.java:97)
at org.exolab.jms.service.ServiceManager.doStart(ServiceManager.java:176
)
at org.exolab.jms.service.Service.start(Service.java:97)
at org.exolab.jms.server.JmsServer.init(JmsServer.java:146)
at org.exolab.jms.server.JmsServer.main(JmsServer.java:178)
23:13:21.852 ERROR [main] - Failed to register persistent queue gndcon_q
javax.jms.JMSException: Failed to create persistent destination gndcon_q: Destin
ations.add failed with java.sql.SQLDataException: A truncation error was encount
ered trying to shrink CHAR 'true' to length 1.
at org.exolab.jms.messagemgr.DestinationManagerImpl.cleanup(DestinationM
anagerImpl.java:784)
at org.exolab.jms.messagemgr.DestinationManagerImpl.createPersistentDest
ination(DestinationManagerImpl.java:623)
at org.exolab.jms.messagemgr.DestinationManagerImpl.createDestination(De
stinationManagerImpl.java:278)
at org.exolab.jms.messagemgr.DestinationConfigurator.configureQueues(Des
tinationConfigurator.java:180)
at org.exolab.jms.messagemgr.DestinationConfigurator.doStart(Destination
Configurator.java:130)
at org.exolab.jms.service.Service.start(Service.java:97)
at org.exolab.jms.service.ServiceManager.doStart(ServiceManager.java:176
)
at org.exolab.jms.service.Service.start(Service.java:97)
at org.exolab.jms.server.JmsServer.init(JmsServer.java:146)
at org.exolab.jms.server.JmsServer.main(JmsServer.java:178)
23:13:21.953 INFO [main] - Server accepting connections on tcp://192.168.1.20:3
035/
23:13:21.957 INFO [main] - JNDI service accepting connections on tcp://192.168.
1.20:3035/
23:13:21.960 INFO [main] - Admin service accepting connections on tcp://192.168
.1.20:3035/
23:13:22.032 INFO [main] - Server accepting connections on rmi://192.168.1.20:1
099/
23:13:22.034 INFO [main] - JNDI service accepting connections on rmi://192.168.
1.20:1099/
23:13:22.035 INFO [main] - Admin service accepting connections on rmi://192.168
.1.20:1099/
|
×
Want the latest updates on software, tech news, and AI?
Get latest updates about software, tech news, and AI from SourceForge directly in your inbox once a month.
Thanks for helping keep SourceForge clean.
X