• Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

Having to create a connection again after closing ResultSet In MYSQL (no Issue In MSSQL)

 
Nikolas Nikolaou
Ranch Hand
Posts: 101
1
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Hi. I have a small database app that was connecting to a MSSQL database.
I've modified It to work with a MYSQL database but I'm not sure why I have to create the connection again after
closing a ResultSet with MYSQL.

I could use the .setCatalog method Immediately after closing the ResultSet with the MSSQL connection but I'm
not sure why I can't do the same with MYSQL.
I'd Just like to get a better understanding of what's going on.





 
Nikolas Nikolaou
Ranch Hand
Posts: 101
1
  • Likes 1
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Sorry , Just a syntax error I made.
It's working now. I'll mark as resolved because I can't see a delete option.
 
Roel De Nijs
Sheriff
Posts: 10662
144
AngularJS Chrome Eclipse IDE Hibernate Java jQuery MySQL Database Spring Tomcat Server
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Thanks for coming back and sharing your solution. Have a cow!
 
Nikolas Nikolaou
Ranch Hand
Posts: 101
1
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Cow-abunga ! I mean thanks !
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic