Return-Path: Delivered-To: apmail-db-derby-user-archive@www.apache.org Received: (qmail 63937 invoked from network); 23 Feb 2009 19:31:32 -0000 Received: from hermes.apache.org (HELO mail.apache.org) (140.211.11.2) by minotaur.apache.org with SMTP; 23 Feb 2009 19:31:32 -0000 Received: (qmail 64634 invoked by uid 500); 23 Feb 2009 19:31:31 -0000 Delivered-To: apmail-db-derby-user-archive@db.apache.org Received: (qmail 64608 invoked by uid 500); 23 Feb 2009 19:31:31 -0000 Mailing-List: contact derby-user-help@db.apache.org; run by ezmlm Precedence: bulk list-help: list-unsubscribe: List-Post: List-Id: Reply-To: "Derby Discussion" Delivered-To: mailing list derby-user@db.apache.org Received: (qmail 64593 invoked by uid 99); 23 Feb 2009 19:31:31 -0000 Received: from nike.apache.org (HELO nike.apache.org) (192.87.106.230) by apache.org (qpsmtpd/0.29) with ESMTP; Mon, 23 Feb 2009 11:31:31 -0800 X-ASF-Spam-Status: No, hits=2.2 required=10.0 tests=HTML_MESSAGE,SPF_PASS X-Spam-Check-By: apache.org Received-SPF: pass (nike.apache.org: domain of francois.orsini@gmail.com designates 209.85.146.183 as permitted sender) Received: from [209.85.146.183] (HELO wa-out-1112.google.com) (209.85.146.183) by apache.org (qpsmtpd/0.29) with ESMTP; Mon, 23 Feb 2009 19:31:21 +0000 Received: by wa-out-1112.google.com with SMTP id m33so1053412wag.23 for ; Mon, 23 Feb 2009 11:31:00 -0800 (PST) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=gamma; h=domainkey-signature:mime-version:received:in-reply-to:references :date:message-id:subject:from:to:content-type; bh=P0/gHPqOKk/NayyvM2S572QJab57VRBpUTTG+6CYGHI=; b=Z/WE/iSu3WFU5RsBuyIjm9dFRgyT1+/3VcX7q8cpQIyZsIDom0JYEOc91Ho3jzBHww ZNmrrkO9g+w7dnkwHiXxfmN1/OIZTu9bm9J0qIyqcKPm8ENSzXCqknLePl0a9YApbTGu J/bUXMfjSa8PGlZqdpi5kWXdPNTjtOgacMA6s= DomainKey-Signature: a=rsa-sha1; c=nofws; d=gmail.com; s=gamma; h=mime-version:in-reply-to:references:date:message-id:subject:from:to :content-type; b=f1o/dE/bnudyL1d2+eXF8TSPlv6vcNBV5NTy86h+R/JZG9uouF15PCQY5vEklf6R2i lYjxWNsP3nWuFu2yFITK8jJUKh6QsdymE35L47Q14YNKUMzbgne560rDmWwjDw2Wqq1E eXqtYM2W7zbdNzFBZ8wEmaDnpwPY7izGoY9Iw= MIME-Version: 1.0 Received: by 10.114.240.13 with SMTP id n13mr1798464wah.41.1235417458847; Mon, 23 Feb 2009 11:30:58 -0800 (PST) In-Reply-To: <20090223202128.1a47dc43@jibe> References: <20090216082735.30aa6293@ventus> <7921d3e40902160207j46a0950n15557ad5510e8562@mail.gmail.com> <20090221095409.7bbef381@ventus> <7921d3e40902201610s71547397icd590c8bbd622011@mail.gmail.com> <20090221102222.632db2f3@ventus> <20090221103157.1109a04d@ventus> <7921d3e40902202038o21034fb7j8b11b1ced149a3d0@mail.gmail.com> <20090222201102.5ae64d98@ventus> <7921d3e40902221357p76a95a26q9deb701b4d8a4dea@mail.gmail.com> <20090223202128.1a47dc43@jibe> Date: Mon, 23 Feb 2009 11:30:58 -0800 Message-ID: <7921d3e40902231130p2385b93cy8bb643435527caad@mail.gmail.com> Subject: Re: Derby and third party products From: Francois Orsini To: Derby Discussion Content-Type: multipart/alternative; boundary=0016e649cce6c8b2a204639b0a3d X-Virus-Checked: Checked by ClamAV on apache.org --0016e649cce6c8b2a204639b0a3d Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: 7bit 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 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 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 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 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 > > > > 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 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 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 > > > > > > > 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 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 > > > > > > > > > > > > > > > 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 > > > > > > > > > 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 > > > > > > > > > > > > > > > > > > > > > > > > > > > --0016e649cce6c8b2a204639b0a3d Content-Type: text/html; charset=ISO-8859-1 Content-Transfer-Encoding: quoted-printable Hi Walter,

