Recent Posts by mrnuxi

Subscribe to Recent Posts by mrnuxi 3 post(s) found

Jan 30, 2018
Avatar mrnuxi 3 post(s)

Comment Topic: JBidwatcher Development / derbyLocale_os.jar missing

In run JUnit tests for jbidwatcher (cloned from the git repo), I hit a failure due the missing jar file “derbyLocale_os.jar”.

Thanks.

 
Jan 25, 2018
Avatar mrnuxi 3 post(s)

Comment Topic: JBidwatcher Development / Missing source code?

On Windows 10, using git, IntelliJ Idea, and Java JDK 9 I tried building jbidwatcher after cloning the git repo [master]. src/com/jbidwatcher/app/JBidWatch.java failed to compile due to the missing import:

import com.cyberfox.util.platform.osx.NoNap;

looking at the src tree, under com/cyberfox/util/platform, there are no subdirectories, just Path.java and Platform.java …

I suspect the “osx” is an apple-related dir

Update: I commented out the import and the section of code that had:
if(Platform.isMac()) {
NoNap.dontNapMeBro();
}

Now it builds and I am moving on to running the Unit tests (about half of which fail) … investigating.

Thanks!

 
May 12, 2012
Avatar mrnuxi 3 post(s)

Comment Topic: JBidwatcher Development / SQL bug in 2.5.0

Right when an auction ended on which I had a multisnipe (my bid was lower than the high bid at the time of the snipe), I saw a bunch of messages streaming by in the log. It turned out to be a stack trace. jbidwatcher had no externally visible effects from this and seems unaffected.

Running jbidwatcher 2.5-0-g8f10beb on:
OS Centos 5.7 (kernel 2.6.18-308.4.1.el5)
java $ java -version
java version “1.7.0_03”
Java™ SE Runtime Environment (build 1.7.0_03-b04)
Java HotSpot™ 64-Bit Server VM (build 22.1-b02, mixed mode)

Right around the time an auction ended (multisnipe) I got the following stacktrace:

