Raible's Wiki: AppFuseWithSQLServer

-       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
Articles
Articles_de
Articles_pt



    




   



   
   JSPWiki v2.2.33 
   



       
           

           

           
           
           


           Hide Menu
+            AppFuseWithSQLServer
            



  
    Search Wiki:
    
    
  



         
         
            Your trail: 
         
      

      


      

      
         



      
          Difference between 
          version 2 
          and 
          version 1:
          

          
At line 1 added 48 lines.
!!__2005.07.27__ - AppFuse 1.8 with Microsoft SQLServer 2000

!1] download JDTS jar
http://jasigch.princeton
edu:9000/display/UPC/MSSQL+with+the+JTDS+JDBC+Driver
and copy them to "lib/jdts" directory

!2] Add this to "lib/lib.properties"
#
# MS SQL SERVER
#
http://jasigch.princeton
edu:9000/display/UPC/MSSQL+with+the+JTDS+JDBC+Driver
#
#
mssql.version=1.1
mssql.dir=${lib.dir}/jtds
mssql.jar=${mssql.dir}/jtds-${mssql.version}.jar

!3] in "properties.xml" change this lines:
<!-- Defaults for database.properties -->
<property name="database.jar" location="${mssql.jar}"/>
<property name="database.type" value="jtds:sqlserver"/>
<property name="database.name" value="appfuse"/>
<property name="database.host" value="localhost"/>
<property name="database.username" value="sa"/>
<property name="database.password" value="password"/>

<!-- database URL for creating other dbs - used in db-create target -->
<!--pro MSSQL nelze vytvorit databazi -->
<property name="database.admin.url"
value="jdbc:${database.type}://${database.host}/appfuse"/>
<property name="database.admin.username" value="sa"/>
<property name="database.admin.password" value="password"/>
<property name="hibernate.dialect"
value="org.hibernate.dialect.SybaseDialect"/>
<property name="database.driver_class"
value="net.sourceforge.jtds.jdbc.Driver"/>
<property name="database.url"
value="jdbc:${database.type}://${database.host}:1433/appfuse"/>
<property name="database.show_sql" value="true"/>

4] in build.xml change
<property name="operation" value="CLEAN_INSERT"/>
to
<property name="operation" value="MSSQL_CLEAN_INSERT"/> 




          

      

      

      
      Back to AppFuseWithSQLServer,
       or to the Page History.
       

      

      

      

      

      

      

      

      Show Menu
-AppFuseWithSQLServer
+    Search Wiki:
 At line 1 added 48 lines.
+!!__2005.07.27__ - AppFuse 1.8 with Microsoft SQLServer 2000
+!1] download JDTS jar
+http://jasigch.princeton
+edu:9000/display/UPC/MSSQL+with+the+JTDS+JDBC+Driver
+and copy them to "lib/jdts" directory
+!2] Add this to "lib/lib.properties"
+#
+# MS SQL SERVER
+#
+http://jasigch.princeton
+edu:9000/display/UPC/MSSQL+with+the+JTDS+JDBC+Driver
+#
+#
+mssql.version=1.1
+mssql.dir=${lib.dir}/jtds
+mssql.jar=${mssql.dir}/jtds-${mssql.version}.jar
+!3] in "properties.xml" change this lines:
+<!-- Defaults for database.properties -->
+<property name="database.jar" location="${mssql.jar}"/>
+<property name="database.type" value="jtds:sqlserver"/>
+<property name="database.name" value="appfuse"/>
+<property name="database.host" value="localhost"/>
+<property name="database.username" value="sa"/>
+<property name="database.password" value="password"/>
+<!-- database URL for creating other dbs - used in db-create target -->
+<!--pro MSSQL nelze vytvorit databazi -->
+<property name="database.admin.url"
+value="jdbc:${database.type}://${database.host}/appfuse"/>
+<property name="database.admin.username" value="sa"/>
+<property name="database.admin.password" value="password"/>
+<property name="hibernate.dialect"
+value="org.hibernate.dialect.SybaseDialect"/>
+<property name="database.driver_class"
+value="net.sourceforge.jtds.jdbc.Driver"/>
+<property name="database.url"
+value="jdbc:${database.type}://${database.host}:1433/appfuse"/>
+<property name="database.show_sql" value="true"/>
+] in build.xml change
+<property name="operation" value="CLEAN_INSERT"/>
+to
+<property name="operation" value="MSSQL_CLEAN_INSERT"/>