details: https://code.openbravo.com/erp/devel/pi/rev/d4ef642f1e2a
changeset: 16552:d4ef642f1e2a
user: Asier Lostalé <asier.lostale <at> openbravo.com>
date: Wed May 16 08:24:37 2012 +0200
summary: fixed bug 20498: Heap space error in SqlC with big number of rows in
ad_session
diffstat:
src/org/openbravo/erpCommon/security/SessionLogin_data.xsql | 26 +++++--------
1 files changed, 10 insertions(+), 16 deletions(-)
diffs (44 lines):
diff -r 73df55fd12cc -r d4ef642f1e2a
src/org/openbravo/erpCommon/security/SessionLogin_data.xsql
--- a/src/org/openbravo/erpCommon/security/SessionLogin_data.xsql Tue May
15 23:24:17 2012 +0200
+++ b/src/org/openbravo/erpCommon/security/SessionLogin_data.xsql Wed May
16 08:24:37 2012 +0200
@@ -20,14 +20,16 @@
<SqlClass name="SessionLoginData" package="org.openbravo.erpCommon.security">
<SqlClassComment></SqlClassComment>
- <SqlMethod name="select" type="preparedStatement" return="multiple">
- <SqlMethodComment></SqlMethodComment>
- <Sql>
- select * from ad_session
- </Sql>
+
+ <SqlMethod name="activeSessions" type="preparedStatement" return="multiple">
+ <Sql><![CDATA[
+ SELECT AD_SESSION_ID, SERVER_URL
+ FROM AD_SESSION
+ WHERE SESSION_ACTIVE = 'Y'
+ ]]></Sql>
<Field name="supportContact" value=""/>
- </SqlMethod>
-
+ </SqlMethod>
+
<SqlMethod name="deactivate" type="preparedStatement" return="rowCount">
<Sql><![CDATA[
UPDATE AD_Session
@@ -46,15 +48,7 @@
]]></Sql>
<Parameter name="adSessionId"/>
</SqlMethod>
-
- <SqlMethod name="activeSessions" type="preparedStatement" return="multiple">
- <Sql><![CDATA[
- SELECT AD_SESSION_ID, SERVER_URL
- FROM AD_SESSION
- WHERE SESSION_ACTIVE = 'Y'
- ]]></Sql>
- </SqlMethod>
-
+
<SqlMethod name="selectSupportContact" type="preparedStatement"
return="string">
<Sql><![CDATA[
SELECT SUPPORT_CONTACT
------------------------------------------------------------------------------
Live Security Virtual Conference
Exclusive live event will cover all the ways today's security and
threat landscape has changed and how IT managers can respond. Discussions
will include endpoint security, mobile security and the latest in malware
threats. http://www.accelacomm.com/jaw/sfrnl04242012/114/50122263/
_______________________________________________
Openbravo-commits mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/openbravo-commits
