force JBidwatcher to re-import auctions.xml

Subscribe to force JBidwatcher to re-import auctions.xml 4 post(s), 2 voice(s)

 
Avatar laalaa99stl 4 post(s)

Hi

My Win7x64 machine BSOD’ed this morning and my JBidwatcher has been unhappy ever since. It seems the program will hang while loading auctions. I checked in the process manager. There is no disk activity or CPU activity. The program simply becomes a zombie. I tried renaming the jbdb to jbdb.bak and restarting, but it failed to re-import the auctions.xml file. It’s just an empty table. I checked the auctions.xml file in a text editor. It looks fine. I even tried using one of the many many many (really, why does JBidwatcher keep so many?) backup auctions.xml files and none of those work either. I tried re-installing Java 8. I even tried downgrading to Java 7. I also tried older and newer versions of JBidwatcher. Same result. Hangs if trying to open the current database. Completely ignores the auctions.xml file if I try to force it to rebuild the database. Is there a way to really really really FORCE JBidwatcher to rebuild the Derby database using the auctions.xml file other than renaming the database folder (which doesn’t seem to be working)? An import auctions menu item would be super useful. I’m at wit’s end, having spent a half day on this already. I’m attaching my debugging output:

Thu Apr 07 13:45:04 EDT 2016: Couldn’t set up tray access: C:\Users\user\.jbidwatcher\platform\tray.dll: Can’t load IA 32-bit .dll on a AMD 64-bit platform
Thu Apr 07 13:45:04 EDT 2016: JBidwatcher 2.5.6-11-gac197d6
Thu Apr 07 13:45:04 EDT 2016: Oracle Corporation Java, version 1.8.0_77 on Windows 7
Thu Apr 07 13:45:04 EDT 2016: Logging to C:\Users\user\.jbidwatcher\errors.537.log
Thu Apr 07 13:45:05 EDT 2016: Loaded the appropriate driver.
Thu Apr 07 13:45:05 EDT 2016: Upgrading error
Failed to create database ‘jbdb’, see the next exception for details.
java.sql.SQLException: Failed to create database ‘jbdb’, see the next exception for details.
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.seeNextException(Unknown Source)
at org.apache.derby.impl.jdbc.EmbedConnection.createDatabase(Unknown Source)
at org.apache.derby.impl.jdbc.EmbedConnection.(Unknown Source)
at org.apache.derby.impl.jdbc.EmbedConnection30.(Unknown Source)
at org.apache.derby.impl.jdbc.EmbedConnection40.(Unknown Source)
at org.apache.derby.jdbc.Driver40.getNewEmbedConnection(Unknown Source)
at org.apache.derby.jdbc.InternalDriver.connect(Unknown Source)
at org.apache.derby.jdbc.AutoloadedDriver.connect(Unknown Source)
at java.sql.DriverManager.getConnection(Unknown Source)
at java.sql.DriverManager.getConnection(Unknown Source)
at com.jbidwatcher.util.db.Database.setup(Database.java:101)
at com.jbidwatcher.util.db.Database.(Database.java:62)
at com.jbidwatcher.Upgrader.upgrade(Upgrader.java:26)
at com.jbidwatcher.app.JBidWatch.main(JBidWatch.java:429)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
at java.lang.reflect.Method.invoke(Unknown Source)
at com.simontuffs.onejar.Boot.run(Boot.java:342)
at com.simontuffs.onejar.Boot.main(Boot.java:168)
Caused by: java.sql.SQLException: Failed to create database ‘jbdb’, see the next exception for details.
at org.apache.derby.impl.jdbc.SQLExceptionFactory.getSQLException(Unknown Source)
at org.apache.derby.impl.jdbc.SQLExceptionFactory40.wrapArgsForTransportAcrossDRDA(Unknown Source)
… 22 more
Caused by: java.sql.SQLException: Directory C:\Users\user\.jbidwatcher\C:\Users\user\.jbidwatcher\jbdb already exists.
at org.apache.derby.impl.jdbc.SQLExceptionFactory.getSQLException(Unknown Source)
at org.apache.derby.impl.jdbc.SQLExceptionFactory40.wrapArgsForTransportAcrossDRDA(Unknown Source)
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)
… 19 more
Caused by: ERROR XBM0J: Directory C:\Users\user\.jbidwatcher\C:\Users\user\.jbidwatcher\jbdb already exists.
at org.apache.derby.iapi.error.StandardException.newException(Unknown Source)
at org.apache.derby.impl.services.monitor.StorageFactoryService$9.run(Unknown Source)
at java.security.AccessController.doPrivileged(Native Method)
at org.apache.derby.impl.services.monitor.StorageFactoryService.createServiceRoot(Unknown Source)
at org.apache.derby.impl.services.monitor.BaseMonitor.bootService(Unknown Source)
at org.apache.derby.impl.services.monitor.BaseMonitor.createPersistentService(Unknown Source)
at org.apache.derby.iapi.services.monitor.Monitor.createPersistentService(Unknown Source)
… 19 more
Thu Apr 07 13:45:06 EDT 2016: Scripting is not enabled.
Thu Apr 07 13:45:08 EDT 2016: Loaded the appropriate driver.
Thu Apr 07 13:45:08 EDT 2016: JBidwatcher: java.lang.RuntimeException: Can’t access the auctions database table
Can’t access the auctions database table
java.lang.RuntimeException: Can’t access the auctions database table
at com.jbidwatcher.util.db.ActiveRecord.openDB(ActiveRecord.java:32)
at com.jbidwatcher.auction.AuctionInfo.getRealDatabase(AuctionInfo.java:397)
at com.jbidwatcher.auction.AuctionInfo.getDatabase(AuctionInfo.java:394)
at com.jbidwatcher.util.db.ActiveRecord.count(ActiveRecord.java:63)
at com.jbidwatcher.auction.AuctionInfo.count(AuctionInfo.java:428)
at com.jbidwatcher.ui.AuctionsManager.loadAuctionsFromDatabase(AuctionsManager.java:217)
at com.jbidwatcher.app.JBidWatch.(JBidWatch.java:654)
at com.jbidwatcher.app.JBidWatch.main(JBidWatch.java:477)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
at java.lang.reflect.Method.invoke(Unknown Source)
at com.simontuffs.onejar.Boot.run(Boot.java:342)
at com.simontuffs.onejar.Boot.main(Boot.java:168)
Caused by: java.sql.SQLException: Failed to create database ‘jbdb’, see the next exception for details.
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.seeNextException(Unknown Source)
at org.apache.derby.impl.jdbc.EmbedConnection.createDatabase(Unknown Source)
at org.apache.derby.impl.jdbc.EmbedConnection.(Unknown Source)
at org.apache.derby.impl.jdbc.EmbedConnection30.(Unknown Source)
at org.apache.derby.impl.jdbc.EmbedConnection40.(Unknown Source)
at org.apache.derby.jdbc.Driver40.getNewEmbedConnection(Unknown Source)
at org.apache.derby.jdbc.InternalDriver.connect(Unknown Source)
at org.apache.derby.jdbc.AutoloadedDriver.connect(Unknown Source)
at java.sql.DriverManager.getConnection(Unknown Source)
at java.sql.DriverManager.getConnection(Unknown Source)
at com.jbidwatcher.util.db.Database.setup(Database.java:101)
at com.jbidwatcher.util.db.Database.(Database.java:62)
at com.jbidwatcher.util.db.Table.(Table.java:59)
at com.jbidwatcher.util.db.ActiveRecord.openDB(ActiveRecord.java:29)
… 13 more
Caused by: java.sql.SQLException: Failed to create database ‘jbdb’, see the next exception for details.
at org.apache.derby.impl.jdbc.SQLExceptionFactory.getSQLException(Unknown Source)
at org.apache.derby.impl.jdbc.SQLExceptionFactory40.wrapArgsForTransportAcrossDRDA(Unknown Source)
… 29 more
Caused by: java.sql.SQLException: Directory C:\Users\user\.jbidwatcher\C:\Users\user\.jbidwatcher\jbdb already exists.
at org.apache.derby.impl.jdbc.SQLExceptionFactory.getSQLException(Unknown Source)
at org.apache.derby.impl.jdbc.SQLExceptionFactory40.wrapArgsForTransportAcrossDRDA(Unknown Source)
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)
… 26 more
Caused by: ERROR XBM0J: Directory C:\Users\user\.jbidwatcher\C:\Users\user\.jbidwatcher\jbdb already exists.
at org.apache.derby.iapi.error.StandardException.newException(Unknown Source)
at org.apache.derby.impl.services.monitor.StorageFactoryService$9.run(Unknown Source)
at java.security.AccessController.doPrivileged(Native Method)
at org.apache.derby.impl.services.monitor.StorageFactoryService.createServiceRoot(Unknown Source)
at org.apache.derby.impl.services.monitor.BaseMonitor.bootService(Unknown Source)
at org.apache.derby.impl.services.monitor.BaseMonitor.createPersistentService(Unknown Source)
at org.apache.derby.iapi.services.monitor.Monitor.createPersistentService(Unknown Source)
… 26 more

 
Avatar laalaa99stl 4 post(s)

OK. I was able to fix the problem by myself. I had to go out and find an ancient copy of JBidwatcher 2.1.3. In addition to renaming jbdb, I also renamed JBidWatch.cfg so the program was forced to recreate both from scratch. After the reconstruction, you can go back to using a more recent version of JBidwatcher. I still think a menu option to recreate the database would be a LOT more user-friendly.

 
Avatar ivan 10 post(s)

Hi,
This won’t help you but I vote for your request to get a menu item to import csv files. Not exclusively for the current tab but for all the tabs, standard and added ones.

 
Avatar laalaa99stl 4 post(s)

Updating to add that rebuilding the database also works in 2.1.6. It does not work on any version after 2.5. I strongly encourage all JBidWatcher users retain one of these pre-2.5 versions of the program in the event that you need to rebuild your derby database. And I’ll re-iterate my request to have this feature as a menu item in future versions of the program.