B
Bumsys
I run:
public final void makeSigleBackup(final int id, final String folder,
final String filename, final int maxBackups, final int
type)
throws SQLException {
// TODO _ backuping
int clientId = info.getClient().getId();
log.info("makeSigleBackup");
if (maxBackups == 0) {
deleteResource(id, folder, filename, 0, clientId);
return;
}
String query = "update "
+ getFullTableName(Tables.RESOURCE)
+ " set backupno = backupno + 1 where application_id
= ? and backupno = 0 and path = ? and name = ? and type = ?"
+ " and client_id = ?";
logQuery(query);
logQueryParameter("application_id = " + id);
logQueryParameter("path = " + makePathToDB(folder));
logQueryParameter("name = " + filename);
logQueryParameter("type = " + type);
logQueryParameter("client_id = " + clientId);
PreparedStatement ps =
manager.getConnection().prepareStatement(query);
ps.setInt(1, id);
ps.setString(2, makePathToDB(folder));
ps.setString(3, filename);
ps.setInt(4, type);
ps.setInt(5, clientId);
int numberOfRows = ps.executeUpdate();
logNumberOfRows(numberOfRows);
ps.close();
}
and I have:
5/30/08 6:00:55 PM INFO de.alfa.autoupdate.db.DataManager -
makeSigleBackup
5/30/08 6:00:55 PM INFO de.alfa.autoupdate.db.DataManager - sql
query: update dbo.au_res set backupno = backupno + 1 where
application_id = ? and backupno = 0 and path = ? and name = ? and type
= ? and client_id = ?
5/30/08 6:00:55 PM DEBUG de.alfa.autoupdate.db.DataManager -
parameter: application_id = 101
5/30/08 6:00:55 PM DEBUG de.alfa.autoupdate.db.DataManager -
parameter: path = app
5/30/08 6:00:55 PM DEBUG de.alfa.autoupdate.db.DataManager -
parameter: name = test.rar
5/30/08 6:00:55 PM DEBUG de.alfa.autoupdate.db.DataManager -
parameter: type = 0
5/30/08 6:00:55 PM DEBUG de.alfa.autoupdate.db.DataManager -
parameter: client_id = 11
5/30/08 6:00:56 PM ERROR de.alfa.autoupdate.engine.UpdateTask - Error
java.sql.SQLException: JZ0P1: Unexpected result type.
at com.sybase.jdbc3.jdbc.ErrorMessage.raiseError(Unknown Source)
at com.sybase.jdbc3.jdbc.SybStatement.updateLoop(Unknown Source)
at com.sybase.jdbc3.jdbc.SybStatement.executeUpdate(Unknown Source)
at com.sybase.jdbc3.jdbc.SybPreparedStatement.executeUpdate(Unknown
Source)
at de.alfa.autoupdate.db.DataManager.makeSigleBackup(DataManager.java:
1853)
at
de.alfa.autoupdate.engine.ResourceUpdater.updateLocal2DB(ResourceUpdater.java:
183)
at de.alfa.autoupdate.engine.UpdateTask.load(UpdateTask.java:900)
at de.alfa.autoupdate.engine.UpdateTask.performUpdate(UpdateTask.java:
479)
at de.alfa.autoupdate.engine.UpdateTask$1.run(UpdateTask.java:402)
at java.lang.Thread.run(Thread.java:619)
What does this error mean? What can do?
public final void makeSigleBackup(final int id, final String folder,
final String filename, final int maxBackups, final int
type)
throws SQLException {
// TODO _ backuping
int clientId = info.getClient().getId();
log.info("makeSigleBackup");
if (maxBackups == 0) {
deleteResource(id, folder, filename, 0, clientId);
return;
}
String query = "update "
+ getFullTableName(Tables.RESOURCE)
+ " set backupno = backupno + 1 where application_id
= ? and backupno = 0 and path = ? and name = ? and type = ?"
+ " and client_id = ?";
logQuery(query);
logQueryParameter("application_id = " + id);
logQueryParameter("path = " + makePathToDB(folder));
logQueryParameter("name = " + filename);
logQueryParameter("type = " + type);
logQueryParameter("client_id = " + clientId);
PreparedStatement ps =
manager.getConnection().prepareStatement(query);
ps.setInt(1, id);
ps.setString(2, makePathToDB(folder));
ps.setString(3, filename);
ps.setInt(4, type);
ps.setInt(5, clientId);
int numberOfRows = ps.executeUpdate();
logNumberOfRows(numberOfRows);
ps.close();
}
and I have:
5/30/08 6:00:55 PM INFO de.alfa.autoupdate.db.DataManager -
makeSigleBackup
5/30/08 6:00:55 PM INFO de.alfa.autoupdate.db.DataManager - sql
query: update dbo.au_res set backupno = backupno + 1 where
application_id = ? and backupno = 0 and path = ? and name = ? and type
= ? and client_id = ?
5/30/08 6:00:55 PM DEBUG de.alfa.autoupdate.db.DataManager -
parameter: application_id = 101
5/30/08 6:00:55 PM DEBUG de.alfa.autoupdate.db.DataManager -
parameter: path = app
5/30/08 6:00:55 PM DEBUG de.alfa.autoupdate.db.DataManager -
parameter: name = test.rar
5/30/08 6:00:55 PM DEBUG de.alfa.autoupdate.db.DataManager -
parameter: type = 0
5/30/08 6:00:55 PM DEBUG de.alfa.autoupdate.db.DataManager -
parameter: client_id = 11
5/30/08 6:00:56 PM ERROR de.alfa.autoupdate.engine.UpdateTask - Error
java.sql.SQLException: JZ0P1: Unexpected result type.
at com.sybase.jdbc3.jdbc.ErrorMessage.raiseError(Unknown Source)
at com.sybase.jdbc3.jdbc.SybStatement.updateLoop(Unknown Source)
at com.sybase.jdbc3.jdbc.SybStatement.executeUpdate(Unknown Source)
at com.sybase.jdbc3.jdbc.SybPreparedStatement.executeUpdate(Unknown
Source)
at de.alfa.autoupdate.db.DataManager.makeSigleBackup(DataManager.java:
1853)
at
de.alfa.autoupdate.engine.ResourceUpdater.updateLocal2DB(ResourceUpdater.java:
183)
at de.alfa.autoupdate.engine.UpdateTask.load(UpdateTask.java:900)
at de.alfa.autoupdate.engine.UpdateTask.performUpdate(UpdateTask.java:
479)
at de.alfa.autoupdate.engine.UpdateTask$1.run(UpdateTask.java:402)
at java.lang.Thread.run(Thread.java:619)
What does this error mean? What can do?