Petals ESB Container

Persistence service does not support Oracle database

Details

  • Type: Bug Bug
  • Status: Resolved Resolved
  • Priority: Blocker Blocker
  • Resolution: Won't Fix
  • Affects Version/s: 3.1.1
  • Fix Version/s: 5.0.1
  • Component/s: Persistence
  • Security Level: Public
  • Description:
    Hide

    Using a database Oracle 10g Express, and after to have enable the message exchange monitoring, we get the following when storing message exchange into the database:

    [Petals.JBI-Messaging.RouterMonitorServiceImpl]-WARNING 2011-03-30 17:57:54,104 Failed to store a monitored exchange with Id 'petals:uid:E6DF7B9BC4C254A9A01014019754554531'
java.sql.SQLException: Type de colonne non valide
	at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:113)
	at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:147)
	at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:209)
	at oracle.jdbc.driver.OraclePreparedStatement.setObjectCritical(OraclePreparedStatement.java:9308)
	at oracle.jdbc.driver.OraclePreparedStatement.setObjectInternal(OraclePreparedStatement.java:8889)
	at oracle.jdbc.driver.OraclePreparedStatement.setObjectInternal(OraclePreparedStatement.java:9611)
	at oracle.jdbc.driver.OraclePreparedStatement.setObject(OraclePreparedStatement.java:9594)
	at org.apache.commons.dbcp.DelegatingPreparedStatement.setObject(DelegatingPreparedStatement.java:166)
	at org.ow2.petals.system.persistence.PersistenceServiceImpl.addMessageExchange(PersistenceServiceImpl.java:201)
	at org.objectweb.fractal.julia.generated.Cb55bcf26_0.addMessageExchange(INTERCEPTOR[PersistenceService])
	at org.objectweb.fractal.julia.generated.C61607011_0.addMessageExchange(INTERFACE[PersistenceService])
	at org.ow2.petals.jbi.messaging.routing.monitoring.RouterMonitorServiceImpl.exchangeSent(RouterMonitorServiceImpl.java:274)
	at org.objectweb.fractal.julia.generated.C1ccebc2d_0.exchangeSent(INTERCEPTOR[RouterMonitorService])
	at org.objectweb.fractal.julia.generated.C5c1ad5f8_0.exchangeSent(INTERFACE[RouterMonitorService])
	at org.ow2.petals.jbi.messaging.routing.RouterServiceImpl.exchangeSent(RouterServiceImpl.java:221)
	at org.objectweb.fractal.julia.generated.C3fb61c7a_0.exchangeSent(INTERCEPTOR[TransportListener])
	at org.objectweb.fractal.julia.generated.Cb6e287e5_0.exchangeSent(INTERFACE[TransportListener])
	at org.ow2.petals.transport.local.LocalTransporterImpl.sendSync(LocalTransporterImpl.java:164)
	at org.objectweb.fractal.julia.generated.C94e500a3_0.sendSync(INTERCEPTOR[Transporter])
	at org.objectweb.fractal.julia.generated.C52af992e_0.sendSync(INTERFACE[Transporter])
	at org.ow2.petals.jbi.messaging.routing.RouterServiceImpl.sendToProvider(RouterServiceImpl.java:769)
	at org.ow2.petals.jbi.messaging.routing.RouterServiceImpl.sendSync(RouterServiceImpl.java:485)
	at org.objectweb.fractal.julia.generated.Ca28c702f_0.sendSync(INTERCEPTOR[RouterService])
	at org.objectweb.fractal.julia.generated.C5a01da3a_0.sendSync(INTERFACE[RouterService])
	at org.ow2.petals.jbi.messaging.exchange.DeliveryChannelImpl.sendExchange(DeliveryChannelImpl.java:466)
	at org.ow2.petals.jbi.messaging.exchange.DeliveryChannelImpl.sendSync(DeliveryChannelImpl.java:272)
	at org.ow2.petals.jbi.messaging.exchange.DeliveryChannelImpl.sendSync(DeliveryChannelImpl.java:254)
	at org.ow2.petals.binding.soap.listener.incoming.SOAPProcessor.process(SOAPProcessor.java:175)
	at org.ow2.petals.binding.soap.listener.incoming.PetalsReceiver.process(PetalsReceiver.java:173)
	at org.ow2.petals.binding.soap.listener.incoming.PetalsReceiver.invokeBusinessLogic(PetalsReceiver.java:123)
	at org.apache.axis2.receivers.AbstractMessageReceiver.receive(AbstractMessageReceiver.java:100)
	at org.apache.axis2.engine.AxisEngine.receive(AxisEngine.java:176)
	at org.apache.axis2.transport.http.HTTPTransportUtils.processHTTPPostRequest(HTTPTransportUtils.java:275)
	at org.apache.axis2.transport.http.AxisServlet.doPost(AxisServlet.java:133)
	at org.ow2.petals.binding.soap.listener.incoming.servlet.SoapServlet.doPost(SoapServlet.java:122)
	at javax.servlet.http.HttpServlet.service(HttpServlet.java:760)
	at javax.servlet.http.HttpServlet.service(HttpServlet.java:853)
	at org.mortbay.jetty.servlet.ServletHolder.handle(ServletHolder.java:487)
	at org.mortbay.jetty.servlet.ServletHandler.handle(ServletHandler.java:362)
	at org.mortbay.jetty.servlet.SessionHandler.handle(SessionHandler.java:181)
	at org.mortbay.jetty.handler.ContextHandler.handle(ContextHandler.java:726)
	at org.mortbay.jetty.handler.HandlerCollection.handle(HandlerCollection.java:114)
	at org.mortbay.jetty.handler.HandlerWrapper.handle(HandlerWrapper.java:152)
	at org.mortbay.jetty.Server.handle(Server.java:324)
	at org.mortbay.jetty.HttpConnection.handleRequest(HttpConnection.java:505)
	at org.mortbay.jetty.HttpConnection$RequestHandler.content(HttpConnection.java:842)
	at org.mortbay.jetty.HttpParser.parseNext(HttpParser.java:648)
	at org.mortbay.jetty.HttpParser.parseAvailable(HttpParser.java:211)
	at org.mortbay.jetty.HttpConnection.handle(HttpConnection.java:380)
	at org.mortbay.io.nio.SelectChannelEndPoint.run(SelectChannelEndPoint.java:395)
	at org.mortbay.thread.BoundedThreadPool$PoolThread.run(BoundedThreadPool.java:450)
    Show
    Using a database Oracle 10g Express, and after to have enable the message exchange monitoring, we get the following when storing message exchange into the database: 
    [Petals.JBI-Messaging.RouterMonitorServiceImpl]-WARNING 2011-03-30 17:57:54,104 Failed to store a monitored exchange with Id 'petals:uid:E6DF7B9BC4C254A9A01014019754554531'
