Discussions
Categories
- 382.2K All Categories
- 2.1K Data
- 208 Big Data Appliance
- 1.9K Data Science
- 447.9K Databases
- 220.9K General Database Discussions
- 3.7K Java and JavaScript in the Database
- 25 Multilingual Engine
- 521 MySQL Community Space
- 465 NoSQL Database
- 7.8K Oracle Database Express Edition (XE)
- 2.9K ORDS, SODA & JSON in the Database
- 489 SQLcl
- 3.9K SQL Developer Data Modeler
- 186.1K SQL & PL/SQL
- 21K SQL Developer
- 293.2K Development
- 7 Developer Projects
- 127 Programming Languages
- 289.9K Development Tools
- 96 DevOps
- 3K QA/Testing
- 645.6K Java
- 24 Java Learning Subscription
- 36.9K Database Connectivity
- 150 Java Community Process
- 104 Java 25
- 22.1K Java APIs
- 137.9K Java Development Tools
- 165.3K Java EE (Java Enterprise Edition)
- 16 Java Essentials
- 144 Java 8 Questions
- 85.9K Java Programming
- 79 Java Puzzle Ball
- 65.1K New To Java
- 1.7K Training / Learning / Certification
- 13.8K Java HotSpot Virtual Machine
- 94.2K Java SE
- 13.8K Java Security
- 198 Java User Groups
- 24 JavaScript - Nashorn
- Programs
- 260 LiveLabs
- 36 Workshops
- 10.2K Software
- 6.7K Berkeley DB Family
- 3.5K JHeadstart
- 5.8K Other Languages
- 2.3K Chinese
- 166 Deutsche Oracle Community
- 1.2K Español
- 1.9K Japanese
- 225 Portuguese
Configure DB connection timeouts
Is there a possibility to configure the connection timeout in SQL Developer (UI or programaticaly)
Best Answer
-
then yes you can mess with jdbc connection properties, but if you do that, it could impact say...the driver giving up queries that say also take longer than 2 minutes to complete
it's not simple journey you're about to take, so to speak
Answers
-
DB connection timeouts or client connection timeouts? Be specific on exactly what you're asking to configure.
-
For the client SQL Developer. We want to configure the timeout (make it less), so that for example if no db is available, the UI is not blocked with the connection dialog for about 2 minutes.
-
then yes you can mess with jdbc connection properties, but if you do that, it could impact say...the driver giving up queries that say also take longer than 2 minutes to complete
it's not simple journey you're about to take, so to speak