#950
  • Created on
    2011-03-26 15:04
  • Reported by
    ebiggs
  • Status
    Accepted
  • Priority
    Normal (3)
  • Assigned to
    David Whittaker
  • Milestone
    2.5-M1
  • Plan Level
    -
  • Due Date
    -

Attachments

Related Tickets

Add new subtask or bug

Connections unexpectedly closed when using DB.use with a JNDI datasource with squerylrecord

Per this discussion, the database connection is often (if not mostly) unexpectedly closed when attempting to use squerylrecord with DB.use and a JNDI DataSource.

To reproduce:

a) Configure a JNDI DataSource in your servlet container.

b) Then in Boot.scala:

1) tell the DefaultConnectionIdentifier the appropriate jndi name.
2) call SquerylRecord.init() with the appropriate adapter.
3) use DefaultConnectionIdentifier with the DB.buildLoanWrapper and
add it to S.around

c) Use squerylrecord in such a way that it requires a Connection to the DataSource

Tests should immediately reveal that the connections squeryl tries to use are unexpectedly closed.
User picture
  on 2011-03-26 15:05 *
By ebiggs
Description changed from [[url:http://groups.google.... to [[url:http://groups.google....
User picture
  on 2011-05-04 14:41 *
By David Whittaker
Milestone set to 2.4-M1
Status changed from New to Accepted
Sorry for not updating this sooner. I have been able to reproduce the issue with your test case, thanks for that. I'm planning on getting this fixed for 2.4, I just haven't had time for the deeper dive into DB and Squeryl's external transaction management that it will require. Hopefully I've have more for you soon.
User picture
  on 2011-05-18 20:18 *
By dpp
Milestone changed from 2.4-M1 to 2.4-M2
User picture
  on 2011-07-20 11:55 *
By Indrajit Raychaudhuri
Milestone changed from 2.4-M3 to 2.4-M4
Updating tickets (#919, #938, #950, #956, #976, #980, #982, #999, #1008, #1024, #1025, #1032, #1034, #1051)
User picture
  on 2011-09-08 13:19 *
By Indrajit Raychaudhuri
Milestone changed from 2.4-M4 to 2.4-M5
Updating tickets (#950, #956, #976, #980, #982, #999, #1008, #1053, #1078, #1092, #1097)

Pushed pending tickets to 2.4-M5
User picture
  on 2011-09-30 22:31 *
By David Whittaker
Milestone changed from 2.4-M5 to 2.5
User picture
  on 2011-12-22 05:38 *
By Indrajit Raychaudhuri
Milestone changed from 2.4-RC1 to 2.5-M1
Updating tickets (#906, #950, #956, #960, #976, #980, #982, #997, #999, #1008, #1053, #1078, #1090, #1092, #1097, #1128, #1134, #1155, #1168)