java.sql.SQLException: Type de colonne non valide
	at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:113)
	at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:147)
	at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:209)
	at oracle.jdbc.driver.OraclePreparedStatement.setObjectCritical(OraclePreparedStatement.java:9308)
	at oracle.jdbc.driver.OraclePreparedStatement.setObjectInternal(OraclePreparedStatement.java:8889)
	at oracle.jdbc.driver.OraclePreparedStatement.setObjectInternal(OraclePreparedStatement.java:9611)
	at oracle.jdbc.driver.OraclePreparedStatement.setObject(OraclePreparedStatement.java:9594)
	at org.apache.commons.dbcp.DelegatingPreparedStatement.setObject(DelegatingPreparedStatement.java:166)
	at org.ow2.petals.system.persistence.PersistenceServiceImpl.addMessageExchange(PersistenceServiceImpl.java:201)
	at org.objectweb.fractal.julia.generated.Cb55bcf26_0.addMessageExchange(INTERCEPTOR[PersistenceService])
	at org.objectweb.fractal.julia.generated.C61607011_0.addMessageExchange(INTERFACE[PersistenceService])
	at org.ow2.petals.jbi.messaging.routing.monitoring.RouterMonitorServiceImpl.exchangeSent(RouterMonitorServiceImpl.java:274)
	at org.objectweb.fractal.julia.generated.C1ccebc2d_0.exchangeSent(INTERCEPTOR[RouterMonitorService])
	at org.objectweb.fractal.julia.generated.C5c1ad5f8_0.exchangeSent(INTERFACE[RouterMonitorService])
	at org.ow2.petals.jbi.messaging.routing.RouterServiceImpl.exchangeSent(RouterServiceImpl.java:221)
	at org.objectweb.fractal.julia.generated.C3fb61c7a_0.exchangeSent(INTERCEPTOR[TransportListener])
	at org.objectweb.fractal.julia.generated.Cb6e287e5_0.exchangeSent(INTERFACE[TransportListener])
	at org.ow2.petals.transport.local.LocalTransporterImpl.sendSync(LocalTransporterImpl.java:164)
	at org.objectweb.fractal.julia.generated.C94e500a3_0.sendSync(INTERCEPTOR[Transporter])
	at org.objectweb.fractal.julia.generated.C52af992e_0.sendSync(INTERFACE[Transporter])
	at org.ow2.petals.jbi.messaging.routing.RouterServiceImpl.sendToProvider(RouterServiceImpl.java:769)
	at org.ow2.petals.jbi.messaging.routing.RouterServiceImpl.sendSync(RouterServiceImpl.java:485)
	at org.objectweb.fractal.julia.generated.Ca28c702f_0.sendSync(INTERCEPTOR[RouterService])
	at org.objectweb.fractal.julia.generated.C5a01da3a_0.sendSync(INTERFACE[RouterService])
	at org.ow2.petals.jbi.messaging.exchange.DeliveryChannelImpl.sendExchange(DeliveryChannelImpl.java:466)
	at org.ow2.petals.jbi.messaging.exchange.DeliveryChannelImpl.sendSync(DeliveryChannelImpl.java:272)
	at org.ow2.petals.jbi.messaging.exchange.DeliveryChannelImpl.sendSync(DeliveryChannelImpl.java:254)
	at org.ow2.petals.binding.soap.listener.incoming.SOAPProcessor.process(SOAPProcessor.java:175)
	at org.ow2.petals.binding.soap.listener.incoming.PetalsReceiver.process(PetalsReceiver.java:173)
	at org.ow2.petals.binding.soap.listener.incoming.PetalsReceiver.invokeBusinessLogic(PetalsReceiver.java:123)
	at org.apache.axis2.receivers.AbstractMessageReceiver.receive(AbstractMessageReceiver.java:100)
	at org.apache.axis2.engine.AxisEngine.receive(AxisEngine.java:176)
	at org.apache.axis2.transport.http.HTTPTransportUtils.processHTTPPostRequest(HTTPTransportUtils.java:275)
	at org.apache.axis2.transport.http.AxisServlet.doPost(AxisServlet.java:133)
	at org.ow2.petals.binding.soap.listener.incoming.servlet.SoapServlet.doPost(SoapServlet.java:122)
	at javax.servlet.http.HttpServlet.service(HttpServlet.java:760)
	at javax.servlet.http.HttpServlet.service(HttpServlet.java:853)
	at org.mortbay.jetty.servlet.ServletHolder.handle(ServletHolder.java:487)
	at org.mortbay.jetty.servlet.ServletHandler.handle(ServletHandler.java:362)
	at org.mortbay.jetty.servlet.SessionHandler.handle(SessionHandler.java:181)
	at org.mortbay.jetty.handler.ContextHandler.handle(ContextHandler.java:726)
	at org.mortbay.jetty.handler.HandlerCollection.handle(HandlerCollection.java:114)
	at org.mortbay.jetty.handler.HandlerWrapper.handle(HandlerWrapper.java:152)
	at org.mortbay.jetty.Server.handle(Server.java:324)
	at org.mortbay.jetty.HttpConnection.handleRequest(HttpConnection.java:505)
	at org.mortbay.jetty.HttpConnection$RequestHandler.content(HttpConnection.java:842)
	at org.mortbay.jetty.HttpParser.parseNext(HttpParser.java:648)
	at org.mortbay.jetty.HttpParser.parseAvailable(HttpParser.java:211)
	at org.mortbay.jetty.HttpConnection.handle(HttpConnection.java:380)
	at org.mortbay.io.nio.SelectChannelEndPoint.run(SelectChannelEndPoint.java:395)
	at org.mortbay.thread.BoundedThreadPool$PoolThread.run(BoundedThreadPool.java:450)
  • Environment:
    -

