Difference between revisions of "GVJDBCConnectionBuilder"

From GreenVulcano Wiki
Jump to: navigation, search
(Created page with "==Description== This element defines the helpers necessary to create a JDBC connection. =={{GVESB}} / {{VULCON}} Configuration== {{GVESB}} offers the JDBCConnectionBuilder ada...")
 
Line 3: Line 3:
 
This element defines the helpers necessary to create a JDBC connection.
 
This element defines the helpers necessary to create a JDBC connection.
  
=={{GVESB}} / {{VULCON}} Configuration==
+
=={{VULCON}} / {{GVCONSOLE}} Configuration==
  
{{GVESB}} offers the JDBCConnectionBuilder adapter for allowing a JDBC connection. It is used by DataHandler, Excel Report and <nowiki>sql*{{...}}</nowiki> Metadata.
+
{{GVESB}} uses the GVJDBCConnectionBuilder adapter for creating a JDBC connection. It is used by DataHandler, Excel Report and <nowiki>sql*{{...}}</nowiki> Metadata.
  
The following table show the element's attributes GVJDBCConnectionBuilder:
+
The following table shows the element's attributes GVJDBCConnectionBuilder:
 
{|class="gvtable"
 
{|class="gvtable"
 
! Attribute !! Type !! Description
 
! Attribute !! Type !! Description
Line 20: Line 20:
 
* [[JDBCConnectionBuilder#DriverConnectionBuilder|DriverConnectionBuilder]]  
 
* [[JDBCConnectionBuilder#DriverConnectionBuilder|DriverConnectionBuilder]]  
 
* [[JDBCConnectionBuilder#DriverPoolConnectionBuilder|DriverPoolConnectionBuilder]]
 
* [[JDBCConnectionBuilder#DriverPoolConnectionBuilder|DriverPoolConnectionBuilder]]
* [[JDBCConnectionBuilder#DataSourceConnectionBuilder|DataSourceConnectionBuilder]])
+
* [[JDBCConnectionBuilder#DataSourceConnectionBuilder|DataSourceConnectionBuilder]]
 +
 
 +
===DriverConnectionBuilder===
 +
 
 +
Creates a JDBC connection using the [[DriverManager]].
 +
 
 +
The following table shows the element's attributes DriverConnectionBuilder:
 +
{|class="gvtable"
 +
! Attribute !! Type !! Description
 +
|-
 +
| type || fixed || This attribute must assume the value jdbc-connection-builder
 +
|-
 +
| class || fixed || This attribute must assume the value '''it.greenvulcano.gvesb.j2ee.db.connections.impl.DriverConnectionBuilder'''.
 +
|-
 +
| name || required || Builder name.
 +
|-
 +
| driver-class || required || JDBC driver class.
 +
|-
 +
| url || required || JDBC connection URL.
 +
|-
 +
| user || optional || JDBC connection user name.
 +
|-
 +
| password || optional || JDBC connection password.
 +
|}
 +
 
 +
===DriverPoolConnectionBuilder===
 +
 
 +
This item creates a JDBC connection (pool) using Apache DBCP.
 +
 
 +
The following table shows the element's attributes DriverPoolConnectionBuilder:
 +
{|class="gvtable"
 +
! Attribute !! Type !! Description
 +
|-
 +
| type || fixed || This attribute must assume the value jdbc-connection-builder
 +
|-
 +
| class || fixed || This attribute must assume the value '''it.greenvulcano.gvesb.j2ee.db.connections.impl.DriverPoolConnectionBuilder'''.
 +
|-
 +
| name || required || Builder name.
 +
|-
 +
| driver-class || required || JDBC driver class.
 +
|-
 +
| url || required || JDBC connection URL.
 +
|-
 +
| user || optional || JDBC connection user name.
 +
|-
 +
| password || optional || JDBC connection password.
 +
|}
 +
 
 +
Might contain the following sub-elements:
 +
* Description
 +
* [[PoolParameters]]
 +
 
 +
===DataSourceConnectionBuilder===
 +
 
 +
This elements creates a JDBC connection using a DataSource.
 +
 
 +
The following table shows the element's attributes DataSourceConnectionBuilder:
 +
{|class="gvtable"
 +
! Attribute !! Type !! Description
 +
|-
 +
| type || fixed || This attribute must assume the value jdbc-connection-builder
 +
|-
 +
| class || fixed || This attribute must assume the value '''it.greenvulcano.gvesb.j2ee.db.connections.impl.DataSourceConnectionBuilder'''.
 +
|-
 +
| name || required || Builder name.
 +
|-
 +
| data-source-jndi || required || DataSource JNDI name.
 +
|}
 +
 
 +
Might contain the following sub-elements:
 +
* Description
 +
* [[JNDIHelper]]

Revision as of 15:13, 8 February 2012

Description

This element defines the helpers necessary to create a JDBC connection.

VulCon / GV Console Configuration

GreenVulcano® ESB uses the GVJDBCConnectionBuilder adapter for creating a JDBC connection. It is used by DataHandler, Excel Report and sql*{{...}} Metadata.

The following table shows the element's attributes GVJDBCConnectionBuilder:

Attribute Type Description
type fixed This attribute must assume the value module.
name fixed This attribute must assume the value GVJDBC.

Might contain the following sub-elements:

DriverConnectionBuilder

Creates a JDBC connection using the DriverManager.

The following table shows the element's attributes DriverConnectionBuilder:

Attribute Type Description
type fixed This attribute must assume the value jdbc-connection-builder
class fixed This attribute must assume the value it.greenvulcano.gvesb.j2ee.db.connections.impl.DriverConnectionBuilder.
name required Builder name.
driver-class required JDBC driver class.
url required JDBC connection URL.
user optional JDBC connection user name.
password optional JDBC connection password.

DriverPoolConnectionBuilder

This item creates a JDBC connection (pool) using Apache DBCP.

The following table shows the element's attributes DriverPoolConnectionBuilder:

Attribute Type Description
type fixed This attribute must assume the value jdbc-connection-builder
class fixed This attribute must assume the value it.greenvulcano.gvesb.j2ee.db.connections.impl.DriverPoolConnectionBuilder.
name required Builder name.
driver-class required JDBC driver class.
url required JDBC connection URL.
user optional JDBC connection user name.
password optional JDBC connection password.

Might contain the following sub-elements:

DataSourceConnectionBuilder

This elements creates a JDBC connection using a DataSource.

The following table shows the element's attributes DataSourceConnectionBuilder:

Attribute Type Description
type fixed This attribute must assume the value jdbc-connection-builder
class fixed This attribute must assume the value it.greenvulcano.gvesb.j2ee.db.connections.impl.DataSourceConnectionBuilder.
name required Builder name.
data-source-jndi required DataSource JNDI name.

Might contain the following sub-elements: