Hi, I think this functionality is not exposed from our ndatasource RDBMSDataSourceReader implementation. We would have to put a new property to set these "DB properties". I think, these must be the properties passed into when creating a new connection with this [1]. @Madhawa, shall we implement this for a future Kernel release, by adding a new section to put these properties in the configuration.
[1] http://docs.oracle.com/javase/7/docs/api/java/sql/DriverManager.html#getConnection(java.lang.String,%20java.util.Properties) Cheers, Anjana. On Thu, Oct 8, 2015 at 3:33 PM, Isuru Perera <[email protected]> wrote: > Hi, > > With Carbon Metrics, I need to save some "double" values in the database. > Sometimes the Oracle JDBC Driver throws "Underflow" exceptions [1] when > trying to set a double to a prepared statement. > > To solve that issue, I changed the database columns to "BINARY_DOUBLE > <https://docs.oracle.com/cd/E11882_01/timesten.112/e21642/types.htm#BABIGDEA>" > [2] and I want to set the property "SetFloatAndDoubleUseBinary" to true. > > I tested this with a standalone app with Tomcat JDBC and it works. > > import org.apache.tomcat.jdbc.pool.DataSource; > import org.apache.tomcat.jdbc.pool.PoolProperties; > ... > > PoolProperties p = new PoolProperties(); > p.setUrl("jdbc:oracle:thin:@localhost:1521/metrics"); > p.setDriverClassName("oracle.jdbc.OracleDriver"); > p.setUsername("USER"); > p.setPassword("PASSWD"); > .... > DataSource datasource = new DataSource(); > datasource.setPoolProperties(p); > > > *Properties properties = new > Properties();properties.setProperty("SetFloatAndDoubleUseBinary", > "true");p.setDbProperties(properties);* > > I thought there is a way to set these kinds of properties in > *-datasources.xml file. However I don't see a way to do that in > configuration [3]. > > I don't want to change the double values and I want to save it directly in > the database. How do we fix this? > > Thanks! > > Best Regards, > > [1] https://wso2.org/jira/browse/MB-1271 > [2] > https://docs.oracle.com/cd/E11882_01/timesten.112/e21642/types.htm#BABIGDEA > [3] > https://github.com/wso2/carbon-kernel/blob/v4.4.1/core/org.wso2.carbon.ndatasource.rdbms/src/main/java/org/wso2/carbon/ndatasource/rdbms/RDBMSConfiguration.java > -- > Isuru Perera > Associate Technical Lead | WSO2, Inc. | http://wso2.com/ > Lean . Enterprise . Middleware > > about.me/chrishantha > Contact: +IsuruPereraWSO2 <https://www.google.com/+IsuruPereraWSO2/about> > -- *Anjana Fernando* Senior Technical Lead WSO2 Inc. | http://wso2.com lean . enterprise . middleware
_______________________________________________ Dev mailing list [email protected] http://wso2.org/cgi-bin/mailman/listinfo/dev
