It seems that Zend Skeleton (I tried to install using this tutorial) updated and now it comes with zend-mvc version 3.0.1, but when I try to install DoctrineORMModule, I get this error:

Using version ^1.0 for doctrine/doctrine-orm-module ./composer.json has been updated Loading composer repositories with package information Updating dependencies (including require-dev) Your requirements could not be resolved to an installable set of packages.

Problem 1 - Installation request for doctrine/doctrine-orm-module ^1.0 -> satisfiable by doctrine/doctrine-orm-module[1.0.0]. - doctrine/doctrine-orm-module 1.0.0 requires zendframework/zend-mvc ^2.5.2 -> satisfiable by zendframework/zend-mvc[2.5.2, 2.5.3, 2.6.0, 2.6.1, 2.6.2, 2.6.3, 2.7.0, 2.7.1, 2.7.10, 2.7.2, 2.7.3, 2.7.4, 2.7.5, 2.7.6, 2.7.7, 2.7.8, 2.7.9] but these conflict with your requirements or minimum-stability.

Installation failed, reverting ./composer.json to its original content.

I have an OneToMany unidirectional with Join Table relationship between Employee and EmployeeCommission, using a Zend\Form\Element\Collection but when I set "$commissions = new ArrayCollection();" into "__construct()" of the Employee entity, the $form, lose the Collection fieldset, and it breaks to render. I already changed the relationship to OneToMany Bidirectional but happens the same. I'm not sure if it's an doctrine's issue, but i've tried it with other versions of ZF2 and doctrine and it keeps. I'm using ZF 2.3.1, doctrine-module and doctrine-orm-module 0.8.0.

code following:

Employee entity:

<?php

namespace Employee\Entity;

use Doctrine\ORM\Mapping as ORM;
use Doctrine\Common\Collections\ArrayCollection;


/**
 * @ORM\Entity(repositoryClass="Employee\Entity\Repository\Employee")
 * @ORM\Table(name="employee")
 */
class Employee {

    /**
     * @ORM\Id
     * @ORM\Column(name="employee_id", type="bigint")
     * @ORM\GeneratedValue(strategy="AUTO")
     */
    protected $employeeId;

    /**
     * @ORM\ManyToMany(targetEntity="Employee\Entity\EmployeeCommission", mappedBy="employee", cascade="all")
     * @ORM\JoinTable(name="employee_employee_commission",
     *      joinColumns={@ORM\JoinColumn(name="employee_id", referencedColumnName="employee_id")},
     *      inverseJoinColumns={@ORM\JoinColumn(name="employee_commission_id", referencedColumnName="employee_commission_id", unique=true)}
     * )
     */
    protected $commissions;

    public function __construct() {
        $this->commissions              = new ArrayCollection();
    }
    ... setter

    ... getter
}

EmployeeCommission entity:

<?php

namespace Employee\Entity;

use Employee\Entity\Employee;
use Doctrine\ORM\Mapping as ORM;

/**
 * @ORM\Entity
 * @ORM\Table(name="employee_commission")
 */
class EmployeeCommission {

    /**
     * @ORM\Id
     * @ORM\Column(name="employee_commission_id", type="integer")
     * @ORM\GeneratedValue(strategy="AUTO")
     */
    protected $employeeCommissionId;

    /**
     * @ORM\Column(name="employee_commission_fixed", type="decimal", precision=2)
     */
    protected $employeeCommissionFixed;

    /**
     * @ORM\Column(name="employee_commission_variant", type="decimal", precision=2)
     */
    protected $employeeCommissionVariant;

    /**
     * @ORM\OneToOne(targetEntity="Product\Entity\Product", cascade={"persist"})
     * @ORM\JoinColumn(name="product_id", referencedColumnName="product_id")
     */
    protected $product;

    public function __construct() {
        $this->employeeCommissionFixed = 0.00;
        $this->employeeCommissionVariant = 0.00;
    }

    ... setter
    ... getter
}

links for fieldsets and controller following:

Employee fieldset: http://pastebin.com/NbTZJLGK

EmployeeCommission fieldset: http://pastebin.com/VpDa0ziD

EmployeeController: http://pastebin.com/8P9GUyM8

My app that I am refactoring to use doctrine has different database connections for both of the modules. The documentation says that it's possible to register multiple database connections but I cannot for the life of me figure out how to do it.

An example would be helpful!

Full ZF3 support. Dropped support PHP 5.5 and ZF2. It works with https://github.com/doctrine/DoctrineModule/pull/564.

Need a bit more work. Documentation needs update.

