Hi Ravi,
Tables will only be created by DBMSConnect when you define a DdsToDbms
mapping. The other way around, DBMSConnect will never create a table to read
from (nor a Topic to write to). Since you explicitly defined the mapping
(from lowercase to the case used in the topic), there must be another reason
reported in your log-file why DBMSConnect is not able to map the topic on
the table (if you restarted MySQL after reconfiguring).
What you could do to find the issue if it is not reported by DBMSConnect, is
define a mapping the other way around:
<DbmsConnectService name="dbmsconnect">
<*DdsToDbms*>
<NameSpace dsn="Spykar" name="ddstodbms" partition="*
ThePartitionInWhichYourHelloTopicLives*" *topic="HelloTopic"* pwd="root"
usr="root" />
</*DdsToDbms*>
</DbmsConnectService>
This will let DBMSConnect create a table that is compatible and you could
verify what is different with the table you are trying to use.
Please be aware that in the configuration you sent, the
partition="*"setting will cause the topic to be published in ALL
partitions, which is
quite certainly not what you are after.
With best regards,
Maurits
*Maurits de Jong*
Software Engineer
E-mail: maurits.dej...@prismtech.com <niels.kortstee>
Tele: +31-74-247-257-4
Web: www.prismtech.com
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.
On 23 June 2011 10:42, Ravi Chandran <ra...@analytica-india.com> wrote:
> hi Maurits,
> I had indeed added those specific lines to my.ini in MySQL installation
> folder. These are the lines which I changed::
>
> default-storage-engine=MyISAM
>
> sql-mode="ANSI,NO_BACKSLASH_ESCAPES"
>
> lower_case_table_names=2
>
> And regarding DCPS tables creation, what parameters do I need to specify
> for that? This is my current ospl.xml settings:
>
> <DbmsConnectService name="dbmsconnect">
> <DbmsToDds>
> <NameSpace dsn="Spykar" name="dbmstodds" partition="*" pwd="root"
> usr="root">
> <Mapping table="hellotopic" topic="HelloTopic"/>
> </NameSpace>
> </DbmsToDds>
> </DbmsConnectService>
>
> --
> Thanks & Regards
> Ravi
>
>
> _______________________________________________
> OpenSplice DDS Developer Mailing List
> Developer@opensplice.org
> Subscribe / Unsubscribe
> http://dev.opensplice.org/mailman/listinfo/developer
>
>
_______________________________________________
OpenSplice DDS Developer Mailing List
Developer@opensplice.org
Subscribe / Unsubscribe http://dev.opensplice.org/mailman/listinfo/developer
