[hibernate-dev] Re: hibernate testsuite on DB2 7.2

[Steve Ebersole]

It would appear the DDM bit is specific to iSeries/AS400.  Is that what you are 
running the DB2 instance on?

Found some more info (did you try a web search?):
http://www.aquafold.com/docs-jdbcdrivers-db2.html
<quote>
DB2 7.2 JDBC Driver - DB2 7.2 is the database which has the most connection 
issues. JDBC drivers for database version are not compatible, neither are they 
compatible across fixpacks. Updating your DB2 JDBC driver to the version which 
you are using is always a good idea. The DB2 Server installation provides JDBC 
drivers for the version and fixpack in use. You may copy the provided JDBC 
driver and overwrite the driver provided by ADS. You can copy the 
/sqllib/java/db2java.zip that comes with your installation and overwrite the 
/ADS_INSTALLATION/lib/db2java.jar file.

- NOTE: The DB2 7.2 JDBC driver does not connect directly to the DB2 Server, but 
to a proxy server which is installed with the DB2 Server. This proxy server can 
be started with the db2jstrt[.exe], which defaults to port 6789. The process is 
enabled by default in most installations.
</quote>

I love the "most connection issues" quote ;)

Also, this particular article seems to indicate that DB2 7x does not have 
support at all for a Type4 driver, which is apparently the com.ibm.db2.jcc 
package): 
http://www-128.ibm.com/developerworks/db2/library/techarticle/0203zikopoulos/0203zikopoulos.html


This has nothing to do with Hibernate.  It is a simple JDBC connection issue. 
What happens if you try to connect via direct JDBC with these same 
driver/settings?  Have you tried the drivers that explicitly came with the 
install of DB2 you are trying to use?


Aleksandar Kostadinov wrote:
> Hi
> 
> I'm trying to setup DB2 7.2 cruisecontrol build but have this:
>    Tests Failures Errors Success rate  Time
>    1043  8        686    33.46%       894.810
> 
> I see many "com.ibm.db2.jcc.c.DisconnectException: The DDM parameter is
> not supported. Unsupported DDM parameter..."
> 
> My config is:
> hibernate.dialect org.hibernate.dialect.DB2Dialect
> hibernate.connection.driver_class com.ibm.db2.jcc.DB2Driver
> hibernate.connection.url jdbc:db2://dev34.qa.atl.jboss.com:50000/jbossqa
> 
> As you see I'm using the jcc driver which the database should have
> appropriate bindings for.
> 
> What could be the reason of these failures?
> Is there a special dialect for DB2 7.x? Some particular bindings that
> have to be done so hibernate can work?
> 
> Thanks,
> Aleksandar