[JBoss JIRA] (AG-135) Connection doesn't release.
by Luis Barreiro (Jira)
[ https://issues.redhat.com/browse/AG-135?page=com.atlassian.jira.plugin.sy... ]
Luis Barreiro closed AG-135.
----------------------------
> Connection doesn't release.
> ---------------------------
>
> Key: AG-135
> URL: https://issues.redhat.com/browse/AG-135
> Project: Agroal
> Issue Type: Bug
> Components: narayana
> Affects Versions: 1.7
> Reporter: bingo chen
> Assignee: Luis Barreiro
> Priority: Major
> Fix For: 1.8
>
>
> We use narayana as our application JTA component. Through some tests we found an issue that database connection which related to recovery doesn't release.
> The narayana use periodic recovery works; During each recovery job execution, the XADataSource is re-established, the connection obtained from the XADataSource doesn't release after recovery job finished, the connections are released only after the GC is executed.
> Is this a problem or am I misconfiguring some settings?
> the narayana version is 5.10.1.final
--
This message was sent by Atlassian Jira
(v7.13.8#713008)
6 years, 2 months
[JBoss JIRA] (AG-136) Add a safe callback interface for pool events
by Luis Barreiro (Jira)
[ https://issues.redhat.com/browse/AG-136?page=com.atlassian.jira.plugin.sy... ]
Luis Barreiro closed AG-136.
----------------------------
> Add a safe callback interface for pool events
> ---------------------------------------------
>
> Key: AG-136
> URL: https://issues.redhat.com/browse/AG-136
> Project: Agroal
> Issue Type: Feature Request
> Components: api, pool
> Affects Versions: 1.7
> Reporter: Luis Barreiro
> Assignee: Luis Barreiro
> Priority: Major
> Fix For: 1.8
>
>
> There is a need for a callback to intercept pool events that is safe for applications to use.
> Right now the current listener interface is fine for container implementations, but should not be used by higher level applications because:
> * The {{AgroalDataSourceListener}} interface was not designed with the Interceptor concept in mind. Agroal always invoke the listeners in the given order, so if there are 2 listeners with common concerns,only one of them will be effective.
> * The Listener gives access to the raw {{java.sql.Connection}} and therefore any error may cause chaos on the pool (leave an invalid connection on the pool, etc.)
> * Some methods on the listener are invoked by Agroal's own thread and therefore should not execute any long running task (that is not a problem in the context of this issue, but may be if we expose this interface as API)
> * When running Agroal with a TransactionManager, the life-cycle of the connections can be slightly different as this is associated with the transaction. This does not map well on the current listener interface.
> A new interface PoolInteceptor should be added to address this issues.
--
This message was sent by Atlassian Jira
(v7.13.8#713008)
6 years, 2 months
[JBoss JIRA] (AG-134) Some issues in when use MSSQL SQLServerXADataSource
by Luis Barreiro (Jira)
[ https://issues.redhat.com/browse/AG-134?page=com.atlassian.jira.plugin.sy... ]
Luis Barreiro closed AG-134.
----------------------------
> Some issues in when use MSSQL SQLServerXADataSource
> ---------------------------------------------------
>
> Key: AG-134
> URL: https://issues.redhat.com/browse/AG-134
> Project: Agroal
> Issue Type: Enhancement
> Components: pool
> Affects Versions: 1.7
> Reporter: bingo chen
> Assignee: Luis Barreiro
> Priority: Major
> Fix For: 1.8
>
>
> We use MSSQL as our data base server and use 'com.microsoft.sqlserver.jdbc.SQLServerXADataSource' as driver class.
> Here some issues occured, the SQLServerXADataSource url property name is 'URL' not 'url', so we can't connect the data base server.
> Environments:
> 1.JDBC driver is 'mssql-jdbc.7.2.2.jre8'
> <dependency>
> <groupId>com.microsoft.sqlserver</groupId>
> <artifactId>mssql-jdbc</artifactId>
> <version>7.2.2.jre8</version>
> </dependency>
> 2.Agroal 1.7
> <dependency>
> <groupId>io.agroal</groupId>
> <artifactId>agroal-api</artifactId>
> <version>1.7</version>
> </dependency>
> <dependency>
> <groupId>io.agroal</groupId>
> <artifactId>agroal-pool</artifactId>
> <version>1.7</version>
> </dependency>
> <dependency>
> <groupId>io.agroal</groupId>
> <artifactId>agroal-narayana</artifactId>
> <version>1.7</version>
> </dependency>
>
--
This message was sent by Atlassian Jira
(v7.13.8#713008)
6 years, 2 months
[JBoss JIRA] (AG-139) Update dependencies
by Luis Barreiro (Jira)
Luis Barreiro created AG-139:
--------------------------------
Summary: Update dependencies
Key: AG-139
URL: https://issues.redhat.com/browse/AG-139
Project: Agroal
Issue Type: Enhancement
Components: build
Affects Versions: 1.7
Reporter: Luis Barreiro
Assignee: Luis Barreiro
Fix For: 1.8
--
This message was sent by Atlassian Jira
(v7.13.8#713008)
6 years, 2 months