|
From: <tri...@us...> - 2007-12-29 01:18:56
|
Revision: 228
http://equanda.svn.sourceforge.net/equanda/?rev=228&view=rev
Author: triathlon98
Date: 2007-12-28 17:18:51 -0800 (Fri, 28 Dec 2007)
Log Message:
-----------
improve docs
Modified Paths:
--------------
trunk/src/site/wiki/gettingstarted.wiki
Modified: trunk/src/site/wiki/gettingstarted.wiki
===================================================================
--- trunk/src/site/wiki/gettingstarted.wiki 2007-12-29 00:53:47 UTC (rev 227)
+++ trunk/src/site/wiki/gettingstarted.wiki 2007-12-29 01:18:51 UTC (rev 228)
@@ -8,7 +8,7 @@
- Install [maven|http://maven.apache.org/]. It has been tested with v2.07, higher versions should also work, not sure about lower versions.
- Download and install [firebird|http://www.firebirdsql.org].
-- Download the jboss, it is easiest to use this [equanda tuned configuration|http://www.progs.be/equandajboss-4.2.2.zip] of 4.2.2GA. Unzip at a location of your choice. Or you can [tune your own|jbosstuning.html] copy.
+- Download jboss, it is easiest to use this [equanda tuned configuration|http://www.progs.be/equandajboss-4.2.2.zip] of 4.2.2GA. Unzip at a location of your choice. Or you can [tune your own|jbosstuning.html] copy.
- Download the example application at [http://www.progs.be/equanda-example.tgz] (or get it from svn). Unzip at a location of your choice.
h2. Prepare the deployment
@@ -18,14 +18,83 @@
isql -u myusername -p mypassword
CREATE DATABASE "/home/joachim/data/example-data.fdb" DEFAULT CHARACTER SET UTF8;
{code}
-- Adjust you maven settings file to specify the database location
+- Adjust you maven settings file to specify the database location. This is the file .m2/settings.xml under your home directory.
{code}
-.....
+<settings>
+ <profiles>
+ <profile>
+ <id>mine</id>
+ <properties>
+ <!-- selenium properties-->
+ <firefox.path>firefox /usr/lib/firefox/firefox-bin</firefox.path>
+
+ <!-- example app -->
+ <example.db.url>jdbc:firebirdsql:localhost/3050:/home/joachim/data/example.fdb</example.db.url>
+ <example.db.login>sysdba</example.db.login>
+ <example.db.password>masterkey</example.db.password>
+ <example.db.location>/home/joachim/data/example.fdb</example.db.location>
+ <example.db.empty>/home/joachim/data/example-empty.fdb</example.db.empty>
+ <example.cargo.wait>true</example.cargo.wait>
+ <example.jboss.home>/home/joachim/java/examplejboss</example.jboss.home>
+ <example.jboss.config>equanda</example.jboss.config>
+ <example.jboss.host>localhost</example.jboss.host>
+ <example.jboss.port>8080</example.jboss.port>
+ <example.jboss.jvmargs>
+ -server -Xms256m -Xmx382m -XX:MaxPermSize=128m -Dsun.net.inetaddr.ttl=15
+ -Dsun.rmi.dgc.client.gcInterval=3600000
+ -Dsun.rmi.dgc.server.gcInterval=3600000
+ </example.jboss.jvmargs>
+ <example.jboss.logging>medium</example.jboss.logging>
+
+ </properties>
+ </profile>
+ </profiles>
+ <activeProfiles>
+ <activeProfile>mine</activeProfile>
+ </activeProfiles>
+ <pluginGroups>
+ <pluginGroup>org.equanda</pluginGroup>
+ </pluginGroups>
+
+</settings>
{code}
-- Assure that the data source as defined in jboss is correct.
+You need to check all the settings, but specifically the "example.db.url" contains the database location and "example.jboss.home" contains the jboss location.
+- Assure that the data source as defined in jboss is correct. This is part of the server/equanda/deploy/equanda-example-ds.xml file.
{code}
-.....
+<?xml version="1.0" encoding="UTF-8"?>
+
+<connection-factories>
+
+<local-tx-datasource>
+ <jndi-name>exampleDS</jndi-name>
+
+ <connection-url>jdbc:firebirdsql:localhost/3050:/home/joachim/data/example.fdb</connection-url>
+ <driver-class>org.firebirdsql.jdbc.FBDriver</driver-class>
+ <transaction-isolation>TRANSACTION_REPEATABLE_READ</transaction-isolation>
+ <connection-property name="lc_ctype" type="java.lang.String">UNICODE_FSS</connection-property>
+ <connection-property name="maxStatements">10</connection-property>
+ <user-name>SYSDBA</user-name>
+ <password>masterkey</password>
+
+ <min-pool-size>0</min-pool-size>
+ <max-pool-size>200</max-pool-size>
+ <blocking-timeout-millis>5000</blocking-timeout-millis>
+ <idle-timeout-minutes>15</idle-timeout-minutes>
+
+ <check-valid-connection-sql>SELECT CAST(1 as INTEGER) FROM rdb$database</check-valid-connection-sql>
+ <exception-sorter-class-name>be.unid.util.FirebirdExceptionSorter</exception-sorter-class-name>
+
+ <track-statements>false</track-statements>
+ <prepared-statement-cache-size>0</prepared-statement-cache-size>
+
+ <metadata>
+ <type-mapping>Firebird</type-mapping>
+ </metadata>
+</local-tx-datasource>
+
+</connection-factories>
{code}
+Specifically, the contents of the "connection-url" tag may need changing.
h2. Deploy and run
This was sent by the SourceForge.net collaborative development platform, the world's largest Open Source development site.
|