Author |
Mike Haberman |
Creation date |
06/06/2011 |
Firing policy |
any |
Package |
org.seasr.meandre.components.tools.tuples |
DESCRIPTION
This component reads a mysql database
INPUTS
Name |
Description |
Example |
|---|---|---|
query |
Database query statement whose contents will be pushed out e.g. select * from a,b where a.id = b.id |
|
password |
The password TYPE: java.lang.String TYPE: org.seasr.datatypes.BasicDataTypes.Strings TYPE: byte[] TYPE: org.seasr.datatypes.BasicDataTypes.Bytes TYPE: java.lang.Object |
|
username |
The user name to authenticate to the DB server TYPE: java.lang.String TYPE: org.seasr.datatypes.BasicDataTypes.Strings TYPE: byte[] TYPE: org.seasr.datatypes.BasicDataTypes.Bytes TYPE: java.lang.Object |
|
OUTPUTS
Name |
Description |
Example |
|---|---|---|
error |
This port is used to output any unhandled errors encountered during the execution of this component |
|
meta_tuple |
meta data for the tuple (column names from select!) TYPE: org.seasr.datatypes.BasicDataTypes.Strings |
|
tuples |
tuples (based on the SQL) TYPE: org.seasr.datatypes.BasicDataTypes.StringsArray |
|
PROPERTIES
Name |
Description |
Default value |
|---|---|---|
_debug_level |
Controls the verbosity of debug messages printed by the component during execution. Possible values are: off, severe, warning, info, config, fine, finer, finest, all Append ',mirror' to any of the values above to mirror that output to the server logs. |
info |
db_driver |
jdbc driver to be loaded, jar must be in classpath |
com.mysql.jdbc.Driver |
_stream_id |
Defines the stream id used to identify a particular stream of data |
|
db_url |
The url of the database connection. (example: jdbc:mysql://localhost/myDB) |
jdbc:mysql:// |
_ignore_errors |
Set to 'true' to ignore all unhandled exceptions and prevent the flow from being terminated. Setting this property to 'false' will result in the flow being terminated in the event an unhandled exception is thrown during the execution of this component |
false |
Add Comment