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
_______________________________________________
hibernate-dev mailing list
hibernate-dev@lists.jboss.org
https://lists.jboss.org/mailman/listinfo/hibernate-dev

Reply via email to