Microsoft SQL Server Binding

Add-ons Bindings
21

Allen_Farmer,

Now my binding can SELECT and UPDATE. If you UPDATE your table. An item should be defined as follows;
Number Data1 {acsqlserver=">[UPDATE TABLE1 SET value=? WHERE recordId=1]"}

22

I am not wanting to do a update I am wanting to do a insert into a table.

23

I see.
So I rewrote my program , please download and build it again.
In org.openhab.binding.ACDBCommon directory, you can build it as follows;

mvn clean instal
cp target/org.openhab.binding.ACDBCommon-1.8.0-SNAPSHOT.jar …/org.openhab.binding.ACMySQL/lib
cd …/org.openhab.binding.ACMySQL
mvn clean install
cp target/org.openhab.binding.ACMySQL-1.8.0-SNAPSHOT.jar “to your addons directory”

I tested following difinitions;
(1)acmysql.cfg
acmysql:server1.url=jdbc:mysql://localhost/cyber
acmysql:server1.user=cyber
acmysql:server1.password=cyber
(2)demo.items
String test {acmysql=“>>[server1:INSERT INTO messages (MACAddress,Timestamp,TypeID,Taken,Attempts,IsGoodSend) values (’
0014f5400002’,‘2016-03-02 14:05:24.000’,2,0,0,0)]”}

But using these configurations, you only can insert fixed data.