View Issue Details

IDProjectCategoryView StatusLast Update
0001939SymmetricDSTaskpublic2019-04-22 21:49
Reportervbn Assigned Toadmin  
Prioritynormal 
Status closedResolutionwon't fix 
Product Version3.5.22 
Summary0001939: SymmetricDS - dbimport is not working with Oracle database
DescriptionI 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 InformationBelow 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.
TagsNo tags attached.

Activities

admin

2019-04-22 21:49

administrator   ~0001416

Not going to fix anything here. If the tables are created, telling it to create the tables again results in an error that the tables already exist.

Issue History

Date Modified Username Field Change
2014-08-27 06:46 vbn New Issue
2019-04-22 21:49 admin Assigned To => admin
2019-04-22 21:49 admin Status new => closed
2019-04-22 21:49 admin Resolution open => won't fix
2019-04-22 21:49 admin Note Added: 0001416