db-derby-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Abdulla <abdulla.hclinfo...@gmail.com>
Subject record is not inserting in the Derby DB.
Date Sat, 20 Apr 2013 07:30:26 GMT
i am unable to insert the record in the Derby DB.

problem:-

i create one table in the already existing Derby by but table is creating
successfully but unable to insert the record.

excepted output:-

in the zip file record inserted successfully in Derby.
 
I am using following framework.

spring 2.5
Ibatis
DerbyDB


I am sharing you the files list.


i created ibatis registrarDocumentAgeGroup-sql-map.xml files are.

child table:-registrarDocumentAgeGroup-sql-map.xml
<?xml version="1.0" encoding="UTF-8"?>
<!DOCTYPE sqlMap
    PUBLIC &quot;-//ibatis.apache.org//DTD SQL Map 2.0//EN&quot;
    &quot;http://ibatis.apache.org/dtd/sql-map-2.dtd&quot;>
    
    

<sqlMap namespace="ProofDocumentDetail">

	

	<typeAlias alias="ProofDocumentDetail"
type="in.gov.uidai.server.model.proofDetail.ProofDetail" />

	<select id="findProofDocumentApplicableAgeBfrInsert" 
parameterClass="java.lang.String" resultClass="java.lang.Integer">
		select count(1) from age_group where age_group_description=#value#
  	</select> 


	<insert id="insertProofDocumentApplicableAge"
parameterClass="ProofDocumentDetail">
		
		insert into age_group
    	<dynamic prepend="(" >
    	  		<isNotNull prepend="," property="applicableAge" >
		        	 age_group_id
		       </isNotNull>
		       <isNotNull prepend="," property="applicableAgeValue" >
		        	age_group_description
		       </isNotNull>
		      )
		    </dynamic>
		    values
		    <dynamic prepend="(" >
		      <isNotNull prepend="," property="applicableAge" >
		        #applicableAge:INTEGER#
		      </isNotNull>
		       <isNotNull prepend="," property="applicableAgeValue" >
		        #applicableAgeValue:VARCHAR#
		      </isNotNull>
		     )
		 </dynamic>
	</insert>

</sqlMap>

master table:-registrarDocument-sql-ecmp1.7-map.xml

<?xml version="1.0" encoding="UTF-8"?>
<!DOCTYPE sqlMap
    PUBLIC &quot;-//ibatis.apache.org//DTD SQL Map 2.0//EN&quot;
    &quot;http://ibatis.apache.org/dtd/sql-map-2.dtd&quot;>

<sqlMap namespace="ProofDocumentDetail">

	

	<typeAlias alias="ProofDocumentDetail"
type="in.gov.uidai.server.model.proofDetail.ProofDetail" />

	<insert id="insertProofDocument" parameterClass="ProofDocumentDetail">
		<selectKey resultClass="int" keyProperty="id" > 
    		SELECT SEQUENCE.NEXTVAL AS registrar_doc_id FROM registrar_doc
        </selectKey>
		insert into registrar_doc
    	<dynamic prepend="(" >
		       <isNotNull prepend="," property="documentName" >
		        	document_name
		       </isNotNull>
		       <isNotNull prepend="," property="documentTypeId" >
		        	registrar_doc_type_id
		       </isNotNull>
		       <isNotNull prepend="," property="regCode" >
		        	registrar_code
		       </isNotNull>
		       <isNotNull prepend="," property="documentId" >
		        	document_id
		       </isNotNull>
		       <isNotNull prepend="," property="modeType" >
		        	mode_type
		       </isNotNull>
		       <isNotNull prepend="," property="applicableAge">
		           age_group
		       </isNotNull>
		      )
		    </dynamic>
		    values
		    <dynamic prepend="(" >
		       <isNotNull prepend="," property="documentName" >
		        #documentName:VARCHAR#
		      </isNotNull>
		      <isNotNull prepend="," property="documentTypeId" >
		         #documentTypeId:INTEGER#
		      </isNotNull>
		       <isNotNull prepend="," property="regCode" >
		        #regCode:VARCHAR#
		      </isNotNull>
		      <isNotNull prepend="," property="documentId" >
		        #documentId:VARCHAR#
		      </isNotNull>
		      <isNotNull prepend="," property="modeType" >
		        #modeType:VARCHAR#
		      </isNotNull>
		      <isNotNull prepend="," property="applicableAge" >
		        #applicableAge:VARCHAR#
		      </isNotNull>
		     )
		 </dynamic>
	</insert>

</sqlMap>


configuration files:-
registrar-sql-ecmp1.7-map-config.xml

<?xml version="1.0" encoding="UTF-8" ?>
<!DOCTYPE sqlMapConfig PUBLIC &quot;-//iBATIS.com//DTD SQL Map Config
2.0//EN&quot;
   &quot;http://www.ibatis.com/dtd/sql-map-config-2.dtd&quot;>
<sqlMapConfig>	
	<sqlMap resource="external/sqlMaps/introducer-sql-map.xml" />
	<sqlMap resource="external/sqlMaps/registrarAndEA-sql-map.xml" />
	<sqlMap resource="external/sqlMaps/registrarDocumentType-sql-map.xml" />
	<sqlMap resource="external/sqlMaps/registrarDocument-sql-ecmp1.7-map.xml"
/>
	<sqlMap resource="external/sqlMaps/registrarDocumentMode-sql-map.xml" /> 
	<sqlMap resource="external/sqlMaps/registrarDocumentAgeGroup-sql-map.xml"
/>	
</sqlMapConfig>

derby-registrar-version1.7-ddl.sql:-

DROP TABLE introducer_master;
DROP TABLE registrar_ea;
DROP TABLE registrar_doc_master;
DROP TABLE registrar_doc_type;
DROP TABLE mode_type;
DROP TABLE age_group;
DROP TABLE registrar_doc;

CREATE TABLE introducer_master
(
	introducer_id VARCHAR(12) NOT NULL,
	full_name VARCHAR(50),
	region_code VARCHAR(20),
	region_type INT,
	PRIMARY KEY (introducer_id)
);

CREATE TABLE registrar_ea
(
	registrar_code VARCHAR(3) NOT NULL,
	registrar_name VARCHAR(99) NOT NULL,
	ea_code VARCHAR(5) NOT NULL,
	ea_name VARCHAR(99) NOT NULL,
	PRIMARY KEY (registrar_code, ea_code)
);

-- 1 - POI
-- 2 - POA
-- 3 - PHOF
-- 5 – POB
CREATE TABLE registrar_doc_type
(
	registrar_doc_type_id INT GENERATED BY DEFAULT AS IDENTITY,
	document_type VARCHAR(20) NOT NULL UNIQUE,
	document_type_description VARCHAR(100) UNIQUE,
	PRIMARY KEY (registrar_doc_type_id)
);

-- 1 – NEW
-- 2 - UPDATE
-- 3 – CORRECTION
CREATE TABLE mode_type
(
	mode_type_id INT GENERATED BY DEFAULT AS IDENTITY,
	mode_type_description VARCHAR(100) UNIQUE,
	PRIMARY KEY (mode_type_id)
);

--1 - ABOVE5
--2 - ABOVE18
--3 - ALL

CREATE TABLE age_group
(
	age_group_id INT GENERATED BY DEFAULT AS IDENTITY,
	age_group_description VARCHAR(100) UNIQUE,
	PRIMARY KEY (age_group_id)
);

CREATE TABLE registrar_doc
(
	registrar_doc_id INT GENERATED BY DEFAULT AS IDENTITY,
	registrar_code VARCHAR(3),
	document_id VARCHAR(8),
	document_name VARCHAR(200),
	registrar_doc_type_id INT,
	mode_type INT,
	age_group INT,
	PRIMARY KEY (registrar_doc_id),
	FOREIGN KEY (registrar_doc_type_id) REFERENCES registrar_doc_type
(registrar_doc_type_id),
	FOREIGN KEY (mode_type) REFERENCES mode_type (mode_type_id),
	FOREIGN KEY (age_group) REFERENCES age_group (age_group_id)
);


springconfigcontext files:-


<?xml version="1.0" encoding="UTF-8"?>
<beans xmlns="http://www.springframework.org/schema/beans"
	xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
xmlns:batch="http://www.springframework.org/schema/batch"
	xmlns:context="http://www.springframework.org/schema/context"
	xmlns:security="http://www.springframework.org/schema/security"
	xmlns:util="http://www.springframework.org/schema/util"

	xsi:schemaLocation="
    http://www.springframework.org/schema/beans
classpath:org/springframework/beans/factory/xml/spring-beans-2.5.xsd	
    http://www.springframework.org/schema/batch
classpath:packaged/xsd/spring-batch-2.1.xsd
    http://www.springframework.org/schema/context
classpath:org/springframework/context/config/spring-context-2.5.xsd
	http://www.springframework.org/schema/security
classpath:org/springframework/security/config/spring-security-2.0.4.xsd 
	http://www.springframework.org/schema/util
http://www.springframework.org/schema/util/spring-util-2.5.xsd">

	<import resource="NameMatcherBeans.xml" />
	<import resource="UidWorkflowDbConfigContext.xml"></import>

	
	<bean id="uidAdminMasterDataSource"
class="com.mchange.v2.c3p0.ComboPooledDataSource"
		destroy-method="close">
		<property name="driverClass" value="${JDBC.MYSQL.DRIVER}" />
		<property name="jdbcUrl"
value="${JDBC.MYSQL.CONNECTION.URL.ENRL.UIDMASTER}" />
		<property name="user" value="${JDBC.MYSQL.USERNAME.ENRL.UIDMASTER}" />
		<property name="password" value="${JDBC.MYSQL.PASSWORD.ENRL.UIDMASTER}" />
		<property name="minPoolSize" value="${JDBC.POOL.MIN.SIZE.ENRL.UIDMASTER}"
/>
		<property name="maxPoolSize"
value="${JDBC.POOL.MAX.ACTIVE.ENRL.UIDMASTER}" />
		<property name="acquireIncrement" value="${JDBC.POOL.INCREMENT}" />
		<property name="maxIdleTime" value="${JDBC.POOL.IDLE.TIME.SECONDS}" />
		<property name="maxStatements" value="${JDBC.POOL.STATEMENTS}" />
		<property name="idleConnectionTestPeriod"
value="${JDBC.TEST.IDLE.TEST.PERIOD}" />
		<property name="testConnectionOnCheckin" value="${JDBC.TEST.ON.CHECKIN}"
/>
		<property name="preferredTestQuery" value="${JDBC.VALIDATION.QUERY.MYSQL}"
/>
		<property
name="hibernate.connection.zeroDateTimeBehavior">convertToNull</property>
	</bean>

	<bean id="adminMasterSessionFactory"
class="org.springframework.orm.hibernate3.LocalSessionFactoryBean">
		<property name="dataSource" ref="uidAdminMasterDataSource" />
		
		<property name="mappingResources">
			<list>
				<value>
					packaged/hibernate/enrollment/introducerregionmapping.hbm.xml
				</value>
				<value>
					packaged/hibernate/enrollment/introducerregionstatushistory.hbm.xml
				</value>
				<value>
					packaged/hibernate/enrollment/regiontype.hbm.xml
				</value>
				<value>
					packaged/hibernate/enrollment/user.hbm.xml
				</value>
				<value>
					packaged/hibernate/enrollment/usertype.hbm.xml
				</value>
				<value>
					packaged/hibernate/enrollment/userstatushistory.hbm.xml
				</value>
				<value>
					packaged/hibernate/enrollment/organizationcontact.hbm.xml
				</value>
				<value>
					packaged/hibernate/enrollment/contact.hbm.xml
				</value>
				<value>
					packaged/hibernate/enrollment/device.hbm.xml
				</value>
				<value>
					packaged/hibernate/enrollment/devicemodel.hbm.xml
				</value>
				<value>
					packaged/hibernate/enrollment/devicetype.hbm.xml
				</value>
				<value>
					packaged/hibernate/enrollment/organization.hbm.xml
				</value>
				<value>
					packaged/hibernate/enrollment/organizationtype.hbm.xml
				</value>
				<value>
					packaged/hibernate/enrollment/organizationsubtype.hbm.xml
				</value>
				<value>
					packaged/hibernate/enrollment/enrolmentstation.hbm.xml
				</value>
				<value>
					packaged/hibernate/enrollment/enrolmentstationhistory.hbm.xml
				</value>
				<value>
					packaged/hibernate/enrollment/organizationassociation.hbm.xml
				</value>
				<value>
					packaged/hibernate/enrollment/bankmaster.hbm.xml
				</value>
				<value>
					packaged/hibernate/enrollment/bankmasterbranch.hbm.xml
				</value>
				<value>
					packaged/hibernate/enrollment/organizationstatushistory.hbm.xml
				</value>
				<value>
					packaged/hibernate/enrollment/organizationassocstatushistory.hbm.xml
				</value>
				<value>
					packaged/hibernate/enrollment/organizationoutboundkey.hbm.xml
				</value>
				<value>
					packaged/hibernate/enrollment/enrollmentkey.hbm.xml
				</value>
				<value>
					packaged/hibernate/enrollment/portalreportsmaster.hbm.xml
				</value>
				<value>
					packaged/hibernate/enrollment/certificationtype.hbm.xml
				</value>
				<value>
					packaged/hibernate/enrollment/certificationtypemaster.hbm.xml
				</value>
				<value>
					packaged/hibernate/enrollment/certificaterecord.hbm.xml
				</value>
				<value>
					packaged/hibernate/enrollment/usercertification.hbm.xml
				</value>
				<value>
					packaged/hibernate/enrollment/userInactiveReason.hbm.xml
				</value>
				<value>
					packaged/hibernate/enrollment/registrardocref.hbm.xml
				</value>
				<value>
					packaged/hibernate/enrollment/registrardocmaster.hbm.xml
				</value>				
				<value>
					packaged/hibernate/enrollment/registrardoctype.hbm.xml
				</value>
				<value>
					packaged/hibernate/user/queries/uidMasterQueries.xml
				</value>							
				<value>
					packaged/hibernate/enrollment/tickermaster.hbm.xml
				</value>
				<value>
					packaged/hibernate/enrollment/tickerdetails.hbm.xml
				</value>
				<value>
					packaged/hibernate/enrollment/linkdetails.hbm.xml
				</value>	
				<value>
					packaged/hibernate/enrollment/linkmaster.hbm.xml
				</value>											
				<value>
					packaged/hibernate/enrollment/orglicense.hbm.xml
				</value>		
				<value>
					packaged/hibernate/enrollment/orgsetting.hbm.xml
				</value>	
				<value>
					packaged/hibernate/enrollment/orglicenseparams.hbm.xml
				</value>	
				<value>
					packaged/hibernate/enrollment/blacklistedaccounts.hbm.xml
				</value>	
				<value>
					packaged/hibernate/enrollment/blacklistedaccountshistory.hbm.xml
				</value>	
				<value>
					packaged/hibernate/enrollment/blacklistedactiveuser.hbm.xml
				</value>		
				<value>
				    packaged/hibernate/enrollment/locallanuagemaster.hbm.xml
				</value>	
				<value>packaged/hibernate/enrollment/modetypemaster.hbm.xml</value>	
				<value>packaged/hibernate/enrollment/registraragegroup.hbm.xml</value>    
			
<value>packaged/hibernate/orgapplication/orginfoattribute.hbm.xml</value>
			
<value>packaged/hibernate/orgapplication/orginfoattributemaster.hbm.xml</value>
				<value>packaged/hibernate/security/caCertificate.hbm.xml</value>
				<value>packaged/hibernate/enrollment/regionaloffice.hbm.xml</value>
				<value>packaged/hibernate/enrollment/blacklistreasons.hbm.xml</value>
			</list>
		</property>
		<property name="hibernateProperties">
			<value>
				hibernate.dialect = org.hibernate.dialect.MySQL5Dialect
				hibernate.show_sql = false
			</value>
		</property>
	</bean>
	
	
	<bean id="eidFormatValidatorPersistenceManager"
		class="in.gov.uidai.platform.impl.persistence.PersistenceManagerProvider">
		<property name="providersForEntity">
			<map>
				<entry
					key="in.gov.uidai.platform.impl.persistence.Criteria"
					value-ref="uidMasterRdbmsProviderForJDBC" />				
				<entry
				
key="in.gov.uidai.platform.impl.persistence.entity.AbstractPersistentEntity"
					value-ref="uidMasterRdbmsProviderForJDBC" />
			</map>
		</property>
		<property name="persistenceDelegate"
			ref="uidmasterPersistenceDelegate" />
	</bean>
	
	
	<bean id="uidMasterRdbmsProviderForJDBC"
		class="in.gov.uidai.platform.impl.persistence.provider.RDBMSProvider"
		parent="basePersistenceProvider">
		<property name="handler" ref="uidMasterJDBCHandler" />
	</bean>
	<bean id="uidMasterJDBCHandler"
	
class="in.gov.uidai.platform.impl.persistence.handler.SpringJDBCHiveHandler"
		parent="rdbmsPersistenceHandler">
		<property name="template" ref="uidMasterJdbcTemplate" />
	</bean>
	<bean id="uidMasterJdbcTemplate"
		class="org.springframework.jdbc.core.JdbcTemplate">
		<property name="dataSource" ref="uidAdminMasterDataSource" />
	</bean>
	
	
	
	<bean id="uidmasterPersistenceDelegate"
class="in.gov.uidai.platform.impl.persistence.PersistenceDelegate"></bean>

	<bean id="uidmasterTransactionManager"
class="org.springframework.orm.hibernate3.HibernateTransactionManager">
		<property name="sessionFactory" ref="adminMasterSessionFactory" />
	</bean>
	<bean id="uidmasterTransactionInterceptor"
class='org.springframework.transaction.interceptor.TransactionInterceptor'>
		<property name="transactionManager">
			<ref bean="uidmasterTransactionManager" />
		</property>
		<property name="transactionAttributeSource">
			<ref bean="uidmasterTransactionAttributeSource" />
		</property>
	</bean>
	<bean id="uidmasterTransactionAttributeSource"
class="org.springframework.transaction.annotation.AnnotationTransactionAttributeSource"
/>
	<bean id="adminMasterHibernateTemplate"
class="org.springframework.orm.hibernate3.HibernateTemplate">
		<property name="sessionFactory"
ref="adminMasterSessionFactory"></property>
	</bean>

	<bean id="adminMasterHibernateHandler"
class="in.gov.uidai.platform.impl.persistence.handler.HibernateHandler">
		<property name="template" ref="adminMasterHibernateTemplate" />
	</bean>

	<bean id="adminMasterRdbmsProviderForHibernate"
class="in.gov.uidai.platform.impl.persistence.provider.RDBMSProvider">
		<property name="handler" ref="adminMasterHibernateHandler" />
	</bean>
	
	<bean id="organizationTypeConstants"
class="in.gov.uidai.admin.helper.OrganizationTypes">
		<property name="organizationType">
			<map>
				<entry key="otEnrollAgency"	value="OT_ENROL_AGENCY" />
				<entry key="otRegistrar" value="OT_REGISTRAR" />
				<entry key="otAua"	value="OT_AUTHENTICATOR" />
				<entry key="otAsa"	value="OT_ASA" />
				<entry key="ostOthers" value="OST_OTHERS" />
				<entry key="ostPrivate" value="OST_PRIVATE" />				
		  </map>
		</property>
		
	</bean>

	<bean id="masterAdminPersistenceManager"
class="in.gov.uidai.platform.impl.persistence.PersistenceManagerProvider">
		<property name="providersForEntity">
			<map>
				<entry key="in.gov.uidai.enrl.domain.IntroducerRegionMappingEntity"
value-ref="adminMasterRdbmsProviderForHibernate" />
				<entry key="in.gov.uidai.enrl.domain.IntroducerRegionStatusHistory"
value-ref="adminMasterRdbmsProviderForHibernate" />
				<entry key="in.gov.uidai.enrl.domain.User"
value-ref="adminMasterRdbmsProviderForHibernate" />
				<entry key="in.gov.uidai.enrl.domain.UserType"
value-ref="adminMasterRdbmsProviderForHibernate" />
				<entry key="in.gov.uidai.enrl.domain.UserStatusHistory"
value-ref="adminMasterRdbmsProviderForHibernate" />
				<entry key="in.gov.uidai.enrl.domain.ContactEntity"
value-ref="adminMasterRdbmsProviderForHibernate" />
				<entry key="in.gov.uidai.enrl.domain.Device"
value-ref="adminMasterRdbmsProviderForHibernate" />
				<entry key="in.gov.uidai.enrl.domain.DeviceType"
value-ref="adminMasterRdbmsProviderForHibernate" />
				<entry key="in.gov.uidai.enrl.domain.DeviceModel"
value-ref="adminMasterRdbmsProviderForHibernate" />
				<entry key="in.gov.uidai.enrl.domain.Organization"
value-ref="adminMasterRdbmsProviderForHibernate" />
				<entry key="in.gov.uidai.enrl.domain.OrganizationType"
value-ref="adminMasterRdbmsProviderForHibernate" />
				<entry key="in.gov.uidai.enrl.domain.OrganizationSubType"
value-ref="adminMasterRdbmsProviderForHibernate" />
				<entry key="in.gov.uidai.enrl.domain.OrganizationContact"
value-ref="adminMasterRdbmsProviderForHibernate" />
				<entry key="in.gov.uidai.enrl.domain.OrganizationAssociation"
value-ref="adminMasterRdbmsProviderForHibernate" />
				<entry key="in.gov.uidai.enrl.domain.OrganizationStatusHistory"
value-ref="adminMasterRdbmsProviderForHibernate" />
				<entry key="in.gov.uidai.enrl.domain.OrganizationAssocStatusHistory"
value-ref="adminMasterRdbmsProviderForHibernate" />
				<entry key="in.gov.uidai.enrl.domain.OrganizationOutboundKey"
value-ref="adminMasterRdbmsProviderForHibernate" />
				<entry key="in.gov.uidai.enrl.domain.EnrolmentStation"
value-ref="adminMasterRdbmsProviderForHibernate" />
				<entry key="in.gov.uidai.enrl.domain.EnrolmentStationHistory"
value-ref="adminMasterRdbmsProviderForHibernate" />
				<entry key="in.gov.uidai.enrl.domain.RegionTypeEntity"
value-ref="adminMasterRdbmsProviderForHibernate" />
				<entry key="in.gov.uidai.enrl.domain.BankMasterEntity"
value-ref="adminMasterRdbmsProviderForHibernate" />
				<entry key="in.gov.uidai.enrl.domain.BankMasterBranchEntity"
value-ref="adminMasterRdbmsProviderForHibernate" />
				<entry key="in.gov.uidai.enrl.domain.EnrollmentKey"
value-ref="adminMasterRdbmsProviderForHibernate" />
				<entry key="in.gov.uidai.enrl.domain.PortalReportMasterEntity"
value-ref="adminMasterRdbmsProviderForHibernate" />
				<entry key="in.gov.uidai.enrl.domain.CertificateRecordEntity"
value-ref="adminMasterRdbmsProviderForHibernate" />
				<entry key="in.gov.uidai.enrl.domain.CertificationTypeEntity"
value-ref="adminMasterRdbmsProviderForHibernate" />
				<entry key="in.gov.uidai.enrl.domain.CertificationTypeMasterEntity"
value-ref="adminMasterRdbmsProviderForHibernate" />				
				<entry key="in.gov.uidai.enrl.domain.UserCertificationEntity"
value-ref="adminMasterRdbmsProviderForHibernate" />
				<entry key="in.gov.uidai.enrl.domain.LocalLangMasterEntity"
value-ref="adminMasterRdbmsProviderForHibernate"/>		
				<entry key="in.gov.uidai.enrl.domain.UserInactiveReason"
value-ref="adminMasterRdbmsProviderForHibernate" />				
				<entry key="in.gov.uidai.enrl.domain.RegistrarDocMasterEntity"
value-ref="adminMasterRdbmsProviderForHibernate" />
				<entry key="in.gov.uidai.enrl.domain.RegistrarDocReferenceEntity"
value-ref="adminMasterRdbmsProviderForHibernate" />
				<entry key="in.gov.uidai.enrl.domain.RegistrarDocTypeEntity"
value-ref="adminMasterRdbmsProviderForHibernate" />
				<entry key="in.gov.uidai.enrl.domain.TickerMasterEntity"
value-ref="adminMasterRdbmsProviderForHibernate" />
				<entry key="in.gov.uidai.enrl.domain.TickerDetailsEntity"
value-ref="adminMasterRdbmsProviderForHibernate" />
				<entry key="in.gov.uidai.enrl.domain.LinkMasterEntity"
value-ref="adminMasterRdbmsProviderForHibernate" />
				<entry key="in.gov.uidai.enrl.domain.LinkDetailsEntity"
value-ref="adminMasterRdbmsProviderForHibernate" />
				<entry key="in.gov.uidai.enrl.domain.OrgLicense"
value-ref="adminMasterRdbmsProviderForHibernate" />
				<entry key="in.gov.uidai.enrl.domain.OrgSetting"
value-ref="adminMasterRdbmsProviderForHibernate" />
				<entry key="in.gov.uidai.enrl.domain.OrgLicenseParams"
value-ref="adminMasterRdbmsProviderForHibernate" />
				<entry key="in.gov.uidai.enrl.domain.BlacklistedAccountsEntity"
value-ref="adminMasterRdbmsProviderForHibernate" />
				<entry key="in.gov.uidai.enrl.domain.BlacklistedAccountsHistoryEntity"
value-ref="adminMasterRdbmsProviderForHibernate" />
				<entry key="in.gov.uidai.enrl.domain.BlacklistedActiveUsersEntity"
value-ref="adminMasterRdbmsProviderForHibernate" />
				<entry key="in.gov.uidai.enrl.domain.ModeTypeMaster"
value-ref="adminMasterRdbmsProviderForHibernate" />
				<entry key="in.gov.uidai.enrl.domain.RegistrarAgeGroup"
value-ref="adminMasterRdbmsProviderForHibernate" />  
				<entry key="in.gov.uidai.orgApplication.model.OrgInfoAttribute"
value-ref="adminMasterRdbmsProviderForHibernate" />
				<entry key="in.gov.uidai.orgApplication.model.OrgInfoAttributeMaster"
value-ref="adminMasterRdbmsProviderForHibernate" />
				<entry key="in.gov.uidai.security.domain.CACertificateEntity"
value-ref="adminMasterRdbmsProviderForHibernate" />
				<entry key="in.gov.uidai.enrl.domain.RegionalOfficeEntity"
value-ref="adminMasterRdbmsProviderForHibernate" />
				<entry key="in.gov.uidai.enrl.domain.BlacklistReasonsEntity"
value-ref="adminMasterRdbmsProviderForHibernate" />
			</map>
		</property>
		<property name="persistenceDelegate" ref="uidmasterPersistenceDelegate" />
	</bean>

	<bean id="registrarReportLocator"
class="in.gov.uidai.admin.service.impl.report.RegistrarReportLocator">
		<property name="location" value="${REGISTRAR.FSHANDLER.STORE.LOCATION}" />
		<property name="clientDataDownloadMasterECMP"
value="${CLIENT.DATA.DOWNLOAD.MASTER.ECMP.OUTPUT.FOLDER}" /> 
		<property name="clientDataDownloadMasterDotNet"
value="${CLIENT.DATA.DOWNLOAD.MASTER.NET.OUTPUT.FOLDER}" /> 
		<property name="clientDataDownloadRegistrarECMP"
value="${CLIENT.DATA.DOWNLOAD.REGISTRAR.ECMP.OUTPUT.FOLDER}" />
		<property  name="clientDataDownloadRegistrarECMP17"
value="${CLIENT.DATA.DOWNLOAD.REGISTRAR.ECMP17.OUTPUT.FOLDER}" />
		<property name="clientDataDownloadRegistrarDotNet"
value="${CLIENT.DATA.DOWNLOAD.REGISTRAR.NET.OUTPUT.FOLDER}" />
		<property name="clientDataDownloadNameDictionaryECMP"
value="${CLIENT.DATA.DOWNLOAD.NAMEDICTIONARY.ECMP.OUTPUT.FOLDER}" /> 
		<property name="pentahoReportsLocation"
value="${UID.PORTAL.REPORTS.BASE.PATH}" /> 
	</bean>
	
	<bean id="enrolmentStatusAPI"
class="in.gov.uidai.admin.helper.EnrolmentStatusAPI">
		<property name="url" value="${ENROLMENT.STATUS.CRM.API.URL}" />
	</bean>
	
	<bean id="enrolmentStationDeregisterAPI"
class="in.gov.uidai.admin.helper.EnrolmentStationDeregisterAPI">
		<property name="url" value="${ENROLMENT.STATION.DEREGISTER.API.URL}" />
	</bean>
	<bean id="httpInvokerBean" class="in.gov.uidai.admin.helper.HttpInvoker"/>
	
	<bean id="loggedInUserType"
class="in.gov.uidai.admin.helper.LoggedInUserType"/>		
	
	<bean id="templateNames" class="in.gov.uidai.admin.helper.TemplateNames">
		<property name="usrTmpName" value="usrTemplate.csv" />
		<property name="intrTmpName" value="intrTemplate.csv" />
	</bean>

	<bean
class="org.springframework.aop.framework.autoproxy.BeanNameAutoProxyCreator">
		<property name="beanNames">
			<list>
				<value>persistenceDelegate</value>
			</list>
		</property>
		<property name="interceptorNames">
			<list>
				<value>uidmasterTransactionInterceptor</value>
			</list>
		</property>
		<property name='proxyTargetClass' value="true" />
	</bean>

	
	<import resource="UIDFraudConfigContext.xml" />

	
	<import resource="UIDProcessConfigContext.xml" />
	
	<import resource="UIDConfigContext.xml" />
		
	<import resource="UIDPresedaConfigContext.xml" />
	
	<import resource="UIDFiPersistmanagerConfigContext.xml" />
	
	
	<import resource="UidGeoPersistmanagerconfigcontext.xml" />

	<bean id="uidDataSource" class="com.mchange.v2.c3p0.ComboPooledDataSource"
		destroy-method="close">
		<property name="driverClass" value="${JDBC.MYSQL.DRIVER}" />
		<property name="jdbcUrl" value="${JDBC.MYSQL.CONNECTION.URL.ENRL.UID}" />
		<property name="user" value="${JDBC.MYSQL.USERNAME.ENRL.UID}" />
		<property name="password" value="${JDBC.MYSQL.PASSWORD.ENRL.UID}" />
		<property name="minPoolSize" value="${JDBC.POOL.MIN.SIZE.ENRL.UID}" />
		<property name="maxPoolSize" value="${JDBC.POOL.MAX.ACTIVE.ENRL.UID}" />
		<property name="acquireIncrement" value="${JDBC.POOL.INCREMENT}" />
		<property name="maxIdleTime" value="${JDBC.POOL.IDLE.TIME.SECONDS}" />
		<property name="maxStatements" value="${JDBC.POOL.STATEMENTS}" />
		<property name="idleConnectionTestPeriod"
value="${JDBC.TEST.IDLE.TEST.PERIOD}" />
		<property name="testConnectionOnCheckin" value="${JDBC.TEST.ON.CHECKIN}"
/>
		<property name="preferredTestQuery" value="${JDBC.VALIDATION.QUERY.MYSQL}"
/>
	</bean>

	<bean id="uidSessionFactory"
class="org.springframework.orm.hibernate3.LocalSessionFactoryBean">
		<property name="dataSource" ref="uidDataSource" />
		
		<property name="mappingResources">
			<list>
				<value>
					packaged/hibernate/enrollment/uidmaster.hbm.xml
				</value>
				<value>
					packaged/hibernate/enrollment/uidextdemo.hbm.xml
				</value>
				<value>
					packaged/hibernate/enrollment/uidaddress.hbm.xml
				</value>
				<value>
					packaged/hibernate/enrollment/uidtracker.hbm.xml
				</value>
				<value>
					packaged/hibernate/enrollment/bankaccountdetails.hbm.xml
				</value>
			</list>
		</property>
		<property name="hibernateProperties">
			<value>
				hibernate.dialect = org.hibernate.dialect.MySQL5Dialect
				hibernate.show_sql = false
			</value>
		</property>
	</bean>

	<bean id="uidPersistenceManager"
class="in.gov.uidai.platform.impl.persistence.PersistenceManagerProvider">
		<property name="providersForEntity">
			<map>
				<entry key="in.gov.uidai.enrl.domain.UIDMasterEntity"
					value-ref="uidRdbmsProviderForHibernate" />
				<entry key="in.gov.uidai.enrl.domain.UIDExtDemoEntity"
					value-ref="uidRdbmsProviderForHibernate" />
				<entry key="in.gov.uidai.enrl.domain.UIDAddress"
value-ref="uidRdbmsProviderForHibernate" />
				<entry key="in.gov.uidai.enrl.domain.UIDTracker"
value-ref="uidRdbmsProviderForHibernate" />
				<entry key="in.gov.uidai.enrl.domain.BankAccountDetailsEntity"
					value-ref="uidRdbmsProviderForHibernate" />
			</map>
		</property>
	</bean>

	<bean id="uidRdbmsProviderForHibernate"
class="in.gov.uidai.platform.impl.persistence.provider.RDBMSProvider">
		<property name="handler" ref="uidHibernateHandler" />
	</bean>

	<bean id="uidHibernateTemplate"
class="org.springframework.orm.hibernate3.HibernateTemplate">
		<property name="sessionFactory" ref="uidSessionFactory"></property>
	</bean>

	<bean id="uidHibernateHandler"
class="in.gov.uidai.platform.impl.persistence.handler.HibernateHandler">
		<property name="template" ref="uidHibernateTemplate" />
	</bean>

	<bean id="sha1HashGenerator"
class="in.gov.uidai.platform.impl.security.HashGeneratorImpl">
		<property name="algorithm" value="SHA-1"></property>
	</bean>

	<bean id="mailSender"
class="in.gov.uidai.platform.impl.mail.MailSenderImpl">
		<property name="javaMailSender">
			<bean class="org.springframework.mail.javamail.JavaMailSenderImpl">
				<property name="session">
					<bean class="javax.mail.Session" factory-method="getInstance">
						<constructor-arg index="0">
							<props>
								<prop
key="mail.transport.protocol">${ADMIN.PSWDRSET.MAIL.TRANSPORT.PROTOCOL}</prop>
								<prop key="mail.host">${ADMIN.PSWDRSET.MAIL.HOST}</prop>
								<prop key="mail.smtp.port">${ADMIN.PSWDRSET.MAIL.PORT}</prop>
							</props>
						</constructor-arg>
						<constructor-arg index="1">
							<bean class="in.gov.uidai.platform.common.PasswordAuthenticator">
							</bean>
						</constructor-arg>
					</bean>
				</property>
				<property name="host" value="${ADMIN.PSWDRSET.MAIL.HOST}" />
			</bean>
		</property>
		<property name="senderMailId" value="${ADMIN.PSWDRSET.MAIL.SENDER.MAILID}"
/>
	</bean>


	

	<bean id="defaultContextSource"
class="org.springframework.security.ldap.DefaultSpringSecurityContextSource">
		<constructor-arg
		
value="ldap://${WEB.PORTAL.DEFAULT.LDAP.SERVER.HOST}:${WEB.PORTAL.DEFAULT.LDAP.SERVER.PORT}/${WEB.PORTAL.DEFAULT.LDAP.BASE.DN}"
/>
		<property name="base" value="${WEB.PORTAL.DEFAULT.LDAP.BASE.DN}" />
		<property name="userDn" value="${WEB.PORTAL.DEFAULT.LDAP.MANAGER.DN}" />
		<property name="password"
