I finally got an error message on this issue.  Here is the data I pulled, Maybe this will shed some light on what I'm doing wrong.

ErrorMsg: deadlock
ErrorData: Procedure=DataAdapterReturnDT|SprocName=USPVALIDATESESSION|GUID=7c3713d9-26bd-43f5-ba64-5bd1eb8e3fa1|NEWSESSIONTIMEOUT=20|

ErrorStack:    at FirebirdSql.Data.FirebirdClient.FbCommand.Fetch() in c:\Users\Jiri\Documents\devel\NETProvider\working\NETProvider\source\FirebirdSql\Data\FirebirdClient\FbCommand.cs:line 694
   at FirebirdSql.Data.FirebirdClient.FbDataReader.Read() in c:\Users\Jiri\Documents\devel\NETProvider\working\NETProvider\source\FirebirdSql\Data\FirebirdClient\FbDataReader.cs:line 245
   at System.Data.Common.DataAdapter.FillLoadDataRow(SchemaMapping mapping)
   at System.Data.Common.DataAdapter.FillFromReader(DataSet dataset, DataTable datatable, String srcTable, DataReaderContainer dataReader, Int32 startRecord, Int32 maxRecords, DataColumn parentChapterColumn, Object parentChapterValue)
   at System.Data.Common.DataAdapter.Fill(DataTable[] dataTables, IDataReader dataReader, Int32 startRecord, Int32 maxRecords)
   at System.Data.Common.DbDataAdapter.FillInternal(DataSet dataset, DataTable[] datatables, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior)
   at System.Data.Common.DbDataAdapter.Fill(DataTable[] dataTables, Int32 startRecord, Int32 maxRecords, IDbCommand command, CommandBehavior behavior)
   at System.Data.Common.DbDataAdapter.Fill(DataTable dataTable)
   at FirebirdDAO.DAO.DataAdapterFillDTWTrans(DataTable dt, String sprocname, SProcParam[] parms, TransIsoLvl isolvl) in c:\FocusAppC#\FirebirdDAO\FirebirdDAO\DAO.cs:line 629
   at FirebirdDAO.DAO.DataAdapterReturnDTWTrans(String sprocname, SProcParam[] parms, TransIsoLvl isolvl) in c:\FocusAppC#\FirebirdDAO\FirebirdDAO\DAO.cs:line 590
   at CBT.Models.DaoAccess.DataAdapterReturnDT(String procedurename, SProcParam[] sprocparams, Guid guid, Int32 timeout, String controllerpath, String ipaddr, String browserinfo, TransIsoLvl isolvl) in c:\WebSites\CBT\CBT\Models\DaoAccess.cs:line 143

The transaction level is "Snapshot"

a follow up error, with the same transaction level about 11 minutes later:
ErrorMsg: lock conflict on no wait transaction
ErrorData: Procedure=DataAdapterReturnDT|SprocName=USPVALIDATESESSION|GUID=662a1981-a9e9-4fda-b287-3397197f0bbb|NEWSESSIONTIMEOUT=20|
ErrorStack:    at FirebirdSql.Data.FirebirdClient.FbCommand.Fetch() in c:\Users\Jiri\Documents\devel\NETProvider\working\NETProvider\source\FirebirdSql\Data\FirebirdClient\FbCommand.cs:line 694
   at FirebirdSql.Data.FirebirdClient.FbDataReader.Read() in c:\Users\Jiri\Documents\devel\NETProvider\working\NETProvider\source\FirebirdSql\Data\FirebirdClient\FbDataReader.cs:line 245
   at System.Data.Common.DataAdapter.FillLoadDataRow(SchemaMapping mapping)
   at System.Data.Common.DataAdapter.FillFromReader(DataSet dataset, DataTable datatable, String srcTable, DataReaderContainer dataReader, Int32 startRecord, Int32 maxRecords, DataColumn parentChapterColumn, Object parentChapterValue)
   at System.Data.Common.DataAdapter.Fill(DataTable[] dataTables, IDataReader dataReader, Int32 startRecord, Int32 maxRecords)
   at System.Data.Common.DbDataAdapter.FillInternal(DataSet dataset, DataTable[] datatables, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior)
   at System.Data.Common.DbDataAdapter.Fill(DataTable[] dataTables, Int32 startRecord, Int32 maxRecords, IDbCommand command, CommandBehavior behavior)
   at System.Data.Common.DbDataAdapter.Fill(DataTable dataTable)
   at FirebirdDAO.DAO.DataAdapterFillDTWTrans(DataTable dt, String sprocname, SProcParam[] parms, TransIsoLvl isolvl) in c:\FocusAppC#\FirebirdDAO\FirebirdDAO\DAO.cs:line 629
   at FirebirdDAO.DAO.DataAdapterReturnDTWTrans(String sprocname, SProcParam[] parms, TransIsoLvl isolvl) in c:\FocusAppC#\FirebirdDAO\FirebirdDAO\DAO.cs:line 590
   at CBT.Models.DaoAccess.DataAdapterReturnDT(String procedurename, SProcParam[] sprocparams, Guid guid, Int32 timeout, String controllerpath, String ipaddr, String browserinfo, TransIsoLvl isolvl) in c:\WebSites\CBT\CBT\Models\DaoAccess.cs:line 143

Dixon


On Wed, Mar 19, 2014 at 3:48 PM, E. D. Epperson Jr <dixonepperson@gmail.com> wrote:
When I hit this line:
conn.Open();
it breaks out of that block without throwing an exception.  Actually it breaks out of that class completely, but it doesn't return a datatable so my calling class experiences a datatable == null exception, which I handle.  

here is the code sample where I open the connection

            try
            {
                if (conn == null)
                {
                    conn = new FbConnection(_connstr);  -- it breaks out here
                }
                switch (conn.State)
                {
                    case ConnectionState.Closed:
                        conn.Open();
                        break;
                    case ConnectionState.Broken:
                    case ConnectionState.Connecting:
                    case ConnectionState.Executing:
                    case ConnectionState.Fetching:
                        conn.Close();
                        conn.Open();
                        break;
                }
                return conn.State == ConnectionState.Open;
            }
... then I handle any exception thrown here, except it never throws the exception.  I guess it just isn't opening the connection

Dixon


On Wed, Mar 19, 2014 at 3:36 PM, Jiri Cincura <diskuze@cincura.net> wrote:
On Wed, Mar 19, 2014 at 8:00 PM, E. D. Epperson Jr
<dixonepperson@gmail.com> wrote:
> At some point during every day, after creating the FbConnection, I then
> Open.  It apparently throws an error, but my try/catch doesn't catch it.

How do you know it throw an exception? Did you tried attaching
debugger to VS (from other VS)?

--
Jiri {x2} Cincura (x2develop.com founder)
http://blog.cincura.net/ | http://www.ID3renamer.com

------------------------------------------------------------------------------
Learn Graph Databases - Download FREE O'Reilly Book
"Graph Databases" is the definitive new guide to graph databases and their
applications. Written by three acclaimed leaders in the field,
this first edition is now available. Download your free book today!
http://p.sf.net/sfu/13534_NeoTech
_______________________________________________
Firebird-net-provider mailing list
Firebird-net-provider@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/firebird-net-provider



--
Dixon Epperson



--
Dixon Epperson