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.