value="${WEB.PORTAL.DEFAULT.LDAP.MANAGER.PASSWD}" />
	</bean>

	<bean id="intrnlContextSource"
class="org.springframework.security.ldap.DefaultSpringSecurityContextSource">
		<constructor-arg
		
value="ldap://${WEB.PORTAL.UIDAI.LDAP.SERVER.HOST}:${WEB.PORTAL.UIDAI.LDAP.SERVER.PORT}/${WEB.PORTAL.UIDAI.LDAP.BASE.DN}"
/>
		<property name="base" value="${WEB.PORTAL.UIDAI.LDAP.BASE.DN}" />
		<property name="userDn" value="${WEB.PORTAL.UIDAI.LDAP.MANAGER.DN}" />
		<property name="password" value="${WEB.PORTAL.UIDAI.LDAP.MANAGER.PASSWD}"
/>
	</bean>
	
	<bean id="contextSource"
class="in.gov.uidai.admin.service.impl.ldap.RoutingSpringSecurityContextSource"
scope="prototype">
		<property name="targetSpringSecurityContextSources">
			<map>
				<entry key="DEFAULT_CONTEXT_SOURCE" value-ref="defaultContextSource" />
				<entry key="UIDAI_ORG_CONTEXT_SOURCE" value-ref="intrnlContextSource" />
			</map>
		</property>
	</bean>

	<bean id="ldapTemplate" class="org.springframework.ldap.core.LdapTemplate">
		<property name="contextSource" ref="contextSource" />
	</bean>

	<security:ldap-authentication-provider server-ref="contextSource"
		user-dn-pattern="cn={0},ou=users" user-search-filter="(cn={0})"
		user-search-base="ou=users" group-search-base="ou=groups"
		group-search-filter="(member={0})">

		<security:password-compare>
			<security:password-encoder hash="sha" />
		</security:password-compare>
	</security:ldap-authentication-provider>

	<security:authentication-manager alias="authenticationManager" />
	

	<bean id="ldapConfigurator"
class="in.gov.uidai.admin.service.impl.ldap.config.LdapConfigurator">
		<property name="baseDn" value="${WEB.PORTAL.DEFAULT.LDAP.BASE.DN}"/>
		<property name="objectClass" value="objectClass"/>		
		<property name="groupAttribute" value="member"/>
		<property name="nextUidNumberCn" value="cn=uidNext"/>
		<property name="uidNumberAttribute" value="uidNumber"/>
		
		<property name="createFtpUser" value="false"/>
		<property name="homeDirectory" value="/home/"/>
		
		<property name="userAtrributesMap">
			<map>
				<entry key="userCreationAttribute" value="cn"></entry>				
				<entry key="commonNameAttribute" value="cn"></entry>
				<entry key="lastNameAttribute" value="sn"></entry>
				<entry key="mailAttribute" value="mail"></entry>
				<entry key="passwordAttribute" value="userPassword"></entry>
				<entry key="descriptionAttribute" value="description"></entry>
				<entry key="organizationalUnit" value="ou"></entry>
				<entry key="userOrganizationalUnit" value="users"></entry>
				<entry key="userSearchBase" value="ou=users"></entry>
				<entry key="groupSearchBase" value="ou=groups"></entry>				
			</map>
		</property>
		
		<property name="ldapUserAttributes" ref="ldapUserAttributes"/>		
		<property name="ldapGroupAttributes" ref="ldapGroupAttributes"/>
		<property name="ldapNextUidAttributes" ref="ldapNextUidAttributes"/>
	</bean>
	
	<bean id="ldapUserAttributes"
class="in.gov.uidai.admin.service.impl.ldap.config.LdapUserAttributes">
		<property name="structuralPersonObjClasses">
			<list>
				<value>top</value>
				<value>person</value>
				<value>organizationalPerson</value>
				<value>inetOrgPerson</value>
			</list>
		</property>
		
		<property name="structuralObjClassAtrributesMap">
			<map>
				<entry key="userCreationAttribute" value="cn"></entry>
				<entry key="commonNameAttribute" value="cn"></entry>
				<entry key="lastNameAttribute" value="sn"></entry>
				<entry key="mailAttribute" value="mail"></entry>
				<entry key="passwordAttribute" value="userPassword"></entry>
				<entry key="descriptionAttribute" value="description"></entry>
			</map>
		</property>
		<property name="auxillaryPersonObjClasses">
			<list>
				<value>posixAccount</value>
			</list>
		</property>		
		<property name="auxillaryPersonObjClassAtrributesMap">
			<map>
				<entry key="userId" value="uid"></entry>
				<entry key="uidNumber" value="uidNumber"></entry>
				<entry key="gidNumber" value="gidNumber"></entry>
				<entry key="homeDirectory" value="homeDirectory"></entry>
			</map>
		</property>				
	</bean>

	<bean id="ldapGroupAttributes"
class="in.gov.uidai.admin.service.impl.ldap.config.LdapGroupAttributes">
		<property name="structuralGroupObjClasses">
			<list>
				<value>groupOfNames</value>
				<value>organizationalPerson</value>				
			</list>
		</property>
		
		<property name="structuralGroupObjClassAtrributesMap">
			<map>
				<entry key="groupCreationAttribute" value="cn"></entry>
				<entry key="memberAttribute" value="member"></entry>				
			</map>
		</property>	
		<property name="auxillaryGroupObjClasses">
			<list>
				<value>posixGroup</value>
			</list>
		</property>		
	
		<property name="auxillaryGroupObjClassAtrributesMap">
			<map>				
				<entry key="gidNumberAttribute" value="gidNumber"></entry>				
			</map>
		</property>		
	</bean>
	
	<bean id="ldapNextUidAttributes"
class="in.gov.uidai.admin.service.impl.ldap.config.LdapNextUIDAttributes">
		<property name="structuralObjClasses">
			<list>
				<value>uidNext</value>
			</list>
		</property>
		
		<property name="structuralObjClassAtrributesMap">
			<map>
				<entry key="uidCreationAttribute" value="cn"></entry>
				<entry key="uidNumberAttribute" value="uidNumber"></entry>
			</map>
		</property>
	</bean>

	<bean id="ldapDaoImpl"
class="in.gov.uidai.admin.service.impl.ldap.LdapDaoImpl">
		<property name="ldapConfig" ref="ldapConfigurator" />
		<property name="ldapTemplate" ref="ldapTemplate" />
	</bean>
	
	<bean id="sshClientImpl"
class="in.gov.uidai.admin.service.ssh.impl.SshClientImpl">
		<property name="hostName" value="10.12.12.221"/>
		<property name="portNum" value="22"/>
		<property name="superuserName" value="aditya"/>
		<property name="superuserPassword" value="aditya"/>
	</bean>
	
	<bean id="ftpFolderCreationHelperBean"
class="in.gov.uidai.admin.service.ftpfoldercreation.impl.FtpFolderCreationHelperBean">		
		<property name="inboxFolder" value="inbox"/>
		<property name="outBoxFolder" value="outbox"/>
		<property name="inBoxCommandsList">
			<list>
				<value>mkdir -p</value>
				<value>chmod 755</value>
			</list>
		</property>		
		<property name="outBoxCommandsList">
			<list>
				<value>mkdir -p</value>
				<value>chmod 555</value>
			</list>
		</property>
	</bean>
	
	<import resource="propertyconfigurator.xml" />

	
	<bean id="messagePublisherBaseConfiguration"
class="in.gov.uidai.platform.impl.messaging.MessagePublisherConfiguration">
		<property name="userName" value="${MSG.PUBLISHER.DOWNLOAD.EVENT.USER}" />
		<property name="password" value="${MSG.PUBLISHER.DOWNLOAD.EVENT.PASSWD}"
/>
		<property name="hostName" value="${MSG.PUBLISHER.DOWNLOAD.EVENT.HOSTNAME}"
/>
		<property name="virtualHost"
value="${MSG.PUBLISHER.DOWNLOAD.EVENT.VIRTUALHOSTNAME}" />
		<property name="exchangeName"
value="${MSG.PUBLISHER.DATA.DOWNLOAD.EVENT.EXCHANGE}" />
		<property name="messageMode" value="direct" />
		<property name="portNumber" value="${MSG.PUBLISHER.DOWNLOAD.EVENT.PORT}"
/>
		<property name="requestHeartBeat" value="0" />
		<property name="durable" value="false" />
		<property name="noAck" value="false" />
	</bean>
	<bean id="downloadRequestPublisherConfiguration"
class="in.gov.uidai.platform.impl.messaging.MessagePublisherConfiguration">
		<constructor-arg ref="messagePublisherBaseConfiguration" />
		<property name="queueName" value="${ADMIN.JOB.QUEUE}" />
		<property name="routeKey" value="${ADMIN.JOB.QUEUE}" />
	</bean>
	<bean id="downloadRequestPublisher"
class="in.gov.uidai.platform.impl.messaging.RabbitMQMessagePublisherImpl">
		<property name="rabbitMQConfigurations">
			<list>
				<ref bean="downloadRequestPublisherConfiguration" />
			</list>
		</property>
	</bean>

	
	<bean id="dashboardConfiguration"
