Greetings,
I’ve pushed a new version of the JBidwatcher pre-release up tonight; it’s not an official release, but I’m trying to get one together. Please download it and let me know if it works out for you. It features a different way of parsing eBay’s items, and should fix thumbnails, fixed price/$1 items, bad currency issues, and more. Because of the depths of changes to the way JBidwatcher works, I’m urging caution on this one. Don’t use it for multi-sniping just yet, as I haven’t had a chance to test that.

That said, PLEASE do try it and let me know how it works. I need folks testing it and seeing what breaks, or seems odd. Thank you!

You can download it here:

Mac OS X (unsigned)

Windows (non-installer)

Linux

Please let me know if you run into any problems with this version; I’m really hoping to get it released soon, but I need it vetted by you folks first!

— Morgan Schweers, CyberFOX!

Hi,

get pound sign, even though the auction is running on Euro. It appears 1 pound, but must be 1 euro. ( ebay.de )

Marc

I’m getting this as well. Auction 251241428555 is in €, but my “Current”, “Shipping” and “Total” columns display £ (although my “Snipe Bid” column shows €. (Update: having changed my snipe amount on this item, it shows as £ in all columns, including “Snipe Bid”).

Another example – 121076801240 shows as £ in all columns, even though the auction is in $.

Also, around half of my Sellers show as “Q&A” – no obvious difference that I can see between the auctions that show this and those that show the correct name.

I can confirm the above comments, accessing ebay.de / ebay.fr / ebay.it via ebay.co.uk — the thumbnails and seller names are back (once the auctions are updated), but auction currencies are in £ irrespective of the auction currency (€ or $), and the snipe currency changes from € to £ when the snipe amount is changed. However, for all three sites, Fixed Price sales show the correct currency!

As an update on yesterday’s post, the two Fixed Price auctions that I was watching have now (today) disappeared from JBidwatcher, and can no longer be added. They are both listed on ebay.fr: 280953536276, 270957283010.

When I try to add them, I get this error log when I use drag-and-drop:
Thu Mar 14 12:25:50 CET 2013: Done getting the sign in cookie for ebay.co.uk
Thu Mar 14 12:25:54 CET 2013: MQ_update: Postponing Message: AUTOMATIC
Thu Mar 14 12:26:05 CET 2013: Parsing URL http://www.ebay.fr/itm/VOUVRAY-1976-Domaine-Benoit-Gautier-/270957283010?pt=FR_JG_Vins_Vins&hash=item3f165006c2
Thu Mar 14 12:26:05 CET 2013: Not loaded (270957283010).

I get this error log when I try to add them manually:
Thu Mar 14 12:27:03 CET 2013: PMQ Caught exception: java.lang.NullPointerException
at com.jbidwatcher.ui.FilterManager.addAuction(FilterManager.java:135)
at com.jbidwatcher.ui.JTabManager.showEntry(JTabManager.java:107)
at com.jbidwatcher.ui.commands.UserActions.cmdAddAuction(UserActions.java:169)
at com.jbidwatcher.ui.commands.UserActions.handleStringMessage(UserActions.java:102)
at com.jbidwatcher.ui.commands.UserActions.messageAction(UserActions.java:88)
at com.jbidwatcher.util.queue.PlainMessageQueue.run(PlainMessageQueue.java:56)
at java.lang.Thread.run(Thread.java:680)

Neither of them can be added to JBidwatcher 2.5.3pre3-2-g03a9bc3, either:
Thu Mar 14 12:33:49 CET 2013: Done getting the sign in cookie for ebay.co.uk
Thu Mar 14 12:33:52 CET 2013: MQ_update: Postponing Message: AUTOMATIC
Thu Mar 14 12:34:21 CET 2013: PMQ Caught exception: java.lang.NullPointerException
at com.jbidwatcher.ui.FilterManager.addAuction(FilterManager.java:135)
at com.jbidwatcher.ui.JTabManager.showEntry(JTabManager.java:107)
at com.jbidwatcher.ui.commands.UserActions.cmdAddAuction(UserActions.java:169)
at com.jbidwatcher.ui.commands.UserActions.handleStringMessage(UserActions.java:102)
at com.jbidwatcher.ui.commands.UserActions.messageAction(UserActions.java:88)
at com.jbidwatcher.util.queue.PlainMessageQueue.run(PlainMessageQueue.java:56)
at java.lang.Thread.run(Thread.java:680)

Most of my auctions went to (null)

Exited out and came back, some of them were back most were gone. Exit and come back, more gone. Just re-opened again, every auction is gone. Only fixed price items remain.

Rather than continue, and figuring something must be corrupt, I just wiped everything out and started fresh. Recreated the same searches and fired them off.

It started working fine, but some items ended up in current that should have been under another folder then I added another search and it just stopped updating.

Thu Mar 14 10:36:08 EDT 2013: Parsing URL http://thumbs2.ebaystatic.com/m/mDFEhttor0Ei5rzTU5hCRxw/96.jpg
Thu Mar 14 10:36:08 EDT 2013: Loaded 130863875197.
Thu Mar 14 10:36:28 EDT 2013: Can’t get row (auction_id = ‘66’).
A lock could not be obtained due to a deadlock, cycle of locks and waiters is:
Lock : ROW, ENTRIES, (1,70)
Waiting XID : {7854, S} , USER1, SELECT * FROM entries WHERE auction_id = ?
Granted XID : {7853, X}
Lock : ROW, ENTRIES, (1,69)
Waiting XID : {7853, X} , USER1, UPDATE entries SET updated_at=?,identifier=? WHERE id = ?
Granted XID : {7854, S}
. The selected victim is XID : 7854.
at org.apache.derby.impl.jdbc.SQLExceptionFactory40.getSQLException(Unknown Source)
at org.apache.derby.impl.jdbc.Util.generateCsSQLException(Unknown Source)
at org.apache.derby.impl.jdbc.TransactionResourceImpl.wrapInSQLException(Unknown Source)
at org.apache.derby.impl.jdbc.TransactionResourceImpl.handleException(Unknown Source)
at org.apache.derby.impl.jdbc.EmbedConnection.handleException(Unknown Source)
at org.apache.derby.impl.jdbc.ConnectionChild.handleException(Unknown Source)
at org.apache.derby.impl.jdbc.EmbedResultSet.closeOnTransactionError(Unknown Source)
at org.apache.derby.impl.jdbc.EmbedResultSet.movePosition(Unknown Source)
at org.apache.derby.impl.jdbc.EmbedResultSet.next(Unknown Source)
at com.jbidwatcher.util.db.Table.getFirstResult(Table.java:273)
at com.jbidwatcher.util.db.Table.getRow(Table.java:363)
at com.jbidwatcher.util.db.Table.findByColumn(Table.java:349)
at com.jbidwatcher.util.db.Table.findByColumn(Table.java:345)
at com.jbidwatcher.util.db.Table.findFirstBy(Table.java:137)
at com.jbidwatcher.util.db.ActiveRecord.findFirstByUncached(ActiveRecord.java:235)
at com.jbidwatcher.util.db.ActiveRecord.findFirstBy(ActiveRecord.java:245)
at com.jbidwatcher.auction.AuctionEntry.findFirstBy(AuctionEntry.java:1591)
at com.jbidwatcher.auction.AuctionEntry.findByIdentifier(AuctionEntry.java:1700)
at com.jbidwatcher.auction.EntryCorral.getItem(EntryCorral.java:126)
at com.jbidwatcher.auction.EntryCorral.getItem(EntryCorral.java:123)
at com.jbidwatcher.auction.EntryCorralTemplate.takeForRead(EntryCorral.java:63)
at com.jbidwatcher.ui.FilterManager.addAuction(FilterManager.java:134)
at com.jbidwatcher.ui.AuctionsManager.addEntry(AuctionsManager.java:152)
at com.jbidwatcher.ui.JBWDropHandler.loadDroppedEntry(JBWDropHandler.java:82)
at com.jbidwatcher.ui.JBWDropHandler.messageAction(JBWDropHandler.java:52)
at com.jbidwatcher.util.queue.PlainMessageQueue.run(PlainMessageQueue.java:56)
at java.lang.Thread.run(Thread.java:680)
Caused by: java.sql.SQLException: A lock could not be obtained due to a deadlock, cycle of locks and waiters is:
Lock : ROW, ENTRIES, (1,70)
Waiting XID : {7854, S} , USER1, SELECT * FROM entries WHERE auction_id = ?
Granted XID : {7853, X}
Lock : ROW, ENTRIES, (1,69)
Waiting XID : {7853, X} , USER1, UPDATE entries SET updated_at=?,identifier=? WHERE id = ?
Granted XID : {7854, S}
. The selected victim is XID : 7854.
at org.apache.derby.impl.jdbc.SQLExceptionFactory.getSQLException(Unknown Source)
at org.apache.derby.impl.jdbc.SQLExceptionFactory40.wrapArgsForTransportAcrossDRDA(Unknown Source)
… 27 more
Caused by: ERROR 40001: A lock could not be obtained due to a deadlock, cycle of locks and waiters is:
Lock : ROW, ENTRIES, (1,70)
Waiting XID : {7854, S} , USER1, SELECT * FROM entries WHERE auction_id = ?
Granted XID : {7853, X}
Lock : ROW, ENTRIES, (1,69)
Waiting XID : {7853, X} , USER1, UPDATE entries SET updated_at=?,identifier=? WHERE id = ?
Granted XID : {7854, S}
. The selected victim is XID : 7854.
at org.apache.derby.iapi.error.StandardException.newException(Unknown Source)
at org.apache.derby.impl.services.locks.Deadlock.buildException(Unknown Source)
at org.apache.derby.impl.services.locks.ConcurrentLockSet.lockObject(Unknown Source)
at org.apache.derby.impl.services.locks.AbstractPool.lockObject(Unknown Source)
at org.apache.derby.impl.services.locks.ConcurrentPool.lockObject(Unknown Source)
at org.apache.derby.impl.store.raw.xact.RowLocking3.lockRecordForRead(Unknown Source)
at org.apache.derby.impl.store.access.heap.HeapController.lockRow(Unknown Source)
at org.apache.derby.impl.store.access.heap.HeapController.lockRow(Unknown Source)
at org.apache.derby.impl.store.access.btree.index.B2IRowLocking3.lockRowOnPage(Unknown Source)
at org.apache.derby.impl.store.access.btree.index.B2IRowLocking3._lockScanRow(Unknown Source)
at org.apache.derby.impl.store.access.btree.index.B2IRowLocking3.lockScanRow(Unknown Source)
at org.apache.derby.impl.store.access.btree.BTreeForwardScan.fetchRows(Unknown Source)
at org.apache.derby.impl.store.access.btree.BTreeScan.fetchNextGroup(Unknown Source)
at org.apache.derby.impl.sql.execute.BulkTableScanResultSet.reloadArray(Unknown Source)
at org.apache.derby.impl.sql.execute.BulkTableScanResultSet.getNextRowCore(Unknown Source)
at org.apache.derby.impl.sql.execute.IndexRowToBaseRowResultSet.getNextRowCore(Unknown Source)
at org.apache.derby.impl.sql.execute.BasicNoPutResultSetImpl.getNextRow(Unknown Source)
… 20 more

Thu Mar 14 10:36:28 EDT 2013: PMQ Caught exception: java.lang.NullPointerException
at com.jbidwatcher.ui.FilterManager.addAuction(FilterManager.java:135)
at com.jbidwatcher.ui.AuctionsManager.addEntry(AuctionsManager.java:152)
at com.jbidwatcher.ui.JBWDropHandler.loadDroppedEntry(JBWDropHandler.java:82)
at com.jbidwatcher.ui.JBWDropHandler.messageAction(JBWDropHandler.java:52)
at com.jbidwatcher.util.queue.PlainMessageQueue.run(PlainMessageQueue.java:56)
at java.lang.Thread.run(Thread.java:680)

Hi Morgan!
I just downloaded and started the 2.5.3pre4 Windows version. At the moment I don’t have any auctions in the Current tab, just ca. 20 in the Complete area.
2.5.3pre4 seems to correct most of the display problems. The only exception is item 200842243333, where the seller is shown as “Q&A” (in the information window it’s shown as Q&A).
In case you need additional information, please let me know and describe what I have to do to retrieve it.
Many thanks!

I’ve had no luck with pre4 on my mac. Switched to mysql to see if that would help. Works for a bit, but the database gets corrupted and entries start to disappear after a few quit/restarts.

I’ve also tried running jbidwatcher pre4 on my mac with java 1.7 after cleaning out all jbidwatcher files, though you have to use the linux version to do so (otherwise you have to re-package with the oracle installer to get the info.plist generated correctly). Unable to change database to mysql, change won’t stick (already dropped the old database). Searches will not save new items to derby database. Removed all files again and ran pre3 for linux on my mac, it is “working.”

Whoops, wasn’t quite done. Working, but not all auctions show up from searches, getting errors in the error log like: (keep in mind, this is pre3 below, not pre4. Pre4 complains about null data and then repeats itself over and over while doing searches and never finishes.)

java.sql.SQLTransactionRollbackException: A lock could not be obtained due to a deadlock, cycle of locks and waiters is:
Lock : ROW, ENTRIES, (1,24)
Waiting XID : {2419, S} , USER1, SELECT * FROM entries WHERE auction_id = ?
Granted XID : {2418, X}
Lock : ROW, ENTRIES, (1,23)
Waiting XID : {2418, X} , USER1, UPDATE entries SET updated_at=?,identifier=? WHERE id = ?
Granted XID : {2419, S}
. The selected victim is XID : 2419.
at org.apache.derby.impl.jdbc.SQLExceptionFactory40.getSQLException(Unknown Source)
at org.apache.derby.impl.jdbc.Util.generateCsSQLException(Unknown Source)
at org.apache.derby.impl.jdbc.TransactionResourceImpl.wrapInSQLException(Unknown Source)
at org.apache.derby.impl.jdbc.TransactionResourceImpl.handleException(Unknown Source)
at org.apache.derby.impl.jdbc.EmbedConnection.handleException(Unknown Source)
at org.apache.derby.impl.jdbc.ConnectionChild.handleException(Unknown Source)
at org.apache.derby.impl.jdbc.EmbedResultSet.closeOnTransactionError(Unknown Source)
at org.apache.derby.impl.jdbc.EmbedResultSet.movePosition(Unknown Source)
at org.apache.derby.impl.jdbc.EmbedResultSet.next(Unknown Source)
at com.jbidwatcher.util.db.Table.getFirstResult(Table.java:273)
at com.jbidwatcher.util.db.Table.getRow(Table.java:363)
at com.jbidwatcher.util.db.Table.findByColumn(Table.java:349)
at com.jbidwatcher.util.db.Table.findByColumn(Table.java:345)
at com.jbidwatcher.util.db.Table.findFirstBy(Table.java:137)
at com.jbidwatcher.util.db.ActiveRecord.findFirstByUncached(ActiveRecord.java:235)
at com.jbidwatcher.util.db.ActiveRecord.findFirstBy(ActiveRecord.java:245)
at com.jbidwatcher.auction.AuctionEntry.findFirstBy(AuctionEntry.java:1591)
at com.jbidwatcher.auction.AuctionEntry.findByIdentifier(AuctionEntry.java:1700)
at com.jbidwatcher.auction.EntryCorral.getItem(EntryCorral.java:126)
at com.jbidwatcher.auction.EntryCorral.getItem(EntryCorral.java:123)
at com.jbidwatcher.auction.EntryCorralTemplate.takeForRead(EntryCorral.java:63)
at com.jbidwatcher.ui.FilterManager.addAuction(FilterManager.java:134)
at com.jbidwatcher.ui.AuctionsManager.addEntry(AuctionsManager.java:152)
at com.jbidwatcher.ui.JBWDropHandler.loadDroppedEntry(JBWDropHandler.java:82)
at com.jbidwatcher.ui.JBWDropHandler.messageAction(JBWDropHandler.java:52)
at com.jbidwatcher.util.queue.PlainMessageQueue.run(PlainMessageQueue.java:56)
at java.lang.Thread.run(Thread.java:722)
Caused by: java.sql.SQLException: A lock could not be obtained due to a deadlock, cycle of locks and waiters is:
Lock : ROW, ENTRIES, (1,24)
Waiting XID : {2419, S} , USER1, SELECT * FROM entries WHERE auction_id = ?
Granted XID : {2418, X}
Lock : ROW, ENTRIES, (1,23)
Waiting XID : {2418, X} , USER1, UPDATE entries SET updated_at=?,identifier=? WHERE id = ?
Granted XID : {2419, S}
. The selected victim is XID : 2419.
at org.apache.derby.impl.jdbc.SQLExceptionFactory.getSQLException(Unknown Source)
at org.apache.derby.impl.jdbc.SQLExceptionFactory40.wrapArgsForTransportAcrossDRDA(Unknown Source)
… 27 more
Caused by: ERROR 40001: A lock could not be obtained due to a deadlock, cycle of locks and waiters is:
Lock : ROW, ENTRIES, (1,24)
Waiting XID : {2419, S} , USER1, SELECT * FROM entries WHERE auction_id = ?
Granted XID : {2418, X}
Lock : ROW, ENTRIES, (1,23)
Waiting XID : {2418, X} , USER1, UPDATE entries SET updated_at=?,identifier=? WHERE id = ?
Granted XID : {2419, S}
. The selected victim is XID : 2419.
at org.apache.derby.iapi.error.StandardException.newException(Unknown Source)
at org.apache.derby.impl.services.locks.Deadlock.buildException(Unknown Source)
at org.apache.derby.impl.services.locks.ConcurrentLockSet.lockObject(Unknown Source)
at org.apache.derby.impl.services.locks.AbstractPool.lockObject(Unknown Source)
at org.apache.derby.impl.services.locks.ConcurrentPool.lockObject(Unknown Source)
at org.apache.derby.impl.store.raw.xact.RowLocking3.lockRecordForRead(Unknown Source)
at org.apache.derby.impl.store.access.heap.HeapController.lockRow(Unknown Source)
at org.apache.derby.impl.store.access.heap.HeapController.lockRow(Unknown Source)
at org.apache.derby.impl.store.access.btree.index.B2IRowLocking3.lockRowOnPage(Unknown Source)
at org.apache.derby.impl.store.access.btree.index.B2IRowLocking3.lockScanRow(Unknown Source)
at org.apache.derby.impl.store.access.btree.index.B2IRowLocking3.lockScanRow(Unknown Source)
at org.apache.derby.impl.store.access.btree.BTreeForwardScan.fetchRows(Unknown Source)
at org.apache.derby.impl.store.access.btree.BTreeScan.fetchNextGroup(Unknown Source)
at org.apache.derby.impl.sql.execute.BulkTableScanResultSet.reloadArray(Unknown Source)
at org.apache.derby.impl.sql.execute.BulkTableScanResultSet.getNextRowCore(Unknown Source)
at org.apache.derby.impl.sql.execute.IndexRowToBaseRowResultSet.getNextRowCore(Unknown Source)
at org.apache.derby.impl.sql.execute.BasicNoPutResultSetImpl.getNextRow(Unknown Source)
… 20 more
Fri Mar 15 09:30:57 EDT 2013: PMQ Caught exception: java.lang.NullPointerException
java.lang.NullPointerException
at com.jbidwatcher.ui.FilterManager.addAuction(FilterManager.java:135)
at com.jbidwatcher.ui.AuctionsManager.addEntry(AuctionsManager.java:152)
at com.jbidwatcher.ui.JBWDropHandler.loadDroppedEntry(JBWDropHandler.java:82)
at com.jbidwatcher.ui.JBWDropHandler.messageAction(JBWDropHandler.java:52)
at com.jbidwatcher.util.queue.PlainMessageQueue.run(PlainMessageQueue.java:56)
at java.lang.Thread.run(Thread.java:722)
java.sql.SQLTransactionRollbackException: A lock could not be obtained due to a deadlock, cycle of locks and waiters is:
Lock : ROW, ENTRIES, (1,22)
Waiting XID : {2418, X} , USER1, UPDATE entries SET updated_at=?,identifier=? WHERE id = ?
Granted XID : {2420, S}
Lock : ROW, ENTRIES, (1,23)
Waiting XID : {2420, S} , USER1, SELECT e.* FROM entries e JOIN auctions a ON a.id = e.auction_id WHERE (e.ended != 1 OR e.ended IS NULL) AND (e.last_updated_at IS NULL OR e.last_updated_at < ?) ORDER BY a.ending_at ASC
Granted XID : {2418, X}
. The selected victim is XID : 2418.
at org.apache.derby.impl.jdbc.SQLExceptionFactory40.getSQLException(Unknown Source)
at org.apache.derby.impl.jdbc.Util.generateCsSQLException(Unknown Source)
at org.apache.derby.impl.jdbc.TransactionResourceImpl.wrapInSQLException(Unknown Source)
at org.apache.derby.impl.jdbc.TransactionResourceImpl.handleException(Unknown Source)
at org.apache.derby.impl.jdbc.EmbedConnection.handleException(Unknown Source)
at org.apache.derby.impl.jdbc.ConnectionChild.handleException(Unknown Source)
at org.apache.derby.impl.jdbc.EmbedStatement.executeStatement(Unknown Source)
at org.apache.derby.impl.jdbc.EmbedPreparedStatement.executeStatement(Unknown Source)
at org.apache.derby.impl.jdbc.EmbedPreparedStatement.execute(Unknown Source)
at com.jbidwatcher.util.db.Table.updateMap(Table.java:334)
at com.jbidwatcher.util.db.Table.insertOrUpdate(Table.java:302)
at com.jbidwatcher.util.db.ActiveRecord.saveDB(ActiveRecord.java:116)
at com.jbidwatcher.auction.AuctionEntry.saveDB(AuctionEntry.java:1549)
at com.jbidwatcher.auction.AuctionEntry.setAuctionInfo(AuctionEntry.java:1361)
at com.jbidwatcher.auction.AuctionEntry.findByIdentifier(AuctionEntry.java:1701)
at com.jbidwatcher.auction.EntryCorral.getItem(EntryCorral.java:126)
at com.jbidwatcher.auction.EntryCorral.getItem(EntryCorral.java:123)
at com.jbidwatcher.auction.EntryCorralTemplate.takeForRead(EntryCorral.java:63)
at com.jbidwatcher.ui.FilterManager.messageAction(FilterManager.java:86)
at com.jbidwatcher.util.queue.PlainMessageQueue.run(PlainMessageQueue.java:56)
at java.lang.Thread.run(Thread.java:722)
Caused by: java.sql.SQLException: A lock could not be obtained due to a deadlock, cycle of locks and waiters is:
Lock : ROW, ENTRIES, (1,22)
Waiting XID : {2418, X} , USER1, UPDATE entries SET updated_at=?,identifier=? WHERE id = ?
Granted XID : {2420, S}
Lock : ROW, ENTRIES, (1,23)
Waiting XID : {2420, S} , USER1, SELECT e.* FROM entries e JOIN auctions a ON a.id = e.auction_id WHERE (e.ended != 1 OR e.ended IS NULL) AND (e.last_updated_at IS NULL OR e.last_updated_at < ?) ORDER BY a.ending_at ASC
Granted XID : {2418, X}
. The selected victim is XID : 2418.
at org.apache.derby.impl.jdbc.SQLExceptionFactory.getSQLException(Unknown Source)
at org.apache.derby.impl.jdbc.SQLExceptionFactory40.wrapArgsForTransportAcrossDRDA(Unknown Source)
… 21 more
Caused by: ERROR 40001: A lock could not be obtained due to a deadlock, cycle of locks and waiters is:
Lock : ROW, ENTRIES, (1,22)
Waiting XID : {2418, X} , USER1, UPDATE entries SET updated_at=?,identifier=? WHERE id = ?
Granted XID : {2420, S}
Lock : ROW, ENTRIES, (1,23)
Waiting XID : {2420, S} , USER1, SELECT e.* FROM entries e JOIN auctions a ON a.id = e.auction_id WHERE (e.ended != 1 OR e.ended IS NULL) AND (e.last_updated_at IS NULL OR e.last_updated_at < ?) ORDER BY a.endingat ASC
Granted XID : {2418, X}
. The selected victim is XID : 2418.
at org.apache.derby.iapi.error.StandardException.newException(Unknown Source)
at org.apache.derby.impl.services.locks.Deadlock.buildException(Unknown Source)
at org.apache.derby.impl.services.locks.ConcurrentLockSet.lockObject(Unknown Source)
at org.apache.derby.impl.services.locks.ConcurrentLockSet.zeroDurationLockObject(Unknown Source)
at org.apache.derby.impl.services.locks.AbstractPool.zeroDurationlockObject(Unknown Source)
at org.apache.derby.impl.services.locks.ConcurrentPool.zeroDurationlockObject(Unknown Source)
at org.apache.derby.impl.store.raw.xact.RowLocking3.zeroDurationLockRecordForWrite(Unknown Source)
at org.apache.derby.impl.store.access.heap.HeapController.lockRow(Unknown Source)
at org.apache.derby.impl.store.access.heap.HeapController.lockRow(Unknown Source)
at org.apache.derby.impl.store.access.btree.index.B2IRowLocking3.lockRowOnPage(Unknown Source)
at org.apache.derby.impl.store.access.btree.index.B2IRowLocking3.lockNonScanPreviousRow(Unknown Source)
at org.apache.derby.impl.store.access.btree.BTreeController.doIns(Unknown Source)
at org.apache.derby.impl.store.access.btree.BTreeController.insert(Unknown Source)
at org.apache.derby.impl.store.access.btree.index.B2IController.insert(Unknown Source)
at org.apache.derby.impl.sql.execute.IndexChanger.insertAndCheckDups(Unknown Source)
at org.apache.derby.impl.sql.execute.IndexChanger.doInsert(Unknown Source)
at org.apache.derby.impl.sql.execute.IndexChanger.insertForUpdate(Unknown Source)
at org.apache.derby.impl.sql.execute.IndexChanger.update(Unknown Source)
at org.apache.derby.impl.sql.execute.IndexSetChanger.update(Unknown Source)
at org.apache.derby.impl.sql.execute.RowChangerImpl.updateRow(Unknown Source)
at org.apache.derby.impl.sql.execute.UpdateResultSet.collectAffectedRows(Unknown Source)
at org.apache.derby.impl.sql.execute.UpdateResultSet.open(Unknown Source)
at org.apache.derby.impl.sql.GenericPreparedStatement.executeStmt(Unknown Source)
at org.apache.derby.impl.sql.GenericPreparedStatement.execute(Unknown Source)
… 15 more

My auctions also went to (null) and I quit the application in horror.

Now only auctions with active snipes are left … all others are gone. But somehow – when clicking on the update auction toolbar button I have the impression that all auctions are still there, but not displayed. Strange. What happened here?

I’m afraid not working for me – no longer bids – the error log shows: Wed Mar 20 09:04:02 GMT 2013: PMQ Caught exception: java.lang.NullPointerException. Otherwise interface seems ok – I found that deleting the old database and getting ‘My Items’ afreash cured the (null) problem for items. The only other problem I can see is that if fails to get the number of bids for items that have a ‘Buy it now’ price but are also up for auction. But for now EbayWatcher is unusable as it doesn’t bid. I’ve tested on two different PC’s both running Windows XP (32 bit) with Java 7 update 17.

Hoddy

EBay has completely changed the layout for .DE, which is most probably why you are experiencing these ‘null’ issues which I have seen, too. All auctions without set snipes then get lost completely, I haven’t tried having it snipe, since it is already quite broken.
My workaround here is a change to ebay.co.uk for all auctions, which at least made it possible to re-import all auctions and have snipes fire ok.
Auctions are still all shown with a pound sign, even though they are listed in EUR, but bidding (sniping) in EUR does work (just ignore the symbol). Hth.

Update: And much as luck goes, after 10 days of successful auctions on ebay.co.uk, things went (null) there, too. Changing to ebay.com, deleting all auctions, clearing deleted tracking and reimporting all of them fixed it for the moment. Guess some servers in the UK were updated, too.

Removed all traces of previous versions, renamed .jbidwatcher user folder to old. Downloaded and ran 2.5.3pre4. Correctly loaded watch list of 6 items. Several hours later all had turned to (null) and can not be added back. Renamed .jbidwatcher user folder to bak.
Re-installed 2.5.3pre3.

Now, at this time, I have no more the Fixed Price bug with 2.5.3 pre3 (but I have it some hours early).
Surely Ebay change something… ???

Yeah pre4 is not good. When I went to this about half my auctions (all US auctions) showed up as (null). I closed out and tried to reopen as pre3 and all those auctions were removed. Sucks, as it was at least 25 auctions that will take a while to refind. Going forward I’ll definitely backup .jbidwatcher/ before trying any other releases just to be safe – hope no one else tries this version without doing so first.

Keep up the good work morgan! I’ve donated a few times before, probably will again whenever you release a good bugfix version.

2.5.3pre4 won’t work at all for me. Running on Linux, I’ve moved my .jbidwatcher directory out of the way so I’m starting from clean, but I always get a NullPointerException when it tries to load auctions from MyEbay.

Sat Apr 13 08:37:37 BST 2013: Loading page: http://my.ebay.com/ws/eBayISAPI.dll?MyEbayBeta&CurrentPage=MyeBayNextBidding
Sat Apr 13 08:37:37 BST 2013: Parsing URL http://my.ebay.com/ws/eBayISAPI.dll?MyEbayBeta&CurrentPage=MyeBayNextBidding
Sat Apr 13 08:37:37 BST 2013: Loading page 1 of My eBay for user slimey3
Sat Apr 13 08:37:37 BST 2013: URL: http://my.ebay.com/ws/eBayISAPI.dll?MyEbayBeta&SortOrder=ASCEND&GotoPage=1&View=SellingNext&Column=EndTime&
CurrentPage=MyeBayNextSelling&SellingNext.Filter=All&&tagname=All%20Lists&
ssPageName=STRK:ME:PAGE&StoreCatFilter=0&SubmitAction.ChangePage=x&FormatFilter=AllFormat
Sat Apr 13 08:37:37 BST 2013: Parsing URL http://my.ebay.com/ws/eBayISAPI.dll?MyEbayBeta&SortOrder=ASCEND&GotoPage=1&View=SellingNext&Column=EndTime&
CurrentPage=MyeBayNextSelling&SellingNext.Filter=All&&tagname=All%20Lists&
ssPageName=STRK:ME:PAGE&StoreCatFilter=0&SubmitAction.ChangePage=x&FormatFilter=AllFormat
Sat Apr 13 08:37:37 BST 2013: Got a bad end of compressed input stream.
Sat Apr 13 08:37:37 BST 2013: Bad input tag (ignoring): button id=“EditButton_1452” style=“padding:0;width:auto;overflow:visible;” class=“sfbtn”
Sat Apr 13 08:37:37 BST 2013: Parsing URL http://www.ebay.com/itm/161000942612?ssPageName=STRK:MEWAX:IT&_trksid=p3984.m1438.l2648
Sat Apr 13 08:37:37 BST 2013: Parsing URL http://cgi.ebay.co.uk/ws/eBayISAPI.dll?ViewItem&item=161000942612
Sat Apr 13 08:37:37 BST 2013: Parsing URL http://cgi.ebay.co.uk/ws/eBayISAPI.dll?ViewItem&item=161000942612
Sat Apr 13 08:37:39 BST 2013: Parsing URL http://thumbs1.ebaystatic.com/d/l225/m/mW38tfn3cIJZRYr5rrWvxYQ.jpg
Sat Apr 13 08:37:39 BST 2013: Loaded null.
Sat Apr 13 08:37:39 BST 2013: PMQ Caught exception: java.lang.NullPointerException
java.lang.NullPointerException
at com.jbidwatcher.ui.FilterManager.addAuction(FilterManager.java:135)
at com.jbidwatcher.ui.AuctionsManager.addEntry(AuctionsManager.java:152)
at com.jbidwatcher.ui.JBWDropHandler.loadDroppedEntry(JBWDropHandler.java:82)
at com.jbidwatcher.ui.JBWDropHandler.messageAction(JBWDropHandler.java:52)
at com.jbidwatcher.util.queue.PlainMessageQueue.run(PlainMessageQueue.java:56)
at java.lang.Thread.run(Thread.java:662)

damnit same here lost all my auctions

you can get your auctions back by looking through the latest couple logfiles in the .jbidwatcher folder. there will be a bunch of “parsing URL” lines at the beginning. paste in those auction #s and you’ll get them all back.

Morgan,

Is there anything we can do to help you get things working again? I note you’ve not released the source to 2.5.3pre4 yet, otherwise I’d be willing to dive in and see if I can help fix some issues…

EDIT

I’ve just found the source to 2.5.3pre4, and I’ve also found 2.5.3pre5 too :)

2.5.3pre5 is working pretty well for me – no crash on startup, and thumbnails have started working again. I’ll run with it for a while and see how stable it is…

Greetings,
@slimey – My issue with 2.5.3pre5 is that it occasionally loses its mind. Specifically, there is a relationship between AuctionEntry objects and AuctionInfo objects (AuctionInfo is supposed to be the data from eBay, AuctionEntry objects are the metadata JBidwatcher adds to them), and that relationship gets lost. I think it’s a caching issue, where an update occurs and the AuctionEntry objects don’t update their AuctionInfo reference (auction_id) and the old AuctionInfo gets deleted, so now the AuctionInfo is orphaned and the AuctionEntry has no data (title, price, etc.) to show.

I haven’t figured out why, yet. This weekend may be one of my last chances to before I have a lot of family and work obligations piling up.

If you want to run with JBidwatcher from my keyboard to yours, you can get it at http://github.com/cyberfox/jbidwatcher … and if you want to make changes (and I encourage it!), or suggest changes with example implementations, I vastly prefer GitHub pull-requests with the changes.

— Morgan Schweers, CyberFOX!

Hi,

thanks for your great work! I have been using JBidwatcher for some time and I really like it.

With 2.5.3pre4 I get a NullPointerException for this item: 111058016387. I am using the ebay.co.uk site and the URL displays fine in my web browser.
>Thu Apr 25 09:29:08 CEST 2013: Parsing URL http://cgi.ebay.co.uk/ws/eBayISAPI.dll?ViewItem&item=111058016387
Thu Apr 25 09:29:08 CEST 2013: Parsing URL http://cgi.ebay.co.uk/ws/eBayISAPI.dll?ViewItem&item=111058016387
Thu Apr 25 09:29:09 CEST 2013: Parsing URL http://thumbs4.ebaystatic.com/d/l225/m/meHIQfV8I66YQybPr0JWP8A.jpg
Thu Apr 25 09:29:09 CEST 2013: Parsing URL http://offer.ebay.co.uk/ws/eBayISAPI.dll?ViewBids&item=null
Thu Apr 25 09:29:09 CEST 2013: PMQ Caught exception: java.lang.NullPointerException
java.lang.NullPointerException
at com.jbidwatcher.ui.FilterManager.addAuction(FilterManager.java:135)
at com.jbidwatcher.ui.AuctionsManager.addEntry(AuctionsManager.java:152)
at com.jbidwatcher.ui.commands.UserActions.addAuction(UserActions.java:142)
at com.jbidwatcher.ui.commands.UserActions.cmdAddAuction(UserActions.java:158)
at com.jbidwatcher.ui.commands.UserActions.handleStringMessage(UserActions.java:102)
at com.jbidwatcher.ui.commands.UserActions.messageAction(UserActions.java:88)
at com.jbidwatcher.util.queue.PlainMessageQueue.run(PlainMessageQueue.java:56)
at java.lang.Thread.run(Thread.java:679)

