SOAP UI响应(SOAP UI response)
我想在SOAP UI中查看以下方法的响应。 url将如下所示调用SOAP UI中的accountDetails(..)方法来检查响应。
HTTP://本地主机:8080 / AccountInfo / REST /帐号/ 0003942390
@RequestMapping(value = /accountDetails/{accNum}, method = RequestMethod.GET) public void accountDetails(@PathVariable final String accNum) { final boolean accountValue = service.isAccountExists(accNum); if (!accountValue ) { throw new Exception(); } }
该方法正确执行但我在SOAP UI中获得的响应是404. accountDetails(..)方法返回类型为void,所以当我必须检查SOAP中方法的响应时,我需要设置任何额外的参数具有void返回类型的UI以显示成功消息。
以下是SOAP UI中显示的消息:
HTTP/1.1 404 /AccountInfo/WEB-INF/jsp/account/0003942390/accountInfo.jsp Server: Apache-Coyote/1.1
I want to view the response for the below method in SOAP UI. The url would be as below to call the accountDetails(..) method in SOAP UI to check the response.
http://localhost:8080/AccountInfo/rest/account/0003942390
@RequestMapping(value = /accountDetails/{accNum}, method = RequestMethod.GET) public void accountDetails(@PathVariable final String accNum) { final boolean accountValue = service.isAccountExists(accNum); if (!accountValue ) { throw new Exception(); } }
The method is executed correctly but the response i'm getting in SOAP UI is 404. accountDetails(..) method return type is void, so do i need to set any extra parameters when i have to check the response for the method in SOAP UI with void return type to show success message.
Below is the message shown in SOAP UI:
HTTP/1.1 404 /AccountInfo/WEB-INF/jsp/account/0003942390/accountInfo.jsp Server: Apache-Coyote/1.1
原文:https://stackoverflow.com/questions/38665962
最满意答案
你应该为此使用Windows功能:
select t.*, (case when count(*) over (partition by country) > 1 then 1 else 0 end) as flag from t;
这是a_horse_with_no_name的答案。 如果该答案没有删除,我会删除它。
You should use windows functions for this:
select t.*, (case when count(*) over (partition by country) > 1 then 1 else 0 end) as flag from t;
This is essential a_horse_with_no_name's answer. I'll delete it if that answer is undeleted.
相关问答
更多-
无For循环: Dim newColumn As New Data.DataColumn("Foo", GetType(System.String)) newColumn.DefaultValue = "Your DropDownList value" table.Columns.Add(newColumn) 这是未经测试的。 我用了一个在线C# 转换工具 : System.Data.DataColumn newColumn = new System.Data.DataColumn("Foo ...
-
与SQL相关的问题一样,它取决于DBMS。 一些DBMS允许您组合使用逗号分隔的ALTER表操作。 例如... Informix语法: ALTER TABLE one ADD two_id INTEGER, ADD CONSTRAINT FOREIGN KEY(two_id) REFERENCES two(id); IBM DB2 LUW的语法是类似的,重复关键字ADD,但是(如果我正确地阅读了图),不需要逗号来分隔添加的项目。 Microsoft SQL Server语法: ALTER ...
-
您可以使用窗口函数来计算ID: select word, cnt, dense_rank() over (order by word) as id from the_table; 如果你真的需要坚持下去,你可以使用上面的表来更新表: merge into the_table tg using ( select rowid as rid, dense_rank() over (order by word) as new_id from the_tab ...
-
R - 需要添加一个标志,其中代码标识列中缺失的值(R - need to add a flag where code identifies a missing value in a column)[2023-09-25]
输入数据: dat <- read.table(header=TRUE, ## text= ## "Group_ID Ind_ID Name Andy? ## 100 1 Andy Y ## 100 1 Mike Y ## 100 2 Mike Y ## 200 1 Mike N ## 200 2 Mike N ## 300 ... -
SQL中的聚合总和(连接)(Aggregation Sum in SQL (Joins))[2023-08-08]
create table p(id number, up number, name varchar2(100)); create table e(id number, pid number, dsc varchar2(100)); insert into p values (1, null, 'country'); insert into p values (2, 1, 'center'); insert into p values (3, 1, 'province'); insert in ... -
SQL Pivot没有聚合(SQL Pivot without aggregation)[2023-06-12]
这是动态PIVOT查询: DECLARE @sql NVARCHAR(MAX), @cols NVARCHAR(MAX); SELECT @cols = STUFF(( SELECT DISTINCT ',' + QUOTENAME(PropertyName) FROM #tbl FOR XML PATH(''), TYPE ).value('.', 'NVARCHAR(MAX)') , 1, 1, '' ... -
你应该为此使用Windows功能: select t.*, (case when count(*) over (partition by country) > 1 then 1 else 0 end) as flag from t; 这是a_horse_with_no_name的答案。 如果该答案没有删除,我会删除它。 You should use windows functions for this: select t.*, (case when count(*) ove ...
-
如何在sql server中添加带有自动增量的主键列(how to add primary key column with auto increment in sql server)[2021-06-17]
你应该使用内联约束语法 ALTER TABLE OLTMS_0B8DF2 ADD ID INT IDENTITY(1,1) PRIMARY KEY You should use inline constraint syntax ALTER TABLE OLTMS_0B8DF2 ADD ID INT IDENTITY(1,1) PRIMARY KEY -
您必须在FragmentActivity的onCreate方法中设置它: activity.getWindow().setFlags(LayoutParams.FLAG_SECURE, LayoutParams.FLAG_SECURE); You must set it in your onCreate method of your FragmentActivity : activity.getWindow().setFlags(LayoutParams.FLAG_SECURE, LayoutParams ...
-
如何在spark sql聚合中添加三个整数列(How to add three column which are integer in spark sql aggregation)[2023-07-05]
我用这段代码得到了正确的结果: import org.apache.spark.rdd.RDD import org.apache.spark.sql.{DataFrame, Row} import org.apache.spark.sql.functions.{col, sum} import org.apache.spark.sql.types.{IntegerType, StructField, StructType} val rowsRdd: RDD[Row] = spark.sparkCo ...