<?xml version="1.0" encoding="windows-1251"?>
<data name="MyService">
<description>My first test service</description>

<config  id="master-db">
<property name="org.wso2.ws.dataservice.driver">com.sybase.jdbc3.jdbc.SybDriver</property>
<property name="org.wso2.ws.dataservice.protocol">jdbc:sybase:Tds:myDbServer: 2638 /myDatabaseName</property>
<property name="org.wso2.ws.dataservice.user">dba</property>
<property name="org.wso2.ws.dataservice.password">sql</property>
<property name="org.wso2.ws.dataservice.minpoolsize"> 0 </property>
<property name="org.wso2.ws.dataservice.maxpoolsize"> 3 </property>
</config>

<!-- ====================== method: getTableList =========================== -->

<operation name="getTableList">
    <description>Этот метод возвращает список таблиц по введенной маске.</description>
	<call-query href="selectTableList" />
</operation>

<query id="selectTableList" useConfig="master-db">
	<!-- define sql to be executed. use standard java parameter placeholder: ? -->
	<sql>select * from SYS.SYSTABLES where table_name like ?</sql>
	
	<!-- map xml elements to returned column names-->
	<result element="tableList" rowName="table" defaultNamespace="http://mycompany.com/">
		<element name="tableid"               column="table_id" />
		<element name="owner"                 column="creator" />
		<element name="name"                  column="table_name" />
		<element name="type"                  column="table_type" />
	</result>

	<!-- define parameter names of the service -->
	<param name="namePattern"       sqlType="STRING" type="IN"  ordinal="1" />
</query>

<!-- ====================== method: getTableColumns =========================== -->

<operation name="getTableColumns">
    <description>Этот метод возвращает список колонок таблицы.</description>
	<call-query href="selectTableColumns" />
</operation>

<query id="selectTableColumns" useConfig="master-db">
	<!-- define sql to be executed. use standard java parameter placeholder: ? -->
	<sql>select * from SYS.SYSCOLUMN where table_id = ?</sql>
	
	<!-- map xml elements to returned column names-->
	<result element="columnList" rowName="column" defaultNamespace="http://mycompany.com/">
		<element name="columnId"              column="column_id" />
		<element name="isPrimary"             column="pkey" />
		<element name="name"                  column="column_name" />
	</result>

	<!-- define parameter names of the service -->
	<param name="tableId"       sqlType="INTEGER" type="IN"  ordinal="1" />
</query>


</data>