Any help is greatly appreciated.

Best regards,
Chris

Well,running 2.5.3pre5 for almost a week, it was going brilliant until today – and now all my auctions are showing as “null (0)”

There were a bunch of errors logged:

Mon Apr 29 02:39:38 BST 2013: Unexpected exception during high bidder check.
java.lang.IllegalMonitorStateException
at java.util.concurrent.locks.ReentrantLock$Sync.tryRelease(ReentrantLock.java:127)
at java.util.concurrent.locks.AbstractQueuedSynchronizer.release(AbstractQueuedSynchronizer.java:1239)
at java.util.concurrent.locks.ReentrantLock.unlock(ReentrantLock.java:431)
at com.jbidwatcher.auction.EntryCorralTemplate.release(EntryCorral.java:57)
at com.jbidwatcher.auction.server.ebay.ebayServer.updateHighBid(ebayServer.java:187)
at com.jbidwatcher.auction.AuctionEntry.updateHighBid(AuctionEntry.java:508)
[snip]

Then lots of (presumably one per auction):

Mon Apr 29 02:39:38 BST 2013: PMQ Caught exception: java.lang.NullPointerException
java.lang.NullPointerException
at com.jbidwatcher.ui.FilterManager.messageAction(FilterManager.java:84)
at com.jbidwatcher.util.queue.PlainMessageQueue.run(PlainMessageQueue.java:60)
at java.lang.Thread.run(Thread.java:662)

