embulk / embulk/embulk-output-jdbc
Oracle output does not support NUMBER datatype
- Dominant language
- Java
- Stars
- 92
- Forks
- 89
- PR merge metrics
- No merged PRs in 30d
Description
When trying to load to oracle using any mode (default, direct or oci) then getting :+1: Caused by: java.sql.SQLException: Unsupported type : NUMBER
at org.embulk.output.oracle.DirectBatchInsert.prepare(DirectBatchInsert.java:138)
I guess that the way to solve it is to add NUMBER in the switch statement just above DECIMAL - they both should be treated the same way.
Contributor guide
No contributing guide indexed for this repository
Research direction
Start in org.embulk.output.oracle.DirectBatchInsert.java at line 138, where the SQLException is raised while preparing the insert. Read the surrounding switch statement and the DECIMAL handling, then verify that an Oracle NUMBER column loads successfully in the default, direct, and OCI modes. Done means those modes no longer report NUMBER as unsupported.
Written by the indexing model from the issue text.
Assessment
- Tech stack
- java, sql
- Domain
- databases
- Issue type
- Bug
- Difficulty
- 2/5
- Estimated time
- 1-3 hours
- Activity status
- Stale
- Clarity
- Clearly specified
- Newbie friendliness
- 55/100