Issue deploying .par file

[paz]

Hello,

I am using the build.deploy.xml. I am trying to use the ant task to deploy a process. The websale.par included in the starters kit. I have verified the start.jboss and other ant tasks and I have also verified the build.xml. When I get to deploy.processes I receive this error.

I am running the starters kit and have not modified any of the configurations. I have websale.par working fine with localhost. Everything is working great. I just cannot seem to deploy a process using ant. I would like to learn how so I can create my own processes. Am I missing something on my classpath? I have set jboss.home and my basedir.

Also, very clever C3PO..

Thanks again for the great support.

[deploypar] 10:16:56,902 DEBUG JbpmSessionFactory : using the default hibernate configuration file: hibernate.cfg.xml

Do I need to modify the hibernate.cfg.xml?

[deploypar] 10:17:00,152 INFO C3P0ConnectionProvider : C3P0 using driver: org.hsqldb.jdbcDriver at URL: jdbc:hsqldb:hsql://localhost:1701
[deploypar] 10:17:00,152 INFO C3P0ConnectionProvider : Connection properties: {user=sa, password=****}
[deploypar] 10:17:00,168 INFO C3P0ConnectionProvider : autocommit mode: false
[deploypar] Initializing c3p0 pool... com.mchange.v2.c3p0.PoolBackedDataSource@83b1b [ connectionPoolDataSource -> com.mchange.v2.c3p0.WrapperConnectionPoolDataSource@78aa80 [ acquireIncrement -> 1, acquireRetryAttempts -> 30, acquireRetryDelay -> 1000, autoCommitOnClose -> false, automaticTestTable -> null, breakAfterAcquireFailure -> false, checkoutTimeout -> 0, connectionTesterClassName -> com.mchange.v2.c3p0.impl.DefaultConnectionTester, factoryClassLocation -> null, forceIgnoreUnresolvedTransactions -> false, idleConnectionTestPeriod -> 0, initialPoolSize -> 1, maxIdleTime -> 0, maxPoolSize -> 3, maxStatements -> 0, maxStatementsPerConnection -> 0, minPoolSize -> 1, nestedDataSource -> com.mchange.v2.c3p0.DriverManagerDataSource@f892a4 [ description -> null, driverClass -> null, factoryClassLocation -> null, jdbcUrl -> jdbc:hsqldb:hsql://localhost:1701, properties -> {user=******, password=******} ] , preferredTestQuery -> null, propertyCycle -> 300, testConnectionOnCheckin -> false, testConnectionOnCheckout -> false, usesTraditionalReflectiveProxies -> false ] , factoryClassLocation -> null, numHelperThreads -> 3, poolOwnerIdentityToken -> 83b1b ]

Error...

[deploypar] java.sql.SQLException: socket creation error
[deploypar] at org.hsqldb.jdbc.Util.sqlException(Unknown Source)
[deploypar] at org.hsqldb.jdbc.jdbcConnection.(Unknown Source)
[deploypar] at org.hsqldb.jdbcDriver.getConnection(Unknown Source)
[deploypar] at org.hsqldb.jdbcDriver.connect(Unknown Source)
[deploypar] at com.mchange.v2.c3p0.DriverManagerDataSource.getConnection(DriverManagerDataSource.java:68)
[deploypar] at com.mchange.v2.c3p0.WrapperConnectionPoolDataSource.getPooledConnection(WrapperConnectionPoolDataSource.java:87)
[deploypar] at com.mchange.v2.c3p0.impl.C3P0PooledConnectionPool$1.acquireResource(C3P0PooledConnectionPool.java:83)
[deploypar] at com.mchange.v2.resourcepool.BasicResourcePool.assimilateResource(BasicResourcePool.java:884)
[deploypar] at com.mchange.v2.resourcepool.BasicResourcePool.acquireUntil(BasicResourcePool.java:601)
[deploypar] at com.mchange.v2.resourcepool.BasicResourcePool.access$400(BasicResourcePool.java:31)
[deploypar] at com.mchange.v2.resourcepool.BasicResourcePool$AcquireTask.run(BasicResourcePool.java:1079)
[deploypar] at com.mchange.v2.async.ThreadPoolAsynchronousRunner$PoolThread.run(ThreadPoolAsynchronousRunner.java:354)

[tom.baeyens]

the tcp/ip sockets of the hsqldb had to be closed because of a security issue.

if you want to deploy with ant task, you have to open up the tcp sockets of the hsqldb. but don't put such an instance on the internet, because of the security issue.

regards, tom.

[paz]

So make the changes to hsqldb-ds.xml. I will have this project on the intranet (inside firewall-no punching through)and I will go through and make the necessary port changes and secure the app-db server. Thanks for such a quick response. Very much appreciated.

Do I then uncomment "using tcp connections" these sections and then comment "in process persistent db" these sections or can I have both uncommented?

Thanks again Speedy Tom..and crew...