Hitachi Vantara Pentaho Community Forums
Results 1 to 6 of 6

Thread: oracle.jdbc.oracledriver exception

  1. #1

    Default oracle.jdbc.oracledriver exception

    hi,

    i am running the design wizard from the report designer.
    my connection is successful (to oracle db).
    but when i click on the query designer, it throws exception of the above driver.

    i have all the driver in place, the connection is successful then why the error?

    please help.

    thanks
    pranav.

  2. #2
    Join Date
    Jun 2007
    Posts
    2

    Default

    I have the same error, somebody can help us?

  3. #3
    Join Date
    Jun 2007
    Posts
    2

    Default

    I already found the problem of oracle Driver exception, just clean REM in the file startdesigner.bat of the line :

    FOR %%F IN (lib \ jdbc \ to *.jar) DO call: updateClassPath %%F

    But after use tables and finalize wizard, when I play the report show no data available !!!

    Why ? if there is data in the table

  4. #4

    Default

    Hello !

    What is your versions (OS/Pentaho/ReportWizard) ?

    Cedric
    Cedric CLAIDIERE
    Aprolis
    www.aprolis.com

  5. #5

    Default private

    Please by e-mail tcljava@gmail.com
    I am using with the Oracle. How he could decide this?




    09:19:17,984 INFO [JobStoreCMT] Recovering 0 jobs that were in-progress at the
    time of the last shut-down.
    09:19:17,984 INFO [JobStoreCMT] Recovery complete.
    09:19:18,000 INFO [JobStoreCMT] Removed 0 'complete' triggers.
    09:19:18,015 INFO [JobStoreCMT] Removed 0 stale fired job entries.
    09:19:18,015 INFO [QuartzScheduler] Scheduler PentahoQuartzScheduler_$_1 starte
    d.
    09:19:25,953 INFO [CWM] CWM - Loaded CWM model into the default repository.
    09:19:25,968 INFO [STDOUT] [pt_47] Pentaho BI Platform server is ready. (1.2.1-
    625 GA)
    09:19:26,656 INFO [TomcatDeployer] deploy, ctxPath=/sw-style, warUrl=.../tmp/de
    ploy/tmp31730pentaho.ear-contents/sw-style-exp.war/
    09:19:26,859 INFO [EARDeployer] Started J2EE application: file:/C:/JBoss/jboss-
    4.0.5.GA/server/default/deploy/pentaho.ear
    09:19:26,968 INFO [Http11BaseProtocol] Starting Coyote HTTP/1.1 on http-0.0.0.0
    -8080
    09:19:27,156 ERROR [STDERR] 2007/07/31 09:19:27:156 GMT-03:00 [INFO] ChannelSock
    et - JK: ajp13 listening on /0.0.0.0:8009
    09:19:27,234 INFO [JkMain] Jk running ID=0 time=0/94 config=null
    09:19:27,250 INFO [Server] JBoss (MX MicroKernel) [4.0.5.GA (build: CVSTag=Bran
    ch_4_0 date=200610162339)] Started in 1m:49s:360ms
    09:19:42,843 INFO [SolutionRepositoryBase] Solution Repository name not defined
    in Pentaho.xml node solution-repository/db-repository-name
    09:19:51,593 WARN [LoggerListener] Authentication event AuthenticationSuccessEv
    ent: luis; details: org.acegisecurity.ui.WebAuthenticationDetails@0: RemoteIpAdd
    ress: 127.0.0.1; SessionId: DBBFC2D200BCB0C6845061F641C35FE8
    09:19:51,640 WARN [LoggerListener] Authentication event InteractiveAuthenticati
    onSuccessEvent: luis; details: org.acegisecurity.ui.WebAuthenticationDetails@0:
    RemoteIpAddress: 127.0.0.1; SessionId: DBBFC2D200BCB0C6845061F641C35FE8
    09:19:58,218 INFO [SolutionRepositoryBase] SOLUTION-REPOSITORY: [pt_45] Adding
    action to solution repository clean_repository.xaction
    09:20:01,218 INFO [SolutionRepositoryBase] SOLUTION-REPOSITORY: [pt_45] Adding
    action to solution repository schedule-clean.xaction
    09:20:04,343 ERROR [CachedConnectionValve] Application error: /jsp/Admin.jsp did
    not complete its transaction
    09:20:04,656 ERROR [JTATransaction] JTA commit failed
    java.lang.IllegalStateException: No transaction.
    at org.jboss.tm.TxManager.commit(TxManager.java:246)
    at org.jboss.tm.usertx.client.ServerVMClientUserTransaction.commit(Serve
    rVMClientUserTransaction.java:140)
    at org.hibernate.transaction.JTATransaction.commit(JTATransaction.java:1
    46)
    at org.pentaho.repository.HibernateUtil.commitTransaction(HibernateUtil.
    java:372)
    at org.pentaho.repository.HibernateUtil.systemExitPoint(HibernateUtil.ja
    va:612)
    at org.pentaho.core.system.StandaloneApplicationContext.invokeExitPoints
    (StandaloneApplicationContext.java:132)
    at org.pentaho.core.system.PentahoSystem.systemExitPoint(PentahoSystem.j
    ava:1277)
    at org.pentaho.ui.servlet.GetImage.doPost(GetImage.java:137)
    at org.pentaho.ui.servlet.GetImage.doGet(GetImage.java:45)
    at javax.servlet.http.HttpServlet.service(HttpServlet.java:697)
    at javax.servlet.http.HttpServlet.service(HttpServlet.java:810)
    at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(Appl
    icationFilterChain.java:252)
    at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationF
    ilterChain.java:173)
    at org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(F
    ilterChainProxy.java:264)
    at org.acegisecurity.intercept.web.FilterSecurityInterceptor.invoke(Filt
    erSecurityInterceptor.java:107)
    at org.acegisecurity.intercept.web.FilterSecurityInterceptor.doFilter(Fi
    lterSecurityInterceptor.java:72)
    at org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(F
    ilterChainProxy.java:274)
    at org.acegisecurity.ui.ExceptionTranslationFilter.doFilter(ExceptionTra
    nslationFilter.java:110)
    at org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(F
    ilterChainProxy.java:274)
    at org.acegisecurity.ui.switchuser.SwitchUserProcessingFilter.doFilter(S
    witchUserProcessingFilter.java:335)
    at org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(F
    ilterChainProxy.java:274)
    at com.pentaho.security.SecurityStartupFilter.doFilter(SecurityStartupFi
    lter.java:71)
    at org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(F
    ilterChainProxy.java:274)
    at org.acegisecurity.providers.anonymous.AnonymousProcessingFilter.doFil
    ter(AnonymousProcessingFilter.java:125)
    at org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(F
    ilterChainProxy.java:274)
    at org.acegisecurity.ui.rememberme.RememberMeProcessingFilter.doFilter(R
    ememberMeProcessingFilter.java:142)
    at org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(F
    ilterChainProxy.java:274)
    at com.pentaho.security.RequestParameterAuthenticationFilter.doFilter(Re
    questParameterAuthenticationFilter.java:160)
    at org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(F
    ilterChainProxy.java:274)
    at org.acegisecurity.ui.basicauth.BasicProcessingFilter.doFilter(BasicPr
    ocessingFilter.java:178)
    at org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(F
    ilterChainProxy.java:274)
    at org.acegisecurity.ui.AbstractProcessingFilter.doFilter(AbstractProces
    singFilter.java:217)
    at org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(F
    ilterChainProxy.java:274)
    at org.acegisecurity.ui.logout.LogoutFilter.doFilter(LogoutFilter.java:1
    08)
    at org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(F
    ilterChainProxy.java:274)
    at com.pentaho.security.HttpSessionReuseDetectionFilter.doFilter(HttpSes
    sionReuseDetectionFilter.java:142)
    at org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(F
    ilterChainProxy.java:274)
    at org.acegisecurity.context.HttpSessionContextIntegrationFilter.doFilte
    r(HttpSessionContextIntegrationFilter.java:193)
    at org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(F
    ilterChainProxy.java:274)
    at org.acegisecurity.wrapper.SecurityContextHolderAwareRequestFilter.doF
    ilter(SecurityContextHolderAwareRequestFilter.java:81)
    at org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(F
    ilterChainProxy.java:274)
    at org.acegisecurity.util.FilterChainProxy.doFilter(FilterChainProxy.jav
    a:148)
    at org.acegisecurity.util.FilterToBeanProxy.doFilter(FilterToBeanProxy.j
    ava:98)
    at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(Appl
    icationFilterChain.java:202)
    at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationF
    ilterChain.java:173)
    at org.pentaho.core.system.SystemStatusFilter.doFilter(SystemStatusFilte
    r.java:53)
    at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(Appl
    icationFilterChain.java:202)
    at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationF
    ilterChain.java:173)
    at org.jboss.web.tomcat.filters.ReplyHeaderFilter.doFilter(ReplyHeaderFi
    lter.java:96)
    at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(Appl
    icationFilterChain.java:202)
    at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationF
    ilterChain.java:173)
    at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperV
    alve.java:213)
    at org.apache.catalina.core.StandardContextValve.invoke(StandardContextV
    alve.java:178)
    at org.jboss.web.tomcat.security.SecurityAssociationValve.invoke(Securit
    yAssociationValve.java:175)
    at org.apache.catalina.authenticator.AuthenticatorBase.invoke(Authentica
    torBase.java:432)
    at org.jboss.web.tomcat.security.JaccContextValve.invoke(JaccContextValv
    e.java:74)
    at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.j
    ava:126)
    at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.j
    ava:105)
    at org.jboss.web.tomcat.tc5.jca.CachedConnectionValve.invoke(CachedConne
    ctionValve.java:156)
    at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineVal
    ve.java:107)
    at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.jav
    a:148)
    at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java
    :869)
    at org.apache.coyote.http11.Http11BaseProtocol$Http11ConnectionHandler.p
    rocessConnection(Http11BaseProtocol.java:664)
    at org.apache.tomcat.util.net.PoolTcpEndpoint.processSocket(PoolTcpEndpo
    int.java:527)
    at org.apache.tomcat.util.net.MasterSlaveWorkerThread.run(MasterSlaveWor
    kerThread.java:112)
    at java.lang.Thread.run(Thread.java:595)
    09:20:04,687 ERROR [HibernateUtil] [pt_103] HIBUTIL.ERROR_0008 - [pt_53] commitT
    ransaction() failed.
    org.hibernate.TransactionException: JTA commit failed:
    at org.hibernate.transaction.JTATransaction.commit(JTATransaction.java:1
    53)
    at org.pentaho.repository.HibernateUtil.commitTransaction(HibernateUtil.
    java:372)
    at org.pentaho.repository.HibernateUtil.systemExitPoint(HibernateUtil.ja
    va:612)
    at org.pentaho.core.system.StandaloneApplicationContext.invokeExitPoints
    (StandaloneApplicationContext.java:132)
    at org.pentaho.core.system.PentahoSystem.systemExitPoint(PentahoSystem.j
    ava:1277)
    at org.pentaho.ui.servlet.GetImage.doPost(GetImage.java:137)
    at org.pentaho.ui.servlet.GetImage.doGet(GetImage.java:45)
    at javax.servlet.http.HttpServlet.service(HttpServlet.java:697)
    at javax.servlet.http.HttpServlet.service(HttpServlet.java:810)
    at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(Appl
    icationFilterChain.java:252)
    at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationF
    ilterChain.java:173)
    at org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(F
    ilterChainProxy.java:264)
    at org.acegisecurity.intercept.web.FilterSecurityInterceptor.invoke(Filt
    erSecurityInterceptor.java:107)
    at org.acegisecurity.intercept.web.FilterSecurityInterceptor.doFilter(Fi
    lterSecurityInterceptor.java:72)
    at org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(F
    ilterChainProxy.java:274)
    at org.acegisecurity.ui.ExceptionTranslationFilter.doFilter(ExceptionTra
    nslationFilter.java:110)
    at org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(F
    ilterChainProxy.java:274)
    at org.acegisecurity.ui.switchuser.SwitchUserProcessingFilter.doFilter(S
    witchUserProcessingFilter.java:335)
    at org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(F
    ilterChainProxy.java:274)
    at com.pentaho.security.SecurityStartupFilter.doFilter(SecurityStartupFi
    lter.java:71)
    at org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(F
    ilterChainProxy.java:274)
    at org.acegisecurity.providers.anonymous.AnonymousProcessingFilter.doFil
    ter(AnonymousProcessingFilter.java:125)
    at org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(F
    ilterChainProxy.java:274)
    at org.acegisecurity.ui.rememberme.RememberMeProcessingFilter.doFilter(R
    ememberMeProcessingFilter.java:142)
    at org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(F
    ilterChainProxy.java:274)
    at com.pentaho.security.RequestParameterAuthenticationFilter.doFilter(Re
    questParameterAuthenticationFilter.java:160)
    at org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(F
    ilterChainProxy.java:274)
    at org.acegisecurity.ui.basicauth.BasicProcessingFilter.doFilter(BasicPr
    ocessingFilter.java:178)
    at org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(F
    ilterChainProxy.java:274)
    at org.acegisecurity.ui.AbstractProcessingFilter.doFilter(AbstractProces
    singFilter.java:217)
    at org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(F
    ilterChainProxy.java:274)
    at org.acegisecurity.ui.logout.LogoutFilter.doFilter(LogoutFilter.java:1
    08)
    at org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(F
    ilterChainProxy.java:274)
    at com.pentaho.security.HttpSessionReuseDetectionFilter.doFilter(HttpSes
    sionReuseDetectionFilter.java:142)
    at org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(F
    ilterChainProxy.java:274)
    at org.acegisecurity.context.HttpSessionContextIntegrationFilter.doFilte
    r(HttpSessionContextIntegrationFilter.java:193)
    at org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(F
    ilterChainProxy.java:274)
    at org.acegisecurity.wrapper.SecurityContextHolderAwareRequestFilter.doF
    ilter(SecurityContextHolderAwareRequestFilter.java:81)
    at org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(F
    ilterChainProxy.java:274)
    at org.acegisecurity.util.FilterChainProxy.doFilter(FilterChainProxy.jav
    a:148)
    at org.acegisecurity.util.FilterToBeanProxy.doFilter(FilterToBeanProxy.j
    ava:98)
    at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(Appl
    icationFilterChain.java:202)
    at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationF
    ilterChain.java:173)
    at org.pentaho.core.system.SystemStatusFilter.doFilter(SystemStatusFilte
    r.java:53)
    at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(Appl
    icationFilterChain.java:202)
    at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationF
    ilterChain.java:173)
    at org.jboss.web.tomcat.filters.ReplyHeaderFilter.doFilter(ReplyHeaderFi
    lter.java:96)
    at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(Appl
    icationFilterChain.java:202)
    at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationF
    ilterChain.java:173)
    at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperV
    alve.java:213)
    at org.apache.catalina.core.StandardContextValve.invoke(StandardContextV
    alve.java:178)
    at org.jboss.web.tomcat.security.SecurityAssociationValve.invoke(Securit
    yAssociationValve.java:175)
    at org.apache.catalina.authenticator.AuthenticatorBase.invoke(Authentica
    torBase.java:432)
    at org.jboss.web.tomcat.security.JaccContextValve.invoke(JaccContextValv
    e.java:74)
    at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.j
    ava:126)
    at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.j
    ava:105)
    at org.jboss.web.tomcat.tc5.jca.CachedConnectionValve.invoke(CachedConne
    ctionValve.java:156)
    at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineVal
    ve.java:107)
    at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.jav
    a:148)
    at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java
    :869)
    at org.apache.coyote.http11.Http11BaseProtocol$Http11ConnectionHandler.p
    rocessConnection(Http11BaseProtocol.java:664)
    at org.apache.tomcat.util.net.PoolTcpEndpoint.processSocket(PoolTcpEndpo
    int.java:527)
    at org.apache.tomcat.util.net.MasterSlaveWorkerThread.run(MasterSlaveWor
    kerThread.java:112)
    at java.lang.Thread.run(Thread.java:595)
    Caused by: java.lang.IllegalStateException: No transaction.
    at org.jboss.tm.TxManager.commit(TxManager.java:246)
    at org.jboss.tm.usertx.client.ServerVMClientUserTransaction.commit(Serve
    rVMClientUserTransaction.java:140)
    at org.hibernate.transaction.JTATransaction.commit(JTATransaction.java:1
    46)
    ... 63 more
    09:24:02,109 WARN [TransactionImpl] Transaction TransactionImpl:XidImpl[FormatI
    d=257, GlobalId=tecnol010/14, BranchQual=, localId=14] timed out. status=STATUS_
    ACTIVE

  6. #6

    Default

    All the versions all ok. I dont understand the error!!!

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Privacy Policy | Legal Notices | Safe Harbor Privacy Policy

Copyright © 2005 - 2019 Hitachi Vantara Corporation. All Rights Reserved.