Double check the following procedure:
For some reason you are pointing to a wrong DB or using wrong credentials.
thanks for your support, i've checked the procedure again and i've tested the connection from the Admin Console and it works correctly.
It seems not be a connection error.
Any other ideas?
I would try to connect to the DB using a java client (i.e. Squirrel) with the same driver and the same credentials.
- you can see the table
- you can insert/delete rows.
Yes, i'm logged on the DB using a SQLDeveloper and i see the tables.
In this way you are not sure that you are using exactly the same driver and same credentials.
Double check the credentials: if I recall correctly they are configured as JAAS alias in WAS.
Option 2: raise the JDBC logs level to TRACE
Option 3: write a servlet and place it in the same war to inquire the DB