Show TOC

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

Sample adapter configuration file for the JDBC Input adapter.

<?xml version="1.0" encoding="utf-8"?>
<Adapter>
	<Name>jdbc_input</Name>
	<Description>An adapter which gets data from a database through a JDBC interface then publishes to a stream.</Description>
	<Log4jProperty>./log4j.properties</Log4jProperty>
	<Modules>
		<Module type="transporter">
			<InstanceName>MyJdbcInputTransporter</InstanceName>
			<Name>JdbcInputTransporter</Name>
			<Next>ObjectListToEspFormatterInstance</Next>
			<Parameters>
				<JdbcInputTransporterParameters>
					<Host>localhost</Host>
					<Port>5000</Port>
					<Username></Username>
					<Password encrypted="false"></Password>
					<!-- <RSAKeyStore>/keystore/keystore.jks</RSAKeyStore> <RSAKeyStorePassword></RSAKeyStorePassword> 
						<RSAKeyStoreAlias>serverkey</RSAKeyStoreAlias> -->
					<DbName>master</DbName>
					<DbType>ASE</DbType>
					<DbDriver>com.sybase.jdbc4.jdbc.SybDriver</DbDriver>
					<Table>MyInStream</Table>
				</JdbcInputTransporterParameters>
			</Parameters>
		</Module>

		<Module type="formatter">
			<InstanceName>ObjectListToEspFormatterInstance</InstanceName>
			<Name>ObjectListToEspFormatter</Name>
			<Next>MyInStream_Publisher</Next>
			<Parallel>true</Parallel>
			<Parameters>
				<ObjectListToEspFormatterParameters>
					<SecondDateFormat>yyyy-MM-dd HH:mm:ss.SSS</SecondDateFormat>
					<MsDateFormat>yyyy-MM-dd HH:mm:ss.SSS</MsDateFormat>
					<TimeFormat>HH:mm:ss</TimeFormat>
				</ObjectListToEspFormatterParameters>
			</Parameters>
		</Module>


		<Module type="espconnector">
			<InstanceName>MyInStream_Publisher</InstanceName>
			<Name>EspPublisher</Name>
			<Parameters>
				<EspPublisherParameters>
				    <!--Uncomment the following 2 elements when you use 'start_adapter[.bat|.sh]' -->
					<!--ProjectName>EspProject1</ProjectName-->
					<!--StreamName>MyInStream</StreamName-->
					<MaxPubPoolSize>1</MaxPubPoolSize>
					<UseTransactions>false</UseTransactions>
					<SafeOps>false</SafeOps>
					<SkipDels>false</SkipDels>
				</EspPublisherParameters>
			</Parameters>
		</Module>


	</Modules>

	<EspProjects>
		<EspProject>
			<Name>EspProject1</Name>
			<Uri>esp[s]://localhost:19011/sample_workspace/jdbc_objlist_input</Uri>
			
			<Security>
				<User></User>
				<Password encrypted="false"></Password>
				<AuthType>user_password</AuthType>
				<!-- <RSAKeyStore>/keystore/keystore.jks</RSAKeyStore> <RSAKeyStorePassword></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>