search

JesseChavez / activerecord-jdbc-adapter

SQL Server Adapter support on JRuby's ActiveRecord JDBC Adapter
BSD 2-Clause "Simplified" License
7 stars 5 forks source link

Recurring 'The connection is closed' error #12

Open JesseChavez opened 4 years ago

JesseChavez commented 4 years ago

This is mostly to document a bug that was showing up from time to time.

the error is

ActiveRecord::StatementInvalid: ActiveRecord::JDBCError: com.microsoft.sqlserver.jdbc.SQLServerException: The connection is closed.
    arjdbc/jdbc/RubyJdbcConnection.java:1144:in `execute_prepared_query'

This recurring bug was seen is Rails 5.2 and Rails 6.0 apps, the issue is fixed in the following versions of this adapter:

50.6.1, 51.6.1, 52.5.1 and the up coming 60.0.0

As a extra measure to avoid using the faulty versions I will be yanking the following gem versions:

50.x series:

50.5.1, 50.5.2 , and 50.6.0

51.x series:

51.5.1 and 51.6.0

52.x series:

52.4.1 and 52.5.0