It works, thanks. However, it seems a bit weird that the broker takes on itself to create the Database (I'm not talking about the tables). I think there should be a way to initialize a database that was created manually.
Cheers, Julien -----Message d'origine----- De : Steve Huston [mailto:[email protected]] Envoyé : lundi 20 septembre 2010 13:33 À : [email protected] Objet : RE: MS SQL store Hmmm... Your SQL version is ok. Can you try deleting the QpidStore database from the SQL Management studio and then re-run the broker? That is, if you don't have anything important in the store. -Steve -- Steve Huston, Riverace Corporation Total Lifecycle Support for Your Networked Applications http://www.riverace.com > -----Original Message----- > From: Julien Lavigne du Cadet > [mailto:[email protected]] > Sent: Monday, September 20, 2010 7:09 AM > To: [email protected] > Subject: RE: MS SQL store > > > Then I have the following error : > > "2010-09-20 13:07:35 notice MSSQL: Database located: > QpidStore 2010-09-20 13:07:35 info MS SQL Provider is up > > This application has requested the Runtime to terminate it in > an unusual way. Please contact the application's support team > for more information." > > > > Looking at the sql server profiler, it happens after this > statement is executed : > > exec sp_executesql N' > DECLARE @is_policy_automation_enabled bit > SET @is_policy_automation_enabled = (SELECT > CONVERT(bit, current_value) > FROM > msdb.dbo.syspolicy_configuration > WHERE name = > ''Enabled'') > > > > SELECT > ''serv...@name='' + quotename(CAST( > serverproperty(N''Servername'') > AS sysname),'''''''') + '']'' + ''/databa...@name='' + > quotename(db_name(),'''''''') + '']'' + ''/tab...@name='' + > quotename(tbl.name,'''''''') + '' and @Schema='' + > quotename(SCHEMA_NAME(tbl.schema_id),'''''''') + '']'' AS > [Urn], tbl.name AS [Name], > SCHEMA_NAME(tbl.schema_id) AS [Schema], > CAST( > case > when tbl.is_ms_shipped = 1 then 1 > when ( > select > major_id > from > sys.extended_properties > where > major_id = tbl.object_id and > minor_id = 0 and > class = 1 and > name = N''microsoft_database_tools_support'') > is not null then 1 > else 0 > end > AS bit) AS [IsSystemObject], > tbl.create_date AS [CreateDate], > ISNULL(stbl.name, N'''') AS [Owner], > case when 1...@is_policy_automation_enabled and exists (select > * from msdb.dbo.syspolicy_system_health_state where > target_query_expression_with_id like ''Server'' + > ''/databas...@id='' + convert(nvarchar(20),dtb.database_id) + > ''\]''+ ''/tabl...@id='' + > convert(nvarchar(20),tbl.object_id) + ''\]%'' ESCAPE ''\'') > then 1 else 0 end AS [PolicyHealthState] FROM > master.sys.databases AS dtb, sys.tables AS tbl LEFT OUTER > JOIN sys.database_principals AS stbl ON stbl.principal_id = > ISNULL(tbl.principal_id, (OBJECTPROPERTY(tbl.object_id, > ''OwnerId''))) WHERE (CAST( case > when tbl.is_ms_shipped = 1 then 1 > when ( > select > major_id > from > sys.extended_properties > where > major_id = tbl.object_id and > minor_id = 0 and > class = 1 and > name = N''microsoft_database_tools_support'') > is not null then 1 > else 0 > end > AS > bit)=...@_msparam_0)and((db_name()=...@_msparam_1)and(dtb.name=db_name())) > ORDER BY > [Schema] ASC,[Name] ASC',N'@_msparam_0 > nvarchar(4000),@_msparam_1 > nvarchar(4000)',@_msparam_0=N'0',@_msparam_1=N'QpidStore' > > > A few more information: > > - The broker is running on Windows XP Pro x64 > - The broker is working if I don't enable the SQL Server store > - I'm using SQL Server 2008 dev edition and not SQL Server > Express (but I don't see why it would matter) > > Any ideas? > > Cheers, > > Julien > > -----Message d'origine----- > De : Steve Huston [mailto:[email protected]] > Envoyé : lundi 20 septembre 2010 12:56 > À : [email protected] > Objet : RE: MS SQL store > > Hi Julien, > > > I'm trying to set up qpid with a MS SQL store but I can't > > find the schema for the tables. Can someone point me at some > > documentation to initialize the database please? > > The store module initializes the database when it starts. To > get the options for the store, run the broker to load the > modules and specify --help. > > -Steve > > -- > Steve Huston, Riverace Corporation > Total Lifecycle Support for Your Networked Applications > http://www.riverace.com > > > --------------------------------------------------------------------- > Apache Qpid - AMQP Messaging Implementation > Project: http://qpid.apache.org > Use/Interact: mailto:[email protected] > > > P Please consider your environmental responsibility before > printing this email > > ************************************************************** > ******************* > Ce message peut contenir des informations confidentielles. > Les idees et opinions presentees dans ce message > sont celles de son auteur, et ne representent pas > necessairement celles du groupe ABC arbitrage. Au cas ou il > ne vous serait pas destine, merci d'en aviser l'expediteur > immediatement et de le supprimer. > > This message may contain confidential information. > Any views or opinions presented are solely those of its author > and do not necessarily represent those of ABC arbitrage. > If you are not the intended recipient, > please notify the sender immediately and delete it. > ************************************************************** > ******************* > > > --------------------------------------------------------------------- > Apache Qpid - AMQP Messaging Implementation > Project: http://qpid.apache.org > Use/Interact: mailto:[email protected] > > --------------------------------------------------------------------- Apache Qpid - AMQP Messaging Implementation Project: http://qpid.apache.org Use/Interact: mailto:[email protected] P Please consider your environmental responsibility before printing this email ********************************************************************************* Ce message peut contenir des informations confidentielles. Les idees et opinions presentees dans ce message sont celles de son auteur, et ne representent pas necessairement celles du groupe ABC arbitrage. Au cas ou il ne vous serait pas destine, merci d'en aviser l'expediteur immediatement et de le supprimer. This message may contain confidential information. Any views or opinions presented are solely those of its author and do not necessarily represent those of ABC arbitrage. If you are not the intended recipient, please notify the sender immediately and delete it. ********************************************************************************* --------------------------------------------------------------------- Apache Qpid - AMQP Messaging Implementation Project: http://qpid.apache.org Use/Interact: mailto:[email protected]
