Why does the adapter run a query to get a default value again, when it should already be there from this line of code
@BobbyMcWho The adapter uses no tables, its your code which accesses tables.
@KDGundermann I think the reason is the "includes" vs "left_joins".Device.left_joins(:health_records).order('health_records.error_number desc').page(1).limit(10).count returns 10
Device.includes(:health_records).order('health_records.error_number desc').page(1).limit(10).count returns 3
the only difference is includes and left_joins in the queries above. can you explain to me why?
non-rails
figured it out. I had to clear my local gemset in rvm and lock my active record to ~>5.1
then install the other gems
I need to set up a connection with sql server 2008 in rails
all I want to make is a direct sql connection that I can write sql queries
I have the database credentials
would need 1. set up the database connection, 2. sql interface to database
Going from version 4.2.18 to 5.0.8 (We're of course also upgrading Rails) has broker finder behavior on a table with multiple primary keys, and I'm not sure how to address it. For example
MyRecord.where(field_name: value).take now fails with ActiveRecord::StatementInvalid:TinyTds::Error: Invalid column name '"TicketNo", "UniqueID", "ItemNo"'.: EXEC sp_executesql N'SELECT [Tkscale].* FROM [Tkscale] WHERE [Tkscale].[TicketNo] = @0 ORDER BY [Tkscale].["TicketNo", "UniqueID", "ItemNo"] ASC OFFSET 0 ROWS FETCH NEXT @1 ROWS ONLY', N'@0 nvarchar(max), @1 int', @0 = N'10234770', @1 = 1 which is odd since I didn't ask for the ordering. I'm not sure how to fix this. I have set MyRecord.table_name = 'Tkbatch' and MyRecord.primary_key = :UniqueId. MyRecord.connection.schema_cache.primary_keys("Tkbatch") returns ["TicketNo", "UniqueID", "ItemNo"]. I can't find an issue or in the code where this should be addressed. any ideas?
I could get around it by setting a default scope with an
order but that's kind of a workaround
I'm running ubuntu. The rails 4 app with my config worked on my mac. I'm getting an error:
"Unable Adaptive Server connection failed (servername.database.secure.windows.net:1433)"
tiny_tds (2.1.2) lib/tiny_tds/client.rb:60:in 'connect'
tiny_tds (2.1.2) lib/tiny_tds/client.rb:60:in 'initialize'
If I look at the username of the opts being passed to
"Unable Adaptive Server connection failed (servername.database.secure.windows.net:1433)"
tiny_tds (2.1.2) lib/tiny_tds/client.rb:60:in 'connect'
tiny_tds (2.1.2) lib/tiny_tds/client.rb:60:in 'initialize'
If I look at the username of the opts being passed to
connect is has the wrong username. There was an @server automatically appended to it. I don't know if that is what the problem might be?
Please help. I've been stuck on this for dayyyyssss
Hello I'm trying to connect to a Sql Server that is on a remote windows server, using ruby. I've tried using the gem tiny_tds, but I keep getting a
connect server name not founderror. I'm thinking this is just for connecting to a local sql server, and not one that is on a completely different machine. Can anyone point me in the right direction?
Perhaps I'm missing something, is there a way to define an Identity column that is not a primary key?
I am working with a legacy database which has some non-PK identity columns. When a performed a schema dump against our development database nothing seems to indicate that these columns are to be auto incremented.
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
And is @metaskills around?
it works fine, no?
so still cimplains
I mean it still complains about being incompatible with ruby 2.6
