AppFuce + MSSQL

  1. Lib \ lib.properties add the following code 

#
  # MS SQL SERVER 
  # Http://jasigch.princeton.edu:9000/display/UPC/MSSQL + with + the + JTDS + JDBC + Driver 
#
  mssql.version = 1.2 
  mssql.dir = $ (lib.dir) / jtds-$ (mssql.version) 
  mssql.jar = $ (mssql.dir) / jtds-$ (mssql.version). jar 

  2. Properties.xml file amended the following line 

  <! – Defaults for database.properties -> 
  <property name="database.jar" location="${mssql.jar}"/> 
  <property name="database.type" value="jtds:sqlserver"/> 
  <property name="database.name" value="zyfDb"/> 
  <property name="database.host" value="Ewzyf"/> 
  <property name="database.username" value="sa"/> 
  <property name="database.password" value="123456"/> 

  <! – Database URL for creating other dbs – used in db-create target jdbc: microsoft: sqlserver: / / localhost: 1433; -> 
  <property name="database.admin.url" value="jdbc:${database.type}://${database.host}/zyfDb"/> 
  <property name="database.admin.username" value="sa"/> 
  <property name="database.admin.password" value="123456"/> 
  <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/zyfDb" /> 
  <property name="database.show_sql" value="true"/> 

  3. Build.xml will be in 

  <property name="operation" value="CLEAN_INSERT"/> to 

  <property name="operation" value="MSSQL_CLEAN_INSERT"/> 

Share and Enjoy: These icons link to social bookmarking sites where readers can share and discover new web pages.
  • Digg
  • Sphinn
  • del.icio.us
  • Facebook
  • Google
  • DZone
  • Netvouz
  • NewsVine
  • Technorati

You can follow any responses to this entry through the RSS 2.0 feed. You can leave a response, or trackback from your own site.

AddThis Social Bookmark Button

Tags: