You may want to check https://github.com/doctrine/dbal/pull/518 regarding DB2 support on IBMi
Marco Pivetta http://twitter.com/Ocramius http://ocramius.github.com/ On 9 May 2014 21:58, Mr E <[email protected]> wrote: > Doctrine's IBM_DB2 driver does not work with DB2 on an i Series server. > Apparently, it was developed using the free version of DB2 (Express-C), and > they don't seem to be the same. > > For example, this is an issue you encounter as soon as you connect to DB2. > Doctrine's ibm_db2 driver looks for tables created by the user in > SYSIBM.SYSTABLES (getListTablesSQL() in DB2Platform). In our i Series > server, SYSTABLES does not reside in SYSIBM. SYSTABLE resides in SCHEMAS. > > If you want to save yourself a world of pain, try not to use doctrine with > DB2. It may only work with the free version of DB2. In that case, why would > you use Express-C instead of MySql or Postgresql? > > Use doctrine with something else and build an integration level in between. > > > On Thursday, October 17, 2013 6:39:16 AM UTC-4, Wei Zhang wrote: >> >> Hi, >> >> I am looking for ORM to work with IBM DB2 database. Doctrine 2 is my >> preference to propose to my company. However I cant really find clear >> confirmation that Doctrine 2 supports IBM DB2. >> >> There are confusing information on the internet. Doctrine 2 documentation >> says IBM Db2 is not supported. On the other hand I found JIRA ticket from >> Doctrine saying IBM DB2 support has been added since 2010. With further >> research, I found issues from other users about the DB2 driver and there is >> no answer after it. This really worries me. >> >> Here I just would like to get confirmation that Doctrine2 supports IBM >> DB2 and which drivers are the most reliable one. I have seen topic here >> about ODBC driver with some issue and resolved well. Does that mean ODBC is >> preferred officially? And what is the verdict regarding the IBM DB2 driver? >> >> Thanks in advanced. >> >> Regards >> >> Wei >> > -- > You received this message because you are subscribed to the Google Groups > "doctrine-user" group. > To unsubscribe from this group and stop receiving emails from it, send an > email to [email protected]. > To post to this group, send email to [email protected]. > Visit this group at http://groups.google.com/group/doctrine-user. > For more options, visit https://groups.google.com/d/optout. > -- You received this message because you are subscribed to the Google Groups "doctrine-user" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. To post to this group, send email to [email protected]. Visit this group at http://groups.google.com/group/doctrine-user. For more options, visit https://groups.google.com/d/optout.
