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]

Im no expert in this area, but id double check the Connection URL, sounds like theres a syntax error in there.

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

sounds like the part of the string that references allowLocalInfile is wrong.

[Poojita O]

Hi Jeffrey, 

Thank you for the response.

The connection URL was wrong.

The below format worked:

jdbc:teradata://<server name>/DBS_PORT=<port number>

[Jeffrey Siegel]

Awesome, please mark my response helpful if it was able to help you figure out the issue!