Fill method cause Dynamic SQL Error
-----------------------------------
Key: DNET-326
URL: http://tracker.firebirdsql.org/browse/DNET-326
Project: .NET Data provider
Issue Type: Bug
Environment: Windows XP
Reporter: Thomas
Assignee: Jiri Cincura
Hi, I'm trying to draw my problem.
It only occures when connection pooling is disabled.
1. Initialize my FbDataAdapter's once within an Init()
[QUOTE]// initialise DataAdapter
DA_MainView = new FbDataAdapter(Select_MainView);
DA_DetailView = new FbDataAdapter(Select_DetailView);
DA_Image = new FbDataAdapter(Select_Images);[/QUOTE]
2. Call every FbDataAdapter's Fill method within a method
[QUOTE]
using (connection = new FbConnection(sConnectionString))
{
try
{
connection.Open();
// start a transaction
usedTransaction = connection.BeginTransaction();
// set the transaction & connection for the select statements of the data
adapters
DA_MainView.SelectCommand.Connection = connection;
DA_MainView.SelectCommand.Transaction = usedTransaction;
DA_DetailView.SelectCommand.Connection = connection;
DA_DetailView.SelectCommand.Transaction = usedTransaction;
DA_Image.SelectCommand.Connection = connection;
DA_Image.SelectCommand.Transaction = usedTransaction;
DA_MainView.Fill(tblMainView);
DA_DetailView.Fill(tblDetailsView);
DA_Image.Fill(tblImage_FileIDs);
.
.
.[/QUOTE]
3. calling the method twice results in an SQL error. Executing
DA_DetailView.Fill(tblDetailsView); the second time causes the error, while
calling DA_MainView.Fill(tblMainView); still works.
But what makes me curious is that i got different error messages within the
exception message property.
I got following error messages:
[QUOTE] "invalid request handle"[/QUOTE]
and
[QUOTE]
"Dynamic SQL Error
SQL error code = -502
Attempt to reopen an open cursor"[/QUOTE]
If connection pooling is turned on, no error occures.
Does anybody got an idea how to fix this? Or is this behaviour a bug of the
firebird database?
--
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators:
http://tracker.firebirdsql.org/secure/Administrators.jspa
-
For more information on JIRA, see: http://www.atlassian.com/software/jira
------------------------------------------------------------------------------
ThinkGeek and WIRED's GeekDad team up for the Ultimate
GeekDad Father's Day Giveaway. ONE MASSIVE PRIZE to the
lucky parental unit. See the prize list and enter to win:
http://p.sf.net/sfu/thinkgeek-promo
_______________________________________________
Firebird-net-provider mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
