perfsonar development work

Author: roman
Date: 2006-08-31 07:55:42 -0400 (Thu, 31 Aug 2006)
New Revision: 1586

Modified:
   trunk/perfsonar/conf/ibatis-L2-status-domain.xml
   trunk/perfsonar/conf/ibatis-L2-status-interdomain.xml
Log:
insert sql statements corrected (time format convertion was wrong)

Modified: trunk/perfsonar/conf/ibatis-L2-status-domain.xml
===================================================================
--- trunk/perfsonar/conf/ibatis-L2-status-domain.xml    2006-08-31 11:53:44 
UTC (rev 1585)
+++ trunk/perfsonar/conf/ibatis-L2-status-domain.xml    2006-08-31 11:55:42 
UTC (rev 1586)
@@ -105,8 +105,8 @@
   <insert id="setResults"
           parameterMap="insert-parameters">
     <![CDATA[
-        insert into domain_link (id, from_unixtime(time), status_oper)
-        values (?, ?, ?)
+        insert into domain_link (id, time, status_oper)
+        values (?, from_unixtime(?), ?)
     ]]>
   </insert>
 
@@ -116,8 +116,8 @@
   <insert id="setResults"
     parameterMap="insert-parameters">
     <![CDATA[
-        insert into domain_link (id, to_timestamp(time), status_oper)
-        values (?, ?, ?)
+        insert into domain_link (id, time, status_oper)
+        values (?, to_timestamp(?), ?)
     ]]>
   </insert>
   -->

Modified: trunk/perfsonar/conf/ibatis-L2-status-interdomain.xml
===================================================================
--- trunk/perfsonar/conf/ibatis-L2-status-interdomain.xml       2006-08-31 
11:53:44 UTC (rev 1585)
+++ trunk/perfsonar/conf/ibatis-L2-status-interdomain.xml       2006-08-31 
11:55:42 UTC (rev 1586)
@@ -105,8 +105,8 @@
   <insert id="setResults"
           parameterMap="insert-parameters">
     <![CDATA[
-        insert into interdomain_link (id, from_unixtime(time), status_oper)
-        values (?, ?, ?)
+        insert into interdomain_link (id, time, status_oper)
+        values (?, from_unixtime(?), ?)
     ]]>
   </insert>
 
@@ -116,8 +116,8 @@
   <insert id="setResults"
     parameterMap="insert-parameters">
     <![CDATA[
-        insert into interdomain_link (id, to_timestamp(time), status_oper)
-        values (?, ?, ?)
+        insert into interdomain_link (id, time, status_oper)
+        values (?, to_timestamp(?), ?)
     ]]>
   </insert>
   -->