Hitachi Vantara Pentaho Community Forums
Results 1 to 8 of 8

Thread: Report Designer & Oracle

  1. #1

    Default Report Designer & Oracle

    Hoping to work around the problem with the Report Wizard, I tried the Report Designer RC. There seems to be a problem creating a JNDI connection to an Oracle database.

    The driver is fine and properly positioned, the connection details are fine (both work through other tools). I encounter the error when I try to test the data connetion: Could Not Establish Connection oracle.jdbc.driver.OracleDriver.

    Chris

  2. #2
    Join Date
    Nov 1999
    Posts
    579

    Default Re:Report Designer & Oracle

    I'm afraid there isn't quite enough information provided to help you with your problem.

    I suggest reading the following forum post on how to ask your question with enough detail to be able to answer it.

    http://forums.pentaho.org/showthread.php?t=26490

    Take care,

    Marc

  3. #3

    Default Re:Report Designer & Oracle

    Hi Marc,

    My post wasn't a request for help, but a bug report for the Report Designer release candidate. It was my understanding that this was the right place for such a report. My apologies for any confusion.

    Cheers,

    Chris

  4. #4
    Join Date
    Nov 1999
    Posts
    579

    Default Re:Report Designer & Oracle

    Hey Chris,

    No problem, and thanks for the information. But even for a bug report, there simply isn't enough information to create a JIRA case.

    Minimally, we'd need:

    a- Where you put the driver

    b- What driver are you using - the OCI or thin driver.

    c- What is the stack trace saying? If you don't see a stack trace, modify the .bat file (or .sh file) and change the invocation from javaw to java. Then, you'd see a stack trace.

    d- What is the exact driver information you've provided that seems not to work. This includes the driver class name, and the URL.

    Thanks,

    Marc

  5. #5
    Join Date
    Sep 2006
    Posts
    11

    Default Re:Report Designer & Oracle

    I can confirm this as well,

    Works in 1.1.6 Not in 1.1.7

    Hope to have an update soon!


    EDIT!

    Found the problem.


    Added Classes12 to the StartDesigner.bat file classpath

    e.g.

    start javaw -cp lib\\ReportDesigner.jar;lib\\annotations.jar;lib\\classes12.jar;............

    Note. File has to be placed in this location as well!

    Hope This Helps sombody!!!!

    Post edited by: cruel_world, at: 2006/09/18 18:51

  6. #6

    Default Re:Report Designer & Oracle

    Classes12 isn't in the download...can you attach it here?

  7. #7
    Join Date
    Sep 2006
    Posts
    11

    Default Re:Report Designer & Oracle

    You can get it from Oracle or from Version 1.1.6

  8. #8
    Join Date
    Oct 2006
    Posts
    18

    Default Re:Report Designer & Oracle

    This had been been a problem for me as well until I got here. Just wanted to say thanks for the fix info.

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.