java.sql.SQLException: An attempt was made to put a data value of type ‘int’ into a data value of type ‘TIMESTAMP’.
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.EmbedResultSet.noStateChangeException(Unknown Source)
at org.apache.derby.impl.jdbc.EmbedPreparedStatement.setInt(Unknown Source)
at com.jbidwatcher.util.db.Table.setColumn(Table.java:507)
at com.jbidwatcher.util.db.Table.setPreparedUpdate(Table.java:463)
at com.jbidwatcher.util.db.Table.updateMap(Table.java:329)
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:1550)
at com.jbidwatcher.auction.AuctionEntry.setNeedsUpdate(AuctionEntry.java:1044)
at com.jbidwatcher.auction.AuctionEntry.checkEnded(AuctionEntry.java:268)
at com.jbidwatcher.auction.AuctionEntry.setAuctionInfo(AuctionEntry.java:1361)
at com.jbidwatcher.auction.server.AuctionServer.reload(AuctionServer.java:194)
at com.jbidwatcher.auction.AuctionEntry.update(AuctionEntry.java:901)
at com.jbidwatcher.auction.Auctions.doUpdate(Auctions.java:92)
at com.jbidwatcher.ui.AuctionsManager.updateList(AuctionsManager.java:130)
at com.jbidwatcher.ui.AuctionsManager.check(AuctionsManager.java:107)
at com.jbidwatcher.util.queue.TimerHandler.run(TimerHandler.java:62)
Caused by: java.sql.SQLException: An attempt was made to put a data value of type ‘int’ into a data value of type ‘TIMESTAMP’.
at org.apache.derby.impl.jdbc.SQLExceptionFactory.getSQLException(Unknown Source)
at org.apache.derby.impl.jdbc.SQLExceptionFactory40.wrapArgsForTransportAcrossDRDA(Unknown Source)
… 20 more
Caused by: ERROR XCL12: An attempt was made to put a data value of type ‘int’ into a data value of type ‘TIMESTAMP’.
at org.apache.derby.iapi.error.StandardException.newException(Unknown Source)
at org.apache.derby.iapi.types.DataType.throwLangSetMismatch(Unknown Source)
at org.apache.derby.iapi.types.DataType.setValue(Unknown Source)
… 16 more
Sat May 12 09:08:17 MDT 2012: Error from columns: (2,category_id, INTEGER, 2)
java.sql.SQLException: An attempt was made to put a data value of type ‘short’ into a data value of type ‘TIMESTAMP’.
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.EmbedResultSet.noStateChangeException(Unknown Source)
at org.apache.derby.impl.jdbc.EmbedPreparedStatement.setShort(Unknown Source)
at com.jbidwatcher.util.db.Table.setColumn(Table.java:515)
at com.jbidwatcher.util.db.Table.setPreparedUpdate(Table.java:463)
at com.jbidwatcher.util.db.Table.updateMap(Table.java:329)
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:1550)
at com.jbidwatcher.auction.AuctionEntry.setNeedsUpdate(AuctionEntry.java:1044)
at com.jbidwatcher.auction.AuctionEntry.checkEnded(AuctionEntry.java:268)
at com.jbidwatcher.auction.AuctionEntry.setAuctionInfo(AuctionEntry.java:1361)
at com.jbidwatcher.auction.server.AuctionServer.reload(AuctionServer.java:194)
at com.jbidwatcher.auction.AuctionEntry.update(AuctionEntry.java:901)
at com.jbidwatcher.auction.Auctions.doUpdate(Auctions.java:92)
at com.jbidwatcher.ui.AuctionsManager.updateList(AuctionsManager.java:130)
at com.jbidwatcher.ui.AuctionsManager.check(AuctionsManager.java:107)
at com.jbidwatcher.util.queue.TimerHandler.run(TimerHandler.java:62)
Caused by: java.sql.SQLException: An attempt was made to put a data value of type ‘short’ into a data value of type ‘TIMESTAMP’.
at org.apache.derby.impl.jdbc.SQLExceptionFactory.getSQLException(Unknown Source)
at org.apache.derby.impl.jdbc.SQLExceptionFactory40.wrapArgsForTransportAcrossDRDA(Unknown Source)
… 20 more
Caused by: ERROR XCL12: An attempt was made to put a data value of type ‘short’ into a data value of type ‘TIMESTAMP’.
at org.apache.derby.iapi.error.StandardException.newException(Unknown Source)
at org.apache.derby.iapi.types.DataType.throwLangSetMismatch(Unknown Source)
at org.apache.derby.iapi.types.DataType.setValue(Unknown Source)
… 16 more
Sat May 12 09:08:17 MDT 2012: Error from columns: (3,sticky, SMALLINT, 1)
Sat May 12 09:08:17 MDT 2012: Failing to insert “2012-05-12 09:08:17” into column 3 of table entries
java.sql.SQLException: An attempt was made to put a data value of type ‘java.sql.Timestamp’ into a data value of type ‘INTEGER’.
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.EmbedResultSet.noStateChangeException(Unknown Source)
at org.apache.derby.impl.jdbc.EmbedPreparedStatement.setTimestamp(Unknown Source)
at org.apache.derby.impl.jdbc.EmbedPreparedStatement.setTimestamp(Unknown Source)
at com.jbidwatcher.util.db.Table.setColumn(Table.java:494)
at com.jbidwatcher.util.db.Table.setPreparedUpdate(Table.java:463)
at com.jbidwatcher.util.db.Table.updateMap(Table.java:329)
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:1550)
at com.jbidwatcher.auction.AuctionEntry.setNeedsUpdate(AuctionEntry.java:1044)
at com.jbidwatcher.auction.AuctionEntry.checkEnded(AuctionEntry.java:268)
at com.jbidwatcher.auction.AuctionEntry.setAuctionInfo(AuctionEntry.java:1361)
at com.jbidwatcher.auction.server.AuctionServer.reload(AuctionServer.java:194)
at com.jbidwatcher.auction.AuctionEntry.update(AuctionEntry.java:901)
at com.jbidwatcher.auction.Auctions.doUpdate(Auctions.java:92)
at com.jbidwatcher.ui.AuctionsManager.updateList(AuctionsManager.java:130)
at com.jbidwatcher.ui.AuctionsManager.check(AuctionsManager.java:107)
at com.jbidwatcher.util.queue.TimerHandler.run(TimerHandler.java:62)
Caused by: java.sql.SQLException: An attempt was made to put a data value of type ‘java.sql.Timestamp’ into a data value of type ‘INTEGER’.
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 XCL12: An attempt was made to put a data value of type ‘java.sql.Timestamp’ into a data value of type ‘INTEGER’.
at org.apache.derby.iapi.error.StandardException.newException(Unknown Source)
at org.apache.derby.iapi.types.DataType.throwLangSetMismatch(Unknown Source)
at org.apache.derby.iapi.types.DataType.setValue(Unknown Source)
… 17 more
Sat May 12 09:08:17 MDT 2012: Error from columns: (4,updated_at, TIMESTAMP, 2012-05-12 09:08:17)
java.sql.SQLException: The parameter position ‘4’ is out of range. The number of parameters for this prepared statement is ‘3’.
at org.apache.derby.impl.jdbc.SQLExceptionFactory40.getSQLException(Unknown Source)
at org.apache.derby.impl.jdbc.Util.newEmbedSQLException(Unknown Source)
at org.apache.derby.impl.jdbc.Util.newEmbedSQLException(Unknown Source)
at org.apache.derby.impl.jdbc.Util.generateCsSQLException(Unknown Source)
at org.apache.derby.impl.jdbc.EmbedConnection.newSQLException(Unknown Source)
at org.apache.derby.impl.jdbc.ConnectionChild.newSQLException(Unknown Source)
at org.apache.derby.impl.jdbc.EmbedPreparedStatement.getTypes(Unknown Source)
at org.apache.derby.impl.jdbc.EmbedPreparedStatement.getParameterJDBCType(Unknown Source)
at org.apache.derby.impl.jdbc.EmbedPreparedStatement.setNull(Unknown Source)
at com.jbidwatcher.util.db.Table.setColumn(Table.java:492)
at com.jbidwatcher.util.db.Table.setPreparedUpdate(Table.java:463)
at com.jbidwatcher.util.db.Table.updateMap(Table.java:329)
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:1550)
at com.jbidwatcher.auction.AuctionEntry.setNeedsUpdate(AuctionEntry.java:1044)
at com.jbidwatcher.auction.AuctionEntry.checkEnded(AuctionEntry.java:268)
at com.jbidwatcher.auction.AuctionEntry.setAuctionInfo(AuctionEntry.java:1361)
at com.jbidwatcher.auction.server.AuctionServer.reload(AuctionServer.java:194)
at com.jbidwatcher.auction.AuctionEntry.update(AuctionEntry.java:901)
at com.jbidwatcher.auction.Auctions.doUpdate(Auctions.java:92)
at com.jbidwatcher.ui.AuctionsManager.updateList(AuctionsManager.java:130)
at com.jbidwatcher.ui.AuctionsManager.check(AuctionsManager.java:107)
at com.jbidwatcher.util.queue.TimerHandler.run(TimerHandler.java:62)
Caused by: java.sql.SQLException: The parameter position ‘4’ is out of range. The number of parameters for this prepared statement is ‘3’.
at org.apache.derby.impl.jdbc.SQLExceptionFactory.getSQLException(Unknown Source)
at org.apache.derby.impl.jdbc.SQLExceptionFactory40.wrapArgsForTransportAcrossDRDA(Unknown Source)
… 24 more
Sat May 12 09:08:17 MDT 2012: Error from columns: (5,last_updated_at, TIMESTAMP, null)