[RunTime] failed to load class: com.mysql.jdbc.Driver

**laewoon** · 31/03/2011, 18h18

Bonjour à tous.

J'ai un problème lorsque j'essaye d'utiliser le genReport du RunTime.
J'ai correctement setté ma variable BIRT_HOME, mis le jar jdbc (correspond à celui que j'utilise dans birt pour créer mon rapport) dans le dossier du ReportEngine, et vérifié que j'utilisais le meme runtime que ma version de birt.

J'ai ces erreurs qui apparaissent lorsque je lance ma commande :

sh genReport.sh -f PDF -o test.pdf -p "StartDate"="2011-03-01" my_report.rptdesign

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
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
 
31 mars 2011 18:02:56 org.eclipse.birt.report.data.oda.jdbc.JDBCDriverManager loadExtraDriver
GRAVE: DriverClassLoader failed to load class: com.mysql.jdbc.Driver
java.lang.ClassNotFoundException: com.mysql.jdbc.Driver
        at org.eclipse.birt.core.framework.URLClassLoader.findClass1(URLClassLoader.java:185)
        at org.eclipse.birt.core.framework.URLClassLoader$1.run(URLClassLoader.java:154)
        at org.eclipse.birt.core.framework.URLClassLoader$1.run(URLClassLoader.java:1)
        at java.security.AccessController.doPrivileged(Native Method)
        at org.eclipse.birt.core.framework.URLClassLoader.findClass(URLClassLoader.java:149)
        at java.lang.ClassLoader.loadClass(ClassLoader.java:321)
        at java.lang.ClassLoader.loadClass(ClassLoader.java:266)
        at org.eclipse.birt.report.data.oda.jdbc.JDBCDriverManager.loadExtraDriver(JDBCDriverManager.java:919)
        at org.eclipse.birt.report.data.oda.jdbc.JDBCDriverManager.findDriver(JDBCDriverManager.java:738)
        at org.eclipse.birt.report.data.oda.jdbc.JDBCDriverManager.registerDriver(JDBCDriverManager.java:879)
        at org.eclipse.birt.report.data.oda.jdbc.JDBCDriverManager.loadAndRegisterDriver(JDBCDriverManager.java:862)
        at org.eclipse.birt.report.data.oda.jdbc.JDBCDriverManager.doConnect(JDBCDriverManager.java:246)
        at org.eclipse.birt.report.data.oda.jdbc.JDBCDriverManager.getConnection(JDBCDriverManager.java:212)
        at org.eclipse.birt.report.data.oda.jdbc.Connection.connectByUrl(Connection.java:237)
        at org.eclipse.birt.report.data.oda.jdbc.Connection.open(Connection.java:162)
        at org.eclipse.datatools.connectivity.oda.consumer.helper.OdaConnection.open(OdaConnection.java:250)
        at org.eclipse.birt.data.engine.odaconsumer.ConnectionManager.openConnection(ConnectionManager.java:165)
        at org.eclipse.birt.data.engine.executor.DataSource.newConnection(DataSource.java:224)
        at org.eclipse.birt.data.engine.executor.DataSource.open(DataSource.java:212)
        at org.eclipse.birt.data.engine.impl.DataSourceRuntime.openOdiDataSource(DataSourceRuntime.java:208)
        at org.eclipse.birt.data.engine.impl.QueryExecutor.openDataSource(QueryExecutor.java:406)
        at org.eclipse.birt.data.engine.impl.QueryExecutor.prepareExecution(QueryExecutor.java:316)
        at org.eclipse.birt.data.engine.impl.PreparedQuery.doPrepare(PreparedQuery.java:455)
        at org.eclipse.birt.data.engine.impl.PreparedDataSourceQuery.produceQueryResults(PreparedDataSourceQuery.java:190)
        at org.eclipse.birt.data.engine.impl.PreparedDataSourceQuery.execute(PreparedDataSourceQuery.java:178)
        at org.eclipse.birt.data.engine.impl.PreparedOdaDSQuery.execute(PreparedOdaDSQuery.java:145)
        at org.eclipse.birt.report.data.adapter.impl.DataRequestSessionImpl.execute(DataRequestSessionImpl.java:616)
        at org.eclipse.birt.report.engine.data.dte.DteDataEngine.doExecuteQuery(DteDataEngine.java:152)
        at org.eclipse.birt.report.engine.data.dte.AbstractDataEngine.execute(AbstractDataEngine.java:265)
        at org.eclipse.birt.report.engine.executor.ExecutionContext.executeQuery(ExecutionContext.java:1890)
        at org.eclipse.birt.report.engine.executor.QueryItemExecutor.executeQuery(QueryItemExecutor.java:80)
        at org.eclipse.birt.report.engine.executor.TableItemExecutor.execute(TableItemExecutor.java:62)
        at org.eclipse.birt.report.engine.internal.executor.dup.SuppressDuplicateItemExecutor.execute(SuppressDuplicateItemExecutor.java:43)
        at org.eclipse.birt.report.engine.internal.executor.wrap.WrappedReportItemExecutor.execute(WrappedReportItemExecutor.java:46)
        at org.eclipse.birt.report.engine.internal.executor.l18n.LocalizedReportItemExecutor.execute(LocalizedReportItemExecutor.java:34)
        at org.eclipse.birt.report.engine.layout.html.HTMLBlockStackingLM.layoutNodes(HTMLBlockStackingLM.java:65)
        at org.eclipse.birt.report.engine.layout.html.HTMLPageLM.layout(HTMLPageLM.java:90)
        at org.eclipse.birt.report.engine.layout.html.HTMLReportLayoutEngine.layout(HTMLReportLayoutEngine.java:99)
        at org.eclipse.birt.report.engine.api.impl.RunAndRenderTask.doRun(RunAndRenderTask.java:180)
        at org.eclipse.birt.report.engine.api.impl.RunAndRenderTask.run(RunAndRenderTask.java:77)
        at org.eclipse.birt.report.engine.api.ReportRunner.runAndRenderReport(ReportRunner.java:223)
        at org.eclipse.birt.report.engine.api.ReportRunner.execute(ReportRunner.java:163)
        at org.eclipse.birt.report.engine.api.ReportRunner.main(ReportRunner.java:122)
