|
Re: AbstractSqlLookupService cancels transaction on PostgresSQL 9.2 [message #1126021 is a reply to message #1125755] |
Sat, 05 October 2013 04:26 |
Jeremie Bresson Messages: 1252 Registered: October 2011 |
Senior Member |
|
|
Are you on nightly build (Luna - Scout 3.10)?
We just removed the @ConfigPropertyValue... Bug 395132
Our analysis has shown that the Annotation wasn't used.
-> That something we will need to verify next week.
Can you try with our last Luna release: 3.10.0 M2?
You can find the EPP Package here.
Or you can use the corresponding update site.
Quote:The service works fine for key search but not for browsing all entries with the getDataByAll method. There is not an error nor an exception visible, but the Smartfield shows only an empty list.
Can you check in the server console (log)? What SQL Query is executed? Does it seems OK?
Can you debug? Set a breakpoint at:
org.eclipse.scout.rt.server.services.lookup.AbstractSqlLookupService.getDataByAll(LookupCall)
What is the content of LookupRow[] rows, before it is returned?
[Updated on: Sat, 05 October 2013 05:19] Report message to a moderator
|
|
|
Re: AbstractSqlLookupService cancels transaction on PostgresSQL 9.2 [message #1126610 is a reply to message #1126021] |
Sat, 05 October 2013 19:33 |
Thomas Mangold Messages: 7 Registered: October 2013 |
Junior Member |
|
|
I'm still using scout 3.9.1 distributed with Eclipse 4.3 and can't download the 3.10 version because of a slow internet connection at the place I'm staying at the moment,
But the query seems absolut correct:
SQL with binds:
SELECT U.ID,
U.NAME || ' (' || U.EQUI_QUANTITY || ' g)'
AS "lookup_name"
FROM FDB.UNITS U
WHERE 1 = 1
Pasted into the SQL editor of pgadmin3 it delivers the expected result.
Debugging AbstractSqlLookupService.getDataByAll(LookupCall) delivers still the right result in the rows variable of the return statement.
The Problem occurs later in ActiveTransactionRegistry.unregister(ITransaction tx)
There in the debugger the transaction has suddenly the m_cancelled property set to true. May be this is only an artefact of debugging because i must leave the SmartField with the mousepointer to step on.
[Updated on: Sat, 05 October 2013 19:57] Report message to a moderator
|
|
|
Re: AbstractSqlLookupService cancels transaction on PostgresSQL 9.2 [message #1127933 is a reply to message #1126610] |
Mon, 07 October 2013 06:48 |
Jeremie Bresson Messages: 1252 Registered: October 2011 |
Senior Member |
|
|
Thomas Mangold wrote on Sat, 05 October 2013 21:33I'm still using scout 3.9.1 distributed with Eclipse 4.3 and can't download the 3.10 version because of a slow internet connection at the place I'm staying at the moment
Stay at this version. It should be OK.
I guess it has nothing to do with @ConfigPropertyValue.
Thomas Mangold wrote on Fri, 04 October 2013 23:18I'm using eclipse 4.3 installed local from eclipse.org, scout 3.9 and postgres 9.2 as database on Linux 32bit Fedora 19.
Maybe there is a problem with Fedora.
Thomas Mangold wrote on Sat, 05 October 2013 21:33
Debugging AbstractSqlLookupService.getDataByAll(LookupCall) delivers still the right result in the rows variable of the return statement.
The Problem occurs later in ActiveTransactionRegistry.unregister(ITransaction tx)
There in the debugger the transaction has suddenly the m_cancelled property set to true. May be this is only an artefact of debugging because i must leave the SmartField with the mousepointer to step on.
If you want to debug it futher, you could devide the problem: I suggest to test it without a database dependency.
Can you try an other implementation for your LookupService extending AbstractLookupService instead of AbstractSqlLookupService. For the different functions getDataByKey(), getDataByText(), getDataByAll(), just return array of LookupRows:
public LookupRow[] getDataByAll(LookupCall call) throws ProcessingException {
return new LookupRow[]{
new LookupRow(1L, "text by all 1"),
new LookupRow(2L, "text by all 2"),
new LookupRow(3L, "text by all 3")
};
}
This service can be registered this service in the server. If this is still not working, it would be interesting to register the service in the client (you can verify if this has something to do with the client/server communication).
.
|
|
|
|
|
|
|
|
|
|
Powered by
FUDForum. Page generated in 0.03792 seconds