TrueTrade, Java/IB trading & backtesting

[tyro_t]

Quote from Janhaus:

Sure thing tyro. I was thinking maybe you should have your own group somewhere than using a thread from either elitetrader or ib discussion

I looked around briefly to see if there was an easy way to create a new google group, but I didn't see anything. Sourceforge allows each project to create a forum, but I'm not thrilled about using SF.

I think this thread is of value to the ET crowd and they're gracious enough to let us continue.

 

[Janhaus]

Heya Tyro,

I re-ran the create_tables.sql script, and it shows:
--
e_tables.sql
Query OK, 6 rows affected (0.02 sec)

Query OK, 1 row affected (0.00 sec)

Database changed
Query OK, 0 rows affected (0.00 sec)

Query OK, 0 rows affected (0.02 sec)

Query OK, 0 rows affected (0.00 sec)

Query OK, 0 rows affected (0.00 sec)

Query OK, 0 rows affected (0.01 sec)

Query OK, 0 rows affected (0.00 sec)

Query OK, 0 rows affected (0.02 sec)

mysql>

Seems ok to me. How else to check? Other than that, when I run the program, this is what it looks like:
(unfortunately, no error file in runtime-EclipseApplication/.metadata/.log)

P.S. I don't know about Google code groups, but it's fairly easy to create normal Google groups in general:
http://groups.google.com/groups/create?lnk=gcf

 

[tyro_t]

Quote from Janhaus:

Heya Tyro,

I re-ran the create_tables.sql script, and it shows:
--
e_tables.sql
Query OK, 6 rows affected (0.02 sec)

This looks just like a DB issue.

Have you made sure that the database is named correctly? Have you created the guest user and granted it permissions (like at the top of the script)?

Other than that, you can go into Window>Preferences in the ATS Client and configure the database preferences if you have something different.

 

[tyro_t]

Quote from Janhaus:

P.S. I don't know about Google code groups, but it's fairly easy to create normal Google groups in general:
http://groups.google.com/groups/create?lnk=gcf

Huh, cool. I'll have to think about that.

Does anyone else have a preference for using a Google Group over an ET thread?

 

[TraderMojo]

Quote from tyro_t:

Huh, cool. I'll have to think about that.

Does anyone else have a preference for using a Google Group over an ET thread?

I think an ET thread would become unwieldly pretty quickly and the forums at IB are even worse.

I don't really have a better suggestion other than a standard mailing list. Does Google code allow you to set one of those up?

 

[tyro_t]

Quote from TraderMojo:

I think an ET thread would become unwieldly pretty quickly and the forums at IB are even worse.

Okay, let's see how this works.

I created two new Google discussion groups:

TrueTrade General, for a general discussion and support of TrueTrade. Probably most appropriate for most users.
http://groups.google.com/group/truetrade-gen

TrueTrade Development, for those people that want to contribute to the code base and need to co-ordinate with the other developers.
http://groups.google.com/group/truetrade-dev


I see a real danger that with all of these different sources of discussion and support, there will be a lot of duplication and it will become hard to find things. Still, I'm curious to see which will survive. I'll read all sources regularly (except maybe the IB forums, ick) so it's up to the users to pick which will win out.


Personally I like the extra control & independence that Google Groups gives us. Let's see how it works.

 

[thrunner]

Quote from tyro_t:

This looks just like a DB issue.

Have you made sure that the database is named correctly? Have you created the guest user and granted it permissions (like at the top of the script)?

Other than that, you can go into Window>Preferences in the ATS Client and configure the database preferences if you have something different.

I still have the same error as Janhaus which I reported earlier as a newbie error (nice to know I am not the only one having this error ). No solution yet, but MySQL seems to be running and the ats database and guest permission ok, as reported by this useful MySQL front end: http://www.heidisql.com/download.php.

 

[tyro_t]

Quote from thrunner:

I still have the same error as Janhaus which I reported earlier as a newbie error (nice to know I am not the only one having this error ). No solution yet, but MySQL seems to be running and the ats database and guest permission ok, as reported by this useful MySQL front end

What I wouldn't give to be sitting over your shoulder right now...

What errors do you get in the eclipse console? (Same question to Janhaus.)

Line 136 in InstrumentView is an attempt to iterate over the instruments returned from the DB. The only way this could be null (as opposed to 0-length) is if the DB query fails for some reason, it's just a matter of figuring out what that reason is.

 

[TraderMojo]

Quote from tyro_t:

What I wouldn't give to be sitting over your shoulder right now...

What errors do you get in the eclipse console? (Same question to Janhaus.)

Line 136 in InstrumentView is an attempt to iterate over the instruments returned from the DB. The only way this could be null (as opposed to 0-length) is if the DB query fails for some reason, it's just a matter of figuring out what that reason is.

Off the top of my head, perhaps some people don't have the MySQL JDBC driver.

Also suggest they try the following:

1) Don't use the named pipe URL so instead of:

jdbc:mysql://localhost/ats?enable-named-pipe&socketFactory=com.mysql.jdbc.NamedPipeSocketFactory

use

jdbc:mysql://localhost/ats

2) For the username and password, try using root to see if that works first.

 

[TraderMojo]

Quote from TraderMojo:

Off the top of my head, perhaps some people don't have the MySQL JDBC driver.

Ignore that bit, I see it's bundled in the com.ats.resources project