topic Custom JDBC Extension in Extensions

Custom JDBC Extension

Das-Niharika — Tue, 10 Mar 2026 22:28:44 GMT

Hi , I am creating a custom jdbc extension using Extension creator. where I have to pass the query and a Go statement in the next line . Below is my yaml.

I have deployed it . Created the monitoring configuration . But the status shows a warning saying that Query has failed: Incorrect syntax near 'Go'. How can I pass multiline query here ? This is for Sybase query so it ways needs a Go statement after the query.

Can someone pls help ?

minDynatraceVersion: "1.303.0"

author:

version: "1.0.1"

jdbc:

driverClassName: "com.sybase.jdbc4.jdbc.SybDriver"

validationQuery: "SELECT 1"

versionQuery: "SELECT 1"

connectionStringPattern: "^jdbc:sybase:.*$"

connectionStringPatternErrorMessage: "The connection string must be a valid JDBC

sybase connection string starting with 'jdbc:sybase:', check:

https://infocenter.sybase.com/help/index.jsp?topic=/com.sybase.infocenter.d\

c39001.0605/html/prjdbc/prjdbc14.htm"

errorMessage: "An error occurred while trying to connect to the database. Please

check the connection details and try again."

groups:

- group: "SybaseDatabases"

featureSet: "databases"

query: "select @@servername + ' connection successful' as 'ActiveServer'\

\ Go"

timeout: "60"

metrics:

- key: "sybase.vipserver"

value: "col:ActiveServer"

dimensions:

- key: "database"

value: "col:database"

Re: Custom JDBC Extension

sujit_k_singh — Wed, 11 Mar 2026 02:35:23 GMT

@Das-Niharika

I would say don’t use GO. It’s not valid SQL for the database engine—GO is just a client-side batch separator used by tools like isql/sqsh/DBArtisan. The Dynatrace JDBC extension sends your query straight to the JDBC driver, so the server sees the literal text “Go” and errors out

Use a YAML multiline block and remove GO

Thanks,

Sujit K Singh

Re: Custom JDBC Extension

Das-Niharika — Wed, 11 Mar 2026 18:32:36 GMT

Hi @sujit_k_singh ,

Thanks for your response . I have removed GO . When you say 'use a YAML multiline code' is this the below change in red what is expected ? if so , after deploying this it throws a warning message saying Endpoint jdbc:sybase:Tds:10.39.33.11:2138?ENABLE_SSL=true&SSL_TRUST_ALL_CERTS=true&CHARSET=iso_1&CHARSET=iso_1&DYNAMIC_PREPARE=false group 'SybaseDatabases' did not produce any metrics. Subgroups will not be polled.

minDynatraceVersion: "1.303.0"

author:

version: "1.0.5"

jdbc:

driverClassName: "com.sybase.jdbc4.jdbc.SybDriver"

validationQuery: "SELECT 1"

versionQuery: "SELECT 1"

connectionStringPattern: "^jdbc:sybase:.*$"

connectionStringPatternErrorMessage: "The connection string must be a valid JDBC

sybase connection string starting with 'jdbc:sybase:', check:

https://infocenter.sybase.com/help/index.jsp?topic=/com.sybase.infocenter.d\

c39001.0605/html/prjdbc/prjdbc14.htm"

errorMessage: "An error occurred while trying to connect to the database. Please

check the connection details and try again."

groups:

- group: "SybaseDatabases"

featureSet: "databases"

query: |

select @@servername + ' connection successful' as 'ActiveServer'

timeout: "60"

metrics:

- key: "sybase.vipserver"

value: "col:ActiveServer"

dimensions:

- key: "database"

value: "col:database"

Re: Custom JDBC Extension

sujit_k_singh — Wed, 11 Mar 2026 21:27:48 GMT

Hi @Das-Niharika

Endpoint … group 'SybaseDatabases' did not produce any metrics. Subgroups will not be polled.

usually means the query ran but Dynatrace couldn’t map any numeric value to a metric (or the result set didn’t match the mappings), so the group yielded zero metrics.

Can you add this

groups:

- group: "SybaseDatabases"

featureSet: "databases"

query: |

select

1 as value,

@@servername + ' connection successful' as ActiveServer,

db_name() as database

timeout: "60"

metrics:

- key: "sybase.vipserver"

value: "col:value"

dimensions:

- key: "active_server"

value: "col:ActiveServer"

- key: "database"

value: "col:database"

If you still get the “did not produce any metrics” warning after this, grab the extension execution logs for that endpoint.

Re: Custom JDBC Extension

Das-Niharika — Wed, 11 Mar 2026 22:01:08 GMT

Hi @sujit_k_singh - This is the query executed in sybase side . They use "go" to execute the code.

Re: Custom JDBC Extension

sujit_k_singh — Wed, 11 Mar 2026 23:02:23 GMT

Hi @Das-Niharika ,

Thanks for checking that and for sharing your side.

Just to clarify the confusion around the “GO” keyword:

In Sybase tools like isql, DBArtisan, and similar SQL clients, GO is handled by the client, not by the Sybase database itself. The client splits the script into separate batches before sending them to Sybase.

When using JDBC (Dynatrace JDBC‑based extensions), the text is sent exactly as written straight to the Sybase server. Since the Sybase server does not understand “GO”, it fails if GO is included.

So both things can appear “true” at the same time:

GO works in SQL tools because the client removes it.

GO does not work in JDBC because it reaches the Sybase server unchanged.

Re: Custom JDBC Extension

Das-Niharika — Thu, 12 Mar 2026 15:23:53 GMT

Thanks a lot @sujit_k_singh - Without "go" it worked . The issue was - I was trying the get the string value in metric . Seems the only the integer value can be assigned to metric and column value (string type) should be assigned to dimension.

I have another issue . I want to customize my query passed in yaml . it should read from connectionstring that is passed and return a value .

Currently it the query is

select count(@@servername) as 'ActiveServerCount', @@servername as
        'ActiveServer

I want to do something like this . Read from connection string , if the hostname is for example - 'syb_hadr_aimmport_tst.nml.com' then return 'TDS_SY140'

Something similar to below -

select count(@@servername) as 'ActiveServerCount', @@servername as 'ActiveServer , <read from connection string . if hostname is syb_hadr_aimmport_tst.nml.com return the value as 'TDS_SY140' as 'VIP server' >

Re: Custom JDBC Extension

sujit_k_singh — Mon, 16 Mar 2026 05:39:31 GMT

Hi @Das-Niharika

Thanks for the update — great to hear it worked after removing GO. And yes, metrics must come from a numeric column; strings should be mapped as dimensions.

About “reading from the connection string”: the SQL running on Sybase can’t see the JDBC URL used by Dynatrace. That lives on the client side, not inside the database session.

The SQL alone isn’t enough. In JDBC extensions, Dynatrace requires at least one numeric column to be explicitly mapped as a metric; string columns must be mapped as dimensions. Without that mapping, the group executes but produces no metrics.

Re: Custom JDBC Extension

sujit_k_singh — Mon, 16 Mar 2026 05:43:43 GMT

@Das-Niharika

can you try this, SQL + mapping

Mapping

metrics:

- key: "sybase.vipserver"

value: "col:value"

dimensions:

- key: "active_server"

value: "col:ActiveServer"

- key: "vip_server"

value: "col:VIPServer"