有关,jspsmart上传到Oracle数据库出错
CREATE TABLE TFILES (ID number(4) NOT NULL, FILENAME VARCHAR2(255), FILE1 BLOB, PRIMARY KEY (ID));
INSERT TABLE TFILES (ID,FILENAME,FILE1) VALUES (1,"test",null);
if ( FILE1!=null ){
// Connect to the database
//Class.forName("org.gjt.mm.mysql.Driver").newInstance();
Connection con = ConnPool.getConnection();
// SQL Request
Statement stmt = con.createStatement(ResultSet.TYPE_FORWARD_ONLY ,ResultSet.CONCUR_UPDATABLE);
ResultSet rs = stmt.executeQuery("SELECT * FROM TFILES WHERE ID=1");
// if the resultset is not null
if (rs.next()){
// Initialization
mySmartUpload.initialize(pageContext);
// Upload
mySmartUpload.upload();
// upload file in the DB if this file is not missing
if (!mySmartUpload.getFiles().getFile(0).isMissing()){
try {
rs.updateString("FileName",mySmartUpload.getFiles().getFile(0).getFileName());
// Add the current file in the DB field
mySmartUpload.getFiles().getFile(0).fileToField(rs,"File1");
System.out.println("FILE1");
// Update
rs.updateRow();
count++;
} catch(Exception e) {
out.println("An error occurs : " + e.toString());
}
}
}
// Display the number of files uploaded
out.println(count + " file(s) uploaded in the database.");
}
An error occurs : java.sql.SQLException: ???????????: updateString 0 file(s) uploaded in the database.