Spring boot reactive (Webflux) with MySql
up vote
0
down vote
favorite
I would develop an Spring boot application compliant with new feature Webflux.
Does an driver JDBC for Mysql exist?
I found just driver for some NoSql DB (for ex. MongoDB).
Could you help me?
Thanks, regards.
java spring spring-boot spring-webflux reactive
add a comment |
up vote
0
down vote
favorite
I would develop an Spring boot application compliant with new feature Webflux.
Does an driver JDBC for Mysql exist?
I found just driver for some NoSql DB (for ex. MongoDB).
Could you help me?
Thanks, regards.
java spring spring-boot spring-webflux reactive
add a comment |
up vote
0
down vote
favorite
up vote
0
down vote
favorite
I would develop an Spring boot application compliant with new feature Webflux.
Does an driver JDBC for Mysql exist?
I found just driver for some NoSql DB (for ex. MongoDB).
Could you help me?
Thanks, regards.
java spring spring-boot spring-webflux reactive
I would develop an Spring boot application compliant with new feature Webflux.
Does an driver JDBC for Mysql exist?
I found just driver for some NoSql DB (for ex. MongoDB).
Could you help me?
Thanks, regards.
java spring spring-boot spring-webflux reactive
java spring spring-boot spring-webflux reactive
asked Nov 8 at 13:49
Michel Foucault
1,10321628
1,10321628
add a comment |
add a comment |
2 Answers
2
active
oldest
votes
up vote
1
down vote
accepted
No there is no reactive driver for MySQl. There is one for Postgres:
https://github.com/r2dbc/r2dbc-client
it uses all the reactive bits from project rector (collections are return as flux). Of Course you are back to working with prepared statements. And pulling data directly from the Serch reasult.
And the one for the oracle DB:
https://github.com/oracle/oracle-db-examples/tree/master/java/AoJ
But it uses a blocking JDBC calls and only hides the problem of behind thread pool. However it represent the current effort at Oracle to attack the problem. And it is not a trivial thing as there is a certain philosophy when working with relational databases of consistent state. That is why your query result is return all at once unlike mongodb that can return result as it comes in.
Because of that any ORM (hibernate, eclipselink) tooling is nowhere.
I think for production code we are stuck with blocking calls for now.
add a comment |
up vote
0
down vote
Actually there isn't any reactive support for relational database. But not for long time since the Spring Team are working on R2DBC, which will provide the ability to access data reactively from a relational database. Stay tuned here: https://github.com/r2dbc
add a comment |
2 Answers
2
active
oldest
votes
2 Answers
2
active
oldest
votes
active
oldest
votes
active
oldest
votes
up vote
1
down vote
accepted
No there is no reactive driver for MySQl. There is one for Postgres:
https://github.com/r2dbc/r2dbc-client
it uses all the reactive bits from project rector (collections are return as flux). Of Course you are back to working with prepared statements. And pulling data directly from the Serch reasult.
And the one for the oracle DB:
https://github.com/oracle/oracle-db-examples/tree/master/java/AoJ
But it uses a blocking JDBC calls and only hides the problem of behind thread pool. However it represent the current effort at Oracle to attack the problem. And it is not a trivial thing as there is a certain philosophy when working with relational databases of consistent state. That is why your query result is return all at once unlike mongodb that can return result as it comes in.
Because of that any ORM (hibernate, eclipselink) tooling is nowhere.
I think for production code we are stuck with blocking calls for now.
add a comment |
up vote
1
down vote
accepted
No there is no reactive driver for MySQl. There is one for Postgres:
https://github.com/r2dbc/r2dbc-client
it uses all the reactive bits from project rector (collections are return as flux). Of Course you are back to working with prepared statements. And pulling data directly from the Serch reasult.
And the one for the oracle DB:
https://github.com/oracle/oracle-db-examples/tree/master/java/AoJ
But it uses a blocking JDBC calls and only hides the problem of behind thread pool. However it represent the current effort at Oracle to attack the problem. And it is not a trivial thing as there is a certain philosophy when working with relational databases of consistent state. That is why your query result is return all at once unlike mongodb that can return result as it comes in.
Because of that any ORM (hibernate, eclipselink) tooling is nowhere.
I think for production code we are stuck with blocking calls for now.
add a comment |
up vote
1
down vote
accepted
up vote
1
down vote
accepted
No there is no reactive driver for MySQl. There is one for Postgres:
https://github.com/r2dbc/r2dbc-client
it uses all the reactive bits from project rector (collections are return as flux). Of Course you are back to working with prepared statements. And pulling data directly from the Serch reasult.
And the one for the oracle DB:
https://github.com/oracle/oracle-db-examples/tree/master/java/AoJ
But it uses a blocking JDBC calls and only hides the problem of behind thread pool. However it represent the current effort at Oracle to attack the problem. And it is not a trivial thing as there is a certain philosophy when working with relational databases of consistent state. That is why your query result is return all at once unlike mongodb that can return result as it comes in.
Because of that any ORM (hibernate, eclipselink) tooling is nowhere.
I think for production code we are stuck with blocking calls for now.
No there is no reactive driver for MySQl. There is one for Postgres:
https://github.com/r2dbc/r2dbc-client
it uses all the reactive bits from project rector (collections are return as flux). Of Course you are back to working with prepared statements. And pulling data directly from the Serch reasult.
And the one for the oracle DB:
https://github.com/oracle/oracle-db-examples/tree/master/java/AoJ
But it uses a blocking JDBC calls and only hides the problem of behind thread pool. However it represent the current effort at Oracle to attack the problem. And it is not a trivial thing as there is a certain philosophy when working with relational databases of consistent state. That is why your query result is return all at once unlike mongodb that can return result as it comes in.
Because of that any ORM (hibernate, eclipselink) tooling is nowhere.
I think for production code we are stuck with blocking calls for now.
edited Nov 8 at 16:43
answered Nov 8 at 16:33
piotr szybicki
41329
41329
add a comment |
add a comment |
up vote
0
down vote
Actually there isn't any reactive support for relational database. But not for long time since the Spring Team are working on R2DBC, which will provide the ability to access data reactively from a relational database. Stay tuned here: https://github.com/r2dbc
add a comment |
up vote
0
down vote
Actually there isn't any reactive support for relational database. But not for long time since the Spring Team are working on R2DBC, which will provide the ability to access data reactively from a relational database. Stay tuned here: https://github.com/r2dbc
add a comment |
up vote
0
down vote
up vote
0
down vote
Actually there isn't any reactive support for relational database. But not for long time since the Spring Team are working on R2DBC, which will provide the ability to access data reactively from a relational database. Stay tuned here: https://github.com/r2dbc
Actually there isn't any reactive support for relational database. But not for long time since the Spring Team are working on R2DBC, which will provide the ability to access data reactively from a relational database. Stay tuned here: https://github.com/r2dbc
answered Nov 8 at 16:12
akuma8
836819
836819
add a comment |
add a comment |
Thanks for contributing an answer to Stack Overflow!
- Please be sure to answer the question. Provide details and share your research!
But avoid …
- Asking for help, clarification, or responding to other answers.
- Making statements based on opinion; back them up with references or personal experience.
To learn more, see our tips on writing great answers.
Some of your past answers have not been well-received, and you're in danger of being blocked from answering.
Please pay close attention to the following guidance:
- Please be sure to answer the question. Provide details and share your research!
But avoid …
- Asking for help, clarification, or responding to other answers.
- Making statements based on opinion; back them up with references or personal experience.
To learn more, see our tips on writing great answers.
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
StackExchange.ready(
function () {
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fstackoverflow.com%2fquestions%2f53209088%2fspring-boot-reactive-webflux-with-mysql%23new-answer', 'question_page');
}
);
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown