jdbc-console | small webapp gives an ability to execute SQL
kandi X-RAY | jdbc-console Summary
kandi X-RAY | jdbc-console Summary
jdbc-console
Support
Quality
Security
License
Reuse
Top functions reviewed by kandi - BETA
- Initialize the servlet
- Extract data source from jndi
jdbc-console Key Features
jdbc-console Examples and Code Snippets
Community Discussions
Trending Discussions on jdbc-console
QUESTION
I'm trying to connect my database to my project (in PhpStorm), so that I have autocomplete.
Steps that I do to get the error :
- Open the database panel, and add a
MySQL DataSource
- Fill every field
- Click
TEST CONNECTION
button
I've filled correctly every field (host, database, user, password) in the Database feature
- Host:
s00vl9944624.fr.net.intra
- Database:
animationqrc
- User:
animationqrc
- URL (built by PhpStorm):
jdbc:mysql://s00vl9944624.fr.net.intra:3306/animationqrc
The error is :
java.rmi.ConnectException: Connection refused to host: 127.0.0.1; nested exception is: java.net.ConnectException: Connection timed out: connect
The problem is that, when I use myself a Java class that only tries to connect to the server and print rows from a table, it works.
...ANSWER
Answered 2018-Sep-20 at 16:11To summarize my comments, it seems that PhpStorm uses separate Java processes to isolate database access from the rest of the application. It looks like communication between these two processes (using RMI, Remote Method Invocation) is not possible.
This is possibly a firewall issue. Given you're using Windows, check the Windows Firewall settings under allowed apps config for the OpenJDK Platform Binary for your PhpStorm install (see its details, path should be C:\Users\b96297\AppData\Local\JetBrains\PhpStorm 2018.2.3\jre64\bin\java
in your case), and enable Private access (in some cases, you may need to try Public as well). This will allow the Java processes to communicate using RMI.
If you can't find the OpenJDK Platform Binary in the firewall configuration, add the java.exe
from the jre64\bin
folder of the PhpStorm install and configure it.
Community Discussions, Code Snippets contain sources that include Stack Exchange Network
Vulnerabilities
No vulnerabilities reported
Install jdbc-console
You can use jdbc-console like any standard Java library. Please include the the jar files in your classpath. You can also use any IDE and you can run and debug the jdbc-console component as you would do with any other Java program. Best practice is to use a build tool that supports dependency management such as Maven or Gradle. For Maven installation, please refer maven.apache.org. For Gradle installation, please refer gradle.org .
Support
Reuse Trending Solutions
Find, review, and download reusable Libraries, Code Snippets, Cloud APIs from over 650 million Knowledge Items
Find more librariesStay Updated
Subscribe to our newsletter for trending solutions and developer bootcamps
Share this Page