Subreports and JNDI

[sdemelis]

Hello,

is it possible to use a JNDI connection with a subreport? I need to use connections different from the main report and if I use a standard JDBC connection for the subreport, I have too many open connection on mySql.

 

thanks

[sdemelis]

I found the solution.

It's quite simple.....if you know what to do...

I'll post it, maybe it could help someone else without loosing 2 days:

1- I configured 2 JNDI connections on my JasperServer/Tomcat

2- I created a simple java class where I access the JNDI pool and I deployed it on Jasper Server

3- In the subreport, instead of passing as connection expression the standard string

java.sql.DriverManager.getConnection ("jdbc:mysql://mydb", "user","pwd")

I used my custom class

myClass.myJNDIconnection("selectedDB")

 

Now when I execute the report, the connections are closed after 4 or 5 seconds.

[sdemelis]

As requested,
here's the code of the jndi class:

    public static Connection getJNDIConnection(String db) throws Exception
    {
        String connString ="";
        InitialContext ctx = new InitialContext();
        
        connString = "java:comp/env/jdbc/".concat(db);

        DataSource ds = (DataSource)ctx.lookup(connString);

        return ds.getConnection();
        
    }

The input string is the name of the jndi connection defined in Tomcat.

[nicolaifriis]

Connection expression on the sub-report (in the main report):

javax.naming.InitialContext.doLookup("jdbc/jmydb").getConnection()