neuna <[EMAIL PROTECTED]> writes: > Hi, in my java app i want to set up a complete derby database, but after i > set the properties (e.g. sqlAuthorization) i have to reboot the server to > grant rights with the SQL command "GRANT". > But for some reason, it doesn't work if i use the simple methods > derbyServer.shutdown(); > and > derbyServer.start(null); > If i use this to reboot the server, i can't grant rights (it says GRANT not > allowed unless database property derby.database.sqlAuthorization has value > 'TRUE'., although derby.database.sqlAuthorization definately has the value > 'TRUE' !) > > What can i do, to restart the database properly? Thx in advance for any > help!
I am not sure, but perhaps your database was not correctly shut down cleanly when you shut down the server (there have been some corner cases where that didn't happen, although I thought it did not apply in this case). Does it make a difference if you shut down the database before you shut down the server? Which version of Derby are you using? How do you set the properties? > > -- > View this message in context: > http://www.nabble.com/Rebooting-derby-within-a-java-app-tp18437879p18437879.html > Sent from the Apache Derby Users mailing list archive at Nabble.com. > > > -- Dag H. Wanvik, staff engineer Sun Microsystems, Databases (JavaDB/Derby) Haakon VII gt. 7b, N-7485 Trondheim, Norway Tel: x43496/+47 73842196, Fax: +47 73842101
