Recent Posts by ciuly

Subscribe to Recent Posts by ciuly 5 post(s) found

Apr 24, 2012
Avatar ciuly 5 post(s)

Comment Topic: JBidwatcher Development / Bug: 2.5 remote DB not used

And another pretty serious issue I notice is that when in remote DB, the snipes are not persisted. After I loaded jbid, the snpies I set yesterday were not shown.
I really need to be using this remote DB option as I’m using jbid at home and at work. Using a local DB would not cut it as the 2 places will always be out of sync from snipes point of view, at least.

Am I doing something wrong or is this really an issue?

 
Apr 24, 2012
Avatar ciuly 5 post(s)

Comment Topic: JBidwatcher Development / Bug: 2.5 remote DB not used

I also noticed that it looses the DB configuration after closed and resets to user root and DB localhost with schema jbidwatcher.
so actually the problem is it doesn’t persist the DB configuration

 
Apr 21, 2012
Avatar ciuly 5 post(s)

Comment Topic: JBidwatcher Help / Null price

update: you must name your mysql schema “jbidwatcher”. it won’t work any other way till its fixed.

 
Apr 21, 2012
Avatar ciuly 5 post(s)

Comment Topic: JBidwatcher Development / Bug: 2.5 remote DB not used

My config says db.mysql.database=something but I look in the error log and see. jbid then hangs.

Access denied for user ’XXX’@’YYY’ to database ‘jbidwatcher’
com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Access denied for user ’XXX’@’YYY’ to database ‘jbidwatcher’
at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:39)
at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:27)
at java.lang.reflect.Constructor.newInstance(Constructor.java:513)
at com.mysql.jdbc.Util.handleNewInstance(Util.java:406)
at com.mysql.jdbc.Util.getInstance(Util.java:381)
at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1030)
at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:956)
at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3515)
at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3447)
at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1951)
at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2101)
at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2548)
at com.mysql.jdbc.StatementImpl.executeUpdate(StatementImpl.java:1605)
at com.mysql.jdbc.StatementImpl.executeUpdate(StatementImpl.java:1524)
at com.jbidwatcher.util.db.Database.setup(Database.java:87)
at com.jbidwatcher.util.db.Database.(Database.java:52)
at com.jbidwatcher.Upgrader.upgrade(Upgrader.java:26)
at com.jbidwatcher.app.JBidWatch.main(JBidWatch.java:425)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
at java.lang.reflect.Method.invoke(Method.java:597)
at com.simontuffs.onejar.Boot.run(Boot.java:342)
at com.simontuffs.onejar.Boot.main(Boot.java:168)

Once I change the db in config and rename the schema, it works. So I guess the config setting is ignored.

 
Apr 19, 2012
Avatar ciuly 5 post(s)

Comment Topic: JBidwatcher Help / Null price

new user here. Installed latest 2.5, winxp sp2, 32 bit.
upon first start, it loads all the items in my watch list (a little over 142), about 60 of them in the ended list. I’m on ebay.com with my account and also bidding and using ebay.co.uk.
Now, all the 140 items were loaded in the current list, and some of them with these null values and no time and stuff. most of these nulls were ended items from what I see (too many to check them all by hand).
It loaded the ended items just fine though in the second tab.

Now, I closed and re-started jbid as suggested above to see if it gets the nulls fixed. But now it won’t load. It’s stuck at “Loading Auctions”.
My jbid is configured with my local mysql DB if that makes any difference but I don’t see any tables there…
Would I need to create the tables myself? Is there an sql for that?
Any way to debug this starting freeze now that I can’t get into config editor?

thanks