Java tutorial
/* * Copyright (C) 2005 - 2014 TIBCO Software Inc. All rights reserved. * http://www.jaspersoft.com. * * Unless you have purchased a commercial license agreement from Jaspersoft, * the following license terms apply: * * This program is free software: you can redistribute it and/or modify * it under the terms of the GNU Affero General Public License as * published by the Free Software Foundation, either version 3 of the * License, or (at your option) any later version. * * This program is distributed in the hope that it will be useful, * but WITHOUT ANY WARRANTY; without even the implied warranty of * MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the * GNU Affero General Public License for more details. * * You should have received a copy of the GNU Affero General Public License * along with this program. If not, see <http://www.gnu.org/licenses/>. */ package com.jaspersoft.jasperserver.api.engine.jasperreports.service.impl; import java.sql.Connection; import java.sql.SQLException; import javax.naming.Context; import javax.naming.InitialContext; import javax.naming.NamingException; import javax.sql.DataSource; import org.apache.commons.logging.Log; import org.apache.commons.logging.LogFactory; import com.jaspersoft.jasperserver.api.JSExceptionWrapper; /** * @author Lucian Chirita (lucianc@users.sourceforge.net) * @version $Id: JndiJdbcDataSourceService.java 47331 2014-07-18 09:13:06Z kklein $ */ public class JndiJdbcDataSourceService extends BaseJdbcDataSource { private static final Log log = LogFactory.getLog(JndiJdbcDataSourceService.class); private final String jndiName; public JndiJdbcDataSourceService(String jndiName) { this.jndiName = jndiName; } protected Connection createConnection() { try { Context ctx = new InitialContext(); DataSource ds = (DataSource) ctx.lookup("java:comp/env/" + jndiName); Connection c = ds.getConnection(); if (log.isDebugEnabled()) { log.debug( "CreateConnection successful at com.jaspersoft.jasperserver.api.engine.jasperreports.service.impl.JndiJdbcDataSourceService.createConnection"); } return c; } catch (NamingException e) { try { //Added as short time solution due of http://bugzilla.jaspersoft.com/show_bug.cgi?id=26570. //The main problem - this code executes in separate tread (non http). //Jboss 7 support team recommend that you use the non-component environment namespace for such situations. Context ctx = new InitialContext(); DataSource ds = (DataSource) ctx.lookup(jndiName); Connection c = ds.getConnection(); if (log.isDebugEnabled()) { log.debug( "CreateConnection successful at com.jaspersoft.jasperserver.api.engine.jasperreports.service.impl.JndiJdbcDataSourceService.createConnection"); } return c; } catch (NamingException ex) { if (log.isDebugEnabled()) log.debug(e, e); throw new JSExceptionWrapper(e); } catch (SQLException ex) { if (log.isDebugEnabled()) log.debug(e, e); throw new JSExceptionWrapper(e); } } catch (SQLException e) { if (log.isDebugEnabled()) log.debug(e, e); throw new JSExceptionWrapper(e); } } }