Hitachi Vantara Pentaho Community Forums
Results 1 to 3 of 3

Thread: add database to report designer

  1. #1
    Join Date
    Feb 2007
    Posts
    1

    Default add database to report designer

    I was trying to add a mysql database to the report designer, but it was imposible I always got a message: couldn't stablished connection: com.mysql.jdbc.Driver, or if I tried to use org.gjt.mysql.jdb.Driver I got the same message, could someone please help me to solver my problem

  2. #2
    Join Date
    Jan 2007
    Posts
    20

    Default

    Follow the steps listed in http://www.nicholasgoodman.com/bt/bl...-own-database/

    And also make sure to add jar files in to

    Pentaho-report-design-wizard-1.2.0.373.GA\lib\jdbc

    And also edit the XML file jdbc.xml in

    pentaho-report-design-wizard-1.2.0.373.GA\resources\solutions\system\simple-jndi
    Last edited by rpayyavula; 02-07-2007 at 06:00 AM.

  3. #3

    Thumbs down Same problem

    When i add in resources\solutions\system\simple-jndi\jdbc.properties my jdbc definition, and my JAR in the lib/jdbc folder
    I gad :

    +> i know this datasource is correctly declared , it works with report wizard....

    java.lang.NoClassDefFoundError: javax/resource/spi/ConnectionManager
    at java.lang.ClassLoader.defineClass1(Native Method)
    at java.lang.ClassLoader.defineClass(Unknown Source)
    at java.security.SecureClassLoader.defineClass(Unknown Source)
    at java.net.URLClassLoader.defineClass(Unknown Source)
    at java.net.URLClassLoader.access$100(Unknown Source)
    at java.net.URLClassLoader$1.run(Unknown Source)
    at java.security.AccessController.doPrivileged(Native Method)
    at java.net.URLClassLoader.findClass(Unknown Source)
    at java.lang.ClassLoader.loadClass(Unknown Source)
    at java.lang.ClassLoader.loadClass(Unknown Source)
    at java.lang.ClassLoader.loadClassInternal(Unknown Source)
    at java.lang.Class.forName0(Native Method)
    at java.lang.Class.forName(Unknown Source)
    at org.pentaho.reportdesigner.crm.report.datasetplugin.jdbc.ClasspathSearcher.findDrivers(ClasspathSearcher.java:179)
    at org.pentaho.reportdesigner.crm.report.datasetplugin.jdbc.ClasspathSearcher.<init>(ClasspathSearcher.java:126)
    at org.pentaho.reportdesigner.crm.report.datasetplugin.jdbc.ClasspathSearcher.<clinit>(ClasspathSearcher.java:50)
    at org.pentaho.reportdesigner.crm.report.datasetplugin.jdbc.JDBCClassLoader.getConnection(JDBCClassLoader.java:75)
    at org.pentaho.reportdesigner.crm.report.datasetplugin.sampledb.SampleDB.initSampleDB(SampleDB.java:33)
    at org.pentaho.reportdesigner.crm.report.Rep
    ortDialog$2.run(ReportDialog.java:308)



    Please Help

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.