Show TOC

Sample Configuration File: JDBC Output AdapterLocate this document in the navigation structure

Sample adapter configuration file for the JDBC Output adapter.

<?xml version="1.0" encoding="utf-8"?>
<Adapter>
	<Name>jdbc_objlist_output</Name>
	<Description>An adapter which outputs Event Stream Processor data to a database through the JDBC interface.</Description>
	<Log4jProperty>./log4j.properties</Log4jProperty>
	<Modules>
		<Module type="espconnector">
			<InstanceName>MyOutStream_Subscriber</InstanceName>
			<Name>EspSubscriber</Name>
			<Next>EspToObjectListFormatterInstance</Next>
			<Parameters>
				<EspSubscriberParameters>
					<ProjectName>Project1</ProjectName>
					<StreamName>MyInStream</StreamName>
					<OutputBase>true</OutputBase>
				    <OnlyBase>false</OnlyBase>
				</EspSubscriberParameters>
			</Parameters>
		</Module>

		<Module type="formatter">
			<InstanceName>EspToObjectListFormatterInstance</InstanceName>
			<Name>EspToObjectListFormatter</Name>
			<Next>MyJdbcOutputTransporter</Next>
			<Parallel>true</Parallel>
			<Parameters>
				<EspToObjectListFormatterParameters>
					<!--For output adapter with JDBC transporter, the value must be "true". 
						Then, the java.sql.Date will be used as output type for ESP SECONDDATE and MSDATE 
						value instead of java.util.Date. The java.sql.Timestamp will be used as output 
						type for ESP BIGDATETIME value instead of java.util.Date. -->
					<OutputAsSQLDatetimeFormat>true</OutputAsSQLDatetimeFormat>
				</EspToObjectListFormatterParameters>
			</Parameters>
		</Module>

		<Module type="transporter">
			<InstanceName>MyJdbcOutputTransporter</InstanceName>
			<Name>JdbcOutputTransporter</Name>
			<Parameters>
				<JdbcOutputTransporterParameters>
					<Host>10.128.99.92</Host>
					<Port>5000</Port>
					<Username></Username>
					<Password encrypted="false"></Password>
					<!-- <RSAKeyStore>/keystore/keystore.jks</RSAKeyStore> <RSAKeyStorePassword>SAP1234</RSAKeyStorePassword> 
						<RSAKeyStoreAlias>serverkey</RSAKeyStoreAlias> -->
					<DbName>master</DbName>
					<DbType>ASE</DbType>
					<DbDriver>com.sybase.jdbc4.jdbc.SybDriver</DbDriver>
					<Table>MyInStream</Table>
				</JdbcOutputTransporterParameters>
			</Parameters>
		</Module>

	</Modules>

	<EspProjects>
		<EspProject>
			<Name>Project1</Name>
			<Uri>esp[s]://localhost:19011/sample_workspace/jdbc_objlist_output</Uri>
			
			<!--can specify multiple uri’s -->
			<Security>
				<User></User>
				<Password encrypted="false"></Password>
				<AuthType>user_password</AuthType>
				<!-- <RSAKeyStore>/keystore/keystore.jks</RSAKeyStore> <RSAKeyStorePassword>SAP1234</RSAKeyStorePassword> -->
		      <!-- <KerberosKDC>KDC</KerberosKDC> <KerberosRealm>REALM</KerberosRealm> 
					<KerberosService>service/instance</KerberosService> <KerberosTicketCache>/tmp/krb5cc_user</KerberosTicketCache> -->
				<EncryptionAlgorithm>RSA</EncryptionAlgorithm>
			</Security>
		</EspProject>

	</EspProjects>
	<GlobalParameters></GlobalParameters>
</Adapter>