bonjour,
voila quand je execute ce code :
même si j'ai dans l'objet conInfo tout les information concernant la connexion a la base de données
Code : Sélectionner tout - Visualiser dans une fenêtre à part
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49 static final String REPORT_NAME = "rep1.rpt"; static final String EXPORT_FILE = "C:\\rep1.pdf"; ReportClientDocument reportClientDoc = new ReportClientDocument(); reportClientDoc.open(REPORT_NAME, 0); IReportSource repSrc = reportClientDoc.getReportSource(); ConnectionInfos conInfos = new ConnectionInfos(); ConnectionInfo conInfo = new ConnectionInfo(); conInfo.setUserName("mylog"); conInfo.setPassword("mypass"); conInfo.setKind(ConnectionInfoKind.SQL); Fields parameterFields = new Fields(); Values values2 = new Values(); ParameterField parameterField2 = new ParameterField(); parameterField2.setReportName(""); parameterField2.setName("p_dn"); ParameterFieldDiscreteValue parameterFieldDiscreteValue2 = new ParameterFieldDiscreteValue(); parameterFieldDiscreteValue2.setValue("1287"); values2.add(parameterFieldDiscreteValue2); parameterField2.setCurrentValues(values2); parameterFields.add(parameterField2); PropertyBag propertyBag = new PropertyBag(); propertyBag.put("Database Class Name","oracle.jdbc.driver.OracleDriver"); propertyBag.put("Connection URL","jdbc:oracle:thin:@10.100.0.143:1521:DBQ"); conInfo.setAttributes(propertyBag); conInfos.add(conInfo); ExportOptions expOpt = new ExportOptions(); expOpt.setExportFormatType(ReportExportFormat.PDF); PDFExportFormatOptions pdfExpOpt = new PDFExportFormatOptions(); expOpt.setFormatOptions(pdfExpOpt); ReportStateInfoImpl repStateInfo = new ReportStateInfoImpl(); repStateInfo.setParameterFields(parameterFields); repStateInfo.setDatabaseLogOnInfos(conInfos); RequestContextImpl reqCont = new RequestContextImpl(); reqCont.setReportStateInfo(repStateInfo); System.out.println("******************"+reqCont+"****************"); InputStream byteArrayInputStream = repSrc.export(expOpt, reqCont); System.out.println("****************** 7 ****************"); // Release report. reportClientDoc.close();
j'ai cette l'exeption cousee par la ligne suivant :
InputStream byteArrayInputStream = repSrc.export(expOpt, reqCont);
je suis vraiment bloquée sur ca je n'ai plus d'aidéecom.crystaldecisions.sdk.occa.report.lib.ReportSDKLogonException: Echec de la connexion à la base de données. Code d'erreur du fournisseur de la base de données : 17443---- Error code:-2147217393 Error code name:dbLogonFailed
at com.businessobjects.reports.sdk.JRCCommunicationAdapter.a(Unknown Source)
at com.businessobjects.reports.sdk.JRCCommunicationAdapter.request(Unknown Source)
at com.crystaldecisions.proxy.remoteagent.x.a(Unknown Source)
at com.crystaldecisions.proxy.remoteagent.q.a(Unknown Source)
at com.crystaldecisions.sdk.occa.report.application.dd.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.ReportSource.export(Unknown Source)
at com.crystaldecisions.sdk.occa.report.application.AdvancedReportSource.export(Unknown Source)
at com.crystaldecisions.sdk.occa.report.application.NonDCPAdvancedReportSource.export(Unknown Source)
at com.crystaldecisions.reports.reportengineinterface.JPEReportSource.export(Unknown Source)
at ExportTest.main(ExportTest.java:93)
Caused by: com.businessobjects.reports.sdk.d: Echec de la connexion à la base de données. Code d'erreur du fournisseur de la base de données : 17443
at com.businessobjects.reports.sdk.b.b.byte(Unknown Source)
at com.businessobjects.reports.sdk.b.b.int(Unknown Source)
... 11 more
Caused by: com.crystaldecisions.reports.queryengine.bn: Erreur de connexion : Utilisateur ou mot de passe NULL non pris en charge par le pilote THIN
at com.crystaldecisions.reports.queryengine.driverImpl.o.if(Unknown Source)
at com.crystaldecisions.reports.queryengine.ax.new(Unknown Source)
at com.crystaldecisions.reports.queryengine.ax.byte(Unknown Source)
at com.crystaldecisions.reports.reportdefinition.datainterface.a.a(Unknown Source)
at com.crystaldecisions.reports.reportdefinition.datainterface.a.a(Unknown Source)
at com.crystaldecisions.reports.reportdefinition.datainterface.a.a(Unknown Source)
at com.crystaldecisions.reports.reportdefinition.datainterface.a.a(Unknown Source)
at com.crystaldecisions.reports.reportdefinition.datainterface.g.a(Unknown Source)
... 13 more
donc j'attend votre aide
Merci d'avance
Partager