Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2012 Forums
 Transact-SQL (2012)
 JDBC connection issue with multiple DBs on same in

Author  Topic 

mgreen84
Yak Posting Veteran

94 Posts

Posted - 2014-05-27 : 14:46:17
I have two databases on one sql server 2012 instance. One called 'demotime' the other called 'demotime_dev'. how ever when I change in my JDBC connection the DB from demotime to demotime_dev. the connection still remains established with the demotime, is there any known reason to cause this? does both being on the same instance have anything to do with the problem?

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2014-05-27 : 14:48:37
When you make the connection change, did you close the app down first?

Tara Kizer
SQL Server MVP since 2007
http://weblogs.sqlteam.com/tarad/
Go to Top of Page

mgreen84
Yak Posting Veteran

94 Posts

Posted - 2014-05-27 : 15:40:14
Yup even restarted web server
quote:
Originally posted by tkizer

When you make the connection change, did you close the app down first?

Tara Kizer
SQL Server MVP since 2007
http://weblogs.sqlteam.com/tarad/

Go to Top of Page

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2014-05-27 : 16:01:30
It seems to me that the app has a bug then where it is leaving connections open.

Tara Kizer
SQL Server MVP since 2007
http://weblogs.sqlteam.com/tarad/
Go to Top of Page
   

- Advertisement -