Hi John , Your information helps a lot. Sorry for my unformatted message.
Thanks Raghunath N John Embretsen wrote: > > Raghunath wrote: >> Hi, >> I created my database from netbeans,by spcifying db location(All data >> will go to that directory). > > The "Database Location" setting available from the "Tools -> Java DB > Database -> > Settings" menu in Netbeans only has effect on the Network Server when > started > from the NetBeans utilities/menus. It does not affect embedded > connections, nor > Network Server instances started by other means (e.g. command line, > derbyrun.jar, Derby's Java API...). > >> Then I ran my application with 4 >> connection/80 connection. > > Not sure what this means.. Do you mean 4 threads, 80 connections? > >> After some time it's going outof memory. >> I analyzed that I can specify the -Xms jvm option in >> startNetworkServer.bat (Not sure wil it solve the problem) > > This will only have an effect if you are starting the Network Server using > that > script. If you start the server from NetBeans, it won't have any effect (I > don't > think you change the server's heap settings from NetBeans - yet). > > If you need to use custom heap settings for the Network Server JVM, I > recommend > you start it from the command line, e.g. by using derbyrun.jar, > > 'java -Xmx512m -Dderby.system.home=YourDatabaseLocation -jar > %DERBY_HOME%\lib\derbyrun.jar server start' > > This gives you full control over which settings your server VM is actually > running with. But there are several ways to do this, as you have > discovered. > >> And I want to rise my db (different directory location). > > Do you mean that you want to boot another database, at a different > location? > Or that you want to access your database even if your working directory is > different from the "Database location" setting in NetBeans? > Or something else? > >> thru ij im able >> to connect , but it's embeded connection manager i think >> ij> connect 'jdbc:derby:H:\My >> Dream\bb-jd-db\bb-jd-real-hyd;user=app;password=app;' >> but this time my application in failing to connect to the server. > > Yes, this is a URL for the embedded driver. This will not even attempt to > access > the server. If the path to the database is correct, you will be able to > connect > to the database only if the database exists and the same database is not > booted > by another JVM (e.g. the Network Server, or NetBeans). > > If the Network Server is running, you can access the database from IJ (and > NetBeans) by using the client driver and a matching URL, for example > > ij> connect 'jdbc:derby://localhost:1527/H:/My > Dream/bb-jd-db/bb-jd-real-hyd;user=app;password=app;' > > Note that you should use forward slashes as path separator in the > connection > URL, even on Windows. > > You can read more about URLs, embedded vs. client/server, database paths > etc. in > the manuals and in various other documents and tutorials. A good starting > page > is this: > > http://db.apache.org/derby/quick_start.html > >> But If i do the same from netbeans , the service is up and im able to >> connect to db..but it's withou jvm -xms option > > Then you are probably using the client driver from NetBeans. > > If you are running out of memory, make sure you release (close and set to > null) > all resources to the JVM when you are done using them, such as ResultSets, > Statements, PreparedStatements, Connections. > > If you post details about what kind of database operations lead to the > OutOfMemoryError, someone on this list may be able to assist as well. > > I hope this helps somewhat... > > -- > John > > > -- View this message in context: http://www.nabble.com/How-to-start-Derby-service-with-db-in-different-locatoin-tp15010871p15018895.html Sent from the Apache Derby Users mailing list archive at Nabble.com.
