Thanks very much to Carl Franklin and Richard Chambell for bringing this valuable resource to everyone's desktop.
.NET Rocks is one of the important / more useful resource for all IT savvy to know more about the .NET Technology and software development in general.
There are around 177 shows currently, all are much valuable and contains rich information about the technology. I already subscribed to the shows and downloaded each. Its good to spend enough time everyday by listening to each show and get to know the insights. Very nice!
Check out the official .NET Rocks site and subscribe to it (if not done already).
We are using Enterpise Library June 2005 relase for .NET Framework 1.1 in our application, having a Oracle 10g database.
We are getting the following error often,
Message : Timeout expired. The timeout period elapsed prior to obtaining a connection from the pool. This may have occurred because all pooled connections were in use and max pool size was reached.
Source : System.Data.OracleClient
Help link :
TargetSite : System.Data.OracleClient.OracleInternalConnection GetPooledConnection(System.String, System.Data.OracleClient.OracleConnectionString, System.Data.OracleClient.OracleConnection, Boolean ByRef)
Stack Trace : at System.Data.OracleClient.OracleConnectionPoolManager.GetPooledConnection(String encryptedConnectionString, OracleConnectionString options, OracleConnection owningObject, Boolean& isInTransaction)
at System.Data.OracleClient.OracleConnection.OpenInternal(OracleConnectionString parsedConnectionString, Object transact)
at System.Data.Common.DbDataAdapter.QuietOpen(IDbConnection connection, ConnectionState& originalState)
at System.Data.Common.DbDataAdapter.FillFromCommand(Object data, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior)
at System.Data.Common.DbDataAdapter.Fill(DataSet dataSet, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior)
at System.Data.Common.DbDataAdapter.Fill(DataSet dataSet)
at Microsoft.Practices.EnterpriseLibrary.Data.Database.DoLoadDataSet(DBCommandWrapper command, DataSet dataSet, String tableNames)
at Microsoft.Practices.EnterpriseLibrary.Data.Database.LoadDataSet(DBCommandWrapper command, DataSet dataSet, String tableNames)
at Microsoft.Practices.EnterpriseLibrary.Data.Oracle.OracleDatabase.LoadDataSet(DBCommandWrapper commandWrapper, DataSet dataSet, String tableNames)
at Microsoft.Practices.EnterpriseLibrary.Data.Database.LoadDataSet(DBCommandWrapper command, DataSet dataSet, String tableName)
at Microsoft.Practices.EnterpriseLibrary.Data.Database.ExecuteDataSet(DBCommandWrapper command)
at Microsoft.Practices.EnterpriseLibrary.Data.Oracle.OracleDatabase.ExecuteDataSet(DBCommandWrapper commandWrapper)
As per the Enterprise Library documentation and expert reviews (ref. MSDN Magazine Data Points) it was mentioned as,
The DAAB also helps manage connection state for you. For example, if you want to fill a DataSet or insert some rows by executing a stored procedure, the DAAB automatically opens and closes the connection when needed. It uses the open late, close early approach so that connection pooling is maximized.
We are using only ExecuteDataset and ExecuteNonQuery in our Business Layer. But not sure why this error is occuring on the server.
When we contacted our DBA it was told that "There were two listeners running".
We are pretty sure that there is no connections kept open in our application, since its been taken care by the DAAB.
Not sure what was the cause for this problem.
Did anyone encountered similar issue? Is there some settings to be done on the DB Server?
All inputs are very much appreciated.
This has been resolved.
At times, there were 2 listeners getting created in our DB, This causes slow performance in application and sometimes throws time-out error as well.
We were told that there was a reference to an Oracle bug #4518443, Oracle reported this bug on metalink and has given a patch for the fix.
After installing this patch p4518443_10201_AIX64-5L.zip from metalink for AIX system, the issue of spawning 2 listeres got resolved.
This is a problem only in Oracle 10g.
This is definitely a good news for all MS developers.
Check out the news at Rob Caron's Blog
Download MSDN Library May 2006 Edition here
I just got this over e-mail and keeping it here for reference.
The new version of ODP.NET is released by Oracle Corporation, the download is available here
The features include the following:
ODP.NET -- ADO.NET 2.0 Support
- Factory and DbCommon Classes
- Connection String Builder
- DataAdapter Batch Processing
- Schema Discovery
- Server Enumeration
Oracle Developer Tools (ODT) for Visual Studio .NET
- Visual Studio 2005 Integration
- Integrated PL/SQL Debugging (Visual Studio 2003 and 2005)
Oracle Database Extensions for .NET
- .NET 2.0 Framework Support
- Learn some ODP.NET best practices to optimize your .NET application's performance.
- Oracle Developer Tools for Visual Studio 2005 Demo
- .NET Stored Procedures Demo
Language-Integrated Query (LINQ) is a technology that eliminates the mismatch among different data domains. With LINQ, there is no need to learn separate query syntaxes when querying over diverse data domains such as XML, Relational and Objects.
Check out the MSDN Channel9 Session on LINQ.
More information is available at The LINQ project site.
Blinq is one of the exciting tool for ASP.NET and SQL. Looks like its better use Blinq for creating Admin modules to manage the Master Tables in an application database. Its very simple to create web pages without any code and it all happens just linking the SQL Database to the tool. Wonderful!
ScottGu's excellent blog post on Using LINQ with ASP.NET Part I and Part II is worth a read and practice.
Today's HOT Topic in .NET Blogsphere is that TestDriven.NET of Jamie goes commercial.
We have been using his TD.NET extensively in most of our projects and are amazed with its features. It is AWESOME!
Read more here TestDriven.NET Enterprise & Professional
I will go for the personal edition quickly and need to follow-up with my BOSS on getting the Enterprise version :)
I still remember the day Jamie helped us (over mail) on resolving an issue we had with NUnit & NCover while generating a coverage report. We always appreciate his time in bringing this product a remarkable one among all .NET Developers!
Thanks a lot to Jamie. All the very best to TD.NET Commercial Versions!
Microsoft Launches CodePlex, Vehicle for Sharing Source Code.
Read more here