You are viewing a plain text version of this content. The canonical link for it is here.
Posted to derby-user@db.apache.org by todd runstein <to...@yahoo.com> on 2004/12/08 23:45:05 UTC
Embedding a database in a web application
I'm looking for ways to embed a Derby database into a
web application that will be distributed as a war
file. Since I don't know the path where it will be
deployed ("webapps" in Tomcat, "deploy" in JBoss,
etc), I'm struggling to envision how I can make a JDBC
connection.
Let me elaborate a bit. I want to create a database
(basically an empty set of tables) and put the
directory that Derby creates somewhere in the WEB-INF
directory of my web application. I want to use this
database to save user preferences or application
settings. I want to be able to create a war file
which someone with a J2EE server can drop into their
server and have the application work. Making changes
to the web server is out of the question (so the Lance
Bader tutorial technique is out).
If you were asked to do this, how would you go about
it?
Thanks in advance!
Todd
=====
The only "dumb question" is the one you were too afraid to ask.
________________________________________
Check out RouteRuler - Free software for runners, cyclists, walkers, etc.
http://routeruler.sourceforge.net
________________________________________
Get a handle on your data with "pocOLAP", the "little" OLAP project
http://pocolap.sourceforge.net
________________________________________
__________________________________
Do you Yahoo!?
The all-new My Yahoo! - What will yours do?
http://my.yahoo.com
Re: Embedding a database in a web application
Posted by Arda M <ma...@yahoo.com>.
I think it was a plain "unable to connect to database" error.
todd runstein <to...@yahoo.com> wrote:
I've been able to get it to work using the WEB-INF/lib
directory. Do you remember the error you were
getting?
--- Arda M wrote:
> Trying Tomcat, I could not get derby.jar work by
> putting it in my WEB-INF/lib of my web application.
> I was able to make it work by putting derby.jar
> among all other Tomcat jars. But that would effect
> all web applications running in this Tomcat and
> force every use the same version. Is there a way to
> deploy derby per web application such that i can
> have a Tomcat server with many websites that run
> their own Derby jar version (web app a uses version
> 10, another webapp b uses version 11 for example?)
> and have their own derby database inside their
> directories protected from others??
> Regards,
> Arda
>
>
> todd runstein wrote:
> I'm looking for ways to embed a Derby database into
> a
> web application that will be distributed as a war
> file. Since I don't know the path where it will be
> deployed ("webapps" in Tomcat, "deploy" in JBoss,
> etc), I'm struggling to envision how I can make a
> JDBC
> connection.
>
> Let me elaborate a bit. I want to create a database
> (basically an empty set of tables) and put the
> directory that Derby creates somewhere in the
> WEB-INF
> directory of my web application. I want to use this
> database to save user preferences or application
> settings. I want to be able to create a war file
> which someone with a J2EE server can drop into their
> server and have the application work. Making changes
> to the web server is out of the question (so the
> Lance
> Bader tutorial technique is out).
>
> If you were asked to do this, how would you go about
> it?
>
> Thanks in advance!
>
> Todd
>
> =====
> The only "dumb question" is the one you were too
> afraid to ask.
> ________________________________________
> Check out RouteRuler - Free software for runners,
> cyclists, walkers, etc.
> http://routeruler.sourceforge.net
> ________________________________________
> Get a handle on your data with "pocOLAP", the
> "little" OLAP project
> http://pocolap.sourceforge.net
> ________________________________________
>
>
>
> __________________________________
> Do you Yahoo!?
> The all-new My Yahoo! - What will yours do?
> http://my.yahoo.com
>
>
> ---------------------------------
> Do you Yahoo!?
> Yahoo! Mail - 250MB free storage. Do more. Manage
less.
=====
The only "dumb question" is the one you were too afraid to ask.
________________________________________
Check out RouteRuler - Free software for runners, cyclists, walkers, etc.
http://routeruler.sourceforge.net
________________________________________
Get a handle on your data with "pocOLAP", the "little" OLAP project
http://pocolap.sourceforge.net
________________________________________
__________________________________
Do you Yahoo!?
Yahoo! Mail - Helps protect you from nasty viruses.
http://promotions.yahoo.com/new_mail
---------------------------------
Do you Yahoo!?
Take Yahoo! Mail with you! Get it on your mobile phone.
Re: Embedding a database in a web application
Posted by todd runstein <to...@yahoo.com>.
I've been able to get it to work using the WEB-INF/lib
directory. Do you remember the error you were
getting?
--- Arda M <ma...@yahoo.com> wrote:
> Trying Tomcat, I could not get derby.jar work by
> putting it in my WEB-INF/lib of my web application.
> I was able to make it work by putting derby.jar
> among all other Tomcat jars. But that would effect
> all web applications running in this Tomcat and
> force every use the same version. Is there a way to
> deploy derby per web application such that i can
> have a Tomcat server with many websites that run
> their own Derby jar version (web app a uses version
> 10, another webapp b uses version 11 for example?)
> and have their own derby database inside their
> directories protected from others??
> Regards,
> Arda
>
>
> todd runstein <to...@yahoo.com> wrote:
> I'm looking for ways to embed a Derby database into
> a
> web application that will be distributed as a war
> file. Since I don't know the path where it will be
> deployed ("webapps" in Tomcat, "deploy" in JBoss,
> etc), I'm struggling to envision how I can make a
> JDBC
> connection.
>
> Let me elaborate a bit. I want to create a database
> (basically an empty set of tables) and put the
> directory that Derby creates somewhere in the
> WEB-INF
> directory of my web application. I want to use this
> database to save user preferences or application
> settings. I want to be able to create a war file
> which someone with a J2EE server can drop into their
> server and have the application work. Making changes
> to the web server is out of the question (so the
> Lance
> Bader tutorial technique is out).
>
> If you were asked to do this, how would you go about
> it?
>
> Thanks in advance!
>
> Todd
>
> =====
> The only "dumb question" is the one you were too
> afraid to ask.
> ________________________________________
> Check out RouteRuler - Free software for runners,
> cyclists, walkers, etc.
> http://routeruler.sourceforge.net
> ________________________________________
> Get a handle on your data with "pocOLAP", the
> "little" OLAP project
> http://pocolap.sourceforge.net
> ________________________________________
>
>
>
> __________________________________
> Do you Yahoo!?
> The all-new My Yahoo! - What will yours do?
> http://my.yahoo.com
>
>
> ---------------------------------
> Do you Yahoo!?
> Yahoo! Mail - 250MB free storage. Do more. Manage
less.
=====
The only "dumb question" is the one you were too afraid to ask.
________________________________________
Check out RouteRuler - Free software for runners, cyclists, walkers, etc.
http://routeruler.sourceforge.net
________________________________________
Get a handle on your data with "pocOLAP", the "little" OLAP project
http://pocolap.sourceforge.net
________________________________________
__________________________________
Do you Yahoo!?
Yahoo! Mail - Helps protect you from nasty viruses.
http://promotions.yahoo.com/new_mail
Re: Embedding a database in a web application
Posted by Arda M <ma...@yahoo.com>.
Trying Tomcat, I could not get derby.jar work by putting it in my WEB-INF/lib of my web application. I was able to make it work by putting derby.jar among all other Tomcat jars. But that would effect all web applications running in this Tomcat and force every use the same version. Is there a way to deploy derby per web application such that i can have a Tomcat server with many websites that run their own Derby jar version (web app a uses version 10, another webapp b uses version 11 for example?) and have their own derby database inside their directories protected from others??
Regards,
Arda
todd runstein <to...@yahoo.com> wrote:
I'm looking for ways to embed a Derby database into a
web application that will be distributed as a war
file. Since I don't know the path where it will be
deployed ("webapps" in Tomcat, "deploy" in JBoss,
etc), I'm struggling to envision how I can make a JDBC
connection.
Let me elaborate a bit. I want to create a database
(basically an empty set of tables) and put the
directory that Derby creates somewhere in the WEB-INF
directory of my web application. I want to use this
database to save user preferences or application
settings. I want to be able to create a war file
which someone with a J2EE server can drop into their
server and have the application work. Making changes
to the web server is out of the question (so the Lance
Bader tutorial technique is out).
If you were asked to do this, how would you go about
it?
Thanks in advance!
Todd
=====
The only "dumb question" is the one you were too afraid to ask.
________________________________________
Check out RouteRuler - Free software for runners, cyclists, walkers, etc.
http://routeruler.sourceforge.net
________________________________________
Get a handle on your data with "pocOLAP", the "little" OLAP project
http://pocolap.sourceforge.net
________________________________________
__________________________________
Do you Yahoo!?
The all-new My Yahoo! - What will yours do?
http://my.yahoo.com
---------------------------------
Do you Yahoo!?
Yahoo! Mail - 250MB free storage. Do more. Manage less.