Examples of PGConnectionPoolDataSource

org.postgresql.ds.PGConnectionPoolDataSource
PostgreSQL implementation of ConnectionPoolDataSource. The app server or middleware vendor should provide a DataSource implementation that takes advantage of this ConnectionPoolDataSource. If not, you can use the PostgreSQL implementation known as PoolingDataSource, but that should only be used if your server or middleware vendor does not provide their own. Why? The server may want to reuse the same Connection across all EJBs requesting a Connection within the same Transaction, or provide other similar advanced features.
In any case, in order to use this ConnectionPoolDataSource, you must set the property databaseName. The settings for serverName, portNumber, user, and password are optional. Note: these properties are declared in the superclass.

This implementation supports JDK 1.3 and higher.
@author Aaron Mulder (ammulder@chariotsolutions.com)

Examples of org.postgresql.ds.PGConnectionPoolDataSource

  static GPSTraceDAO gpsTraceDAO;
  static Logger logger = Logger.getLogger(SpeedBinTests.class);
  
  public static void createJNDIContext() throws Exception
  {
    PGConnectionPoolDataSource ds = new PGConnectionPoolDataSource();
    ds.setServerName("localhost");
    ds.setPortNumber(5432);
    ds.setDatabaseName("tamt15");
    ds.setUser("gis");
    ds.setPassword("gis");
    ds.setDefaultAutoCommit(true);
    System.setProperty(Context.INITIAL_CONTEXT_FACTORY, MockIntialContextFactory.class.getName());
    InitialContext ic = new InitialContext();
    ic.bind("TAMTDataSource", ds);
  }

View Full Code Here

Examples of org.postgresql.ds.PGConnectionPoolDataSource


  static Logger logger = Logger.getLogger(DatabaseDumpTests.class);
  
  public static void createJNDIContext() throws Exception
  {
    PGConnectionPoolDataSource ds = new PGConnectionPoolDataSource();
    ds.setServerName("localhost");
    ds.setPortNumber(5432);
    ds.setDatabaseName("tamt15");
    ds.setUser("gis");
    ds.setPassword("gis");
    ds.setDefaultAutoCommit(true);
    System.setProperty(Context.INITIAL_CONTEXT_FACTORY, MockIntialContextFactory.class.getName());
    InitialContext ic = new InitialContext();
    ic.bind("TAMTDataSource", ds);
  }

View Full Code Here

Examples of org.postgresql.ds.PGConnectionPoolDataSource

  static final Logger logger = Logger.getLogger(TAMTConnectionPoolInitializer.class);
   
    public void init() throws ServletException {
      
    logger.debug("Initializing database connection source with JNDI");
    PGConnectionPoolDataSource source = new PGConnectionPoolDataSource();
    source.setServerName("localhost");
    source.setPortNumber(5432);
    source.setDatabaseName("tamt15");
    source.setUser("gis");
    source.setPassword("gis");
    source.setDefaultAutoCommit(true);
    
    try {
      new InitialContext().rebind("TAMTDataSource", source);
    } catch (NamingException e) {
      logger.error("Could not initialize database connection source:" + e.getMessage());

View Full Code Here

Examples of org.postgresql.ds.PGConnectionPoolDataSource

  static TripStatisticsReportDAO tripStatisticsReportDAO;
  static Logger logger = Logger.getLogger(ReportTests.class);
  
  public static void createJNDIContext() throws Exception
  {
    PGConnectionPoolDataSource ds = new PGConnectionPoolDataSource();
    ds.setServerName("localhost");
    ds.setPortNumber(5432);
    ds.setDatabaseName("tamt15");
    ds.setUser("gis");
    ds.setPassword("gis");
    ds.setDefaultAutoCommit(true);
    System.setProperty(Context.INITIAL_CONTEXT_FACTORY, MockIntialContextFactory.class.getName());
    InitialContext ic = new InitialContext();
    ic.bind("TAMTDataSource", ds);
  }

View Full Code Here

Examples of org.postgresql.ds.PGConnectionPoolDataSource

  static Logger logger = Logger.getLogger(RegionBOTests.class);
  static RegionBO regionBO = RegionBO.get();
  
  public static void createJNDIContext() throws Exception
  {
    PGConnectionPoolDataSource ds = new PGConnectionPoolDataSource();
    ds.setServerName("localhost");
    ds.setPortNumber(5432);
    ds.setDatabaseName("tamt15");
    ds.setUser("gis");
    ds.setPassword("gis");
    ds.setDefaultAutoCommit(true);
    System.setProperty(Context.INITIAL_CONTEXT_FACTORY, MockIntialContextFactory.class.getName());
    InitialContext ic = new InitialContext();
    ic.bind("TAMTDataSource", ds);
  }

View Full Code Here

Examples of org.postgresql.ds.PGConnectionPoolDataSource

     */
    if( connection == null)
    {
      //logger.debug("Connection is null, get one from the pool");
      try {
        PGConnectionPoolDataSource source = (PGConnectionPoolDataSource)new InitialContext().lookup("TAMTDataSource");
          connection = source.getConnection();
      } catch(SQLException e) {
          // log error
        logger.debug("SQLException: " + e.getMessage());
      } catch(NamingException e) {
          // DataSource wasn't found in JNDI
        logger.debug("JNDI naming exception: " + e.getMessage());
      } finally {
          //if(connection != null) {
          //    try {connection.close();}catch(SQLException e) {}
          //}
      }
    } else {
      
      try {
        if( connection.isClosed())
        {
          try {
            PGConnectionPoolDataSource source = (PGConnectionPoolDataSource)new InitialContext().lookup("TAMTDataSource");
              connection = source.getConnection();
          } catch(SQLException e) {
              // log error
            logger.debug("SQLException: " + e.getMessage());
          } catch(NamingException e) {
              // DataSource wasn't found in JNDI

View Full Code Here

TOP

All source code are property of their respective owners. Java is a trademark of Sun Microsystems, Inc and owned by ORACLE Inc. Contact coftware#gmail.com.