31 mars 2011 18:02:56 org.eclipse.birt.report.data.oda.jdbc.JDBCDriverManager loadExtraDriver
GRAVE: refreshUrlsWhenFail: true
31 mars 2011 18:02:56 org.eclipse.birt.report.data.oda.jdbc.JDBCDriverManager loadExtraDriver
GRAVE: driverClassPath: null
31 mars 2011 18:02:56 org.eclipse.birt.report.data.oda.jdbc.JDBCDriverManager loadExtraDriver
GRAVE: Registered URLs: 
31 mars 2011 18:02:56 org.eclipse.birt.report.data.oda.jdbc.JDBCDriverManager findDriver
ATTENTION: Failed to load JDBC driver class: com.mysql.jdbc.Driver
31 mars 2011 18:02:56 org.eclipse.birt.data.engine.odaconsumer.ConnectionManager openConnection
GRAVE: Unable to open connection.
org.eclipse.birt.report.data.oda.jdbc.JDBCException: Cannot load JDBC Driver class: com.mysql.jdbc.Driver.
        at org.eclipse.birt.report.data.oda.jdbc.JDBCDriverManager.findDriver(JDBCDriverManager.java:760)
        at org.eclipse.birt.report.data.oda.jdbc.JDBCDriverManager.registerDriver(JDBCDriverManager.java:879)
        at org.eclipse.birt.report.data.oda.jdbc.JDBCDriverManager.loadAndRegisterDriver(JDBCDriverManager.java:862)
        at org.eclipse.birt.report.data.oda.jdbc.JDBCDriverManager.doConnect(JDBCDriverManager.java:246)
        at org.eclipse.birt.report.data.oda.jdbc.JDBCDriverManager.getConnection(JDBCDriverManager.java:212)
        at org.eclipse.birt.report.data.oda.jdbc.Connection.connectByUrl(Connection.java:237)
        at org.eclipse.birt.report.data.oda.jdbc.Connection.open(Connection.java:162)
        at org.eclipse.datatools.connectivity.oda.consumer.helper.OdaConnection.open(OdaConnection.java:250)
        at org.eclipse.birt.data.engine.odaconsumer.ConnectionManager.openConnection(ConnectionManager.java:165)
        at org.eclipse.birt.data.engine.executor.DataSource.newConnection(DataSource.java:224)
        at org.eclipse.birt.data.engine.executor.DataSource.open(DataSource.java:212)
        at org.eclipse.birt.data.engine.impl.DataSourceRuntime.openOdiDataSource(DataSourceRuntime.java:208)
        at org.eclipse.birt.data.engine.impl.QueryExecutor.openDataSource(QueryExecutor.java:406)
        at org.eclipse.birt.data.engine.impl.QueryExecutor.prepareExecution(QueryExecutor.java:316)
        at org.eclipse.birt.data.engine.impl.PreparedQuery.doPrepare(PreparedQuery.java:455)
        at org.eclipse.birt.data.engine.impl.PreparedDataSourceQuery.produceQueryResults(PreparedDataSourceQuery.java:190)
        at org.eclipse.birt.data.engine.impl.PreparedDataSourceQuery.execute(PreparedDataSourceQuery.java:178)
        at org.eclipse.birt.data.engine.impl.PreparedOdaDSQuery.execute(PreparedOdaDSQuery.java:145)
        at org.eclipse.birt.report.data.adapter.impl.DataRequestSessionImpl.execute(DataRequestSessionImpl.java:616)
        at org.eclipse.birt.report.engine.data.dte.DteDataEngine.doExecuteQuery(DteDataEngine.java:152)
        at org.eclipse.birt.report.engine.data.dte.AbstractDataEngine.execute(AbstractDataEngine.java:265)
        at org.eclipse.birt.report.engine.executor.ExecutionContext.executeQuery(ExecutionContext.java:1890)
        at org.eclipse.birt.report.engine.executor.QueryItemExecutor.executeQuery(QueryItemExecutor.java:80)
        at org.eclipse.birt.report.engine.executor.TableItemExecutor.execute(TableItemExecutor.java:62)
        at org.eclipse.birt.report.engine.internal.executor.dup.SuppressDuplicateItemExecutor.execute(SuppressDuplicateItemExecutor.java:43)
        at org.eclipse.birt.report.engine.internal.executor.wrap.WrappedReportItemExecutor.execute(WrappedReportItemExecutor.java:46)
        at org.eclipse.birt.report.engine.internal.executor.l18n.LocalizedReportItemExecutor.execute(LocalizedReportItemExecutor.java:34)
        at org.eclipse.birt.report.engine.layout.html.HTMLBlockStackingLM.layoutNodes(HTMLBlockStackingLM.java:65)
        at org.eclipse.birt.report.engine.layout.html.HTMLPageLM.layout(HTMLPageLM.java:90)
        at org.eclipse.birt.report.engine.layout.html.HTMLReportLayoutEngine.layout(HTMLReportLayoutEngine.java:99)
        at org.eclipse.birt.report.engine.api.impl.RunAndRenderTask.doRun(RunAndRenderTask.java:180)
        at org.eclipse.birt.report.engine.api.impl.RunAndRenderTask.run(RunAndRenderTask.java:77)
        at org.eclipse.birt.report.engine.api.ReportRunner.runAndRenderReport(ReportRunner.java:223)
        at org.eclipse.birt.report.engine.api.ReportRunner.execute(ReportRunner.java:163)
        at org.eclipse.birt.report.engine.api.ReportRunner.main(ReportRunner.java:122)

Quelqu'un aurait-il un coup de main à me proposer svp ?

D'avance merci,

L.

PS : j'utilise Birt 2.6.1 et le Runtime correspondant.

**Stefan C** · 31/03/2011, 19h23

Vous avez mis ou le pilote JDBC de MySQL?

C'est clairement la source de l'erreur.

**laewoon** · 01/04/2011, 09h33

Bonjour,

Ici :

birt_runtime_2_6_1/ReportEngine/plugins/org.eclipse.birt.report.data.oda.jdbc_2.6.1.v20100909/

**galel** · 01/04/2011, 09h40

Il faut le mettre dans le répertoire "driver" du répertoire

birt_runtime_2_6_1/ReportEngine/plugins/org.eclipse.birt.report.data.oda.jdbc_2.6.1.v20100909/

**laewoon** · 01/04/2011, 12h14

Exact ça marche, merci !

[RunTime] failed to load class: com.mysql.jdbc.Driver

BIRT

Discussions similaires

Partager

Partager