Re: [Firebird-net-provider] next problem

[Pavol S. - P. <pa...@st...>]

Can you release a patch or something??? I have now time to play with this
assembly, so i can do lot of tests...

next thing is: do you plan make it System.EnterpriseServices allowed it is
important for performance... I plan to use your component on big ASP.NET
site (more than 20k hits a hour), but now it is unusable (pooling not
working as i have to do)...
My site was writen using COM+ objects in delphi. it was fast stable and
scalable, but developing take to log, becouse you need to take care about
com+ logic more than your aplication logic... Net brings easy way how to
develob COM+ compliant assemblies and it is cool.
I can rewrite your code to make it thread safe, but it will be hard for
me... very hard... without your help... And for now im not .NET guru, so my
code will be not very nice...

Next thing is, that documentation is greate (very complex), but somethimes
it is not good :-)  you done there lot of overloaded methods and
constructors and not all are working in any way of use... for example i
think, that most offen question will be that Object reference not set to an
instance of an object. I was able to solve this by my hand, becouse i know
how firebird work and i checked your code so i knew that transactions are
missing... but many peole is not so far... Some examples are obsolete (you
have there examples without transactions) and so... I want to help you with
this project. May be i can start with documentation but you have to say
exactly what to do, not only say that do something... i cannot swim, so you
cannot throw me in to a pool...

p.

p.



----- Original Message -----
From: "Carlos Guzmán Álvarez" <car...@te...>
To: "Pavol Starek" <pa...@st...>
Cc: <fir...@li...>
Sent: Monday, November 18, 2002 10:27 AM
Subject: Re: [Firebird-net-provider] next problem


> Hello:
>
>  >  i solved problem... it was my stupidnes... charset have to be 1250 not
>  > 1252.
>  >  it is hard make program without IDE...
>
>
>
> :)), yo can get an IDE for Windows here:
>
> http://www.icsharpcode.net/OpenSource/SD/default.asp
>
> If you are using Linux you can see:
>
> http://www.jext.org/home.html
> http://www.jedit.org/
> http://csde.sourceforge.net/
>
>  >  but i have new problem:
>  >
>  >  Unhandled Exception: FirebirdSql.Data.Firebird.FbException: invalid
> sqlind
>  >  value
>  >  : -1658821521
>  >     at FirebirdSql.Data.Firebird.FbResultset.Fetch()
>  >     at FirebirdSql.Data.Firebird.FbDataReader.Read()
>  >
>  >  where that value is varying...
>  >
>  >  thrown at first evaluating of expression
>  >   while (fbData.Read()) {
>  >  ...
>  >  }
>  >
>  >  here is metadata:
>  >
>  >  CREATE TABLE "ARTICLES"
>  >  (
>  >    "ID" INTEGER NOT NULL,
>  >    "NADNADPIS" VARCHAR(512) CHARACTER SET WIN1250 COLLATE PXW_SLOV,
>  >    "NADPIS" VARCHAR(512) CHARACTER SET WIN1250 COLLATE PXW_SLOV,
>  >    "PEREX" VARCHAR(512) CHARACTER SET WIN1250 COLLATE PXW_SLOV,
>  >    "TEXT" VARCHAR(32000) CHARACTER SET WIN1250 COLLATE PXW_SLOV,
>  >    "VYDANIE" INTEGER,
>  >    "KATEGORIA" CHAR(5) CHARACTER SET WIN1250 COLLATE PXW_SLOV,
>  >    "DATUM" DATE
>  >  );
>  >
>  >  here is script:
>  >  select first x skip y ID, TEXT from ARTICLES order by ID
>  >
>  >  exception is thrown no depend ox x, y... problem is not in recor,
> because
>  > in
>  >  select first 3 skip 1 ID, TEXT from ARTICLES order by ID is exception
>  >  present but
>  >  in
>  >  select first 2 skip 2 ID, TEXT from ARTICLES order by ID is not...
>  >
>  >  i tried lot of combinations and i see that there is problem if sum of
>  >  lengths of rows is higher then some value (highest working i found was
>  > aprox
>  >  4298).
>  >  it dont read rwcords with size bigger then 4298 too...
>
> Ok, thanks, i have it solved now, there is a problem with sockets reading.
>
>  >  sumary:
>  >  i think, tha there is some problem with geting record bigger than
> 4298 b or
>  >  set of rows with sum size greater then 4298b while fetching rows.
>  >
>  > sorry if my questions and problems are stupid, but i like this
> assembly and
>  > i want to use it, so by patient with me...
>
>
> No problem :)
>
>
>
> Best regards
> Carlos Guzmán Álvarez
> Vigo-Spain
>