[jira] [Updated] (NIFI-8052) Groovy: SQL inserts crashes DBCPConnectionPool

["DEOM Damien (Jira)" <ji...@apache.org>]

     [ 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:
{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.}}

  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:
> {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.}}



--
This message was sent by Atlassian Jira
(v8.3.4#803005)