Are you guys customers (as in that case, its best to go through our customer-support chain as that provides the progress you need .. )
Typically how to use DBMSConnect is explained in our courses ..
Quickly looking below: you should compare your ‘example’ with the
distributed example I guess…
Whats eminent is that you’re forgetting to use the ‘fully-qualified’
topic-name that incluees the module-name i.e. chattest_chatmsg rather than
just “chatmsg” (like for the included example the xml contains
Chat_ChatMessage to map on the chatroom IDL that contains the topics in
module Chat)
* *
*Hans van 't Hag*
OpenSplice DDS Product Manager
PrismTech Netherlands
Email: hans.vant...@prismtech.com
Tel: +31742472572
Fax: +31742472571
Gsm: +31624654078
PrismTech is a global leader in standards-based, performance-critical
middleware. Our products enable our OEM, Systems Integrator, and End User
customers to build and optimize high-performance systems primarily for
Mil/Aero, Communications, Industrial, and Financial Markets.
------------------------------
*From:* developer-boun...@opensplice.org [mailto:
developer-boun...@opensplice.org] *On Behalf Of *Ravi Chandran
*Sent:* Thursday, June 16, 2011 12:45 PM
*To:* OpenSplice DDS Developer Mailing List
*Subject:* Re: [OSPL-Dev] using DDS with DBMS
hi Hans,
I was working on that same issue, suddenly I am getting a new type of
error.. I have removed the odbc property. This is my current ospl config
setting for DBMSConnect::
<DbmsConnectService name="dbmsconnect">
<DbmsToDds publish_initial_data="false">
<NameSpace dsn="Spykar" partition="*" pwd="root" table="chatmsg"
usr="root">
<Mapping publish_initial_data="true" table="chatmsg"
topic="ChatTopic"/>
</NameSpace>
</DbmsToDds>
<Tracing>
<OutputFile>dbmsconnect.log</OutputFile>
</Tracing>
</DbmsConnectService>
This is the structure of my Database Table::
mysql> describe chatmsg;
+---------+-----------------------+------+-----+---------+-------+
| Field | Type | Null | Key | Default | Extra |
+---------+-----------------------+------+-----+---------+-------+
| userID | int(11) | NO | PRI | NULL | |
| content | varchar(6000) | YES | | NULL | |
| name | varchar(6000) | YES | | NULL | |
+---------+---------------+------+-----+---------+-------+
and this is the IDL file code ::
module chattest {
struct chatmsg
{
long userID;
string content;
string name;
};
#pragma keylist chatmsg userID
};
The error I am getting now is: OPERATIONAL (dbmsDataHandler) ->
Table 'chatmsg' could not be mapped to Topic .
I did not change anything other than removing ODBC property. What is
happening now? Why is the mapping not compatible here..?
--
Thanks & Regards
Ravi
<<image001.jpg>>
_______________________________________________ OpenSplice DDS Developer Mailing List Developer@opensplice.org Subscribe / Unsubscribe http://dev.opensplice.org/mailman/listinfo/developer
