Forum Discussion

Musketeer's avatar
Musketeer
New Contributor
2 months ago

Data Sink JDBC doesn't register connection properties

Hello! 

I encountered a problem that my JDBC connection isn't working in Data Sink test step, because I need to use serverTimezone property in the connection string in order to establish connection.

I have the connection setup in the database connection editor and it is testing properly there.
The connection is also working properly when I am using it in Data Source test step and when I retrieve it with the following groovy script: 

import com.eviware.soapui.support.GroovyUtilsPro;

def jdbcConnectionName = "LocalMySQL-JDBC";
def groovyUtilsPro = new GroovyUtilsPro(context);

def connection = groovyUtilsPro.getJdbcConnection(jdbcConnectionName);

But as I stated before, it isn't working when I use it in a Data Sink test step. Since I get an error complaining about timezones configuration, I suspect the connection properties aren't properly used in the Data Sink. Even when I try setting the connection manually for a specific data sink instance, the property is ignored AND it's deleted when I reopen the connection configuration.

Am I doing something incorrectly?

PS: Where to put posts like this? 

No RepliesBe the first to reply