- This topic has 19 replies, 5 voices, and was last updated 13 years, 11 months ago by
Brian Fernandes.
-
AuthorPosts
-
frankc01aMemberThis message has not been recovered.
November 12, 2007 at 10:44 am #278403
Loyal WaterMemberWhat plugin are you using ? What version of MyEclispe are you working with ? What exception is being thrown ?
November 13, 2007 at 1:13 pm #278504
frankc01aMemberFor the Plug-In I am using the Derby library that gets copied in with when I select adding Hibernate Capabilities via MyEclipse menu, or when I use the 10.3.1.4 libraries from the Derby distribution.
I am using MyEclipse 6.0.1
Here is the exception
Caused by: ERROR XSDB6: Another instance of Derby may have already booted the database C:\Program Files\MyEclipse 6.0.01\eclipse\scrach. at org.apache.derby.iapi.error.StandardException.newException(Unknown Source) at org.apache.derby.impl.store.raw.data.BaseDataFileFactory.privGetJBMSLockOnDB(Unknown Source) at org.apache.derby.impl.store.raw.data.BaseDataFileFactory.run(Unknown Source) at java.security.AccessController.doPrivileged(Native Method) at org.apache.derby.impl.store.raw.data.BaseDataFileFactory.getJBMSLockOnDB(Unknown Source) at org.apache.derby.impl.store.raw.data.BaseDataFileFactory.boot(Unknown Source) at org.apache.derby.impl.services.monitor.BaseMonitor.boot(Unknown Source) at org.apache.derby.impl.services.monitor.TopService.bootModule(Unknown Source) at org.apache.derby.impl.services.monitor.BaseMonitor.startModule(Unknown Source) at org.apache.derby.iapi.services.monitor.Monitor.bootServiceModule(Unknown Source) at org.apache.derby.impl.store.raw.RawStore.boot(Unknown Source) at org.apache.derby.impl.services.monitor.BaseMonitor.boot(Unknown Source) at org.apache.derby.impl.services.monitor.TopService.bootModule(Unknown Source) at org.apache.derby.impl.services.monitor.BaseMonitor.startModule(Unknown Source) at org.apache.derby.iapi.services.monitor.Monitor.bootServiceModule(Unknown Source) at org.apache.derby.impl.store.access.RAMAccessManager.boot(Unknown Source) at org.apache.derby.impl.services.monitor.BaseMonitor.boot(Unknown Source) at org.apache.derby.impl.services.monitor.TopService.bootModule(Unknown Source) at org.apache.derby.impl.services.monitor.BaseMonitor.startModule(Unknown Source) at org.apache.derby.iapi.services.monitor.Monitor.bootServiceModule(Unknown Source) at org.apache.derby.impl.db.BasicDatabase.bootStore(Unknown Source) at org.apache.derby.impl.db.BasicDatabase.boot(Unknown Source) at org.apache.derby.impl.services.monitor.BaseMonitor.boot(Unknown Source) at org.apache.derby.impl.services.monitor.TopService.bootModule(Unknown Source) at org.apache.derby.impl.services.monitor.BaseMonitor.bootService(Unknown Source) at org.apache.derby.impl.services.monitor.BaseMonitor.startProviderService(Unknown Source) at org.apache.derby.impl.services.monitor.BaseMonitor.findProviderAndStartService(Unknown Source) at org.apache.derby.impl.services.monitor.BaseMonitor.startPersistentService(Unknown Source) at org.apache.derby.iapi.services.monitor.Monitor.startPersistentService(Unknown Source)
Thanks
FrankNovember 14, 2007 at 3:11 am #278530
Loyal WaterMemberCaused by: ERROR XSDB6: Another instance of Derby may have already booted the database
The error suggests there is more than one instance of the server running at the same time.
Here is a doc that provides a solution to this. Hope it helps.
http://db.apache.org/derby/docs/dev/devguide/cdevdvlp20458.htmlNovember 14, 2007 at 9:03 pm #278589
frankc01aMemberThis just confirms what I already knew about the limitations of “non-server” usage of Derby.
My question is that when I “Close the Connection” from MyEclipse DBE, shouldn’t it be closing and shutting down the database for use? Is that a defect?
November 15, 2007 at 3:41 am #278608
Loyal WaterMemberMy question is that when I “Close the Connection” from MyEclipse DBE, shouldn’t it be closing and shutting down the database for use? Is that a defect?
It does shutdown the database. Are you facing any problem with “Closing the Connection” ?
Can you switch to a new worksapce and start Opening and Closing the connection again. Do you still face the same issue ?
November 15, 2007 at 7:52 am #278615
frankc01aMemberIf it shuts down the database, don’t you think the exception I posted above would be avoided?
Again: My plug-in (it’s an RCP app) runs fine now matter how many times I run it from within MyEclipse (Run, Debug). Once I use the DBE though, the only way I can recover is by shutting MyEclipse down and restarting it.
Here is the driver that MyEclipse uses:
<!-- MyEclipse Database Explorer Driver Repository --> <Beans version="1.0"> <Bean Class="net.sourceforge.squirrel_sql.fw.sql.SQLDriver"> <driverClassName>org.apache.derby.jdbc.EmbeddedDriver</driverClassName> <identifier Class="net.sourceforge.squirrel_sql.fw.id.UidIdentifier"> <string>20543c5a:11638b689c3:-7ee0</string> </identifier> <jarFileName/> <jarFileNames Indexed="true"> <Bean Class="net.sourceforge.squirrel_sql.fw.util.beanwrapper.StringWrapper"> <string>C:\temp\db-derby-10.3.1.4-lib\db-derby-10.3.1.4-lib\lib\derby.jar</string> </Bean> </jarFileNames> <name>MyEclipseDriverName012</name> <url>jdbc:derby:homeword;create=true</url> </Bean> <Bean Class="com.genuitec.eclipse.sqlexplorer.utils.ConnectionProfile"> <activate>false</activate> <driverIdentifier Class="net.sourceforge.squirrel_sql.fw.id.UidIdentifier"> <string>20543c5a:11638b689c3:-7ee0</string> </driverIdentifier> <identifier Class="net.sourceforge.squirrel_sql.fw.id.UidIdentifier"> <string>-2ecad9dd:116176ede2d:-7f93</string> </identifier> <name>HomewordDerby</name> <password encryption="true">Dws6fKz0xxVc2yJVjw4IiQ==</password> <promptForPassword>false</promptForPassword> <schema Indexed="true"> <Bean Class="net.sourceforge.squirrel_sql.fw.util.beanwrapper.StringWrapper"> <string>APP</string> </Bean> </schema> <schemaDisplayPolicy>2</schemaDisplayPolicy> <url>jdbc:derby:homeword;create=true</url> <userName>Homeword</userName> </Bean> </Beans>
Thanks, Frank
November 22, 2007 at 4:57 am #278881
frankc01aMemberHello?
November 22, 2007 at 11:15 am #278900
Loyal WaterMemberFrank,
Im extremely sorry for the delay on this one. I some how didnt receive the notification mail when you replied.Im not really sure whats wrong here. Maybe the plugin has gone bad. You can try cleaning your workspace using the -clean command and see if that helps:-
https://www.genuitec.com/forums/topic/troubleshoot-using-the-clean-command-line-argument/November 25, 2007 at 6:10 am #278937
frankc01aMemberNo, that didn’t help at all.
By the way, both the RCP app and MyEclipse Data Explorer are using the same driver (not concurrently) which is 10.3.1.4 and I have them both set to use the embedded driver.
This is really a productivity hit, is there anything you can look at?
November 28, 2007 at 11:58 am #279091
Riyad KallaMemberThis message has not been recovered.
November 28, 2007 at 6:12 pm #279111
frankc01aMemberThis message has not been recovered.
November 30, 2007 at 1:53 pm #279202
Riyad KallaMemberThis message has not been recovered.
December 3, 2007 at 2:40 pm #279301
frankc01aMemberThis message has not been recovered.
December 3, 2007 at 3:18 pm #279305
Riyad KallaMemberThis message has not been recovered.
-
AuthorPosts