[jboss-user] [JCA/JBoss] - Re: JBOSS & DB2 V9.1 : com.ibm.db2.jcc.c.SqlException: SQL10

[vickyk]

"vickyk" wrote : Can you point  LD_LIBRARY_PATH variable to to lib32 for DB2V9.1 ?
  | Have a look at this 
  | http://lekkimworld.com/2005/02/18/connecting_to_ibm_db2_v_8_x_using_jdbc.html
  | The DB2 type4 driver seems not to be fully pure java as described by the JDBC specifications , it will not work unless the LD_LIBRARY_PATH points to correct native libraries in the lib32 (or lib in DB2 V8)
  | 
This statement is wrong .... Apologies for misleading you here , you had basically configured type 2 driver here .
Actually you can get Type 4 behavior by setting the driverType property to 4 as 
<xa-datasource-property name="DriverType">4</xa-datasource-property>
You don't need to set the LD_LIBRARY_PATH once this is done .

Vicky

View the original post : http://www.jboss.com/index.html?module=bb&op=viewtopic&p=4105181#4105181

Reply to the post : http://www.jboss.com/index.html?module=bb&op=posting&mode=reply&p=4105181