BLR for SQL_NULL parameter

View: New views
15 Messages — Rating Filter:   Alert me  

BLR for SQL_NULL parameter

by Jiri Cincura :: Rate this Message:

Reply to Author | View Threaded | Show Only this Message

Hi *,

if I'm creating BLR for SQL_NULL parameter ([1] around line 134), I'm
putting there stuff same as for SQL_TEXT. Is this right? I found this
in server sources (utld.cpp), but I'm not 100% sure.

BTW if I was testing some stuff to put there, with some combinations I
was able to kill server without problem. Nothing in log, the process
just ended.

[1] http://firebird.svn.sourceforge.net/viewvc/firebird/NETProvider/trunk/NETProvider/source/FirebirdSql/Data/Common/Descriptor.cs?view=markup

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

------------------------------------------------------------------------------
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-Devel mailing list, web interface at https://lists.sourceforge.net/lists/listinfo/firebird-devel

Re: BLR for SQL_NULL parameter

by Alexander Peshkoff :: Rate this Message:

Reply to Author | View Threaded | Show Only this Message

On Wednesday 28 October 2009 12:12:01 Jiri Cincura wrote:
> BTW if I was testing some stuff to put there, with some combinations I
> was able to kill server without problem. Nothing in log, the process
> just ended.

Will be very interesting to have a look at such sample. And fix server.

------------------------------------------------------------------------------
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-Devel mailing list, web interface at https://lists.sourceforge.net/lists/listinfo/firebird-devel

Re: BLR for SQL_NULL parameter

by Jiri Cincura :: Rate this Message:

Reply to Author | View Threaded | Show Only this Message

On Wed, Oct 28, 2009 at 10:20, Alexander Peshkoff <peshkoff@...> wrote:
> Will be very interesting to have a look at such sample. And fix server.

Would the .NET binary app with tweaked provider suitable for you?

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

------------------------------------------------------------------------------
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-Devel mailing list, web interface at https://lists.sourceforge.net/lists/listinfo/firebird-devel

Re: BLR for SQL_NULL parameter

by Alexander Peshkoff :: Rate this Message:

Reply to Author | View Threaded | Show Only this Message

On Wednesday 28 October 2009 12:21:07 Jiri Cincura wrote:
> On Wed, Oct 28, 2009 at 10:20, Alexander Peshkoff <peshkoff@...> wrote:
> > Will be very interesting to have a look at such sample. And fix server.
>
> Would the .NET binary app with tweaked provider suitable for you?

If it runnable using wine - why not? I should try.


------------------------------------------------------------------------------
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-Devel mailing list, web interface at https://lists.sourceforge.net/lists/listinfo/firebird-devel

Re: BLR for SQL_NULL parameter

by Jiri Cincura :: Rate this Message:

Reply to Author | View Threaded | Show Only this Message

On Wed, Oct 28, 2009 at 10:30, Alexander Peshkoff <peshkoff@...> wrote:
> If it runnable using wine - why not? I should try.

Sent to your private mail.

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

------------------------------------------------------------------------------
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-Devel mailing list, web interface at https://lists.sourceforge.net/lists/listinfo/firebird-devel

Re: BLR for SQL_NULL parameter

by Jiri Cincura :: Rate this Message:

Reply to Author | View Threaded | Show Only this Message

Hi *,

can somebody confirm (or not) this? Thanks.

On Wed, Oct 28, 2009 at 10:12, Jiri Cincura <diskuze@...> wrote:
> if I'm creating BLR for SQL_NULL parameter ([1] around line 134), I'm
> putting there stuff same as for SQL_TEXT. Is this right? I found this
> in server sources (utld.cpp), but I'm not 100% sure.


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

------------------------------------------------------------------------------
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-Devel mailing list, web interface at https://lists.sourceforge.net/lists/listinfo/firebird-devel

Re: BLR for SQL_NULL parameter

by Adriano dos Santos Fernandes-3 :: Rate this Message:

Reply to Author | View Threaded | Show Only this Message

Jiri Cincura wrote:
> Hi *,
>
> can somebody confirm (or not) this? Thanks.
>
> On Wed, Oct 28, 2009 at 10:12, Jiri Cincura <diskuze@...> wrote:
>> if I'm creating BLR for SQL_NULL parameter ([1] around line 134), I'm
>> putting there stuff same as for SQL_TEXT. Is this right? I found this
>> in server sources (utld.cpp), but I'm not 100% sure.
>
It should be it. You talked about a crash. So far, I cannot say anything without reproduce.


Adriano


------------------------------------------------------------------------------
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-Devel mailing list, web interface at https://lists.sourceforge.net/lists/listinfo/firebird-devel

Re: BLR for SQL_NULL parameter

by Jiri Cincura :: Rate this Message:

Reply to Author | View Threaded | Show Only this Message

On Sun, Nov 1, 2009 at 15:07, Adriano dos Santos Fernandes
<adrianosf@...> wrote:
> It should be it.

Good, thanks.

> You talked about a crash. So far, I cannot say anything without reproduce.

Alex is already working on it. He also has a test case for it.

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

------------------------------------------------------------------------------
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-Devel mailing list, web interface at https://lists.sourceforge.net/lists/listinfo/firebird-devel

Parent Message unknown Re: BLR for SQL_NULL parameter

by Alexander Peshkoff :: Rate this Message:

Reply to Author | View Threaded | Show Only this Message

