Knowledge Base

cancel
Showing results for 
Search instead for 
Did you mean: 

How do I detect Greenplum Database?

Question

My application uses a Greenplum database. The calls to the database are JDBC, but we are not discovering the database out of the box. How can I fix this?

 

Answer

Refer to Using Node Properties to Detect JDBC Backends for more details on using these node properties. The values to use for Greenplum are detailed below.

 

Greenplum Simple using greenplum.jar

Use the following JDBC node properties and values:

 

jdbc-connections: value="com.ddtek.jdbc.greenplumbase.BaseConnection,com.ddtek.jdbcspygreenplum.SpyConnection,com.ddtek.jdbcx.greenplumbase.ddd"
jdbc-prepared-statements: value="com.ddtek.jdbc.greenplumbase.dddw,com.ddtek.jdbcspygreenplum.SpyPreparedStatement,com.ddtek.jdbcx.greenplumbase.ddn"
jdbc-statements: value="com.ddtek.jdbc.greenplumbase.dde_,com.ddtek.jdbc.greenplumbase.dde,com.ddtek.jdbcspygreenplum.SpyStatement,com.ddtek.jdbcx.greenplumbase.ddu"
jdbc-callable-statements: value="com.ddtek.jdbc.greenplumbase.ddk,com.ddtek.jdbc.greenplumbase.ddm,com.ddtek.jdbcspygreenplum.SpyCallableStatement,com.ddtek.jdbcx.greenplumbase.dda"

 

Greenplum Deluxe includes Pivotal Greenplum drivers

Use the following JDBC node properties and values:

 

jdbc-connections: value="com.ddtek.jdbc.greenplumbase.BaseConnection,com.ddtek.jdbcspygreenplum.SpyConnection,com.ddtek.jdbcx.greenplumbase.ddd,com.pivotal.jdbc.greenplumbase.BaseConnection,com.pivotal.jdbcspygreenplum.SpyConnection,com.pivotal.jdbcx.greenplumbase.ddf"

jdbc-prepared-statements: value="com.ddtek.jdbc.greenplumbase.dddw,com.ddtek.jdbcspygreenplum.SpyPreparedStatement,com.ddtek.jdbcx.greenplumbase.ddn,com.pivotal.jdbc.greenplumbase.dddk,com.pivotal.jdbcspygreenplum.SpyPreparedStatement,com.pivotal.jdbcx.greenplumbase.ddp"

jdbc-statements:
value="com.ddtek.jdbc.greenplumbase.dde_,com.ddtek.jdbc.greenplumbase.dde,com.ddtek.jdbcspygreenplum.SpyStatement,com.ddtek.jdbcx.greenplumbase.ddu,com.pivotal.jdbc.greenplumbase.ddd_,com.pivotal.jdbcspygreenplum.SpyStatement,com.pivotal.jdbcx.greenplumbase.ddw" jdbc-callable-statements: value="com.ddtek.jdbc.greenplumbase.ddk,com.ddtek.jdbc.greenplumbase.ddm,com.ddtek.jdbcspygreenplum.SpyCallableStatement,com.ddtek.jdbcx.greenplumbase.dda,com.pivotal.jdbc.greenplumbase.dde1,com.pivotal.jdbc.greenplumbase.dde3,com.pivotal.jdbcspygreenplum.SpyCallableStatement,com.pivotal.jdbcx.greenplumbase.ddb,cs.jdbc.driver"

 

Version history
Revision #:
5 of 5
Last update:
‎11-19-2018 07:08 AM
Updated by:
 
Labels (1)
Contributors
Tags (1)
0 Kudos