Win a copy of Design for the Mind this week in the Design forum!
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

Post connection query

 
Ash Jose
Greenhorn
Posts: 7
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Hi,

I have defined a datasource to connect to Sybase DB. I need to run an authentication statement (SET TEMPORARY OPTION CONNECTION_AUTHENTICATION=....) after connection to keep the connection alive, else DB server will drop the connection after 10 seconds.

Is there a way to specify to run this in the connection parameters (DBCP params) so that all the connection in the pool have this authentication statement executed.

Thanks,
-ash
 
Wendy Gibbons
Bartender
Posts: 1110
Eclipse IDE Oracle VI Editor
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
and you can't set this in the connection url?
 
Ash Jose
Greenhorn
Posts: 7
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Wendy Gibbons wrote:and you can't set this in the connection url?


How do I set this in connection URL?
 
Wendy Gibbons
Bartender
Posts: 1110
Eclipse IDE Oracle VI Editor
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
alongside the username and password and other settings like schema you just pop in CONNECTION_AUTHENTICATION=xxx
worth a try;
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic