Sample Configuration File: JDBC Output Adapter

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 ESP data to database through JDBC interface.</Description>
	<Log4jProperty>./log4j.properties</Log4jProperty>
	<Modules>
		<Module type="espconnector">
			<InstanceName>MyOutStream_Subscriber</InstanceName>
			<Name>EspSubscriber</Name>
			<Next>EspToObjectListFormatterInstance</Next>
			<Parameters>
				<EspSubscriberParameters>
					<ProjectName>EspProject1</ProjectName>
					<StreamName>MyInStream</StreamName>
				</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 DATE and TIMESTAMP 
						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>sybase</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>EspProject1</Name>
			<Uri>esp://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>Sybase123</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>