Skip to main content

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index] [List Home]
[birt-report-designer-dev] Reg. Two Sql connection for scripted data source and sql connection termination

I am using BIRT 2.2.0 .
I have created a class that access mysql database and returns some data.
This class I am using for a scripted data source.
Now the problem that I am facing are :

1. For every creation of report , two database connection are made to the database. I am not able to figure out why ?
2. After the report is rendered , those connection do not terminate and continue indefinitely and are closed only after I close eclipse. Thus connections keep on gathering  and after sometime databases server crashes.

I guess their is no error with the class file.
Evern so it is as follows

package BIRT;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;
import java.util.ArrayList;
import java.util.List;

public class Mysqlclass {
    public  List<String[]> data() {
        Connection con = null;
        ArrayList <String[]> result = new ArrayList <String[]>();
        try {
            String url = "">
            // Get a connection to the database for a
            // user named auser with the password
            // drowssap, which is password spelled
            // backwards.
            con = DriverManager.getConnection(url, "root","password");
            Statement st = con.createStatement();
            ResultSet rs = st.executeQuery("select UserLogin,StatType from table");

                String[]  result1 = {"",""};
                result1[0]= rs.getString("UserLogin");
        } catch (Exception e) {
            System.out.println("Exception: " + e.getMessage());
        } finally {
            try {
                if (con != null)
            } catch (SQLException e) {
                System.out.println("Error with closing the collection");
        return result;

Any help will be greatly appreciated.

Shivam Agarwal

Back to the top