On Monday 02 November 2009 12:36:02 Jiri Cincura wrote:
> On Mon, Nov 2, 2009 at 10:25, Alexander Peshkoff <peshkoff@...> wrote:
> > Jiri, check once more please. I'm a bit surprised that both dlls (old &
> > new) have exactly same size. MD5 checksums differ. May be you've sent
> > wrong build?
>
> I did new build, to be sure.

Cool, it starts now.
But server does not want to crash (B2_5_Release).
I get:

Unhandled Exception: FirebirdSql.Data.FirebirdClient.FbException: I/O error
for file "rrr.fdb"
Error while trying to open file ---> I/O error for file "rrr.fdb"
Error while trying to open file
  --- End of inner exception stack trace ---
  at FirebirdSql.Data.FirebirdClient.FbConnectionInternal.Connect () [0x00000]
  at (wrapper remoting-invoke-with-check)
FirebirdSql.Data.FirebirdClient.FbConnectionInternal:Connect ()
  at FirebirdSql.Data.FirebirdClient.FbConnectionPool.Create () [0x00000]
  at FirebirdSql.Data.FirebirdClient.FbConnectionPool.CheckOut () [0x00000]
  at (wrapper remoting-invoke-with-check)
FirebirdSql.Data.FirebirdClient.FbConnectionPool:CheckOut ()
  at FirebirdSql.Data.FirebirdClient.FbConnection.Open () [0x00000]

but server keeps running and responding to incoming connections.

------------------------------------------------------------------------------
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-Devel mailing list, web interface at https://lists.sourceforge.net/lists/listinfo/firebird-devel

Re: BLR for SQL_NULL parameter

by Jiri Cincura :: Rate this Message:

Reply to Author | View Threaded | Show Only this Message

On Mon, Nov 2, 2009 at 11:15, Alexander Peshkoff <peshkoff@...> wrote:
> But server does not want to crash (B2_5_Release).
> I get:
>
> Unhandled Exception: FirebirdSql.Data.FirebirdClient.FbException: I/O error
> for file "rrr.fdb"
> Error while trying to open file ---> I/O error for file "rrr.fdb"
> Error while trying to open file

Did you created the rrr.fdb database?

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

------------------------------------------------------------------------------
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-Devel mailing list, web interface at https://lists.sourceforge.net/lists/listinfo/firebird-devel

Re: BLR for SQL_NULL parameter

by Alexander Peshkoff :: Rate this Message:

Reply to Author | View Threaded | Show Only this Message

On Monday 02 November 2009 13:17:53 Jiri Cincura wrote:

> On Mon, Nov 2, 2009 at 11:15, Alexander Peshkoff <peshkoff@...> wrote:
> > But server does not want to crash (B2_5_Release).
> > I get:
> >
> > Unhandled Exception: FirebirdSql.Data.FirebirdClient.FbException: I/O
> > error for file "rrr.fdb"
> > Error while trying to open file ---> I/O error for file "rrr.fdb"
> > Error while trying to open file
>
> Did you created the rrr.fdb database?

Reproduced with new clear rrr.fdb database.


------------------------------------------------------------------------------
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-Devel mailing list, web interface at https://lists.sourceforge.net/lists/listinfo/firebird-devel

Re: BLR for SQL_NULL parameter

by Jiri Cincura :: Rate this Message:

Reply to Author | View Threaded | Show Only this Message

On Mon, Nov 2, 2009 at 11:37, Alexander Peshkoff <peshkoff@...> wrote:
> Reproduced with new clear rrr.fdb database.

Should I create ticket in tracker?

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

------------------------------------------------------------------------------
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-Devel mailing list, web interface at https://lists.sourceforge.net/lists/listinfo/firebird-devel

Re: BLR for SQL_NULL parameter

by Alexander Peshkoff :: Rate this Message:

Reply to Author | View Threaded | Show Only this Message

On Monday 02 November 2009 13:42:47 Jiri Cincura wrote:
> On Mon, Nov 2, 2009 at 11:37, Alexander Peshkoff <peshkoff@...> wrote:
> > Reproduced with new clear rrr.fdb database.
>
> Should I create ticket in tracker?

Yes, please do it.


------------------------------------------------------------------------------
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-Devel mailing list, web interface at https://lists.sourceforge.net/lists/listinfo/firebird-devel

Re: BLR for SQL_NULL parameter

by Jiri Cincura :: Rate this Message:

Reply to Author | View Threaded | Show Only this Message

On Mon, Nov 2, 2009 at 11:48, Alexander Peshkoff <peshkoff@...> wrote:
> Yes, please do it.

Done. CORE-2725

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

------------------------------------------------------------------------------
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-Devel mailing list, web interface at https://lists.sourceforge.net/lists/listinfo/firebird-devel

Re: BLR for SQL_NULL parameter

by Alexander Peshkoff :: Rate this Message:

Reply to Author | View Threaded | Show Only this Message

On Monday 02 November 2009 13:53:04 Jiri Cincura wrote:
> On Mon, Nov 2, 2009 at 11:48, Alexander Peshkoff <peshkoff@...> wrote:
> > Yes, please do it.
>
> Done. CORE-2725

Quick fix for this particular case is ready and committed. But I do not close
a ticket - looks like there is no goood control over bad BLR's in remote, and
we may have some more interesting cases.

------------------------------------------------------------------------------
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-Devel mailing list, web interface at https://lists.sourceforge.net/lists/listinfo/firebird-devel