<< Click to Display Table of Contents >>
SetQueryTimeout
쿼리 타임아웃 시간을 설정합니다.
Prototype
void SetQueryTimeout(integer QueryTimeout)
Parameters
QueryTimeout |
타임 아웃 시간 (단위 초) |
Example
function OZJSPreparedStatementSample(){
var con = OZCreator.GetBuiltInObject(OZBuiltInObject.DBCONNECTION);
con.SetAlias("ozcar");
con.Connect(true);
var pstmt = con.PrepareStatement("select * from car where Maker = ? ");
pstmt.SetQueryTimeout(1000);
pstmt.SetMaxRows(2);
pstmt.SetParameter(1, "HYUNDAI");
var rs = pstmt.ExecuteQuery();
var meta = rs.GetMetaData();
for(var i=0; i<meta.GetColumnCount(); i++) {
_DEBUG(i+"= column Name="+meta.GetColumnName(i+1)+"type="+meta.GetColumnType(i+1));
}
while(rs.Next()) {
var data = "";
for(var i=0; i<meta.GetColumnCount(); i++) {
data = data + rs.GetString(i+1) + ", ";
}
_DEBUG(data);
}
rs.Close();
pstmt.Close();
}