Author: BerndSG Message: Hello,
I'm trying to activate the Oracle driver property "SetFloatAndDoubleUseBinary" in WAS 6.1 but it does not work, whatever we try. We need to have this enabled because we use the Oracle data type binary_double, and not having this property set leads to errors like this: "Internal Error: Overflow Exception trying to bind 1.0E160" Setting it as a custom property on the datasource does not work. this generates a warning while testing the connection as follows: 10/14/10 20:03:10:208 CEST 00000035 DSConfigurati W DSRA8200W: DataSource Configuration: DSRA8020E: Warning: The property 'SetFloatAndDoubleUseBinary' does not exist on the DataSource class oracle.jdbc.pool.OracleConnectionPoolDataSource. 10/14/10 20:03:13:162 CEST 00000035 DSConfigurati I DSRA8203I: Database product name : Oracle 10/14/10 20:03:13:162 CEST 00000035 DSConfigurati I DSRA8204I: Database product version : Oracle Database 10g Enterprise Edition Release 10.2.0.4.0 - 64bit Production With the Partitioning, Real Application Clusters, OLAP, Data Mining and Real Application Testing options 10/14/10 20:03:13:162 CEST 00000035 DSConfigurati I DSRA8205I: JDBC driver name : Oracle JDBC driver 10/14/10 20:03:13:162 CEST 00000035 DSConfigurati I DSRA8206I: JDBC driver version : 11.2.0.1.0 10/14/10 20:03:13:193 CEST 00000035 DSConfigurati I DSRA8030I: Successfully connected to DataSource, with 1 warnings. I've written some tests to check whether this attribute works at all, using basic JDBC API, see attached Java code. The question is how to get this activated within Websphere Application Server 6.1. Any ideas or solutions to that? Many thanks in advance! Regards, Bernd To respond to this post, please click the following link: <http://www.ibm.com/developerworks/forums/thread.jspa?messageID=14542631> ____________________________________ Unsubscribe via the "binocular" icon on the web