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.

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

IN with more than 9 element raise oracle.r2dbc.impl.OracleR2dbcExceptions$OracleR2dbcException: [17110] [99999] Warning: #82

Closed
larousso opened this issue Jul 11, 2022 · 6 comments

Comments

@larousso
Copy link

Hi,

I got an oracle.r2dbc.impl.OracleR2dbcExceptions$OracleR2dbcException: [17110] [99999] Warning: ... when I ran query with more than 9 element in a IN statement.
There is no problems with JDBC so I don't think this is a database issue. Is there a specific option to turn on or something to do to make it work ?

Thanks

@Michael-A-McMahon
Copy link
Member

Hi @larousso. Can you share some code that would reproduce the issue?

@larousso
Copy link
Author

Hi,
I can't share the query but it is a query that return a lot of in XML.
I have done some test and it seems that the error depends on the size of the query

@Michael-A-McMahon
Copy link
Member

In order to fix the issue, I'll need to understand how to recreate the issue. Rather than provide the exact query, could you provide a new query that recreates the issue?

@Michael-A-McMahon
Copy link
Member

Hi @larousso. Sorry for the lack of progress on this, I let this issue sit for too long.

I'm just now noting that the error code, 17110, indicates a warning was raised by the database. So the SQL is not actually failing; Rather, the database is executing it, but it is also trying to warn us about something.

Another issue has cropped up about warnings recently: #93

You are more than welcome to join the discussion there, if you'd like to.

@larousso
Copy link
Author

Nice, i will try to filter warnings

@Michael-A-McMahon
Copy link
Member

Should be fixed when #98 merges, so I'll close this issue. Thanks again for the discussion!

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
None yet
Projects
None yet
Development

No branches or pull requests

2 participants