MySQL & Ninja

[dsraider]

This works perfectly:

protected override void OnBarUpdate()
{
//create a MySQL connection 
MySqlConnection connection = new MySqlConnection("Server=server;Database=database;Port=port;Uid=userid;Password=password"); 

//create a MySQL insert command with a query string 
string myInsertQuery = String.Format ("INSERT INTO table (column1, column2) values ('value1', 'value2')"); 
MySqlCommand command = new MySqlCommand(myInsertQuery); 

command.Connection = connection; 
connection.Open(); 

//insert info 
command.ExecuteNonQuery(); 
                 
//close the connection 
connection.Close(); 
} 

This results in "Connection must be valid and open" or in Termination fail if I move connection.Open() to OnBarUpdate:

protected override void OnStartUp()
{
//create a MySQL connection 
MySqlConnection connection = new MySqlConnection("Server=server;Database=database;Port=port;Uid=userid;Password=password"); 

connection.Open(); 
} 

Anyone know why? I tried a Print statement in OnStartUp and it printed just fine.

[dsraider]

Edited for new purpose.

[NinjaTrader_AdamP]

dsraider,

Unfortunately this level of coding is unsupported. Hopefully a community member can help you.

Please let us know if we can assist further.

[dsraider]

Hi Adam,

Unfortunately, I kind of figured that. However, if you're aware of any issues at all with OnStartup() or OnTermination(), please let me know.

Thanks,
DS

[sledge]

In our .net with oracle database and webpages, a sql connection must be opened every single time.

This might be what is happening here to some degree.?.

That's my guess. Now I have no idea why we are mixing .net with Oracle database at work. Bunch of no brains there.

This works perfectly:

protected override void OnBarUpdate()
{
//create a MySQL connection 
MySqlConnection connection = new MySqlConnection("Server=server;Database=database;Port=port;Uid=userid;Password=password"); 

//create a MySQL insert command with a query string 
string myInsertQuery = String.Format ("INSERT INTO table (column1, column2) values ('value1', 'value2')"); 
MySqlCommand command = new MySqlCommand(myInsertQuery); 

command.Connection = connection; 
connection.Open(); 

//insert info 
command.ExecuteNonQuery(); 
                 
//close the connection 
connection.Close(); 
} 

This results in "Connection must be valid and open" or in Termination fail if I move connection.Open() to OnBarUpdate:

protected override void OnStartUp()
{
//create a MySQL connection 
MySqlConnection connection = new MySqlConnection("Server=server;Database=database;Port=port;Uid=userid;Password=password"); 

connection.Open(); 
} 

Anyone know why? I tried a Print statement in OnStartUp and it printed just fine.

[dsraider]

LOL sorry to hear about work but I hope I don't have to do this for every tick. In fact, I think my computer just started crying.

[edmondgoh]

Has this issue been solved, I would also be interested in moving the OPEN and CLOSE part to startup and termination areas of ninjatrader code

[edmondgoh]

I would also been interesting moving the OPEN and connect and CLOSE to startup and termination parts of ninjatrader code, any solutions here?

[EnsoTrader]

Not sure what happened originally.
But, looking at the code posted, when he moved the connection definition and open call to the OnStartUp method, he defined the connection object as a local variable.
So, that meant once OnStartUp exited the connection object was disposed.

Try defining the connection object in the Variables #region so it'll will persist for all methods.

Technically, as was mentioned before, you should establish a new connection with each unit of work so that you don't leave resources hanging.
BUt, given that this is a local DB, and probably single user, the best thing is to establish the connection on start up and then close it on termination.