Process Mapping Logo

Process Mapping - Forums

Sharing 19 years of knowledge and experience

 
Metastorm BPM forums
Sign up Latest Topics
 
 
 


Reply
  Author   Comment  
krathod

New Member
Registered:
Posts: 6
Reply with quote  #1 
Hi,

I have been searching the web endlessly for a solution to my problem and cannot find any answers, i'm hoping someone here may have an answer.

I'm using metastorm 9.1 and have had a form which has been working absolutely fine for a while now.  Today on my DEV environment I switched my connection to the database from an ODBC connection to a Database connection as a little birdy told me that using the Database connection type is better and faster than an ODBC connection to a database (I'm a little sceptical about it having any major performance benefits).

Anyway, when I switch the connection from ODBC to Database one of my queries has stopped working.  I am using the following query to populate my memo field on the form:

select BusDesc + ' ' as 'data()' from BusinessDesc where Client='05678' for xml path('')

now since changing the connection my memo field displays:  System.Byte[] instead of the business description.  Changing the connection type back to ODBC resolves the issue, but i am curious as to why it doesn't work with the database connection type.  Do I need to change a setting somewhere?

I am using the above query to concatenate multiple rows (as each column can only hold 48 characters of data) of the business description into one string.

I would appreciate any sort of feedback.  (I have attached images of my two different results)

Attached Images
jpeg DBResult.JPG (4.08 KB, 8 views)
jpeg ODBCResult.JPG (5.26 KB, 8 views)

0
Jerome

Avatar / Picture

Guru
Registered:
Posts: 5,507
Reply with quote  #2 
1. This seems to me to be an overly complicated way to get data from a database. Plain SQL would do the job for me in most cases, although I may have to replace some delimiting characters after the conversion to a memo variable.
2. If it ain't broke, don't fix it!

__________________
Post an example, and we will have a much better idea what the problem is. In about 90% of posts, the problem is one of communication. Examples bridge that gap.
0
krathod

New Member
Registered:
Posts: 6
Reply with quote  #3 
Thanks Jerome,

I never wanted to change the connection type, call it 'peer pressure'.

But it's strange how the result is of the same query is different depending on the type of connection that you use!

Out of interest, is using the database connection better than using the ODBC connection?
0
Jerome

Avatar / Picture

Guru
Registered:
Posts: 5,507
Reply with quote  #4 
A Native connection should be quicker, but unless you are doing a heck of a lot, it would not be possible to measure IMO.
__________________
Post an example, and we will have a much better idea what the problem is. In about 90% of posts, the problem is one of communication. Examples bridge that gap.
0
Previous Topic | Next Topic
Print
Reply

Quick Navigation:


Create your own forum with Website Toolbox!