Start line:  
End line:  

Snippet Preview

Snippet HTML Code

Stack Overflow Questions
   * Firebird Open Source J2ee connector - jdbc driver, public Firebird-specific 
   * JDBC extensions.
   * Redistribution and use in source and binary forms, with or without 
   * modification, are permitted provided that the following conditions are met:
   *    1. Redistributions of source code must retain the above copyright notice, 
   *       this list of conditions and the following disclaimer.
   *    2. Redistributions in binary form must reproduce the above copyright 
  *       notice, this list of conditions and the following disclaimer in the 
  *       documentation and/or other materials provided with the distribution. 
  *    3. The name of the author may not be used to endorse or promote products 
  *       derived from this software without specific prior written permission.
 package org.firebirdsql.pool;
Configuration for the FBWrappingDataSource and FBConnectionPoolDataSource objects. Following properties are supported:
  • blobBufferSize size of the buffer used to transfer BLOB data.
  • blockingTimeout time in milliseconds during which javax.sql.DataSource.getConnection() method will block if no free connection is in pool.
  • charSet similar to encoding, but takes Java character set name instead of Firebird's encoding.
  • database path to a database including the server name; for example localhost/3050:c:/path/to/database.gdb.
  • encoding character encoding for the JDBC connection.
  • freeSize read-only: gives amount of free connections in the pool, when 0, blocking will occur if workingSize is equal to maxPoolSize.
  • isolation default transaction isolation level for connections as string; possible values are:
  • loginTimeout property from javax.sql.DataSource, in this context is a synonym for blockingTimeout (however value is specified in seconds).
  • maxIdleTime time in milliseconds after which idle physical connection in the pool is closed.
  • maxStatements maximum number of pooled prepared statements, if 0, pooling is switched off.
  • maxPoolSize maximum number of physical connections that can be opened by this data source.
  • minPoolSize minimum number of connections that will remain open by this data source.
  • nonStandardProperty a non-standard connection parameter in form name[=value].
  • password password that is used to connect to database.
  • pingInterval time interval during which connection will be proved for aliveness.
  • pooling allows switching pooling off.
  • statementPooling alternative way to switch statement pooling off.
  • socketBufferSize size of the socket buffer in bytes. In some cases values used by JVM by default are not optimal. This results in performance degradation (especially when you transfer big BLOBs). Usually 8192 bytes provides good results.
  • roleName SQL role name.
  • tpbMapping mapping of the TPB parameters to JDBC transaction isolation levels.
  • transactionIsolationLevel default transaction isolation level, number from java.sql.Connection interface.
  • totalSize total number of allocated connections.
  • type type of connection that will be created. There are four possible types: pure Java (or type 4), type 2 that will use Firebird client library to connect to the database, local-mode type 2 driver, and embedded that will use embedded engine (access to local databases). Possible values are (case insensitive):
    • "PURE_JAVA" or "TYPE4" for pure Java (type 4) JDBC connections;
    • "NATIVE" or "TYPE2" to use Firebird client library;
    • "LOCAL" to use Firebird client library in local-mode (IPC link to server);
    • "EMBEDDED" to use embedded engine.
  • userName name of the user that will be used to access the database.
  • workingSize number of connections that are in use (e.g. were obtained using javax.sql.DataSource.getConnection() method, but not yet closed).

Roman Rokytskyy
    void restart();
    void shutdown();
     * Properties of this datasource.
     int getBlockingTimeout();
     void setBlockingTimeout(int blockingTimeoutValue);
     int getMaxIdleTime();
     void setMaxIdleTime(int maxIdleTime);
     int getMaxStatements();
     void setMaxStatements(int maxStatements);
     int getMaxPoolSize();
     void setMaxPoolSize(int maxPoolSize);
     int getMinPoolSize();
     void setMinPoolSize(int minPoolSize);
     int getPingInterval();
     void setPingInterval(int pingIntervalValue);
     boolean isPooling();
     void setPooling(boolean pooling);
     boolean isStatementPooling();
     void setStatementPooling(boolean statementPooling);
     int getFreeSize() throws SQLException;
     int getWorkingSize() throws SQLException;
     int getTotalSize() throws SQLException;
New to GrepCode? Check out our FAQ X