Unsupported Database & Other Doubts on Jooq

[Kamal raj]

Hi All, 

I want to achieve the following and I'm wondering whether any nice solution already exits:

1. I'm working on a project which connects to many database on the fly (configured by the user). Here I guess, I cannot pool the connection but rather cache them for sometime and invalidate. Correct me if I'm wrong here.

2. The most important thing is that, we as a product owner, provide set of supported database. Now imagine, we support say MySql version 1.x. What if user tires to connect to MySql 2.x, will the exception will be thrown? The reason is, we want to show that back to the user on un supported database. 

3. I believe we can connect to the remote database's using Jooq. Just a double confirmation. 

reg, 

Kamal.

[Lukas Eder]

Hi Kamal,

Welcome to the jOOQ community. I'm sure it's the beginning of a wonderful relationship :)

I'll comment inline.

2017-06-22 18:05 GMT+02:00 Kamal raj <kamalra...@gmail.com>:

Hi All, 

I want to achieve the following and I'm wondering whether any nice solution already exits:

1. I'm working on a project which connects to many database on the fly (configured by the user). Here I guess, I cannot pool the connection but rather cache them for sometime and invalidate. Correct me if I'm wrong here.

This isn't directly related to jOOQ, as jOOQ doesn't manage connections / pools / data sources for you but rather operates on your existing connectivity infrastructure.

For instance, if you work with JavaEE or Spring, you can simply provide jOOQ with a DataSource. If you work with manually managed JDBC Connections, you can provide jOOQ with those connections.

I suspect the latter will be the case as your users can configure their own connection, so you'll need to roll some sort of pool yourself.

 

2. The most important thing is that, we as a product owner, provide set of supported database. Now imagine, we support say MySql version 1.x. What if user tires to connect to MySql 2.x, will the exception will be thrown? The reason is, we want to show that back to the user on un supported database. 

jOOQ officially supports MySQL 5.5. We cannot possibly support MySQL 1.x anymore, it's not even available from Oracle. Are you sure this is a use-case or is this a more general question with respect to older SQL dialects?

The way jOOQ generally works is this: For some databases, we support a variety of historic versions explicitly (e.g. Oracle, SQL Server, PostgreSQL, DB2). In those cases, the specific database version can be configured in jOOQ to ensure the queries generated by jOOQ will work on that database.

This is usually not a problem, with the exception of Oracle and SQL Server who only recently started supporting OFFSET .. FETCH. The exception, if any, will be thrown when a specific query is rejected by the database server because of not (yet) supported syntax.

 

3. I believe we can connect to the remote database's using Jooq. Just a double confirmation. 

See 1.

I hope this helps,

Lukas 

[Kamal raj]

Hi Luke,

Thanks a lot for your reply. Yes Mysql 1.x was just a question :) Definitely I'm not supporting it!

--
You received this message because you are subscribed to a topic in the Google Groups "jOOQ User Group" group.
To unsubscribe from this topic, visit https://groups.google.com/d/topic/jooq-user/zogFQERKQwE/unsubscribe.
To unsubscribe from this group and all its topics, send an email to jooq-user+unsubscribe@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.