Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- mbnoimi@test-pc /home/mbnoimi/symmetric/tutorial/sym-corp/symmetric-3.5.18/samples $ ../bin/dbimport --engine corp-000 --format XML create_sample.xmlLog output will be written to ../logs/symmetric.log
- [] - AbstractCommandLauncher - Option: name=engine, value={corp-000}
- [] - AbstractCommandLauncher - Option: name=format, value={XML}
- -------------------------------------------------------------------------------
- An exception occurred. Please see the following for details:
- -------------------------------------------------------------------------------
- java.lang.RuntimeException: Cannot find file create_sample.xml
- at org.jumpmind.symmetric.DbImportCommand.executeWithOptions(DbImportCommand.java:183)
- at org.jumpmind.symmetric.AbstractCommandLauncher.execute(AbstractCommandLauncher.java:130)
- at org.jumpmind.symmetric.DbImportCommand.main(DbImportCommand.java:72)
- -------------------------------------------------------------------------------
- mbnoimi@test-pc /home/mbnoimi/symmetric/tutorial/sym-corp/symmetric-3.5.18/samples $ ../bin/dbimport --engine corp-000 --format XML '/home/mbnoimi/symmetric/tutorial/sym-corp/symmetric-3.5.18/samples/create_sample.xml'
- Log output will be written to ../logs/symmetric.log
- [] - AbstractCommandLauncher - Option: name=engine, value={corp-000}
- [] - AbstractCommandLauncher - Option: name=format, value={XML}
- [] - DatabaseWriter - Did not find the item table in the target database
- [] - DatabaseWriter - About to create table using the following definition: <table name="item">
- <column name="item_id" primaryKey="true" required="true" type="INTEGER"/>
- <column name="name" type="VARCHAR" size="100"/>
- </table>
- [] - DatabaseWriter - Did not find the item_selling_price table in the target database
- [] - DatabaseWriter - About to create table using the following definition: <table name="item_selling_price">
- <column name="item_id" primaryKey="true" required="true" type="INTEGER"/>
- <column name="store_id" primaryKey="true" required="true" type="VARCHAR" size="5"/>
- <column name="price" required="true" type="DECIMAL" size="10,2"/>
- <column name="cost" type="DECIMAL" size="10,2"/>
- <foreign-key name="fk_price_item_id" foreignTable="item">
- <reference local="item_id" foreign="item_id"/>
- </foreign-key>
- </table>
- [] - JdbcSqlTemplate - [SQLITE_ERROR] SQL error or missing database (near "CONSTRAINT": syntax error). Failed to execute: ALTER TABLE "item_selling_price"
- ADD CONSTRAINT "fk_price_item_id" FOREIGN KEY ("item_id") REFERENCES "item" ("item_id")
- [] - DatabaseWriter - Failed to alter table using the following xml: <table name="item_selling_price">
- <column name="item_id" primaryKey="true" required="true" type="INTEGER"/>
- <column name="store_id" primaryKey="true" required="true" type="VARCHAR" size="5"/>
- <column name="price" required="true" type="DECIMAL" size="10,2"/>
- <column name="cost" type="DECIMAL" size="10,2"/>
- <foreign-key name="fk_price_item_id" foreignTable="item">
- <reference local="item_id" foreign="item_id"/>
- </foreign-key>
- </table>
- -------------------------------------------------------------------------------
- An exception occurred. Please see the following for details:
- -------------------------------------------------------------------------------
- java.sql.SQLException: [SQLITE_ERROR] SQL error or missing database (near "CONSTRAINT": syntax error)
- at org.sqlite.DB.newSQLException(DB.java:886)
- at org.sqlite.DB.newSQLException(DB.java:897)
- at org.sqlite.DB.throwex(DB.java:864)
- at org.sqlite.NativeDB.prepare(Native Method)
- at org.sqlite.DB.prepare(DB.java:207)
- at org.sqlite.Stmt.execute(Stmt.java:152)
- at org.apache.commons.dbcp.DelegatingStatement.execute(DelegatingStatement.java:264)
- at org.apache.commons.dbcp.DelegatingStatement.execute(DelegatingStatement.java:264)
- at org.jumpmind.db.sql.JdbcSqlTemplate$6.execute(JdbcSqlTemplate.java:343)
- at org.jumpmind.db.sql.JdbcSqlTemplate$6.execute(JdbcSqlTemplate.java:330)
- at org.jumpmind.db.sql.JdbcSqlTemplate.execute(JdbcSqlTemplate.java:415)
- [wrapped] org.jumpmind.db.sql.SqlException: [SQLITE_ERROR] SQL error or missing database (near "CONSTRAINT": syntax error)
- at org.jumpmind.db.sql.AbstractSqlTemplate.translate(AbstractSqlTemplate.java:288)
- at org.jumpmind.db.sql.AbstractSqlTemplate.translate(AbstractSqlTemplate.java:279)
- at org.jumpmind.db.sql.JdbcSqlTemplate.execute(JdbcSqlTemplate.java:417)
- at org.jumpmind.db.sql.JdbcSqlTemplate.update(JdbcSqlTemplate.java:330)
- at org.jumpmind.db.sql.SqlScript.execute(SqlScript.java:107)
- at org.jumpmind.db.sql.SqlScript.execute(SqlScript.java:102)
- at org.jumpmind.db.platform.AbstractDatabasePlatform.createDatabase(AbstractDatabasePlatform.java:169)
- at org.jumpmind.symmetric.io.data.writer.DatabaseWriter.create(DatabaseWriter.java:941)
- at org.jumpmind.symmetric.io.data.writer.DatabaseWriter.write(DatabaseWriter.java:202)
- at org.jumpmind.symmetric.io.data.writer.DatabaseWriter.write(DatabaseWriter.java:167)
- at org.jumpmind.symmetric.io.data.DataProcessor.forEachDataInTable(DataProcessor.java:194)
- at org.jumpmind.symmetric.io.data.DataProcessor.forEachTableInBatch(DataProcessor.java:164)
- at org.jumpmind.symmetric.io.data.DataProcessor.process(DataProcessor.java:114)
- at org.jumpmind.symmetric.io.data.DataProcessor.process(DataProcessor.java:78)
- at org.jumpmind.symmetric.io.data.DbImport.importTablesFromXml(DbImport.java:208)
- at org.jumpmind.symmetric.io.data.DbImport.importTables(DbImport.java:154)
- at org.jumpmind.symmetric.DbImportCommand.executeWithOptions(DbImportCommand.java:188)
- at org.jumpmind.symmetric.AbstractCommandLauncher.execute(AbstractCommandLauncher.java:130)
- at org.jumpmind.symmetric.DbImportCommand.main(DbImportCommand.java:72)
- -------------------------------------------------------------------------------
- mbnoimi@test-pc /home/mbnoimi/symmetric/tutorial/sym-corp/symmetric-3.5.18/samples $
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement