Hi Harold,
Can you refresh your workspace? There has been some changes to the
schema. You will have to drop and recreate your database with the new
schema, and then rerun dbloader.
I just tried this on my updated workspace (I had to drop and recreate as
well since I was using an older schema) and it went through.
kim
$ ./dbloader.sh localhost 25
Nov 11, 2009 10:18:29 PM org.apache.olio.workload.loader.LoadController main
INFO: Done clearing database tables.
Nov 11, 2009 10:18:33 PM org.apache.olio.workload.loader.LoadController main
INFO: Done data creation.
Nov 11, 2009 10:19:53 PM org.apache.olio.workload.loader.LoadController main
INFO: Done data loading.
Nov 11, 2009 10:19:53 PM org.apache.olio.workload.loader.LoadController main
INFO: Done post-load.
Database Load Successful
Hi All,
When I try to run dbloader, I'm getting the following error:
java.sql.BatchUpdateException: Field 'ADDRESSID' doesn't have a default value
at
com.mysql.jdbc.PreparedStatement.executeBatchSerially(PreparedStatement.java:2007)
at
com.mysql.jdbc.PreparedStatement.executeBatch(PreparedStatement.java:1443)
at
org.apache.olio.workload.loader.framework.ThreadConnection.flush(ThreadConnection.java:235)
at
org.apache.olio.workload.loader.framework.ThreadConnection.processBatch(ThreadConnection.java:180)
at
org.apache.olio.workload.loader.framework.Loader$4.run(Loader.java:276)
at
java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:441)
at java.util.concurrent.FutureTask$Sync.innerRun(FutureTask.java:303)
at java.util.concurrent.FutureTask.run(FutureTask.java:138)
at
java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoolExecutor.java:886)
at
java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:908)
at java.lang.Thread.run(Thread.java:619)
Any idea how to fix this problem?
Thanks,
Harold
