View Issue Details
ID | Project | Category | View Status | Date Submitted | Last Update |
---|---|---|---|---|---|
0001939 | SymmetricDS | Task | public | 2014-08-27 06:46 | 2019-04-22 21:49 |
Reporter | vbn | Assigned To | admin | ||
Priority | normal | ||||
Status | closed | Resolution | won't fix | ||
Product Version | 3.5.22 | ||||
Summary | 0001939: SymmetricDS - dbimport is not working with Oracle database | ||||
Description | I am attempting to test the SymmetricDS tool for Oracle to PostgreSQL Replication. I am following the Quick start guide and tried importing the sample schema from create_sample.xml Below is the command - ./dbimport --engine eng --properties engOra.properties --format XML ../samples/create_sample.xml Error is : Log output will be written to ../logs/engOra.log [] - AbstractCommandLauncher - Option: name=engine, value={eng} [] - AbstractCommandLauncher - Option: name=properties, value={engOra.properties} [] - AbstractCommandLauncher - Option: name=format, value={XML} [] - DatabaseWriter - About to create table using the following definition: <table name="item1"> <column name="item1_id" primaryKey="true" required="true" type="INTEGER"/> <column name="name" type="VARCHAR" size="100"/> </table> [] - JdbcSqlTemplate - ORA-00955: name is already used by an existing object . Failed to execute: CREATE TABLE "item1" ( "item1_id" NUMBER(22) NOT NULL, "name" VARCHAR2(100), PRIMARY KEY ("item1_id") ) [] - DatabaseWriter - Failed to alter table using the following xml: <table name="item1"> <column name="item1_id" primaryKey="true" required="true" type="INTEGER"/> <column name="name" type="VARCHAR" size="100"/> </table> ------------------------------------------------------------------------------- An exception occurred. Please see the following for details: ------------------------------------------------------------------------------- java.sql.SQLSyntaxErrorException: ORA-00955: name is already used by an existing object at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:450) at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:399) at oracle.jdbc.driver.T4C8Oall.processError(T4C8Oall.java:1017) at oracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.java:655) at oracle.jdbc.driver.T4CTTIfun.doRPC(T4CTTIfun.java:249) Can anyone please help ! | ||||
Additional Information | Below are the parameter i configured. Rest all are default db.driver=oracle.jdbc.driver.OracleDriver db.url=jdbc:oracle:thin:@127.0.0.1:1521:orcl db.user=sys as sysdba db.password=oracle registration.url= sync.url=http://localhost:8080/sync/eng Please let me know if you need any additional information. | ||||
Tags | No tags attached. | ||||