db-derby-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From José Ventura <st.ne...@gmail.com>
Subject Re: Move from embedded to network server
Date Mon, 12 Sep 2011 10:51:44 GMT
To make the embedded connection start a network server instead of an
embedded server, use the following property:

http://db.apache.org/derby/docs/10.5/adminguide/radminconfigstartnetworkserver.html

I think that page links to other useful properties in this scenario
(derby.drda.*).

On Mon, Sep 12, 2011 at 7:42 AM, johny_quest <ivan_belev@yahoo.com> wrote:

>
> I checked the configuration options for IBM Director and Derby and here are
> the available options:
>
>
> ;==============================================================================
> ; Apache Derby
>
> ;==============================================================================
> DbmsApplication = Apache Derby
> DbmsTcpIpListenerPort = 1527
> DbmsServerName = localhost
> DbmsDatabaseName = database
> DbmsUserId = tioadmin
> DbmsPassword = **
> DbmsDatabaseAppHome = C:\Program
>
> Files\IBM\Director\lwi\runtime\database\eclipse\plugins\org.apache.derby.core_10.5.3.1
> DbmsDatabaseHome = C:\Program Files\IBM\Director
>
> I can change the port here, probably I have to set the IP or host name
> instead of localhost, but there is no url to specify. Maybe I should change
> the DatabaseAppHome to where derby network server is installed (the lib
> folder with the java files).
>
>
> José Ventura-3 wrote:
> >
> > That's about right.
> >
> > I usually specify the directory I want by opening a command prompt in the
> > parent directory. For example, if the files are located in
> > C:/derby/databases/mydb, then I open a prompt in C:/derby/databases and
> > issue the start command from there. There are probably other ways to do
> > it,
> > check the documentation.
> >
> > In the above example, the URL you would use (both in Director and other
> > clients) would be "jdbc:derby://host:port/mydb" (note the database name,
> > which is the name of a subdirectory where derby was started).
> >
> > Hope that helps.
> >
> > On Mon, Sep 12, 2011 at 6:21 AM, johny_quest <ivan_belev@yahoo.com>
> wrote:
> >
> >>
> >> Ok, lets see if I got you correctly:
> >>
> >> I stop IBM Director.
> >> I start the Derby Network Server giving it the database directory as
> home
> >> (is this done within the start command?)
> >> I then reconfigure IBM Director to connect with the network mode url
> (not
> >> the embedded) and the new port number (because I set the Network server
> >> to
> >> listen on port 1528).
> >>
> >> I should then be able to connect simultaniously from more than one
> >> clients,
> >> right?
> >>
> >>
> >> José Ventura-3 wrote:
> >> >
> >> > Derby only allows one instance *of the database software* (RDBMS) to
> >> open
> >> > the files in a directory at a time. According to the error you
> >> received,
> >> > there already is an instance of the RDBMS open on c:/Program
> >> > Files/IBM/Director/database (probably started by an embedded
> connection
> >> in
> >> > IBM Director).
> >> >
> >> > Even if you use Derby Network Server, you will still be limited to one
> >> > instance *of the database software*, however this instance will accept
> >> > connections from any number of *clients*.
> >> >
> >> > I think what you want to do is stop IBM Director, then start Derby
> >> Network
> >> > Server upon that directory, then configure IBM Director to use a
> client
> >> > connection instead of an embedded connection. That way, both Director
> >> and
> >> > other clients (such as razorSQL) will be able to connect, read and
> >> write
> >> > data to the database.
> >> >
> >> > - José
> >> >
> >> > On Fri, Sep 9, 2011 at 12:02 PM, johny_quest <ivan_belev@yahoo.com>
> >> wrote:
> >> >
> >> >>
> >> >> Hello guys,
> >> >> I have the following situation, that I have tried to solve for a
> >> couple
> >> >> of
> >> >> week but I can't seem to get it working.
> >> >> Here is the deal.
> >> >>
> >> >> I have a derby database that is running in embedded mode as a part
of
> >> an
> >> >> application (IBM Director software runs Apache Derby database by
> >> >> default).
> >> >>
> >> >> What I have to do, is to connect another type of software to that
> >> >> database
> >> >> using ODBC connector.
> >> >>
> >> >> First I read about the fact, that only one connection is possibla at
> a
> >> >> time.
> >> >> I tried to connect to the database with razorSQL just to see if I can
> >> >> connect, but the error is:
> >> >>
> >> >> DERBY SQL error: SQLCODE:
> >> >> -1, SQLSTATE: XJ040, SQLERRMC: Failed to start database 'c:/Program
> >> >> Files/IBM/Director/database' with class loader
> >> >> sun.misc.Launcher$AppClassLoader@11b86e7,
> >> >> see the next exception
> >> >> for details.::SQLSTATE: XSDB6Another instance of Derby may
> >> >> have already booted the database C:\Program
> >> Files\IBM\Director\database.
> >> >>
> >> >> After that I installed a new apache derby and set it in network mode.
> >> I
> >> >> had
> >> >> to change the port to 1528 because obviously the other instance is
> >> >> listening
> >> >> on 1527. Using the new setting I managed to connect to the server,
> >> create
> >> >> database and tables etc. - it is working, but I still cannot connect
> >> to
> >> >> the
> >> >> needed database. The error is the same.
> >> >>
> >> >> Please, can someone suggest a solution for this problem.
> >> >> I will be very grateful.
> >> >>
> >> >> --
> >> >> View this message in context:
> >> >>
> >>
> http://old.nabble.com/Move-from-embedded-to-network-server-tp32431926p32431926.html
> >> >> Sent from the Apache Derby Users mailing list archive at Nabble.com.
> >> >>
> >> >>
> >> >
> >> >
> >>
> >> --
> >> View this message in context:
> >>
> http://old.nabble.com/Move-from-embedded-to-network-server-tp32431926p32446393.html
> >> Sent from the Apache Derby Users mailing list archive at Nabble.com.
> >>
> >>
> >
> >
>
> --
> View this message in context:
> http://old.nabble.com/Move-from-embedded-to-network-server-tp32431926p32446785.html
> Sent from the Apache Derby Users mailing list archive at Nabble.com.
>
>

Mime
View raw message