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 Wed, 25 Feb 2009 22:44:10 GMT
Hi Francois,

thank you very much for all those efforts. I'll dig into that and let
you know.

Walter

On Wed, 25 Feb 2009 14:28:57 -0800
Francois Orsini <francois.orsini@gmail.com> wrote:

> Hi Walter,
> 
> I have just tried OpenOffice against an embedded and remote server
> instance of Derby and I was able to modify  data.
> 
> I used Derby's ToursDB sample database and I was able to modify
> flights information (e.g. Aircraft for flight # AA1111 changed to
> 'DC10'). I have verified that it got persisted by exiting OO and
> Derby completely and reading the table back in from OpenOffice Base...
> 
> Can you check again if you can update data with an embedded instance
> of Derby from OpenOffice.
> 
> I have used the following Derby driver class and URL based on my
> environment:
> org.apache.derby.jdbc.EmbeddedDriver
> jdbc:derby:/usr/forsini/Derby/toursdb
> (no need to specify a user name/pwd since I wanted the default 'APP')
> 
> Cheers
> 
> --francois
> 
> On Mon, Feb 23, 2009 at 6:31 PM, Walter Rogura <mist@sudus.eu> wrote:
> 
> > Hi Francois,
> >
> > I receive any error from OpenOffice and the log file mentions no
> > problem. As I wrote as reply to Dag's posting, I can update data
> > with ij. I tested it already with the latest OpenOffice version.
> > Still the same. Wired.
> >
> > Thank you,
> > Walter
> >
> > On Mon, 23 Feb 2009 11:30:58 -0800
> > Francois Orsini <francois.orsini@gmail.com> wrote:
> >
> > > Hi Walter,
> > >
> > > If your servlet connecting to Derby via Hibernate is using the
> > > default user and schema 'APP', then you should be able to do the
> > > same and update data as well from OpenOffice using 'APP'.
> > >
> > > Are you getting any (permission) error message(s) from OpenOffice
> > > at all when you try to update data? How are you updating the data
> > > from OpenOffice? Can you actually access the (same) tables (data)
> > > from OpenOffice as you do from your servlet?
> > >
> > > Also is there any error messages in derby.log (generated from
> > > starting Derby from your servlet)?
> > >
> > > Cheers
> > >
> > > --francois
> > >
> > > On Mon, Feb 23, 2009 at 2:21 AM, Walter Rogura <mist@sudus.eu>
> > > wrote:
> > >
> > > > Hi Francois,
> > > >
> > > > ok, than I expect that I'm logged in as APP, since I never set a
> > > > username and password in my servlet. However, I'm able to update
> > > > data with the servlet, but not with OOo. Thank you for the link.
> > > >
> > > > Well, I set no specific permissions. Actually, everything is
> > > > realised by hibernate. I never made big modifications in
> > > > OpenOffice. And when I login with APP I'm still not able to
> > > > modify data.
> > > >
> > > > Thank you for your help!
> > > > Walter
> > > >
> > > >
> > > > On Sun, 22 Feb 2009 13:57:02 -0800
> > > > Francois Orsini <francois.orsini@gmail.com> wrote:
> > > >
> > > > > Hi Walter,
> > > > >
> > > > > Yes this is expected - if you don't define and connect with a
> > > > > specific username, the default is 'APP' as the schema and
> > > > > owner name for that database.
> > > > >
> > > > > More info in the developer guide in the security section:
> > > > > http://db.apache.org/derby/docs/10.4/devguide/
> > > > >
> > > > > I was asking if you had set-up particular permissions or not
> > > > > as you mentioned your connection from OpenOffice was
> > > > > read-only - how did you notice and verify this? Can't you
> > > > > update data at all?
> > > > >
> > > > > Cheers
> > > > >
> > > > > --francois
> > > > >
> > > > > On Sun, Feb 22, 2009 at 2:11 AM, Walter Rogura <mist@sudus.eu>
> > > > > wrote:
> > > > >
> > > > > > 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
> > >
> > > > <
> > > >
> > http://db.apache.org/derby/docs/10.4/adminguide/tadminconfig814963.html%28for
> > > > >
> > > > > > <
> > > > > >
> > > >
> > 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