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]
