qubole / streamx

kafka-connect-s3 : Ingest data from Kafka to Object Stores(s3)
Apache License 2.0
96 stars 54 forks source link

Use c3p0 for JDBC connection pooling #18

Closed PraveenSeluka closed 8 years ago

PraveenSeluka commented 8 years ago

StreamX DBWAL uses JDBC to communicate with mysql. If StreamX is long running - and does not get any messages, the connection gets closed (after wait_timeout) and DBWAL fails later. To avoid this, we can use some connection pooling. The pool will renew the connection periodically.

PraveenSeluka commented 8 years ago

https://github.com/qubole/streamx/pull/19