geronimo-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Man-Chi Leung <manchi.leung+n...@gmail.com>
Subject Unable to setup hsqldb for "ant setup". pls help
Date Mon, 30 Oct 2006 07:02:16 GMT
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



Mime
View raw message