Discussion :

[ZULL]

Bonjour,

Je bloc sur l'erreur suivante :

lorsque je crée un rpt avec avec une requête comprenant un paramètre variable.
:

Code :

Sélectionner tout - Visualiser dans une fenêtre à part

Select personne_name where personne_id = ?person_id

j'ais une erreur.

en revanche je n'est pas d'erreur sur d'autre paramètre en dehors des requêtes.

En vous remerciant d'avance

37:4537 - ERROR - [JRCCommunicationAdapter ] - detected an exception: Impossible de charger le connecteur de base de données com.crystaldecisions.reports.queryengine.driverImpl.DriverLoader.
at com.crystaldecisions.reports.queryengine.Connection.uB(Unknown Source)
at com.crystaldecisions.reports.queryengine.Connection.br(Unknown Source)
at com.crystaldecisions.reports.queryengine.Connection.bs(Unknown Source)
at com.crystaldecisions.reports.queryengine.Connection.t1(Unknown Source)
at com.crystaldecisions.reports.datafoundation.DFQuery.try(Unknown Source)
at com.crystaldecisions.reports.datafoundation.DFQuery.for(Unknown Source)
at com.crystaldecisions.reports.datalayer.a.do(Unknown Source)
at com.crystaldecisions.reports.datalayer.a.a(Unknown Source)
at com.crystaldecisions.reports.dataengine.m.b(Unknown Source)
at com.crystaldecisions.reports.dataengine.j.b(Unknown Source)
at com.crystaldecisions.reports.dataengine.m.o(Unknown Source)
at com.crystaldecisions.reports.dataengine.m.a(Unknown Source)
at com.crystaldecisions.reports.dataengine.ContextNode.a(Unknown Source)
at com.crystaldecisions.reports.dataengine.ContextNode.a(Unknown Source)
at com.crystaldecisions.reports.dataengine.j.case(Unknown Source)
at com.crystaldecisions.reports.dataengine.h.<init>(Unknown Source)
at com.crystaldecisions.reports.dataengine.DataContext.a(Unknown Source)
at com.crystaldecisions.reports.dataengine.DataProcessor2.a(Unknown Source)
at com.crystaldecisions.reports.dataengine.DataProcessor2.a(Unknown Source)
at com.crystaldecisions.reports.dataengine.DataProcessor2.new(Unknown Source)
at com.crystaldecisions.reports.dataengine.DataProcessor2.try(Unknown Source)
at com.crystaldecisions.reports.dataengine.DataProcessor2.int(Unknown Source)
at com.crystaldecisions.reports.dataengine.DataProcessor2.I(Unknown Source)
at com.crystaldecisions.reports.formatter.formatter.objectformatter.ObjectFormatter.fl(Unknown Source)
at com.crystaldecisions.reports.formatter.formatter.paginator.PageFormatter.if(Unknown Source)
at com.crystaldecisions.reports.formatter.formatter.paginator.PageFormatter.a(Unknown Source)
at com.crystaldecisions.reports.formatter.formatter.paginator.PageFormatter.X(Unknown Source)
at com.crystaldecisions.reports.formatter.formatter.paginator.PageFormatter.moveToPageN(Unknown Source)
at com.crystaldecisions.reports.formatter.export2.a.a(Unknown Source)
at com.crystaldecisions.reports.formatter.export2.a.a(Unknown Source)
at com.crystaldecisions.reports.formatter.export2.ExportSupervisorEx.if(Unknown Source)
at com.crystaldecisions.reports.formatter.export2.ExportSupervisorEx.a(Unknown Source)
at com.businessobjects.reports.sdk.requesthandler.ReportViewingRequestHandler.a(Unknown Source)
at com.businessobjects.reports.sdk.requesthandler.ReportViewingRequestHandler.int(Unknown Source)
at com.businessobjects.reports.sdk.JRCCommunicationAdapter.do(Unknown Source)
at com.businessobjects.reports.sdk.JRCCommunicationAdapter.if(Unknown Source)
at com.businessobjects.reports.sdk.JRCCommunicationAdapter.a(Unknown Source)
at com.businessobjects.reports.sdk.JRCCommunicationAdapter$2.a(Unknown Source)
at com.businessobjects.reports.sdk.JRCCommunicationAdapter$2.call(Unknown Source)
at com.crystaldecisions.reports.common.ThreadGuard.syncExecute(Unknown Source)
at com.businessobjects.reports.sdk.JRCCommunicationAdapter.for(Unknown Source)
at com.businessobjects.reports.sdk.JRCCommunicationAdapter.int(Unknown Source)
at com.businessobjects.reports.sdk.JRCCommunicationAdapter.request(Unknown Source)
at com.businessobjects.sdk.erom.jrc.a.a(Unknown Source)
at com.businessobjects.sdk.erom.jrc.a.execute(Unknown Source)
at com.crystaldecisions.proxy.remoteagent.RemoteAgent$a.execute(Unknown Source)
at com.crystaldecisions.proxy.remoteagent.CommunicationChannel.a(Unknown Source)
at com.crystaldecisions.proxy.remoteagent.RemoteAgent.a(Unknown Source)
at com.crystaldecisions.sdk.occa.report.application.ds.a(Unknown Source)
at com.crystaldecisions.sdk.occa.report.application.ReportSource.a(Unknown Source)
at com.crystaldecisions.sdk.occa.report.application.ReportSource.a(Unknown Source)
at com.crystaldecisions.sdk.occa.report.application.PrintOutputController.if(Unknown Source)
at com.crystaldecisions.sdk.occa.report.application.PrintOutputController.export(Unknown Source)
at com.crystaldecisions.sdk.occa.report.application.PrintOutputController.export(Unknown Source)
at com.crystaldecisions.sdk.occa.report.application.PrintOutputController.export(Unknown Source)
at tlmcom.welStat.CrystalReports.convertirParCrystalArgumentsId(CrystalReports.java:317)
at tlmcom.welStat.WelStatCrystalReports.convertir(WelStatCrystalReports.java:303)
at tlmcom.welStat.WelStat.chargerPdfEmissionRapport(WelStat.java:1297)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
at java.lang.reflect.Method.invoke(Method.java:597)
at tlmcom.TlmComServlet.invokeApplication(TlmComServlet.java:188)
at tlmcom.TlmComServlet.service(TlmComServlet.java:90)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:717)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
at db.queries.HibernateFilter.doFilter(HibernateFilter.java:32)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:233)
at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:191)
at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:128)
at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:102)
at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109)
at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:286)
at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:845)
at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:583)
at org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:447)
at java.lang.Thread.run(Thread.java:619)

Si quelqu'un est deja passe par la merci pour votre aide

[dehian]

Salut, si tu n'utilises qu'une table dans ta requete tu peux surcharger avec le contenu d'un resultset comme dans l'exemple que j'ai mis dans mon dernier post (dans le zip test2.jsp et test2.rpt)

http://www.developpez.net/forums/d82...etes-jointure/