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

[RSS]


Hide Menu

AppFuseWithSQLServer
Search Wiki:
Your trail:

Difference between version 23 and version 2:

At line 1 changed 1 line.
!!__2005.07.27__ - AppFuse 1.8 with Microsoft SQLServer 2000
!!__2006.08.08__ - AppFuse 1.9 with Microsoft SQLServer 2000
<div style="margin-left: 40px">
!1] download JTDS jar
[jtds jar|http://jtds.sourceforge.net]
and copy them to directory "__appfuse/lib/jtds-1.2__"
At line 3 removed 5 lines.
!1] download JDTS jar
http://jasigch.princeton
edu:9000/display/UPC/MSSQL+with+the+JTDS+JDBC+Driver
and copy them to "lib/jdts" directory
At line 8 added 2 lines.
<div style="margin-left: 40px">
{{{
At line 10 changed 1 line.
# MS SQL SERVER
# JTDS SQL Server - http://jtds.sourceforge.net
At line 12 changed 7 lines.
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
jtds.version=1.2
jtds.dir=${lib.dir}/jtds-${jtds.version}
jtds.jar=${jtds.dir}/jtds-${jtds.version}.jar
}}}
</div>
At line 20 added 2 lines.
<div style="margin-left: 40px">
{{{
At line 22 changed 1 line.
<property name="database.jar" location="${mssql.jar}"/>
<property name="database.jar" location="${jtds.jar}"/>
At line 30 removed 1 line.
<!--pro MSSQL nelze vytvorit databazi -->
At line 40 changed 1 line.
value="jdbc:${database.type}://${database.host}:1433/appfuse"/>
value="jdbc:${database.type}://${database.host}/${database.name}"/>
At line 42 added 2 lines.
}}}
</div>
At line 43 changed 4 lines.
4] in build.xml change
<property name="operation" value="CLEAN_INSERT"/>
to
<property name="operation" value="MSSQL_CLEAN_INSERT"/>
!4] Edit "build.xml" line 669
<div style="margin-left: 40px">
{{{
<equals arg1="${database.type}" arg2="jtds:sqlserver"/>}}}
</div>
At line 51 added 8 lines.
!5] Solving common problems
Where should be the problem:
# You need to run "__ant setup-tomcat__" to set jdbc connector before deploynment
# check that __appfuse__ database is created (not possible to create db via jdbc)
# Check permissions (username and password) of MSSQL db and MSSQL is running
# Check paths
# Check if host is set properly. In my posted config I am using localhost
# Check port of your MSSQL server
At line 60 added 12 lines.
In my confiuration is after "__ant setup-db__" displayed
net.sourceforge.jtds.jdbc.Driver at URL:
__jdbc:jtds:sqlserver://localhost:1433/appfuse__
</div>
!!__2006.08.08__ - Microsoft JDBC Driver also available
This wiki page describes the opensource JTDS driver. In addition to that driver, Microsoft also has its own
JDBC Driver for SQL Server.
[http://www.microsoft.com/downloads/details.aspx?familyid=e22bc83b-32ff-4474-a44a-22b6ae2c4e17&displaylang=en|http://www.microsoft.com/downloads/details.aspx?familyid=e22bc83b-32ff-4474-a44a-22b6ae2c4e17&displaylang=en]

Back to AppFuseWithSQLServer, or to the Page History.