As I've stated before, I'm not getting the metadata returned to me for a query. As such, I'm having to provide result descriptors, including an ID.
I want to do the following <Command name="count" SQL="select COUNT(ID) from CONTACTS" kind="Select"> </Command> Without metadata being returned, it's again asking me for result descriptors. But, if I just add <ResultDescriptor columnName="COUNT" tableName="CONTACTS" columnType="commonj.sdo.Int"/> I get told no ID. But, obviously, there can't be <ResultDescriptor columnName="ID" tableName="CONTACTS" columnType="commonj.sdo.Int"/> because that query returns a resultset with 1 column. Has anyone else had experience with SQL Server 2005 not returning MetaData? Their docs says they do and I have their latest drivers, but I'm getting very little for metadata. A simple test of the metadata results returns Column Table Name: Schema name: Column Type: 12 Column Name: BUSINESS_CELL As you can see, I'm missing Table Name and Schema Name. I'm doing a simple Select query on this, so. I'm at a loss here. Any more ideas? -Jason Clark
