Re: Derby Database Usage by OpenJMS

Serkan Dik <dik1ser@...> writes:

> 
> Hi All,
> 
> We have recently installed openjms-0.7.7-alpha-3. From the documents, we know 
> that Derby comes with this package and that it is used to store queue 
messages.
> 
> Though, when connecting to the Derby DB via SQuirrel SQL client, and browsing 
> through all the available schemas, we are are not able to find the tables 
that 
> store the messages we have placed on the queues ?
> 
> Can any one help with identifying the tables/schemas in Derby used by OpenJMS 
> to store queue messages ?
> 
> Cheers,
> Serkan
> 
> -------------------------------------------------------------------------
> Take Surveys. Earn Cash. Influence the Future of IT
> Join SourceForge.net's Techsay panel and you'll get the chance to share your
> opinions on IT & business topics through brief surveys -- and earn cash
> http://www.techsay.com/default.php?page=join.php&p=sourceforge&CID=DEVDEV
> 


Ok, reading through the other posts, and turning on derby logging, I can see 
that I am supposed to be able to query the Message_Handles and Messages table 
at the very least. Trouble is, i cant see any of these table names in any of 
the schemas shown to me via SQuirrel SQL client.

Help on this would be very appreciated.



-------------------------------------------------------------------------
Take Surveys. Earn Cash. Influence the Future of IT
Join SourceForge.net's Techsay panel and you'll get the chance to share your
opinions on IT & business topics through brief surveys -- and earn cash
http://www.techsay.com/default.php?page=join.php&p=sourceforge&CID=DEVDEV