class="in.gov.uidai.admin.service.impl.dashboard.config.DashboardConfiguration">
		<property name="catalogRootDirLocation" value="${DASHBOARD.CATALOG.DIR}"
/>
		<property name="reportsDirLocation" value="${DASHBOARD.REPORT.DIR}" />
		<property name="abisCSVLocation" value="${ABIS.REPORT.DIR}" />
		<property name="throughputReport" value="${ABIS.REPORT.NAME}" />
	</bean>

	<bean id="mddDemographicCacheProvider"
class="in.gov.uidai.admin.service.impl.manualdedup.ManualDedupDemographicCacheProvider"/>
	<bean id="demographicThresholdScore" class="java.lang.Integer">
		<constructor-arg value="${MDD.DEMOGRAPHIC.THRESHOLD.SCORE}"/>
	</bean>
	
	<bean id="bioSdkFingerMaxThresholdScore" class="java.lang.Integer">
		<constructor-arg value="${MDD.SDK.VERIFY.FINGER.MAX.THRESHOLD}"/>
	</bean>
	<bean id="bioSdkIrisMaxThresholdScore" class="java.lang.Integer">
		<constructor-arg value="${MDD.SDK.VERIFY.IRIS.MAX.THRESHOLD}"/>
	</bean>

	<import resource="UIDEnrolmentConfigContext.xml" />
	
	<bean id="recaptchaConfigurator"
class="in.gov.uidai.admin.service.impl.recaptcha.config.RecaptchaConfigurator">
		<property name="privateKey"
value="${WEB.PORTAL.UIDAI.RECAPTCHA.PRIVATEKEY}"/>
		<property name="publicKey"
value="${WEB.PORTAL.UIDAI.RECAPTCHA.PUBLICKEY}"/>
		<property name="enableProxy" value="${IS_HTTP_PROXY_ENABLED}"/>		
		<property name="proxyHost" value="${HTTP_PROXY_HOST}"/>
		<property name="proxyPort" value="${HTTP_PROXY_PORT}"/>
		<property name="includeNoscript" value="false"/>
	</bean>
	
	<bean id="uidJDBCPersistenceManager"
		class="in.gov.uidai.platform.impl.persistence.PersistenceManagerProvider">
		<property name="providersForEntity">
			<map>
				<entry
					key="in.gov.uidai.platform.impl.persistence.Criteria"
					value-ref="uidRdbmsProviderForJDBC" />				
				<entry
				
key="in.gov.uidai.platform.impl.persistence.entity.AbstractPersistentEntity"
					value-ref="uidRdbmsProviderForJDBC" />
			</map>
		</property>		
		<property name="persistenceDelegate"
			ref="uidmasterPersistenceDelegate" />
	</bean>
	
	<bean id="uidRdbmsProviderForJDBC"
		class="in.gov.uidai.platform.impl.persistence.provider.RDBMSProvider"
		parent="basePersistenceProvider">
		<property name="handler" ref="uidJDBCHandler" />
	</bean>
	<bean id="uidJDBCHandler"
	
class="in.gov.uidai.platform.impl.persistence.handler.SpringJDBCHiveHandler"
		parent="rdbmsPersistenceHandler">
		<property name="template" ref="uidJdbcTemplate" />
	</bean>
	<bean id="uidJdbcTemplate"
		class="org.springframework.jdbc.core.JdbcTemplate">
		<property name="dataSource" ref="uidDataSource" />
	</bean>
	
	<bean id="enrolStatusEmailSender"
class="in.gov.uidai.admin.service.impl.user.management.helper.EnrolStatusEmailSender">
		<property name="receiptEmail"
value="${UID.PORTAL.ENROLSTATUS.REQ.EMAIL}"></property>	
	</bean>

	<bean id="authenticationReportDefaultParams"
	
class="in.gov.uidai.server.model.authenticationReportService.AuthenticationReportParams">
		<property name="noOfDays" value="${AUTH.REPORT.MAX.DAYS}" />
		<property name="noOfAuths" value="${AUTH.REPORT.MAX.AUTHS}" />
	</bean>

	<bean id="authReportFolderPath" class="java.lang.String">
		<constructor-arg value="${AUTH.REPORT.PDF.FOLDER}" />
	</bean>
	
	<bean id="sifyAPIUrl" class="java.lang.String">
		<constructor-arg value="${SIFY.API.URL}" />
	</bean>
	
	<bean id="rgiRegistarList" class="java.lang.String">
		<constructor-arg value="${RGI.REGISTRAR.LIST}" />
	</bean>
	
	
		
	<bean id="manualdedupPublisherConfiguration"
	
class="in.gov.uidai.platform.impl.messaging.MessagePublisherConfiguration">
        <property name="hostName" value="${MSG.PUBLISHER.EVENT.HOSTNAME}" />
        <property name="virtualHost"
value="${MSG.PUBLISHER.EVENT.VIRTUALHOSTNAME}" />
        <property name="portNumber" value="${MSG.PUBLISHER.EVENT.PORT}" />
        <property name="userName" value="${MSG.PUBLISHER.EVENT.USER}" />
        <property name="password" value="${MSG.PUBLISHER.EVENT.PASSWD}" />
		<property name="exchangeName" value="${MSG.PUBLISHER.EVENT.EXCHANGE}" />
		<property name="queueName" value="${SERVICE.EVENT.QUEUE}" />
		<property name="routeKey" value="${SERVICE.EVENT.QUEUE}" />
		<property name="messageMode" value="direct" />
		<property name="requestHeartBeat" value="0" />
		<property name="durable" value="true" />
		<property name="noAck" value="false" />
	</bean>
	<bean id="manualdedupEventPublisher"
		class="in.gov.uidai.platform.impl.messaging.RabbitMQMessagePublisherImpl">
		<property name="rabbitMQConfigurations">
			<list>
				<ref bean="manualdedupPublisherConfiguration" />
			</list>
		</property>
	</bean>
	
	
	
	<bean id="mDDTaskEventPublisher"
		class="in.gov.uidai.admin.event.publisher.MDDTaskEventPublisherImpl">
		<property name="useInMemory"
value="${APP.MONITORING.MDD.EVENT.PUBLISHING.FLAG}" />
		<property name="endpointEventProducer" ref="endpointEventProducer" />
		<property name="eventMetricMap">
			<map>
				<entry key="MANUAL_DEDUP_REJECT"
value="MANUAL_DEDUP_REJECT_COUNT"></entry>
				<entry key="MANUAL_DEDUP_SUCCESS"
value="MANUAL_DEDUP_SUCCESS_COUNT"></entry>
				<entry key="MANUAL_DEDUP" value="MANUAL_DEDUP_HOLD_COUNT"></entry>
				<entry key="PKT_MDD_FAIL_FOR_DUPLICATE" value="REJECT_REASONS_"></entry>
				<entry key="PKT_MDD_FAIL_FOR_REENROLMENT"
value="REJECT_REASONS_"></entry>
				<entry key="PKT_MDD_FAIL_FOR_INVESTIGATION"
value="HOLD_REASONS_"></entry>
			</map>
		</property>
	</bean>

	<bean id="endpointEventProducer"
		class="in.gov.uidai.platform.impl.event.EndpointEventProducerImpl">
		<property name="defaultEndpointURI">
			<value>evt://service.taskevents</value>
		</property>
	</bean>

	<bean id="applicationEventMulticaster"
		class="in.gov.uidai.platform.impl.event.PlatformEventMulticaster">
		<property name="subscriptions">
			<list>
				<value>evt://service.taskevents</value>
			</list>
		</property>
	</bean>

	<bean id="taskEventConsumer"
class="in.gov.uidai.event.TaskEventConsumerImpl">
		<property name="subscriptions">
			<list>
				<value>evt://service.taskevents</value>
			</list>
		</property>
	</bean>
	
	
	<bean name="showResidentSelfServiceLink" class="java.lang.Boolean">
		<constructor-arg value="${SHOW.RESIDENT.SELF.SERVICE.LINK}" />
	</bean>
	
	<bean name="showReportFraudLink" class="java.lang.Boolean">
		<constructor-arg value="${SHOW.REPORT.FRAUD.LINK}" />
	</bean>
	
	<bean id="configServicePreferences"
		class="in.gov.uidai.admin.helper.ConfigServicePreferences">
		<property name="configServerUrl" value="${CONFIG.SERVER.URL}" />
	</bean>
	
	<bean id="orgApplicationTaskHelper"
class="in.gov.uidai.admin.service.impl.orgApplication.OrgApplicationTaskHelper">
		<constructor-arg ref="organizationTypeConstants" index="0"/>
		<constructor-arg ref="masterAdminPersistenceManager" index="1"/>
	</bean>
	
	<import
resource="UIDAuthSecurityBeans${AUTH_LICENSE_SECURITY_MECHANISM}.xml" />
	<import resource="propertyconfigurator.xml" />
	
	
	<bean id="hrWorkFlowTaskRequestPublisherBaseConfiguration"
	
