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"
