ZF2 and DB2 for IBM i

I’d like to address questions about DB2 support in Zend Framework 2.x. Because I helped create the IBM i-friendly DB2 adapter for Zend Framework 1.x, I’ve followed the development of a similar adapter for ZF2.

(updated January 30, 2013, upon the release of ZF 2.1)

Q. Does ZF 2 include an adapter for DB2?
A. Yes! Starting with ZF 2.1, which was released today.

Q. Is Alan’s IBM i-friendly DB2 adapter for Zend Framework 1.x needed in 2.x?
A. No. Because ZF’s Zend_Db equivalent in 2.x works differently than in 1.x, my 1.x component is not needed in 2.x.

Q. Does ZF 2.1’s DB2 adapter work with IBM i?
A. Yes! Please try it and provide feedback to the ZF team.

This entry was posted in db2, IBM i, iSeries, Open Source, PHP, System i, Zend Framework and tagged , , , , , , , , , , . Bookmark the permalink.

11 Responses to ZF2 and DB2 for IBM i

  1. Alan Seiden says:

    I’ve updated this post to reflect today’s release of ZF 2.1, which includes a DB2 adapter that works with IBM i.

  2. Andy Youens says:

    Hi Alan

    Does ZF2 have to be installed outside of the Zend Server updates?

    Hotfix 7 does not seem to update ZF1 to ZF2.

    Regards
    Andy Youens

  3. Alan Seiden says:

    Hi, Andy,

    You wouldn’t want an automatic ZF1-to-ZF2 update. ZF2 is a major redesign with its own learning curve.

    At present, you’ll have to download and install ZF2 yourself, which is a good idea anyway, because you’ll get the latest version. Download ZF2 here: http://www.framework.zend.com/.

    Alan

  4. Andy Youens says:

    Thanks for the reply Alan, appreciated.

    Will you be doing any presentations on ZF2 on the IBM I in the near future?

    Best Regards
    Andy

  5. Alan Seiden says:

    Andy, yes, I have a ZF2 on IBM i talk scheduled for COMMON in April, 2013.

    Details here: http://www.alanseiden.com/presentations/upcoming/

    Alan

  6. Alan Seiden says:

    To answer your original question, Andy, Hotfix 7 does include Zend Framework 2.02, but it’s installed in a separate folder from ZF 1. Therefore, your applications won’t automatically update, which is good, because ZF2 is quite different from ZF1. What’s more, ZF 2.02 didn’t have a DB2 adapter. The DB2 adapter was shipped with the later release 2.1.

    Here are the paths where ZF1 and 2 are installed by default:
    ZF1: /usr/local/zendsvr/share/ZendFramework
    ZF2: /usr/local/zendsvr/share/ZendFramework2

  7. Andy Youens says:

    Spot on!

    Many thanks Alan

    Regards
    Andy

  8. Rodney says:

    Hey Alan,
    I’m currently working on a zf2 app on the ibmi. I have it mostly workin except for paginating result sets with the Zend\Paginator\Adapter\DbSelect. Db2 doesn’t support the LIMIT and OFFSET function, which I know are not ANSI SQL, but I have another zf1 app on the i that uses the paginator dbselect and it works great. Just wondering if the zf2 app is not using the native ibmiDb2 driver/adapter. Would happen to know the proper driver and adapter name?

    • Alan Seiden says:

      Hi, Rodney,

      The driver should be “IbmDb2”. Have you been successful with DB2 from ZF2 aside from the pagination issue?

      Alan

      • Rodney says:

        I would say yes up to this point. I have run into some other inconsistencies with the Zend\Db\Sql\Select with ZF2. Using the methods in this class to build Sql statements do not always give you the expected results. I’m finding its better to just write the statements long hand, prepare them and then execute. Gives up some abstraction when and if we need to move it to a different platform or Db but at least the project keeps moving :)

        The paginator is a big issue right now since I’m working with a very large tables and bringing back the entire result set, then paginating over it is not an option.

        The zf2 docs say that I should extend the paginator’s DbSelect class and override the getItems method and implement a custom limit and offset routine. Easy enough, but I’m struggling a bit with the correct sql that Db2i could use to simulate this. How would you handle this?

  9. throwback baseball jerseys El Ahly Jersey wholesale mlb
    jerseys

  10. cheap nhl jerseys free shipping St. Louis Blues Jersey nhhl vintage jerseys

  11. cheap jerseys us wholesale nba jerseys china cheap jerseys
    usa

  12. Thanks a bunch for sharing this with all folks you really know what you are speaking approximately! Bookmarked. Please also consult with my site =). We could have a hyperlink alternate arrangement among us|

  13. I’m really inspired along with your writing talents as well as with the format on your weblog. Is that this a paid subject matter or did you customize it yourself? Anyway stay up the excellent high quality writing, it’s uncommon to peer a great weblog like this one nowadays..|

  14. mlb shop promo nfl shop cyber monday cojpons wholesale nfl jerseys china free shipping

  15. viagra says:

    free animal sex pics

  16. porn videos says:

    free animal sex pics

  17. WOW just what I was searching for. Came here by searching for chemical control of
    pests

  18. The other private investigator activities that we carry also include discovering any hidden financial assets, providing room
    hard wre audio and visual surveillance and undertaking
    pre-employment screening for your business. Andd how do they get these videos,
    files, songs and games. There are some challenges that face interracial dating because oof cultural differences between interracial couples.

  19. I think the admin of this website is really working hard in favor of his web site, because here every information is
    quality based material.

  20. So things would be easier for both, for you and your car mover.
    In fact, some people easily spend upwards of $30,000 on a single car.
    It is very important to request this factor so that
    you get your papers up to date nicely prior to the transportation.

  21. Expert plastic extrusion companies serve the vital function of creating specific shapes out of hard plastic
    that are used to make various other products like tubing,
    casing, and more. In the cross over or perhaps soften step, the main width within the attach heightens even though the peak on the flight journey will reduce.

    The plastic extruder consists from the extrusion device, the extrusion and pressing
    system, the transmission system and the heating and cooling system.

  22. I love what you guys are up too. Such clever work and coverage!
    Keep up the terrific works guys I’ve included you guys to
    blogroll.

  23. lun says:

    Greetings! Very useful advice within this post!
    It’s the little changes that make the most important changes.

    Many thanks for sharing!

  24. Wow, this piece of writing is pleasant, my younger sister
    is analyzing these kinds of things, therefore I am going to
    inform her.

  25. If you resemble many of today’s seniors who are stressed over retired life security and also as a result of inadequate
    funds, you can contribute to your nest egg by starting your very
    own company with fairly low funding.

  26. cheap jereys china Your brilliant choice wholesale jerseys for
    sale cheap mlb jerseys

  27. sports jerseys Cheap Cleveland Cavaliers Jerseys nhl jerseys

  28. Denver Broncos,Denver Broncos #18 Peyton Manning Blue Stitched NFL Jerseys,
    T-Shirts, Apparel, Gear for Men,Women and Kids. Buy your boy/girl the wholesale price jerseys,
    other great hot jerseys for pick.

  29. A motivating discussion is worth comment. There’s no doubt that that you should publish more on this topic,
    it might not be a taboo matter but usually people do not speak about these issues.
    To the next! Best wishes!!

  30. Cheap NFL Jerseys, jerseys bulk order at wholesale price free shipping.
    We are specialized in football jerseys, and also supply styles of hockey jerseys, soccer jerseys, basketball jerseys.
    Find new arrivals 2016!
    Buy: cheap nfl jerseys

  31. Felixyfgkkpr says:

    I see, that your website needs unique and fresh articles.
    I know it’s hard to write content manually everyday, but there is solution for this.

    Simply search in google for: Imcad’s Essential Tool

  32. Pendrive 2Gb says:

    Very nice article, just what I was looking for.

  33. Vietnam (10th April, 2015) — Vietnam is often referred to as
    a sparkling jewel in the seas of Southeast Asia with beauty, culture, food
    and the friendliest people you’ll ever meet.
    07:45 – 8:30: We’ll pick you up at your hotel and then leave for Ha
    Long city. Halong Tours  ,promising amazingly unforgettable travelling time, would definitely bring youpriceless Vietnam tour experiences.

  34. Jack says:

    ARM (Arm) loans are offered with settlement terms of thirty years They are primarily granted to prospects with an bad credit standing.

  35. Bill says:

    The bottom line on credit restoration is that it can take time, and trying to avoid in which
    reality will simply leave you worse off eventually and prevent
    you from making the positive changes in your own financial existence
    that you are competent at achieving If you take out there multiple
    cash advance loans you will end up within a never ending
    circuit of debts.

  36. christine says:

    The main benefit of an online category format is that is is often accessed everywhere you go in the world Tailored Military Outfits

  37. john says:

    Nevertheless what you in the end do is determined by
    what you price the most, as well as smallest amount Your poor credit report is completely sidelined as well as its impression has no
    effect on the decision of capital lender

  38. Cheap NFL Jerseys, jerseys bulk orxer at wholesale
    price free shipping. We are specialized in football jerseys, and also supply styles of
    hockey jerseys, soccer jerseys, basketball jerseys.
    Find new arrivals 2016!
    Buy: cheap nfl jerseys

  39. Cheap NFL Jerseys, jerseys bulk order at wholesale
    price free shipping. We are specialized in football
    jerseys, and also supply styles of hockey jerseys,
    soccer jerseys, basketball jerseys. Find neww
    arrivals 2016!
    Buy: Click into site

  40. This page certainly has all of the information and facts I wanted about this subject and didn’t know who
    to ask.

  41. En este video porno podemos ver una despedida de soltera en la que invita a un par
    de strippers y con los que se lo acaban pasando muy bien comiendo
    sus pollas y follandoselos mientras el resto de amigas miran y animan el
    cotarro.

  42. Hi my family member! I wish to say that this article is amazing,
    great written and come with almost all important infos. I’d like to peer extra posts like this .

  43. The risk is your own – do make certain you understand the
    exchange/return policy of your cushion shop before
    you finish the sale.

  44. Hello everybody, here every person is sharing these kinds of familiarity, thus it’s nice to read this
    web site, and I used to go to see this website everyday.

  45. Ceramic and band heaters are a bit expensive compared to a wire coil heater, but the benefits they offer are great.

    This mess which is used so that you can propel
    the liquid plastic resin right out the kick the bucket may be
    the crucial part of your bang extruder. Extruders may be divided into three general types :
    .

  46. Je suis tout à fait en accord avec toi

Leave a Reply

Your email address will not be published. Required fields are marked *