Steps to add a custom JDBC driver in TIBCO BusinessEvents (BE) Studio's JDBC shared resource.
Article ID: KB0093104
Updated On:
| Products | Versions |
|---|---|
| TIBCO BusinessEvents Enterprise Edition | - |
| Not Applicable | - |
Description
Resolution:
You can add a custom JDBC driver in a BE Studio shared resource by manually editing the driver class. See the attached screen-shot (Filename: custom__jdbc_driver.jpg). Make sure you provide the correct driver class name in the JDBC Driver.
These additional configuration steps are needed along with adding the class name as indicated above:
- Install and start a supported DBMS product. See the product readme file for a list of supported products.
- Copy the appropriate JDBC drivers file to BE_HOME/lib/ext/tpcl. You must restart BE Studio after copying the drivers file.
- If you plan to use the debugger or tester features, add your DBMS product's libraries to the BE Studio classpath.
Note that there are few Design Time connection issues when using these custom JDBC drivers. You will see errors such as "Class not found: <full class name>" occuring when testing a connection in BEStudio. However at runtime , the BE Engine will connect to the database successfully. Here are the sample engine logs for a simple postgresql custom JAR added to connect to a postgresql DB:
********
[Loaded org.postgresql.geometric.PGbox from file:/E:/tibco_5.1.2/be/5.1/lib/ext/tpcl/postgresql-9.4-1201.jdbc41.jar]
[Loaded org.postgresql.geometric.PGcircle from file:/E:/tibco_5.1.2/be/5.1/lib/ext/tpcl/postgresql-9.4-1201.jdbc41.jar]
[Loaded org.postgresql.geometric.PGline from file:/E:/tibco_5.1.2/be/5.1/lib/ext/tpcl/postgresql-9.4-1201.jdbc41.jar]
[Loaded org.postgresql.geometric.PGlseg from file:/E:/tibco_5.1.2/be/5.1/lib/ext/tpcl/postgresql-9.4-1201.jdbc41.jar]
[Loaded org.postgresql.geometric.PGpath from file:/E:/tibco_5.1.2/be/5.1/lib/ext/tpcl/postgresql-9.4-1201.jdbc41.jar]
[Loaded org.postgresql.geometric.PGpoint from file:/E:/tibco_5.1.2/be/5.1/lib/ext/tpcl/postgresql-9.4-1201.jdbc41.jar]
[Loaded org.postgresql.geometric.PGpolygon from file:/E:/tibco_5.1.2/be/5.1/lib/ext/tpcl/postgresql-9.4-1201.jdbc41.jar]
[Loaded org.postgresql.util.PGmoney from file:/E:/tibco_5.1.2/be/5.1/lib/ext/tpcl/postgresql-9.4-1201.jdbc41.jar]
[Loaded org.postgresql.util.PGInterval from file:/E:/tibco_5.1.2/be/5.1/lib/ext/tpcl/postgresql-9.4-1201.jdbc41.jar]
**************
2015 Feb 27 13:57:14:496 GMT -8 DJEYACHA-Z210.na.tibco.com Debug [main] - [modules.db] Making connection for: JdbcUrl=jdbc:postgresql://localhost:5432/postgres, username=beuser
2015 Feb 27 13:57:14:514 GMT -8 DJEYACHA-Z210.na.tibco.com Debug [main] - [modules.db] Created/recovered connections to database: jdbc:postgresql://localhost:5432/postgres
2015 Feb 27 13:57:14:515 GMT -8 DJEYACHA-Z210.na.tibco.com Info [main] - [modules.db] [JDBCConnectionPool(jdbc:postgresql://localhost:5432/postgres,beuser), available=1, busy=0, max=2] initialized successfully
**************
You can add a custom JDBC driver in a BE Studio shared resource by manually editing the driver class. See the attached screen-shot (Filename: custom__jdbc_driver.jpg). Make sure you provide the correct driver class name in the JDBC Driver.
These additional configuration steps are needed along with adding the class name as indicated above:
- Install and start a supported DBMS product. See the product readme file for a list of supported products.
- Copy the appropriate JDBC drivers file to BE_HOME/lib/ext/tpcl. You must restart BE Studio after copying the drivers file.
- If you plan to use the debugger or tester features, add your DBMS product's libraries to the BE Studio classpath.
Note that there are few Design Time connection issues when using these custom JDBC drivers. You will see errors such as "Class not found: <full class name>" occuring when testing a connection in BEStudio. However at runtime , the BE Engine will connect to the database successfully. Here are the sample engine logs for a simple postgresql custom JAR added to connect to a postgresql DB:
********
[Loaded org.postgresql.geometric.PGbox from file:/E:/tibco_5.1.2/be/5.1/lib/ext/tpcl/postgresql-9.4-1201.jdbc41.jar]
[Loaded org.postgresql.geometric.PGcircle from file:/E:/tibco_5.1.2/be/5.1/lib/ext/tpcl/postgresql-9.4-1201.jdbc41.jar]
[Loaded org.postgresql.geometric.PGline from file:/E:/tibco_5.1.2/be/5.1/lib/ext/tpcl/postgresql-9.4-1201.jdbc41.jar]
[Loaded org.postgresql.geometric.PGlseg from file:/E:/tibco_5.1.2/be/5.1/lib/ext/tpcl/postgresql-9.4-1201.jdbc41.jar]
[Loaded org.postgresql.geometric.PGpath from file:/E:/tibco_5.1.2/be/5.1/lib/ext/tpcl/postgresql-9.4-1201.jdbc41.jar]
[Loaded org.postgresql.geometric.PGpoint from file:/E:/tibco_5.1.2/be/5.1/lib/ext/tpcl/postgresql-9.4-1201.jdbc41.jar]
[Loaded org.postgresql.geometric.PGpolygon from file:/E:/tibco_5.1.2/be/5.1/lib/ext/tpcl/postgresql-9.4-1201.jdbc41.jar]
[Loaded org.postgresql.util.PGmoney from file:/E:/tibco_5.1.2/be/5.1/lib/ext/tpcl/postgresql-9.4-1201.jdbc41.jar]
[Loaded org.postgresql.util.PGInterval from file:/E:/tibco_5.1.2/be/5.1/lib/ext/tpcl/postgresql-9.4-1201.jdbc41.jar]
**************
2015 Feb 27 13:57:14:496 GMT -8 DJEYACHA-Z210.na.tibco.com Debug [main] - [modules.db] Making connection for: JdbcUrl=jdbc:postgresql://localhost:5432/postgres, username=beuser
2015 Feb 27 13:57:14:514 GMT -8 DJEYACHA-Z210.na.tibco.com Debug [main] - [modules.db] Created/recovered connections to database: jdbc:postgresql://localhost:5432/postgres
2015 Feb 27 13:57:14:515 GMT -8 DJEYACHA-Z210.na.tibco.com Info [main] - [modules.db] [JDBCConnectionPool(jdbc:postgresql://localhost:5432/postgres,beuser), available=1, busy=0, max=2] initialized successfully
**************
Issue/Introduction
Steps to add a custom JDBC driver in TIBCO BusinessEvents (BE) Studio's JDBC shared resource.
Attachments
Feedback
Yes
No
Powered by
