to taking mdbdata in the Vector from hxttDriver
printed underMessage
"java.sql.SQLException: An invalid Access database page 6279"
WhatMean?
Please answer.
|
Source
------------
public Vector getOwnerMDBData(String year, String gubun, String district, String fileName, String month){
int writen = 0;
int total= 0;
int a=0;
if(month.equals("6") || month.equals("9")){
month = "WHERE BASE_MON = '2'";
}else{
month = "WHERE BASE_MON = '1'";
}
Vector dataList=new Vector();
String sql= "SELECT DISTINCT LAND_CD,BLDG_REGNO,DONG_GBN,BASE_MON,UMD_CD,ADMD_CD,"+
"RI_CD,USE_GBN,OWN_GBN,OWNER_NO,LAND_OWNER,OWNER_ADDR,ZIPCD "+
" FROM OWNER "+month;
//System.out.println("SQL ="+sql);
try{
System.out.println("MDB 파일에서 OWNER 자료를 가져오는 중......");
con = this.getHXTTConnection(gubun,district,fileName);
pstmt = con.prepareStatement(sql);
rs=pstmt.executeQuery();
while(rs.next()){
Hashtable data=new Hashtable();
for(int cnt=0; cnt< wcols.length; cnt++){
String key = this.wcols[cnt];
String value = rs.getString(key);
data.put(key, (value==null)?"":value );
}
dataList.addElement(data);
a++;
}
System.out.println("총 "+dataList.size()+"개의 OWNER 자료를 가져왔습니다");
}catch(Exception ex){
//****PRINT TO HERE ERROR MESSAGE****
System.out.println("ERROR");
ex.printStackTrace();
}finally{
try{
if(pstmt!=null)pstmt.close();
}catch(Exception e){}
this.conClose();
}
System.out.println(dataList.size());
return dataList;
}
|
>"java.sql.SQLException: An invalid Access database page 6279"
It means that HXTT Access found an error message in that mdb file. You can use MS Access to compact/repari that file once.
|
Thank you !
add Question.
To this ErrorMessage "An invalid Access dataBase page 6279"
What is pointing "page 6279"
|
>What is pointing "page 6279"
It means that error is about at page 6279 of that mdb file, which is only a prompt message.
|
Main
webmaster@hxtt.com