JBossDeveloper

I see. Well, I guess this is not my lucky day... after changing the connection url to:

jdbc:hsqldb:hsql://localhost/blogjpa

I get the following exception:

(and yes, the DB is up and running, when it's not I get an error for not being able to open the socket. And, it's not empty, but the create-drop should take care of that)

12:11:15,328 WARN [LocalTxDataSource] Throwable while attempting to get a new connection: null
org.jboss.resource.JBossResourceException: Could not create connection; - nested
 throwable: (java.sql.SQLException: Connection is broken: Transfer corrupted)
 at org.jboss.resource.adapter.jdbc.local.LocalManagedConnectionFactory.c
reateManagedConnection(LocalManagedConnectionFactory.java:164)
 at org.jboss.resource.connectionmanager.InternalManagedConnectionPool.cr
eateConnectionEventListener(InternalManagedConnectionPool.java:519)
 at org.jboss.resource.connectionmanager.InternalManagedConnectionPool.ge
tConnection(InternalManagedConnectionPool.java:208)
 at org.jboss.resource.connectionmanager.JBossManagedConnectionPool$BaseP
ool.getConnection(JBossManagedConnectionPool.java:529)
 at org.jboss.resource.connectionmanager.BaseConnectionManager2.getManage
dConnection(BaseConnectionManager2.java:412)
 at org.jboss.resource.connectionmanager.TxConnectionManager.

... et cetera

I have no idea what hsqldb.jar(s) you deploy, so I can't help you with that. Maybe just a file search would help...

I found the hsqldb.jar in the lib/mc directory, missed it the first time around. Replaced it with 'my' hsqldb.jar and now it finally works. I'm still getting a nullpointer on the injected EntityManager, but I'll debug a bit more before asking about it :-)

Once again, thanks for your kind and patient answers. You guys are the best!