Search code examples
jdbcnullpointerexceptionglassfishadminconnection-pooling

Cannot create a JDBC Resource or Connection Pool


I have recently installed GlassFish v4.1.1 on my computer (Windows 8.1).

When I execute my GlassFish Server and enter in the administration webpage(http://localhost:4848/common/index.jsf from the NetBeans project), I obtain:

Admin webpage

When, when I press the button "Create New JDBC Resource" or "Create new JDBC Connection Pool" the following error appears:

error

I really do not understand what is going on. Could you help me please ?

Thank you so much for your help.


Solution

  • I'm facing the same issue and I found a solution: instead of creating the connection pool using my IDE (Netbeans), I used the command line:

    My DB username is root with an empty password and I'm working on my localhost. My table is named tmpDb and the pool myPool3.

    Here is the used command

    $> cd "c:\Program Files\glassfish4\bin"
    $> asadmin create-jdbc-connection-pool --restype  javax.sql.DataSource --datasourceclassname org.apache.derby.jdbc.ClientDataSource --validationmethod table --validationtable DUAL --property User=root:Password="":ServerName=localhost:tmpDb --ping true myPool3
    

    Does this work for you?