I am using the DBCP component of the Apache Commons library to connection to an Oracle database. I have created a BasicDataSource object and set the MaxWait time to two minutes. However when I call the "getConnection" method to get a connection it never returns or times out. I am try to connect to an Oracle 12.1.0.2 database. What could the cause of this be ? Thanks.
Java BasicDataSource getting stuck when connecting
459 Views Asked by lgriffin At
1
There are 1 best solutions below
Related Questions in JAVA
- I need the BIRT.war that is compatible with Java 17 and Tomcat 10
- Creating global Class holder
- No method found for class java.lang.String in Kafka
- Issue edit a jtable with a pictures
- getting error when trying to launch kotlin jar file that use supabase "java.lang.NoClassDefFoundError"
- Does the && (logical AND) operator have a higher precedence than || (logical OR) operator in Java?
- Mixed color rendering in a JTable
- HTTPS configuration in Spring Boot, server returning timeout
- How to use Layout to create textfields which dont increase in size?
- Function for making the code wait in javafx
- How to create beans of the same class for multiple template parameters in Spring
- How could you print a specific String from an array with the values of an array from a double array on the same line, using iteration to print all?
- org.telegram.telegrambots.meta.exceptions.TelegramApiException: Bot token and username can't be empty
- Accessing Secret Variables in Classic Pipelines through Java app in Azure DevOps
- Postgres && statement Error in Mybatis Mapper?
Related Questions in ORACLE
- sqlplus myusername/mypassword@ORCL not working with Oracle on Docker
- Oracle setting up on k8s cluster using helm charts enterprise edition
- Oracle Managed Data Access Client can't work from IIS but work for local debug environment
- If composite indexing created - indexing is called?
- Oracle Http server ISNT-07551
- why here not creating table?
- Data migration from Oracle Database Clob to GCP Bucket
- SQL Alchemy custom type, forcing blob bind parameter
- How to send message to syslog agent in plsql
- Whatever the data available in previous record it should add to the new record
- I have an Oracle SQL query that is giving me a "ORA-00918: column ambiguously defined" error on a line that is a comment line
- 'ORA-12170: TNS:Connect timeout occurredORA-12170: TNS:Connect timeout occurred' ERROR while working on oracle with laravel
- Is their any way i can open parallel query tabs
- VSCode Libraries not showing for New Java Project
- I can't ssh to my instance, Connection refused
Related Questions in COMMONJS
- how do I create code transformer for parsing customized extension like JSX?
- serverless-offline module --> Cannot use import statement outside a module
- TypeError: Cannot convert object to primitive value when trying to use template literal in require(`${some_var_string}`)
- How do you combine subpath exports, environment conditional exports, and module system conditional exports in the same package.json?
- Using TypeScript in Node.js project with "module": "commonjs"
- How to compile typescript to use CommonJS and import/export?
- How to build TypeScript/MJS package compatible with NodeJs?
- Trying to import KcAdminClient
- Cannot import ESM modules when modifying require.extensions
- Import ESM libraries into commonjs project Error [ERR_REQUIRE_ESM]: require() of ES Module -
- Exposed and private/local members in CommonJS modules
- require() of ES Module \node_modules\string-width\index.js from \node_modules\wide-align\align.js not supported
- Jest : SyntaxError: Cannot use import statement outside a module
- How to make default export compatible with CommonJS
- Testing CommonJS with dynamic imports of ESM with ts-jest
Related Questions in DBCP
- Cannot get a connection, pool error Timeout waiting for idle object while using DBPC2
- DBCP connection property name issue
- How should I connect my web app in java with the database? With jdbc coming from a jar file in referenced libraries or dbcp?
- SQL Server returned an incomplete response. The connection has been closed.; nested exception is com.microsoft.sqlserver.jdbc.SQLServerException:
- BasicDataSource Support domain name？
- how to reload password in dbcp basic datasource
- Java BasicDataSource getting stuck when connecting
- Connecting to Cassandra using Java DBCP
- Java and MariaDB connection drivers errors
- java connection pool and autocommit status
- Concurrency logging to sql DB - threads not running parallel
- Getting error on shutdown of simple Micronaut CLI data application
- setting connectionTimedOut to 1 sec is throwing Socket Timed Out error
- java dbcp2 multithreaded connection access
- Apache felix cannot load dbcp2 as bundle
Trending Questions
- UIImageView Frame Doesn't Reflect Constraints
- Is it possible to use adb commands to click on a view by finding its ID?
- How to create a new web character symbol recognizable by html/javascript?
- Why isn't my CSS3 animation smooth in Google Chrome (but very smooth on other browsers)?
- Heap Gives Page Fault
- Connect ffmpeg to Visual Studio 2008
- Both Object- and ValueAnimator jumps when Duration is set above API LvL 24
- How to avoid default initialization of objects in std::vector?
- second argument of the command line arguments in a format other than char** argv or char* argv[]
- How to improve efficiency of algorithm which generates next lexicographic permutation?
- Navigating to the another actvity app getting crash in android
- How to read the particular message format in android and store in sqlite database?
- Resetting inventory status after order is cancelled
- Efficiently compute powers of X in SSE/AVX
- Insert into an external database using ajax and php : POST 500 (Internal Server Error)
Popular # Hahtags
Popular Questions
- How do I undo the most recent local commits in Git?
- How can I remove a specific item from an array in JavaScript?
- How do I delete a Git branch locally and remotely?
- Find all files containing a specific text (string) on Linux?
- How do I revert a Git repository to a previous commit?
- How do I create an HTML button that acts like a link?
- How do I check out a remote Git branch?
- How do I force "git pull" to overwrite local files?
- How do I list all files of a directory?
- How to check whether a string contains a substring in JavaScript?
- How do I redirect to another webpage?
- How can I iterate over rows in a Pandas DataFrame?
- How do I convert a String to an int in Java?
- Does Python have a string 'contains' substring method?
- How do I check if a string contains a specific word?
There can be many reasons like: A firewall between the client and the server. A odbc driver that is too old to be accepted by the database. Incorrect connection details. Wrong driver. Using a database user that has no access.
Some kind of instrumentation can help.
First things to check: is the port open on the io that is used? Is a listener waiting there to handle my connection attempt? Next step is to check the connection with a client that is known to work: sqlplus. If the sqlplus connection works, your jdbc client also makes a chance.