Recent

Author Topic: ANN: IBX for Lazarus - Call for Testers  (Read 42800 times)

tonyw

  • Full Member
  • ***
  • Posts: 151
    • MWA Software
ANN: IBX for Lazarus - Call for Testers
« on: May 07, 2011, 03:27:24 pm »
MWA Software is pleased to announce the immediate availability of IBX for Lazarus. IBX for Lazarus is derived from the Open Source edition of IBX published by Borland/Inprise in 2000 under the InterBase Public License. This version has been brought up-to-date by MWA Software and focused on the Firebird Database API for both Linux and Windows platforms. It is released under the InterBase Public License for the original code and under the compatible Initial Developers Public License for new software. Both Licenses permit commercial use.

http://www.mwasoftware.co.uk/ibx

IBX for Lazarus has been developed in the context of a single project porting a large application originally developed in Delphi to Lazarus. Testing has focused on this application and the Linux 64-bit environment (Ubuntu 10.04), with product testing on 32-bit Linux and Windows XP. Wider deployment and testing is necessary before IBX for Lazarus can be considered stable.

You are encouraged to download the software and report your experience to us (ibx@mwasoftware.co.uk) - both good and bad so that a stable product can be made available to the Open Source Community.

Initially, please report bugs to the Bugzilla Database (http://www.mwasoftware.co.uk/ibxbugs) set up to monitor IBX for Lazarus bugs.

JD

  • Hero Member
  • *****
  • Posts: 1761
Re: ANN: IBX for Lazarus - Call for Testers
« Reply #1 on: May 09, 2011, 12:49:50 am »
First of all, thanks for the good work.

My first observation: Adding IBTable to an empty project causes Lazarus to freeze. The only way round it is to shut down Lazarus.

Lazarus v0.9.31 fpc 2.4.3 svn 30024 of 27-03-2011/ Windows XP SP3
Windows (10, 7) - Lazarus 2.0.6/FPC 3.2, Delphi

Indy 10.6 series; mORMot; Zeos 7.3; SQLite, Firebird, PostgreSQL & MariaDB; VirtualTreeView 5.5.3 R1

Zoran

  • Hero Member
  • *****
  • Posts: 1468
    • http://wiki.lazarus.freepascal.org/User:Zoran
Re: ANN: IBX for Lazarus - Call for Testers
« Reply #2 on: May 09, 2011, 10:34:59 am »
Thank you for your contribution to Lazarus comunity!

These are bugs I encountered on Windows 7, fpc 2.4.2:
1. 32-bit compiler
I can confirm what JD says — IBTable causes Lazarus to freeze. Further, I can say that it happens not only with 0.9.31 Lazarus from trunk, but also with 0.9.30.

2. with 64 bit Lazarus 0.9.30 the components can not even compile. The compiler gives this message:
Quote
\ibx\runtime\IBCustomDataSet.pas(2099,50) Error: Incompatible type for arg no. 1: Got "Double", expected "Int64"
« Last Edit: May 09, 2011, 10:37:21 am by Zoran »

tonyw

  • Full Member
  • ***
  • Posts: 151
    • MWA Software
Re: ANN: IBX for Lazarus - Call for Testers
« Reply #3 on: May 09, 2011, 12:34:07 pm »
Many thanks for your responses. This is just the kind of input needed to get the product quickly to stability.

IBTable Freeze: This is one of those embarrassing - but I've fixed that bug!  TIBTable is not used in the project for which IBX was ported and hence it was easy for the fix to have dropped out and not be noticed.

Commenting out line 153 of runtime/IBTable.pas (and rebuilding the IDE) fixes the problem i.e.

//    property Constraints stored ConstraintsStored;

I suspect that a bug in the FCL is underlying the problem as the property is defined in the DB unit, but have not had time to investigate.

I don't have a copy of Win64 so will always be interested to hear of bugs in this area. This problem seems to be due to inconsistencies in the way the "comp" type is defined. The offending statement is:

MSecsToTimeStamp(PDouble(data)^));

With 64 bit Linux, there is no problem, but it seems that the comp type has a different definition in 64 bit windows as an Int64 (line 140 of systemh.inc). Hence the failure. Changing the statement to

MSecsToTimeStamp(PComp(data)^));

should hopefully fix the problem on all platforms. Please confirm.

Zoran

  • Hero Member
  • *****
  • Posts: 1468
    • http://wiki.lazarus.freepascal.org/User:Zoran
Re: ANN: IBX for Lazarus - Call for Testers
« Reply #4 on: May 09, 2011, 01:39:58 pm »
I can confirm that both bugs have dissapeared, thanks. :)

jepafi

  • New Member
  • *
  • Posts: 36
