You are viewing a plain text version of this content. The canonical link for it is here.
Posted to user@geronimo.apache.org by Man-Chi Leung <ma...@gmail.com> on 2006/10/30 08:02:16 UTC
Unable to setup hsqldb for "ant setup". pls help
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
Re: Unable to setup hsqldb for "ant setup". pls help
Posted by Peter Petersson <pe...@pmb.mine.nu>.
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
>
>