Jump to content
Changes to the Jaspersoft community edition download ×
  • Connecting iReport to an Oracle Datasource


    eongaro
    • Features: Custom Data Sources, Data Sources Version: v4.7, v4.7.1, v4.7.0, v4.5, v4.5.1, v4.5.0, v4.2, v4.2.1, v4.1, v4.0, v4.0.1, v3.7.1, v3.7.0, v3.7.0.1, v3.6, v3.6.2, v3.6.1, v3.5, v3.5.2 Product: iReport Designer

    [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..."
      New_driver.png.5312ae7197d9b9d86998622c7382aea9.png
    4. Add the jar file; Give it a name i.e. "Oracle Thin" and click OK
      Oracle_jdbc_driver.png.66b2f4b6721a0e1dbbc927e416dd67ee.png
    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...