[
https://issues.apache.org/jira/browse/NIFI-8052?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
DEOM Damien updated NIFI-8052:
------------------------------
Description:
Following this tutorial
[http://funnifi.blogspot.com/2016/04/sql-in-nifi-with-executescript.html]
I could read the database, but writing to it crashes my DBCPConnectionPool with
the following error:
{quote}PutSQL[id=a2c741f9-947d-137e-0000-000058ffcc56]
org.apache.nifi.processors.standard.PutSQL$$Lambda$1891/0x0000000842eb4440@5c63d8ac
failed to process due to java.sql.SQLException: Cannot get a connection, pool
error Timeout waiting for idle object; rolling back session:
org.apache.nifi.processor.exception.ProcessException: java.sql.SQLException:
Cannot get a connection, pool error Timeout waiting for idle object
{quote}
My (simple) code:
{{import java.nio.charset.StandardCharsets}}
{{import org.apache.nifi.controller.ControllerService}}
{{import groovy.sql.Sql}}{{def lookup = context.controllerServiceLookup}}
{{def dbServiceName = DatabaseConnectionPoolName.value}}
{{def dbcpServiceId =
lookup.getControllerServiceIdentifiers(ControllerService).find { }}
{{ cs -> lookup.getControllerServiceName(cs) == dbServiceName}}
{{}}}
{{def conn = lookup.getControllerService(dbcpServiceId)?.getConnection()}}
{{def sql = new Sql(conn)}}
{{def insertSql = 'INSERT INTO test (a) VALUES (?)'}}
{{def params = ['Jon']}}
{{def keys = sql.executeInsert insertSql, params}}
{{assert keys[0] == [1]}}
{{def flowFile = session.get()}}
{{if(!flowFile) return}}
{{Note that the problem only occurs when using Groovy. The PutSQL processor
works just fine.}}
was:
Following this tutorial
[http://funnifi.blogspot.com/2016/04/sql-in-nifi-with-executescript.html]
I could read the database, but writing to it crashes my DBCPConnectionPool with
the following error:
{quote}PutSQL[id=a2c741f9-947d-137e-0000-000058ffcc56]
org.apache.nifi.processors.standard.PutSQL$$Lambda$1891/0x0000000842eb4440@5c63d8ac
failed to process due to java.sql.SQLException: Cannot get a connection, pool
error Timeout waiting for idle object; rolling back session:
org.apache.nifi.processor.exception.ProcessException: java.sql.SQLException:
Cannot get a connection, pool error Timeout waiting for idle object
{quote}
My (simple) code:
{quote}{{import java.nio.charset.StandardCharsets}}
{{import org.apache.nifi.controller.ControllerService}}
{{import groovy.sql.Sql}}{{def lookup = context.controllerServiceLookup}}
{{def dbServiceName = DatabaseConnectionPoolName.value}}
\{{def dbcpServiceId =
lookup.getControllerServiceIdentifiers(ControllerService).find { }}
\{{ cs -> lookup.getControllerServiceName(cs) == dbServiceName}}
{{}}}
{{def conn = lookup.getControllerService(dbcpServiceId)?.getConnection()}}
{{def sql = new Sql(conn)}}
{{def insertSql = 'INSERT INTO test (a) VALUES ( ? )'}}
{{def params = ['Jon']}}
{{def keys = sql.executeInsert insertSql, params}}
{{assert keys[0] == [1]}}
{{def flowFile = session.get()}}
{{if(!flowFile) return}}
{quote}
{{Note that the problem only occurs when using Groovy. The PutSQL processor
works just fine.}}
> Groovy: SQL inserts crashes DBCPConnectionPool
> ----------------------------------------------
>
> Key: NIFI-8052
> URL: https://issues.apache.org/jira/browse/NIFI-8052
> Project: Apache NiFi
> Issue Type: Bug
> Affects Versions: 1.11.4
> Reporter: DEOM Damien
> Priority: Blocker
>
> Following this tutorial
> [http://funnifi.blogspot.com/2016/04/sql-in-nifi-with-executescript.html]
> I could read the database, but writing to it crashes my DBCPConnectionPool
> with the following error:
> {quote}PutSQL[id=a2c741f9-947d-137e-0000-000058ffcc56]
> org.apache.nifi.processors.standard.PutSQL$$Lambda$1891/0x0000000842eb4440@5c63d8ac
> failed to process due to java.sql.SQLException: Cannot get a connection,
> pool error Timeout waiting for idle object; rolling back session:
> org.apache.nifi.processor.exception.ProcessException: java.sql.SQLException:
> Cannot get a connection, pool error Timeout waiting for idle object
> {quote}
> My (simple) code:
>
> {{import java.nio.charset.StandardCharsets}}
> {{import org.apache.nifi.controller.ControllerService}}
> {{import groovy.sql.Sql}}{{def lookup = context.controllerServiceLookup}}
> {{def dbServiceName = DatabaseConnectionPoolName.value}}
> {{def dbcpServiceId =
> lookup.getControllerServiceIdentifiers(ControllerService).find { }}
> {{ cs -> lookup.getControllerServiceName(cs) == dbServiceName}}
> {{}}}
> {{def conn = lookup.getControllerService(dbcpServiceId)?.getConnection()}}
> {{def sql = new Sql(conn)}}
> {{def insertSql = 'INSERT INTO test (a) VALUES (?)'}}
> {{def params = ['Jon']}}
> {{def keys = sql.executeInsert insertSql, params}}
> {{assert keys[0] == [1]}}
> {{def flowFile = session.get()}}
> {{if(!flowFile) return}}
>
>
> {{Note that the problem only occurs when using Groovy. The PutSQL processor
> works just fine.}}
--
This message was sent by Atlassian Jira
(v8.3.4#803005)
