The name of the driver class for the datasource is missing (Netbeans+ PostgreSql + Glassfish)
Apologies for being straightforward, but I believe that on this specific situation, you are all wrong. What should be done is:
- Go to your Glassfish server administration panel (Link should look like this: http://localhost:4848/common/index.jsf (Under Additional Properties tab)
- Click on Services in Netbeans
- Click on Server
- Right-click on your server name [A pop-up contextual menu appears]
- Click on View Domain Admin Console [Note: Your server must be running in order to see that feature. A browser tab is automatically launched, if the server is running. You know that your server is running if you see a greenish arrow pointing to the right on the right of the server instance]
- Click on resources
- Click on JDBC
- Click on JDBC Connection Pools
Add the following properties by clicking every time on the button Add Property (After selecting the pool name and editing it):
- driverClass: com.mysql.jdbc.Driver
- URL : jdbc:mysql://localhost/your_database_name
- password : your_password to the database management system
- serverName : localhost or your_server_name
- user : root or your_username to access the database management system
- databaseName : your_database_name
Set up your JDBC Resources [jdbc/your_pool_name]
- Point to the specific connection pool you just setup by selecting it in the drop down box.
Save everything (The button usually is on the upper-right corner of your Internet browser) Don't forget that the JDBC Resources is always connected to a connection pool. So ensure that it is the case for you. They, JDBC Connection Pools and JDBC Resources, are usually located under JDBC in the left pane menu of your server administration panel. Go back to whatever you were doing, and try again. Please also note that this works for MySQL Database Management Systems. You might need to change the driver class as well as the URL if using another DBMS. You may find additional information on YouTube [http://www.youtube.com/].
I believe this is the answer.
For me the issue was that I had added a new JDBC driver JAR file to Glassfish, but I hadn't added it to NetBeans.
The first step is to copy your JAR file to NetBean's EXT folder. For me, that folder is: "C:\Program Files\NetBeans 8.0.1\ide\modules\ext"
Next, we need to add the JDBC driver as described below:
- In NetBeans, select Window > Services menu option which adds the Services tab to the explorer panel.
- Expand the "Database" tree node
- Right click on the "Drivers" tree node and select "New Driver..."
- In the "New JDBC Driver" window press "Add..." which opens a dialog that says "Select Driver".
- Navigate to the EXT folder where you copied your JAR file and select the JAR file.
- Press OK.
- The new driver will be added to the list.
When I attempted to create an "Entity class from database", I still ran into issues when I selected my connection. After trying various things what worked for me was to:
- Open the Database tree node again and delete each of the database connections.
- Return to the Projects tabs and go through the steps to create an "Entity class from database".
- When the dialog appears, in the drop down select "New Data Source".
- Select the driver and then enter the information for your database.
- After recreating the connection I was able to create the Entity class from the selected database table.
Good luck!