Any suggestions would be appreciated.

(library uses now PSR-4 autoloading, as mentioned in https://github.com/doctrine/DoctrineModule/pull/564 doctrine uses deprecated PSR-0, it could be moved back to PSR-0 later on if needed)

Using doctrine-orm-module together with doctrine-migrations and multiple database connections is currently not possible.

If I don't have an "orm_default" connection / EM / configuration / ... I cant use the CLI commands at all. "orm_default" is hardcoded in MigrationsCommandFactory on line 60 and since there is no configuration for it I get this exception:

InvalidArgumentException: Cannot load migrations from "data/DoctrineORMModule/Migrations" because it is not a valid directory in /x/vendor/doctrine/migrations/lib/Doctrine/DBAL/Migrations/Finder/AbstractFinder.php:38

Next Zend\ServiceManager\Exception\ServiceNotCreatedException: Service with name "doctrine.migrations_configuration.orm_default" could not be created. Reason: Cannot load migrations from "data/DoctrineORMModule/Migrations" because it is not a valid directory in /x/vendor/zendframework/zend-servicemanager/src/ServiceManager.php:765

What we need is an option to choose the object manager / configuration / ... for the migrations commands. Something similar was introduced for all the other commands in PR #524 .

This issue was forked from issue https://github.com/doctrine/DoctrineORMModule/issues/97.

This library currently requires doctrine/persistence ^1.3 but not ^2.0. This prevents updating doctrine/doctrine-module and thus also prevents upgrading doctrine/common to v3.

Could the constraint be loosened to allow ^1.3 || ^2.0?

Is anyone on that?

When calling validate schema, but skipping the sync (for CI purposes), the code still tries to connect to the database.

+ vendor/bin/doctrine-module orm:validate-schema -n --skip-sync
PHP Warning:  array_map(): An error occurred while invoking the map callback in /var/lib/jenkins/jobs/p42-schema-315139603fb1/workspace/vendor/doctrine/doctrine-orm-module/src/DoctrineORMModule/Module.php on line 135

Warning: array_map(): An error occurred while invoking the map callback in /var/lib/jenkins/jobs/p42-schema-315139603fb1/workspace/vendor/doctrine/doctrine-orm-module/src/DoctrineORMModule/Module.php on line 135
PHP Fatal error:  Uncaught exception 'PDOException' with message 'SQLSTATE[HY000] [2002] Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2)' in /var/lib/jenkins/jobs/p42-schema-315139603fb1/workspace/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOConnection.php:43
Stack trace:
#0 /var/lib/jenkins/jobs/p42-schema-315139603fb1/workspace/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOConnection.php(43): PDO->__construct('mysql:host=loca...', 'username', 'password', Array)
#1 /var/lib/jenkins/jobs/p42-schema-315139603fb1/workspace/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOMySql/Driver.php(45): Doctrine\DBAL\Driver\PDOConnection->__construct('mysql:host=loca...', 'username', 'password', Array)
#2 /var/lib/jenkins/jobs/p42-schema-315139603fb1/workspace/vendor/doctrine/dbal/lib/Doctrine/DBAL/Connection.php(358): Doctrine\DBAL\Driver\PDOMySql\Driver->connect(Array, 'username', 'password', Array)
#3 /var/lib/jenkins/jobs/p42-schema-315139603fb1/workspace/vendor/doctrine/dbal/lib/Doctrine/DBA in /var/lib/jenkins/jobs/p42-schema-315139603fb1/workspace/vendor/zendframework/zendframework/library/Zend/ServiceManager/ServiceManager.php on line 909

Fatal error: Uncaught exception 'PDOException' with message 'SQLSTATE[HY000] [2002] Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2)' in /var/lib/jenkins/jobs/p42-schema-315139603fb1/workspace/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOConnection.php:43
Stack trace:
#0 /var/lib/jenkins/jobs/p42-schema-315139603fb1/workspace/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOConnection.php(43): PDO->__construct('mysql:host=loca...', 'username', 'password', Array)
#1 /var/lib/jenkins/jobs/p42-schema-315139603fb1/workspace/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOMySql/Driver.php(45): Doctrine\DBAL\Driver\PDOConnection->__construct('mysql:host=loca...', 'username', 'password', Array)
#2 /var/lib/jenkins/jobs/p42-schema-315139603fb1/workspace/vendor/doctrine/dbal/lib/Doctrine/DBAL/Connection.php(358): Doctrine\DBAL\Driver\PDOMySql\Driver->connect(Array, 'username', 'password', Array)
#3 /var/lib/jenkins/jobs/p42-schema-315139603fb1/workspace/vendor/doctrine/dbal/lib/Doctrine/DBA in /var/lib/jenkins/jobs/p42-schema-315139603fb1/workspace/vendor/zendframework/zendframework/library/Zend/ServiceManager/ServiceManager.php on line 909
Build step 'Execute shell' marked build as failure

I am blocked by zendframework/zf2#3726, so I have attempted to step around the problem by implementing Doctrine.

I have completed the Doctrine 2 tutorial to replace Zend\Db calls in the Album example. I did this using MySQL on a Windows workstation. Everything works - all good.

Next step - repeat on the IBMi.

It does not work. Following is the configuration extract from /config/autoload/local.php

'doctrine' => array(
    'connection' => array(
        'orm_default' => array(
            'driverClass' => 'Doctrine\DBAL\Driver\IBMDB2\DB2Driver',
            'params' => array(
                'host' => 'dse',
                'port' => '50000',
                'user' => '***',
                'password' => '***',
                'dbname' => '*LOCAL',
            ),

I can connect to DB2 by calling 'db2_connect' with the information above.

Note the driver definition. I found this in /vendor/doctrine/dbal/lib/Doctrine/DBAL/DriverManager.php

But a call to $this->getEntityManager()->getRepository(...)->findAll(); results in the following exception;

PDOException

File:
/www/local/zf2/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOConnection.php:36

Message:

SQLSTATE[HY000] [2002] Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2)
Stack trace:

#0 /www/local/zf2/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOConnection.php(36): PDO->__construct('mysql:host=loca...', 'username', 'password', Array)
#1 /www/local/zf2/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOMySql/Driver.php(47): Doctrine\DBAL\Driver\PDOConnection->__construct('mysql:host=loca...', 'username', 'password', Array)
#2 /www/local/zf2/vendor/doctrine/dbal/lib/Doctrine/DBAL/Connection.php(350): Doctrine\DBAL\Driver\PDOMySql\Driver->connect(Array, 'username', 'password', Array)
#3 /www/local/zf2/vendor/doctrine/dbal/lib/Doctrine/DBAL/Connection.php(627): Doctrine\DBAL\Connection->connect()
#4 /www/local/zf2/vendor/doctrine/orm/lib/Doctrine/ORM/Persisters/BasicEntityPersister.php(844): Doctrine\DBAL\Connection->executeQuery('SELECT t0.CUR A...', Array, Array)
#5 /www/local/zf2/vendor/doctrine/orm/lib/Doctrine/ORM/EntityRepository.php(157): Doctrine\ORM\Persisters\BasicEntityPersister->loadAll(Array, NULL, NULL, NULL)
#6 /www/local/zf2/vendor/doctrine/orm/lib/Doctrine/ORM/EntityRepository.php(141): Doctrine\ORM\EntityRepository->findBy(Array)
#7 /www/local/zf2/module/Application/src/Application/Controller/IndexController.php(69): Doctrine\ORM\EntityRepository->findAll()

There is no reference in the (my) code on the IBMi to a MySQL server, yet the error clearly states a failure to connect to MySQL.

Has anyone had any success connecting to IBMi DB2 using Doctrine or Zend/Db on ZF2?

It may be interesting to provide a helper (or custom Symfony Application) that replaces the EntityManager or DBAL Connection helpers based on a provided parameter such as --em=name_of_em_service

I use 'doctrine_em' alias. After recent update I got fatal error:

Uncaught exception 'Zend\Di\Exception\MissingPropertyException' with message 'Missing instance/object for parameter params for DoctrineORMModule\Doctrine\ORM\Connection::__construct' in /proj/vendor/ZendFramework/library/Zend/Di/Di.php on line 617

If I change

'Doctrine\ORM\EntityManager' => array(
    'parameters' => array(
        'conn' => 'orm_connection',
    )
),

to

'orm_em' => array(
    'parameters' => array(
         'conn' => 'orm_connection',
    )
),

at the end of DoctrineORMModule/config/module.config.php file it works.

I have some trouble, i need to initialize some RouteGuard:

RouteGuard.php

namespace Acl\Guard;

class RouteGuard {
    public function __construct(EntityManager $em)
    {

    }
}

Module.php

.........
class Module {
   public function onBootstrap(MvcEvent $e)
   {
        $sm = $e->getApplication()->getServiceManager();
        $eventManager = $e->getApplication()->getEventManager();
        $eventManager->attach($sm->get('di')->get('Acl\Guard\RouteGuard'));
   }
.....

And i get Exceptions:

1. Fatal error: Uncaught exception 'Zend\Di\Exception\RuntimeException' with message 'Invalid instantiator of type "NULL" for "Doctrine\ORM\EntityManager".' in [projectDir]/vendor/zendframework/zendframework/library/Zend/Di/Di.php on line 767
2. Zend\Di\Exception\RuntimeException: Invalid instantiator of type "NULL" for "Doctrine\ORM\EntityManager". in [projectDir]/vendor/zendframework/zendframework/library/Zend/Di/Di.php on line 298
3. Zend\Di\Exception\MissingPropertyException: Missing instance/object for parameter entityManager for Acl\Service\AclService::__construct in [projectDir]/vendor/zendframework/zendframework/library/Zend/Di/Di.php on line 767

I understand that i try to get(Doctrine\ORM\EntityManager) and DI tries to create new instance and falls with error because EntityManager has a protected constructor. I understand that EntityManager should be instantiated with static method ::create, but i see that DoctrineORMModule already have an instance of Doctrine\ORM\EntityManager with configuration for Doctrine so how could i get this instance in Bootstrap with DI ?

Thanks, in advance.

Hey,

Good day.

We currently having issues with the doctrine EntityBasedFormBuilder. This is our current setup:

<?php
namespace Application\Annotation;

use Doctrine\Laminas\Hydrator\DoctrineObject;
use Doctrine\ORM\EntityManager;
use DoctrineORMModule\Form\Annotation\EntityBasedFormBuilder;
use Laminas\Code\Annotation\Parser\DoctrineAnnotationParser;
use Laminas\Code\Annotation\AnnotationManager;

class Builder
{
    private $customAnnotations = array(
        'Guid',
        ...
    )
    protected $entityManager;

    ...
    public function createForm($entity)
    {
        $builder = new EntityBasedFormBuilder($this->entityManager);
        $form = $builder->createForm($entity);

        $hydrator = new DoctrineObject($this->entityManager, true);
        $form->setHydrator($hydrator);

        return $form;
    }

The bits I am not sure of is why my ‘id’ no longer works for an existing entity? I get the following message:

Additional information:
Laminas\Form\Exception\InvalidElementException
File:
/var/www/html/vendor/laminas/laminas-form/src/Fieldset.php                    :207
Message:
No element by the name of [id] found in form
Stack trace:
#0 /var/www/html/module/Litigation/view/litigation/matter/add.phtml(83): Laminas\Form\Fieldset->get('id')
#1 /var/www/html/vendor/laminas/laminas-view/src/Renderer/PhpRenderer.php(519): include('/var/www/html/m...')
#2 /var/www/html/vendor/laminas/laminas-view/src/View.php(194): Laminas\View\Renderer\PhpRenderer->render(NULL)
#3 /var/www/html/vendor/laminas/laminas-view/src/View.php(222): Laminas\View\View->render(Object(Laminas\View\Model\ViewModel))
#4 /var/www/html/vendor/laminas/laminas-view/src/View.php(187): Laminas\View\View->renderChildren(Object(Laminas\View\Model\ViewModel))
#5 /var/www/html/vendor/laminas/laminas-mvc/src/View/Http/DefaultRenderingStrategy.php(98): Laminas\View\View->render(Object(Laminas\View\Model\ViewModel))
#6 /var/www/html/vendor/laminas/laminas-eventmanager/src/EventManager.php(319): Laminas\Mvc\View\Http\DefaultRenderingStrategy->render(Object(Laminas\Mvc\MvcEvent))
#7 /var/www/html/vendor/laminas/laminas-eventmanager/src/EventManager.php(171): Laminas\EventManager\EventManager->triggerListeners(Object(Laminas\Mvc\MvcEvent))
#8 /var/www/html/vendor/laminas/laminas-mvc/src/Application.php(360): Laminas\EventManager\EventManager->triggerEvent(Object(Laminas\Mvc\MvcEvent))
#9 /var/www/html/vendor/laminas/laminas-mvc/src/Application.php(341): Laminas\Mvc\Application->completeRequest(Object(Laminas\Mvc\MvcEvent))
#10 /var/www/html/public/index.php(31): Laminas\Mvc\Application->run()
#11 {main}

composer.json

        ....
        "doctrine/annotations": "^1.13",
        "doctrine/doctrine-orm-module": "^4.1",
        "doctrine/migrations": "^3.3",
        "doctrine/orm": "^2.10",
        "gedmo/doctrine-extensions": "^3.4",
        ....

Any help would be much appreciated. Thanks.

Regards, Jarrett