IdentifiantMot de passe
Loading...
Mot de passe oublié ?Je m'inscris ! (gratuit)
Navigation

Inscrivez-vous gratuitement
pour pouvoir participer, suivre les réponses en temps réel, voter pour les messages, poser vos propres questions et recevoir la newsletter

SpagoBI Discussion :

Cannot open the connection for the driver: org.eclipse.birt.report.data.oda.jdbc.dbprofile


Sujet :

SpagoBI

  1. #1
    Membre régulier
    Profil pro
    Inscrit en
    mai 2009
    Messages
    212
    Détails du profil
    Informations personnelles :
    Localisation : Belgique

    Informations forums :
    Inscription : mai 2009
    Messages : 212
    Points : 71
    Points
    71
    Par défaut Cannot open the connection for the driver: org.eclipse.birt.report.data.oda.jdbc.dbprofile
    Salut,
    J'ai un problème lorsque j'exécute un rapport birt sur le server spago.
    Spago :3.6
    Database : PostgreSQL
    -Birt : Report Preview OK, J'arrive bien à récupérer les données.
    -Spago Server : Datasource OK, Lovs : J'arrive bien à alimenter la lov en données depouis la base.
    -Report execution on the server : Loading ok ( Je vois titre,en-tête,etc.)
    Mais pas les données de la base.
    J'ai l'erreur suivante:

    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
    94
    95
    96
     
    The following items have errors:  
    Table (id = 51):  
    - An exception occurred during processing. Please see the following message for details:  
    Cannot open the connection for the driver: org.eclipse.birt.report.data.oda.jdbc.dbprofile.  
    org.eclipse.datatools.connectivity.oda.OdaException ;  
    java.lang.Exception: Driver definition could not be found.  
     
    exception.error ( 1 time(s) )  
    detail : org.eclipse.birt.report.engine.api.EngineException: An exception occurred during processing. Please see the following message for details:  
    Cannot open the connection for the driver: org.eclipse.birt.report.data.oda.jdbc.dbprofile.  
    org.eclipse.datatools.connectivity.oda.OdaException ;  
    java.lang.Exception: Driver definition could not be found.  
    at org.eclipse.birt.report.engine.executor.ExecutionContext.addException(ExecutionContext.java:1195)  
    at org.eclipse.birt.report.engine.executor.ExecutionContext.addException(ExecutionContext.java:1174)  
    at org.eclipse.birt.report.engine.executor.QueryItemExecutor.executeQuery(QueryItemExecutor.java:96)  
    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 it.eng.spagobi.engines.birt.BirtReportServlet.runReport(BirtReportServlet.java:690)  
    at it.eng.spagobi.engines.birt.BirtReportServlet.service(BirtReportServlet.java:159)  
    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 it.eng.spagobi.utilities.filters.SpagoBIAccessFilter.doFilter(SpagoBIAccessFilter.java:193)  
    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:662)  
    Caused by: org.eclipse.birt.report.data.adapter.api.AdapterException: An exception occurred during processing. Please see the following message for details:  
    Cannot open the connection for the driver: org.eclipse.birt.report.data.oda.jdbc.dbprofile.  
    org.eclipse.datatools.connectivity.oda.OdaException ;  
    java.lang.Exception: Driver definition could not be found.  
    at org.eclipse.birt.report.data.adapter.impl.DataRequestSessionImpl.execute(DataRequestSessionImpl.java:637)  
    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:1876)  
    at org.eclipse.birt.report.engine.executor.QueryItemExecutor.executeQuery(QueryItemExecutor.java:80)  
    ... 27 more  
    Caused by: org.eclipse.birt.data.engine.odaconsumer.OdaDataException: Cannot open the connection for the driver: org.eclipse.birt.report.data.oda.jdbc.dbprofile.  
    org.eclipse.datatools.connectivity.oda.OdaException ;  
    java.lang.Exception: Driver definition could not be found.  
    at org.eclipse.birt.data.engine.odaconsumer.ExceptionHandler.newException(ExceptionHandler.java:54)  
    at org.eclipse.birt.data.engine.odaconsumer.ConnectionManager.openConnection(ConnectionManager.java:177)  
    at org.eclipse.birt.data.engine.executor.DataSource.newConnection(DataSource.java:222)  
    at org.eclipse.birt.data.engine.executor.DataSource.open(DataSource.java:210)  
    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:448)  
    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:617)  
    ... 31 more  
    Caused by: org.eclipse.datatools.connectivity.oda.OdaException ;  
    java.lang.Exception: Driver definition could not be found.  
    at org.eclipse.birt.report.data.oda.jdbc.dbprofile.impl.Connection.open(Connection.java:113)  
    at org.eclipse.birt.report.data.oda.jdbc.dbprofile.impl.Connection.open(Connection.java:57)  
    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)  
    ... 41 more  
    Caused by: java.lang.Exception: Driver definition could not be found.  
    at org.eclipse.datatools.connectivity.DriverConnectionBase.getDriverDefinition(DriverConnectionBase.java:140)  
    at org.eclipse.datatools.connectivity.DriverConnectionBase.internalCreateConnection(DriverConnectionBase.java:100)  
    at org.eclipse.datatools.connectivity.DriverConnectionBase.open(DriverConnectionBase.java:54)  
    at org.eclipse.datatools.enablement.internal.postgresql.PostgreSQLJDBCConnection.<init>(PostgreSQLJDBCConnection.java:47)  
    at org.eclipse.datatools.enablement.internal.postgresql.PostgreSQLConnectionFactory.createConnection(PostgreSQLConnectionFactory.java:51)  
    at org.eclipse.datatools.connectivity.internal.ConnectionFactoryProvider.createConnection(ConnectionFactoryProvider.java:83)  
    at org.eclipse.datatools.connectivity.internal.ConnectionProfile.createConnection(ConnectionProfile.java:358)  
    at org.eclipse.datatools.connectivity.sqm.internal.core.connection.ConnectionInfoImpl.initializeJDBCConnection(ConnectionInfoImpl.java:659)  
    at org.eclipse.datatools.connectivity.sqm.internal.core.connection.ConnectionInfoImpl.<init>(ConnectionInfoImpl.java:644)  
    at org.eclipse.datatools.connectivity.sqm.internal.core.connection.ConnectionFactory.createConnection(ConnectionFactory.java:38)  
    at org.eclipse.datatools.connectivity.sqm.core.SQMConnectionFactory.createConnection(SQMConnectionFactory.java:45)  
    at org.eclipse.datatools.connectivity.sqm.internal.core.connection.ConnectionFactory.createConnection(ConnectionFactory.java:59)  
    at org.eclipse.datatools.connectivity.internal.ConnectionFactoryAdapterProvider.createConnection(ConnectionFactoryAdapterProvider.java:114)  
    at org.eclipse.datatools.connectivity.internal.ManagedConnection.createConnection(ManagedConnection.java:163)  
    at org.eclipse.datatools.connectivity.internal.CreateConnectionJob.run(CreateConnectionJob.java:56)  
    at org.eclipse.core.internal.jobs.Worker.run(Worker.java:54)  
    Caused by: java.lang.Throwable: DriverConnectionBase.error.driverDefinitionNotFound  
    at org.eclipse.datatools.connectivity.DriverConnectionBase.getDriverDefinition(DriverConnectionBase.java:141)  
    ... 15 more
    J'ai checké ce répertoire: "\SpagoBI_server\webapps\SpagoBIBirtReportEngine\WEB-INF\platform\plugins"
    Le jar :org.eclipse.birt.report.data.oda.jdbc.dbprofile_2.6.1.v20100909 est présent.
    Quelqu'un aurait une idée?
    Vinc.

  2. #2
    Membre régulier
    Profil pro
    Inscrit en
    mai 2009
    Messages
    212
    Détails du profil
    Informations personnelles :
    Localisation : Belgique

    Informations forums :
    Inscription : mai 2009
    Messages : 212
    Points : 71
    Points
    71
    Par défaut
    Salut, j'ai finalement trouvé l'origine du problème.
    Sous birt, la datasource choisie était celle destinée au query builder. J'ai changé avec une datasource de type adéquat et ça fonctionne.
    Vinc

  3. #3
    Candidat au Club
    Inscrit en
    juillet 2013
    Messages
    2
    Détails du profil
    Informations forums :
    Inscription : juillet 2013
    Messages : 2
    Points : 2
    Points
    2
    Par défaut
    Je rencontre le même problème.
    Merci de m'éclairer avec votre solution.

+ Répondre à la discussion
Cette discussion est résolue.

Discussions similaires

  1. Réponses: 1
    Dernier message: 06/05/2015, 12h47
  2. Réponses: 0
    Dernier message: 17/12/2012, 15h17
  3. Réponses: 1
    Dernier message: 22/04/2010, 13h24
  4. Réponses: 30
    Dernier message: 12/01/2009, 10h08
  5. Réponses: 5
    Dernier message: 19/11/2007, 11h10

Partager

Partager
  • Envoyer la discussion sur Viadeo
  • Envoyer la discussion sur Twitter
  • Envoyer la discussion sur Google
  • Envoyer la discussion sur Facebook
  • Envoyer la discussion sur Digg
  • Envoyer la discussion sur Delicious
  • Envoyer la discussion sur MySpace
  • Envoyer la discussion sur Yahoo