Activity

Ascending order - Click to sort in descending order
Hide
Permalink
Victor NOËL added a comment - Mon, 29 Feb 2016 - 11:00:07 +0100

Persistence service is being removed: PETALSESBCONT-402

Show
Victor NOËL added a comment - Mon, 29 Feb 2016 - 11:00:07 +0100 Persistence service is being removed: PETALSESBCONT-402
Victor NOËL made changes - Mon, 29 Feb 2016 - 11:00:07 +0100
Field Original Value New Value
Resolution Won't Fix [ 2 ]
Status New [ 10000 ] Resolved [ 10004 ]
Assignee Admin [ rnaudin ] Victor NOËL [ vnoel ]
Christophe DENEUX made changes - Mon, 29 Feb 2016 - 13:07:04 +0100
Fix Version/s 5.0.1 [ 10579 ]
Priority Blocker [ 1 ]
Transition Status Change Time Execution Times Last Executer Last Execution Date
New New Resolved Resolved
1796d 17h 58m
1
Victor NOËL
Mon, 29 Feb 2016 - 11:00:07 +0100



People

Dates

  • Created:
    Wed, 30 Mar 2011 - 18:01:55 +0200
    Updated:
    Mon, 29 Feb 2016 - 13:07:04 +0100
    Resolved:
    Mon, 29 Feb 2016 - 11:00:07 +0100
Atlassian JIRA (v4.1.2#531) | Report a problem | Request a feature | Contact administrators
Powered by a free Atlassian JIRA open source license for Petals ESB. Try JIRA - bug tracking software for your team.