Re: ANN: IBX for Lazarus - Call for Testers
« Reply #5 on: May 09, 2011, 02:06:59 pm »
Using TIBEvents or TIBSQLMonitor to compile the following error occurs:

"Project project1 raised exception class 'RunError (232)'."

On property "Params" of TIBDatabase is not included "password"automatically.

Zoran

  • Hero Member
  • *****
  • Posts: 1468
    • http://wiki.lazarus.freepascal.org/User:Zoran
Re: ANN: IBX for Lazarus - Call for Testers
« Reply #6 on: May 09, 2011, 02:07:56 pm »
This maybe a bug, but it can be just that I don't know how to set up correctly:

I added the following components on the form: IBDatabase1, IBTransaction1, IBQuery1 and IBUpdateSQL1.

I set the following in Object inspector:
- IBDatabase1.DatabaseName = localhost:sampledb (I have sampledb listed in aliases.conf file in Firebird installation folder),
- IBTransaction1.DefaultDatabase = IBDatabase1,
- IBQuery1.Database = IBDatabase1,
- IBQuery1.Transaction = IBTransaction1
- IBQuery1.UpdateSQL = IBUpdateSQL1

Then I added some select statement to IBQuery1.SQL. The select query works well. Now I want to set up the IBUpdateSQL1 component, but when I try to edit any of its sql properties (delete, modify, insert, refresh), I get "No Default Transaction" message box!
There is no Transaction property of IBUpdateSQL. And I belive that there should not be this property, as the IBUpdateSQL component has the IBQuery, which has its Transaction property.

Is it a bug or I'm doing something wrong?

tonyw

  • Full Member
  • ***
  • Posts: 151
    • MWA Software
Re: ANN: IBX for Lazarus - Call for Testers
« Reply #7 on: May 09, 2011, 03:17:07 pm »
You get this error when your IBDatabase component does not have a default transaction assigned. Please check this component.

motaz

  • Hero Member
  • *****
  • Posts: 508
    • http://code.sd
Re: ANN: IBX for Lazarus - Call for Testers
« Reply #8 on: May 09, 2011, 06:10:24 pm »
It seems to be a huge work.

Quote
for both Linux and Windows platforms

Did you plan to support Mac?

tonyw

  • Full Member
  • ***
  • Posts: 151
    • MWA Software
Re: ANN: IBX for Lazarus - Call for Testers
« Reply #9 on: May 09, 2011, 06:26:35 pm »
It seems to be a huge work.

Quote
for both Linux and Windows platforms

Did you plan to support Mac?

I don't have a Mac and never have had one - so don't really have the means to support Mac OSX. The main issue is probably over whether the SV5 IPC component in IBSQLMonitor will work -especially as this has to use libc in order to work around a bug in the RTL. You could always compile it and post the result.

tonyw

  • Full Member
  • ***
  • Posts: 151
    • MWA Software
Re: ANN: IBX for Lazarus - Call for Testers
« Reply #10 on: May 09, 2011, 06:27:48 pm »
Thanks for the bug reports received so far. I have uploaded version 0.9.1 to

http://www.mwasoftware.co.uk/ibx

This should fix the issues reported so far.

luk2009

  • Jr. Member
  • **
  • Posts: 50
Re: ANN: IBX for Lazarus - Call for Testers
« Reply #11 on: May 10, 2011, 03:04:57 am »
great job, thanks. I will test and report any problems you'll

exdatis

  • Hero Member
  • *****
  • Posts: 668
    • exdatis
Re: ANN: IBX for Lazarus - Call for Testers
« Reply #12 on: May 10, 2011, 07:09:56 am »
Great job, thanks! :)

laguna

  • Sr. Member
  • ****
  • Posts: 274
Re: ANN: IBX for Lazarus - Call for Testers
« Reply #13 on: May 10, 2011, 09:02:18 am »
Not compile in Mac Leopard 10.6

Error:
file sv5ipc.inc
row: 350
row code: Result := sem_op(FSemaphoreSetID,@sembuf,1);    {May hang on race condition} 
error message: /Developer/lazarus/components/ibx/runtime/sv5ipc.inc(390,45) Error: Incompatible type for arg no. 2: Got "Pointer", expected "LongInt"



miquelmatas

  • Jr. Member
  • **
  • Posts: 98
  • Beginner forever.
Re: ANN: IBX for Lazarus - Call for Testers
« Reply #14 on: May 10, 2011, 09:39:03 am »
Thanks for the bug reports received so far. I have uploaded version 0.9.1 to

http://www.mwasoftware.co.uk/ibx

This should fix the issues reported so far.

webpage says 0.9.0 instead of 0.9.1
--
Cheers.
Miquel.