Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

Sign up for GitHub

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Jump to bottom

New R2DBC Driver for IBM DB2 #34

Open
jason-who-codes opened this issue Mar 2, 2022 · 4 comments
Open

New R2DBC Driver for IBM DB2 #34

jason-who-codes opened this issue Mar 2, 2022 · 4 comments

Comments

@jason-who-codes
Copy link

Hello R2DBC team!

I'd like to bring to your attention a new R2DBC driver for the IBM DB2 database, which I implemented while working at USAA and was just open-sourced at https://github.com/usaa/reactive-db-bridge. I am no longer employed by USAA, but would be happy to answer any questions about the driver, or connect your team with the appropriate folks still over at USAA.

Thanks!
Jason Edwards
GitHub | LinkedIn
@mp911de
Copy link
Member

mp911de commented Mar 2, 2022 •
edited
Loading

Wow, this is awesome news. What is the state of the driver? Which SPI versions (0.8, 0,9) do you support, and do you pass the TCK?

Going forward, we can include your driver in the BOM until we hit R2DBC spec version 1.0 (after which the BOM will be decommissioned).

I'd also recommend renaming your driver to provide a clear name indicating that the driver is related to R2DBC and DB2. db2-r2dbc-adapter/db2-r2dbc-bridge could be good candidates.

@jason-who-codes
Copy link
Author

jason-who-codes commented Mar 2, 2022 •
edited
Loading

Hey Mark, it hasn't yet been battle-tested in a prod application, but the implementation is relatively simple (it merely delegates operations to the Vert.X Reactive DB2 Client).

The driver implements the 0.8.6 version of the SPI and has a passing TCK, except it does not support compound statements and has to do a bit of tinkering with the SQL in the BLOB/CLOB test cases (since the underlying Vert.X driver doesn't support LOB's, so they have to be passed as VARCHAR/VARBINARY and aren't streamed).

@mp911de
Copy link
Member

mp911de commented Mar 4, 2022

Thanks a lot. The BLOB issue isn't really pressing. What are the plans going forward? R2DBC 0.9 has been released recently so it would make sense to have a 0.9-compliant variant.

Soon, R2DBC 1.0 will be released (with a small number of API changes). If the future maintenance is ensured, then happy to include the driver on the page and our BOM.

@odrotbohm
Copy link

I'd also recommend renaming your driver to provide a clear name indicating that the driver is related to R2DBC and DB2. db2-r2dbc-adapter/db2-r2dbc-bridge could be good candidates.

I'd still love to see a R2DBC DB2 driver to eventually end up being named R2DB2. 🙃

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Assignees
No one assigned
Labels
None yet
Projects
None yet
Milestone
No milestone
Development

No branches or pull requests
3 participants
@odrotbohm @mp911de @jason-who-codes