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 1:

At line 1 added 71 lines.
!!__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__"
!2] Add this to "lib/lib.properties"
<div style="margin-left: 40px">
{{{
#
# JTDS SQL Server - http://jtds.sourceforge.net
#
jtds.version=1.2
jtds.dir=${lib.dir}/jtds-${jtds.version}
jtds.jar=${jtds.dir}/jtds-${jtds.version}.jar
}}}
</div>
!3] in "properties.xml" change this lines:
<div style="margin-left: 40px">
{{{
<!-- Defaults for database.properties -->
<property name="database.jar" location="${jtds.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 -->
<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}/${database.name}"/>
<property name="database.show_sql" value="true"/>
}}}
</div>
!4] Edit "build.xml" line 669
<div style="margin-left: 40px">
{{{
<equals arg1="${database.type}" arg2="jtds:sqlserver"/>}}}
</div>
!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
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.