Velocity Reviews - Computer Hardware Reviews

Velocity Reviews > Newsgroups > Programming > Java > java.sql.SQLException: JZ0P1: Unexpected result type.

Reply
Thread Tools

java.sql.SQLException: JZ0P1: Unexpected result type.

 
 
Bumsys@gmail.com
Guest
Posts: n/a
 
      05-30-2008
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(Unkn own Source)
at com.sybase.jdbc3.jdbc.SybStatement.updateLoop(Unkn own Source)
at com.sybase.jdbc3.jdbc.SybStatement.executeUpdate(U nknown Source)
at com.sybase.jdbc3.jdbc.SybPreparedStatement.execute Update(Unknown
Source)
at de.alfa.autoupdate.db.DataManager.makeSigleBackup( DataManager.java:
1853)
at
de.alfa.autoupdate.engine.ResourceUpdater.updateLo cal2DB(ResourceUpdater.java:
183)
at de.alfa.autoupdate.engine.UpdateTask.load(UpdateTa sk.java:900)
at de.alfa.autoupdate.engine.UpdateTask.performUpdate (UpdateTask.java:
479)
at de.alfa.autoupdate.engine.UpdateTask$1.run(UpdateT ask.java:402)
at java.lang.Thread.run(Thread.java:619)

What does this error mean? What can do?
 
Reply With Quote
 
 
 
Reply

Thread Tools

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
Mysql::Result .each_hash - unexpected result Andy Tolle Ruby 7 11-15-2010 10:39 AM
1. Ruby result: 101 seconds , 2. Java result:9.8 seconds, 3. Perl result:62 seconds Michael Tan Ruby 32 07-21-2005 03:23 PM
Unexpected result when entering wrong data type japh C++ 4 01-08-2005 08:21 PM
Unexpected Result John J C++ 8 05-13-2004 08:48 AM
unexpected result using std::list Mike Pemberton C++ 3 10-14-2003 06:24 PM



Advertisments