On 17-dec-05, at 20:14, F Baube wrote:
Any Rife+Derby experts here ?
I want to use Derby in embedded mode. AFAICT if I do this then
I don't need to configure the DB in Tomcat's conf/ directory.
This ought to work in rep/datasources.xml :
<?xml version="1.0" encoding="ISO-8859-1"?>
<!DOCTYPE datasources SYSTEM "/dtd/datasources.dtd">
<datasources>
<datasource name="derby">
<driver>org.apache.derby.jdbc.EmbeddedDriver</driver>
<url>jdbc:derby:/opt/myapp/databases/rife;create=true</url>
<user>fred</user>
<password>fubarfubar</password>
<poolsize>5</poolsize>
</datasource>
</datasources>
I probably don't even need the <user> and <password> elements,
altho I assume that Rife uses the <poolsize> element.
Well derby will create the db with the credentials you provide and of
course the pool is used.
It looks tho like if I do it this way, then I can't use the Derby
utilities such as "ij" and "dblook", since they would run in a
different JVM from Tomcat+Rife+Derby.
You can run Derby in embedded mode too when you use tools like Aqua
Datastudio or DbVisualizer, just provide the same connection
parameters. You'll have to shut down the web application before
though, I think.
--
Geert Bevin Uwyn bvba
"Use what you need" Avenue de Scailmont 34
http://www.uwyn.com 7170 Manage, Belgium
gbevin[remove] at uwyn dot com Tel +32 64 84 80 03
PGP Fingerprint : 4E21 6399 CD9E A384 6619 719A C8F4 D40D 309F D6A9
Public PGP key : available at servers pgp.mit.edu, wwwkeys.pgp.net
_______________________________________________
Rife-users mailing list
[email protected]
http://www.uwyn.com/mailman/listinfo/rife-users
