Re: [Firebird-net-provider] [FB-Tracker] Created: (DNET-631) Support for BOOLEAN in FB3

2015-09-25 Thread Геннадий Забула 
Jiri, could you take a look at PR.
I've finished bringing support, but stuck with problems running
unit-tests on both servers 2.5/3.0. Both embedded configuration works
fine. I think I'll finish the problems this weekend.

On 24 September 2015 at 19:14, Jiří Činčura  wrote:
> On Thu, Sep 24, 2015, at 18:10, Геннадий Забула wrote:
>> I have several question about Gds protocol. Where can I find
>> documentation about it? I need to know what should I write to send
>> boolean field to server.
>> And also I have doubts about an implementation of reading boolean fields.
>
> The best "documentation" is Firebird's source code. Not the most
> readable form, though. But always up-to-date.
>
> --
> Mgr. Jiří Činčura
> Independent IT Specialist
>
> --
> Monitor Your Dynamic Infrastructure at Any Scale With Datadog!
> Get real-time metrics from all of your servers, apps and tools
> in one place.
> SourceForge users - Click here to start your Free Trial of Datadog now!
> http://pubads.g.doubleclick.net/gampad/clk?id=241902991=/4140
> ___
> 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] Created: (DNET-631) Support for BOOLEAN in FB3

2015-09-25 Thread Jiří Činčura 
I'll have a look. I'm now focusing on Migrations, so then. 

-- 
Mgr. Jiří Činčura
Independent IT Specialist

On Fri, Sep 25, 2015, at 13:36, Геннадий Забула wrote:
> Jiri, could you take a look at PR.
> I've finished bringing support, but stuck with problems running
> unit-tests on both servers 2.5/3.0. Both embedded configuration works
> fine. I think I'll finish the problems this weekend.
> 
> On 24 September 2015 at 19:14, Jiří Činčura  wrote:
> > On Thu, Sep 24, 2015, at 18:10, Геннадий Забула wrote:
> >> I have several question about Gds protocol. Where can I find
> >> documentation about it? I need to know what should I write to send
> >> boolean field to server.
> >> And also I have doubts about an implementation of reading boolean fields.
> >
> > The best "documentation" is Firebird's source code. Not the most
> > readable form, though. But always up-to-date.
> >
> > --
> > Mgr. Jiří Činčura
> > Independent IT Specialist
> >
> > --
> > Monitor Your Dynamic Infrastructure at Any Scale With Datadog!
> > Get real-time metrics from all of your servers, apps and tools
> > in one place.
> > SourceForge users - Click here to start your Free Trial of Datadog now!
> > http://pubads.g.doubleclick.net/gampad/clk?id=241902991=/4140
> > ___
> > 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

--
___
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-631) Support for BOOLEAN in FB3

2015-09-25 Thread Геннадий Забула 
Thanks,
I've already got it working. At least tests migrated from Jaybird pass.
As Jiri suggested I took a look at FB core, and found everything I've needed.


On 25 September 2015 at 16:08, Mark Rotteveel  wrote:
> On Thu, 24 Sep 2015 19:10:44 +0300, Геннадий Забула 
> wrote:
>> https://github.com/cincuranet/FirebirdSql.Data.FirebirdClient/pull/40
>> WIP about boolean support is here. Only Gds implemented for now.
>>
>> I have several question about Gds protocol. Where can I find
>> documentation about it? I need to know what should I write to send
>> boolean field to server.
>
> There is the Firebird Wire protocol documentation, but it doesn't contain
> all details and is mostly based on reverse engineering the protocol on a
> message level, not so much the content of the messages. You'll have more
> luck looking at the Firebird implementation, or other drivers like Jaybird.
>
> In any case, you need to encode a boolean as a single byte byte-array with
> the value 0 for false or 1 for true. See also:
>
> https://github.com/FirebirdSQL/jaybird/blob/master/src/main/org/firebirdsql/gds/ng/DefaultDatatypeCoder.java#L358
>
> For reading and writing you also need information on the blr calculations:
> https://github.com/FirebirdSQL/jaybird/blob/master/src/main/org/firebirdsql/gds/ng/wire/DefaultBlrCalculator.java
>
> And reading:
> https://github.com/FirebirdSQL/jaybird/blob/master/src/main/org/firebirdsql/gds/ng/wire/version10/V10Statement.java#L516
>
> And writing:
> https://github.com/FirebirdSQL/jaybird/blob/master/src/main/org/firebirdsql/gds/ng/wire/version10/V10Statement.java#L564
>
> I'd also suggest to take a look at the commit for Jaybird I linked in
> ticket, as that includes all the changes you need to get it working.
>
>> And also I have doubts about an implementation of reading boolean
> fields.
>
> See above.
>
> Mark
>
> --
> ___
> 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] Created: (DNET-631) Support for BOOLEAN in FB3

