Hi Man-Chi
I dont know anyting about appfuse but the error message
[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.
is probably the (first) reasson your installation fales.
You need to creat the database manually and then let the ant script
build the tables for you (with 'ant db-prepare').
/Peter
Man-Chi Leung skrev:
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
