db-derby-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Jordan-61 <mahs...@gmail.com>
Subject Re: Starting Derby with Database
Date Mon, 06 Aug 2012 19:39:43 GMT

The first option worked perfectly for me. Thank you for the assistance!!!



José Ventura-3 wrote:
> 
> I think that, if you are using bash, the variable needs to be set before
> the command. Try this:
> 
> $ DERBY_OPTS="-Dderby.system.home=/greenWorldDB" startNetworkServer
> 
> If that fails, export the variable in a separate command:
> 
> $ export DERBY_OPTS="-Dderby.system.home=/greenWorldDB"
> $ startNetworkServer
> 
> Hope that helps...
> 
> On Mon, Aug 6, 2012 at 4:19 PM, Jordan-61 <mahstah@gmail.com> wrote:
> 
>>
>> Greetings José, thank you for your input. I tried the command switch you
>> suggested and it generated an error that it was an invalid command.
>>
>> [smartplant@SmartPlantWeb WEB-INF]$ startNetworkServer
>> DERBY_OPTS=-Dderby.system.home=/greenWorldDB
>> Mon Aug 06 14:08:11 EDT 2012 : Security manager installed using the Basic
>> server security policy.
>> Mon Aug 06 14:08:11 EDT 2012 : Invalid number of arguments for command
>> start.
>> Usage: NetworkServerControl <commands>
>> Commands:
>> start [-h <host>] [-p <portnumber>] [-noSecurityManager] [-ssl <sslmode>]
>> shutdown [-h <host>][-p <portnumber>] [-ssl <sslmode>] [-user <username>]
>> [-password <password>]
>> ping [-h <host>][-p <portnumber>] [-ssl <sslmode>]
>> sysinfo [-h <host>][-p <portnumber>] [-ssl <sslmode>]
>> runtimeinfo [-h <host>][-p <portnumber>] [-ssl <sslmode>]
>> logconnections {on|off} [-h <host>][-p <portnumber>] [-ssl <sslmode>]
>> maxthreads <max>[-h <host>][-p <portnumber>] [-ssl <sslmode>]
>> timeslice <milliseconds>[-h <host>][-p <portnumber>] [-ssl <sslmode>]
>> trace {on|off} [-s <session id>][-h <host>][-p <portnumber>] [-ssl
>> <sslmode>]
>> tracedirectory <traceDirectory>[-h <host>][-p <portnumber>] [-ssl
>> <sslmode>]
>>
>> I was searching for other suggestions and ran across this:
>> http://www.vogella.com/articles/ApacheDerby/article.html
>>
>> It recommends starting the derby server using the startNetworkServer
>> command
>> and then attaching to the database using the  command
>> jdbc:derby://localhost:1527/c:\temp\mydatabase.
>>
>> However, attempting to connect to the database using that command
>> generates
>> an invalid path error despite the path existing.
>>
>> [root@SmartPlantWeb WEB-INF]# jdbc:derby://localhost:1527/greenWorldDB
>> bash: jdbc:derby://localhost:1527/greenWorldDB: No such file or directory
>> [root@SmartPlantWeb WEB-INF]# jdbc:derby://localhost:1527//greenWorldDB
>> bash: jdbc:derby://localhost:1527//greenWorldDB: No such file or
>> directory
>> [root@SmartPlantWeb WEB-INF]# cd /greenWorldDB
>> [root@SmartPlantWeb greenWorldDB]#
>>
>> Do you have suggestions for either method of connecting to the database?
>> Thanks in advance,
>>
>> Jordan
>>
>>
>>
>>
>> José Ventura-3 wrote:
>> >
>> > I believe that the startNetworkServer command uses an environment
>> variable
>> > DERBY_OPTS to hold additional properties. Try setting DERBY_OPTS=*-D*
>> > derby.system.home=/greenWorldDB and running the command again (without
>> the
>> > -derby.system.home part).
>> >
>> > Also, note the -D in front of the property name, as that is a Java
>> system
>> > property.
>> >
>> > Hope that helps...
>> >
>> > On Wed, Aug 1, 2012 at 2:50 PM, Jordan <mahstah@gmail.com> wrote:
>> >
>> >> Greetings all-
>> >>
>> >> I'm a new Derby user and am trying to recover a derby database from a
>> >> server that died that was set up by a co-worker who passed away as
>> well.
>> >> I
>> >> have the entire database set up on a new Fedora 17 server which
>> contains
>> >> the service.properties file and the log, tmp, and seg0 directories and
>> >> Derby is installed and configured properly with DERBY_HOME and
>> JAVA_HOME.
>> >>
>> >> I have read through some of the documentation on getting started but
>> seem
>> >> to be missing something basic. How do I start Derby from the terminal
>> and
>> >> point it to my database folder? I tried the below method but it didn't
>> >> work. How is the derby.system.home parameter entered while starting
>> the
>> >> database?
>> >>
>> >> [smartplant@SmartPlantWeb WEB-INF]$ startNetworkServer
>> >> -derby.system.home=/greenWorldDB
>> >> Wed Aug 01 13:38:03 EDT 2012 : Argument
>> -derby.system.home=/greenWorldDB
>> >> is unknown.
>> >>
>> >> Any tips would be appreciated. Thank you,
>> >>
>> >> Jordan
>> >>
>> >
>> >
>> --
>> View this message in context:
>> http://old.nabble.com/Starting-Derby-with-Database-tp34242141p34262881.html
>> Sent from the Apache Derby Users mailing list archive at Nabble.com.
>>
>>
> 
> 

-- 
View this message in context: http://old.nabble.com/Starting-Derby-with-Database-tp34242141p34262964.html
Sent from the Apache Derby Users mailing list archive at Nabble.com.


Mime
View raw message