incubator-olio-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Kim LiChong <Kim.Lich...@Sun.COM>
Subject Re: Problem loading data using ./dbloader
Date Thu, 12 Nov 2009 06:27:27 GMT
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
>
>
>       
>   


Mime
View raw message