MID Server JDBC doesn't work

[Yadin]

We're trying to pull in data from a source using JDBC.  This appears to not work for some reason, possibly due to custom JAR.  The MID is configured, the JAR is loaded and on the MID, everything seems in order.  However, it does not work, and per log:

MID Server reported error: java.sql.SQLException: com.snc.automation_common.integration.exceptions.InvalidConnectionParameterException: JDBC connection string not specified

Well that's a peculiar message as it would indicate the software doesn't work.  There is no place to specify a connection string, the assumption is the MID should be building that from the information in the Data Source configuration (server, port, etc etc).  Any ideas why this would be?

[Jeffrey Siegel]

ok so i got it to work!

so for ServiceNow's mid server to get the connection string to appear, you have to add the field to your form.  Right click header, configure form layout, add connection URL. save. and then you can add your string.

[Yadin]

Kudos for figuring that out!  Woe that SN couldn't answer it for 3 years and their product is missing a required field that you have to figure out how to add manually.  Rather reinforces the notion this is a generic framework and not a finished product of any sort, despite what marketing may say.

[Jeffrey Siegel]

if my response was helpful, please click the helpful link.

[Saikrishna3072]

It works for me as well

[Poojita O]

Hi ,
We are trying to use Teradata as a data source by following the below KB article:

Unable to establish connectivity to Postgresql data source from ServiceNow 

but we have the below issue despite adding the connection URL
InvalidConnectionParameterException: JDBC connection string not specified

or

java.sql.SQLException: java.sql.SQLException: [Teradata JDBC Driver] [TeraJDBC 17.10.00.27] [Error 1536] [SQLState HY000] Invalid connection parameter name allowLocalInfile

We had added the required Teradata JDBC jar .

If any other jars are required, pls suggest and kindly add jar download links , if possible.

Please suggest a solution