Topic
IC4NOTICE: developerWorks Community will be offline May 29-30, 2015 while we upgrade to the latest version of IBM Connections. For more information, read our upgrade FAQ.
2 replies Latest Post - ‏2010-06-16T14:53:59Z by spoonware
spoonware
spoonware
5 Posts
ACCEPTED ANSWER

Pinned topic Services that change data are failing

‏2010-06-15T20:10:48Z |
We just started working with WPF 7 beta and are testing it with the models that we built for the Top Gun course we wrote for Portlet Factory Application Development. We are finding that when we run any service created using SQL Call builders that change data (i.e. insert, update, or delete) the service fails and returns this message:
prepareStatement with auto-generated keys is not supported in this version of DB2 JDBC 2.0 driver.

We tried adding a new SQL Call and Service Operation builder and used the Database Explorer in the SQL Call builder thinking that maybe something was different about using new builder calls versus using models that we wrote in earlier versions of WPF. It didn't make any difference. We have been using these models in 6.1.5 as well as in several earlier version.

These failures happen when using the testing features in a service provider model and when using Data Page in a service consumer model.

Attached is the error message and below that message, in the same file, I included all of the messages from the general.txt log file.

We're trying to narrow down the problem and want some input from the Portlet Factory team before we go trying to change jdbc drivers, etc.

Can you help us understand what's going on here?

Spoon

Puzzled by Portlet Factory?
We've got the answers.
http://www.davalen.com
Updated on 2010-06-16T14:53:59Z at 2010-06-16T14:53:59Z by spoonware
  • DGawron
    DGawron
    251 Posts
    ACCEPTED ANSWER

    Re: Services that change data are failing

    ‏2010-06-15T21:07:45Z  in response to spoonware
    You need to update your driver to a more recent version; JDBC 3.0 or better. JDBC 2.0 is ancient and doesn't support all of the features required by WPF 7.
    • spoonware
      spoonware
      5 Posts
      ACCEPTED ANSWER

      Re: Services that change data are failing

      ‏2010-06-16T14:53:59Z  in response to DGawron
      Thanks, Dave. I will dig around and try to find one.

      Spoon

      Puzzled by Portlet Factory?
      We've got the answers.
      http://www.davalen.com