[resolved] [Talend 6.0.1] tOracleConnection error

One Star

[resolved] [Talend 6.0.1] tOracleConnection error

Hello,
I'm testing my route using Talend ESB 6.0.1 on a new server.
It doesn't work because the component tOracleConnection is unable to connect to our database while I installed the ojdbc14.jar into my runtime. 
See the errors below I received on TAC.
Could you see how can I resolve this issue and which bundle I need to deploy in order to connect to our Oracle database 11g ?
Thanks in advance



Accepted Solutions
One Star

Re: [resolved] [Talend 6.0.1] tOracleConnection error

Hi ,
The solution is to add a PreJob ->tLibraryLoad ->OnComponentOk / OnSubjobOk -> tOracleConnection -> ..
Thanks all for your help

All Replies
Employee

Re: [resolved] [Talend 6.0.1] tOracleConnection error

Hi,
It depends how you used tOracleConnection component, if you don't check "Specify a data source alias" option, then you don't need to install the ojdbc driver into the Runtime container. if you checked this option, then:
1) install ojdbc driver into Runtime (Note: please using wrap: because ojdbc jar is not an OSGi bundle.  bundle:install wrap:fileSmiley Very Happy:/ojdbc4.jar)
2) install datasource xml for oracle into Runtime
(also please provide the full log from Runtime container/logs/tesb.log)
HTH
One Star

Re: [resolved] [Talend 6.0.1] tOracleConnection error

Hello and thank you for your answer.
"Specify a data source alias" option is not check but I think I need to install the ojdbc driver because I use a metadata connection.
Thus I installed the driver ojdbc6.jar as you recommanded but I have still the same error.
Below the log:

