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

2007-03-22 Thread Steve Ebersole

IBM product?  P...  Have fun ;)

Seriously, I have no idea.

But from 
(http://www.redbooks.ibm.com/pubs/html/as400/v4r5/ic2924/index.htm?info/db2/rbal1mst141.htm?notoc):

quote
Handling connection request failures for TCP/IP

The main causes for failed connection requests at a DRDA server configured for 
TCP/IP use is that the DDM TCP/IP server is not started, an authorization error 
occurred, or the machine is not running.

/quote


Aleksandar Kostadinov wrote:

Hi

I'm trying to setup DB2 7.2 cruisecontrol build but have this:
   Tests Failures Errors Success rate  Time
   1043  868633.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:5/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


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

2007-03-22 Thread 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  868633.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:5/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