2015-09-25 Thread Mark Rotteveel 
On Thu, 24 Sep 2015 19:10:44 +0300, Геннадий Забула 
wrote:
> https://github.com/cincuranet/FirebirdSql.Data.FirebirdClient/pull/40
> WIP about boolean support is here. Only Gds implemented for now.
> 
> I have several question about Gds protocol. Where can I find
> documentation about it? I need to know what should I write to send
> boolean field to server.

There is the Firebird Wire protocol documentation, but it doesn't contain
all details and is mostly based on reverse engineering the protocol on a
message level, not so much the content of the messages. You'll have more
luck looking at the Firebird implementation, or other drivers like Jaybird.

In any case, you need to encode a boolean as a single byte byte-array with
the value 0 for false or 1 for true. See also: 

https://github.com/FirebirdSQL/jaybird/blob/master/src/main/org/firebirdsql/gds/ng/DefaultDatatypeCoder.java#L358

For reading and writing you also need information on the blr calculations:
https://github.com/FirebirdSQL/jaybird/blob/master/src/main/org/firebirdsql/gds/ng/wire/DefaultBlrCalculator.java

And reading:
https://github.com/FirebirdSQL/jaybird/blob/master/src/main/org/firebirdsql/gds/ng/wire/version10/V10Statement.java#L516

And writing:
https://github.com/FirebirdSQL/jaybird/blob/master/src/main/org/firebirdsql/gds/ng/wire/version10/V10Statement.java#L564

I'd also suggest to take a look at the commit for Jaybird I linked in
ticket, as that includes all the changes you need to get it working.

> And also I have doubts about an implementation of reading boolean
fields.

See above.

Mark

--
___
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-631) Support for BOOLEAN in FB3

2015-09-24 Thread Jiří Činčura 
On Thu, Sep 24, 2015, at 18:10, Геннадий Забула wrote:
> I have several question about Gds protocol. Where can I find
> documentation about it? I need to know what should I write to send
> boolean field to server.
> And also I have doubts about an implementation of reading boolean fields.

The best "documentation" is Firebird's source code. Not the most
readable form, though. But always up-to-date.

-- 
Mgr. Jiří Činčura
Independent IT Specialist

--
Monitor Your Dynamic Infrastructure at Any Scale With Datadog!
Get real-time metrics from all of your servers, apps and tools
in one place.
SourceForge users - Click here to start your Free Trial of Datadog now!
http://pubads.g.doubleclick.net/gampad/clk?id=241902991=/4140
___
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-631) Support for BOOLEAN in FB3

2015-09-24 Thread Геннадий Забула 
https://github.com/cincuranet/FirebirdSql.Data.FirebirdClient/pull/40
WIP about boolean support is here. Only Gds implemented for now.

I have several question about Gds protocol. Where can I find
documentation about it? I need to know what should I write to send
boolean field to server.
And also I have doubts about an implementation of reading boolean fields.

