hi,
I am new to appfuse. I am trying to setup appfuse to run with hsqldb so
that i can easly deploy my apps with the concern of db server for the
development time being. however, I encounterred error:
I also followed the notes written by Matt on wiki, but without any
success. pls help!
http://raibledesigns.com/wiki/Wiki.jsp?page=AppFuseWithHSQLDB
-----MY ERROR MESSAGE ---
$ant setup
Buildfile: build.xml
init:
db-create:
[echo] WARNING:
[echo] You selected a 'hsql' database which
[echo] does NOT support creating a database via JDBC.
[echo] Please create a 'myapp' database manually
[echo] and then run "ant db-prepare" to create the
[echo] database tables. You might want to check the
[echo] metadata/sql directory to see if the file
[echo] 'hsql-create.sql' exists.
clean:
[echo] Cleaning build and distribution directories
[delete] Deleting directory /Users/manchi/Java/myapp/build
[delete] Deleting directory /Users/manchi/Java/myapp/dist
prepare:
[echo] Preparing target directory '/Users/manchi/Java/myapp/build/myapp'
[mkdir] Created dir: /Users/manchi/Java/myapp/build/myapp
[mkdir] Created dir: /Users/manchi/Java/myapp/build/myapp/WEB-INF
[mkdir] Created dir: /Users/manchi/Java/myapp/dist/webapps
hibernatedoclet:
[hibernatedoclet] (XDocletMain.start 48 ) Running
<hibernate/>
[hibernatedoclet] (TemplateSubTask.engineStarted 829 ) Generating
output 'com/rosonix/model/Role.hbm.xml' using template file
'jar:file:/Users/manchi/Java/myapp/lib/x
doclet-1.3-SNAPSHOT/xdoclet-hibernate-module-1.3-SNAPSHOT.jar!/xdoclet/modules/hibernate/resources/hibernate.xdt'.
[hibernatedoclet]
com.rosonix.model.Role
[hibernatedoclet] (TemplateSubTask.engineStarted 829 ) Generating
output 'com/rosonix/model/User.hbm.xml' using template file
'jar:file:/Users/manchi/Java/myapp/lib/x
doclet-1.3-SNAPSHOT/xdoclet-hibernate-module-1.3-SNAPSHOT.jar!/xdoclet/modules/hibernate/resources/hibernate.xdt'.
[hibernatedoclet]
com.rosonix.model.User
compile-dao:
[echo] Compiling dao...
[mkdir] Created dir: /Users/manchi/Java/myapp/build/dao/classes
[mkdir] Created dir: /Users/manchi/Java/myapp/build/test/dao/classes
[javac] Compiling 14 source files to
/Users/manchi/Java/myapp/build/dao/classes
[javac] Note:
/Users/manchi/Java/myapp/src/dao/com/rosonix/model/User.java uses
unchecked or unsafe operations.
[javac] Note: Recompile with -Xlint:unchecked for details.
[javac] Compiling 5 source files to
/Users/manchi/Java/myapp/build/test/dao/classes
[javac] Note:
/Users/manchi/Java/myapp/test/dao/com/rosonix/dao/BaseDaoTestCase.java
uses unchecked or unsafe operations.
[javac] Note: Recompile with -Xlint:unchecked for details.
package-dao:
[mkdir] Created dir: /Users/manchi/Java/myapp/build/dao/gen/META-INF
[copy] Copying 1 file to /Users/manchi/Java/myapp/build/dao/gen/META-INF
[jar] Building jar: /Users/manchi/Java/myapp/dist/myapp-dao.jar
db-prepare:
[echo] generating database.properties from build.properties
[propertyfile] Creating new property file:
/Users/manchi/Java/myapp/database.properties
[schemaexport] (cfg.Environment 500 ) Hibernate 3.2.0
[schemaexport] (cfg.Environment 533 )
hibernate.properties not found
[schemaexport] (cfg.Environment 667 ) Bytecode
provider name : cglib
[schemaexport] (cfg.Environment 584 ) using JDK 1.4
java.sql.Timestamp handling
[schemaexport] (cfg.Configuration 274 ) Reading
mappings from file:
/Users/manchi/Java/myapp/build/dao/gen/com/rosonix/model/Role.hbm.xml
[schemaexport] (cfg.HbmBinder 300 ) Mapping
class: com.rosonix.model.Role -> role
[schemaexport] (cfg.Configuration 274 ) Reading
mappings from file:
/Users/manchi/Java/myapp/build/dao/gen/com/rosonix/model/User.hbm.xml
[schemaexport] (cfg.HbmBinder 300 ) Mapping
class: com.rosonix.model.User -> app_user
[schemaexport] (cfg.HbmBinder 1412) Mapping
collection: com.rosonix.model.User.roles -> user_role
[schemaexport] (dialect.Dialect 141 ) Using
dialect: org.hibernate.dialect.HSQLDialect
[schemaexport] (hbm2ddl.SchemaExport 154 ) Running
hbm2ddl schema export
[schemaexport] (hbm2ddl.SchemaExport 174 ) writing
generated schema to file: /Users/manchi/Java/myapp/create-tables.sql
[schemaexport] (hbm2ddl.SchemaExport 179 ) exporting
generated schema to database
[schemaexport] (connection.DriverManagerConnectionProvider 41 ) Using
Hibernate built-in connection pool (not for production use!)
[schemaexport] (connection.DriverManagerConnectionProvider 42 )
Hibernate connection pool size: 20
[schemaexport] (connection.DriverManagerConnectionProvider 45 )
autocommit mode: false
[schemaexport] (connection.DriverManagerConnectionProvider 80 ) using
driver: org.hsqldb.jdbcDriver at URL: jdbc:hsqldb:hsql://localhost/myapp
[schemaexport] (connection.DriverManagerConnectionProvider 86 )
connection properties: {user=sa, password=****, show_sql=true}
[schemaexport] (hbm2ddl.SchemaExport 202 ) schema export
unsuccessful
[schemaexport] java.sql.SQLException: socket creation error
[schemaexport] at org.hsqldb.jdbc.Util.sqlException(Unknown Source)
[schemaexport] at org.hsqldb.jdbc.jdbcConnection.<init>(Unknown Source)
[schemaexport] at org.hsqldb.jdbcDriver.getConnection(Unknown Source)
[schemaexport] at org.hsqldb.jdbcDriver.connect(Unknown Source)
[schemaexport] at java.sql.DriverManager.getConnection(DriverManager.java:525)
[schemaexport] at java.sql.DriverManager.getConnection(DriverManager.java:140)
[schemaexport] at
org.hibernate.connection.DriverManagerConnectionProvider.getConnection(DriverManagerConnectionProvider.java:110)
[schemaexport]
at
org.hibernate.tool.hbm2ddl.ManagedProviderConnectionHelper.prepare(ManagedProviderConnectionHelper.java:28)
[schemaexport]
at org.hibernate.tool.hbm2ddl.SchemaExport.execute(SchemaExport.java:180)
[schemaexport] at
org.hibernate.tool.hbm2ddl.SchemaExportTask.execute(SchemaExportTask.java:146)
[schemaexport]
at org.apache.tools.ant.UnknownElement.execute(UnknownElement.java:275)
[schemaexport] at org.apache.tools.ant.Task.perform(Task.java:364)
[schemaexport] at org.apache.tools.ant.Target.execute(Target.java:341)
[schemaexport] at org.apache.tools.ant.Target.performTasks(Target.java:369)
[schemaexport] at
org.apache.tools.ant.Project.executeSortedTargets(Project.java:1216)
[schemaexport] at
org.apache.tools.ant.Project.executeTarget(Project.java:1185)
[schemaexport] at
org.apache.tools.ant.helper.DefaultExecutor.executeTargets(DefaultExecutor.java:40)
[schemaexport]
at org.apache.tools.ant.Project.executeTargets(Project.java:1068)
[schemaexport] at org.apache.tools.ant.Main.runBuild(Main.java:668)
[schemaexport] at org.apache.tools.ant.Main.startAnt(Main.java:187)
[schemaexport] at org.apache.tools.ant.launch.Launcher.run(Launcher.java:246)
[schemaexport] at org.apache.tools.ant.launch.Launcher.main(Launcher.java:67)
db-load:
BUILD FAILED
/Users/manchi/Java/myapp/build.xml:689: java.sql.SQLException: socket
creation error
