allright here we go:
with these two datasources things start moving the right direction
derby-users-ds.xml:
?xml version=1.0 encoding=UTF-8?
datasources
local-tx-datasource
!-- The jndi name of the DataSource, it is prefixed with java:/
--
!-- Datasources are not available outside the virtual machine --
jndi-nameusers/jndi-name
!-- for in-process persistent db, saved when jboss stops. The
org.jboss.jdbc.DerbyDatabase mbean is necessary for properly db
shutdown --
connection-urljdbc:derby:database/users;create=true/connection-url
!-- The driver class --
driver-classorg.apache.derby.jdbc.EmbeddedDriver/driver-class
!-- The login and password --
user-namesa/user-name
password/password
!-- The minimum connections in a pool/sub-pool. Pools are lazily
constructed on first use --
min-pool-size5/min-pool-size
!-- The maximum connections in a pool/sub-pool --
max-pool-size20/max-pool-size
!-- The time before an unused connection is destroyed --
idle-timeout-minutes5/idle-timeout-minutes
!-- Whether to check all statements are closed when the connection
is returned to the pool,
this is a debugging feature that should be turned off in
production --
track-statements/
/local-tx-datasource
/datasources
and derby-continuum-ds.xml
?xml version=1.0 encoding=UTF-8?
datasources
local-tx-datasource
!-- The jndi name of the DataSource, it is prefixed with java:/
--
!-- Datasources are not available outside the virtual machine --
jndi-namecontinuum/jndi-name
!-- for in-process persistent db, saved when jboss stops. The
org.jboss.jdbc.DerbyDatabase mbean is necessary for properly db
shutdown --
connection-urljdbc:derby:database/continuum;create=true/connection-ur
l
!-- The driver class --
driver-classorg.apache.derby.jdbc.EmbeddedDriver/driver-class
!-- The login and password --
user-namesa/user-name
password/password
!-- The minimum connections in a pool/sub-pool. Pools are lazily
constructed on first use --
min-pool-size5/min-pool-size
!-- The maximum connections in a pool/sub-pool --
max-pool-size20/max-pool-size
!-- The time before an unused connection is destroyed --
idle-timeout-minutes5/idle-timeout-minutes
!-- Whether to check all statements are closed when the connection
is returned to the pool,
this is a debugging feature that should be turned off in
production --
track-statements/
/local-tx-datasource
/datasources
and the database is built under JBOSS_HOME/bin
But hold on, the next exception is here (rather long)
2007-02-15 18:48:08,681 ERROR
[com.opensymphony.xwork.config.providers.InterceptorBuilder] Unable to
find interceptor class referenced by ref-name pssCommonStack
2007-02-15 18:48:08,681 ERROR
[com.opensymphony.xwork.config.providers.InterceptorBuilder] Unable to
find interceptor class referenced by ref-name pssCommonStack
2007-02-15 18:48:09,242 ERROR [org.jboss.web.localhost.Engine]
StandardWrapperValve[default]: Servlet.service() for servlet default
threw exception
java.lang.NoSuchMethodError:
org.apache.commons.collections.IteratorUtils.emptyIterator()Lorg/apache/
commons/collections/ResettableIterator;
at
org.apache.commons.configuration.PropertyConverter.toIterator(PropertyCo
nverter.java:632)
at
org.apache.commons.configuration.HierarchicalConfiguration.setProperty(H
ierarchicalConfiguration.java:559)
at
org.apache.commons.configuration.ConfigurationUtils.copy(ConfigurationUt
ils.java:143)
at
org.apache.commons.configuration.ConfigurationUtils.convertToHierarchica
l(ConfigurationUtils.java:191)
at
org.apache.commons.configuration.CombinedConfiguration$ConfigData.getTra
nsformedRoot(CombinedConfiguration.java:629)
at
org.apache.commons.configuration.CombinedConfiguration.constructCombined
Node(CombinedConfiguration.java:533)
at
org.apache.commons.configuration.CombinedConfiguration.getRootNode(Combi
nedConfiguration.java:437)
at
org.apache.commons.configuration.HierarchicalConfiguration.fetchNodeList
(HierarchicalConfiguration.java:721)
at
org.apache.commons.configuration.HierarchicalConfiguration.getProperty(H
ierarchicalConfiguration.java:284)
at
org.apache.commons.configuration.CombinedConfiguration.getProperty(Combi
nedConfiguration.java:511)
at
org.apache.commons.configuration.AbstractConfiguration.resolveContainerS
tore(AbstractConfiguration.java:1222)
at
org.apache.commons.configuration.AbstractConfiguration$1.lookup(Abstract
Configuration.java:324)
at
org.apache.commons.configuration.interpol.ConfigurationInterpolator.look
up(ConfigurationInterpolator.java:281)
at
org.apache.commons.lang.text.StrSubstitutor.resolveVariable(StrSubstitut
or.java:655)
at
org.apache.commons.lang.text.StrSubstitutor.substitute(StrSubstitutor.ja
va:587)
at