Create New database connection or datasource in ireport

Following step is required to create New database connection.

1.) You have to click on Report Datasources.

   Selected Connection/Datasource is shown just beside Report Datasources.

2.) To create New Connection/Datasource click on Report Datasources
     
    

New Dialog Box will be opened which contains all Connections/Datasources Name

3.) Click on New to create new Connection or click on Modify to modify available    Connection/Datasources .

When you will click on New , a new dialog box will open to select Datasource Type.

4.) Select Database JDBC connection to create database Connection and click Next.

5.)Provide Connection name.

6.) Select JDBC Driver from list
   

7.) Now select Oracle Driver from List

      If you have not installed Oracle Driver then Install Oracle Driver.

8.) Now provide JDBC URL ,Username, password and select Save password check box to save the password.

 9.)Now click on Test  to test the connection .

Once you connection test is successful then click on Save to save the Connection.


10.)When you save the connection , Connection will  appear in Connections/Datasources name

Now click on Close to close the dialog box .

Now New Created is set as default connection .

You can create as many as connections but only one will be default at a time.