Ws_Sql Invalid table name or file type not supported: test
Hi,
I run into a problem with Ws_SQL Web Services. When I use the PrepareSQL method soap test. I can't query table.
Request:
Response:
following are the GetDBMetaData
following are the create 'test' table code,
I am not able to figure out what I am doing wrong. and I don't know how to set the tablename.
Thanks
Bob
I run into a problem with Ws_SQL Web Services. When I use the PrepareSQL method soap test. I can't query table.
Request:
- Code: Select all
<?xml version="1.0" encoding="UTF-8"?>
<soap:Envelope xmlns:soap="http://schemas.xmlsoap.org/soap/envelope/" xmlns:SOAP-ENC="http://schemas.xmlsoap.org/soap/encoding/" xmlns="urn:hpccsystems:ws:ws_sql">
<soap:Body>
<PrepareSQLRequest>
<SqlText>select * from test</SqlText>
<TargetCluster>hthor</TargetCluster>
<TargetQuerySet/>
<Wait>-1</Wait>
</PrepareSQLRequest>
</soap:Body>
</soap:Envelope>
Response:
- Code: Select all
<?xml version="1.0" encoding="utf-8"?>
<soap:Envelope xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:xsd="http://www.w3.org/2001/XMLSchema" xmlns:soap="http://schemas.xmlsoap.org/soap/envelope/" xmlns:wsse="http://schemas.xmlsoap.org/ws/2002/04/secext">
<soap:Body>
<PrepareSQLResponse xmlns="urn:hpccsystems:ws:ws_sql">
<Exceptions>
<Exception>
<Code>-1</Code>
<Audience>user</Audience>
<Source>CSoapResponseBinding</Source>
<Message>2014-11-24 06:32:30 GMT: Invalid table name or file type not supported: test
</Message>
</Exception>
</Exceptions>
</PrepareSQLResponse>
</soap:Body>
</soap:Envelope>
following are the GetDBMetaData
- Code: Select all
<?xml version="1.0" encoding="utf-8"?>
<soap:Envelope xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:xsd="http://www.w3.org/2001/XMLSchema" xmlns:soap="http://schemas.xmlsoap.org/soap/envelope/" xmlns:wsse="http://schemas.xmlsoap.org/ws/2002/04/secext">
<soap:Body>
<GetDBMetaDataResponse xmlns="urn:hpccsystems:ws:ws_sql">
<TableCount>0</TableCount>
<QuerySets>
<QuerySet>
<Name>hthor</Name>
<QuerySetQueries>
<QuerySetQuery>
<Name>test</Name>
<Id>test.1</Id>
<Wuid>W20141124-101734</Wuid>
<Suspended>1</Suspended>
<Signature>
<ResultSets>
<ResultSet>
<name>Result 1</name>
<OutParams>
<OutParam>
<Name>personid</Name>
<Type>unsigned1</Type>
</OutParam>
<OutParam>
<Name>name</Name>
<Type>string25</Type>
</OutParam>
<OutParam>
<Name>age</Name>
<Type>integer8</Type>
</OutParam>
<OutParam>
<Name>height</Name>
<Type>integer8</Type>
</OutParam>
<OutParam>
<Name>address</Name>
<Type>string25</Type>
</OutParam>
</OutParams>
</ResultSet>
</ResultSets>
</Signature>
</QuerySetQuery>
<QuerySetQuery>
<Name>bobtest</Name>
<Id>bobtest.1</Id>
<Wuid>W20141124-134421</Wuid>
<Suspended>0</Suspended>
<Signature>
<ResultSets>
<ResultSet>
<name>Result 1</name>
<OutParams>
<OutParam>
<Name>personid</Name>
<Type>unsigned1</Type>
</OutParam>
<OutParam>
<Name>firstname</Name>
<Type>string15</Type>
</OutParam>
<OutParam>
<Name>lastname</Name>
<Type>string25</Type>
</OutParam>
</OutParams>
</ResultSet>
</ResultSets>
</Signature>
</QuerySetQuery>
</QuerySetQueries>
<QuerySetAliases>
<QuerySetAlias>
<Id>test.1</Id>
<Name>test</Name>
</QuerySetAlias>
<QuerySetAlias>
<Id>bobtest.1</Id>
<Name>bobtest</Name>
</QuerySetAlias>
</QuerySetAliases>
</QuerySet>
<QuerySet>
<Name>thor</Name>
</QuerySet>
<QuerySet>
<Name>roxie</Name>
</QuerySet>
<QuerySet>
<Name>thor_roxie</Name>
</QuerySet>
</QuerySets>
<ClusterNames>
<ClusterName>hthor</ClusterName>
<ClusterName>thor</ClusterName>
<ClusterName>roxie</ClusterName>
<ClusterName>thor_roxie</ClusterName>
</ClusterNames>
</GetDBMetaDataResponse>
</soap:Body>
</soap:Envelope>
following are the create 'test' table code,
- Code: Select all
Layout_Person := RECORD
UNSIGNED1 PersonID;
STRING25 Name;
INTEGER age;
INTEGER height;
STRING25 address;
END;
t := DATASET([ {1,'bob',23,180,'xian'},
{2,'ivy',28,160,'gaolin'},
{3,'leo',28,180,'xian'},
{4,'neal',35,175,'tangyanlu'},
{5,'owen',32,170,'tianshui'},
{6,'jake',34,170,'wuhanxiangyang'}],Layout_Person);
test := t;
// Outputs ---
test;
I am not able to figure out what I am doing wrong. and I don't know how to set the tablename.
Thanks
Bob
- bobl
- Posts: 5
- Joined: Tue Nov 18, 2014 7:05 am
2 posts
• Page 1 of 1
Who is online
Users browsing this forum: No registered users and 1 guest