Derby
  1. Derby
  2. DERBY-3285

Make derby.system.bootAll work regardless of whether derby.system.home is explicitly set or not

    Details

    • Type: Improvement Improvement
    • Status: Open
    • Priority: Minor Minor
    • Resolution: Unresolved
    • Affects Version/s: 10.3.1.4, 10.3.2.1, 10.4.1.3
    • Fix Version/s: None
    • Component/s: Services
    • Labels:
      None

      Description

      Cf discussion under DERBY-2182, which revealed that bootAll only works as intended (?!) when derby.system.home. If
      it has its default value, user.dir, no autoboot takes place.

      We also saw an exception: The network server sets derby.system.home explicitly, unless
      -noSecurityManager is set, so in this case the auto-booting is not affected by this bug.

        Activity

        Hide
        Kathey Marsden added a comment -

        I am having some trouble getting derby.system.bootAll to work even with derby.system.home set. First I created a couple of databases.
        [C:/kmarsden/repro/derby-3285] java org.apache.derby.tools.ij
        ij version 10.6
        ij> run 'prep.sql';
        ij> connect 'jdbc:derby:dba;create=true';
        ij> connect 'jdbc:derby:dba;shutdown=true';
        ERROR 08006: Database 'dba' shutdown.
        ij> connect 'jdbc:derby:dbb;create=true';
        ij(CONNECTION1)> connect 'jdbc:derby:dbb;shutdown=true';
        ERROR 08006: Database 'dbb' shutdown.
        ij(CONNECTION1)> quit;

        I verified there were no lck files in these database directories.
        Then I started ij with derby.system.home and derby.system.bootAll set and created a third database.

        java -Dderby.system.home=C:/kmarsden/repro/derby-3285 -Dderby.sytem.bootAll org.apache.derby.tools.ij
        ij> connect 'jdbc:derby:dbc;create=true';

        I think this should have booted databases dba and dbb too, but I checked the database directories (without exiting ij) and see a db.lck file only for dbc. dba and dbb have none.
        Any ideas what I am doing wrong?

        Show
        Kathey Marsden added a comment - I am having some trouble getting derby.system.bootAll to work even with derby.system.home set. First I created a couple of databases. [C:/kmarsden/repro/derby-3285] java org.apache.derby.tools.ij ij version 10.6 ij> run 'prep.sql'; ij> connect 'jdbc:derby:dba;create=true'; ij> connect 'jdbc:derby:dba;shutdown=true'; ERROR 08006: Database 'dba' shutdown. ij> connect 'jdbc:derby:dbb;create=true'; ij(CONNECTION1)> connect 'jdbc:derby:dbb;shutdown=true'; ERROR 08006: Database 'dbb' shutdown. ij(CONNECTION1)> quit; I verified there were no lck files in these database directories. Then I started ij with derby.system.home and derby.system.bootAll set and created a third database. java -Dderby.system.home=C:/kmarsden/repro/derby-3285 -Dderby.sytem.bootAll org.apache.derby.tools.ij ij> connect 'jdbc:derby:dbc;create=true'; I think this should have booted databases dba and dbb too, but I checked the database directories (without exiting ij) and see a db.lck file only for dbc. dba and dbb have none. Any ideas what I am doing wrong?
        Hide
        Dag H. Wanvik added a comment -

        Kathey> java -Dderby.system.home=C:/kmarsden/repro/derby-3285 -Dderby.sytem.bootAll org.apache.derby.tools.ij

          • typo: system

        Could this be it?

        Dag

        Kathey> ij> connect 'jdbc:derby:dbc;create=true';
        Kathey>
        Kathey> I think this should have booted databases dba and dbb too, but I checked the database directories (without exiting ij) and see a db.lck file only for dbc. dba and dbb have none.
        Kathey> Any ideas what I am doing wrong?

        Show
        Dag H. Wanvik added a comment - Kathey> java -Dderby.system.home=C:/kmarsden/repro/derby-3285 -Dderby.sytem.bootAll org.apache.derby.tools.ij typo: system Could this be it? Dag Kathey> ij> connect 'jdbc:derby:dbc;create=true'; Kathey> Kathey> I think this should have booted databases dba and dbb too, but I checked the database directories (without exiting ij) and see a db.lck file only for dbc. dba and dbb have none. Kathey> Any ideas what I am doing wrong?
        Hide
        Kathey Marsden added a comment -

        That was of course it. Thank you Dag. Next time I won't attempt triage before coffee.

        I with the corrected command line I verified that that the databases boot when derby.system.home is set and don't if I do not set derby.system.home. I think though that this should be reclassified as an improvement since the doc is pretty specific that derby.system.bootAll applies only when derby.system.home is set.
        http://db.apache.org/derby/docs/dev/tuning/rtunproperbootall.html

        Show
        Kathey Marsden added a comment - That was of course it. Thank you Dag. Next time I won't attempt triage before coffee. I with the corrected command line I verified that that the databases boot when derby.system.home is set and don't if I do not set derby.system.home. I think though that this should be reclassified as an improvement since the doc is pretty specific that derby.system.bootAll applies only when derby.system.home is set. http://db.apache.org/derby/docs/dev/tuning/rtunproperbootall.html

          People

          • Assignee:
            Unassigned
            Reporter:
            Dag H. Wanvik
          • Votes:
            0 Vote for this issue
            Watchers:
            0 Start watching this issue

            Dates

            • Created:
              Updated:

              Development