geronimo-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Peter Petersson <pe...@pmb.mine.nu>
Subject Re: Unable to setup hsqldb for "ant setup". pls help
Date Tue, 31 Oct 2006 09:34:05 GMT
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
>
>

Mime
View raw message