Running as root on Docker images that don’t use root
tl;dr: specify the --user root argument:
docker exec --interactive \
--tty \
--user root \
--workdir / \
container-name bashtl;dr: specify the --user root argument:
docker exec --interactive \
--tty \
--user root \
--workdir / \
container-name bashThe Kafka Connect JDBC Connector by default does not cope so well with:
NUMBER columns with no defined precision/scale. You may end up with apparent junk (bytes) in the output, or just errors.TIMESTAMP WITH LOCAL TIME ZONE. Throws JDBC type -102 not currently supported warning in the log.Read more about NUMBER data type in the Oracle docs.
There are several options:
numeric.mapping"numeric.mapping":"best_fit"NUMBER ’s precision and scaleTIMESTAMP type that is supportedqueryPull from the object directly, and use query in the JDBC connector (instead of table.whitelist)—and cast the columns appropriately:
This is the detailed step-by-step if you want to recreate the process I describe in the Confluent blog here
I used Oracle’s Oracle Developer Days VM, which comes preinstalled with Oracle 12cR2. You can see the notes on how to do this here. These notes take you through installing and configuring:
extract from the Order Entry schemaFrom this point, I’ll now walk through configuring OGG-BD with the Kafka Connect handler
Here’s where I’ll be!
If you use Google Calendar you can click on individual entries above and select copy to my calendar - which of course you’ll want to do for all the ones I’ve marked as [SPEAKING] :-)
Here’s a list of all the Apache Kafka talks at OpenWorld and JavaOne, most of which I’ll be trying to get to.
The Replicat was kapput:
GGSCI (localhost.localdomain) 3> info rkconnoe
REPLICAT RKCONNOE Last Started 2017-09-12 17:06 Status ABENDED
Checkpoint Lag 00:00:00 (updated 00:46:34 ago)
Log Read Checkpoint File /u01/app/ogg/dirdat/oe000000
First Record RBA 0
So checking the OGG error log ggserr.log showed
2017-09-12T17:06:17.572-0400 ERROR OGG-15051 Oracle GoldenGate Delivery, rkconnoe.prm: Java or JNI exception:
oracle.goldengate.util.GGException: Error detected handling operation added event.
2017-09-12T17:06:17.572-0400 ERROR OGG-01668 Oracle GoldenGate Delivery, rkconnoe.prm: PROCESS ABENDING.
So checking the replicat log dirrpt/RKCONNOE_info_log4j.log showed:
Oracle’s excellent Big Data Lite VM has been updated, to version 4.5.
Changes: