Created a JIRA: https://wso2.org/jira/browse/CARBON-15497
On Thu, Oct 8, 2015 at 6:13 PM, Madhawa Gunasekara <[email protected]> wrote: > Hi Anjana, > > Sure will do it. > > Thanks, > Madhawa > > On Thu, Oct 8, 2015 at 6:05 PM, Anjana Fernando <[email protected]> wrote: > >> 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 >> > > > > -- > *Madhawa Gunasekara* > Software Engineer > WSO2 Inc.; http://wso2.com > lean.enterprise.middleware > > mobile: +94 719411002 <+94+719411002> > blog: *http://madhawa-gunasekara.blogspot.com > <http://madhawa-gunasekara.blogspot.com>* > linkedin: *http://lk.linkedin.com/in/mgunasekara > <http://lk.linkedin.com/in/mgunasekara>* > -- Isuru Perera Associate Technical Lead | WSO2, Inc. | http://wso2.com/ Lean . Enterprise . Middleware about.me/chrishantha Contact: +IsuruPereraWSO2 <https://www.google.com/+IsuruPereraWSO2/about>
_______________________________________________ Dev mailing list [email protected] http://wso2.org/cgi-bin/mailman/listinfo/dev
