[OSPL-Dev] using DDS with DBMS

[Ravi Chandran]

hi all,
I wanted to learn DDS- DBMS interaction. I saw the DBMSConnectService
property in PDF, but i did not find any example or any description about it.
Do we have any example for DDS to DBMS and DBMS to DDS interation?

[Hans van't Hag]

Hi Ravi,



The DBMSConnect service is extensively described in the deployment guide
(chapter 2).

Also, there?s a chatroom-based example of it under
examples/services/dbmsconnect in the distribution



Regards,

Hans





* *

*Hans van 't Hag*

OpenSplice DDS Product Manager

PrismTech Netherlands

Email: hans.vanthag at prismtech.com

Tel: [phone]

Fax: [phone]

Gsm: [phone]



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-bounces at opensplice.org [mailto:
developer-bounces at opensplice.org] *On Behalf Of *Ravi Chandran
*Sent:* Thursday, June 16, 2011 10:31 AM
*To:* OpenSplice DDS Developer Mailing List
*Subject:* [OSPL-Dev] using DDS with DBMS



hi all,

I wanted to learn DDS- DBMS interaction. I saw the DBMSConnectService
property in PDF, but i did not find any example or any description about it.
Do we have any example for DDS to DBMS and DBMS to DDS interation?
--
Thanks & Regards

Ravi
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://dev.opensplice.org/pipermail/developer/attachments/20110616/feed984a/attachment.htm>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: not available
Type: image/jpeg
Size: 3349 bytes
Desc: not available
URL: <Loading Image...>

[Ravi Chandran]

Thanks for replying. I wanted to know one more thing. If I want to use
DBMSConnectService, how should I add it in ospl.xml using Opensplice
Configurator? I was unable to find any direct option for it. I tried right
click on Domain, I clicked on Service, but it added Durability Service
automatically. How should I add the DBMSConnect Service? Do we have to add
it from edit option?

[Hans van't Hag]

Hi Ravi,



First you need to have an edition that includes the service (so either a
commercial- or a commercial-trial edition).

Then if you for instance edit the ?default? configuration xml-file, you add
the dbmsconnect service like this:





And then you configure its parameters .. there?s an xml-file example
proviced under services/examples/dbmsconnect/dbmsconnect.xml that already
contains a setup that looks like this when opened with the configurator:







Hope this helps,


Thanks,

Hans





* *

*Hans van 't Hag*

OpenSplice DDS Product Manager

PrismTech Netherlands

Email: hans.vanthag at prismtech.com

Tel: [phone]

Fax: [phone]

Gsm: [phone]



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-bounces at opensplice.org [mailto:
developer-bounces at opensplice.org] *On Behalf Of *Ravi Chandran
*Sent:* Thursday, June 16, 2011 11:19 AM
*To:* OpenSplice DDS Developer Mailing List
*Subject:* Re: [OSPL-Dev] using DDS with DBMS



Thanks for replying. I wanted to know one more thing. If I want to use
DBMSConnectService, how should I add it in ospl.xml using Opensplice
Configurator? I was unable to find any direct option for it. I tried right
click on Domain, I clicked on Service, but it added Durability Service
automatically. How should I add the DBMSConnect Service? Do we have to add
it from edit option?
--
Thanks & Regards

Ravi
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://dev.opensplice.org/pipermail/developer/attachments/20110616/e6a7def3/attachment.htm>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: not available
Type: image/jpeg
Size: 89501 bytes
Desc: not available
URL: <Loading Image...>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: not available
Type: image/jpeg
Size: 96962 bytes
Desc: not available
URL: <Loading Image...>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: not available
Type: image/jpeg
Size: 3349 bytes
Desc: not available
URL: <Loading Image...>

[Ravi Chandran]

Thanks a lot. I will start working on this.

[Hans van't Hag]

Don?t forget to checkout the README of the DBMSConnect example
(eamples/services/dbmsconnect/SQL/C++/ODBC/README.txt):



This example is based on the Chatter and MessageBoard from the

DCPS Tutorial. It contains SQL versions of these two applications that

communicate with any ODBC-enabled database system. This example will show
that

these applications can communicate with their DDS equivalents by using the

DBMSConnect service.



The example requires the following to be available on your system:

- An ODBC-enabled database system

- A configured dsn (Data Source Name). This can be configured by selecting

Start > All Programs > Administrative Tools > Data Sources (ODBC)



The example is delivered with a special OpenSplice configuration file:



$OSPL_HOME/examples/dbmsconnect/dbmsconnect.xml



This file also holds the configuration of the OpenSplice DBMSConnect service

for this example. It assumes a dsn (Data Source Name) to be available with

the following properties:

- name : 'my_dsn'

- user name : 'SYSTEM'

- password : 'SYSTEM'



Please setup a DSN with these properties on your system or change the
settings

in the dbmsconnect.xml configuration file to match a DSN to your liking.



The SQL Chatter and MessageBoard executables require some command-line

parameters. The parameters and their meaning are specified below:



Chatter [dsn] [dsnuser] [dsnpwd] [userid] [username]

dsn: a Data Source Name that identifies the ODBC connection with the

database. Make sure this dsn is configured on your system before

running the example.

dsnuser: the username to use for connecting to the dsn. Make sure the

username is configured for the dsn before running the example.

dsnpwd: the password to use for connection to the dsn. Make sure the

password is configured for the dsnuser before running the
example.

userid: an integer number that uniquely identifies the sender of a
message

(Transmit a message with userid = -1 to terminate the
MessageBoard.)

username: the user-name other chatters will see when they receive one of
your

chat messages.



MessageBoard [dsn] [dsnuser] [dsnpwd]

dsn: a data source name that identifies the ODBC connection with the

database. Make sure this dsn is configured on your system before

running the example.

dsnuser: the username to use for connecting to the dsn. Make sure the

username is configured for the dsn before running the example.

dsnpwd: the password to use for connection to the dsn. Make sure the

password is configured for the dsnuser before running the
example.



Finally, when you?re daring enough to add all dbmsconnect settings yourself
(preferably using the configurator tool), don?t forget to add the service to
the domainConfiguration so that the ?total? xml-file will look something
like:









Note also that I?ve changed the <Verbosity> tag to ?CONFIG? rather than
?FINEST? (as that can create rather big log-files.



Thanks,

Hans







* *

*Hans van 't Hag*

OpenSplice DDS Product Manager

PrismTech Netherlands

Email: hans.vanthag at prismtech.com

Tel: [phone]

Fax: [phone]

Gsm: [phone]



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-bounces at opensplice.org [mailto:
developer-bounces at opensplice.org] *On Behalf Of *Ravi Chandran
*Sent:* Thursday, June 16, 2011 11:35 AM
*To:* OpenSplice DDS Developer Mailing List
*Subject:* Re: [OSPL-Dev] using DDS with DBMS



Thanks a lot. I will start working on this.
--
Thanks & Regards

Ravi
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://dev.opensplice.org/pipermail/developer/attachments/20110616/a5039ddb/attachment.htm>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: not available
Type: image/jpeg
Size: 101807 bytes
Desc: not available
URL: <Loading Image...>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: not available
Type: image/jpeg
Size: 3349 bytes
Desc: not available
URL: <Loading Image...>

[Ravi Chandran]

hi Hans,
I am actually working in Java. But things will be same i guess. I am trying
the same Chat example. I have configured the params as you gave. I had added
ODBC value = odbc ( I dont know what value is supposed to come here
exactly). When I start OSPL, I am getting this in the dbmsconnect.log::

INIT (dbmsConnectionOdbc) -> Unable to load ODBC library 'odbc'.


I have installed Mysql ODBC 5.1 ... What value should I put in ODBC?

[Ravi Chandran]

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..?

[Hans van't Hag]

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.vanthag at prismtech.com

Tel: [phone]

Fax: [phone]

Gsm: [phone]



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-bounces at opensplice.org [mailto:
developer-bounces at 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
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://dev.opensplice.org/pipermail/developer/attachments/20110616/621c2d35/attachment.htm>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: not available
Type: image/jpeg
Size: 3349 bytes
Desc: not available
URL: <Loading Image...>

[Ravi Chandran]

hi Hans,
I did not see any example for dbmsconnect.. In which version is it
available? Is it in windows version also? also i am getting more elaborative
error now....

OPERATIONAL (dbmsConnectionOdbc) -> db_dbmsConnectionOdbcSQLExecDirect:
SQLSTATE: 42S22, native error: 1054, diagnostics: [MySQL][ODBC 5.1
Driver][mysqld-5.1.56-community]Unknown column
'parentMsg.senderAddress.lifecycl' in 'NEW'.

OPERATIONAL (dbmsConnectionOdbc) -> db_dbmsConnectionOdbcSQLExecDirect:
SQLSTATE: HY000, native error: 1360, diagnostics: [MySQL][ODBC 5.1
Driver][mysqld-5.1.56-community]Trigger does not exist.

OPERATIONAL (dbmsConnectionOdbc) -> db_dbmsConnectionOdbcSQLExecDirect:
SQLSTATE: 42S22, native error: 1054, diagnostics: [MySQL][ODBC 5.1
Driver][mysqld-5.1.56-community]Unknown column
'parentMsg.senderAddress.lifecycl' in 'NEW'.

OPERATIONAL (dbmsConnectionOdbc) ->
db_dbmsConnectionOdbcSQLExecDirect: SQLSTATE: 42S22, native error: 1054,
diagnostics: [MySQL][ODBC 5.1 Driver][mysqld-5.1.56-community]Unknown column
'parentMsg.senderAddress.lifecycl' in 'NEW'.

OPERATIONAL (dbmsConnectionOdbc) ->
db_dbmsConnectionOdbcSQLExecDirect: SQLSTATE: HY000, native error: 1360,
diagnostics: [MySQL][ODBC 5.1 Driver][mysqld-5.1.56-community]Trigger does
not exist.

OPERATIONAL (dbmsConnectionOdbc) ->
db_dbmsConnectionOdbcSQLExecDirect: SQLSTATE: 42S22, native error: 1054,
diagnostics: [MySQL][ODBC 5.1 Driver][mysqld-5.1.56-community]Unknown column
'parentMsg.senderAddress.lifecycl' in 'NEW'.

OPERATIONAL (dbmsConnectionOdbc) ->
db_dbmsConnectionOdbcSQLExecDirect: SQLSTATE: 42S22, native error: 1054,
diagnostics: [MySQL][ODBC 5.1 Driver][mysqld-5.1.56-community]Unknown column
'parentMsg.senderAddress.lifecycl' in 'OLD'.

OPERATIONAL (dbmsConnectionOdbc) ->
db_dbmsConnectionOdbcSQLExecDirect: SQLSTATE: HY000, native error: 1360,
diagnostics: [MySQL][ODBC 5.1 Driver][mysqld-5.1.56-community]Trigger does
not exist.

OPERATIONAL (dbmsConnectionOdbc) ->
db_dbmsConnectionOdbcSQLExecDirect: SQLSTATE: 42S22, native error: 1054,
diagnostics: [MySQL][ODBC 5.1 Driver][mysqld-5.1.56-community]Unknown column
'parentMsg.senderAddress.lifecycl' in 'OLD'.

Is this because of naming convention? I doubt that..

[Hans van't Hag]

Its in any commercial/trial edition (that supports dbmsConnect) , like for
5.5_on_windows its in:

C:\Program
Files\PrismTech\OpenSpliceDDS\V5.5.0\HDE\x86.win32\examples\services\dbmsconnect





* *

*Hans van 't Hag*

OpenSplice DDS Product Manager

PrismTech Netherlands

Email: hans.vanthag at prismtech.com

Tel: [phone]

Fax: [phone]

Gsm: [phone]



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-bounces at opensplice.org [mailto:
developer-bounces at opensplice.org] *On Behalf Of *Ravi Chandran
*Sent:* Thursday, June 16, 2011 1:50 PM
*To:* OpenSplice DDS Developer Mailing List
*Subject:* Re: [OSPL-Dev] using DDS with DBMS



hi Hans,

I did not see any example for dbmsconnect.. In which version is it
available? Is it in windows version also? also i am getting more elaborative
error now....



OPERATIONAL (dbmsConnectionOdbc) -> db_dbmsConnectionOdbcSQLExecDirect:
SQLSTATE: 42S22, native error: 1054, diagnostics: [MySQL][ODBC 5.1
Driver][mysqld-5.1.56-community]Unknown column
'parentMsg.senderAddress.lifecycl' in 'NEW'.



OPERATIONAL (dbmsConnectionOdbc) -> db_dbmsConnectionOdbcSQLExecDirect:
SQLSTATE: HY000, native error: 1360, diagnostics: [MySQL][ODBC 5.1
Driver][mysqld-5.1.56-community]Trigger does not exist.



OPERATIONAL (dbmsConnectionOdbc) -> db_dbmsConnectionOdbcSQLExecDirect:
SQLSTATE: 42S22, native error: 1054, diagnostics: [MySQL][ODBC 5.1
Driver][mysqld-5.1.56-community]Unknown column
'parentMsg.senderAddress.lifecycl' in 'NEW'.



OPERATIONAL (dbmsConnectionOdbc) ->
db_dbmsConnectionOdbcSQLExecDirect: SQLSTATE: 42S22, native error: 1054,
diagnostics: [MySQL][ODBC 5.1 Driver][mysqld-5.1.56-community]Unknown column
'parentMsg.senderAddress.lifecycl' in 'NEW'.



OPERATIONAL (dbmsConnectionOdbc) ->
db_dbmsConnectionOdbcSQLExecDirect: SQLSTATE: HY000, native error: 1360,
diagnostics: [MySQL][ODBC 5.1 Driver][mysqld-5.1.56-community]Trigger does
not exist.



OPERATIONAL (dbmsConnectionOdbc) ->
db_dbmsConnectionOdbcSQLExecDirect: SQLSTATE: 42S22, native error: 1054,
diagnostics: [MySQL][ODBC 5.1 Driver][mysqld-5.1.56-community]Unknown column
'parentMsg.senderAddress.lifecycl' in 'NEW'.



OPERATIONAL (dbmsConnectionOdbc) ->
db_dbmsConnectionOdbcSQLExecDirect: SQLSTATE: 42S22, native error: 1054,
diagnostics: [MySQL][ODBC 5.1 Driver][mysqld-5.1.56-community]Unknown column
'parentMsg.senderAddress.lifecycl' in 'OLD'.



OPERATIONAL (dbmsConnectionOdbc) ->
db_dbmsConnectionOdbcSQLExecDirect: SQLSTATE: HY000, native error: 1360,
diagnostics: [MySQL][ODBC 5.1 Driver][mysqld-5.1.56-community]Trigger does
not exist.



OPERATIONAL (dbmsConnectionOdbc) ->
db_dbmsConnectionOdbcSQLExecDirect: SQLSTATE: 42S22, native error: 1054,
diagnostics: [MySQL][ODBC 5.1 Driver][mysqld-5.1.56-community]Unknown column
'parentMsg.senderAddress.lifecycl' in 'OLD'.



Is this because of naming convention? I doubt that..
--
Thanks & Regards

Ravi
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://dev.opensplice.org/pipermail/developer/attachments/20110616/4a4b5acf/attachment.htm>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: not available
Type: image/jpeg
Size: 3349 bytes
Desc: not available
URL: <Loading Image...>

[Ravi Chandran]

Thanks. And the cause of error which I showed you?

On Thu, Jun 16, 2011 at 5:27 PM, Hans van't Hag

Post by Hans van't Hag
Its in any commercial/trial edition (that supports dbmsConnect) , like
C:\Program
Files\PrismTech\OpenSpliceDDS\V5.5.0\HDE\x86.win32\examples\services\dbmsconnect
* *
*Hans van 't Hag*
OpenSplice DDS Product Manager
PrismTech Netherlands
Email: hans.vanthag at prismtech.com
Tel: [phone]
Fax: [phone]
Gsm: [phone]
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.
------------------------------
developer-bounces at opensplice.org] *On Behalf Of *Ravi Chandran
*Sent:* Thursday, June 16, 2011 1:50 PM
*To:* OpenSplice DDS Developer Mailing List
*Subject:* Re: [OSPL-Dev] using DDS with DBMS
hi Hans,
I did not see any example for dbmsconnect.. In which version is it
available? Is it in windows version also? also i am getting more elaborative
error now....
OPERATIONAL (dbmsConnectionOdbc) ->
db_dbmsConnectionOdbcSQLExecDirect: SQLSTATE: 42S22, native error: 1054,
diagnostics: [MySQL][ODBC 5.1 Driver][mysqld-5.1.56-community]Unknown column
'parentMsg.senderAddress.lifecycl' in 'NEW'.
OPERATIONAL (dbmsConnectionOdbc) ->
db_dbmsConnectionOdbcSQLExecDirect: SQLSTATE: HY000, native error: 1360,
diagnostics: [MySQL][ODBC 5.1 Driver][mysqld-5.1.56-community]Trigger does
not exist.
OPERATIONAL (dbmsConnectionOdbc) ->
db_dbmsConnectionOdbcSQLExecDirect: SQLSTATE: 42S22, native error: 1054,
diagnostics: [MySQL][ODBC 5.1 Driver][mysqld-5.1.56-community]Unknown column
'parentMsg.senderAddress.lifecycl' in 'NEW'.
OPERATIONAL (dbmsConnectionOdbc) ->
db_dbmsConnectionOdbcSQLExecDirect: SQLSTATE: 42S22, native error: 1054,
diagnostics: [MySQL][ODBC 5.1 Driver][mysqld-5.1.56-community]Unknown column
'parentMsg.senderAddress.lifecycl' in 'NEW'.
OPERATIONAL (dbmsConnectionOdbc) ->
db_dbmsConnectionOdbcSQLExecDirect: SQLSTATE: HY000, native error: 1360,
diagnostics: [MySQL][ODBC 5.1 Driver][mysqld-5.1.56-community]Trigger does
not exist.
OPERATIONAL (dbmsConnectionOdbc) ->
db_dbmsConnectionOdbcSQLExecDirect: SQLSTATE: 42S22, native error: 1054,
diagnostics: [MySQL][ODBC 5.1 Driver][mysqld-5.1.56-community]Unknown column
'parentMsg.senderAddress.lifecycl' in 'NEW'.
OPERATIONAL (dbmsConnectionOdbc) ->
db_dbmsConnectionOdbcSQLExecDirect: SQLSTATE: 42S22, native error: 1054,
diagnostics: [MySQL][ODBC 5.1 Driver][mysqld-5.1.56-community]Unknown column
'parentMsg.senderAddress.lifecycl' in 'OLD'.
OPERATIONAL (dbmsConnectionOdbc) ->
db_dbmsConnectionOdbcSQLExecDirect: SQLSTATE: HY000, native error: 1360,
diagnostics: [MySQL][ODBC 5.1 Driver][mysqld-5.1.56-community]Trigger does
not exist.
OPERATIONAL (dbmsConnectionOdbc) ->
db_dbmsConnectionOdbcSQLExecDirect: SQLSTATE: 42S22, native error: 1054,
diagnostics: [MySQL][ODBC 5.1 Driver][mysqld-5.1.56-community]Unknown column
'parentMsg.senderAddress.lifecycl' in 'OLD'.
Is this because of naming convention? I doubt that..
--
Thanks & Regards
Ravi
_______________________________________________
OpenSplice DDS Developer Mailing List
Developer at opensplice.org
Subscribe / Unsubscribe
http://dev.opensplice.org/mailman/listinfo/developer

[Hans van't Hag]

I?m out of time right now .. do you have a support contract with us ?



* *

*Hans van 't Hag*

OpenSplice DDS Product Manager

PrismTech Netherlands

Email: hans.vanthag at prismtech.com

Tel: [phone]

Fax: [phone]

Gsm: [phone]



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-bounces at opensplice.org [mailto:
developer-bounces at opensplice.org] *On Behalf Of *Ravi Chandran
*Sent:* Thursday, June 16, 2011 2:00 PM
*To:* OpenSplice DDS Developer Mailing List
*Subject:* Re: [OSPL-Dev] using DDS with DBMS



Thanks. And the cause of error which I showed you?

On Thu, Jun 16, 2011 at 5:27 PM, Hans van't Hag <hans.vanthag at prismtech.com>
wrote:

Its in any commercial/trial edition (that supports dbmsConnect) , like for
5.5_on_windows its in:

C:\Program
Files\PrismTech\OpenSpliceDDS\V5.5.0\HDE\x86.win32\examples\services\dbmsconnect





* *

*Hans van 't Hag*

OpenSplice DDS Product Manager

PrismTech Netherlands

Email: hans.vanthag at prismtech.com

Tel: [phone]

Fax: [phone]

Gsm: [phone]



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-bounces at opensplice.org [mailto:
developer-bounces at opensplice.org] *On Behalf Of *Ravi Chandran
*Sent:* Thursday, June 16, 2011 1:50 PM


*To:* OpenSplice DDS Developer Mailing List
*Subject:* Re: [OSPL-Dev] using DDS with DBMS



hi Hans,

I did not see any example for dbmsconnect.. In which version is it
available? Is it in windows version also? also i am getting more elaborative
error now....



OPERATIONAL (dbmsConnectionOdbc) -> db_dbmsConnectionOdbcSQLExecDirect:
SQLSTATE: 42S22, native error: 1054, diagnostics: [MySQL][ODBC 5.1
Driver][mysqld-5.1.56-community]Unknown column
'parentMsg.senderAddress.lifecycl' in 'NEW'.



OPERATIONAL (dbmsConnectionOdbc) -> db_dbmsConnectionOdbcSQLExecDirect:
SQLSTATE: HY000, native error: 1360, diagnostics: [MySQL][ODBC 5.1
Driver][mysqld-5.1.56-community]Trigger does not exist.



OPERATIONAL (dbmsConnectionOdbc) -> db_dbmsConnectionOdbcSQLExecDirect:
SQLSTATE: 42S22, native error: 1054, diagnostics: [MySQL][ODBC 5.1
Driver][mysqld-5.1.56-community]Unknown column
'parentMsg.senderAddress.lifecycl' in 'NEW'.



OPERATIONAL (dbmsConnectionOdbc) ->
db_dbmsConnectionOdbcSQLExecDirect: SQLSTATE: 42S22, native error: 1054,
diagnostics: [MySQL][ODBC 5.1 Driver][mysqld-5.1.56-community]Unknown column
'parentMsg.senderAddress.lifecycl' in 'NEW'.



OPERATIONAL (dbmsConnectionOdbc) ->
db_dbmsConnectionOdbcSQLExecDirect: SQLSTATE: HY000, native error: 1360,
diagnostics: [MySQL][ODBC 5.1 Driver][mysqld-5.1.56-community]Trigger does
not exist.



OPERATIONAL (dbmsConnectionOdbc) ->
db_dbmsConnectionOdbcSQLExecDirect: SQLSTATE: 42S22, native error: 1054,
diagnostics: [MySQL][ODBC 5.1 Driver][mysqld-5.1.56-community]Unknown column
'parentMsg.senderAddress.lifecycl' in 'NEW'.



OPERATIONAL (dbmsConnectionOdbc) ->
db_dbmsConnectionOdbcSQLExecDirect: SQLSTATE: 42S22, native error: 1054,
diagnostics: [MySQL][ODBC 5.1 Driver][mysqld-5.1.56-community]Unknown column
'parentMsg.senderAddress.lifecycl' in 'OLD'.



OPERATIONAL (dbmsConnectionOdbc) ->
db_dbmsConnectionOdbcSQLExecDirect: SQLSTATE: HY000, native error: 1360,
diagnostics: [MySQL][ODBC 5.1 Driver][mysqld-5.1.56-community]Trigger does
not exist.



OPERATIONAL (dbmsConnectionOdbc) ->
db_dbmsConnectionOdbcSQLExecDirect: SQLSTATE: 42S22, native error: 1054,
diagnostics: [MySQL][ODBC 5.1 Driver][mysqld-5.1.56-community]Unknown column
'parentMsg.senderAddress.lifecycl' in 'OLD'.



Is this because of naming convention? I doubt that..
--
Thanks & Regards

Ravi




_______________________________________________
OpenSplice DDS Developer Mailing List
Developer at opensplice.org
Subscribe / Unsubscribe http://dev.opensplice.org/mailman/listinfo/developer
--
Thanks & Regards

Ravi
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://dev.opensplice.org/pipermail/developer/attachments/20110616/738a21a6/attachment.htm>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: not available
Type: image/jpeg
Size: 3349 bytes
Desc: not available
URL: <Loading Image...>

[Ravi Chandran]

I don't know about that. My seniors might know about it. But isn't this
problem as very common one? I do think that this sort of problem might have
happened to many beginners..

[Ravi Chandran]

hi Hans,
I think now the DBMS service is working perfectly. This is the log status
now.:

INIT (mainThread) -> All DBMS connections (1) for
DbmsToDds NameSpaces are opened successfully.

INIT (ddsConnection) -> INIT (dbmsMetaHandler)
-> Initializing DDS data administration...

Resolved all known DBMS metadata.

INIT (ddsConnection) -> DDS data administration
initialized.

INIT (ddsConnection) -> Initializing DDS meta
administration...

INIT (mainThread) -> Start monitoring DDS metadata...

INIT (mainThread) -> Fetching initial DDS metadata...

INIT (ddsMetaHandler) -> Found new group '__BUILT-IN
PARTITION__.DCPSHeartbeat'

INIT (ddsMetaHandler) -> Found new group '__BUILT-IN
PARTITION__.DCPSSubscription'

INIT (ddsMetaHandler) -> Found new group '__BUILT-IN
PARTITION__.DCPSParticipant'

INIT (ddsMetaHandler) -> Found new group '__BUILT-IN
PARTITION__.DCPSPublication'

INIT (ddsMetaHandler) -> Found new group '__BUILT-IN
PARTITION__.DCPSTopic'

INIT (mainThread) -> Initial DDS metadata processed.

INIT (ddsConnection) -> DDS meta administration
initialized.

INIT (mainThread) -> DDS domain monitoring started.

INIT (mainThread) -> ----LEAVING STATE----



OPERATIONAL (mainThread) -> ----ENTERING STATE----

OPERATIONAL (mainThread) -> DBMS service fully started.

OPERATIONAL (ddsMetaHandler) -> Found new group '.HelloTopic'


But I am still not able to see the data in OSPL Tuner or at the subscriber
end. Am I still missing something?

[Hans van't Hag]

Hi Ravi,



Right now it doesn?t look (yet) like a problem OF the middleware, more like
a problem WITH the middleware J

The ?most common? problems that beginners have is that there?s some sort of
?minimal-level-of-understanding? required and with services like DBMSConnect
that ?minimum? is perhaps higher than with other parts of the middleware (as
it requires both DDS/DBMS and ODBC understanding).



Regards,

Hans









* *

*Hans van 't Hag*

OpenSplice DDS Product Manager

PrismTech Netherlands

Email: hans.vanthag at prismtech.com

Tel: [phone]

Fax: [phone]

Gsm: [phone]



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-bounces at opensplice.org [mailto:
developer-bounces at opensplice.org] *On Behalf Of *Ravi Chandran
*Sent:* Friday, June 17, 2011 7:02 AM
*To:* OpenSplice DDS Developer Mailing List
*Subject:* Re: [OSPL-Dev] using DDS with DBMS



I don't know about that. My seniors might know about it. But isn't this
problem as very common one? I do think that this sort of problem might have
happened to many beginners..
--
Thanks & Regards

Ravi
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://dev.opensplice.org/pipermail/developer/attachments/20110617/a00020b6/attachment.htm>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: not available
Type: image/jpeg
Size: 3349 bytes
Desc: not available
URL: <Loading Image...>

[Ravi Chandran]

hi Hans,
If I am getting log info as :

OPERATIONAL (mainThread) -> DBMS service fully started.

does it still mean that there is still something wrong in DBMS service? As
I am still not getting any data from DB to DDS...