[firebird-support] gbak reports Fatal lock manager error:invalid lock id(),errno:22 in firebird.log

2012-12-30 Thread fo...@ymail.com
I published the following report on http://tracker.firebirdsql.org/: http://tracker.firebirdsql.org/browse/CORE-4022 But I do not referred to the answer, which is: That's result of running gbak in embedded mode from root. I appreciate support, clearing the reply or giving me an example to

[firebird-support] Re: FB252 with PHP5.4.10 Apache 2.2.22 gives PHP Warning: PHP Startup: Unable to load dynamic library C:\Program Files (x86)\PHP\ext\php_interbase.dll

2012-12-30 Thread nenhumpois
Copying the fbclient.dll to the same directory as php.exe, gives the following errors when starting Apache: [30-Dec-2012 10:03:10 UTC] PHP Warning: PHP Startup: Unable to load dynamic library 'C:\Program Files (x86)\PHP\ext\php_interbase.dll' - %1 is not a win32 valid application. in

[firebird-support] Re: FB252 with PHP5.4.10 Apache 2.2.22 gives PHP Warning: PHP Startup: Unable to load dynamic library C:\Program Files (x86)\PHP\ext\php_interbase.dll

2012-12-30 Thread nenhumpois
I removed PHP5.4.10 and installed 5.3.20 and i get the same result. I believe that php_interbase.dll and php_pdo_firebird.dll are not compatible with windows 8 64 bits. Can any one confirm this? Where can i get newer DLL files? Thank you

[firebird-support] Re: FB252 with PHP5.4.10 Apache 2.2.22 gives PHP Warning: PHP Startup: Unable to load dynamic library C:\Program Files (x86)\PHP\ext\php_interbase.dll

2012-12-30 Thread tomsee7
Hi, These two links may help: http://www.sitepoint.com/forums/showthread.php?676233-php_mysqli-dll-is-not-a-valid-Win32-Application http://board.phpbuilder.com/showthread.php?10371443-RESOLVED-php-and-mysql-wont-talk-to-each-other HTH, Tom --- In firebird-support@yahoogroups.com, nenhumpois

[firebird-support] Declare and use array datatype in stored procedures

2012-12-30 Thread jb...@ymail.com
Hi, Maybe this question was already answered, but I searched and couldn't find a suitable answer. If so, please point me to an existing answer/FB document. What I'd like to know is if Firebird (2.0.6) supports in-memory arrays in stored procedures? The closest answer I found was here:

RE: [firebird-support] Declare and use array datatype in stored procedures

2012-12-30 Thread Hans
http://ibexpert.net/ibe/index.php?n=Doc.Array -Original Message- From: firebird-support@yahoogroups.com [mailto:firebird-support@yahoogroups.com] On Behalf Of jb...@ymail.com Sent: Sunday, December 30, 2012 9:10 AM To: firebird-support@yahoogroups.com Subject: [firebird-support] Declare

[firebird-support] Re: Declare and use array datatype in stored procedures

2012-12-30 Thread jb...@ymail.com
Thanks for the answer, but the given link describes the array column type, so I'd have to create a table to use it, and if I have to create a table, I can as well create a table with the following structure: test_tab(key number, value varchar(40)) which suits my needs. What I'm asking for is

[firebird-support] Re: NoSQL access to firebird database

2012-12-30 Thread alex_evr
--- In firebird-support@yahoogroups.com, mariuz mariuz@... wrote: Is there any solution (or are there any works on such solution) that allows NoSQL access to FireBird database? (Something like HandlerSocket plugin for MySQL). We'd like to port to FireBird large legacy application

RE: [firebird-support] Re: Declare and use array datatype in stored procedures

2012-12-30 Thread Hans
Maybe a Temporary table will do it. Something like: CREATE GLOBAL TEMPORARY TABLE SESSION_VARS ( USER_UNIQUENUM integer NOT NULL, TICKET_UNIQUENUM integer NOT NULL ) ON COMMIT PRESERVE ROWS; (More options available here) It is unique for each connection and lasts as long as the connection

[firebird-support] Re: Declare and use array datatype in stored procedures

2012-12-30 Thread jb...@ymail.com
Thanks for the fast response. That could be an option, unfortunately GTTs were added only in 2.1 (I'm running on 2.0.6): SQL CREATE GLOBAL TEMPORARY TABLE SESSION_VARS CON ( CON USER_UNIQUENUM integer NOT NULL, CON TICKET_UNIQUENUM integer NOT NULL CON ) CON ON COMMIT PRESERVE ROWS; Statement

RE: [firebird-support] Re: Declare and use array datatype in stored procedures

2012-12-30 Thread Hans
Why dig yourself in deeper? Doubt anyone offers much support for out-of-date versions - thanks for the fast response. - That could be an option, unfortunately GTTs were added only in 2.1 (I'm running on 2.0.6):

[firebird-support] Re: Declare and use array datatype in stored procedures

2012-12-30 Thread jb...@ymail.com
I know we are on an outdated version, but as I wrote, even if we were on a newer version which has GTTs, I'm still interested (for the reasons stated in the previous post) if Firebird supports the type of arrays I described. If it doesn't its fine as well, it means I'll have to find a (bad)