on the server there is an edfiTemp database, in the database there are several tables: edfi.Student, edfi.School and so on. Here edfi is the schema of all tables.
here is my properties file:
- Code: Select all
dbUrl=jdbc:jtds:sqlserver://localhost:1433;databaseName=edfiTemp
dbDriver=net.sourceforge.jtds.jdbc.Driver
dbCatalog=edfiTemp
dbSchema=edfi
Here is my descriptor file:
- Code: Select all
<?xml version="1.0" encoding="iso-8859-1"?>
<setup>
<import domains = "person" />
<import platforms = "db"/>
<comment>set default values</comment>
<setting name="database" default="sql_server" />
<comment>import database specific properties</comment>
<include uri="edfi.sql_server.properties" />
<comment>define the database that will be referred by the id 'db' subsequently</comment>
<database id="db" url="{dbUrl}" driver="{dbDriver}" catalog="{dbCatalog}" schema="{dbSchema}"
user="{dbUser}" password="{dbPassword}" />
<comment>Clear student-related records</comment>
<execute target="db" onError="warn">
DELETE FROM edfi.Student
</execute>
<comment>define StudentUSI generator</comment>
<bean id="StudentIdGen" spec="new IncrementGenerator(1000001)" />
<comment>create students</comment>
<generate type="Student" count="20" consumer="db">
<variable name="studentGen" generator="new PersonGenerator{minAgeYears='4', maxAgeYears='11'}" dataset="US" locale="en" />
<variable name="studentId" generator="studentIdGen" />
</generate>
</setup>
I am using benerator 0.7.1.
I see the following error when I execute benerator.
- Code: Select all
13:03:43,605 INFO (main) [CONFIG] Running file Student.xml
13:03:43,606 INFO (main) [CONFIG] Benerator 0.7.1 build 1820
13:03:43,606 INFO (main) [CONFIG] Java version 1.6.0_29
13:03:43,606 INFO (main) [CONFIG] JVM Java HotSpot(TM) 64-Bit Server VM 20.4-b02-402 (Apple Inc.)
13:03:43,606 INFO (main) [CONFIG] OS Mac OS X 10.7.3 (x86_64)
13:03:43,606 INFO (main) [CONFIG] Installed JSR 223 Script Engines:
13:03:43,611 INFO (main) [CONFIG] - AppleScriptEngine[AppleScriptEngine, AppleScript, OSA]
13:03:43,611 INFO (main) [CONFIG] - Mozilla Rhino[js, rhino, JavaScript, javascript, ECMAScript, ecmascript]
13:03:43,612 INFO (main) [CONFIG] Max heap size: 123 MB
13:03:43,668 DEBUG (main) [CONFIG] Initializing Script mapping from file org/databene/script/script.properties
13:03:43,823 DEBUG (main) [COMMENT] set default values
13:03:43,824 DEBUG (main) [COMMENT] import database specific properties
13:03:43,827 DEBUG (main) [COMMENT] define the database that will be referred by the id 'db' subsequently
13:03:43,836 DEBUG (main) [COMMENT] Clear student-related records
13:03:43,837 INFO (main) [EvaluateStatement] Executing inline script
13:03:43,942 INFO (main) [JDBC] Connected to Microsoft SQL Server 10.50.1617
13:03:43,942 INFO (main) [JDBC] Using driver jTDS Type 4 JDBC Driver for MS SQL Server and Sybase 1.2
13:03:43,942 INFO (main) [JDBC] JDBC version 3.0
13:03:43,977 DEBUG (main) [COMMENT] define StudentUSI generator
13:03:43,988 DEBUG (main) [COMMENT] create students
13:03:44,045 INFO (main) [JDBCDBImporter] Importing tables
..........
13:03:44,102 WARN (main) [JDBCDBImporter] ignoring table School
13:03:44,103 WARN (main) [JDBCDBImporter] ignoring table Student
.........
13:03:44,106 INFO (main) [JDBCDBImporter] Imported core database metadata within 69 ms.
13:03:44,106 INFO (main) [DBSystem] Fetching table details and ordering tables by dependency
13:03:44,328 INFO (main) [PagedTaskRunner] Running task GenerateAndConsumeTask(Student) 20 times with page size 1 in a single thread
13:03:44,408 ERROR (main) [GenerateOrIterateStatement] Error in execution of task Student
org.databene.commons.ObjectNotFoundException: Table Student
at org.databene.platform.db.DBSystem.getTable(DBSystem.java:815)
at org.databene.platform.db.DBSystem.getWriteColumnInfos(DBSystem.java:757)
at org.databene.platform.db.DBSystem.persistOrUpdate(DBSystem.java:854)
at org.databene.platform.db.DBSystem.store(DBSystem.java:355)
at org.databene.benerator.storage.StorageSystemInserter.startProductConsumption(StorageSystemInserter.java:52)
at org.databene.benerator.consumer.AbstractConsumer.startConsuming(AbstractConsumer.java:46)
at org.databene.benerator.consumer.ConsumerProxy.startConsuming(ConsumerProxy.java:50)
at org.databene.benerator.consumer.ConsumerChain.startConsuming(ConsumerChain.java:78)
at org.databene.benerator.engine.statement.ConsumptionStatement.execute(ConsumptionStatement.java:52)
at org.databene.benerator.engine.statement.GenerateAndConsumeTask.execute(GenerateAndConsumeTask.java:181)
at org.databene.task.TaskProxy.execute(TaskProxy.java:58)
at org.databene.task.StateTrackingTaskProxy.execute(StateTrackingTaskProxy.java:52)
at org.databene.task.runner.SingleThreadedTaskRunner.runWithoutPage(SingleThreadedTaskRunner.java:56)
at org.databene.task.runner.SingleThreadedTaskRunner.run(SingleThreadedTaskRunner.java:46)
at org.databene.task.runner.PagedTaskRunner.run(PagedTaskRunner.java:141)
at org.databene.task.runner.PagedTaskRunner.run(PagedTaskRunner.java:101)
at org.databene.task.runner.PagedTaskRunner.execute(PagedTaskRunner.java:169)
at org.databene.benerator.engine.statement.GenerateOrIterateStatement.execute(GenerateOrIterateStatement.java:92)
at org.databene.benerator.engine.statement.LazyStatement.execute(LazyStatement.java:58)
at org.databene.benerator.engine.statement.StatementProxy.execute(StatementProxy.java:45)
at org.databene.benerator.engine.statement.TimedGeneratorStatement.execute(TimedGeneratorStatement.java:66)
at org.databene.benerator.engine.statement.SequentialStatement.executeSubStatements(SequentialStatement.java:51)
at org.databene.benerator.engine.statement.SequentialStatement.execute(SequentialStatement.java:46)
at org.databene.benerator.engine.BeneratorRootStatement.execute(BeneratorRootStatement.java:62)
at org.databene.benerator.engine.DescriptorRunner.execute(DescriptorRunner.java:128)
at org.databene.benerator.engine.DescriptorRunner.runWithoutShutdownHook(DescriptorRunner.java:109)
at org.databene.benerator.engine.DescriptorRunner.run(DescriptorRunner.java:102)
at org.databene.benerator.main.Benerator.runFile(Benerator.java:88)
at org.databene.benerator.main.Benerator.runFromCommandLine(Benerator.java:76)
at org.databene.benerator.main.Benerator.main(Benerator.java:69)
13:03:44,409 ERROR (main) [GenerateOrIterateStatement] Error in execution of task GenerateAndConsumeTask
java.lang.RuntimeException: org.databene.commons.ObjectNotFoundException: Table Student
at org.databene.commons.ErrorHandler.handleError(ErrorHandler.java:91)
at org.databene.benerator.engine.statement.GenerateAndConsumeTask.execute(GenerateAndConsumeTask.java:198)
at org.databene.task.TaskProxy.execute(TaskProxy.java:58)
at org.databene.task.StateTrackingTaskProxy.execute(StateTrackingTaskProxy.java:52)
at org.databene.task.runner.SingleThreadedTaskRunner.runWithoutPage(SingleThreadedTaskRunner.java:56)
at org.databene.task.runner.SingleThreadedTaskRunner.run(SingleThreadedTaskRunner.java:46)
at org.databene.task.runner.PagedTaskRunner.run(PagedTaskRunner.java:141)
at org.databene.task.runner.PagedTaskRunner.run(PagedTaskRunner.java:101)
at org.databene.task.runner.PagedTaskRunner.execute(PagedTaskRunner.java:169)
at org.databene.benerator.engine.statement.GenerateOrIterateStatement.execute(GenerateOrIterateStatement.java:92)
at org.databene.benerator.engine.statement.LazyStatement.execute(LazyStatement.java:58)
at org.databene.benerator.engine.statement.StatementProxy.execute(StatementProxy.java:45)
at org.databene.benerator.engine.statement.TimedGeneratorStatement.execute(TimedGeneratorStatement.java:66)
at org.databene.benerator.engine.statement.SequentialStatement.executeSubStatements(SequentialStatement.java:51)
at org.databene.benerator.engine.statement.SequentialStatement.execute(SequentialStatement.java:46)
at org.databene.benerator.engine.BeneratorRootStatement.execute(BeneratorRootStatement.java:62)
at org.databene.benerator.engine.DescriptorRunner.execute(DescriptorRunner.java:128)
at org.databene.benerator.engine.DescriptorRunner.runWithoutShutdownHook(DescriptorRunner.java:109)
at org.databene.benerator.engine.DescriptorRunner.run(DescriptorRunner.java:102)
at org.databene.benerator.main.Benerator.runFile(Benerator.java:88)
at org.databene.benerator.main.Benerator.runFromCommandLine(Benerator.java:76)
at org.databene.benerator.main.Benerator.main(Benerator.java:69)
Caused by: org.databene.commons.ObjectNotFoundException: Table Student
at org.databene.platform.db.DBSystem.getTable(DBSystem.java:815)
at org.databene.platform.db.DBSystem.getWriteColumnInfos(DBSystem.java:757)
at org.databene.platform.db.DBSystem.persistOrUpdate(DBSystem.java:854)
at org.databene.platform.db.DBSystem.store(DBSystem.java:355)
at org.databene.benerator.storage.StorageSystemInserter.startProductConsumption(StorageSystemInserter.java:52)
at org.databene.benerator.consumer.AbstractConsumer.startConsuming(AbstractConsumer.java:46)
at org.databene.benerator.consumer.ConsumerProxy.startConsuming(ConsumerProxy.java:50)
at org.databene.benerator.consumer.ConsumerChain.startConsuming(ConsumerChain.java:78)
at org.databene.benerator.engine.statement.ConsumptionStatement.execute(ConsumptionStatement.java:52)
at org.databene.benerator.engine.statement.GenerateAndConsumeTask.execute(GenerateAndConsumeTask.java:181)
... 20 more
Exception in thread "main" java.lang.RuntimeException: java.lang.RuntimeException: org.databene.commons.ObjectNotFoundException: Table Student
at org.databene.commons.ErrorHandler.handleError(ErrorHandler.java:91)
at org.databene.task.runner.PagedTaskRunner.run(PagedTaskRunner.java:151)
at org.databene.task.runner.PagedTaskRunner.run(PagedTaskRunner.java:101)
at org.databene.task.runner.PagedTaskRunner.execute(PagedTaskRunner.java:169)
at org.databene.benerator.engine.statement.GenerateOrIterateStatement.execute(GenerateOrIterateStatement.java:92)
at org.databene.benerator.engine.statement.LazyStatement.execute(LazyStatement.java:58)
at org.databene.benerator.engine.statement.StatementProxy.execute(StatementProxy.java:45)
at org.databene.benerator.engine.statement.TimedGeneratorStatement.execute(TimedGeneratorStatement.java:66)
at org.databene.benerator.engine.statement.SequentialStatement.executeSubStatements(SequentialStatement.java:51)
at org.databene.benerator.engine.statement.SequentialStatement.execute(SequentialStatement.java:46)
at org.databene.benerator.engine.BeneratorRootStatement.execute(BeneratorRootStatement.java:62)
at org.databene.benerator.engine.DescriptorRunner.execute(DescriptorRunner.java:128)
at org.databene.benerator.engine.DescriptorRunner.runWithoutShutdownHook(DescriptorRunner.java:109)
at org.databene.benerator.engine.DescriptorRunner.run(DescriptorRunner.java:102)
at org.databene.benerator.main.Benerator.runFile(Benerator.java:88)
at org.databene.benerator.main.Benerator.runFromCommandLine(Benerator.java:76)
at org.databene.benerator.main.Benerator.main(Benerator.java:69)
Caused by: java.lang.RuntimeException: org.databene.commons.ObjectNotFoundException: Table Student
at org.databene.commons.ErrorHandler.handleError(ErrorHandler.java:91)
at org.databene.benerator.engine.statement.GenerateAndConsumeTask.execute(GenerateAndConsumeTask.java:198)
at org.databene.task.TaskProxy.execute(TaskProxy.java:58)
at org.databene.task.StateTrackingTaskProxy.execute(StateTrackingTaskProxy.java:52)
at org.databene.task.runner.SingleThreadedTaskRunner.runWithoutPage(SingleThreadedTaskRunner.java:56)
at org.databene.task.runner.SingleThreadedTaskRunner.run(SingleThreadedTaskRunner.java:46)
at org.databene.task.runner.PagedTaskRunner.run(PagedTaskRunner.java:141)
... 15 more
Caused by: org.databene.commons.ObjectNotFoundException: Table Student
at org.databene.platform.db.DBSystem.getTable(DBSystem.java:815)
at org.databene.platform.db.DBSystem.getWriteColumnInfos(DBSystem.java:757)
at org.databene.platform.db.DBSystem.persistOrUpdate(DBSystem.java:854)
at org.databene.platform.db.DBSystem.store(DBSystem.java:355)
at org.databene.benerator.storage.StorageSystemInserter.startProductConsumption(StorageSystemInserter.java:52)
at org.databene.benerator.consumer.AbstractConsumer.startConsuming(AbstractConsumer.java:46)
at org.databene.benerator.consumer.ConsumerProxy.startConsuming(ConsumerProxy.java:50)
at org.databene.benerator.consumer.ConsumerChain.startConsuming(ConsumerChain.java:78)
at org.databene.benerator.engine.statement.ConsumptionStatement.execute(ConsumptionStatement.java:52)
at org.databene.benerator.engine.statement.GenerateAndConsumeTask.execute(GenerateAndConsumeTask.java:181)
... 20 more
It works when the all tables are under schema "dbo". However, if the table under schema "edfi", benerator could not find them.
Is anything I did wrong here? Thanks for your input.
