Jump to content
  • Connecting iReport to an Oracle Datasource

    • Features: Custom Data Sources, Data Sources Skill: Intermediate

    [toc on_off::hide=1]

    The following are steps that can be followed to set up a data source within iReport to connect to an Oracle database:

    Note:These instructions will work for iReport version 3.1 and greater.

    1. Download the JDBC driver (ojdbc-[your version].jar) from Oracle @ http://www.oracle.com/technetwork/database/features/jdbc/index-091264.html
    2. in iReport, go to the following menu Window =>Services
    3. Expand the Database tree that shows in the Services window and right-click on the Drivers folder and select "New Driver..."
    4. Add the jar file; Give it a name i.e. "Oracle Thin" and click OK
    5. Right Click on the new "Oracle Thin" driver that appears in the Services window and selected "Connect Using..."
    6. Set up the database connection - as an example, you might use "jdbc:oracle:thin:@remotehost:1521:orcl", your username and password - and click ok
    7. Add a new datasource using the NetBeans Database JDBC connection - the new connection defined should be in the dropdown
    8. Open the report wizard and you are on your way....


      See Also


    User Feedback

    Recommended Comments

    I suffer trying connect ireport using as external application finally I solve my problems installing netbeans plugging 

    For connect Ireport with netbeans: http://wiki.netbeans.org/ReportesEnNetBeansConIReport

    You can download ireport pluggin for netbeens  from : http://plugins.netbeans.org/plugin/4425/ireport

    You can connect netbeans with oracle database just follow  step by step the instruccions: https://netbeans.org/kb/docs/ide/oracle-db.html

    Link to comment
    Share on other sites

    Create an account or sign in to comment

    You need to be a member in order to leave a comment

    Create an account

    Sign up for a new account in our community. It's easy!

    Register a new account

    Sign in

    Already have an account? Sign in here.

    Sign In Now

  • Create New...