{"action":"closed","issue":{"url":"https://api.github.com/repos/davidmoten/rxjava-jdbc/issues/43","labels_url":"https://api.github.com/repos/davidmoten/rxjava-jdbc/issues/43/labels{/name}","comments_url":"https://api.github.com/repos/davidmoten/rxjava-jdbc/issues/43/comments","events_url":"https://api.github.com/repos/davidmoten/rxjava-jdbc/issues/43/events","html_url":"https://github.com/davidmoten/rxjava-jdbc/issues/43","id":107582309,"number":43,"title":"Issues with Teradata?","user":{"login":"thomasnield","id":7420801,"avatar_url":"https://avatars.githubusercontent.com/u/7420801?v=3","gravatar_id":"","url":"https://api.github.com/users/thomasnield","html_url":"https://github.com/thomasnield","followers_url":"https://api.github.com/users/thomasnield/followers","following_url":"https://api.github.com/users/thomasnield/following{/other_user}","gists_url":"https://api.github.com/users/thomasnield/gists{/gist_id}","starred_url":"https://api.github.com/users/thomasnield/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/thomasnield/subscriptions","organizations_url":"https://api.github.com/users/thomasnield/orgs","repos_url":"https://api.github.com/users/thomasnield/repos","events_url":"https://api.github.com/users/thomasnield/events{/privacy}","received_events_url":"https://api.github.com/users/thomasnield/received_events","type":"User","site_admin":false},"labels":[],"state":"closed","locked":false,"assignee":null,"milestone":null,"comments":4,"created_at":"2015-09-21T19:30:55Z","updated_at":"2015-09-22T18:16:31Z","closed_at":"2015-09-22T18:16:31Z","body":"I'm not sure whether to post this problem here or in the HikariCP page. I am trying to use Teradata which works just fine as shown below. (EDIT: Not fine, after iterating records it acts like `onCompleted()` is never called)\r\n```\r\nDatabase.builder()\r\n.url(\"jdbc:teradata://CSEDW/database=edw_prod_vw,logmech=TD2\")\r\n.username(myUserName)\r\n.password(myPassword)\r\n```\r\n\r\nBut the moment I try to pool() the connections I start to have problems\r\n```\r\nDatabase.builder()\r\n.url(\"jdbc:teradata://CSEDW/database=my_db_env,logmech=TD2\")\r\n.username(myUserName)\r\n.password(myPassword)\r\n.pool(2,5);\r\n```\r\n\r\nI get the following stacktrace\r\n```\r\ncom.zaxxer.hikari.pool.PoolInitializationException: Exception during pool initialization: Connection.isValid() is not supported, configure connection test query.\r\n\tat com.zaxxer.hikari.pool.HikariPool.initializeConnections(HikariPool.java:581)\r\n\tat com.zaxxer.hikari.pool.HikariPool.<init>(HikariPool.java:152)\r\n\tat com.zaxxer.hikari.HikariDataSource.getConnection(HikariDataSource.java:96)\r\n\tat com.github.davidmoten.rx.jdbc.ConnectionProviderPooled.get(ConnectionProviderPooled.java:80)\r\n\tat com.github.davidmoten.rx.jdbc.QuerySelectOnSubscribe.connectAndPrepareStatement(QuerySelectOnSubscribe.java:105)\r\n\tat com.github.davidmoten.rx.jdbc.QuerySelectOnSubscribe.call(QuerySelectOnSubscribe.java:64)\r\n\tat com.github.davidmoten.rx.jdbc.QuerySelectOnSubscribe.call(QuerySelectOnSubscribe.java:19)\r\n\tat rx.Observable.unsafeSubscribe(Observable.java:7531)\r\n\tat rx.internal.operators.OperatorSubscribeOn$1$1.call(OperatorSubscribeOn.java:62)\r\n\tat rx.schedulers.TrampolineScheduler$InnerCurrentThreadScheduler.enqueue(TrampolineScheduler.java:80)\r\n\tat rx.schedulers.TrampolineScheduler$InnerCurrentThreadScheduler.schedule(TrampolineScheduler.java:59)\r\n\tat rx.internal.operators.OperatorSubscribeOn$1.onNext(OperatorSubscribeOn.java:57)\r\n\tat rx.internal.operators.OperatorSubscribeOn$1.onNext(OperatorSubscribeOn.java:43)\r\n\tat rx.internal.util.ScalarSynchronousObservable$1.call(ScalarSynchronousObservable.java:43)\r\n\tat rx.internal.util.ScalarSynchronousObservable$1.call(ScalarSynchronousObservable.java:32)\r\n\tat rx.Observable$1.call(Observable.java:144)\r\n\tat rx.Observable$1.call(Observable.java:136)\r\n\tat rx.Observable.unsafeSubscribe(Observable.java:7531)\r\n\tat rx.internal.operators.OperatorConcat$ConcatSubscriber.subscribeNext(OperatorConcat.java:176)\r\n\tat rx.internal.operators.OperatorConcat$ConcatSubscriber.onNext(OperatorConcat.java:140)\r\n\tat rx.internal.operators.OperatorConcat$ConcatSubscriber.onNext(OperatorConcat.java:79)\r\n\tat rx.internal.operators.OperatorMap$1.onNext(OperatorMap.java:55)\r\n\tat rx.internal.operators.OperatorMap$1.onNext(OperatorMap.java:55)\r\n\tat rx.observers.SerializedObserver.onNext(SerializedObserver.java:159)\r\n\tat rx.observers.SerializedSubscriber.onNext(SerializedSubscriber.java:95)\r\n\tat rx.internal.operators.OperatorConcat$ConcatInnerSubscriber.onNext(OperatorConcat.java:206)\r\n\tat rx.internal.util.ScalarSynchronousObservable$1.call(ScalarSynchronousObservable.java:43)\r\n\tat rx.internal.util.ScalarSynchronousObservable$1.call(ScalarSynchronousObservable.java:32)\r\n\tat rx.Observable.unsafeSubscribe(Observable.java:7531)\r\n\tat rx.internal.operators.OperatorConcat$ConcatSubscriber.subscribeNext(OperatorConcat.java:176)\r\n\tat rx.internal.operators.OperatorConcat$ConcatSubscriber.onNext(OperatorConcat.java:140)\r\n\tat rx.internal.operators.OperatorConcat$ConcatSubscriber.onNext(OperatorConcat.java:79)\r\n\tat rx.internal.operators.OnSubscribeFromIterable$IterableProducer.request(OnSubscribeFromIterable.java:106)\r\n\tat rx.Subscriber.setProducer(Subscriber.java:177)\r\n\tat rx.internal.operators.OnSubscribeFromIterable.call(OnSubscribeFromIterable.java:50)\r\n\tat rx.internal.operators.OnSubscribeFromIterable.call(OnSubscribeFromIterable.java:33)\r\n\tat rx.Observable$1.call(Observable.java:144)\r\n\tat rx.Observable$1.call(Observable.java:136)\r\n\tat rx.Observable$1.call(Observable.java:144)\r\n\tat rx.Observable$1.call(Observable.java:136)\r\n\tat rx.Observable$1.call(Observable.java:144)\r\n\tat rx.Observable$1.call(Observable.java:136)\r\n\tat rx.Observable$1.call(Observable.java:144)\r\n\tat rx.Observable$1.call(Observable.java:136)\r\n\tat rx.Observable.subscribe(Observable.java:7621)\r\n\tat rx.Observable.subscribe(Observable.java:7397)\r\n\tat com.swa.rm.od.AirportConversionMapping.main(AirportConversionMapping.java:32)\r\nCaused by: java.sql.SQLException: Connection.isValid() is not supported, configure connection test query.\r\n\tat com.zaxxer.hikari.pool.PoolElf.setupConnection(PoolElf.java:178)\r\n\tat com.zaxxer.hikari.pool.HikariPool.addConnection(HikariPool.java:497)\r\n\tat com.zaxxer.hikari.pool.HikariPool.initializeConnections(HikariPool.java:565)\r\n\t... 46 more\r\n```\r\n\r\nHow do I configure Teradata into this? \r\n\r\n\r\n"}}