Error Executing Database Query--急救
npabc 2011-09-21 08:04:32 用ColdFusion 上传一个excel文件,把里面的数据一条条读完后上传来数据库,但是,只要上传的数据条数大于5000, 就会得到Error Executing Database Query 这个错误。哪路大神有解 ?
下面是原码
<cftry>
<cftransaction action="begin">
<cftry>
<cfloop from="1" to="#qry.recordCount#" index="rowIndex">
<cfquery datasource="#getDataSource()#">
insert into TOPLINE_UPLOAD
(
SOURCE_REGION,
SOURCE_ENTITY_CODE,
SOURCE_ENTITY,
FILE_NAME
)
values
(
<cfqueryparam cfsqltype="cf_sql_varchar" value="#qry[cols[1]][rowIndex]#">,
<cfqueryparam cfsqltype="cf_sql_varchar" value="#qry[cols[2]][rowIndex]#">,
<cfqueryparam cfsqltype="cf_sql_varchar" value="#qry[cols[3]][rowIndex]#">,
<cfqueryparam cfsqltype="cf_sql_varchar" value="#fileName#">
)
</cfquery>
</cfloop>
<cftransaction action="commit">
<cfcatch>
<cftransaction action="rollback"/>
<cfquery datasource="#getDataSource()#">
update TOPLINE_MANUAL_DATA_LOAD
set
message=<cfqueryparam cfsqltype="cf_sql_varchar" value="#cfcatch.Message#">,
status='Failed',
end_time=sysdate
where
file_name=<cfqueryparam cfsqltype="cf_sql_varchar" value="#fileName#">
</cfquery>
</cfcatch>
</cftry>
</cftransaction>
</cftry>