Project

General

Profile

« Previous | Next » 

Revision 1742

Added by Jing Tao over 21 years ago

add some new variables for JDBC in MSSQL.

View differences:

build.xml
30 30
  * Foundation, Inc., 59 Temple Place, Suite 330, Boston, MA  02111-1307  USA
31 31
-->
32 32
<project name="metacat" default="jar" basedir=".">
33

  
34
   <target name="oracle">
33
  <target name="oracle">
35 34
     <!-- Customize these properties if you are using oracle -->
36 35
     <property name="jdbc-connect"
37 36
               value="jdbc:oracle:thin:@dev.nceas.ucsb.edu:1521:exp"/>
......
54 53
   <target name="sqlserver">
55 54
     <!-- Customize these properties if you are using SQL server -->
56 55
     <property name="jdbc-connect"
57
               value="jdbc:microsoft:sqlserver://server_name:1433"/>
56
               value="jdbc:microsoft:sqlserver://fatali.nceas.ucsb.edu:1433"/>
58 57
     <property name="dbDriver" value="com.microsoft.jdbc.sqlserver.SQLServerDriver"/>
59 58
     <property name="dbAdapter"
60 59
               value="edu.ucsb.nceas.dbadapter.SqlserverAdapter"/>
61
     <property name="jdbc" value="lib/jdbc7.1-1.2.jar" />
60
     <property name="jdbc-base" value="F:\\Program Files\\Microsoft SQL Server 2000 Driver for JDBC\\lib" />
61
     <property name="jdbc" value="${jdbc-base}/msbase.jar" />
62
     <property name="msutil" value="${jdbc-base}/msutil.jar" />
63
     <property name="mssqlserver" value="${jdbc-base}/mssqlserver.jar" />
62 64
   </target>
63 65

  
64
   <target name="config" depends="postgresql">
66
   <target name="config" depends="sqlserver">
65 67
      <!-- Change the 'depends' attribute above to 'postgresql' to install
66 68
           metacat with postgres instead of oracle -->
67 69

  
68 70
      <!-- Customize these properties for your system -->
69
      <property name="tomcat" value="/usr/local/devtools/jakarta-tomcat" />
70
      <property name="webapps" value="/usr/local/devtools/jakarta-tomcat/webapps" />
71
      <property name="tomcat" value="f:\\devtools\\jakarta-tomcat" />
72
      <property name="webapps" value="f:\\devtools\\jakarta-tomcat\\webapps" />
71 73
      <property name="context" value="tao" />
72 74
      <property name="user" value="tao"/>
73
      <property name="password" value=""/>
75
      <property name="password" value="tdataint"/>
74 76
      <!-- Tomcat version, if you use tomcat 3, please fill it "tomcat3". If you using tomcat4, please fill it "tomcat4"-->
75
      <property name="tomcatversion" value="tomcat3"/>
77
      <property name="tomcatversion" value="tomcat4"/>
76 78

  
77
      <property name="server" value="pine.nceas.ucsb.edu:8080"/>
78
      <property name="systemidserver" value="http://pine.nceas.ucsb.edu:8080" />
79
      <property name="datafilepath" value="/usr/local/devtools/jakarta-tomcat/data/tao/data" />
80
      <property name="inlinedatafilepath" value="/usr/local/devtools/jakarta-tomcat/data/tao/inlinedata" />
79
      <property name="server" value="fatali.nceas.ucsb.edu:8080"/>
80
      <property name="systemidserver" value="http://fatali.nceas.ucsb.edu:8080" />
81
      <property name="datafilepath" value="f:\\devtools\\jakarta-tomcat\\data\\tao\\data" />
82
      <property name="inlinedatafilepath" value="f:\\devtools\\jakarta-tomcat\\data\\tao\\inlinedata" />
81 83
      <property name="debuglevel" value="40" />
82 84

  
83 85
      <property name="forcereplicationwaitingtime" value="30000"/>
......
92 94
      <!-- Make sure these paths match the location of the jar files
93 95
           on your system, the defaults should usually work -->
94 96
      <property name="jsdk"
95
                value="${tomcat}/lib/common/servlet.jar" />
97
                value="${tomcat}/common/lib/servlet.jar" />
96 98
      <property name="xmlp"
97 99
                value="lib/xercesImpl.jar" />
98 100
      <property name="srb"
......
144 146
      <property name="stmmlnamespace" value="http://www.xml-cml.org/schema/stmml" />
145 147

  
146 148
      <property name="cpath"
147
                value="${xmlp}:${xalan}:${apis}:${jdbc}:${jsdk}:${srb}:${cos}:${morpho}:${emlparser}"/>
149
                value="${xmlp}:${xalan}:${apis}:${jdbc}:${jsdk}:${srb}:${cos}:${morpho}:${emlparser}:${msutil}:${mssqlserver}"/>
148 150

  
149 151
      <filter token="docrooturl" value="./" />
150 152
      <filter token="jdbc-connect" value="${jdbc-connect}"/>
......
313 315
     <echo/>
314 316
     <echo>Registering the DTDs with the new Metacat instance...</echo>
315 317
     <sql driver="${dbDriver}"
316
          classpath="${jdbc}"
318
          classpath="${jdbc}:${msutil}:${mssqlserver}"
317 319
          url="${jdbc-connect}"
318 320
          userid="${user}"
319 321
          password="${password}"
......
324 326
     <echo/>
325 327
     <echo>Registering the DTDs with the new Metacat instance...</echo>
326 328
     <sql driver="${dbDriver}"
327
          classpath="${jdbc}"
329
          classpath="${jdbc}:${msutil}:${mssqlserver}"
328 330
          url="${jdbc-connect}"
329 331
          userid="${user}"
330 332
          password="${password}"
......
346 348
             tofile="${installdir}/WEB-INF/lib/xml-apis.jar" />
347 349
       <copy file="${jdbc}"
348 350
             tofile="${installdir}/WEB-INF/lib/jdbc.jar" />
351
       <copy file="${msutil}"
352
             tofile="${installdir}/WEB-INF/lib/msutil.jar" />
353
       <copy file="${mssqlserver}"
354
             tofile="${installdir}/WEB-INF/lib/mssqlserver.jar" />
349 355
       <copy file="${cos}"
350 356
             tofile="${installdir}/WEB-INF/lib/cos.jar" />
351 357
       <copy file="${morpho}"

Also available in: Unified diff