public class JDBCOutputSynapse extends StreamOutputSynapse
The JDBCOutputSynapse provides support for data input to a database. To use this synapse the user should ensure a JDBC Type 4 Driver is in the class path. It is possible to use other JDBC driver types though you will have to refer to the vendors documentation, it may require extra software insallation and this may limit your distributtion to certain Operating Systems.
The properties required by this JDBCOutputSynapse Plugin are the following
Database Driver Name - e.g sun.jdbc.odbc.JdbcOdbcDriver
Database URL - e.g jdbc:mysql://localhost/MyDb?user=myuser&password=mypass
SQLAmendment - e.g "INSERT INTO MY_RESULT_TABLE (RESULT1,RESULT2) VALUES(JOONE[1],JOONE[2])" where JOONE[1] is the first value of the current output.
Note : The database URL uses specific protocol after the "jdbc:" section check with the jdbc driver vendor for specific info.
Some commonly used Driver protocols shown below ...
Driver {com.mysql.jdbc.Driver}
Protocol {jdbc:mysql://[hostname][,failoverhost...][:port]/[dbname][?param1=value1][¶m2=value2].....} MySQL Protool
Example {jdbc:mysql://localhost/test?user=blah&password=blah}
Web Site {http://www.mysql.com}
Driver {sun.jdbc.odbc.JdbcOdbcDriver}
Protocol { jdbc:odbc:
Example {jdbc:odbc:mydb;UID=me;PWD=secret}
Web Site {http://www.java.sun.com}
Data Types
Any fields receiving a value should be able to contain a single double. The data type is not so important it can be text or a number field so long as can hold a double value.
fifo, nextPlugIn
Constructor and Description |
---|
JDBCOutputSynapse()
Constructor for the JDBCOutputSynapse object
|
JDBCOutputSynapse(java.lang.String newDrivername,
java.lang.String newdbURL,
java.lang.String newSQLAmendment,
boolean buffered)
Constructor for the JDBCInputSynapse object that allows all options.
|
Modifier and Type | Method and Description |
---|---|
java.util.TreeSet |
check()
Check that parameters are set correctly for the this JDBCInputSynapse object.
|
java.lang.String |
getdbURL()
Gets the name of the database Universal Resource Location (URL)
|
java.lang.String |
getdriverName()
Gets the name of the database jdbc driver used by this JDBC input syanpse.
|
java.lang.String |
getSQLAmendment()
Gets the SQL Query used to select data from the database.
|
protected void |
initStream()
Connects to the database using Driver name and db URL and selects data
using the SQLAmendment.
|
void |
setdbURL(java.lang.String newdbURL)
Sets the name of the database Universal Resource Location (URL)
|
void |
setdriverName(java.lang.String newDriverName)
Sets the name of the database jdbc driver.
|
void |
setSQLAmendment(java.lang.String newSQLAmendment)
Sets the SQLAmendment attribute of the JDBCInputSynapse object
|
void |
write(Pattern pattern)
Writes the pattern data to the database specified in the dbURL.
|
addPlugIn, backward, dataChanged, forward, fwdPut, getFifo, getPlugIn, getSeparator, isBuffered, removeAllPlugIns, revGet, setArrays, setBuffered, setDimensions, setPlugIn, setSeparator
addNoise, canCountSteps, fwdGet, fwdPattern_consume, fwdPattern_produce, getCount, getFwdLock, getIgnoreBefore, getInputDimension, getLearner, getLearningRate, getMomentum, getMonitor, getName, getOutputDimension, getRevLock, getSynapseNameSafely, getWeights, init, initLearner, InspectableTitle, Inspections, isEnabled, isInputFull, isLoopBack, isOutputFull, randomize, readResolve, reset, revPattern_consume, revPattern_produce, revPut, setEnabled, setIgnoreBefore, setInputDimension, setInputFull, setLearningRate, setLoopBack, setMomentum, setMonitor, setName, setOutputDimension, setOutputFull, setWeights, warnLogger, warnLogger
public JDBCOutputSynapse()
public JDBCOutputSynapse(java.lang.String newDrivername, java.lang.String newdbURL, java.lang.String newSQLAmendment, boolean buffered)
Constructor for the JDBCInputSynapse object that allows all options. Allows the user to construct a JDBCInputSynapse in one call.
newDrivername
- The class name of the database driver to use.newdbURL
- The Universal Resource Locator to enable connection to the database.newSQLAmendment
- The database SQL amendment to apply to the database.buffered
- Whether this synapse is buffered or not.public java.lang.String getdriverName()
public java.lang.String getdbURL()
public java.lang.String getSQLAmendment()
public void setdriverName(java.lang.String newDriverName)
newDriverName
- The JDBC Driver namepublic void setdbURL(java.lang.String newdbURL)
newdbURL
- The database URL to use for selecting input. See the notes on
this class for usage.public void setSQLAmendment(java.lang.String newSQLAmendment)
newSQLAmendment
- The new database SQL Amendment.protected void initStream() throws JooneRuntimeException
JooneRuntimeException
public java.util.TreeSet check()
check
in interface NeuralElement
check
in class StreamOutputSynapse
Synapse
public void write(Pattern pattern) throws JooneRuntimeException
write
in class StreamOutputSynapse
pattern
- The values to write to the database.JooneRuntimeException
Submit Feedback to pmarrone@users.sourceforge.net