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 Sun, 22 Feb 2009 10:11:02 GMT
Hi Francois,

I even didn't set up any users for the db. I connect to it without
username and password. That is strange.

Thank you,
Stephan

On Fri, 20 Feb 2009 20:38:38 -0800
Francois Orsini <francois.orsini@gmail.com> wrote:

> Hi Walter,
> 
> How did you set-up these permissions?
> 
> Normally, if you connect to a remote instance of Derby and have not
> set specific permissions, you should be able to update data based on
> the user you've authenticated with when connecting to the database.
> How did you set permissions to be read-ony for the OpenOffice client?
> Are you connecting with the same user credentials as you do from the
> servlet? Have you configured different users with different
> permissions to connect to this database whether you're connecting
> from the servlet or from a remote (OpenOffice) client?
> 
> Cheers
> 
> --francois
> 
> On Fri, Feb 20, 2009 at 4:31 PM, Walter Rogura <mist@sudus.eu> wrote:
> 
> > 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>
> > <
> > 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