Where communities thrive

  • Join over 1.5M+ people
  • Join over 100K+ communities
  • Free without limits
  • Create your own community
Repo info
    Rafael Vicente Saura
    hello I have a doubt I need a non relational database for now I am using mongodb and I am happy with it but sql has taken filetables that allows the use of files in the sql Which is better?
    Rob Widmer
    @metaskills We're making an effort to support mssql in jruby and we currently have 2 different approaches that we're trying and we need some input from this project as to what makes sense long term
    I think the preferred method is to have a wrapper around the ActiveRecord-sqlserver-adapter gem that just takes care of the driver specifics, i.e. jruby/activerecord-jdbc-adapter#1008
    But that depends on us being able to get some changes into activerecord-sqlserver-adapter and knowing that there will be support long term
    The other option that has been proposed is basically a fork of the activerecord-sqlserver-adapter into the activerecord-jdbc-adapter gem i.e. jruby/activerecord-jdbc-adapter#1007
    Rob Widmer
    I think it is beneficial for both projects in the long term to go with the first option because then we don't have 2 entirely different implementations of the core of the adapter, but if you think it will be too much work to make it happen, then we can go the "fork" route
    vipul Aggarwal
    is anyone working on this project these days?
    And is @metaskills around?
    folks, re-iterating Eduardo's question above. Any help for installing this for ruby 2.6 ?
    Benjamin Fleischer
    we have it working on Ruby 2.6
    it works fine, no?
    on windows 10 ?
    so still cimplains
    I mean it still complains about being incompatible with ruby 2.6
    yassine ben gharsallah
    Hello guys i have some questions about an sql query could you help me ?
    Hi guys, does this gem work with jdbc as well, or do I have to use 'activerecord-jdbcmssql-adapter' instead?
    Rob Widmer
    Hi @podsi, It depends what version of active record you are using, if you are 4.2 or lower you can use the activerecord-jdbcmssql-adapter gem, 5 or above, we're hoping to have an activerecord-jdbcsqlserver-adapter gem released before rubyconf
    Hi @rdubya, thx for your fast response, we are using activerecord 5.2.3, so I am looking forward to the release!
    David McDonald
    I'm attempting to fix the failing tests on Master. I've gotten them resolved down to just 17 ActiveRecord errors. But I'm new to contributing to projects and alot of this is new to me. I'm getting a lot of messages like "Unfound coerced test: ActiveRecord::AdapterTest#test_select_all_with_legacy_binds" when running "rake test TEST=test/cases/coerced_tests.rb"
    I'm not sure quite how to interpret that
    Enrique González
    hi! i was able to run rails 6 with the github branch 6-0-dev. is there a reason that it is not being pushed to master?
    Titov Andrey

    H everyone:
    I'm experiencing below error altough database.yml stated database different from "master":

    "<username>" is not able to access the database "master" under the current security context

    Any ideas?

    Dale Glaser
    @Enrand22_twitter I would assume it's because there are still tests failing.
    Titov Andrey
    @idrozd upd: added azure: true / solved
    Joseph Haig
    Hi. We are possibly going to be moving some Rails apps to Azure and, as such, could start using an MS SQL server as the database. I have literally just starting playing around with this (thanks for this gem, by the way) and am trying it with a mcr.microsoft.com/mssql/server:2017-latest-ubuntu docker image. Our migrations are failing because at some points we are defining columns as 'bool' which, I see now, is not standard SQL. Is there a way to get the sqlserver adapter to automatically substitute for (presumably) a tiny int or a char?

    NoMethodError: undefined method `alias_method_chain' for #<Class:ActiveRecord::Base>
    Did you mean? alias_method

    i always get this error when i make db with sql server in rails

    Andrew Blignaut
    Hi All, I just recently a pull request to the repo but I see that the build is failing for most open pull requests. What's up? Is anyone actively getting the tests back up and running and reviewing pull requests? Thanks
    anyone got this thing running with rails 6 and ruby 2.7?
    anyone even reading this ? xD
    Andrew Blignaut
    @nemesit - No, we are running rails 5.2 at the moment.
    @AndrewBlignaut_twitter yeah we are too, shame really. do the 5.2 tests for this adapter all pass for you?
    I fixed all the ONLY_SQLSERVER=1 errors for rails 6 dunno bout the activerecord stuff
    Hey guys, I know this doesn't work with rails 6 - but do you know when it will be? Not exactly, i just wanna know is it like 2 months or 12 months amount of time
    @dlipinski it will be ready as soon as some has time to run all tests and fix the failing ones. Yoe are welcome to help in this matter ;-)
    Aidan Haran
    All the Rails 6 tests are now passing on Travis CI. Trying to fix the last of the tests failing on Windows (AppVeyor). After that is done then I think there will be a release candidate for Rails 6.
    Wanderson Policarpo
    I released the first RC for Rails 6 v6.0.0.rc1 now. I appreciate if you have a chance to test it and give any feedback or report issues here: https://github.com/rails-sqlserver/activerecord-sqlserver-adapter/issues
    anyone know why I am getting

    rails db:migrate:down VERSION=20200528104729 RAILS_ENV=development
    == 20200528104729 SomeMigration: reverting =====================================
    rails aborted!
    StandardError: An error has occurred, all later migrations canceled:

    undefined method `revert' for #<ActiveRecord::ConnectionAdapters::SQLServerAdapter:0x00007f7f271c3150>

    (5.2 not rails 6)
    and another thing is that it seems like disable_referential_integrity does not get called when testing
    I'm not sure but I think thats kinda necessary
    Aidan Haran
    @nemesit For the "rails db:migrate:down" issue can you create a reproducible script to demonstrate the issue? https://github.com/rails-sqlserver/activerecord-sqlserver-adapter/wiki/How-to-report-a-bug
    @nemesit The tests are currently passing for Rails 5.2 and 6 so I'm not sure why "disable_referential_integrity" is necessary.
    maybe only occurs with multiple adapters
    that it only disables constraints on the main one and not all?
    I guess that could be the problem
    likely in rails itself