If your servlet connecting to Derby via Hibernate is usin= g 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 get= ting 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 actu= ally access the (same) tables (data) from OpenOffice as you do from your se= rvlet?

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 spec= ific
> username, the default is 'APP' as the schema and owner name fo= r 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<= br> > 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> w= rote:
>
> > Hi Francois,
> >
> > I even didn't set up any users for the db. I connect to it wi= thout
> > 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 h= ave
> > > not set specific permissions, you should be able to update d= ata
> > > based on the user you've authenticated with when connect= ing 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<= br> > > > different users with different permissions to connect to thi= s
> > > database whether you're connecting from the servlet or f= rom a
> > > remote (OpenOffice) client?
> > >
> > > Cheers
> > >
> > > --francois
> > >
> > > On Fri, Feb 20, 2009 at 4:31 PM, Walter Rogura <mist@sudu= s.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 to= mcat
> > > > > servlet. In addition, I wished to connect to the s= ame db via
> > > > > openoffice concurrently. Thanks to your solution t= his works
> > > > > now based on the derby network server.
> > > > >
> > > > > The issue is now, that my servlet has read-write p= ermission
> > > > > and openoffice read-only permission. But it would = be great if
> > > > > openoffice would be able to alternate content of t= he 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 la= st issue.
> > > > > > Do you want alternate the database you want t= o connect
> > > > > > within OpenOffice? Like connecting from OpenO= ffice to the
> > > > > > remote database started by TomCat and then sw= itching back
> > > > > > to a local embedded one in OpenOffice?
> > > > > >
> > > > > > It would help if you could give some more con= text or/and a
> > > > > > use case scenario to describe your last issue= .
> > > > > >
> > > > > > Cheers
> > > > > >
> > > > > > --francois
> > > > > >
> > > > > > On Fri, Feb 20, 2009 at 3:54 PM, Walter Rogur= a
> > > > > > <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 t= o 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
> > > > >
> > > > > > > > turning on server mode)
> > > > > > > >
> > > > > > > > You would then be able to connect f= rom an OpenOffice
> > > > > > > > client using Derby's network cl= ient JDBC driver
> > > > > > > > (instead of the embedded ones as th= e tutorial shows).
> > > > > > > > Of course you can still use the emb= edded driver to
> > > > > > > > access the Derby instance started f= rom within TomCat.
> > > > > > > >
> > > > > > >
> > > >
> > http://db.apache.org/derby/doc= s/10.4/getstart/getstart-single.html#tgsactivity4
> > > > > > > >
> > > > > > > > For instance,
> > > > > > > > In 8) replace the Derby embedded co= nnection URL with the
> > > > > > > > one to connect to the remote instan= ce of Derby started
> > > > > > > > within TomCat. e.g.
> > > > > > > >
> > jdbc:derby://localhost:1527/*c:/myfolder/**EactsCongenitalDatabas= e*
> > > > > > > > or jdbc:derby://localhost:1527/*Eac= tsCongenitalDatabase*
> > > > > > > > (if you have set DERBY_SYSTEM_HOME = to point to a
> > > > > > > > directory where to expect to find t= he database(s)
> > > > > > > > [recommended way] of if Derby was s= tarted in a
> > > > > > > > directory where the database is loc= ated).
> > > > > > > >
> > http://db.apache.org/derby/docs/dev/devguide/c= devdvlp27610.html
> > > > > > > >
> > > > > > > > in 9) Use Derby's network clien= t driver instead of the
> > > > > > > > embedded one class, such as:
> > > > > > > > org.apache.derby.jdbc.ClientDriver<= br> > > > > > > > > (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, Wa= lter Rogura
> > > > > > > > <mist@sudus.eu> wrote:
> > > > > > > >
> > > > > > > > > Hey,
> > > > > > > > >
> > > > > > > > > Derby works fine with tomcat a= nd even the connection
> > > > > > > > > to open office runs smoothly (= thanks to that tutorial
> > > > > > > > >
> > > > > > >
> > > >
> > http://www.eactscongenitaldb.org/doc= s/OpenOffice_and_JDBC_for_data_access
> > > > > > > > > ).
> > > > > > > > >
> > > > > > > > > But what does not work is to c= onnect tomcat and open
> > > > > > > > > office to one and the same der= by 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
> > > > > > > > >
> > > > > > >
> > > >
> >

--0016e649cce6c8b2a204639b0a3d--