Data source timeout for JDBC/SQLServer

[jeremy_gardner]

Hello,

Is there a way to set a timeout with the JDBC/SQLServer data source import? I have a query that seems to take about 5 minutes when run normally, and seems to exceed some sort of timeout threshold within Service-now. Is that a data source configuration, mid server configuration, etc?

Thanks!
Jeremy

[john_andersen]

I don't see where you can modify this timeout from the Data Sources page.

It does appear that if you do on-the-fly JDBC calls, you have a potential of setting the timeout value for the query. However, I can't find where you can tie that into the data source.

You have two different options:

1) Run a JDBC query via script rather than using a data source. Then you can (apparently) control the timeout.
2) Break down your data source queries into smaller result sets so that you get results within the timeout period.

I recommend option (2).

[Antony_Alldis]

I know this is an old post - but if anyone stumbles across this, and needs a quick answer, the wiki article: http://wiki.servicenow.com/index.php?title=Data_Sources#JDBC_Connection_Settings&gsc.tab=0 details this.