On 14 September 2015 at 18:37, Jiří Činčura  wrote:
> On Mon, Sep 14, 2015, at 17:17, Геннадий Забула wrote:
>> How should this be implemented?
>
> My guess is by typing the code. ;)
>
>> I could take a look at this in the week.
>
> Sure, why not. The BOOLEAN in provider will not take much effort - I was
> checking it last year, quickly.
>
> --
> Mgr. Jiří Činčura
> Independent IT Specialist
>
>
> --
> ___
> Firebird-net-provider mailing list
> Firebird-net-provider@lists.sourceforge.net
> https://lists.sourceforge.net/lists/listinfo/firebird-net-provider

--
Monitor Your Dynamic Infrastructure at Any Scale With Datadog!
Get real-time metrics from all of your servers, apps and tools
in one place.
SourceForge users - Click here to start your Free Trial of Datadog now!
http://pubads.g.doubleclick.net/gampad/clk?id=241902991=/4140
___
Firebird-net-provider mailing list
Firebird-net-provider@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/firebird-net-provider

[Firebird-net-provider] [FB-Tracker] Created: (DNET-631) Support for BOOLEAN in FB3

2015-09-14 Thread Jiri Cincura (JIRA) 
Support for BOOLEAN in FB3
--

 Key: DNET-631
 URL: http://tracker.firebirdsql.org/browse/DNET-631
 Project: .NET Data provider
  Issue Type: Sub-task
  Components: ADO.NET Provider, DDEX Provider, Entity Framework support
Affects Versions: 4.8.0.0
Reporter: Jiri Cincura
Assignee: Jiri Cincura




-- 
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



--
___
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-631) Support for BOOLEAN in FB3

2015-09-14 Thread Jiří Činčura 
On Mon, Sep 14, 2015, at 17:17, Геннадий Забула wrote:
> How should this be implemented?

My guess is by typing the code. ;)

> I could take a look at this in the week.

Sure, why not. The BOOLEAN in provider will not take much effort - I was
checking it last year, quickly.

-- 
Mgr. Jiří Činčura
Independent IT Specialist


--
___
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-631) Support for BOOLEAN in FB3

2015-09-14 Thread Геннадий Забула 
How should this be implemented?
I could take a look at this in the week.

On 14 September 2015 at 17:06, Jiri Cincura (JIRA)
 wrote:
> Support for BOOLEAN in FB3
> --
>
>  Key: DNET-631
>  URL: http://tracker.firebirdsql.org/browse/DNET-631
>  Project: .NET Data provider
>   Issue Type: Sub-task
>   Components: ADO.NET Provider, DDEX Provider, Entity Framework 
> support
> Affects Versions: 4.8.0.0
> Reporter: Jiri Cincura
> Assignee: Jiri Cincura
>
>
>
>
> --
> 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
>
>
>
> --
> ___
> 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] Created: (DNET-631) Support for BOOLEAN in FB3

2015-09-14 Thread Mark Rotteveel 
I have added a link to the initial implementation I did in Jaybird. It 
won't directly map to the C# implementation, but it might give you some 
indication of what needs to change where, and how it is encoded in the 
wire protocol.

Mark

On 14-9-2015 17:17, Геннадий Забула wrote:
> How should this be implemented?
> I could take a look at this in the week.
>
> On 14 September 2015 at 17:06, Jiri Cincura (JIRA)
>  wrote:
>> Support for BOOLEAN in FB3
>> --
>>
>>   Key: DNET-631
>>   URL: http://tracker.firebirdsql.org/browse/DNET-631
>>   Project: .NET Data provider
>>Issue Type: Sub-task
>>Components: ADO.NET Provider, DDEX Provider, Entity Framework 
>> support
>>  Affects Versions: 4.8.0.0
>>  Reporter: Jiri Cincura
>>  Assignee: Jiri Cincura
>>
>>
>>
>>
>> --
>> 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
>>
>>
>>
>> --
>> ___
>> 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
>


-- 
Mark Rotteveel

--
___
Firebird-net-provider mailing list
Firebird-net-provider@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/firebird-net-provider