[Firebird-net-provider] bug using COALESCE within CASE via .Net provider
Excuse me if this has been reported already - but I've recent ran into a query that the .net provider seems to be choking on - so the questions are - Is it a known bug? Or is it just my setup? Maybe use an older .net provider? Setup: Running Firebird 2.0.6 .Net Provider 2.6.5.1. Query used: select h.h_JobNumber, c.c_LastName, c.c_FirstName , case s.s_value when 'Y' then COALESCE(h.h_servicetech, '') else COALESCE(h.h_representative,'') end as H_BTech, s.s_value, v.v_year from Header h left join systemsetting s on s.s_system_id = 999 and s.s_shopid = h.h_shopid left outer join Customer c on c.c_Customer_Id = h.h_CustomerId left outer join vehicle v on v.v_vehicle_id = h.h_vehicleid where (h.h_ShopId = 100) Error: :Error querying database FirebirdSql.Data.FirebirdClient.FbException (0x80004005): arithmetic exception, numeric overflow, or string truncation --- arithmetic exception, numeric overflow, or string truncation at FirebirdSql.Data.FirebirdClient.FbCommand.Fetch() in C:\VSNET\FB_Provider_265\FirebirdSql\Data\FirebirdClient\FbCommand.cs:line 689 at FirebirdSql.Data.FirebirdClient.FbDataReader.Read() in C:\VSNET\FB_Provider_265\FirebirdSql\Data\FirebirdClient\FbDataReader.cs:line 242 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) This query works without issue within IBExpert. Thanks, Charlie -- Better than sec? Nothing is better than sec when it comes to monitoring Big Data applications. Try Boundary one-second resolution app monitoring today. Free. http://p.sf.net/sfu/Boundary-dev2dev ___ Firebird-net-provider mailing list Firebird-net-provider@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
Re: [Firebird-net-provider] [FB-Tracker] Created: (DNET-370) Bug in the RemoveComments function of FbScript class
Was wondering if anything has been done with this? Comments with procedure and trigger is very vital to our business practice. -- View this message in context: http://firebird.1100200.n4.nabble.com/FB-Tracker-Created-DNET-370-Bug-in-the-RemoveComments-function-of-FbScript-class-tp3355915p3730610.html Sent from the firebird-net-provider mailing list archive at Nabble.com. -- uberSVN's rich system and user administration capabilities and model configuration take the hassle out of deploying and managing Subversion and the tools developers use with it. Learn more about uberSVN and get a free download at: http://p.sf.net/sfu/wandisco-dev2dev ___ Firebird-net-provider mailing list Firebird-net-provider@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
Re: [Firebird-net-provider] Auto-Reply: Auto-Reply:IndexOutOfRangeExceptionOpening FirebirdConnection
GO Phuc yourself - you're spamming! -Original Message- From: Le Phuc [mailto:lep...@tonyvn.com] Sent: Tuesday, October 13, 2009 2:38 PM To: firebird-net-provider@lists.sourceforge.net Subject: [Firebird-net-provider] Auto-Reply: Auto-Reply:IndexOutOfRangeExceptionOpening FirebirdConnection Chào Le Phuc, Phúc đã nhận được thư về: [Firebird-net-provider] Auto-Reply: IndexOutOfRangeExceptionOpening FirebirdConnection, lúc: 02:38, 14-10-2009. Phúc sẽ trả lời ngay khi vào lại văn phòng. Trân trọng. Lê Phúc 0988691926 -- Come build with us! The BlackBerry(R) Developer Conference in SF, CA is the only developer event you need to attend this year. Jumpstart your developing skills, take BlackBerry mobile applications to market and stay ahead of the curve. Join us from November 9 - 12, 2009. Register now! http://p.sf.net/sfu/devconference ___ Firebird-net-provider mailing list Firebird-net-provider@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/firebird-net-provider -- Come build with us! The BlackBerry(R) Developer Conference in SF, CA is the only developer event you need to attend this year. Jumpstart your developing skills, take BlackBerry mobile applications to market and stay ahead of the curve. Join us from November 9 - 12, 2009. Register now! http://p.sf.net/sfu/devconference ___ Firebird-net-provider mailing list Firebird-net-provider@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
Re: [Firebird-net-provider] [FB-Tracker] Reopened: (DNET-171)Implementing IDisposable interface and possibility to stopSocket operations in FbRemoteEvent
Jiri.
I got it working. Thanks.
For those interested - be sure to test for Event count ( args.count ) as
well.
The QueueEvents will loop through the whole event list.
Jiri,
What could be done where if I wanted to only raise the event for 1 event
(the event being posted), aside from showing all registered events?
Take for example this snip of code:
FbRemoteEvent EventComp = new FbRemoteEvent(FireBirdConnection, new
string[] {
event1,event2,event3,eventN });
EventComp.RemoteEventCounts += new
FbRemoteEventEventHandler(ProcessEvent);
EventComp.QueueEvents();
Function ProcessEvent would actually be called 4 times or N times
depending on how many events you are listening to. I'm interested in
picking up just 1 - say only event1 if it was the only event posted.
Thanks,
Charlie
-Original Message-
From: Jiri Cincura [mailto:disk...@cincura.net]
Sent: Tuesday, March 24, 2009 5:54 PM
To: For users and developers of the Firebird .NET providers
Subject: Re: [Firebird-net-provider] [FB-Tracker] Reopened:
(DNET-171)Implementing IDisposable interface and possibility to
stopSocket operations in FbRemoteEvent
On Tue, Mar 24, 2009 at 22:21, Charlie Xiong xio...@yadasystems.com
wrote:
Hopefully I didn't miss any news on this but, I was wondering if there
has been any improvements toward .Net's event posting and
listening/receiving mechanism.
Yes, a lot. Thread synchronization, proper ending of connection, fixed
port reading, IP reading if server behind NAT just couple of thinks I
recall right now.
Specifically the desire of registering multiple events per connection.
i.e.
EventComp = new FbRemoteEvent(FireBirdConnection, new string[] {
event1,event2,event3,eventN });
That's working. Don't forgot to start listening for events calling
QueueEvents.
--
Jiri {x2} Cincura (CTO x2develop.com)
http://blog.vyvojar.cz/jirka/ | http://www.ID3renamer.com
--
Apps built with the Adobe(R) Flex(R) framework and Flex Builder(TM) are
powering Web 2.0 with engaging, cross-platform capabilities. Quickly and
easily build your RIAs with Flex Builder, the Eclipse(TM)based
development software that enables intelligent coding and step-through
debugging.
Download the free 60 day trial. http://p.sf.net/sfu/www-adobe-com
___
Firebird-net-provider mailing list
Firebird-net-provider@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
--
___
Firebird-net-provider mailing list
Firebird-net-provider@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
Re: [Firebird-net-provider] [FB-Tracker] Reopened: (DNET-171) Implementing IDisposable interface and possibility to stop Socket operations in FbRemoteEvent
Hello list,
Hopefully I didn't miss any news on this but, I was wondering if there
has been any improvements toward .Net's event posting and
listening/receiving mechanism.
Specifically the desire of registering multiple events per connection.
i.e.
EventComp = new FbRemoteEvent(FireBirdConnection, new string[] {
event1,event2,event3,eventN });
* Currently, under 2.0.1.0 client - this implementation fails to receive
any events.
Thanks,
Charlie
-Original Message-
From: Jiri Cincura (JIRA) [mailto:trac...@firebirdsql.org]
Sent: Wednesday, January 21, 2009 11:20 AM
To: firebird-net-provider@lists.sourceforge.net
Subject: [Firebird-net-provider] [FB-Tracker] Reopened: (DNET-171)
Implementing IDisposable interface and possibility to stop Socket
operations in FbRemoteEvent
[
http://tracker.firebirdsql.org/browse/DNET-171?page=com.atlassian.jira.p
lugin.system.issuetabpanels:all-tabpanel ]
Jiri Cincura reopened DNET-171:
---
Opened for better implementation. Check next comment.
Implementing IDisposable interface and possibility to stop Socket
operations in FbRemoteEvent
--
Key: DNET-171
URL: http://tracker.firebirdsql.org/browse/DNET-171
Project: .NET Data provider
Issue Type: New Feature
Components: ADO.NET Provider
Affects Versions: 2.5.0 Alpha 2
Reporter: Pavel
Assignee: Jiri Cincura
Fix For: 2.5.0 Beta 1, 2.5.0 Beta 2, 2.5.0
is it possible to implement an IDisposable pattern for FbRemoteEvent?
There are a lot of small problems now. For instance:
if you pass an connection object to the FbRemoteEvent constructor
there are two possibilities
1) you are as owner responsible for destroying this connection object
- doesn't work for now, if you dispose connection, there is a socket
exception, cause RemoteEvent still tries to read from already disposed
stream
2) FbRemoteEvent should destroy it - there is no place in code, where
FbRemoteEvent would manage connection dispose. As i understand, you
cannot stop it from listening at all. the thread, that is reading
responses from server is declared background and reads until owning
window is destroyed (and causes bunch of ThreadAbortedException's) to
understand the problem, consider this test case
FbConnection conn1 = new FbConnection();
conn1.Open();
revent = new FbRemoteEvent(conn1, new[] { event });
revent.RemoteEventCounts += revent_RemoteEventCounts;
revent.QueueEvents(); revent.CancelEvents(); revent.RemoteEventCounts
-= revent_RemoteEventCounts; revent.Connection = null; //this will
cause an socket exception conn1.Dispose(); Is there any possibility to
implement some Stop method (that causes stoppage of all socket/thread
stuff) - in my opinion - CancelEvents might do this work. And it would
be nice to know, that the same functionality (and also dispose of
connection) would be done in Dispose method. We can still dispose
connection on our own, but only if we can stop socket listening (and
this must be clearly stated in docu).
--
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
--
This SF.net email is sponsored by:
SourcForge Community
SourceForge wants to tell your story.
http://p.sf.net/sfu/sf-spreadtheword
___
Firebird-net-provider mailing list
Firebird-net-provider@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
--
Apps built with the Adobe(R) Flex(R) framework and Flex Builder(TM) are
powering Web 2.0 with engaging, cross-platform capabilities. Quickly and
easily build your RIAs with Flex Builder, the Eclipse(TM)based development
software that enables intelligent coding and step-through debugging.
Download the free 60 day trial. http://p.sf.net/sfu/www-adobe-com
___
Firebird-net-provider mailing list
Firebird-net-provider@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