Mon Apr 29 02:39:40 BST 2013: PMQ Caught exception: java.lang.NullPointerException
java.lang.NullPointerException
at com.jbidwatcher.ui.table.AuctionTable$1.match(AuctionTable.java:100)
at com.jbidwatcher.ui.table.BaseTransformation.findRow(BaseTransformation.java:80)
at com.jbidwatcher.ui.table.AuctionTable.messageAction(AuctionTable.java:98)
at com.jbidwatcher.util.queue.PlainMessageQueue.run(PlainMessageQueue.java:60)
at java.lang.Thread.run(Thread.java:662)

I use JBidwatcher 2.5.3pre3-2-g03a9bc3 — I will upgrade to pre4 now that I see it exists; but this “problem” or potential enhancement probably apply to post release.

I have an item that end at Sat May 04 15:55:04 EDT

And snipe did not launch. I check the item information and I see:

Sat May 04 15:52:50 EDT 2013: Cancelling snipe.
Sat May 04 15:52:50 EDT 2013: Pre-snipe login failed. Snipe will be retried, but is unlikely to fire.
Sat May 04 15:52:50 EDT 2013: Preparing snipe.

Was the decision to not snipe taken 3 minutes before the snipe? If so, won’t it be a good idea to retry a couple of time when it fails 3 minutes before. Back in the time this never happened to me (I never noticed) and recently it does happen a lot (and it happened twice on similar item I wanted more than others, bad coincidence).

To add to my just previous post, I got the pre-snipe login failed error live, so I decide to go in eBay > Refresh eBay Session. And it failed 2-3 times, then it worked. Why it failed and worked the 3rd or 4th time is mystery, I have not dig… but I have noticed that eBay sometime try 2-3 different layout at the same time and you may end up with one or another sometime (like the interface to see completed, sold, active listing, there is at least 3 different version I see going around when I do my search directly on eBay); so that might not help when Jbidwatcher try to parse the HTML if there is different layout.

P.S. I do use eBay with an account identified as Canadian, and another one identified as an US account (and I feel the US account often have a more recent version of the interface that eventually reach the Canadian’s one).

I’d love to see this program be #1 in ebay sniping, but in it’s current state, it’s a shitfight. I would be more than happy to pay for it if it worked as advertised.