search

openaplis / ap-pm

Project Management
MIT License
1 stars 0 forks source link

Mirth/MySQL connection string #3

Open SidHarder opened 6 years ago

SidHarder commented 6 years ago

@dspencer-mawd this is a line of code with the connection string to connect Mirth to MySQL: var dbConn = DatabaseConnectionFactory.createDatabaseConnection('com.mysql.jdbc.Driver','jdbc:mysql://SQLServer:3306/lis?allowMultiQueries=true','(username)','(password)');

Later today I will create a username and password for you to actually connect with.

SidHarder commented 6 years ago

@dspencer-mawd once you have a connection then you can do something like this:

dbConn.executeUpdate("Insert tblTest (one, two) values ('Hello', 'Pickles')"); dbConn.close()

dspencer-kc commented 6 years ago

@SidHarder Excellent, that will save me some time. Do you typically utilize the Database Writer Connection type, or just make javascript calls?

SidHarder commented 6 years ago

I have never used the Database Writer. I always just write Javascript.

On Mon, Apr 16, 2018 at 11:46 AM, Drew notifications@github.com wrote:

@SidHarder https://github.com/SidHarder Excellent, that will save me some time. Do you typically utilize the Database Writer Connection type, or just make javascript calls?

— You are receiving this because you were mentioned. Reply to this email directly, view it on GitHub https://github.com/openaplis/ap-pm/issues/3#issuecomment-381689513, or mute the thread https://github.com/notifications/unsubscribe-auth/ABhlifCO58TNVcEHCM68WfRZbYlsejsaks5tpNjZgaJpZM4TWqRb .