kafoso / doctrine-firebird-driver Goto Github PK

Hi,
On some serveur i've got the error:
General error: -303 Dynamic SQL Error SQL error code = -303 arithmetic exception, numeric overflow, or string truncation
with standard verison of bundle and with the pdo version actually in pull request.
The error is present when a query is made with a prepare and then execute with an integer parameters.
The problem is present on 2 of my server in php7.2.34 and not present on other in same os and php version.
I really don't understand what is the problem.
Can someone help me please ?
Thanks

Hi, I'm using uuid field and I try to use the hex syntax in a doctrine query to obtain something like this:

SELECT * FROM table WHERE id = x'64f8d6f011163f48b4cb8325773d13ff'

https://firebirdsql.org/refdocs/langrefupd25-hexbinstrings.html

Do you have an idea of how I could implement it in doctrine?

PHP have unbundled the interbase extension as of 7.4 and moved it into PECL. However, the project on PECL has no releases as of yet, and considering the reasons for unbundling and deprecating the extension, and its commit log, I suspect it's quite likely that there will not be any releases at all.

Would it be possible to migrate this driver to PDO? Also, I'm curious about why it wasn't implemented this way from the start.

Hi, I have installed your package in symfony 3.4 and for the queries it works perfectly, but when you try to perform an update or an insert, when you perform the transaction an error occurs and it is disconnected.firebird 2.5.2
PHP 7.3 4
 "phpunit / phpunit": "^ 8.2",
 "doctrine / orm": "^ 2.6",
"doctrine / dbal": "2.6. *",
The error that appears from postman is:
Could not get any response There was an error connecting to
http: //localhost/miweb/rest/web/app_dev.php/pedido/new.

Could you suggest a solution? Thank you.

In ibase_connect function, 6th parameter is for dialect select.

By default it's 0 (autoselect), but if i want to force this value to be 3, I can't do that.

Mayby you can add in config something like this?

options:
    dialect: 3

Is that possible to upgrade to the most recent version of doctrine ?

In case of sql error, i get the folling error:
Call to undefined method Kafoso\DoctrineFirebirdDriver\Driver\FirebirdInterbase\Statement::checkLastApiCall()

Hello,
Dear friend, I have a business class that saves twice, two records in the same table, so the generator should add twice. But it has only one more number. All in the same transaction.
Example: generator = 234
register 235 save and 236 save, but generator show me 235.
I have a problem when saving next register. duplicate primary key.

Congratulations on the bundle!

I have a few questions:

1. Is it still maintained?
2. Are there any plans on upgrading to firebird 3.x

I have a client that is using firebird 2 but plans to upgrade to firebird 3. How hard can it be to adapt the bundle?

Thank you!

Hey Folks!

I'm trying to use the fork of this repo:
https://github.com/Ambacia-consulting/doctrine-firebird-driver

I'm using symfony 5.4 with php8.1 (or later if I'm able to upgrade any further...).
Problem is that I'm alway getting an error and parameter injection for some reason does not work.

So we have switch to pdo_firebase as interbase / ibase must be installed on our own - which is not feasible in lookout for our hosting...

Error
Too few arguments to function IST\DoctrineFirebirdDriver\Driver\AbstractFirebirdInterbaseDriver::__construct(), 0 passed in /var/www/html/vendor/doctrine/dbal/lib/Doctrine/DBAL/DriverManager.php on line 291 and exactly 1 expected

services.yaml

IST\DoctrineFirebirdDriver\Driver\AbstractFirebirdInterbaseDriver:
    arguments:
        $configuration: '@doctrine.dbal.firebird_connection.configuration'

App\Service\FirebirdService:
    arguments:
        $db: '@doctrine.dbal.firebird_connection'

Anyone a quick guess?

Best,
Bent

Add ext requirement on composer.json.

Example:

ext-interbase: "*"