All, http://ironruby.net/Documentation/Rails has been updated to show instructions for running Rails 2.3.5 on IronRuby, including using the official activerecord-sqlserver-adapter (v2.3). Thanks to Ivan for his work on ironruby-dbi! The steps are extrememly simple now. Assuming you have IronRuby installed and a Rails app you''d like to run on IronRuby: 1. Install Rake, Rails, and IronRuby SQLServer igem install rake rails ironruby-sqlserver 2. Add the following to the top of your app''s config/environment.rb: require ''rubygems'' require ''ironruby_sqlserver'' 3. Connect to SQLServer in config/database.yml: development: mode: ADONET adapter: sqlserver host: YOURMACHINENAME\SQLEXPRESS database: app123_development integrated_security: true 4. Migrate the database and start the server: irake db:migrate ir script\server And that''s it! The documentation link above also has a walk through setting up IronRuby, Rails, and SQLServer, and shows a basic Rails "scaffold" running. Coming soon are updated instructions for running rack-based web applications in IIS on IronRuby. Let me know if you have any questions, ~Jimmy
That''s terrific, Jimmy! Thanks! Jim mentioned that the ''i'' prefix might be going away soon, but I noticed that you are still using the ''i''-prefixed versions of commands. What''s the timeline? Cheers! Ryan Riley Email: ryan.riley at panesofglass.org LinkedIn: http://www.linkedin.com/in/ryanriley Blog: http://wizardsofsmart.net/ Twitter: @panesofglass Website: http://panesofglass.org/ On Thu, Jan 14, 2010 at 6:48 PM, Jimmy Schementi < Jimmy.Schementi at microsoft.com> wrote:> All, > > http://ironruby.net/Documentation/Rails has been updated to show > instructions for running Rails 2.3.5 on IronRuby, including using the > official activerecord-sqlserver-adapter (v2.3). Thanks to Ivan for his work > on ironruby-dbi! > > The steps are extrememly simple now. Assuming you have IronRuby installed > and a Rails app you''d like to run on IronRuby: > > 1. Install Rake, Rails, and IronRuby SQLServer > > igem install rake rails ironruby-sqlserver > > 2. Add the following to the top of your app''s config/environment.rb: > > require ''rubygems'' > require ''ironruby_sqlserver'' > > 3. Connect to SQLServer in config/database.yml: > > development: > mode: ADONET > adapter: sqlserver > host: YOURMACHINENAME\SQLEXPRESS > database: app123_development > integrated_security: true > > 4. Migrate the database and start the server: > > irake db:migrate > ir script\server > > And that''s it! The documentation link above also has a walk through setting > up IronRuby, Rails, and SQLServer, and shows a basic Rails "scaffold" > running. > > Coming soon are updated instructions for running rack-based web > applications in IIS on IronRuby. > > Let me know if you have any questions, > ~Jimmy > _______________________________________________ > Ironruby-core mailing list > Ironruby-core at rubyforge.org > http://rubyforge.org/mailman/listinfo/ironruby-core >-------------- next part -------------- An HTML attachment was scrubbed... URL: <http://rubyforge.org/pipermail/ironruby-core/attachments/20100115/f962ff4a/attachment.html>
I just noticed the instructions are using ironruby-sqlserver though you note in your email that you are supporting activerecord-sqlserver-adapter. Is ironruby-sqlserver a wrapper, or would you just need to swap your adapter? I''m also running into other problems: 1) I verified that I have the correct access (unless rails needs access?), but irake db:migrate produces the following error: [image: ?ui=2&view=att&th=1264a0aeac40d8b9&attid=0.1&disp=attd&realattid=ii_1264a0aeac40d8b9&zw] [image: ?ui=2&view=att&th=1264a0b50426065a&attid=0.1&disp=attd&realattid=ii_1264a0b50426065a&zw] 2) Trying to open the environment settings from the default page for the Rails app produces this message: [image: ?ui=2&view=att&th=1264a0a693b3123b&attid=0.1&disp=attd&realattid=ii_1264a0a693b3123b&zw] Any help is appreciated. I''m stumped. And if anyone knows how to copy text from Console2, I would appreciate the tip. Thanks! Ryan Riley Email: ryan.riley at panesofglass.org LinkedIn: http://www.linkedin.com/in/ryanriley Blog: http://wizardsofsmart.net/ Twitter: @panesofglass Website: http://panesofglass.org/ On Thu, Jan 14, 2010 at 6:48 PM, Jimmy Schementi < Jimmy.Schementi at microsoft.com> wrote:> All, > > http://ironruby.net/Documentation/Rails has been updated to show > instructions for running Rails 2.3.5 on IronRuby, including using the > official activerecord-sqlserver-adapter (v2.3). Thanks to Ivan for his work > on ironruby-dbi! > > The steps are extrememly simple now. Assuming you have IronRuby installed > and a Rails app you''d like to run on IronRuby: > > 1. Install Rake, Rails, and IronRuby SQLServer > > igem install rake rails ironruby-sqlserver > > 2. Add the following to the top of your app''s config/environment.rb: > > require ''rubygems'' > require ''ironruby_sqlserver'' > > 3. Connect to SQLServer in config/database.yml: > > development: > mode: ADONET > adapter: sqlserver > host: YOURMACHINENAME\SQLEXPRESS > database: app123_development > integrated_security: true > > 4. Migrate the database and start the server: > > irake db:migrate > ir script\server > > And that''s it! The documentation link above also has a walk through setting > up IronRuby, Rails, and SQLServer, and shows a basic Rails "scaffold" > running. > > Coming soon are updated instructions for running rack-based web > applications in IIS on IronRuby. > > Let me know if you have any questions, > ~Jimmy > _______________________________________________ > Ironruby-core mailing list > Ironruby-core at rubyforge.org > http://rubyforge.org/mailman/listinfo/ironruby-core >-------------- next part -------------- An HTML attachment was scrubbed... URL: <http://rubyforge.org/pipermail/ironruby-core/attachments/20100119/e0ccc9a7/attachment-0001.html> -------------- next part -------------- A non-text attachment was scrubbed... Name: not available Type: image/png Size: 621885 bytes Desc: not available URL: <http://rubyforge.org/pipermail/ironruby-core/attachments/20100119/e0ccc9a7/attachment-0003.png> -------------- next part -------------- A non-text attachment was scrubbed... Name: not available Type: image/png Size: 36385 bytes Desc: not available URL: <http://rubyforge.org/pipermail/ironruby-core/attachments/20100119/e0ccc9a7/attachment-0004.png> -------------- next part -------------- A non-text attachment was scrubbed... Name: not available Type: image/png Size: 400297 bytes Desc: not available URL: <http://rubyforge.org/pipermail/ironruby-core/attachments/20100119/e0ccc9a7/attachment-0005.png>
I should add that, on item 2, though the default page says something went wrong, the console reports nothing at all, not even a request. Ryan Riley Email: ryan.riley at panesofglass.org LinkedIn: http://www.linkedin.com/in/ryanriley Blog: http://wizardsofsmart.net/ Twitter: @panesofglass Website: http://panesofglass.org/ On Tue, Jan 19, 2010 at 10:45 PM, Ryan Riley <ryan.riley at panesofglass.org>wrote:> I just noticed the instructions are using ironruby-sqlserver though you > note in your email that you are supporting activerecord-sqlserver-adapter. > Is ironruby-sqlserver a wrapper, or would you just need to swap your > adapter? > > I''m also running into other problems: > 1) I verified that I have the correct access (unless rails needs access?), > but irake db:migrate produces the following error: > [image: > ?ui=2&view=att&th=1264a0aeac40d8b9&attid=0.1&disp=attd&realattid=ii_1264a0aeac40d8b9&zw] > [image: > ?ui=2&view=att&th=1264a0b50426065a&attid=0.1&disp=attd&realattid=ii_1264a0b50426065a&zw] > 2) Trying to open the environment settings from the default page for the > Rails app produces this message: > [image: > ?ui=2&view=att&th=1264a0a693b3123b&attid=0.1&disp=attd&realattid=ii_1264a0a693b3123b&zw] > > Any help is appreciated. I''m stumped. And if anyone knows how to copy text > from Console2, I would appreciate the tip. > > Thanks! > > Ryan Riley > > Email: ryan.riley at panesofglass.org > LinkedIn: http://www.linkedin.com/in/ryanriley > Blog: http://wizardsofsmart.net/ > Twitter: @panesofglass > Website: http://panesofglass.org/ > > > On Thu, Jan 14, 2010 at 6:48 PM, Jimmy Schementi < > Jimmy.Schementi at microsoft.com> wrote: > >> All, >> >> http://ironruby.net/Documentation/Rails has been updated to show >> instructions for running Rails 2.3.5 on IronRuby, including using the >> official activerecord-sqlserver-adapter (v2.3). Thanks to Ivan for his work >> on ironruby-dbi! >> >> The steps are extrememly simple now. Assuming you have IronRuby installed >> and a Rails app you''d like to run on IronRuby: >> >> 1. Install Rake, Rails, and IronRuby SQLServer >> >> igem install rake rails ironruby-sqlserver >> >> 2. Add the following to the top of your app''s config/environment.rb: >> >> require ''rubygems'' >> require ''ironruby_sqlserver'' >> >> 3. Connect to SQLServer in config/database.yml: >> >> development: >> mode: ADONET >> adapter: sqlserver >> host: YOURMACHINENAME\SQLEXPRESS >> database: app123_development >> integrated_security: true >> >> 4. Migrate the database and start the server: >> >> irake db:migrate >> ir script\server >> >> And that''s it! The documentation link above also has a walk through >> setting up IronRuby, Rails, and SQLServer, and shows a basic Rails >> "scaffold" running. >> >> Coming soon are updated instructions for running rack-based web >> applications in IIS on IronRuby. >> >> Let me know if you have any questions, >> ~Jimmy >> _______________________________________________ >> Ironruby-core mailing list >> Ironruby-core at rubyforge.org >> http://rubyforge.org/mailman/listinfo/ironruby-core >> > >-------------- next part -------------- An HTML attachment was scrubbed... URL: <http://rubyforge.org/pipermail/ironruby-core/attachments/20100119/abd41cf6/attachment-0001.html> -------------- next part -------------- A non-text attachment was scrubbed... Name: not available Type: image/png Size: 36385 bytes Desc: not available URL: <http://rubyforge.org/pipermail/ironruby-core/attachments/20100119/abd41cf6/attachment-0003.png> -------------- next part -------------- A non-text attachment was scrubbed... Name: not available Type: image/png Size: 400297 bytes Desc: not available URL: <http://rubyforge.org/pipermail/ironruby-core/attachments/20100119/abd41cf6/attachment-0004.png> -------------- next part -------------- A non-text attachment was scrubbed... Name: not available Type: image/png Size: 621885 bytes Desc: not available URL: <http://rubyforge.org/pipermail/ironruby-core/attachments/20100119/abd41cf6/attachment-0005.png>
copying text from console 2. Copy is broken AFAICT. Where do we submit a request to microsoft to finally include a console that allows you to copy paste with a keyboard shortcut from a console window, tabs would be nice too. I''ve wanted to get that for 15 years now. right click the console window and select view > console window That gives you the cmd window and you can use mark,.... Then to your rails problem. Does your database exist? For item 2. Does anything show up in log/develpment.log? --- Met vriendelijke groeten - Best regards - Salutations Ivan Porto Carrero Blog: http://flanders.co.nz Twitter: http://twitter.com/casualjim Author of IronRuby in Action (http://manning.com/carrero) On Wed, Jan 20, 2010 at 5:45 AM, Ryan Riley <ryan.riley at panesofglass.org>wrote:> I just noticed the instructions are using ironruby-sqlserver though you > note in your email that you are supporting activerecord-sqlserver-adapter. > Is ironruby-sqlserver a wrapper, or would you just need to swap your > adapter? > > I''m also running into other problems: > 1) I verified that I have the correct access (unless rails needs access?), > but irake db:migrate produces the following error: > [image: > ?ui=2&view=att&th=1264a0aeac40d8b9&attid=0.1&disp=attd&realattid=ii_1264a0aeac40d8b9&zw] > [image: > ?ui=2&view=att&th=1264a0b50426065a&attid=0.1&disp=attd&realattid=ii_1264a0b50426065a&zw] > 2) Trying to open the environment settings from the default page for the > Rails app produces this message: > [image: > ?ui=2&view=att&th=1264a0a693b3123b&attid=0.1&disp=attd&realattid=ii_1264a0a693b3123b&zw] > > Any help is appreciated. I''m stumped. And if anyone knows how to copy text > from Console2, I would appreciate the tip. > > Thanks! > > Ryan Riley > > Email: ryan.riley at panesofglass.org > LinkedIn: http://www.linkedin.com/in/ryanriley > Blog: http://wizardsofsmart.net/ > Twitter: @panesofglass > Website: http://panesofglass.org/ > > > On Thu, Jan 14, 2010 at 6:48 PM, Jimmy Schementi < > Jimmy.Schementi at microsoft.com> wrote: > >> All, >> >> http://ironruby.net/Documentation/Rails has been updated to show >> instructions for running Rails 2.3.5 on IronRuby, including using the >> official activerecord-sqlserver-adapter (v2.3). Thanks to Ivan for his work >> on ironruby-dbi! >> >> The steps are extrememly simple now. Assuming you have IronRuby installed >> and a Rails app you''d like to run on IronRuby: >> >> 1. Install Rake, Rails, and IronRuby SQLServer >> >> igem install rake rails ironruby-sqlserver >> >> 2. Add the following to the top of your app''s config/environment.rb: >> >> require ''rubygems'' >> require ''ironruby_sqlserver'' >> >> 3. Connect to SQLServer in config/database.yml: >> >> development: >> mode: ADONET >> adapter: sqlserver >> host: YOURMACHINENAME\SQLEXPRESS >> database: app123_development >> integrated_security: true >> >> 4. Migrate the database and start the server: >> >> irake db:migrate >> ir script\server >> >> And that''s it! The documentation link above also has a walk through >> setting up IronRuby, Rails, and SQLServer, and shows a basic Rails >> "scaffold" running. >> >> Coming soon are updated instructions for running rack-based web >> applications in IIS on IronRuby. >> >> Let me know if you have any questions, >> ~Jimmy >> _______________________________________________ >> Ironruby-core mailing list >> Ironruby-core at rubyforge.org >> http://rubyforge.org/mailman/listinfo/ironruby-core >> > > > _______________________________________________ > Ironruby-core mailing list > Ironruby-core at rubyforge.org > http://rubyforge.org/mailman/listinfo/ironruby-core > >-------------- next part -------------- An HTML attachment was scrubbed... URL: <http://rubyforge.org/pipermail/ironruby-core/attachments/20100120/0264da2a/attachment.html>
I believe console 2 defaults to shift + click and drag to select, and auto-copy on release. I do agree with the request for a better console in windows, though. ________________________________ From: Ivan Porto Carrero <ivan at flanders.co.nz> Sent: Wednesday, January 20, 2010 7:29 AM To: ironruby-core at rubyforge.org <ironruby-core at rubyforge.org> Subject: Re: [Ironruby-core] Updated Rails instructions copying text from console 2. Copy is broken AFAICT. Where do we submit a request to microsoft to finally include a console that allows you to copy paste with a keyboard shortcut from a console window, tabs would be nice too. I''ve wanted to get that for 15 years now. right click the console window and select view > console window That gives you the cmd window and you can use mark,.... Then to your rails problem. Does your database exist? For item 2. Does anything show up in log/develpment.log? --- Met vriendelijke groeten - Best regards - Salutations Ivan Porto Carrero Blog: http://flanders.co.nz Twitter: http://twitter.com/casualjim Author of IronRuby in Action (http://manning.com/carrero) On Wed, Jan 20, 2010 at 5:45 AM, Ryan Riley <ryan.riley at panesofglass.org<mailto:ryan.riley at panesofglass.org>> wrote: I just noticed the instructions are using ironruby-sqlserver though you note in your email that you are supporting activerecord-sqlserver-adapter. Is ironruby-sqlserver a wrapper, or would you just need to swap your adapter? I''m also running into other problems: 1) I verified that I have the correct access (unless rails needs access?), but irake db:migrate produces the following error: [?ui=2&view=att&th=1264a0aeac40d8b9&attid=0.1&disp=attd&realattid=ii_1264a0aeac40d8b9&zw] [?ui=2&view=att&th=1264a0b50426065a&attid=0.1&disp=attd&realattid=ii_1264a0b50426065a&zw] 2) Trying to open the environment settings from the default page for the Rails app produces this message: [?ui=2&view=att&th=1264a0a693b3123b&attid=0.1&disp=attd&realattid=ii_1264a0a693b3123b&zw] Any help is appreciated. I''m stumped. And if anyone knows how to copy text from Console2, I would appreciate the tip. Thanks! Ryan Riley Email: ryan.riley at panesofglass.org<mailto:ryan.riley at panesofglass.org> LinkedIn: http://www.linkedin.com/in/ryanriley Blog: http://wizardsofsmart.net/ Twitter: @panesofglass Website: http://panesofglass.org/ On Thu, Jan 14, 2010 at 6:48 PM, Jimmy Schementi <Jimmy.Schementi at microsoft.com<mailto:Jimmy.Schementi at microsoft.com>> wrote: All, http://ironruby.net/Documentation/Rails has been updated to show instructions for running Rails 2.3.5 on IronRuby, including using the official activerecord-sqlserver-adapter (v2.3). Thanks to Ivan for his work on ironruby-dbi! The steps are extrememly simple now. Assuming you have IronRuby installed and a Rails app you''d like to run on IronRuby: 1. Install Rake, Rails, and IronRuby SQLServer igem install rake rails ironruby-sqlserver 2. Add the following to the top of your app''s config/environment.rb: require ''rubygems'' require ''ironruby_sqlserver'' 3. Connect to SQLServer in config/database.yml: development: mode: ADONET adapter: sqlserver host: YOURMACHINENAME\SQLEXPRESS database: app123_development integrated_security: true 4. Migrate the database and start the server: irake db:migrate ir script\server And that''s it! The documentation link above also has a walk through setting up IronRuby, Rails, and SQLServer, and shows a basic Rails "scaffold" running. Coming soon are updated instructions for running rack-based web applications in IIS on IronRuby. Let me know if you have any questions, ~Jimmy _______________________________________________ Ironruby-core mailing list Ironruby-core at rubyforge.org<mailto:Ironruby-core at rubyforge.org> http://rubyforge.org/mailman/listinfo/ironruby-core _______________________________________________ Ironruby-core mailing list Ironruby-core at rubyforge.org<mailto:Ironruby-core at rubyforge.org> http://rubyforge.org/mailman/listinfo/ironruby-core -------------- next part -------------- An HTML attachment was scrubbed... URL: <http://rubyforge.org/pipermail/ironruby-core/attachments/20100120/db1eaab0/attachment.html>
Console2 is the first thing I install on a new machine. Yeah, a updated console in windows would be nice, but it''s not something I see changing in the future, so I''m fine using something that is good. ~Jimmy From: ironruby-core-bounces at rubyforge.org [mailto:ironruby-core-bounces at rubyforge.org] On Behalf Of Jim Deville Sent: Wednesday, January 20, 2010 12:47 AM To: ironruby-core at rubyforge.org Subject: Re: [Ironruby-core] Updated Rails instructions I believe console 2 defaults to shift + click and drag to select, and auto-copy on release. I do agree with the request for a better console in windows, though. ________________________________ From: Ivan Porto Carrero <ivan at flanders.co.nz> Sent: Wednesday, January 20, 2010 7:29 AM To: ironruby-core at rubyforge.org <ironruby-core at rubyforge.org> Subject: Re: [Ironruby-core] Updated Rails instructions copying text from console 2. Copy is broken AFAICT. Where do we submit a request to microsoft to finally include a console that allows you to copy paste with a keyboard shortcut from a console window, tabs would be nice too. I''ve wanted to get that for 15 years now. right click the console window and select view > console window That gives you the cmd window and you can use mark,.... Then to your rails problem. Does your database exist? For item 2. Does anything show up in log/develpment.log? --- Met vriendelijke groeten - Best regards - Salutations Ivan Porto Carrero Blog: http://flanders.co.nz Twitter: http://twitter.com/casualjim Author of IronRuby in Action (http://manning.com/carrero) On Wed, Jan 20, 2010 at 5:45 AM, Ryan Riley <ryan.riley at panesofglass.org<mailto:ryan.riley at panesofglass.org>> wrote: I just noticed the instructions are using ironruby-sqlserver though you note in your email that you are supporting activerecord-sqlserver-adapter. Is ironruby-sqlserver a wrapper, or would you just need to swap your adapter? I''m also running into other problems: 1) I verified that I have the correct access (unless rails needs access?), but irake db:migrate produces the following error: [?ui=2&view=att&th=1264a0aeac40d8b9&attid=0.1&disp=attd&realattid=ii_1264a0aeac40d8b9&zw] [?ui=2&view=att&th=1264a0b50426065a&attid=0.1&disp=attd&realattid=ii_1264a0b50426065a&zw] 2) Trying to open the environment settings from the default page for the Rails app produces this message: [?ui=2&view=att&th=1264a0a693b3123b&attid=0.1&disp=attd&realattid=ii_1264a0a693b3123b&zw] Any help is appreciated. I''m stumped. And if anyone knows how to copy text from Console2, I would appreciate the tip. Thanks! Ryan Riley Email: ryan.riley at panesofglass.org<mailto:ryan.riley at panesofglass.org> LinkedIn: http://www.linkedin.com/in/ryanriley Blog: http://wizardsofsmart.net/ Twitter: @panesofglass Website: http://panesofglass.org/ On Thu, Jan 14, 2010 at 6:48 PM, Jimmy Schementi <Jimmy.Schementi at microsoft.com<mailto:Jimmy.Schementi at microsoft.com>> wrote: All, http://ironruby.net/Documentation/Rails has been updated to show instructions for running Rails 2.3.5 on IronRuby, including using the official activerecord-sqlserver-adapter (v2.3). Thanks to Ivan for his work on ironruby-dbi! The steps are extrememly simple now. Assuming you have IronRuby installed and a Rails app you''d like to run on IronRuby: 1. Install Rake, Rails, and IronRuby SQLServer igem install rake rails ironruby-sqlserver 2. Add the following to the top of your app''s config/environment.rb: require ''rubygems'' require ''ironruby_sqlserver'' 3. Connect to SQLServer in config/database.yml: development: mode: ADONET adapter: sqlserver host: YOURMACHINENAME\SQLEXPRESS database: app123_development integrated_security: true 4. Migrate the database and start the server: irake db:migrate ir script\server And that''s it! The documentation link above also has a walk through setting up IronRuby, Rails, and SQLServer, and shows a basic Rails "scaffold" running. Coming soon are updated instructions for running rack-based web applications in IIS on IronRuby. Let me know if you have any questions, ~Jimmy _______________________________________________ Ironruby-core mailing list Ironruby-core at rubyforge.org<mailto:Ironruby-core at rubyforge.org> http://rubyforge.org/mailman/listinfo/ironruby-core _______________________________________________ Ironruby-core mailing list Ironruby-core at rubyforge.org<mailto:Ironruby-core at rubyforge.org> http://rubyforge.org/mailman/listinfo/ironruby-core -------------- next part -------------- An HTML attachment was scrubbed... URL: <http://rubyforge.org/pipermail/ironruby-core/attachments/20100120/e9152a1c/attachment.html>
ironruby-sqlserver simple depends on ironruby-dbi, which replaces the built-in DBI module with one capable of working with ADO.NET, as well as activerecord-sqlserver-adapter. It also patches activerecord-sqlserver-adapter to allow connection through ADO.NET. So doing a gem install ironruby-sqlserver pulls down those two gems also, and wires everything up:> igem install ironruby-sqlserver --no-rdoc --no-riSuccessfully installed ironruby-dbi-0.1.0 Successfully installed activerecord-sqlserver-adapter-2.3.0 Successfully installed ironruby-sqlserver-0.1.0 3 gems installed In fact, your log below shows activerecord-sqlserver-adapter on the stack =) For the connection issue, did you set your database.yml? As long as ir.exe is running as you, integrated security should be fine. From looking at your log, this should work (if you?re using sqlexpress, and you set up the database to use Windows authentication): development: mode: ADONET adapter: sqlserver host: CATAPULT\SQLEXPRESS database: ironruby_on_rails_dev integrated_security: true Otherwise, you can set up a specific username and password for your database, and then specific the ?username? and ?password? in the database yml file. ~Jimmy From: ironruby-core-bounces at rubyforge.org [mailto:ironruby-core-bounces at rubyforge.org] On Behalf Of Ryan Riley Sent: Tuesday, January 19, 2010 8:46 PM To: ironruby-core at rubyforge.org Subject: Re: [Ironruby-core] Updated Rails instructions I just noticed the instructions are using ironruby-sqlserver though you note in your email that you are supporting activerecord-sqlserver-adapter. Is ironruby-sqlserver a wrapper, or would you just need to swap your adapter? I''m also running into other problems: 1) I verified that I have the correct access (unless rails needs access?), but irake db:migrate produces the following error: [?ui=2&view=att&th=1264a0aeac40d8b9&attid=0.1&disp=attd&realattid=ii_1264a0aeac40d8b9&zw] [?ui=2&view=att&th=1264a0b50426065a&attid=0.1&disp=attd&realattid=ii_1264a0b50426065a&zw] 2) Trying to open the environment settings from the default page for the Rails app produces this message: [?ui=2&view=att&th=1264a0a693b3123b&attid=0.1&disp=attd&realattid=ii_1264a0a693b3123b&zw] Any help is appreciated. I''m stumped. And if anyone knows how to copy text from Console2, I would appreciate the tip. Thanks! Ryan Riley Email: ryan.riley at panesofglass.org<mailto:ryan.riley at panesofglass.org> LinkedIn: http://www.linkedin.com/in/ryanriley Blog: http://wizardsofsmart.net/ Twitter: @panesofglass Website: http://panesofglass.org/ On Thu, Jan 14, 2010 at 6:48 PM, Jimmy Schementi <Jimmy.Schementi at microsoft.com<mailto:Jimmy.Schementi at microsoft.com>> wrote: All, http://ironruby.net/Documentation/Rails has been updated to show instructions for running Rails 2.3.5 on IronRuby, including using the official activerecord-sqlserver-adapter (v2.3). Thanks to Ivan for his work on ironruby-dbi! The steps are extrememly simple now. Assuming you have IronRuby installed and a Rails app you''d like to run on IronRuby: 1. Install Rake, Rails, and IronRuby SQLServer igem install rake rails ironruby-sqlserver 2. Add the following to the top of your app''s config/environment.rb: require ''rubygems'' require ''ironruby_sqlserver'' 3. Connect to SQLServer in config/database.yml: development: mode: ADONET adapter: sqlserver host: YOURMACHINENAME\SQLEXPRESS database: app123_development integrated_security: true 4. Migrate the database and start the server: irake db:migrate ir script\server And that''s it! The documentation link above also has a walk through setting up IronRuby, Rails, and SQLServer, and shows a basic Rails "scaffold" running. Coming soon are updated instructions for running rack-based web applications in IIS on IronRuby. Let me know if you have any questions, ~Jimmy _______________________________________________ Ironruby-core mailing list Ironruby-core at rubyforge.org<mailto:Ironruby-core at rubyforge.org> http://rubyforge.org/mailman/listinfo/ironruby-core -------------- next part -------------- An HTML attachment was scrubbed... URL: <http://rubyforge.org/pipermail/ironruby-core/attachments/20100120/1f72814f/attachment-0001.html> -------------- next part -------------- A non-text attachment was scrubbed... Name: image001.png Type: image/png Size: 621885 bytes Desc: image001.png URL: <http://rubyforge.org/pipermail/ironruby-core/attachments/20100120/1f72814f/attachment-0003.png> -------------- next part -------------- A non-text attachment was scrubbed... Name: image002.png Type: image/png Size: 400297 bytes Desc: image002.png URL: <http://rubyforge.org/pipermail/ironruby-core/attachments/20100120/1f72814f/attachment-0004.png> -------------- next part -------------- A non-text attachment was scrubbed... Name: image003.png Type: image/png Size: 36385 bytes Desc: image003.png URL: <http://rubyforge.org/pipermail/ironruby-core/attachments/20100120/1f72814f/attachment-0005.png>
I did everything you noted below. I think I had already installed ironruby-sqlserber, which is why I didn''t notice the adapter. In answer to Ivan, I created my database but forgot to check the logs. It''s been awhile since I used Rails and had db issues. :) Sadly, the log just tells me what trace tells me, which isn''t too surprising. I have had problems with connection timeouts on this machine in the past, but that was generally noticable in SSMS as well. I''ll try on another machine and see where I land. Thanks for the help! Ryan Sent from my iPhone On Jan 20, 2010, at 3:24 AM, Jimmy Schementi <Jimmy.Schementi at microsoft.com > wrote:> ironruby-sqlserver simple depends on ironruby-dbi, which replaces > the built-in DBI module with one capable of working with ADO.NET, as > well as activerecord-sqlserver-adapter. It also patches activerecord- > sqlserver-adapter to allow connection through ADO.NET. So doing a > gem install ironruby-sqlserver pulls down those two gems also, and > wires everything up: > > > > > igem install ironruby-sqlserver --no-rdoc --no-ri > > Successfully installed ironruby-dbi-0.1.0 > > Successfully installed activerecord-sqlserver-adapter-2.3.0 > > Successfully installed ironruby-sqlserver-0.1.0 > > 3 gems installed > > > > In fact, your log below shows activerecord-sqlserver-adapter on the > stack =) > > > > For the connection issue, did you set your database.yml? As long as > ir.exe is running as you, integrated security should be fine. From > looking at your log, this should work (if you?re using sqlexpress, a > nd you set up the database to use Windows authentication): > > > > development: > > mode: ADONET > > adapter: sqlserver > > host: CATAPULT\SQLEXPRESS > > database: ironruby_on_rails_dev > > integrated_security: true > > > > Otherwise, you can set up a specific username and password for your > database, and then specific the ?username? and ?password? in > the database yml file. > > > > ~Jimmy > > > > From: ironruby-core-bounces at rubyforge.org [mailto:ironruby-core- > bounces at rubyforge.org] On Behalf Of Ryan Riley > Sent: Tuesday, January 19, 2010 8:46 PM > To: ironruby-core at rubyforge.org > Subject: Re: [Ironruby-core] Updated Rails instructions > > > > I just noticed the instructions are using ironruby-sqlserver though > you note in your email that you are supporting activerecord- > sqlserver-adapter. Is ironruby-sqlserver a wrapper, or would you > just need to swap your adapter? > > > > I''m also running into other problems: > > 1) I verified that I have the correct access (unless rails needs > access?), but irake db:migrate produces the following error: > > <image001.png> > > <image002.png> > > 2) Trying to open the environment settings from the default page for > the Rails app produces this message: > > <image003.png> > > > > Any help is appreciated. I''m stumped. And if anyone knows how to > copy text from Console2, I would appreciate the tip. > > > > Thanks! > > > Ryan Riley > > Email: ryan.riley at panesofglass.org > LinkedIn: http://www.linkedin.com/in/ryanriley > Blog: http://wizardsofsmart.net/ > Twitter: @panesofglass > Website: http://panesofglass.org/ > > > On Thu, Jan 14, 2010 at 6:48 PM, Jimmy Schementi <Jimmy.Schementi at microsoft.com > > wrote: > > All, > > http://ironruby.net/Documentation/Rails has been updated to show > instructions for running Rails 2.3.5 on IronRuby, including using > the official activerecord-sqlserver-adapter (v2.3). Thanks to Ivan > for his work on ironruby-dbi! > > The steps are extrememly simple now. Assuming you have IronRuby > installed and a Rails app you''d like to run on IronRuby: > > 1. Install Rake, Rails, and IronRuby SQLServer > > igem install rake rails ironruby-sqlserver > > 2. Add the following to the top of your app''s config/environment.rb: > > require ''rubygems'' > require ''ironruby_sqlserver'' > > 3. Connect to SQLServer in config/database.yml: > > development: > mode: ADONET > adapter: sqlserver > host: YOURMACHINENAME\SQLEXPRESS > database: app123_development > integrated_security: true > > 4. Migrate the database and start the server: > > irake db:migrate > ir script\server > > And that''s it! The documentation link above also has a walk through > setting up IronRuby, Rails, and SQLServer, and shows a basic Rails > "scaffold" running. > > Coming soon are updated instructions for running rack-based web > applications in IIS on IronRuby. > > Let me know if you have any questions, > ~Jimmy > > _______________________________________________ > Ironruby-core mailing list > Ironruby-core at rubyforge.org > http://rubyforge.org/mailman/listinfo/ironruby-core > > > > _______________________________________________ > Ironruby-core mailing list > Ironruby-core at rubyforge.org > http://rubyforge.org/mailman/listinfo/ironruby-core-------------- next part -------------- An HTML attachment was scrubbed... URL: <http://rubyforge.org/pipermail/ironruby-core/attachments/20100120/714dc68e/attachment.html>
Turns out I''m just an idiot. I''ve not been able to get my connection to work. Turns out, my database name is just my computer name, not COMPUTERNAME\SQLEXPRESS. Sheesh! I switched machines recently and keep forgetting the name of my mahcine. Sorry for the trouble and thanks for the help! Ryan Riley Email: ryan.riley at panesofglass.org LinkedIn: http://www.linkedin.com/in/ryanriley Blog: http://wizardsofsmart.net/ Twitter: @panesofglass Website: http://panesofglass.org/ On Wed, Jan 20, 2010 at 3:24 AM, Jimmy Schementi < Jimmy.Schementi at microsoft.com> wrote:> ironruby-sqlserver simple depends on ironruby-dbi, which replaces the > built-in DBI module with one capable of working with ADO.NET, as well as > activerecord-sqlserver-adapter. It also patches > activerecord-sqlserver-adapter to allow connection through ADO.NET. So > doing a gem install ironruby-sqlserver pulls down those two gems also, and > wires everything up: > > > > > igem install ironruby-sqlserver --no-rdoc --no-ri > > Successfully installed ironruby-dbi-0.1.0 > > Successfully installed activerecord-sqlserver-adapter-2.3.0 > > Successfully installed ironruby-sqlserver-0.1.0 > > 3 gems installed > > > > In fact, your log below shows activerecord-sqlserver-adapter on the stack > =) > > > > For the connection issue, did you set your database.yml? As long as ir.exe > is running as you, integrated security should be fine. From looking at your > log, this should work (if you?re using sqlexpress, and you set up the > database to use Windows authentication): > > > > development: > > mode: ADONET > > adapter: sqlserver > > host: CATAPULT\SQLEXPRESS > > database: ironruby_on_rails_dev > > integrated_security: true > > > > Otherwise, you can set up a specific username and password for your > database, and then specific the ?username? and ?password? in the database > yml file. > > > > ~Jimmy > > > > *From:* ironruby-core-bounces at rubyforge.org [mailto: > ironruby-core-bounces at rubyforge.org] *On Behalf Of *Ryan Riley > *Sent:* Tuesday, January 19, 2010 8:46 PM > > *To:* ironruby-core at rubyforge.org > *Subject:* Re: [Ironruby-core] Updated Rails instructions > > > > I just noticed the instructions are using ironruby-sqlserver though you > note in your email that you are supporting activerecord-sqlserver-adapter. > Is ironruby-sqlserver a wrapper, or would you just need to swap your > adapter? > > > > I''m also running into other problems: > > 1) I verified that I have the correct access (unless rails needs access?), > but irake db:migrate produces the following error: > > [image: > ?ui=2&view=att&th=1264a0aeac40d8b9&attid=0.1&disp=attd&realattid=ii_1264a0aeac40d8b9&zw] > > [image: > ?ui=2&view=att&th=1264a0b50426065a&attid=0.1&disp=attd&realattid=ii_1264a0b50426065a&zw] > > 2) Trying to open the environment settings from the default page for the > Rails app produces this message: > > [image: > ?ui=2&view=att&th=1264a0a693b3123b&attid=0.1&disp=attd&realattid=ii_1264a0a693b3123b&zw] > > > > Any help is appreciated. I''m stumped. And if anyone knows how to copy text > from Console2, I would appreciate the tip. > > > > Thanks! > > > Ryan Riley > > Email: ryan.riley at panesofglass.org > LinkedIn: http://www.linkedin.com/in/ryanriley > Blog: http://wizardsofsmart.net/ > Twitter: @panesofglass > Website: http://panesofglass.org/ > > On Thu, Jan 14, 2010 at 6:48 PM, Jimmy Schementi < > Jimmy.Schementi at microsoft.com> wrote: > > All, > > http://ironruby.net/Documentation/Rails has been updated to show > instructions for running Rails 2.3.5 on IronRuby, including using the > official activerecord-sqlserver-adapter (v2.3). Thanks to Ivan for his work > on ironruby-dbi! > > The steps are extrememly simple now. Assuming you have IronRuby installed > and a Rails app you''d like to run on IronRuby: > > 1. Install Rake, Rails, and IronRuby SQLServer > > igem install rake rails ironruby-sqlserver > > 2. Add the following to the top of your app''s config/environment.rb: > > require ''rubygems'' > require ''ironruby_sqlserver'' > > 3. Connect to SQLServer in config/database.yml: > > development: > mode: ADONET > adapter: sqlserver > host: YOURMACHINENAME\SQLEXPRESS > database: app123_development > integrated_security: true > > 4. Migrate the database and start the server: > > irake db:migrate > ir script\server > > And that''s it! The documentation link above also has a walk through setting > up IronRuby, Rails, and SQLServer, and shows a basic Rails "scaffold" > running. > > Coming soon are updated instructions for running rack-based web > applications in IIS on IronRuby. > > Let me know if you have any questions, > ~Jimmy > > _______________________________________________ > Ironruby-core mailing list > Ironruby-core at rubyforge.org > http://rubyforge.org/mailman/listinfo/ironruby-core > > > > _______________________________________________ > Ironruby-core mailing list > Ironruby-core at rubyforge.org > http://rubyforge.org/mailman/listinfo/ironruby-core > >-------------- next part -------------- An HTML attachment was scrubbed... URL: <http://rubyforge.org/pipermail/ironruby-core/attachments/20100120/2b0b0647/attachment-0001.html> -------------- next part -------------- A non-text attachment was scrubbed... Name: not available Type: image/png Size: 621885 bytes Desc: not available URL: <http://rubyforge.org/pipermail/ironruby-core/attachments/20100120/2b0b0647/attachment-0003.png> -------------- next part -------------- A non-text attachment was scrubbed... Name: not available Type: image/png Size: 400297 bytes Desc: not available URL: <http://rubyforge.org/pipermail/ironruby-core/attachments/20100120/2b0b0647/attachment-0004.png> -------------- next part -------------- A non-text attachment was scrubbed... Name: not available Type: image/png Size: 36385 bytes Desc: not available URL: <http://rubyforge.org/pipermail/ironruby-core/attachments/20100120/2b0b0647/attachment-0005.png>
Bug noticed:
Only with the new adapter (used igem install ...), only when I create a
new row, the redirect below adds two 0''s to the end of the new rows id
(I.E. id = 56, it will try to show 5600). Switched back to the old
adapter (at work) for now.
code:
@company = Company.new(params[:company])
if @company.save
flash[:notice] = "Successfully created company."
redirect_to company_path(@company)
else
Jimmy Schementi wrote:> All,
>
> http://ironruby.net/Documentation/Rails has been updated to show
> instructions for running Rails 2.3.5 on IronRuby, including using the
> official activerecord-sqlserver-adapter (v2.3). Thanks to Ivan for his
> work on ironruby-dbi!
>
> The steps are extrememly simple now. Assuming you have IronRuby
> installed and a Rails app you''d like to run on IronRuby:
>
> 1. Install Rake, Rails, and IronRuby SQLServer
>
> igem install rake rails ironruby-sqlserver
>
> 2. Add the following to the top of your app''s
config/environment.rb:
>
> require ''rubygems''
> require ''ironruby_sqlserver''
>
> 3. Connect to SQLServer in config/database.yml:
>
> development:
> mode: ADONET
> adapter: sqlserver
> host: YOURMACHINENAME\SQLEXPRESS
> database: app123_development
> integrated_security: true
>
> 4. Migrate the database and start the server:
>
> irake db:migrate
> ir script\server
>
> And that''s it! The documentation link above also has a walk
through
> setting up IronRuby, Rails, and SQLServer, and shows a basic Rails
> "scaffold" running.
>
> Coming soon are updated instructions for running rack-based web
> applications in IIS on IronRuby.
>
> Let me know if you have any questions,
> ~Jimmy
--
Posted via http://www.ruby-forum.com/.
> -----Original Message----- > From: ironruby-core-bounces at rubyforge.org [mailto:ironruby-core- > bounces at rubyforge.org] On Behalf Of Sam Clopton > Sent: Wednesday, January 20, 2010 12:49 PM > To: ironruby-core at rubyforge.org > Subject: Re: [Ironruby-core] Updated Rails instructions > > Bug noticed: > Only with the new adapter (used igem install ...), only when I create a > new row, the redirect below adds two 0''s to the end of the new rows id > (I.E. id = 56, it will try to show 5600). Switched back to the old > adapter (at work) for now. > > code: > @company = Company.new(params[:company]) > if @company.save > flash[:notice] = "Successfully created company." > redirect_to company_path(@company) > elseI''m not seeing this; the scaffolding example at the link below does the same thing, and redirects fine with the new adapter (a Post created with the id "4" will redirect to "/posts/4"): @post = Post.new(params[:post]) if @post.save flash[:notice] = ''Post was successfully created.'' redirect_to(@post) else render :action => "new" end Can you possibly send more information with the old adapter? I''d like these lines added right after @company.save succeeds (inside the "if" statement), and then could you send the output? p params p @company p company_path(@company) ~Jimmy> Jimmy Schementi wrote: > > All, > > > > http://ironruby.net/Documentation/Rails has been updated to show > > instructions for running Rails 2.3.5 on IronRuby, including using the > > official activerecord-sqlserver-adapter (v2.3). Thanks to Ivan for his > > work on ironruby-dbi! > > > > The steps are extrememly simple now. Assuming you have IronRuby > > installed and a Rails app you''d like to run on IronRuby: > > > > 1. Install Rake, Rails, and IronRuby SQLServer > > > > igem install rake rails ironruby-sqlserver > > > > 2. Add the following to the top of your app''s config/environment.rb: > > > > require ''rubygems'' > > require ''ironruby_sqlserver'' > > > > 3. Connect to SQLServer in config/database.yml: > > > > development: > > mode: ADONET > > adapter: sqlserver > > host: YOURMACHINENAME\SQLEXPRESS > > database: app123_development > > integrated_security: true > > > > 4. Migrate the database and start the server: > > > > irake db:migrate > > ir script\server > > > > And that''s it! The documentation link above also has a walk through > > setting up IronRuby, Rails, and SQLServer, and shows a basic Rails > > "scaffold" running. > > > > Coming soon are updated instructions for running rack-based web > > applications in IIS on IronRuby. > > > > Let me know if you have any questions, > > ~Jimmy > > -- > Posted via http://www.ruby-forum.com/. > _______________________________________________ > Ironruby-core mailing list > Ironruby-core at rubyforge.org > http://rubyforge.org/mailman/listinfo/ironruby-core
> I''m not seeing this; the scaffolding example at the link below does the > same thing, and redirects fine with the new adapter (a Post created with > the id "4" will redirect to "/posts/4"): > > @post = Post.new(params[:post]) > if @post.save > flash[:notice] = ''Post was successfully created.'' > redirect_to(@post) > else > render :action => "new" > end > > Can you possibly send more information with the old adapter? I''d like > these lines added right after @company.save succeeds (inside the "if" > statement), and then could you send the output? > > p params > p @company > p company_path(@company) > > ~JimmyHopefully this helps: authenticity_tokenmrfvGtPzabzzhhdx/NFuxMlM64Q50R0V3cQbOtpJjws=companynamehmmmjj...commentstestcommitSubmitcontrollercompaniesactioncreate #<Company:0x000ea44> /companies/268 -- Posted via http://www.ruby-forum.com/.
> I''m not seeing this; the scaffolding example at the link below does the > same thing, and redirects fine with the new adapter (a Post created with > the id "4" will redirect to "/posts/4"): > > @post = Post.new(params[:post]) > if @post.save > flash[:notice] = ''Post was successfully created.'' > redirect_to(@post) > else > render :action => "new" > end > > Can you possibly send more information with the old adapter? I''d like > these lines added right after @company.save succeeds (inside the "if" > statement), and then could you send the output? > > p params > p @company > p company_path(@company) > > ~JimmyShould have included this in the last post, but here is both of the data with the new/old adapter: *** New Adapter *** Processing CompaniesController#create (for 127.0.0.1 at 2010-01-22 14:33:19) [POST] Parameters: {"authenticity_token"=>"mrfvGtPzabzzhhdx/NFuxMlM64Q50R0V3cQbOtpJjws=", "company"=>{"name"=>"hmmmjjj...", "comments"=>"test"}, "commit"=>"Submit", "controller"=>"companies", "action"=>"create"} [4;36;1mUser Load (0.0ms) [0;1mSELECT TOP 1 * FROM [users] WHERE ([users].[id] = ''1'') [4;35;1mEXECUTE (15.6ms) BEGIN TRANSACTION [4;36;1mCompany Create (46.9ms) [0;1mINSERT INTO [companies] ([name], [comments]) VALUES(''hmmmjjj...'', ''test'') [4;35;1mSQL (0.0ms) SELECT SCOPE_IDENTITY() AS Ident [4;36;1mEXECUTE (0.0ms) [0;1mCOMMIT TRANSACTION authenticity_tokenmrfvGtPzabzzhhdx/NFuxMlM64Q50R0V3cQbOtpJjws=companynamehmmmjjj...commentstestcommitSubmitcontrollercompaniesactioncreate #<Company:0x000263e> /companies/26900 Redirected to http://127.0.0.1:3000/companies/26900 *** Old Adapter *** Processing CompaniesController#create (for 127.0.0.1 at 2010-01-22 14:30:02) [POST] Parameters: {"authenticity_token"=>"mrfvGtPzabzzhhdx/NFuxMlM64Q50R0V3cQbOtpJjws=", "company"=>{"name"=>"hmmmjj...", "comments"=>"test"}, "commit"=>"Submit", "controller"=>"companies", "action"=>"create"} authenticity_tokenmrfvGtPzabzzhhdx/NFuxMlM64Q50R0V3cQbOtpJjws=companynamehmmmjj...commentstestcommitSubmitcontrollercompaniesactioncreate #<Company:0x000ea44> /companies/268 Redirected to http://127.0.0.1:3000/companies/268 Completed in 1922ms (DB: 0) | 302 Found [http://127.0.0.1/companies] -- Posted via http://www.ruby-forum.com/.
Sam Clopton wrote:> Processing CompaniesController#create (for 127.0.0.1 at 2010-01-22 > 14:33:19) [POST] > Parameters: > {"authenticity_token"=>"mrfvGtPzabzzhhdx/NFuxMlM64Q50R0V3cQbOtpJjws=", > "company"=>{"name"=>"hmmmjjj...", "comments"=>"test"}, > "commit"=>"Submit", "controller"=>"companies", "action"=>"create"} > [4;36;1mUser Load (0.0ms) [0;1mSELECT TOP 1 * FROM [users] > WHERE ([users].[id] = ''1'') > [4;35;1mEXECUTE (15.6ms) BEGIN TRANSACTION > [4;36;1mCompany Create (46.9ms) [0;1mINSERT INTO [companies] > ([name], [comments]) VALUES(''hmmmjjj...'', ''test'') > [4;35;1mSQL (0.0ms) SELECT SCOPE_IDENTITY() AS Ident > [4;36;1mEXECUTE (0.0ms) [0;1mCOMMIT TRANSACTION > authenticity_tokenmrfvGtPzabzzhhdx/NFuxMlM64Q50R0V3cQbOtpJjws=companynamehmmmjjj...commentstestcommitSubmitcontrollercompaniesactioncreate > #<Company:0x000263e> > /companies/26900 > Redirected to http://127.0.0.1:3000/companies/26900 > > *** Old Adapter *** > > Processing CompaniesController#create (for 127.0.0.1 at 2010-01-22 > 14:30:02) [POST] > Parameters: > {"authenticity_token"=>"mrfvGtPzabzzhhdx/NFuxMlM64Q50R0V3cQbOtpJjws=", > "company"=>{"name"=>"hmmmjj...", "comments"=>"test"}, > "commit"=>"Submit", "controller"=>"companies", "action"=>"create"} > authenticity_tokenmrfvGtPzabzzhhdx/NFuxMlM64Q50R0V3cQbOtpJjws=companynamehmmmjj...commentstestcommitSubmitcontrollercompaniesactioncreate > #<Company:0x000ea44> > /companies/268 > Redirected to http://127.0.0.1:3000/companies/268 > Completed in 1922ms (DB: 0) | 302 Found [http://127.0.0.1/companies]Jimmy, Do you have any suggestions or is there anything else I can do to help pin down this problem? Thanks, Sam -- Posted via http://www.ruby-forum.com/.
I wanted to see "p @company" (equivalent of "puts @company.inspect") to see what fields it had, since ActiveRecord shows detailed view of the object, including fields. Really I want to see whether the ID is "269" or "26900". Ivan, does this issue seem at all familiar to you? Sam, it''d be helpful if you could produce a small repro, just with ActiveRecord alone, that shows the ID being appended with two zeros. I''d suggest using script\console as it gives you an environment preconfigured for ActiveRecord. If we have a targeted repo of the issue, it''ll be easier to diagnose and fix. Ideally, you could just send me the application zipped up, but at a minimum I''ll need the migration that creates the table, the model file, and whatever other code reproduces the error. ~Jimmy> -----Original Message----- > From: ironruby-core-bounces at rubyforge.org [mailto:ironruby-core- > bounces at rubyforge.org] On Behalf Of Sam Clopton > Sent: Monday, January 25, 2010 3:06 PM > To: ironruby-core at rubyforge.org > Subject: Re: [Ironruby-core] Updated Rails instructions > > Sam Clopton wrote: > > > Processing CompaniesController#create (for 127.0.0.1 at 2010-01-22 > > 14:33:19) [POST] > > Parameters: > > {"authenticity_token"=>"mrfvGtPzabzzhhdx/NFuxMlM64Q50R0V3cQbOtpJjws=", > > "company"=>{"name"=>"hmmmjjj...", "comments"=>"test"}, > > "commit"=>"Submit", "controller"=>"companies", "action"=>"create"} > > [4;36;1mUser Load (0.0ms) [0;1mSELECT TOP 1 * FROM [users] > > WHERE ([users].[id] = ''1'') > > [4;35;1mEXECUTE (15.6ms) BEGIN TRANSACTION > > [4;36;1mCompany Create (46.9ms) [0;1mINSERT INTO [companies] > > ([name], [comments]) VALUES(''hmmmjjj...'', ''test'') > > [4;35;1mSQL (0.0ms) SELECT SCOPE_IDENTITY() AS Ident > > [4;36;1mEXECUTE (0.0ms) [0;1mCOMMIT TRANSACTION > > authenticity_tokenmrfvGtPzabzzhhdx/NFuxMlM64Q50R0V3cQbOtpJjws=companyn > > amehmmmjjj...commentstestcommitSubmitcontrollercompaniesactioncreate > > #<Company:0x000263e> > > /companies/26900 > > Redirected to http://127.0.0.1:3000/companies/26900 > > > > *** Old Adapter *** > > > > Processing CompaniesController#create (for 127.0.0.1 at 2010-01-22 > > 14:30:02) [POST] > > Parameters: > > {"authenticity_token"=>"mrfvGtPzabzzhhdx/NFuxMlM64Q50R0V3cQbOtpJjws=", > > "company"=>{"name"=>"hmmmjj...", "comments"=>"test"}, > > "commit"=>"Submit", "controller"=>"companies", "action"=>"create"} > > authenticity_tokenmrfvGtPzabzzhhdx/NFuxMlM64Q50R0V3cQbOtpJjws=companyn > > amehmmmjj...commentstestcommitSubmitcontrollercompaniesactioncreate > > #<Company:0x000ea44> > > /companies/268 > > Redirected to http://127.0.0.1:3000/companies/268 > > Completed in 1922ms (DB: 0) | 302 Found [http://127.0.0.1/companies] > > Jimmy, > > Do you have any suggestions or is there anything else I can do to help pin > down this problem? > > Thanks, > Sam > -- > Posted via http://www.ruby-forum.com/. > _______________________________________________ > Ironruby-core mailing list > Ironruby-core at rubyforge.org > http://rubyforge.org/mailman/listinfo/ironruby-core
I''m not seeing that issue atm but I''ll work on ironruby-sqlserver tonight. So if Sam wants to send me a repro I can also look at the cause for his problem and hopefully fix it. --- Met vriendelijke groeten - Best regards - Salutations Ivan Porto Carrero Blog: http://flanders.co.nz Twitter: http://twitter.com/casualjim Author of IronRuby in Action (http://manning.com/carrero) On Tue, Jan 26, 2010 at 10:06 AM, Jimmy Schementi < Jimmy.Schementi at microsoft.com> wrote:> I wanted to see "p @company" (equivalent of "puts @company.inspect") to see > what fields it had, since ActiveRecord shows detailed view of the object, > including fields. Really I want to see whether the ID is "269" or "26900". > > Ivan, does this issue seem at all familiar to you? > > Sam, it''d be helpful if you could produce a small repro, just with > ActiveRecord alone, that shows the ID being appended with two zeros. I''d > suggest using script\console as it gives you an environment preconfigured > for ActiveRecord. If we have a targeted repo of the issue, it''ll be easier > to diagnose and fix. Ideally, you could just send me the application zipped > up, but at a minimum I''ll need the migration that creates the table, the > model file, and whatever other code reproduces the error. > > ~Jimmy > > > > -----Original Message----- > > From: ironruby-core-bounces at rubyforge.org [mailto:ironruby-core- > > bounces at rubyforge.org] On Behalf Of Sam Clopton > > Sent: Monday, January 25, 2010 3:06 PM > > To: ironruby-core at rubyforge.org > > Subject: Re: [Ironruby-core] Updated Rails instructions > > > > Sam Clopton wrote: > > > > > Processing CompaniesController#create (for 127.0.0.1 at 2010-01-22 > > > 14:33:19) [POST] > > > Parameters: > > > {"authenticity_token"=>"mrfvGtPzabzzhhdx/NFuxMlM64Q50R0V3cQbOtpJjws=", > > > "company"=>{"name"=>"hmmmjjj...", "comments"=>"test"}, > > > "commit"=>"Submit", "controller"=>"companies", "action"=>"create"} > > > [4;36;1mUser Load (0.0ms) [0m [0;1mSELECT TOP 1 * FROM [users] > > > WHERE ([users].[id] = ''1'') [0m > > > [4;35;1mEXECUTE (15.6ms) [0m [0mBEGIN TRANSACTION [0m > > > [4;36;1mCompany Create (46.9ms) [0m [0;1mINSERT INTO [companies] > > > ([name], [comments]) VALUES(''hmmmjjj...'', ''test'') [0m > > > [4;35;1mSQL (0.0ms) [0m [0mSELECT SCOPE_IDENTITY() AS Ident [0m > > > [4;36;1mEXECUTE (0.0ms) [0m [0;1mCOMMIT TRANSACTION [0m > > > authenticity_tokenmrfvGtPzabzzhhdx/NFuxMlM64Q50R0V3cQbOtpJjws=companyn > > > amehmmmjjj...commentstestcommitSubmitcontrollercompaniesactioncreate > > > #<Company:0x000263e> > > > /companies/26900 > > > Redirected to http://127.0.0.1:3000/companies/26900 > > > > > > *** Old Adapter *** > > > > > > Processing CompaniesController#create (for 127.0.0.1 at 2010-01-22 > > > 14:30:02) [POST] > > > Parameters: > > > {"authenticity_token"=>"mrfvGtPzabzzhhdx/NFuxMlM64Q50R0V3cQbOtpJjws=", > > > "company"=>{"name"=>"hmmmjj...", "comments"=>"test"}, > > > "commit"=>"Submit", "controller"=>"companies", "action"=>"create"} > > > authenticity_tokenmrfvGtPzabzzhhdx/NFuxMlM64Q50R0V3cQbOtpJjws=companyn > > > amehmmmjj...commentstestcommitSubmitcontrollercompaniesactioncreate > > > #<Company:0x000ea44> > > > /companies/268 > > > Redirected to http://127.0.0.1:3000/companies/268 > > > Completed in 1922ms (DB: 0) | 302 Found [http://127.0.0.1/companies] > > > > Jimmy, > > > > Do you have any suggestions or is there anything else I can do to help > pin > > down this problem? > > > > Thanks, > > Sam > > -- > > Posted via http://www.ruby-forum.com/. > > _______________________________________________ > > Ironruby-core mailing list > > Ironruby-core at rubyforge.org > > http://rubyforge.org/mailman/listinfo/ironruby-core > >-------------- next part -------------- An HTML attachment was scrubbed... URL: <http://rubyforge.org/pipermail/ironruby-core/attachments/20100126/d4b707f5/attachment.html>
The ActiveRecord unit tests do have failures where extra 0s are appended. You
can see it from the following disabled tags in
Merlin\Main\Languages\Ruby\Tests\Scripts\utr\active_record_tests.rb (its not yet
pushed to GIT).
disable InheritanceTest,
# <#<VerySpecialClient id: 780, type: nil, ruby_type:
"VerySpecialClient", firm_id: nil, firm_name: nil, name:
"veryspecial", client_of: nil, rating: 1>> expected but was
# <#<VerySpecialClient id: 78, type: nil, ruby_type:
"VerySpecialClient", firm_id: nil, firm_name: nil, name:
"veryspecial", client_of: nil, rating: 1>>.
#
# diff:
# - #<VerySpecialClient id: 780, type: nil, ruby_type:
"VerySpecialClient",
:test_alt_complex_inheritance,
disable HasOneThroughAssociationsTest,
# ActiveRecord::StatementInvalid: DBI::DatabaseError: Arithmetic overflow
error converting expression to data type int.
# The statement has been terminated.: INSERT INTO [memberships]
([joined_on], [club_id], [member_id], [favourite], [type]) VALUES(NULL,
1054009214000000000, 102717546000000000, 0,
''CurrentMembership'')
# abstract_adapter.rb:201:in `log''
# sqlserver_adapter.rb:839:in `raw_execute''
# sqlserver_adapter.rb:403:in `execute''
:test_assigning_association_correctly_assigns_target,
From: Ivan Porto Carrero [mailto:ivan at flanders.co.nz]
Sent: Tuesday, January 26, 2010 1:09 AM
To: Jimmy Schementi
Cc: ironruby-core at rubyforge.org; Shri Borde
Subject: Re: [Ironruby-core] Updated Rails instructions
I''m not seeing that issue atm but I''ll work on
ironruby-sqlserver tonight.
So if Sam wants to send me a repro I can also look at the cause for his problem
and hopefully fix it.
---
Met vriendelijke groeten - Best regards - Salutations
Ivan Porto Carrero
Blog: http://flanders.co.nz
Twitter: http://twitter.com/casualjim
Author of IronRuby in Action (http://manning.com/carrero)
On Tue, Jan 26, 2010 at 10:06 AM, Jimmy Schementi <Jimmy.Schementi at
microsoft.com<mailto:Jimmy.Schementi at microsoft.com>> wrote:
I wanted to see "p @company" (equivalent of "puts
@company.inspect") to see what fields it had, since ActiveRecord shows
detailed view of the object, including fields. Really I want to see whether the
ID is "269" or "26900".
Ivan, does this issue seem at all familiar to you?
Sam, it''d be helpful if you could produce a small repro, just with
ActiveRecord alone, that shows the ID being appended with two zeros.
I''d suggest using script\console as it gives you an environment
preconfigured for ActiveRecord. If we have a targeted repo of the issue,
it''ll be easier to diagnose and fix. Ideally, you could just send me
the application zipped up, but at a minimum I''ll need the migration
that creates the table, the model file, and whatever other code reproduces the
error.
~Jimmy
> -----Original Message-----
> From: ironruby-core-bounces at
rubyforge.org<mailto:ironruby-core-bounces at rubyforge.org>
[mailto:ironruby-core-<mailto:ironruby-core->
> bounces at rubyforge.org<mailto:bounces at rubyforge.org>] On Behalf
Of Sam Clopton
> Sent: Monday, January 25, 2010 3:06 PM
> To: ironruby-core at rubyforge.org<mailto:ironruby-core at
rubyforge.org>
> Subject: Re: [Ironruby-core] Updated Rails instructions
>
> Sam Clopton wrote:
>
> > Processing CompaniesController#create (for 127.0.0.1 at 2010-01-22
> > 14:33:19) [POST]
> > Parameters:
> >
{"authenticity_token"=>"mrfvGtPzabzzhhdx/NFuxMlM64Q50R0V3cQbOtpJjws=",
> > "company"=>{"name"=>"hmmmjjj...",
"comments"=>"test"},
> > "commit"=>"Submit",
"controller"=>"companies",
"action"=>"create"}
> > [4;36;1mUser Load (0.0ms) [0m [0;1mSELECT TOP 1 * FROM [users]
> > WHERE ([users].[id] = ''1'') [0m
> > [4;35;1mEXECUTE (15.6ms) [0m [0mBEGIN TRANSACTION [0m
> > [4;36;1mCompany Create (46.9ms) [0m [0;1mINSERT INTO [companies]
> > ([name], [comments]) VALUES(''hmmmjjj...'',
''test'') [0m
> > [4;35;1mSQL (0.0ms) [0m [0mSELECT SCOPE_IDENTITY() AS Ident [0m
> > [4;36;1mEXECUTE (0.0ms) [0m [0;1mCOMMIT TRANSACTION [0m
> > authenticity_tokenmrfvGtPzabzzhhdx/NFuxMlM64Q50R0V3cQbOtpJjws=companyn
> > amehmmmjjj...commentstestcommitSubmitcontrollercompaniesactioncreate
> > #<Company:0x000263e>
> > /companies/26900
> > Redirected to http://127.0.0.1:3000/companies/26900
> >
> > *** Old Adapter ***
> >
> > Processing CompaniesController#create (for 127.0.0.1 at 2010-01-22
> > 14:30:02) [POST]
> > Parameters:
> >
{"authenticity_token"=>"mrfvGtPzabzzhhdx/NFuxMlM64Q50R0V3cQbOtpJjws=",
> > "company"=>{"name"=>"hmmmjj...",
"comments"=>"test"},
> > "commit"=>"Submit",
"controller"=>"companies",
"action"=>"create"}
> > authenticity_tokenmrfvGtPzabzzhhdx/NFuxMlM64Q50R0V3cQbOtpJjws=companyn
> > amehmmmjj...commentstestcommitSubmitcontrollercompaniesactioncreate
> > #<Company:0x000ea44>
> > /companies/268
> > Redirected to http://127.0.0.1:3000/companies/268
> > Completed in 1922ms (DB: 0) | 302 Found [http://127.0.0.1/companies]
>
> Jimmy,
>
> Do you have any suggestions or is there anything else I can do to help pin
> down this problem?
>
> Thanks,
> Sam
> --
> Posted via http://www.ruby-forum.com/.
> _______________________________________________
> Ironruby-core mailing list
> Ironruby-core at rubyforge.org<mailto:Ironruby-core at rubyforge.org>
> http://rubyforge.org/mailman/listinfo/ironruby-core
-------------- next part --------------
An HTML attachment was scrubbed...
URL:
<http://rubyforge.org/pipermail/ironruby-core/attachments/20100126/c32ad812/attachment-0001.html>
The database has information that is FOUO. Even though to me it seems that none of the source code has any of that information (why should it), I don''t really want to send any of it other than snippets just to protect myself. I should be able to put together a different case at home that has the same problems as mine. If the ActiveRecord unit tests noted above by Shri will work, let me know. Ivan Porto carrero wrote:> I''m not seeing that issue atm but I''ll work on ironruby-sqlserver > tonight. > So if Sam wants to send me a repro I can also look at the cause for his > problem and hopefully fix it. > --- > Met vriendelijke groeten - Best regards - Salutations > Ivan Porto Carrero > Blog: http://flanders.co.nz > Twitter: http://twitter.com/casualjim > Author of IronRuby in Action (http://manning.com/carrero) > > > > On Tue, Jan 26, 2010 at 10:06 AM, Jimmy Schementi <-- Posted via http://www.ruby-forum.com/.
I think they will work as a good enough repro. I''ll let you know when we have a fix. Ivan, are you looking into this? ~Jimmy> -----Original Message----- > From: ironruby-core-bounces at rubyforge.org [mailto:ironruby-core- > bounces at rubyforge.org] On Behalf Of Sam Clopton > Sent: Tuesday, January 26, 2010 2:18 PM > To: ironruby-core at rubyforge.org > Subject: Re: [Ironruby-core] Updated Rails instructions > > The database has information that is FOUO. Even though to me it seems that > none of the source code has any of that information (why should it), I don''t > really want to send any of it other than snippets just to protect myself. I > should be able to put together a different case at home that has the same > problems as mine. > > If the ActiveRecord unit tests noted above by Shri will work, let me know. > > > > Ivan Porto carrero wrote: > > I''m not seeing that issue atm but I''ll work on ironruby-sqlserver > > tonight. > > So if Sam wants to send me a repro I can also look at the cause for his > > problem and hopefully fix it. > > --- > > Met vriendelijke groeten - Best regards - Salutations > > Ivan Porto Carrero > > Blog: http://flanders.co.nz > > Twitter: http://twitter.com/casualjim > > Author of IronRuby in Action (http://manning.com/carrero) > > > > > > > > On Tue, Jan 26, 2010 at 10:06 AM, Jimmy Schementi < > > -- > Posted via http://www.ruby-forum.com/. > _______________________________________________ > Ironruby-core mailing list > Ironruby-core at rubyforge.org > http://rubyforge.org/mailman/listinfo/ironruby-core