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 <[email protected]> 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 <[email protected]> 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 <[email protected]> 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 <[email protected]> > > > 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 <[email protected]> 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 <[email protected]> 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 > > > > > > <[email protected]> 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 <[email protected]> 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 > > > > > > > > <[email protected]> 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 > > > > > > > > > > > > > > > > > > > > > >
