Raible's Wiki: AppFuseWithHSQLDB

-       Raible's Wiki




    Raible Designs

Wiki Home

News

Recent Changes

AppFuse
Homepage

  -  Korean

  -  Chinese

  -  Italian

  -  Japanese

QuickStart Guide

  - Chinese
 
  - French

  - German

  - Italian

  - Korean

  - Portuguese

  - Spanish

  - Japanese


User Guide

  - Korean

  - Chinese
 

Tutorials

  -  Chinese

  -  German

  -  Italian

  -  Korean

  -  Portuguese

  -  Spanish


FAQ

  -  Korean


Latest Downloads

Other Applications
Struts Resume

Security Example

Struts Menu



    




    

    
         
        Set your name in

        UserPreferences
            
    





       
       
       
       




    

Referenced by

AppFuseSupport



    




   



   
   JSPWiki v2.2.33 
   



       
           

           

           
           
           


           Hide Menu
+            AppFuseWithHSQLDB
            



  
    Search Wiki:
    
    
  



         
         
            Your trail: 
         
      

      


      

      
         



      
          Difference between 
          version 4 
          and 
          version 3:
          

          
At line 17 added 2 lines.
[Download HSQLDB|http://sourceforge.net/project/showfiles.php?group_id=23316&amp;release_id=254279] from SourceForge.  Create a lib/hsqldb-1.7.2 directory and put hsqldb.jar in this directory.

At line 21 added 11 lines.
Open lib/lib.properties and add the following entry:

{{{
#
# HSQLDB - http://hsqldb.sourceforge.net
#
hsqldb.version		= 1.7.2
hsqldb.dir=${lib.dir}/hsqldb-${hsqldb.version}
hsqldb.jar=${hsqldb.dir}/hsqldb.jar
}}}

At line 34 added 15 lines.
Uncomment the database entries in build.properties and use the following settings (or just copy/paste these).

{{{
database.jar=${hsqldb.jar}
database.type=hsql
database.name=appfuse
database.host=localhost

hibernate.dialect=net.sf.hibernate.dialect.HSQLDialect
database.driver_class=org.hsqldb.jdbcDriver
database.url=jdbc:hsqldb:${database.type}://${database.host}/${database.name}
database.username=sa
database.password=
}}}

At line 51 added 1 line.
HSQLDB doesn't ship with a way to start and run it as a service.  However, there is a way to configure HSQLDB to [run as a service|http://www.waldhor.com/hsql.htm].  Following these instructions, you can install an HSQL service running the "appfuse" database.  Just [download the hsql.exe and hsql_service_install.bat|http://www.waldhor.com/hsql.zip] and change the hsql_service_install.bat to contain the following.  The setttings below assume you've extracted the hsqldb download to c:\Tools\hsqldb and that you've install the downloaded files into the same directory.
At line 24 changed 1 line.
Start HSQLDB as a service: http://www.waldhor.com/hsql.htm
{{{
net stop HSQLService
hsql.exe -uninstall HSQLService
set EAGLE_MEMEX_BIN=c:/tools/hsqldb/lib
set DATABASE=c:/tools/hsqldb/data/appfuse
set CURRENTDIR=c:/tools/hsqldb/data
hsql.exe -install HSQLService "%JAVA_HOME%\jre\bin\server\jvm.dll" -jvm_option -Xms128m -Xmx128m -Djava.class.path=".;%EAGLE_MEMEX_BIN%\hsqldb.jar" -jvm_option -Dsystem.drive="c:" -start org.hsqldb.Server -params -database.0 %DATABASE% -dbname.0 appfuse -current "% CURRENTDIR%" -out "%CURRENTDIR%/service.out" -err "%CURRENTDIR%/service.err"
net start HSQLService}}}

Another option is to simply create script (i.e. run-hsqldb.bat) in your project's directory that you can use to start HSQLDB.
{{{
java -cp lib/hsqldb-1.7.2/hsqldb.jar org.hsqldb.Server -database.0 c:/temp/appfuse-db -dbname.0 appfuse
}}}



          

      

      

      
      Back to AppFuseWithHSQLDB,
       or to the Page History.
       

      

      

      

      

      

      

      

      Show Menu
-AppFuseWithHSQLDB
+    Search Wiki:
 At line 17 added 2 lines.
+[Download HSQLDB|http://sourceforge.net/project/showfiles.php?group_id=23316&amp;release_id=254279] from SourceForge.  Create a lib/hsqldb-1.7.2 directory and put hsqldb.jar in this directory.
 At line 21 added 11 lines.
+Open lib/lib.properties and add the following entry:
+{{{
+#
+# HSQLDB - http://hsqldb.sourceforge.net
+#
+hsqldb.version		= 1.7.2
+hsqldb.dir=${lib.dir}/hsqldb-${hsqldb.version}
+hsqldb.jar=${hsqldb.dir}/hsqldb.jar
+}}}
 At line 34 added 15 lines.
+Uncomment the database entries in build.properties and use the following settings (or just copy/paste these).
+{{{
+database.jar=${hsqldb.jar}
+database.type=hsql
+database.name=appfuse
+database.host=localhost
+hibernate.dialect=net.sf.hibernate.dialect.HSQLDialect
+database.driver_class=org.hsqldb.jdbcDriver
+database.url=jdbc:hsqldb:${database.type}://${database.host}/${database.name}
+database.username=sa
+database.password=
+}}}
 At line 51 added 1 line.
+HSQLDB doesn't ship with a way to start and run it as a service.  However, there is a way to configure HSQLDB to [run as a service|http://www.waldhor.com/hsql.htm].  Following these instructions, you can install an HSQL service running the "appfuse" database.  Just [download the hsql.exe and hsql_service_install.bat|http://www.waldhor.com/hsql.zip] and change the hsql_service_install.bat to contain the following.  The setttings below assume you've extracted the hsqldb download to c:\Tools\hsqldb and that you've install the downloaded files into the same directory.
 At line 24 changed 1 line.
-Start HSQLDB as a service: http://www.waldhor.com/hsql.htm
+{{{
+net stop HSQLService
+hsql.exe -uninstall HSQLService
+set EAGLE_MEMEX_BIN=c:/tools/hsqldb/lib
+set DATABASE=c:/tools/hsqldb/data/appfuse
+set CURRENTDIR=c:/tools/hsqldb/data
+hsql.exe -install HSQLService "%JAVA_HOME%\jre\bin\server\jvm.dll" -jvm_option -Xms128m -Xmx128m -Djava.class.path=".;%EAGLE_MEMEX_BIN%\hsqldb.jar" -jvm_option -Dsystem.drive="c:" -start org.hsqldb.Server -params -database.0 %DATABASE% -dbname.0 appfuse -current "% CURRENTDIR%" -out "%CURRENTDIR%/service.out" -err "%CURRENTDIR%/service.err"
+net start HSQLService}}}
+Another option is to simply create script (i.e. run-hsqldb.bat) in your project's directory that you can use to start HSQLDB.
+{{{
+java -cp lib/hsqldb-1.7.2/hsqldb.jar org.hsqldb.Server -database.0 c:/temp/appfuse-db -dbname.0 appfuse
+}}}