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

ORA-01843: not a valid month binding JSR 310 to prepared statements #7400

Closed
3 tasks done
lukaseder opened this issue Apr 9, 2018 · 1 comment
Closed
3 tasks done

Comments

@lukaseder
Copy link
Member

lukaseder commented Apr 9, 2018

Oracle's support for JSR-310 types is still incomplete. Internally, the type is bound as a string, which doesn't work for Oracle, depending on the NLS settings. The workaround is to implement a custom data type binding.

An improved solution will need to bind an oracle.sql.TIMESTAMPTZ type. Note that despite ojdbc8 having been retrofitted to accept JSR 310 types like ZoneId, some clients might still be using ojdbc7

Further tests are needed - it is likely that e.g. the following might not work perfectly yet:

See also: #5910

@lukaseder
Copy link
Member Author

The fixes in this area are rather delicately linked to the #4930 DefaultBinding refactoring, and will thus not be merged to 3.10

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

No branches or pull requests

1 participant