svn commit: r723336 - /ofbiz/trunk/framework/entity/fieldtype/fieldtypeoracle.xml

[hansbak-2]

Author: hansbak
Date: Thu Dec  4 06:22:44 2008
New Revision: 723336

URL: http://svn.apache.org/viewvc?rev=723336&view=rev
Log:
adding solution for oracle problem running services

Modified:
    ofbiz/trunk/framework/entity/fieldtype/fieldtypeoracle.xml

Modified: ofbiz/trunk/framework/entity/fieldtype/fieldtypeoracle.xml
URL: http://svn.apache.org/viewvc/ofbiz/trunk/framework/entity/fieldtype/fieldtypeoracle.xml?rev=723336&r1=723335&r2=723336&view=diff
==============================================================================
--- ofbiz/trunk/framework/entity/fieldtype/fieldtypeoracle.xml (original)
+++ ofbiz/trunk/framework/entity/fieldtype/fieldtypeoracle.xml Thu Dec  4 06:22:44 2008
@@ -36,7 +36,21 @@
     <field-type-def type="id" sql-type="VARCHAR2(20)" java-type="String"></field-type-def>
     <field-type-def type="id-long" sql-type="VARCHAR2(60)" java-type="String"></field-type-def>
     <field-type-def type="id-vlong" sql-type="VARCHAR2(255)" java-type="String"></field-type-def>
-
+    
+    <!-- we had a customer using Oracle 11g with the following error after running any service in webtools.
+        Service dispatcher threw an exceptionResult set was empty for entity:
+        [GenericEntity:RuntimeData][runtimeDataId,10205(java.lang.String)] (Result set was empty for entity:
+        [GenericEntity:RuntimeData][runtimeDataId,10205(java.lang.String)]) (Result set was empty for entity:
+        [GenericEntity:RuntimeData][runtimeDataId,10205(java.lang.String)] (Result set was empty for entity:
+        [GenericEntity:RuntimeData][runtimeDataId,10205(java.lang.String)]))
+        
+        adding the fieldtype
+        <field-type-def type="long" sql-type="LONG" java-type="String"><validate method="isNotEmpty" /></field-type-def>
+        and changing the fieldtype in RunTimeData:
+        <field name="runtimeInfo" type="long"></field>
+        cured the problem.
+        (HB)
+    -->
     <field-type-def type="indicator" sql-type="CHAR(1)" java-type="String"></field-type-def>
     <field-type-def type="very-short" sql-type="VARCHAR2(10)" java-type="String"></field-type-def>
     <field-type-def type="short-varchar" sql-type="VARCHAR2(60)" java-type="String"></field-type-def>