Re: [Geotools-gt2-users] DB2 Universal driver Mode 4

[David A. <da...@ri...>]

I'm afraid there is a bug in the GeoTools DB2 driver with the JDBC type 4 
connection.

I thought it was using type 4 but it turns out that it was defaulting to 
type 2 in all
cases.  The fix for this should be checked in for GeoTools 2.1 but has not 
yet been
checked in for 2.2.

It will be a couple days before I am back in the office and can sort this out.

At 07:23 AM 6/23/2006, Holz, Thorsten wrote:
>Hey,
>
>I've got a problem with the DB2DataStore in Version GeoTools 2.2.RC2 (I
>don't try it with other versions ;-) )
>Since DB2 Version 8 the DB2 jdbc Universal Driver is shipped. It works
>either in mode 2 (requires a DB2 8 Client installation) or mode 4 (pure java
>implementation without
>any client installed on enviroment). So I tried to use the DB2 jdbc driver
>in mode 4 with the DB2DataStore, but everytime I get the error
>
>23-Jun-2006 13:19:43 org.geotools.data.db2.DB2ConnectionFactory
>getConnectionPool
>INFO: Created new DB2ConnectionPoolDataSource for dbUrl
>jdbc:db2://xxx.xxx.xxx.xxx:xxxx/ESR
>23-Jun-2006 13:19:43 org.geotools.data.db2.DB2ConnectionFactory
>getConnectionPool
>INFO: Successfully obtained DB2 ConnectionPool
>com.ibm.db2.jcc.a.SqlException: Failure in loading T2 native library
>db2jcct2
>
>because a DB2 Version 8 client installation is missing which includes this
>dll. So, my question is, is there any possiblity
>to run the DB2 jdbc driver in mode 4 or  is there any reason not to do so?
>
>
>Thanks in advance
>
>
>Using Tomcat but need to do more? Need to support web services, security?
>Get stuff done quickly with pre-integrated technology to make your job easier
>Download IBM WebSphere Application Server v.1.0.1 based on Apache Geronimo
>http://sel.as-us.falkag.net/sel?cmd=lnk&kid=120709&bid=263057&dat=121642
>_______________________________________________
>Geotools-gt2-users mailing list
>Geo...@li...
>https://lists.sourceforge.net/lists/listinfo/geotools-gt2-users