Hi Luke,
Getting MSQL up and running with AppFuse is a piece of cake - there are two
main approaches to doing it (note that you still need to do 2 if you want
the AppFuse build to create the database schema for you):
1) You get your data source from JNDI: In this case you simply need to
configure your container to load up JTDS (instructions vary per app
server/servlet container) and you change the
applicationContext-recources.xml file to use jndi to look up the datasource:
uncomment the line starting <jee:jndi..... and comment out the bean called
dataSource. This approach has the advantage that you can deploy the war file
into several different environments without needing to change its contents.
2) You compile user names, passwords, etc into the war (the steps listed
here also allow the AppFuse build to create the database schema for you).
First add the following to the list of dependencies near the bottom of the
pom.xml file:
<dependency>
<groupId>${jdbc.groupId}</groupId>
<artifactId>${jdbc.artifactId}</artifactId>
<version>${jdbc.version}</version>
</dependency>
Now change the properties right at the bottom of the file as follows to use
JTDS (look for the Database Settings comment):
hibernate.dialect: org.hibernate.dialect.SQLServerDialect
jdbc.groupId: net.sourceforge.jtds
jdbc.artifactId: jtds
jdbc.version: 1.2
jdbc.driverClassName: net.sourceforge.jtds.jdbc.Driver
jdbc.url: jdbc:jtds:sqlserver://<server>:<port>/<database_instance> (please
see jtds docs for format)
jdbc.username: <db_username>
jdbc.password: <db_password>
And you should be building with MSSQL as the database.
Mike
On 1/18/07, Luke McLean <[EMAIL PROTECTED]> wrote:
Sorry about this but I'm new to maven and I cannot follow the logic as to
how
maven knows which dependencies to download to the user's repository. I
need
to use evil mssql for my project, so I assume that I need to add jtds as a
dependency?
http://repo1.maven.org/maven2/net/sourceforge/jtds/jtds/1.2
If anyone has done similar and has even sketchy instructions I'd love to
know how please.
Thanks,
Luke
--
View this message in context:
http://www.nabble.com/jtds-help-tf3032097s2369.html#a8424579
Sent from the AppFuse - User mailing list archive at Nabble.com.
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
