#1844 new
Kimo B. Yap

2.5.5 database conversion options?

Reported by Kimo B. Yap | March 15th, 2014 @ 04:50 PM | in 2.1 Release

As a way to maybe get around my other issues (hanging—separate tickets), I was considering (since I am hypothesizing it is due to 4-5 years of "completed auctions" and memory footprint) converting to MySQL from the internal Derby db, but I can't seem to find a way to get old stuff (even from the "current" tab) between the two database formats, at least not from within jbidwatcher. I can export to CSV, but there doesn't seem to be any way to import from CSV. There are some third-party utils that might work, except at least the one I found wants java 1.6 or greater (not an easy option on 10.5.8—PPC machine). This is let alone if could even get this to work without hanging due to "touching" the "completed" tab. Am I just missing some documentation, or is there a way to do this?

Comments and changes to this ticket

  • Morgan Schweers

    Morgan Schweers March 22nd, 2014 @ 03:43 PM

    Actually, while I haven't tested it in years, JBidwatcher tries to
    transfer over all the data from Derby to MySQL when you convert over to it.

    ...except, wow. I just went looking, and I used the XML save mechanism to load the auctions into the changed-over-to database on restart. That
    probably doesn't work terribly well anymore, as I've been moving away from
    using XML for...well, anything. You could try it, after backing up the
    Library/Preferences/JBidwatcher directory. The idea is that on restart, it
    should pull the auctions.xml file and try to load all the auctions that are
    in it into the new database. As I said it hasn't been tested in years, and
    so few users actually used MySQL that I somewhat regret the work it took to
    add it.

    Unfortunately, as a continuing kicker on that, I'm fairly sure that my next
    version doesn't run on PPC. I had to add some capabilities for avoiding
    app nap on 10.9, and in the process discovered that my application launcher
    (the small app that actually runs the JBidwatcher code via Java, provided by Apple many, many years ago) is so out of date that I can either add one
    that runs on 10.9, but is Intel only, or keep the PPC-enabled one and not
    be able to detect post-1.6 Java installs on 10.9.

    I'm really sorry about that. While I don't use a PPC Mac anymore myself, I
    know the pain of not really being able to upgrade.

    Best of luck with your auctions!

    -- Morgan

  • Kimo B. Yap

    Kimo B. Yap March 22nd, 2014 @ 09:46 PM

    So I should just be able to change the database type, enter the appropriate credentials, quit the program and restart?
    That seems to make a new sql database, but very quickly not do anything with it (like it isn't spending time reading the auctions.xml
    file, which was created on exit when restarting). Is there a way to force it to do the read?

    Might there be an older version that could convert the database on startup and do the right thing from the xml file?

    For the PPC, does that mean the java app will no longer work either (needs newer jova)? or just the app runner? Doesn't the java app have
    to run on other platforms and so be fairly generic?

Please Sign in or create a free account to add a new ticket.

With your very own profile, you can contribute to projects, track your activity, watch tickets, receive and update tickets through your email and much more.

New-ticket Create new ticket

Create your profile

Help contribute to this project by taking a few moments to create your personal profile. Create your profile ยป

Shared Ticket Bins

People watching this ticket