[GitHub] [nifi] rkarthik29 commented on pull request #3887: NIFI-6032 - CDC for Oracle using xstream
rkarthik29 commented on pull request #3887: URL: https://github.com/apache/nifi/pull/3887#issuecomment-711021727 @davyam there is some instructions on how to set the stream server here https://github.com/rkarthik29/oracle_cdc You also need the oracle native libraries included in the java_library_path. You can set that in nifi bootstrap.conf. Karthik This is an automated message from the Apache Git Service. To respond to the message, please log on to GitHub and use the URL above to go to the specific comment. For queries about this service, please contact Infrastructure at: us...@infra.apache.org
[GitHub] [nifi] rkarthik29 commented on pull request #3887: NIFI-6032 - CDC for Oracle using xstream
rkarthik29 commented on pull request #3887: URL: https://github.com/apache/nifi/pull/3887#issuecomment-711021119 @davyam looks like there is an issue with getConnection(). is it probably timing out this is the error log target Processor 'OracleChangeCapture[id=32c99420-0175-1000-0e97-840ff38cca51]' that needs to be documented, reported and eventually fixed. 2020-10-16 23:40:24,291 ERROR [Timer-Driven Process Thread-1] o.a.n.p.o.c.i.StandardOracleCDCService StandardOracleCDCService[id=32c9c2cd-0175-1000-c663-73fb836e27c7] cannot attach to outbound server: nfxout java.sql.SQLException: Cannot get a connection, general error that error seems to come from DBCPConectionPool. Best way to figure out is to run the ITOracleChangeCaptureTest via eclipse,you can then put a breakpoint in standardoraclecdcservice.attach() to get more details on why this is happening. Make sure you are using a thick client for connection to oracle. I don't think that is the cause of this error, but ensure that you are doing that. Karthik This is an automated message from the Apache Git Service. To respond to the message, please log on to GitHub and use the URL above to go to the specific comment. For queries about this service, please contact Infrastructure at: us...@infra.apache.org
[GitHub] [nifi] rkarthik29 commented on pull request #3887: NIFI-6032 - CDC for Oracle using xstream
rkarthik29 commented on pull request #3887: URL: https://github.com/apache/nifi/pull/3887#issuecomment-709542160 > @rkarthik29 > I built this PR, but the OracleChangeCapture did not appear on the processor list. Commands executed: > > ``` > git clone https://github.com/rkarthik29/nifi-1.git > cd nifi-1 > git checkout NIFI-6032 > export MAVEN_OPTS="-Xms1024m -Xmx3076m -XX:MaxPermSize=256m" > mvn -T C2.0 clean install -Pinclude-grpc > cd nifi-assembly/target/ > tar -xvzf nifi-1.11.0-SNAPSHOT-bin.tar.gz > sh nifi-1.11.0-SNAPSHOT/bin/nifi.sh run > ``` > > So I had to copy the nars from **nifi-1/nifi-nar-bundles/nifi-oraclecdc-bundle** to the **nifi-1.11.0-SNAPSHOT/lib** directory manually. > > Please, check the parent pom.xml. @davyam There is a profile config in the nifi parent pom.xml. Please add -p include-oraclecdc to maven command to package this piece as part of nifi tar. include-oraclecdc false org.apache.nifi nifi-oraclecdc-nar 1.11.0-SNAPSHOT nar org.apache.nifi nifi-oraclecdcservice-api-nar 1.11.0-SNAPSHOT nar This is an automated message from the Apache Git Service. To respond to the message, please log on to GitHub and use the URL above to go to the specific comment. For queries about this service, please contact Infrastructure at: us...@infra.apache.org