How to achieve that the zones source is built from Oracle?

jackie.wong Member since: 2015-07-02 11:59	Added: 2015-07-10 09:58
	My company set up to use Oracle Database to set up zones and records. I cannot finish it successfully only changing the source of database. How to achieve that? Is it need to modify the source code?
Unlogic Member since: 2008-01-27 20:43	Added: 2015-07-10 14:29
	You don't need to change the source code in order to store zones in an Oracle database. You only need to change the DB script used to create the tables. If you proceed in making an Oracle version of the DB script please consider contributing it to the community.
jackie.wong Member since: 2015-07-02 11:59	Added: 2015-07-24 09:05
	I am now testing using 'zonefile2db.sh' shell script to run the data in the Oracle Database. In Oracle Database, I set up the field 'DOWNLOADED' TIMESTAMP(6). And I face the exception below when running the script above: Exception in thread "main" java.sql.SQLSyntaxErrorException: ORA-00932: inconsistent datatypes: expected TIMESTAMP got NUMBER at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:445) at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:396) at oracle.jdbc.driver.T4C8Oall.processError(T4C8Oall.java:879) at oracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.java:450) at oracle.jdbc.driver.T4CTTIfun.doRPC(T4CTTIfun.java:192) at oracle.jdbc.driver.T4C8Oall.doOALL(T4C8Oall.java:531) at oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4CPreparedStatement.java:207) at oracle.jdbc.driver.T4CPreparedStatement.executeForRows(T4CPreparedStatement.java:1044) at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1329) at oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:3593) at oracle.jdbc.driver.OraclePreparedStatement.executeUpdate(OraclePreparedStatement.java:3674) at oracle.jdbc.driver.OraclePreparedStatementWrapper.executeUpdate(OraclePreparedStatementWrapper.java:1354) at se.unlogic.standardutils.dao.querys.UpdateQuery.executeUpdate(UpdateQuery.java:60) at se.unlogic.standardutils.dao.querys.UpdateQuery.executeUpdate(UpdateQuery.java:90) at se.unlogic.standardutils.dao.AnnotatedDAO.executeUpdateQuery(AnnotatedDAO.java:1040) at se.unlogic.standardutils.dao.AnnotatedDAO.add(AnnotatedDAO.java:1025) at se.unlogic.standardutils.dao.AnnotatedDAO.add(AnnotatedDAO.java:992) at se.unlogic.eagledns.utils.PrimaryZones2DB.importZones(PrimaryZones2DB.java:73) at se.unlogic.eagledns.utils.PrimaryZones2DB.main(PrimaryZones2DB.java:36) Can anyone know about this exception??
jackie.wong Member since: 2015-07-02 11:59	Added: 2015-07-24 09:05
	I am now testing using 'zonefile2db.sh' shell script to run the data in the Oracle Database. In Oracle Database, I set up the field 'DOWNLOADED' TIMESTAMP(6). And I face the exception below when running the script above: Exception in thread "main" java.sql.SQLSyntaxErrorException: ORA-00932: inconsistent datatypes: expected TIMESTAMP got NUMBER at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:445) at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:396) at oracle.jdbc.driver.T4C8Oall.processError(T4C8Oall.java:879) at oracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.java:450) at oracle.jdbc.driver.T4CTTIfun.doRPC(T4CTTIfun.java:192) at oracle.jdbc.driver.T4C8Oall.doOALL(T4C8Oall.java:531) at oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4CPreparedStatement.java:207) at oracle.jdbc.driver.T4CPreparedStatement.executeForRows(T4CPreparedStatement.java:1044) at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1329) at oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:3593) at oracle.jdbc.driver.OraclePreparedStatement.executeUpdate(OraclePreparedStatement.java:3674) at oracle.jdbc.driver.OraclePreparedStatementWrapper.executeUpdate(OraclePreparedStatementWrapper.java:1354) at se.unlogic.standardutils.dao.querys.UpdateQuery.executeUpdate(UpdateQuery.java:60) at se.unlogic.standardutils.dao.querys.UpdateQuery.executeUpdate(UpdateQuery.java:90) at se.unlogic.standardutils.dao.AnnotatedDAO.executeUpdateQuery(AnnotatedDAO.java:1040) at se.unlogic.standardutils.dao.AnnotatedDAO.add(AnnotatedDAO.java:1025) at se.unlogic.standardutils.dao.AnnotatedDAO.add(AnnotatedDAO.java:992) at se.unlogic.eagledns.utils.PrimaryZones2DB.importZones(PrimaryZones2DB.java:73) at se.unlogic.eagledns.utils.PrimaryZones2DB.main(PrimaryZones2DB.java:36) Can anyone know about this exception??

In order to post replies you need to be logged in, click here to create an account