select ballerina.ruby

	@http:GET
	@http:Path("/")
	resource select(message m) {
		sql:Parameter[] params = [];
		try {
			datatable dt = sql:ClientConnector.select(lcDBConnector, "select empno,ename,job,mgr,hiredate,sal,comm,deptno from emp", params);
			json payload = datatables:toJson(dt);
			message response = {};
			messages:setJsonPayload(response, payload);
			reply response;
			
		}
		catch (exception e) {
			message response = {};
			messages:setJsonPayload(response, responseException("select", e));
			reply response;
			
		}
		
	}