Announcements
Alert: Welcome to the Unified Cloudera Community. Former HCC members be sure to read and learn how to activate your account here.
nick_mortimer
nick_mortimer
New Contributor

Re: jdbc windows sqlite

by New Contributor nick_mortimer in Support Questions
‎11-29-2017 03:39 AM
‎11-29-2017 03:39 AM
Ok I think I solved this problem: in the NiFi log org.apache.nifi.processor.exception.ProcessException: org.apache.commons.dbcp.SQLNestedException: Cannot create PoolableConnectionFactory (path to '"C:\data\in2017_v05.db"': 'C:\NIFI-1~1.0\"C:' does not exist) it seems that a path is being added to my path it looks in C:\NIFI-1~1.0\ and C: so my path should not have C: in it only \data\in2017_v05.db so this works but only if my data is on the C disk. ... View more

jdbc windows sqlite

by New Contributor nick_mortimer in Support Questions
‎11-28-2017 02:18 PM
‎11-28-2017 02:18 PM
Hi I'm new to Nifi and enjoying it so far. I'm trying to suck data out of an SQLite3 db on a windows machine. database connection : jdbc:sqlite:c:/data/in2017_v05.db Drive class name : org.sqlite.JDBC I have the sqlite .jar in the lib dir I get error cannot create JDBC drive of type org.sqlite.JDBC Thanks Nick ... View more
Contact Me
Online
Offline
Last Visited
‎11-29-2017 04:52 AM
Public Statistics
Date Registered ‎11-28-2017 01:57 PM
Last Visited ‎11-29-2017 04:52 AM
Total Messages Posted 2