为什么我在本地系统上可以正常工作的同时继续在服务器上获取对象引用

Question

我的类对象没有转换成json，我认为它返回对象引用，尽管在本地执行它时，它执行得很好。

这是代码

private def static sql

private static List<ProductAlertsResponse> executeSelection(String query)
{
    List<ProductAlertsResponse> prodAlerts=new ArrayList<ProductAlertsResponse>()
    sql.eachRow(query)
    {
        ProductAlertsResponse prodAlert=new ProductAlertsResponse((String)it.id,(String)it.name,(String)it.description,(String)it.active,(String)it.release_date)
        prodAlerts.add(prodAlert)
    }
    return prodAlerts
}

static main(args) {

    AppProperties.load()
    sql = Sql.newInstance("jdbc:oracle:thin:@"+AppProperties.get("hostname")+":"+AppProperties.get("port")+":"+AppProperties.get("service"), AppProperties.get("username"), AppProperties.get("password"),"oracle.jdbc.OracleDriver")

    List<ProductAlertsResponse> sqlResult=executeSelection("select ID,NAME,DESCRIPTION,ACTIVE,RELEASE_DATE from productinfo where ACTIVE='A'")

    def json = new groovy.json.JsonBuilder([response: sqlResult])

    String response=json.toPrettyString()
    println "$response"
}

这给了我以下回复

{
"response": [
    {
        "active": "A",
        "release_date": "2011-09-23 00:00:00.0",
        "id": "1",
        "description": "Test",
        "name": "ABC7"
    },
    {
        "active": "A",
        "release_date": "2012-01-19 00:00:00.0",
        "id": "5",
        "description": "Test1",
        "name": "ABC3"
    },
    {
        "active": "A",
        "release_date": "2011-09-23 00:00:00.0",
        "id": "3",
        "description": "Test",
        "name": "ABC1"
    },
    {
        "active": "A",
        "release_date": "2012-01-19 00:00:00.0",
        "id": "6",
        "description": "Test2",
        "name": "ABC2"
    }
]
}

在我的服务器上运行它（struts和commons链）时，它给我以下json响应（在删除静态后）

{
"response": [
    "com.est.dxclient.common.ProductAlertsResponse@67f797",
    "com.est.dxclient.common.ProductAlertsResponse@1e8f2a0",
    "com.est.dxclient.common.ProductAlertsResponse@c3d9ac",
    "com.est.dxclient.common.ProductAlertsResponse@7d8bb"
]
}

注意： 我正在使用groovy 1.8.0

更新 添加服务器端代码

My server side

class GetProductAlertsResponse implements Command {
//Command is import org.apache.commons.chain.Command
    private def sql

    @Override
    public boolean execute(Context ctx) throws Exception 
    {
        AppProperties.load()
        sql = Sql.newInstance("jdbc:oracle:thin:@"+AppProperties.get("hostname")+":"+AppProperties.get("port")+":"+AppProperties.get("service"), AppProperties.get("username"), AppProperties.get("password"),"oracle.jdbc.OracleDriver")

        List<ProductAlertsResponse> sqlResult=executeSelection("select ID,NAME,DESCRIPTION,ACTIVE,RELEASE_DATE from productinfo where ACTIVE='A'")

        def json = new groovy.json.JsonBuilder([response: sqlResult])

        /*I am trying to debug the code here*/
        println sqlResult.size()

        sqlResult.each{
            println it.getName()
        }

        String response=json.toPrettyString()

        println "Inside commands $response"
        ctx.put(CSMContextParams.response,response)
        return false;

    }
}

在控制台上打印

4
ABC7
ABC3
ABC1
ABC2
Inside commands [
    "com.est.dxclient.common.ProductAlertsResponse@a63599",
    "com.est.dxclient.common.ProductAlertsResponse@156f14c",
    "com.est.dxclient.common.ProductAlertsResponse@9ba632",
    "com.est.dxclient.common.ProductAlertsResponse@bc5245"
]

Answer 1

这个答案可能会有所帮助-GrailsJSONBuilder。

也许您的服务器代码使用了不同版本的Grails，或者在本地和服务器环境之间Grails的设置不同。