Printronix PrintNet Enterprise - Manual (Page 299)

Examples Of Property Definitions
299
4. OdvJdbcDbFields (Database Fields List)
This is a comma separated list of database field names that correspond to
the fields defined when the database or spreadsheet was created. Any
field names in this list must match an AutoID property name.
IMPORTANT The field names are case-sensitive. Make sure the field names selected
are spelled correctly and are set to the maximum field sizes as shown in
the tables on page 306.
See “Data Field Names” on page 306 for a list of the acceptable AutoID
property names (database name) that can be used.
5. OdvJdbcPreparedStatement (Optional property)
This optional property allows the user to explicitly define the SQL
prepared statement, as defined in the JDBC specification. If it is not
defined, a standard SQL
INSERT statement is created using the table
name (from the OdvJdbcDbName property) and the fields (from the
OdvJdbcDbFields property).
For example, a table named mytable with the fields CaptureDate ,
FailureCode , and DecodedData would create the following statement:
INSERT INTO mytable(CaptureDate,FailureCode,DecodedData)
VALUES(?,?,?)
Examples Of Property Definitions
NOTE: For all databases, make sure that zero length strings are allowed.
The following are some examples of property definitions. Printronix does not
guarantee that the examples shown will work for your database. Each
database can have different drivers and connectivity requirements. The
examples are provided to assist you in starting your property definition file.
In the examples, the following values are used:
Database = odv
User ID = odvuser
Password = odvpassword
Table name = events
MySQL
OdvJdbcDriver=org.gjt.mm.mysql.Driver
OdvJdbcUrl=jdbc:mysql://mymachine/odv?user=odvuser&password=
odvpassword
OdvJdbcDbName=events
OdvJdbcDbFields=CaptureDate,FailureCode,DecodedData
SAP
OdvJdbcDriver=com.sap.dbtech.jdbc.DriverSapDB
OdvJdbcUrl=jdbc:sapdb:odv?user=odvuser&password=odvpassword
OdvJdbcDbName=events
OdvJdbcDbFields=CaptureDate,FailureCode,DecodedData