{"action":"created","issue":{"url":"https://api.github.com/repos/spring-projects/spring-xd/issues/1521","labels_url":"https://api.github.com/repos/spring-projects/spring-xd/issues/1521/labels{/name}","comments_url":"https://api.github.com/repos/spring-projects/spring-xd/issues/1521/comments","events_url":"https://api.github.com/repos/spring-projects/spring-xd/issues/1521/events","html_url":"https://github.com/spring-projects/spring-xd/issues/1521","id":64338474,"number":1521,"title":"JDBC Source with SQL server","user":{"login":"thesynapses","id":8339634,"avatar_url":"https://avatars.githubusercontent.com/u/8339634?v=3","gravatar_id":"","url":"https://api.github.com/users/thesynapses","html_url":"https://github.com/thesynapses","followers_url":"https://api.github.com/users/thesynapses/followers","following_url":"https://api.github.com/users/thesynapses/following{/other_user}","gists_url":"https://api.github.com/users/thesynapses/gists{/gist_id}","starred_url":"https://api.github.com/users/thesynapses/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/thesynapses/subscriptions","organizations_url":"https://api.github.com/users/thesynapses/orgs","repos_url":"https://api.github.com/users/thesynapses/repos","events_url":"https://api.github.com/users/thesynapses/events{/privacy}","received_events_url":"https://api.github.com/users/thesynapses/received_events","type":"User","site_admin":false},"labels":[],"state":"closed","locked":false,"assignee":null,"milestone":null,"comments":13,"created_at":"2015-03-25T18:18:39Z","updated_at":"2015-03-26T08:08:23Z","closed_at":"2015-03-25T23:01:07Z","body":"There seems to be an issue with connecting SpringXD to SQL server.\r\nI downloaded and inserted a sqljdbc4.jar and sqljdbc.jar in /opt/pivotal/spring-xd/xd/lib directory.\r\nOnce I deploy a stream I get a strange error on 1433/DB-NAME not being the correct port.\r\n\r\nI have tried changing ports, giving Database string as typical \"database=DB-NAME\" value but nothing seems to work.\r\n\r\nPlease advice."},"comment":{"url":"https://api.github.com/repos/spring-projects/spring-xd/issues/comments/86388257","html_url":"https://github.com/spring-projects/spring-xd/issues/1521#issuecomment-86388257","issue_url":"https://api.github.com/repos/spring-projects/spring-xd/issues/1521","id":86388257,"user":{"login":"thomasdarimont","id":314690,"avatar_url":"https://avatars.githubusercontent.com/u/314690?v=3","gravatar_id":"","url":"https://api.github.com/users/thomasdarimont","html_url":"https://github.com/thomasdarimont","followers_url":"https://api.github.com/users/thomasdarimont/followers","following_url":"https://api.github.com/users/thomasdarimont/following{/other_user}","gists_url":"https://api.github.com/users/thomasdarimont/gists{/gist_id}","starred_url":"https://api.github.com/users/thomasdarimont/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/thomasdarimont/subscriptions","organizations_url":"https://api.github.com/users/thomasdarimont/orgs","repos_url":"https://api.github.com/users/thomasdarimont/repos","events_url":"https://api.github.com/users/thomasdarimont/events{/privacy}","received_events_url":"https://api.github.com/users/thomasdarimont/received_events","type":"User","site_admin":false},"created_at":"2015-03-26T08:08:22Z","updated_at":"2015-03-26T08:08:22Z","body":"Small addition:\r\n\r\nI gave this a spin as well and can confirm, that I see an exception logged after 6 successful queries.\r\nIt seems that you need to configure the validation query appropriately: \r\nWith:\r\n```--validationQuery='select 1' ```\r\nI don't see any exceptions anymore.\r\n\r\nCheers,\r\nThomas"}}