class="in.gov.uidai.platform.impl.messaging.MessagePublisherConfiguration">
		<property name="userName"
			value="${HOLD.RESOLUTION.TASK.REQUEST.CONNECTOR.USER}" />
		<property name="password"
			value="${HOLD.RESOLUTION.TASK.REQUEST.CONNECTOR.PASSWD}" />
		<property name="hostName"
			value="${HOLD.RESOLUTION.TASK.REQUEST.CONNECTOR.HOSTNAME}" />
		<property name="virtualHost"
			value="${HOLD.RESOLUTION.TASK.REQUEST.CONNECTOR.VIRTUALHOSTNAME}" />
		<property name="exchangeName" value="${HOLD.RESOLUTION.TASK.MQ.EXCHANGE}"
/>
		<property name="messageMode" value="direct" />
		<property name="portNumber"
			value="${HOLD.RESOLUTION.TASK.REQUEST.CONNECTOR.PORT}" />
		<property name="requestHeartBeat" value="0" />
		<property name="durable" value="true" />
		<property name="noAck" value="false" />
	</bean>
	<bean id="hrWorkFlowTaskRequestPublisherConfiguration"
	
class="in.gov.uidai.platform.impl.messaging.MessagePublisherConfiguration">
		<constructor-arg ref="hrWorkFlowTaskRequestPublisherBaseConfiguration" />
		<property name="queueName"
value="${HOLD.RESOLUTION.TASK.REQUEST.QUEUE.NAME}" />
		<property name="routeKey"
value="${HOLD.RESOLUTION.TASK.REQUEST.QUEUE.NAME}" />
	</bean>
	<bean id="hrWorkFlowTaskRequestPublisher"
		class="in.gov.uidai.platform.impl.messaging.RabbitMQMessagePublisherImpl">
		<property name="rabbitMQConfigurations">
			<list>
				<ref bean="hrWorkFlowTaskRequestPublisherConfiguration" />
			</list>
		</property>
	</bean>
	
	
	
	<bean id="fiCertificateTrustValidator"
class="in.gov.uidai.platform.impl.security.CertificateTrustValidatorImpl">
		<constructor-arg value="21600000"></constructor-arg> 
		<property name="trustStoreProvider" ref="fiTrustStoreProvider"></property>
	</bean>
	
	<bean id="fiTrustStoreProvider"
class="in.gov.uidai.enrl.security.persistence.provider.TrustStoreCertificateProviderImpl">
		<property name="persistenceManager" ref="masterAdminPersistenceManager"
></property>
	</bean>
	
	<bean name="clientDataDownloadConfiguration"
	
class="in.gov.uidai.admin.service.impl.clientdata.ClientDataDownloadConfiguration">
		<property name="outputDir" value="${CLIENT.DATA.DOWNLOAD.OUTPUT.FOLDER}"
/>
		<property name="tempDir" value="${CLIENT.DATA.DOWNLOAD.TEMP.FOLDER}" />	
		<property name="uidmasterPersistenceManager"
ref="masterAdminPersistenceManager"/>
		<property name="uidprocessPersistenceManager"
ref="uidProcessPersistenceManager"/>
		
		
		<property name="entityToFileDescriptor">
			<map>			
				<entry key="EA_USER" value-ref="eaUserFileDescriptor"></entry>			
				<entry key="EAMP_USER_XML"
value-ref="eampUserXmlFileDescriptor"></entry>	
				<entry key="EA_MP_USER" value-ref="eampUserFileDescriptor"></entry>		
				
			</map>
		</property>
	</bean>
	
	<bean name="eaUserFileDescriptor"
class="in.gov.uidai.admin.service.impl.clientdata.ClientFileDescriptor">
		<property name="fileName" value="UID_Credentials_Import.txt"></property>
		<property name="fileType" value="CSV"></property>
		<property name="header" value="UserID,UserName,UserType"></property>
	</bean>

	<bean name="eampUserXmlFileDescriptor"
class="in.gov.uidai.admin.service.impl.clientdata.ClientFileDescriptor">
		<property name="fileName" value="userCredentials.xml"></property>
		<property name="fileType" value="XML"></property>		
	</bean>
	
	<bean name="eampUserFileDescriptor"
class="in.gov.uidai.admin.service.impl.clientdata.ClientFileDescriptor">
		<property name="fileName" value="user-credentials.csv"></property>
		<property name="fileType" value="CSV"></property>
		<property name="header" value="User-ID,Name,Type,Auth-ID"></property>
	</bean>
	
	
</beans>


enrluidmasterpersistmanagerconfigcontext.xml:-

<?xml version="1.0" encoding="UTF-8"?>
<!DOCTYPE beans PUBLIC &quot;-//SPRING//DTD BEAN 2.0//EN&quot;
&quot;http://www.springframework.org/dtd/spring-beans-2.0.dtd&quot;>
<beans>
	
	
	<bean id="uidMasterDataSource"
		class="com.mchange.v2.c3p0.ComboPooledDataSource"
		destroy-method="close">
		<property name="driverClass" value="${JDBC.MYSQL.DRIVER}" />
		<property name="jdbcUrl"
value="${JDBC.MYSQL.CONNECTION.URL.ENRL.UIDMASTER}" />
		<property name="user" value="${JDBC.MYSQL.USERNAME.ENRL.UIDMASTER}" />
		<property name="password" value="${JDBC.MYSQL.PASSWORD.ENRL.UIDMASTER}" />
		<property name="minPoolSize" value="${JDBC.POOL.MIN.SIZE.ENRL.UIDMASTER}"
/>
		<property name="maxPoolSize"
value="${JDBC.POOL.MAX.ACTIVE.ENRL.UIDMASTER}" />
		<property name="acquireIncrement" value="${JDBC.POOL.INCREMENT}" />
		<property name="maxIdleTime" value="${JDBC.POOL.IDLE.TIME.SECONDS}" />
		<property name="maxStatements" value="${JDBC.POOL.STATEMENTS}" /> 
		<property name="idleConnectionTestPeriod"
value="${JDBC.TEST.IDLE.TEST.PERIOD}" />
		<property name="testConnectionOnCheckin" value="${JDBC.TEST.ON.CHECKIN}"
/>
		<property name="preferredTestQuery" value="${JDBC.VALIDATION.QUERY.MYSQL}"
/>
	</bean>
	
	<bean id="uidEnrolmentCommonMasterSessionFactory"
class="org.springframework.orm.hibernate3.LocalSessionFactoryBean"
scope="prototype">
		<property name="dataSource" ref="uidMasterDataSource" />
		
		<property name="mappingResources">
			<list>
			
<value>packaged/hibernate/enrollment/enrolmentstationhistory.hbm.xml</value>
				<value>packaged/hibernate/enrollment/enrolmentstation.hbm.xml</value>
				<value>packaged/hibernate/enrollment/organization.hbm.xml</value>
				<value>packaged/hibernate/enrollment/organizationtype.hbm.xml</value>
				<value>packaged/hibernate/enrollment/organizationsubtype.hbm.xml</value>
				<value>packaged/hibernate/enrollment/user.hbm.xml</value>
				<value>packaged/hibernate/enrollment/usertype.hbm.xml</value>
			
<value>packaged/hibernate/enrollment/organizationassociation.hbm.xml</value>
				<value>packaged/hibernate/enrollment/enrollmentkey.hbm.xml</value>
			
<value>packaged/hibernate/enrollment/introducerregionmapping.hbm.xml</value>	
				<value>packaged/hibernate/enrollment/contact.hbm.xml</value>
				<value>packaged/hibernate/enrollment/organizationcontact.hbm.xml</value>
				<value>packaged/hibernate/enrollment/regiontype.hbm.xml</value>
				<value>packaged/hibernate/enrollment/bankmasterbranch.hbm.xml</value>
				<value>packaged/hibernate/enrollment/bankmaster.hbm.xml</value>
			
<value>packaged/hibernate/enrollment/organizationstatushistory.hbm.xml</value>
			
<value>packaged/hibernate/enrollment/organizationassocstatushistory.hbm.xml</value>
			
<value>packaged/hibernate/enrollment/introducerregionstatushistory.hbm.xml</value>
				<value>packaged/hibernate/enrollment/userstatushistory.hbm.xml</value>
				<value>packaged/hibernate/enrollment/usercertification.hbm.xml</value>
			
<value>packaged/hibernate/enrollment/certificationtypemaster.hbm.xml</value>
				<value>packaged/hibernate/enrollment/certificationtype.hbm.xml</value>
				<value>packaged/hibernate/enrollment/userInactiveReason.hbm.xml</value>
				<value>packaged/hibernate/enrollment/certificaterecord.hbm.xml</value>
				<value>packaged/hibernate/enrollment/registrardocmaster.hbm.xml</value>
				<value>packaged/hibernate/enrollment/registrardoctype.hbm.xml</value>
				<value>packaged/hibernate/enrollment/modetypemaster.hbm.xml</value>
				<value>packaged/hibernate/enrollment/registraragegroup.hbm.xml</value>        
				<value>packaged/hibernate/enrollment/registrardocref.hbm.xml</value>
				<value>packaged/hibernate/enrollment/blacklistedaccounts.hbm.xml</value>
			
