Oci Pooling Error: ORA-24416: Invalid session Poolname was s

Oci Pooling Error: ORA-24416: Invalid session Poolname was s

Postby ThomasMuellerUGIS » Thu 20 Jan 2011 09:58

Hi,

I'm trying to activate Oci Pooling.
Here is the connection string:
"User Id=xxxxxx;Server=xxxxxx;Persist Security Info=False;Unicode=True;Pooling=False;Oci Session Pooling=True;Oci Session Pool User Id=xxxxxx;Oci Session Pool Password=xxxxxx;Oci Session Pool Min Size=4;Oci Session Pool Max Size=8"


An I get that exception:
2011-01-20 10:36:25,228 ERROR [LoadWorkitems=>()] Puma.WorkItemService.WorkItemManager Exception within threaded execution
Devart.Data.Linq.LinqCommandExecutionException: Error on opening DbConnection. ---> Devart.Data.Oracle.OracleException: ORA-24416: Invalid session Poolname was specified.
at Devart.Data.Oracle.bo.b(Int32 A_0)
at Devart.Data.Oracle.ar.d(Int32 A_0)
at Devart.Data.Oracle.ar.a(t A_0, av A_1)
at Devart.Data.Oracle.OracleInternalConnection..ctor(t connectionOptions, OracleInternalConnection proxyConnection)
at Devart.Data.Oracle.b0.a(l A_0, Object A_1, DbConnectionBase A_2)
at Devart.Common.DbConnectionFactory.a(DbConnectionBase A_0, l A_1)
at Devart.Common.DbConnectionFactory.a(DbConnectionBase A_0)
at Devart.Common.DbConnectionClosed.Open(DbConnectionBase outerConnection)
at Devart.Common.DbConnectionBase.Open()
at Devart.Data.Oracle.OracleConnection.Open()
at Devart.Data.Linq.Provider.n.g()
--- End of inner exception stack trace ---
at Devart.Data.Linq.LinqCommandExecutionException.CanThrowLinqCommandExecutionException(String message, Exception e)
at Devart.Data.Linq.Provider.n.g()
at Devart.Data.Linq.Provider.n.b(IConnectionUser A_0)
at Devart.Data.Linq.Provider.DataProvider.ExecuteQuery(CompiledQuery compiledQuery, Object[] parentArgs, Object[] userArgs, Object lastResult)
at Devart.Data.Linq.Provider.DataProvider.ExecuteAllQueries(CompiledQuery compiledQuery, Object[] userArguments)
at Devart.Data.Linq.Provider.DataProvider.CompiledQuery.Devart.Data.Linq.Provider.ICompiledQuery.Execute(IProvider provider, Object[] userArgs)
at Devart.Data.Linq.DataQuery`1.i()
at System.Collections.Generic.List`1..ctor(IEnumerable`1 collection)
at System.Linq.Enumerable.ToList[TSource](IEnumerable`1 source)

What am I doing wrong?

THX alot,

Thomas
ThomasMuellerUGIS
 
Posts: 6
Joined: Wed 08 Dec 2010 18:57

Postby StanislavK » Mon 24 Jan 2011 10:09

Thank you for the report, we've reproduced the error for connections with the Unicode parameter set to true. We will investigate the issue and inform you about the results as soon as possible.
StanislavK
Devart Team
 
Posts: 1710
Joined: Thu 03 Dec 2009 10:48

Postby ThomasMuellerUGIS » Mon 24 Jan 2011 12:56

StanislavK wrote:Thank you for the report, we've reproduced the error for connections with the Unicode parameter set to true. We will investigate the issue and inform you about the results as soon as possible.


Thanks a lot!

Thomas
ThomasMuellerUGIS
 
Posts: 6
Joined: Wed 08 Dec 2010 18:57

Postby StanislavK » Thu 27 Jan 2011 18:03

We have fixed the problem, the fix is available in the new 6.10.96 build of dotConnect for Oracle. This build can be downloaded from
http://www.devart.com/dotconnect/oracle/download.html
(the trial version) or from Registered Users' Area (for users with active subscription only):
http://secure.devart.com/

For the detailed information about the fixes and improvements available in dotConnect for Oracle 6.10.96, please refer to
http://www.devart.com/forums/viewtopic.php?t=20115
StanislavK
Devart Team
 
Posts: 1710
Joined: Thu 03 Dec 2009 10:48


Return to dotConnect for Oracle