Jesper,
Have you tried running the tests that come with the adapter_extensions plugin?
Those were the same tests that I was running, so maybe that might help us
identify the difference that is causing the problem.
Let me know if you need help running the tests.
Paul
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Jesper
Rønn-Jensen
Sent: Wednesday, February 20, 2008 3:27 AM
To: activewarehouse-discuss@rubyforge.org
Subject: Re: [Activewarehouse-discuss] Fwd: problems using bulk_import (to
mysql on win xp)
Hi Paul
Thanks for putting effort into this strange weird behaviour.
The change you suggest, however, makes no difference for me. I still get the
same error. I'm including stack trace below signature.
/Jesper
On Feb 20, 2008 8:51 AM, Paul Cortens wrote:
I think I have made some progress. I added one line to mysql_adapter.rb in the
adapter extensions plugin:
+@connection = Mysql.new([EMAIL PROTECTED])
--
___
Jesper Rønn-Jensen / Capgemini Denmark
Tel. +45 3977 8220 / Mob. +45 2373 6220 / Fax +45 7011 2201
www.dk.capgemini.com / Blog http://justaddwater.dk/
___
Executing screens
Screens passed
Executing post processes
c:/ruby/lib/ruby/gems/1.8/gems/activerecord-2.0.2/lib/active_record/connection_adapters/abstract_adapter.rb:150:in
`log': Mysql::Error: #42000The used command is not allowed with this MySQL
version: LOAD DATA LOCAL INFILE 'C:/Documents and Settings/Administrator/My
Documents/rails/ourpeople/import/output/employees.out.txt' INTO TABLE employees
FIELDS TERMINATED BY ',' ENCLOSED BY '' IGNORE 1 LINES
(id,cgid,longid,firstname,lastname,displayname,middleinitial,initials,phone,mobile,fax,subcellphone,email,englishtitle,localtitle,secretary_id,mentor_id,substitute_id,manager_id,comment,licenseplate,employment_cgemployee,employment_cgexternal,employment_cgtemporary,employeework_employeeid,employeework_workpercentage,employeework_actualworkpercentage,company_id,grade_id,location_id,organisation_id,profession_id,resourcetype_id,skillsunit_id,staffingunit_id)
(ActiveRecord::StatementInvalid)
from
c:/ruby/lib/ruby/gems/1.8/gems/activerecord-2.0.2/lib/active_record/connection_adapters/mysql_adapter.rb:281:in
`execute'
from
c:/ruby/lib/ruby/gems/1.8/gems/adapter_extensions-0.4.0/lib/adapter_extensions/connection_adapters/mysql_adapter.rb:49:in
`do_bulk_load'
from
c:/ruby/lib/ruby/gems/1.8/gems/adapter_extensions-0.4.0/lib/adapter_extensions/connection_adapters/abstract_adapter.rb:18:in
`bulk_load'
from
c:/ruby/lib/ruby/gems/1.8/gems/activewarehouse-etl-0.9.0/bin/../lib/etl/processor/bulk_import_processor.rb:73:in
`process'
from
c:/ruby/lib/ruby/gems/1.8/gems/activerecord-2.0.2/lib/active_record/connection_adapters/abstract/database_statements.rb:66:in
`transaction'
from
c:/ruby/lib/ruby/gems/1.8/gems/activewarehouse-etl-0.9.0/bin/../lib/etl/processor/bulk_import_processor.rb:62:in
`process'
from
c:/ruby/lib/ruby/gems/1.8/gems/activewarehouse-etl-0.9.0/bin/../lib/etl/engine.rb:485:in
`post_process'
from
c:/ruby/lib/ruby/gems/1.8/gems/activewarehouse-etl-0.9.0/bin/../lib/etl/engine.rb:484:in
`each'
... 13 levels...
from
c:/ruby/lib/ruby/gems/1.8/gems/activesupport-2.0.2/lib/active_support/dependencies.rb:496:in
`require'
from c:/ruby/lib/ruby/gems/1.8/gems/activewarehouse-etl-0.9.0/bin/etl:28
from c:/ruby/bin/etl:19:in `load'
from c:/ruby/bin/etl:19
___
Activewarehouse-discuss mailing list
Activewarehouse-discuss@rubyforge.org
http://rubyforge.org/mailman/listinfo/activewarehouse-discuss