10:55:45,347 | INFO  | pool-70-thread-1 | rnal.service.FeaturesServiceImpl 1116 | 8 - org.apache.karaf.features.core - 4.0.1 | Changes to perform:
10:55:45,348 | INFO  | pool-70-thread-1 | rnal.service.FeaturesServiceImpl 1116 | 8 - org.apache.karaf.features.core - 4.0.1 |   Region: root
10:55:45,348 | INFO  | pool-70-thread-1 | rnal.service.FeaturesServiceImpl 1116 | 8 - org.apache.karaf.features.core - 4.0.1 |     Bundles to install:
10:55:45,348 | INFO  | pool-70-thread-1 | rnal.service.FeaturesServiceImpl 1116 | 8 - org.apache.karaf.features.core - 4.0.1 |       mvn:VEHANN/APPEL_JOB_BOR/0.5.0-SNAPSHOT
10:55:45,348 | INFO  | pool-70-thread-1 | rnal.service.FeaturesServiceImpl 1116 | 8 - org.apache.karaf.features.core - 4.0.1 |       mvn:VEHANN/APPEL_JOB_BOR_ATT_GAT_BOR/0.5.0-SNAPSHOT
10:55:45,350 | INFO  | pool-70-thread-1 | rnal.service.FeaturesServiceImpl 1116 | 8 - org.apache.karaf.features.core - 4.0.1 | Installing bundles:
10:55:45,350 | INFO  | pool-70-thread-1 | rnal.service.FeaturesServiceImpl 1116 | 8 - org.apache.karaf.features.core - 4.0.1 |   mvn:VEHANN/APPEL_JOB_BOR/0.5.0-SNAPSHOT
10:55:45,358 | INFO  | pool-70-thread-1 | rnal.service.FeaturesServiceImpl 1116 | 8 - org.apache.karaf.features.core - 4.0.1 |   mvn:VEHANN/APPEL_JOB_BOR_ATT_GAT_BOR/0.5.0-SNAPSHOT
10:55:45,387 | INFO  | pool-70-thread-1 | rnal.service.FeaturesServiceImpl 1116 | 8 - org.apache.karaf.features.core - 4.0.1 | Starting bundles:
10:55:45,387 | INFO  | pool-70-thread-1 | rnal.service.FeaturesServiceImpl 1116 | 8 - org.apache.karaf.features.core - 4.0.1 |   gate.APPEL_JOB_BOR/0.5.0.SNAPSHOT
10:55:45,487 | INFO  | pool-70-thread-1 | r.internal.JobTracker$Customizer  106 | 239 - org.talend.esb.job.controller - 6.0.1 | Service with reference {routines.system.api.TalendESBRoute, routines.system.api.TalendJob}={osgi.service.blueprint.compname=route, name=APPEL_JOB_BOR, type=route, service.id=737, service.bundleid=376, service.scope=bundle} added
10:55:45,487 | INFO  | pool-70-thread-1 | troller.internal.JobLauncherImpl  119 | 239 - org.talend.esb.job.controller - 6.0.1 | Adding route APPEL_JOB_BOR.
10:55:45,503 | INFO  | pool-64-thread-1 | controller.internal.RouteAdapter   66 | 239 - org.talend.esb.job.controller - 6.0.1 | Starting route APPEL_JOB_BOR
10:55:45,503 | INFO  | pool-70-thread-1 | ultOsgiApplicationContextCreator   67 | 231 - org.springframework.osgi.extender - 1.2.1 | Discovered configurations {osgibundle:/META-INF/spring/*.xml} in bundle
10:55:45,503 | INFO  | xtenderThread-17 | pport.AbstractApplicationContext  512 | 220 - org.apache.servicemix.bundles.spring-context - 3.2.14.RELEASE_1 | Refreshing OsgiBundleXmlApplicationContext(bundle=gate.APPEL_JOB_BOR, config=osgibundle:/META-INF/spring/*.xml): startup date ; root of context hierarchy
10:55:45,503 | INFO  | pool-70-thread-1 | rnal.service.FeaturesServiceImpl 1116 | 8 - org.apache.karaf.features.core - 4.0.1 |   gate.ATT_GAT_BOR/0.2.0
10:55:45,503 | INFO  | xtenderThread-17 | ractOsgiBundleApplicationContext  365 | 220 - org.apache.servicemix.bundles.spring-context - 3.2.14.RELEASE_1 | Application Context service already unpublished
10:55:45,503 | INFO  | xtenderThread-17 | tory.xml.XmlBeanDefinitionReader  316 | 219 - org.apache.servicemix.bundles.spring-beans - 3.2.14.RELEASE_1 | Loading XML bean definitions from URL
10:55:45,518 | INFO  | xtenderThread-17 | WaiterApplicationContextExecutor  243 | 231 - org.springframework.osgi.extender - 1.2.1 | No outstanding OSGi service dependencies, completing initialization for OsgiBundleXmlApplicationContext(bundle=gate.APPEL_JOB_BOR, config=osgibundle:/META-INF/spring/*.xml)
10:55:45,518 | INFO  | pool-64-thread-1 | rg.apache.camel.main.MainSupport  329 | 157 - org.apache.camel.camel-core - 2.15.3 | Apache Camel  starting
10:55:45,518 | INFO  | xtenderThread-18 | pport.DefaultListableBeanFactory  603 | 219 - org.apache.servicemix.bundles.spring-beans - 3.2.14.RELEASE_1 | Pre-instantiating singletons in org.springframework.beans.factory.support.DefaultListableBeanFactory@1ce5bae3: defining beans []; root of factory hierarchy
10:55:45,518 | INFO  | xtenderThread-18 | ractOsgiBundleApplicationContext  327 | 220 - org.apache.servicemix.bundles.spring-context - 3.2.14.RELEASE_1 | Publishing application context as OSGi service with properties {org.springframework.context.service.name=gate.APPEL_JOB_BOR, Bundle-SymbolicName=gate.APPEL_JOB_BOR, Bundle-Version=0.5.0.SNAPSHOT}
10:55:45,518 | INFO  | xtenderThread-18 | BundleApplicationContextListener   45 | 231 - org.springframework.osgi.extender - 1.2.1 | Application context successfully refreshed (OsgiBundleXmlApplicationContext(bundle=gate.APPEL_JOB_BOR, config=osgibundle:/META-INF/spring/*.xml))
10:55:45,518 | INFO  | pool-64-thread-1 | pport.AbstractApplicationContext  512 | 220 - org.apache.servicemix.bundles.spring-context - 3.2.14.RELEASE_1 | Refreshing OsgiBundleXmlApplicationContext(bundle=gate.APPEL_JOB_BOR, config=META-INF/spring/appel_job_bor.xml): startup date ; root of context hierarchy
10:55:45,518 | INFO  | pool-64-thread-1 | ractOsgiBundleApplicationContext  365 | 220 - org.apache.servicemix.bundles.spring-context - 3.2.14.RELEASE_1 | Application Context service already unpublished
10:55:45,534 | INFO  | pool-64-thread-1 | tory.xml.XmlBeanDefinitionReader  316 | 219 - org.apache.servicemix.bundles.spring-beans - 3.2.14.RELEASE_1 | Loading XML bean definitions from URL
10:55:45,537 | INFO  | pool-70-thread-1 | r.internal.JobTracker$Customizer  106 | 239 - org.talend.esb.job.controller - 6.0.1 | Service with reference {routines.system.api.TalendESBJob, routines.system.api.TalendESBJobFactory, routines.system.api.TalendJob}={osgi.service.blueprint.compname=job, version=0.2, name=gate.att_gat_bor_0_2.ATT_GAT_BOR, type=job, multithreading=true, service.id=741, service.bundleid=377, service.scope=bundle} added
10:55:45,538 | INFO  | pool-70-thread-1 | troller.internal.JobLauncherImpl   70 | 239 - org.talend.esb.job.controller - 6.0.1 | Adding ESB job factory for job gate.att_gat_bor_0_2.ATT_GAT_BOR.
10:55:45,540 | INFO  | pool-64-thread-1 | pport.DefaultListableBeanFactory  603 | 219 - org.apache.servicemix.bundles.spring-beans - 3.2.14.RELEASE_1 | Pre-instantiating singletons in org.springframework.beans.factory.support.DefaultListableBeanFactory@6dbd4c89: defining beans []; root of factory hierarchy
10:55:45,540 | INFO  | pool-64-thread-1 | ractOsgiBundleApplicationContext  327 | 220 - org.apache.servicemix.bundles.spring-context - 3.2.14.RELEASE_1 | Publishing application context as OSGi service with properties {org.springframework.context.service.name=gate.APPEL_JOB_BOR, Bundle-SymbolicName=gate.APPEL_JOB_BOR, Bundle-Version=0.5.0.SNAPSHOT}
10:55:45,545 | INFO  | pool-70-thread-1 | rnal.service.FeaturesServiceImpl 1116 | 8 - org.apache.karaf.features.core - 4.0.1 | Done.
10:55:45,592 | INFO  | pool-64-thread-1 | e.camel.impl.DefaultCamelContext 2434 | 157 - org.apache.camel.camel-core - 2.15.3 | Apache Camel 2.15.3 (CamelContext: APPEL_JOB_BOR-ctx) is starting
10:55:45,592 | INFO  | pool-64-thread-1 | gement.ManagedManagementStrategy  187 | 157 - org.apache.camel.camel-core - 2.15.3 | JMX is enabled
10:55:45,646 | INFO  | pool-64-thread-1 | e.camel.impl.DefaultCamelContext 2649 | 157 - org.apache.camel.camel-core - 2.15.3 | AllowUseOriginalMessage is enabled. If access to the original message is not needed, then its recommended to turn this option off as it may improve performance.
10:55:45,646 | INFO  | pool-64-thread-1 | e.camel.impl.DefaultCamelContext 2659 | 157 - org.apache.camel.camel-core - 2.15.3 | StreamCaching is not in use. If using streams then its recommended to enable stream caching. See more details at http://camel.apache.org/stream-caching.html
10:55:45,646 | INFO  | pool-64-thread-1 | amel.component.file.FileEndpoint   87 | 157 - org.apache.camel.camel-core - 2.15.3 | Endpoint is configured with noop=true so forcing endpoint to be idempotent as well
10:55:45,646 | INFO  | pool-64-thread-1 | amel.component.file.FileEndpoint   93 | 157 - org.apache.camel.camel-core - 2.15.3 | Using default memory based idempotent repository with cache max size: 1000
10:55:45,659 | INFO  | pool-64-thread-1 | e.camel.impl.DefaultCamelContext 3180 | 157 - org.apache.camel.camel-core - 2.15.3 | Route: cFile_1 started and consuming from: Endpoint
10:55:45,659 | INFO  | pool-64-thread-1 | e.camel.impl.DefaultCamelContext 2469 | 157 - org.apache.camel.camel-core - 2.15.3 | Total 1 routes, of which 1 is started.
10:55:45,660 | INFO  | pool-64-thread-1 | e.camel.impl.DefaultCamelContext 2470 | 157 - org.apache.camel.camel-core - 2.15.3 | Apache Camel 2.15.3 (CamelContext: APPEL_JOB_BOR-ctx) started in 0.067 seconds
10:56:08,861 | WARN  | 1370468171-18745 | rg.eclipse.jetty.server.Response  565 | 77 - org.eclipse.jetty.util - 9.2.10.v20150310 | Committed before 404 null
10:56:08,862 | WARN  | 1370468171-18745 | pse.jetty.servlet.ServletHandler  628 | 77 - org.eclipse.jetty.util - 9.2.10.v20150310 | /system/console
java.lang.IllegalStateException: Committed
 at org.eclipse.jetty.server.Response.resetBuffer(Response.java:1253)
 at org.eclipse.jetty.server.Response.sendError(Response.java:567)
 at org.eclipse.jetty.server.Response.sendError(Response.java:544)
 at org.eclipse.jetty.servlet.ServletHandler$Default404Servlet.doGet(ServletHandler.java:1805)
 at javax.servlet.http.HttpServlet.service(HttpServlet.java:687)
 at javax.servlet.http.HttpServlet.service(HttpServlet.java:790)
 at org.eclipse.jetty.servlet.ServletHolder.handle(ServletHolder.java:808)
 at org.eclipse.jetty.servlet.ServletHandler.doHandle(ServletHandler.java:587)
 at org.ops4j.pax.web.service.jetty.internal.HttpServiceServletHandler.doHandle(HttpServiceServletHandler.java:70)
 at org.eclipse.jetty.server.handler.ScopedHandler.handle(ScopedHandler.java:143)
 at org.eclipse.jetty.security.SecurityHandler.handle(SecurityHandler.java:577)
 at org.eclipse.jetty.server.session.SessionHandler.doHandle(SessionHandler.java:223)
 at org.eclipse.jetty.server.handler.ContextHandler.doHandle(ContextHandler.java:1127)
 at org.ops4j.pax.web.service.jetty.internal.HttpServiceContext.doHandle(HttpServiceContext.java:267)
 at org.eclipse.jetty.servlet.ServletHandler.doScope(ServletHandler.java:515)
 at org.eclipse.jetty.server.session.SessionHandler.doScope(SessionHandler.java:185)
 at org.eclipse.jetty.server.handler.ContextHandler.doScope(ContextHandler.java:1061)
 at org.eclipse.jetty.server.handler.ScopedHandler.handle(ScopedHandler.java:141)
 at org.ops4j.pax.web.service.jetty.internal.JettyServerHandlerCollection.handle(JettyServerHandlerCollection.java:99)
 at org.eclipse.jetty.server.handler.HandlerWrapper.handle(HandlerWrapper.java:97)
 at org.eclipse.jetty.server.Server.handle(Server.java:497)
 at org.eclipse.jetty.server.HttpChannel.handle(HttpChannel.java:310)
 at org.eclipse.jetty.server.HttpConnection.onFillable(HttpConnection.java:257)
 at org.eclipse.jetty.io.AbstractConnection$2.run(AbstractConnection.java:540)
 at org.eclipse.jetty.util.thread.QueuedThreadPool.runJob(QueuedThreadPool.java:635)
 at org.eclipse.jetty.util.thread.QueuedThreadPool$3.run(QueuedThreadPool.java:555)
 at java.lang.Thread.run(Thread.java:745)
10:56:08,863 | WARN  | 1370468171-18745 | eclipse.jetty.server.HttpChannel  395 | 77 - org.eclipse.jetty.util - 9.2.10.v20150310 | /system/console
java.lang.IllegalStateException: Committed
 at org.eclipse.jetty.server.Response.resetBuffer(Response.java:1253)
 at org.eclipse.jetty.server.Response.sendError(Response.java:567)
 at org.eclipse.jetty.server.Response.sendError(Response.java:544)
 at org.eclipse.jetty.servlet.ServletHandler$Default404Servlet.doGet(ServletHandler.java:1805)
 at javax.servlet.http.HttpServlet.service(HttpServlet.java:687)
 at javax.servlet.http.HttpServlet.service(HttpServlet.java:790)
 at org.eclipse.jetty.servlet.ServletHolder.handle(ServletHolder.java:808)
 at org.eclipse.jetty.servlet.ServletHandler.doHandle(ServletHandler.java:587)
 at org.ops4j.pax.web.service.jetty.internal.HttpServiceServletHandler.doHandle(HttpServiceServletHandler.java:70)
 at org.eclipse.jetty.server.handler.ScopedHandler.handle(ScopedHandler.java:143)
 at org.eclipse.jetty.security.SecurityHandler.handle(SecurityHandler.java:577)
 at org.eclipse.jetty.server.session.SessionHandler.doHandle(SessionHandler.java:223)
 at org.eclipse.jetty.server.handler.ContextHandler.doHandle(ContextHandler.java:1127)
 at org.ops4j.pax.web.service.jetty.internal.HttpServiceContext.doHandle(HttpServiceContext.java:267)
 at org.eclipse.jetty.servlet.ServletHandler.doScope(ServletHandler.java:515)
 at org.eclipse.jetty.server.session.SessionHandler.doScope(SessionHandler.java:185)
 at org.eclipse.jetty.server.handler.ContextHandler.doScope(ContextHandler.java:1061)
 at org.eclipse.jetty.server.handler.ScopedHandler.handle(ScopedHandler.java:141)
 at org.ops4j.pax.web.service.jetty.internal.JettyServerHandlerCollection.handle(JettyServerHandlerCollection.java:99)
 at org.eclipse.jetty.server.handler.HandlerWrapper.handle(HandlerWrapper.java:97)
 at org.eclipse.jetty.server.Server.handle(Server.java:497)
 at org.eclipse.jetty.server.HttpChannel.handle(HttpChannel.java:310)
 at org.eclipse.jetty.server.HttpConnection.onFillable(HttpConnection.java:257)
 at org.eclipse.jetty.io.AbstractConnection$2.run(AbstractConnection.java:540)
 at org.eclipse.jetty.util.thread.QueuedThreadPool.runJob(QueuedThreadPool.java:635)
 at org.eclipse.jetty.util.thread.QueuedThreadPool$3.run(QueuedThreadPool.java:555)
 at java.lang.Thread.run(Thread.java:745)
10:56:08,863 | WARN  | 1370468171-18745 | eclipse.jetty.server.HttpChannel  481 | 77 - org.eclipse.jetty.util - 9.2.10.v20150310 | Could not send response error 500: java.lang.IllegalStateException: Committed
10:56:08,872 | WARN  | 1370468171-18745 | rg.eclipse.jetty.server.Response  565 | 77 - org.eclipse.jetty.util - 9.2.10.v20150310 | Committed before 404 null
10:56:08,873 | WARN  | 1370468171-18745 | pse.jetty.servlet.ServletHandler  628 | 77 - org.eclipse.jetty.util - 9.2.10.v20150310 | /system/console/bundles
java.lang.IllegalStateException: Committed
 at org.eclipse.jetty.server.Response.resetBuffer(Response.java:1253)
 at org.eclipse.jetty.server.Response.sendError(Response.java:567)
 at org.eclipse.jetty.server.Response.sendError(Response.java:544)
 at org.eclipse.jetty.servlet.ServletHandler$Default404Servlet.doGet(ServletHandler.java:1805)
 at javax.servlet.http.HttpServlet.service(HttpServlet.java:687)
 at javax.servlet.http.HttpServlet.service(HttpServlet.java:790)
 at org.eclipse.jetty.servlet.ServletHolder.handle(ServletHolder.java:808)
 at org.eclipse.jetty.servlet.ServletHandler.doHandle(ServletHandler.java:587)
 at org.ops4j.pax.web.service.jetty.internal.HttpServiceServletHandler.doHandle(HttpServiceServletHandler.java:70)
 at org.eclipse.jetty.server.handler.ScopedHandler.handle(ScopedHandler.java:143)
 at org.eclipse.jetty.security.SecurityHandler.handle(SecurityHandler.java:577)
 at org.eclipse.jetty.server.session.SessionHandler.doHandle(SessionHandler.java:223)
 at org.eclipse.jetty.server.handler.ContextHandler.doHandle(ContextHandler.java:1127)
 at org.ops4j.pax.web.service.jetty.internal.HttpServiceContext.doHandle(HttpServiceContext.java:267)
 at org.eclipse.jetty.servlet.ServletHandler.doScope(ServletHandler.java:515)
 at org.eclipse.jetty.server.session.SessionHandler.doScope(SessionHandler.java:185)
 at org.eclipse.jetty.server.handler.ContextHandler.doScope(ContextHandler.java:1061)
 at org.eclipse.jetty.server.handler.ScopedHandler.handle(ScopedHandler.java:141)
 at org.ops4j.pax.web.service.jetty.internal.JettyServerHandlerCollection.handle(JettyServerHandlerCollection.java:99)
 at org.eclipse.jetty.server.handler.HandlerWrapper.handle(HandlerWrapper.java:97)
 at org.eclipse.jetty.server.Server.handle(Server.java:497)
 at org.eclipse.jetty.server.HttpChannel.handle(HttpChannel.java:310)
 at org.eclipse.jetty.server.HttpConnection.onFillable(HttpConnection.java:257)
 at org.eclipse.jetty.io.AbstractConnection$2.run(AbstractConnection.java:540)
 at org.eclipse.jetty.util.thread.QueuedThreadPool.runJob(QueuedThreadPool.java:635)
 at org.eclipse.jetty.util.thread.QueuedThreadPool$3.run(QueuedThreadPool.java:555)
 at java.lang.Thread.run(Thread.java:745)
10:56:08,873 | WARN  | 1370468171-18745 | eclipse.jetty.server.HttpChannel  395 | 77 - org.eclipse.jetty.util - 9.2.10.v20150310 | /system/console/bundles
java.lang.IllegalStateException: Committed
 at org.eclipse.jetty.server.Response.resetBuffer(Response.java:1253)
 at org.eclipse.jetty.server.Response.sendError(Response.java:567)
 at org.eclipse.jetty.server.Response.sendError(Response.java:544)
 at org.eclipse.jetty.servlet.ServletHandler$Default404Servlet.doGet(ServletHandler.java:1805)
 at javax.servlet.http.HttpServlet.service(HttpServlet.java:687)
 at javax.servlet.http.HttpServlet.service(HttpServlet.java:790)
 at org.eclipse.jetty.servlet.ServletHolder.handle(ServletHolder.java:808)
 at org.eclipse.jetty.servlet.ServletHandler.doHandle(ServletHandler.java:587)
 at org.ops4j.pax.web.service.jetty.internal.HttpServiceServletHandler.doHandle(HttpServiceServletHandler.java:70)
 at org.eclipse.jetty.server.handler.ScopedHandler.handle(ScopedHandler.java:143)
 at org.eclipse.jetty.security.SecurityHandler.handle(SecurityHandler.java:577)
 at org.eclipse.jetty.server.session.SessionHandler.doHandle(SessionHandler.java:223)
 at org.eclipse.jetty.server.handler.ContextHandler.doHandle(ContextHandler.java:1127)
 at org.ops4j.pax.web.service.jetty.internal.HttpServiceContext.doHandle(HttpServiceContext.java:267)
 at org.eclipse.jetty.servlet.ServletHandler.doScope(ServletHandler.java:515)
 at org.eclipse.jetty.server.session.SessionHandler.doScope(SessionHandler.java:185)
 at org.eclipse.jetty.server.handler.ContextHandler.doScope(ContextHandler.java:1061)
 at org.eclipse.jetty.server.handler.ScopedHandler.handle(ScopedHandler.java:141)
 at org.ops4j.pax.web.service.jetty.internal.JettyServerHandlerCollection.handle(JettyServerHandlerCollection.java:99)
 at org.eclipse.jetty.server.handler.HandlerWrapper.handle(HandlerWrapper.java:97)
 at org.eclipse.jetty.server.Server.handle(Server.java:497)
 at org.eclipse.jetty.server.HttpChannel.handle(HttpChannel.java:310)
 at org.eclipse.jetty.server.HttpConnection.onFillable(HttpConnection.java:257)
 at org.eclipse.jetty.io.AbstractConnection$2.run(AbstractConnection.java:540)
 at org.eclipse.jetty.util.thread.QueuedThreadPool.runJob(QueuedThreadPool.java:635)
 at org.eclipse.jetty.util.thread.QueuedThreadPool$3.run(QueuedThreadPool.java:555)
 at java.lang.Thread.run(Thread.java:745)
10:56:08,873 | WARN  | 1370468171-18745 | eclipse.jetty.server.HttpChannel  481 | 77 - org.eclipse.jetty.util - 9.2.10.v20150310 | Could not send response error 500: java.lang.IllegalStateException: Committed
10:57:38,877 | WARN  | 1370468171-18700 | rg.eclipse.jetty.server.Response  565 | 77 - org.eclipse.jetty.util - 9.2.10.v20150310 | Committed before 404 null
10:57:38,877 | WARN  | 1370468171-18700 | pse.jetty.servlet.ServletHandler  628 | 77 - org.eclipse.jetty.util - 9.2.10.v20150310 | /system/console
java.lang.IllegalStateException: Committed
 at org.eclipse.jetty.server.Response.resetBuffer(Response.java:1253)
 at org.eclipse.jetty.server.Response.sendError(Response.java:567)
 at org.eclipse.jetty.server.Response.sendError(Response.java:544)
 at org.eclipse.jetty.servlet.ServletHandler$Default404Servlet.doGet(ServletHandler.java:1805)
 at javax.servlet.http.HttpServlet.service(HttpServlet.java:687)
 at javax.servlet.http.HttpServlet.service(HttpServlet.java:790)
 at org.eclipse.jetty.servlet.ServletHolder.handle(ServletHolder.java:808)
 at org.eclipse.jetty.servlet.ServletHandler.doHandle(ServletHandler.java:587)
 at org.ops4j.pax.web.service.jetty.internal.HttpServiceServletHandler.doHandle(HttpServiceServletHandler.java:70)
 at org.eclipse.jetty.server.handler.ScopedHandler.handle(ScopedHandler.java:143)
 at org.eclipse.jetty.security.SecurityHandler.handle(SecurityHandler.java:577)
 at org.eclipse.jetty.server.session.SessionHandler.doHandle(SessionHandler.java:223)
 at org.eclipse.jetty.server.handler.ContextHandler.doHandle(ContextHandler.java:1127)
 at org.ops4j.pax.web.service.jetty.internal.HttpServiceContext.doHandle(HttpServiceContext.java:267)
 at org.eclipse.jetty.servlet.ServletHandler.doScope(ServletHandler.java:515)
 at org.eclipse.jetty.server.session.SessionHandler.doScope(SessionHandler.java:185)
 at org.eclipse.jetty.server.handler.ContextHandler.doScope(ContextHandler.java:1061)
 at org.eclipse.jetty.server.handler.ScopedHandler.handle(ScopedHandler.java:141)
 at org.ops4j.pax.web.service.jetty.internal.JettyServerHandlerCollection.handle(JettyServerHandlerCollection.java:99)
 at org.eclipse.jetty.server.handler.HandlerWrapper.handle(HandlerWrapper.java:97)
 at org.eclipse.jetty.server.Server.handle(Server.java:497)
 at org.eclipse.jetty.server.HttpChannel.handle(HttpChannel.java:310)
 at org.eclipse.jetty.server.HttpConnection.onFillable(HttpConnection.java:257)
 at org.eclipse.jetty.io.AbstractConnection$2.run(AbstractConnection.java:540)
 at org.eclipse.jetty.util.thread.QueuedThreadPool.runJob(QueuedThreadPool.java:635)
 at org.eclipse.jetty.util.thread.QueuedThreadPool$3.run(QueuedThreadPool.java:555)
 at java.lang.Thread.run(Thread.java:745)
10:57:38,877 | WARN  | 1370468171-18700 | eclipse.jetty.server.HttpChannel  395 | 77 - org.eclipse.jetty.util - 9.2.10.v20150310 | /system/console
java.lang.IllegalStateException: Committed
 at org.eclipse.jetty.server.Response.resetBuffer(Response.java:1253)
 at org.eclipse.jetty.server.Response.sendError(Response.java:567)
 at org.eclipse.jetty.server.Response.sendError(Response.java:544)
 at org.eclipse.jetty.servlet.ServletHandler$Default404Servlet.doGet(ServletHandler.java:1805)
 at javax.servlet.http.HttpServlet.service(HttpServlet.java:687)
 at javax.servlet.http.HttpServlet.service(HttpServlet.java:790)
 at org.eclipse.jetty.servlet.ServletHolder.handle(ServletHolder.java:808)
 at org.eclipse.jetty.servlet.ServletHandler.doHandle(ServletHandler.java:587)
 at org.ops4j.pax.web.service.jetty.internal.HttpServiceServletHandler.doHandle(HttpServiceServletHandler.java:70)
 at org.eclipse.jetty.server.handler.ScopedHandler.handle(ScopedHandler.java:143)
 at org.eclipse.jetty.security.SecurityHandler.handle(SecurityHandler.java:577)
 at org.eclipse.jetty.server.session.SessionHandler.doHandle(SessionHandler.java:223)
 at org.eclipse.jetty.server.handler.ContextHandler.doHandle(ContextHandler.java:1127)
 at org.ops4j.pax.web.service.jetty.internal.HttpServiceContext.doHandle(HttpServiceContext.java:267)
 at org.eclipse.jetty.servlet.ServletHandler.doScope(ServletHandler.java:515)
 at org.eclipse.jetty.server.session.SessionHandler.doScope(SessionHandler.java:185)
 at org.eclipse.jetty.server.handler.ContextHandler.doScope(ContextHandler.java:1061)
 at org.eclipse.jetty.server.handler.ScopedHandler.handle(ScopedHandler.java:141)
 at org.ops4j.pax.web.service.jetty.internal.JettyServerHandlerCollection.handle(JettyServerHandlerCollection.java:99)
 at org.eclipse.jetty.server.handler.HandlerWrapper.handle(HandlerWrapper.java:97)
 at org.eclipse.jetty.server.Server.handle(Server.java:497)
 at org.eclipse.jetty.server.HttpChannel.handle(HttpChannel.java:310)
 at org.eclipse.jetty.server.HttpConnection.onFillable(HttpConnection.java:257)
 at org.eclipse.jetty.io.AbstractConnection$2.run(AbstractConnection.java:540)
 at org.eclipse.jetty.util.thread.QueuedThreadPool.runJob(QueuedThreadPool.java:635)
 at org.eclipse.jetty.util.thread.QueuedThreadPool$3.run(QueuedThreadPool.java:555)
 at java.lang.Thread.run(Thread.java:745)
10:57:38,877 | WARN  | 1370468171-18700 | eclipse.jetty.server.HttpChannel  481 | 77 - org.eclipse.jetty.util - 9.2.10.v20150310 | Could not send response error 500: java.lang.IllegalStateException: Committed
10:57:38,877 | WARN  | 1370468171-18793 | rg.eclipse.jetty.server.Response  565 | 77 - org.eclipse.jetty.util - 9.2.10.v20150310 | Committed before 404 null
10:57:38,877 | WARN  | 1370468171-18793 | pse.jetty.servlet.ServletHandler  628 | 77 - org.eclipse.jetty.util - 9.2.10.v20150310 | /system/console/bundles
java.lang.IllegalStateException: Committed
 at org.eclipse.jetty.server.Response.resetBuffer(Response.java:1253)
 at org.eclipse.jetty.server.Response.sendError(Response.java:567)
 at org.eclipse.jetty.server.Response.sendError(Response.java:544)
 at org.eclipse.jetty.servlet.ServletHandler$Default404Servlet.doGet(ServletHandler.java:1805)
 at javax.servlet.http.HttpServlet.service(HttpServlet.java:687)
 at javax.servlet.http.HttpServlet.service(HttpServlet.java:790)
 at org.eclipse.jetty.servlet.ServletHolder.handle(ServletHolder.java:808)
 at org.eclipse.jetty.servlet.ServletHandler.doHandle(ServletHandler.java:587)
 at org.ops4j.pax.web.service.jetty.internal.HttpServiceServletHandler.doHandle(HttpServiceServletHandler.java:70)
 at org.eclipse.jetty.server.handler.ScopedHandler.handle(ScopedHandler.java:143)
 at org.eclipse.jetty.security.SecurityHandler.handle(SecurityHandler.java:577)
 at org.eclipse.jetty.server.session.SessionHandler.doHandle(SessionHandler.java:223)
 at org.eclipse.jetty.server.handler.ContextHandler.doHandle(ContextHandler.java:1127)
 at org.ops4j.pax.web.service.jetty.internal.HttpServiceContext.doHandle(HttpServiceContext.java:267)
 at org.eclipse.jetty.servlet.ServletHandler.doScope(ServletHandler.java:515)
 at org.eclipse.jetty.server.session.SessionHandler.doScope(SessionHandler.java:185)
 at org.eclipse.jetty.server.handler.ContextHandler.doScope(ContextHandler.java:1061)
 at org.eclipse.jetty.server.handler.ScopedHandler.handle(ScopedHandler.java:141)
 at org.ops4j.pax.web.service.jetty.internal.JettyServerHandlerCollection.handle(JettyServerHandlerCollection.java:99)
 at org.eclipse.jetty.server.handler.HandlerWrapper.handle(HandlerWrapper.java:97)
 at org.eclipse.jetty.server.Server.handle(Server.java:497)
 at org.eclipse.jetty.server.HttpChannel.handle(HttpChannel.java:310)
 at org.eclipse.jetty.server.HttpConnection.onFillable(HttpConnection.java:257)
 at org.eclipse.jetty.io.AbstractConnection$2.run(AbstractConnection.java:540)
 at org.eclipse.jetty.util.thread.QueuedThreadPool.runJob(QueuedThreadPool.java:635)
 at org.eclipse.jetty.util.thread.QueuedThreadPool$3.run(QueuedThreadPool.java:555)
 at java.lang.Thread.run(Thread.java:745)
10:57:38,877 | WARN  | 1370468171-18793 | eclipse.jetty.server.HttpChannel  395 | 77 - org.eclipse.jetty.util - 9.2.10.v20150310 | /system/console/bundles
java.lang.IllegalStateException: Committed
 at org.eclipse.jetty.server.Response.resetBuffer(Response.java:1253)
 at org.eclipse.jetty.server.Response.sendError(Response.java:567)
 at org.eclipse.jetty.server.Response.sendError(Response.java:544)
 at org.eclipse.jetty.servlet.ServletHandler$Default404Servlet.doGet(ServletHandler.java:1805)
 at javax.servlet.http.HttpServlet.service(HttpServlet.java:687)
 at javax.servlet.http.HttpServlet.service(HttpServlet.java:790)
 at org.eclipse.jetty.servlet.ServletHolder.handle(ServletHolder.java:808)
 at org.eclipse.jetty.servlet.ServletHandler.doHandle(ServletHandler.java:587)
 at org.ops4j.pax.web.service.jetty.internal.HttpServiceServletHandler.doHandle(HttpServiceServletHandler.java:70)
 at org.eclipse.jetty.server.handler.ScopedHandler.handle(ScopedHandler.java:143)
 at org.eclipse.jetty.security.SecurityHandler.handle(SecurityHandler.java:577)
 at org.eclipse.jetty.server.session.SessionHandler.doHandle(SessionHandler.java:223)
 at org.eclipse.jetty.server.handler.ContextHandler.doHandle(ContextHandler.java:1127)
 at org.ops4j.pax.web.service.jetty.internal.HttpServiceContext.doHandle(HttpServiceContext.java:267)
 at org.eclipse.jetty.servlet.ServletHandler.doScope(ServletHandler.java:515)
 at org.eclipse.jetty.server.session.SessionHandler.doScope(SessionHandler.java:185)
 at org.eclipse.jetty.server.handler.ContextHandler.doScope(ContextHandler.java:1061)
 at org.eclipse.jetty.server.handler.ScopedHandler.handle(ScopedHandler.java:141)
 at org.ops4j.pax.web.service.jetty.internal.JettyServerHandlerCollection.handle(JettyServerHandlerCollection.java:99)
 at org.eclipse.jetty.server.handler.HandlerWrapper.handle(HandlerWrapper.java:97)
 at org.eclipse.jetty.server.Server.handle(Server.java:497)
 at org.eclipse.jetty.server.HttpChannel.handle(HttpChannel.java:310)
 at org.eclipse.jetty.server.HttpConnection.onFillable(HttpConnection.java:257)
 at org.eclipse.jetty.io.AbstractConnection$2.run(AbstractConnection.java:540)
 at org.eclipse.jetty.util.thread.QueuedThreadPool.runJob(QueuedThreadPool.java:635)
 at org.eclipse.jetty.util.thread.QueuedThreadPool$3.run(QueuedThreadPool.java:555)
 at java.lang.Thread.run(Thread.java:745)
10:57:38,877 | WARN  | 1370468171-18793 | eclipse.jetty.server.HttpChannel  481 | 77 - org.eclipse.jetty.util - 9.2.10.v20150310 | Could not send response error 500: java.lang.IllegalStateException: Committed
10:58:12,403 | INFO  | 42)-192.168.8.44 | nt.container.BlueprintExtender$3  317 | 15 - org.apache.aries.blueprint.core - 1.4.3 | Destroying BlueprintContainer for bundle gate.APPEL_JOB_BOR
10:58:12,403 | INFO  | 42)-192.168.8.44 | r.internal.JobTracker$Customizer  133 | 239 - org.talend.esb.job.controller - 6.0.1 | Service Routes: ] -> , To]]] removed
10:58:12,403 | INFO  | 42)-192.168.8.44 | troller.internal.JobLauncherImpl  134 | 239 - org.talend.esb.job.controller - 6.0.1 | Removing route APPEL_JOB_BOR.
10:58:12,403 | INFO  | 42)-192.168.8.44 | controller.internal.RouteAdapter   52 | 239 - org.talend.esb.job.controller - 6.0.1 | Cancelling route APPEL_JOB_BOR
10:58:12,403 | INFO  | 42)-192.168.8.44 | rg.apache.camel.main.MainSupport  323 | 157 - org.apache.camel.camel-core - 2.15.3 | Apache Camel  stopping
10:58:12,403 | INFO  | 42)-192.168.8.44 | e.camel.impl.DefaultCamelContext 2676 | 157 - org.apache.camel.camel-core - 2.15.3 | Apache Camel 2.15.3 (CamelContext: APPEL_JOB_BOR-ctx) is shutting down
10:58:12,403 | INFO  | pool-64-thread-1 | controller.internal.RouteAdapter   79 | 239 - org.talend.esb.job.controller - 6.0.1 | Route APPEL_JOB_BOR finished, return code is 0
10:58:12,403 | INFO  | 42)-192.168.8.44 | mel.impl.DefaultShutdownStrategy  187 | 157 - org.apache.camel.camel-core - 2.15.3 | Starting to graceful shutdown 1 routes (timeout 300 seconds)
10:58:12,403 | INFO  | 3 - ShutdownTask | ultShutdownStrategy$ShutdownTask  665 | 157 - org.apache.camel.camel-core - 2.15.3 | Route: cFile_1 shutdown complete, was consuming from: Endpoint
10:58:12,403 | INFO  | 42)-192.168.8.44 | mel.impl.DefaultShutdownStrategy  250 | 157 - org.apache.camel.camel-core - 2.15.3 | Graceful shutdown of 1 routes completed in 0 seconds
10:58:12,435 | INFO  | 42)-192.168.8.44 | e.camel.impl.DefaultCamelContext 2761 | 157 - org.apache.camel.camel-core - 2.15.3 | Apache Camel 2.15.3 (CamelContext: APPEL_JOB_BOR-ctx) uptime 2 minutes
10:58:12,435 | INFO  | 42)-192.168.8.44 | e.camel.impl.DefaultCamelContext 2762 | 157 - org.apache.camel.camel-core - 2.15.3 | Apache Camel 2.15.3 (CamelContext: APPEL_JOB_BOR-ctx) is shutdown in 0.032 seconds
10:58:12,435 | INFO  | Timer-7          | ractOsgiBundleApplicationContext  359 | 220 - org.apache.servicemix.bundles.spring-context - 3.2.14.RELEASE_1 | Unpublishing application context OSGi service for bundle APPEL_JOB_BOR (gate.APPEL_JOB_BOR)
10:58:12,435 | INFO  | Timer-7          | pport.AbstractApplicationContext 1044 | 220 - org.apache.servicemix.bundles.spring-context - 3.2.14.RELEASE_1 | Closing OsgiBundleXmlApplicationContext(bundle=gate.APPEL_JOB_BOR, config=osgibundle:/META-INF/spring/*.xml): startup date ; root of context hierarchy
10:58:12,435 | INFO  | Timer-7          | ort.DefaultSingletonBeanRegistry  444 | 219 - org.apache.servicemix.bundles.spring-beans - 3.2.14.RELEASE_1 | Destroying singletons in org.springframework.beans.factory.support.DefaultListableBeanFactory@1ce5bae3: defining beans []; root of factory hierarchy
10:58:12,435 | INFO  | Timer-7          | BundleApplicationContextListener   60 | 231 - org.springframework.osgi.extender - 1.2.1 | Application context succesfully closed (OsgiBundleXmlApplicationContext(bundle=gate.APPEL_JOB_BOR, config=osgibundle:/META-INF/spring/*.xml))
One Star

Re: [resolved] [Talend 6.0.1] tOracleConnection error

Tac tells me at least one bundle is not active:
One Star

Re: [resolved] [Talend 6.0.1] tOracleConnection error

I have another error in wrapper.log:
INFO   | jvm 1    | 2016/01/07 10:55:46 | Exception in component tOracleConnection_1
INFO   | jvm 1    | 2016/01/07 10:55:46 | java.lang.ClassNotFoundException: oracle.jdbc.OracleDriver cannot be found by gate.ATT_GAT_BOR_0.2.0
INFO   | jvm 1    | 2016/01/07 10:55:46 | at org.eclipse.osgi.internal.loader.BundleLoader.findClassInternal(BundleLoader.java:439)
INFO   | jvm 1    | 2016/01/07 10:55:46 | at org.eclipse.osgi.internal.loader.BundleLoader.findClass(BundleLoader.java:352)
INFO   | jvm 1    | 2016/01/07 10:55:46 | at org.eclipse.osgi.internal.loader.BundleLoader.findClass(BundleLoader.java:344)
INFO   | jvm 1    | 2016/01/07 10:55:46 | at org.eclipse.osgi.internal.loader.ModuleClassLoader.loadClass(ModuleClassLoader.java:160)
INFO   | jvm 1    | 2016/01/07 10:55:46 | at java.lang.ClassLoader.loadClass(ClassLoader.java:357)
INFO   | jvm 1    | 2016/01/07 10:55:46 | at java.lang.Class.forName0(Native Method)
INFO   | jvm 1    | 2016/01/07 10:55:46 | at java.lang.Class.forName(Class.java:264)
INFO   | jvm 1    | 2016/01/07 10:55:46 | at gate.att_gat_bor_write_0_5.ATT_GAT_BOR_WRITE.tOracleConnection_1Process(ATT_GAT_BOR_WRITE.java:1286)
INFO   | jvm 1    | 2016/01/07 10:55:46 | at gate.att_gat_bor_write_0_5.ATT_GAT_BOR_WRITE.runJobInTOS(ATT_GAT_BOR_WRITE.java:17182)
INFO   | jvm 1    | 2016/01/07 10:55:46 | at gate.att_gat_bor_write_0_5.ATT_GAT_BOR_WRITE.runJob(ATT_GAT_BOR_WRITE.java:16970)
INFO   | jvm 1    | 2016/01/07 10:55:46 | at gate.att_gat_bor_0_2.ATT_GAT_BOR.tRunJob_1Process(ATT_GAT_BOR.java:3168)
INFO   | jvm 1    | 2016/01/07 10:55:46 | at gate.att_gat_bor_0_2.ATT_GAT_BOR.tXSDValidator_1Process(ATT_GAT_BOR.java:1920)
INFO   | jvm 1    | 2016/01/07 10:55:46 | at gate.att_gat_bor_0_2.ATT_GAT_BOR.tFixedFlowInput_4Process(ATT_GAT_BOR.java:1650)
INFO   | jvm 1    | 2016/01/07 10:55:46 | at gate.att_gat_bor_0_2.ATT_GAT_BOR.tRouteInput_1Process(ATT_GAT_BOR.java:1111)
INFO   | jvm 1    | 2016/01/07 10:55:46 | at gate.att_gat_bor_0_2.ATT_GAT_BOR.runJobInTOS(ATT_GAT_BOR.java:3985)
INFO   | jvm 1    | 2016/01/07 10:55:46 | at org.talend.camel.TalendProducer.invokeTalendJob(TalendProducer.java:109)
INFO   | jvm 1    | 2016/01/07 10:55:46 | at org.talend.camel.TalendProducer.process(TalendProducer.java:65)
INFO   | jvm 1    | 2016/01/07 10:55:46 | at org.apache.camel.util.AsyncProcessorConverterHelper$ProcessorToAsyncProcessorBridge.process(AsyncProcessorConverterHelper.java:61)
INFO   | jvm 1    | 2016/01/07 10:55:46 | at org.apache.camel.processor.SendProcessor.process(SendProcessor.java:129)
INFO   | jvm 1    | 2016/01/07 10:55:46 | at org.apache.camel.management.InstrumentationProcessor.process(InstrumentationProcessor.java:77)
INFO   | jvm 1    | 2016/01/07 10:55:46 | at org.apache.camel.processor.RedeliveryErrorHandler.process(RedeliveryErrorHandler.java:448)
INFO   | jvm 1    | 2016/01/07 10:55:46 | at org.apache.camel.processor.CamelInternalProcessor.process(CamelInternalProcessor.java:190)
INFO   | jvm 1    | 2016/01/07 10:55:46 | at org.apache.camel.processor.Pipeline.process(Pipeline.java:118)
INFO   | jvm 1    | 2016/01/07 10:55:46 | at org.apache.camel.processor.Pipeline.process(Pipeline.java:80)
INFO   | jvm 1    | 2016/01/07 10:55:46 | at org.apache.camel.processor.CamelInternalProcessor.process(CamelInternalProcessor.java:190)
INFO   | jvm 1    | 2016/01/07 10:55:46 | at org.apache.camel.component.file.GenericFileConsumer.processExchange(GenericFileConsumer.java:439)
INFO   | jvm 1    | 2016/01/07 10:55:46 | at org.apache.camel.component.file.GenericFileConsumer.processBatch(GenericFileConsumer.java:211)
INFO   | jvm 1    | 2016/01/07 10:55:46 | at org.apache.camel.component.file.GenericFileConsumer.poll(GenericFileConsumer.java:175)
INFO   | jvm 1    | 2016/01/07 10:55:46 | at org.apache.camel.impl.ScheduledPollConsumer.doRun(ScheduledPollConsumer.java:174)
INFO   | jvm 1    | 2016/01/07 10:55:46 | at org.apache.camel.impl.ScheduledPollConsumer.run(ScheduledPollConsumer.java:101)
INFO   | jvm 1    | 2016/01/07 10:55:46 | at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:511)
INFO   | jvm 1    | 2016/01/07 10:55:46 | at java.util.concurrent.FutureTask.runAndReset(FutureTask.java:308)
INFO   | jvm 1    | 2016/01/07 10:55:46 | at java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.access$301(ScheduledThreadPoolExecutor.java:180)
INFO   | jvm 1    | 2016/01/07 10:55:46 | at java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.run(ScheduledThreadPoolExecutor.java:294)
INFO   | jvm 1    | 2016/01/07 10:55:46 | at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142)
INFO   | jvm 1    | 2016/01/07 10:55:46 | at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617)
INFO   | jvm 1    | 2016/01/07 10:55:46 | at java.lang.Thread.run(Thread.java:745)
One Star

Re: [resolved] [Talend 6.0.1] tOracleConnection error

hi,
could you check if the oracle.jdbc.* package is imported in the headers? And indeed - the driver needs to be installed always (as a wrapper!)
Carpe diem
g.
One Star

Re: [resolved] [Talend 6.0.1] tOracleConnection error

Hi,
I don't understand your question. I need to check the headers of what or which component ?
Thx for your help
One Star

Re: [resolved] [Talend 6.0.1] tOracleConnection error

Hello
My idea was to check if the job bundle is started, and if not, , the most probable cause will be 'unsatisfied dependency'. Log in into the TESB console (ssh esb_runtime:8101 or http://esb_runtime:8040/system.console).  Details could be found in the bundle headers (in the tesb CLI console issue command 'headers <bundle id>').  
Using command 'list' you could see if the oracle driver bundle is active (and loaded as a wrapper - hence exporting all its classes, see the post from xldai ).
g.
One Star

Re: [resolved] [Talend 6.0.1] tOracleConnection error

Hi ,
The solution is to add a PreJob ->tLibraryLoad ->OnComponentOk / OnSubjobOk -> tOracleConnection -> ..
Thanks all for your help