usingdatabasebeansforallproducts

Differences

This shows you the differences between two versions of the page.

Link to this comparison view

Both sides previous revision Previous revision
usingdatabasebeansforallproducts [2021/07/28 13:23]
wikiadmin [Using the Database Servers in Scripts (MIStudio and TransSECS)] 		usingdatabasebeansforallproducts [2022/01/02 22:09] (current)
wikiadmin [Introduction]
Line 9: Line 9:
 To use any of the database servers, a JDBC Driver jar specific to the database must be added to the project. For MIStudio, use the Drivers node of the project, right click and browse for this jar on your computer system. When you deploy to MIX from MIStudio, this jar will be added to the MIX deployment. For TransSECS this jar must be added to a resources directory of your project. When you build your TransSECS project this jar will be added to the deployment. To use any of the database servers, a JDBC Driver jar specific to the database must be added to the project. For MIStudio, use the Drivers node of the project, right click and browse for this jar on your computer system. When you deploy to MIX from MIStudio, this jar will be added to the MIX deployment. For TransSECS this jar must be added to a resources directory of your project. When you build your TransSECS project this jar will be added to the deployment.
  
-To read data from the database or to write data to the database, there are a variety of database server "beans" which, at a minimum, need to be configured to use a table name and a SQL statement, as well as selecting a pre-configured DatabaseConnectionManager. These beans include DatabaseRawWrite (write one value to the database table), DatabaseRawRead (read one value from the database table), DatabaseArrayRawLookup (read an array of values from the table), DatabaseRowLookup (read an array of values from a single row in the table), and DatabaseRawTableLookup (read a 2D array of values from the database, as a whole table). In addition there is a "historical" database bean which writes a whole row of timestamped data to the table when it is triggered, the TriggeredHistorical bean. +To read data from the database or to write data to the database, there are a variety of database server "beans" which, at a minimum, need to be configured to use a table name and a SQL statement, as well as selecting a pre-configured DatabaseConnectionManager. These beans include DatabaseRawWrite (write one value to the database table), DatabaseRawRead (read one value from the database table), DatabaseArrayRawLookup (read an array of values from the table), DatabaseRowLookup (read an array of values from a single row in the table), and DatabaseRawTableLookup (read a 2D array of values from the database, as a whole table). In addition there is a "historical" database bean which writes a whole row of timestamped data to the table when it is triggered, the TriggeredHistorical bean.  See: [[vibreportinganddatabaseserverbeansdocumentation|Reporting and Historical Servers]]
  
 ==== Using the Database Servers in MIStudio==== ==== Using the Database Servers in MIStudio====
  • usingdatabasebeansforallproducts.1627496636.txt.gz
  • Last modified: 2021/07/28 13:23
  • by wikiadmin