db-derby-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Walter Rogura <m...@sudus.eu>
Subject Re: Derby and third party products
Date Sat, 21 Feb 2009 00:31:57 GMT
Hi Francois,

btw. I don't mean alternation, but updating. Sorry for the confusion!

Walter

On Sat, 21 Feb 2009 10:22:22 +1000
Walter Rogura <mist@sudus.eu> wrote:

> Hi Francois,
> 
> As you know, I connect to the derby db as soon as tomcat starts. From
> there on I can access the db via a tomcat servlet. In addition, I
> wished to connect to the same db via openoffice concurrently. Thanks
> to your solution this works now based on the derby network server.
> 
> The issue is now, that my servlet has read-write permission and
> openoffice read-only permission. But it would be great if openoffice
> would be able to alternate content of the db too.
> 
> Is that possible? Hope I could expressed myself.
> 
> Thank you,
> Stephan
> 
> 
> On Fri, 20 Feb 2009 16:10:51 -0800
> Francois Orsini <francois.orsini@gmail.com> wrote:
> 
> > Hi Walter,
> > 
> > Glad it helped. Not sure I understand your last issue.
> > Do you want alternate the database you want to connect within
> > OpenOffice? Like connecting from OpenOffice to the remote database
> > started by TomCat and then switching back to a local embedded one in
> > OpenOffice?
> > 
> > It would help if you could give some more context or/and a use case
> > scenario to describe your last issue.
> > 
> > Cheers
> > 
> > --francois
> > 
> > On Fri, Feb 20, 2009 at 3:54 PM, Walter Rogura <mist@sudus.eu>
> > wrote:
> > 
> > > Hi Francois,
> > >
> > > Your help was perfect. Thank you so much! Now I'm able to
> > > establish multiple connections. There is one issue left. How do I
> > > enable openoffice to alternate the database too and not only my
> > > tomcat servlet? I guess I have to set up multiple concurrency
> > > levels, but where to specify those?
> > >
> > > Any help is much appreciated!
> > >
> > > Thank you,
> > > Walter
> > >
> > >
> > > On Mon, 16 Feb 2009 02:07:38 -0800
> > > Francois Orsini <francois.orsini@gmail.com> wrote:
> > >
> > > > Hi Walter,
> > > >
> > > > You need to enable the Derby's instance running in TomCat to act
> > > > as a server and allow remote connections.
> > > > See
> > > >
> > > http://db.apache.org/derby/docs/10.4/adminguide/tadminconfig814963.html(for<http://db.apache.org/derby/docs/10.4/adminguide/tadminconfig814963.html%28for>
> > > > turning on server mode)
> > > >
> > > > You would then be able to connect from an OpenOffice client
> > > > using Derby's network client JDBC driver (instead of the
> > > > embedded ones as the tutorial shows). Of course you can still
> > > > use the embedded driver to access the Derby instance started
> > > > from within TomCat.
> > > >
> > > http://db.apache.org/derby/docs/10.4/getstart/getstart-single.html#tgsactivity4
> > > >
> > > > For instance,
> > > > In 8) replace the Derby embedded connection URL with the one to
> > > > connect to the remote instance of Derby started within TomCat.
> > > > e.g.
> > > > jdbc:derby://localhost:1527/*c:/myfolder/**EactsCongenitalDatabase*
> > > > or jdbc:derby://localhost:1527/*EactsCongenitalDatabase* (if you
> > > > have set DERBY_SYSTEM_HOME to point to a directory where to
> > > > expect to find the database(s) [recommended way] of if Derby was
> > > > started in a directory where the database is located).
> > > > http://db.apache.org/derby/docs/dev/devguide/cdevdvlp27610.html
> > > >
> > > > in 9) Use Derby's network client driver instead of the embedded
> > > > one class, such as:
> > > > org.apache.derby.jdbc.ClientDriver
> > > > (make sure to have DerbyClient.jar in OpenOffice classpath as
> > > > you did with Derby.jar)
> > > >
> > > > Hope this helps
> > > >
> > > > --francois
> > > >
> > > > On Sun, Feb 15, 2009 at 2:27 PM, Walter Rogura <mist@sudus.eu>
> > > > wrote:
> > > >
> > > > > Hey,
> > > > >
> > > > > Derby works fine with tomcat and even the connection to open
> > > > > office runs smoothly (thanks to that tutorial
> > > > >
> > > http://www.eactscongenitaldb.org/docs/OpenOffice_and_JDBC_for_data_access
> > > > > ).
> > > > >
> > > > > But what does not work is to connect tomcat and open office to
> > > > > one and the same derby db concurrently. I always need to stop
> > > > > one or the other application to successfully connect to the
> > > > > db.
> > > > >
> > > > > How can I solve this issue?
> > > > >
> > > > > Thank you,
> > > > > Walter
> > > > >
> > >

Mime
View raw message