Using an Initialization Statement

You can specify a statement that executes each time a physical connection to the database is created (not reused) from a JDBC connection pool. This is useful for setting request or session specific properties and is suited for homogeneous requests in a single application. Set the Init SQL attribute of the JDBC connection pool to the SQL string to be executed in one of the following ways:

• Enter an Init SQL value in the Edit Connection Pool Advanced Attributes page in the Administration Console. For more information, click the Help button in the Administration Console.

• Specify the ----initsql option in the asadmin create-jdbc-connection-pool command. For more information, see the Oracle GlassFish Server 3.0.1 Reference Manual.

• Specify the init-sql option in the asadmin set command. For example:

  asadmin set domain1.resources.jdbc-connection-pool.DerbyPool.init-sql="sql-string"

  For more information, see the Oracle GlassFish Server 3.0.1 Reference Manual.