<value>packaged/hibernate/enrollment/blacklistedaccountshistory.hbm.xml</value>
			
<value>packaged/hibernate/enrollment/blacklistedactiveuser.hbm.xml</value>
				<value>packaged/hibernate/enrollment/certificateDataLog.hbm.xml</value>
				<value>packaged/hibernate/security/caCertificate.hbm.xml</value>
				<value>packaged/hibernate/enrollment/regionaloffice.hbm.xml</value>
				<value>packaged/hibernate/enrollment/blacklistreasons.hbm.xml</value>				
			</list>
		</property>
		<property name="hibernateProperties">
			<value>
				hibernate.dialect = org.hibernate.dialect.MySQL5Dialect
				hibernate.show_sql = false
			</value>
		</property>
	</bean>	
	<bean id="uidMasterHibernateTemplate"
class="org.springframework.orm.hibernate3.HibernateTemplate">
		<property name="sessionFactory"
ref="uidEnrolmentCommonMasterSessionFactory"></property>
        <property name="alwaysUseNewSession" value="true" />		
	</bean>	
	<bean id="enrlCommonUidMasterHibernateHandler"
class="in.gov.uidai.platform.impl.persistence.handler.HibernateHandler"
		parent="rdbmsPersistenceHandler">
		<property name="template" ref="uidMasterHibernateTemplate" />
	</bean>
	<bean id="uidMasterRdbmsProviderForHibernate"
class="in.gov.uidai.platform.impl.persistence.provider.RDBMSProvider"
		parent="basePersistenceProvider">
		<property name="handler" ref="enrlCommonUidMasterHibernateHandler" />
	</bean>
	
	<bean id = "uidmasterPersistenceManager"
		class="in.gov.uidai.platform.impl.persistence.PersistenceManagerProvider">
		<property name="providersForEntity">
			<map>
				<entry key="in.gov.uidai.enrl.domain.EnrollmentKey"
value-ref="uidMasterRdbmsProviderForHibernate"/>
				<entry key="in.gov.uidai.enrl.domain.EnrolmentStation"
value-ref="uidMasterRdbmsProviderForHibernate" />
				<entry key="in.gov.uidai.enrl.domain.EnrolmentStationHistory"
value-ref="uidMasterRdbmsProviderForHibernate" />
				<entry key="in.gov.uidai.enrl.domain.Organization"
value-ref="uidMasterRdbmsProviderForHibernate" />
				<entry key="in.gov.uidai.enrl.domain.OrganizationType"
value-ref="uidMasterRdbmsProviderForHibernate" />
				<entry key="in.gov.uidai.enrl.domain.OrganizationSubType"
value-ref="uidMasterRdbmsProviderForHibernate" />
				<entry key="in.gov.uidai.enrl.domain.User"
value-ref="uidMasterRdbmsProviderForHibernate" />
				<entry key="in.gov.uidai.enrl.domain.UserType"
value-ref="uidMasterRdbmsProviderForHibernate" />
				<entry key="in.gov.uidai.enrl.domain.OrganizationAssociation"
value-ref="uidMasterRdbmsProviderForHibernate" />
				<entry key="in.gov.uidai.enrl.domain.IntroducerRegionMappingEntity"
value-ref="uidMasterRdbmsProviderForHibernate" />
				<entry key="in.gov.uidai.enrl.domain.Contact"
value-ref="uidMasterRdbmsProviderForHibernate" />
				<entry key="in.gov.uidai.enrl.domain.OrganizationContact"
value-ref="uidMasterRdbmsProviderForHibernate" />
				<entry key="in.gov.uidai.enrl.domain.RegionType"
value-ref="uidMasterRdbmsProviderForHibernate" />
				<entry key="in.gov.uidai.enrl.domain.BankMasterBranchEntity"
value-ref="uidMasterRdbmsProviderForHibernate" />
				<entry key="in.gov.uidai.enrl.domain.BankMasterEntity"
value-ref="uidMasterRdbmsProviderForHibernate" />
				<entry key="in.gov.uidai.enrl.domain.OrganizationStatusHistory"
value-ref="uidMasterRdbmsProviderForHibernate" />
				<entry key="in.gov.uidai.enrl.domain.OrganizationAssocStatusHistory"
value-ref="uidMasterRdbmsProviderForHibernate" />
				<entry key="in.gov.uidai.enrl.domain.IntroducerRegionStatusHistory"
value-ref="uidMasterRdbmsProviderForHibernate" />
				<entry key="in.gov.uidai.enrl.domain.UserStatusHistory"
value-ref="uidMasterRdbmsProviderForHibernate" />
				<entry key="in.gov.uidai.enrl.domain.UserCertificationEntity"
value-ref="uidMasterRdbmsProviderForHibernate" />
				<entry key="in.gov.uidai.enrl.domain.CertificationTypeMasterEntity"
value-ref="uidMasterRdbmsProviderForHibernate" />
				<entry key="in.gov.uidai.enrl.domain.CertificationTypeEntity"
value-ref="uidMasterRdbmsProviderForHibernate" />
				<entry key="in.gov.uidai.enrl.domain.CertificateRecordEntity"
value-ref="uidMasterRdbmsProviderForHibernate" />
				<entry key="in.gov.uidai.enrl.domain.RegistrarDocMasterEntity"
value-ref="uidMasterRdbmsProviderForHibernate" />
				<entry key="in.gov.uidai.enrl.domain.RegistrarDocTypeEntity"
value-ref="uidMasterRdbmsProviderForHibernate" />
				<entry key="in.gov.uidai.enrl.domain.RegistrarDocReferenceEntity"
value-ref="uidMasterRdbmsProviderForHibernate" />
				<entry key="in.gov.uidai.enrl.domain.BlacklistedActiveUsersEntity"
value-ref="uidMasterRdbmsProviderForHibernate" />
				<entry key="in.gov.uidai.enrl.domain.BlacklistedAccountsHistoryEntity"
value-ref="uidMasterRdbmsProviderForHibernate" />
				<entry key="in.gov.uidai.enrl.domain.BlacklistedAccountsEntity"
value-ref="uidMasterRdbmsProviderForHibernate" />
				<entry key="in.gov.uidai.enrl.domain.BlacklistReasonsEntity"
value-ref="uidMasterRdbmsProviderForHibernate" />
				<entry key="in.gov.uidai.enrl.domain.ModeTypeMaster"
value-ref="uidMasterRdbmsProviderForHibernate" />
				<entry key="in.gov.uidai.enrl.domain.RegistrarAgeGroup"
value-ref="uidMasterRdbmsProviderForHibernate" />   
				<entry key="in.gov.uidai.enrl.domain.CertificateDataLog"
value-ref="uidMasterRdbmsProviderForHibernate" />
				<entry key="in.gov.uidai.security.domain.CACertificateEntity"
value-ref="uidMasterRdbmsProviderForHibernate" />
				<entry key="in.gov.uidai.enrl.domain.RegionalOfficeEntity"
value-ref="uidMasterRdbmsProviderForHibernate" />
				<entry key="in.gov.uidai.enrl.domain.BlacklistReasonsEntity"
value-ref="uidMasterRdbmsProviderForHibernate" />
			</map>
		</property>
		<property name="persistenceDelegate"
ref="uidenrolmentcommonmasterpersistenceDelegate"/>
	</bean>
	
	
    
    <bean id="uidmasterTransactionManager"
class="org.springframework.orm.hibernate3.HibernateTransactionManager">
        <property name="sessionFactory"
ref="uidEnrolmentCommonMasterSessionFactory"/>
    </bean>
    <bean id="uidmasterTransactionInterceptor"
       
class='org.springframework.transaction.interceptor.TransactionInterceptor'>
        <property name="transactionManager">
            <ref bean="uidmasterTransactionManager" />
        </property>
        <property name="transactionAttributeSource">
            <ref bean="uidmasterTransactionAttributeSource" />
        </property>
    </bean>
    <bean id="uidmasterTransactionAttributeSource"
       
class="org.springframework.transaction.annotation.AnnotationTransactionAttributeSource"/>
        
    
    <bean
class="org.springframework.aop.framework.autoproxy.BeanNameAutoProxyCreator">
        <property name="beanNames">
            <list>
                <value>uidenrolmentcommonmasterpersistenceDelegate</value>
            </list>
        </property>
        <property name="interceptorNames">
            <list>
                <value>uidmasterTransactionInterceptor</value>
            </list>
        </property>
        <property name='proxyTargetClass' value="true" />
    </bean> 
    
    
    <bean id="uidenrolmentcommonmasterpersistenceDelegate"
class="in.gov.uidai.platform.impl.persistence.PersistenceDelegate"/>      
	
	
</beans>


Regards,
Abdulla






--
View this message in context: http://apache-database.10148.n7.nabble.com/record-is-not-inserting-in-the-Derby-DB-tp129512.html
Sent from the Apache Derby Users mailing list archive at Nabble.com.

Mime
View raw message