Getting "java.sql.SQLException: socket creation error"

[davidsan1001]

This happens when running "ant -f build.deploy.xml deploy.processes" in the jbpm folder

I'm thinking my "create.db.hibernate.propertes" file has a bad configuration. The default was:

hibernate.connection.username=sa
hibernate.connection.password=

Is the above causing my problem?
Should I change the above? If so, change it to what?
Also, is how can I test to see of the connection is happening correctly?

Dave

[kukeltje]

socket creation error has noting to do with a username/password, more with not getting a fysical connection to the db

[davidsan1001]

any tricks to getting a physical connection to the database?

Obviously I'm new to JBoss, jBPM and in-memory databases.

Dave

[davidsan1001]

Found the solution by manully starting Hypersonic at..

/jbpm-starters-kit-3.0.1/jbpm/lib/jboss/hsqldb.server.bat

[sanjeevt]

I ran into the same problem few days ago and resolved it by eliminating the version inconsistency between the hsqldb library that is part of jBoss server and the hsqldb library that was part of the jbpm-db database folder in the starter kit. The one in jbpm.db/hsqldb/ is 1.7.3.3 and the one in jbpm-server/server/jbpm/lib was 1.8.0.

[purvi.shah]

I have face same problem and tried to solve mention in last reply,but could not resolve.
I have installed startup kit 3.0.2.
Regards
Purvi