Revision 0:02300db8682b

View differences:

pom.xml
4 4
	<modelVersion>4.0.0</modelVersion>
5 5

  
6 6
	<groupId>net.penril</groupId>
7
	<artifactId>m2u-upass-core</artifactId>
7
	<artifactId>agro-upass</artifactId>
8 8
	<version>2.0-SNAPSHOT</version>
9
	<name>M2U UPass Core</name>
9
	<name>Agrobank UPass</name>
10 10
	<properties>
11 11
		<project.build.sourceEncoding>UTF-8</project.build.sourceEncoding>
12 12
		<cobertura.version>1.9.4.1</cobertura.version>
13 13
		<config.postfix />
14
		<m2u-upass-classifier></m2u-upass-classifier>
15 14
	</properties>
16
	<distributionManagement>
17
		<snapshotRepository>
18
			<id>penril.nexus.repo</id>
19
			<name>Penril Nexus Repo</name>
20
			<url>scp://staging.penril.net/usr/share/tomcat5/sonatype-work/nexus/storage/snapshots</url>
21
			<uniqueVersion>false</uniqueVersion>
22
		</snapshotRepository>
23
	</distributionManagement>
24 15
	<build>
25 16
		<sourceDirectory>src</sourceDirectory>
26 17
		<resources>
......
56 47
	</build>
57 48
	<profiles>
58 49
		<profile>
50
			<id>env-ant</id>
51
			<activation>
52
				<property>
53
					<name>env</name>
54
				</property>
55
			</activation>
56
			<build>
57
				<plugins>
58
					<plugin>
59
						<artifactId>maven-antrun-plugin</artifactId>
60
						<executions>
61
							<execution>
62
								<id>env-config</id>
63
								<phase>process-resources</phase>
64
								<configuration>
65
									<target>
66
										<delete file="${project.build.outputDirectory}/com/ib/hibernate/configuration/hibernate.cfg.xml" />
67
										<copy file="resources/com/ib/hibernate/configuration/hibernate${config.postfix}.cfg.xml"
68
											tofile="${project.build.outputDirectory}/com/ib/hibernate/configuration/hibernate.cfg.xml" />
69

  
70
										<delete>
71
											<fileset dir="${project.build.outputDirectory}/com/ib/hibernate/configuration"
72
												includes="hibernate.*.cfg.xml" />
73
										</delete>
74

  
75
										<delete file="${project.build.outputDirectory}/proxool.properties" />
76
										<copy file="resources/proxool${config.postfix}.properties"
77
											tofile="${project.build.outputDirectory}/proxool.properties" />
78

  
79
										<delete>
80
											<fileset dir="${project.build.outputDirectory}"
81
												includes="proxool.*.properties" />
82
										</delete>
83
									</target>
84
								</configuration>
85
								<goals>
86
									<goal>run</goal>
87
								</goals>
88
							</execution>
89
						</executions>
90
					</plugin>
91
				</plugins>
92
			</build>
93
		</profile>
94
		<profile>
95
			<id>env-dev-penril</id>
96
			<activation>
97
				<property>
98
					<name>env</name>
99
					<value>dev-penril</value>
100
				</property>
101
			</activation>
102
			<distributionManagement>
103
				<snapshotRepository>
104
					<id>penril.nexus.repo</id>
105
					<name>Penril Nexus Repo</name>
106
					<url>scp://staging.penril.net/usr/share/tomcat5/sonatype-work/nexus/storage/snapshots</url>
107
				</snapshotRepository>
108
			</distributionManagement>
109
			<properties>
110
				<config.postfix>.dev-penril</config.postfix>
111
			</properties>
112
		</profile>
113
		<profile>
114
			<id>env-staging-ci</id>
115
			<activation>
116
				<property>
117
					<name>env</name>
118
					<value>staging-ci</value>
119
				</property>
120
			</activation>
121
			<distributionManagement>
122
				<snapshotRepository>
123
					<id>penril.nexus.repo.coverage</id>
124
					<name>Penril Nexus Repo (Coverage)</name>
125
					<url>scp://staging.penril.net/usr/share/tomcat5/sonatype-work/nexus/storage/snapshots-coverage</url>
126
				</snapshotRepository>
127
			</distributionManagement>
128
			<properties>
129
				<config.postfix>.staging-ci</config.postfix>
130
			</properties>
131
		</profile>
132
		<profile>
59 133
			<id>cobertura-instrument</id>
60 134
			<activation>
61 135
				<property>
62 136
					<name>cobertura-build</name>
63 137
				</property>
64 138
			</activation>
65
			<properties>
66
				<m2u-upass-classifier>instrumented</m2u-upass-classifier>
67
			</properties>
68 139
			<build>
69 140
				<plugins>
70 141
					<plugin>
71
						<artifactId>maven-jar-plugin</artifactId>
72
						<configuration>
73
							<classifier>${m2u-upass-classifier}</classifier>
74
						</configuration>
75
					</plugin>
76
					<plugin>
77 142
						<groupId>org.codehaus.mojo</groupId>
78 143
						<artifactId>cobertura-maven-plugin</artifactId>
79 144
						<configuration>
......
87 152
									<!-- <ignore>com.example.boringcode.*</ignore> -->
88 153

  
89 154
									<!-- <ignore>my.com.upass.SelfTest</ignore> -->
90
								</ignores>
155
							</ignores>
91 156
								<excludes>
92
									<!-- <exclude>com/example/dullcode/**/*.class</exclude> <exclude>com/example/**/*Test.class</exclude> -->
157
									<!-- 
158
									<exclude>com/example/dullcode/**/*.class</exclude> 
159
									<exclude>com/example/**/*Test.class</exclude> 
160
									-->
93 161
									<!-- <exclude>my/com/upass/UPassController.class</exclude> -->
94 162
									<exclude>my/com/upass/GemaltoTest*.class</exclude>
95 163
									<exclude>my/com/upass/GemaltoTokenBean*.class</exclude>
96
									<exclude>my/com/upass/UPassController.class</exclude>
164
									<exclude>my/com/upass/UPassController*.class</exclude>
97 165
									<exclude>my/com/upass/UPassControllerExt*.class</exclude>
98
									<exclude>my/com/upass/db/DBOperations*.class</exclude>
99
									<exclude>my/com/upass/dao/hibernate/UserGemaltoDAOHibernate*.class</exclude>
100
									<exclude>my/com/upass/dao/hibernate/UserSecureMetricDAOHibernate*.class</exclude>
101
									<exclude>my/com/upass/dao/hibernate/UserVascoDAOHibernate*.class</exclude>
166
									<exclude>my/com/upass/db/DBOperations*.class</exclude> 
167
									<exclude>my/com/upass/dao/hibernate/UserGemaltoDAOHibernate*.class</exclude> 
168
									<exclude>my/com/upass/dao/hibernate/UserSecureMetricDAOHibernate*.class</exclude> 
169
									<exclude>my/com/upass/dao/hibernate/UserVascoDAOHibernate*.class</exclude> 
102 170
									<exclude>my/com/upass/SelfTest*.class</exclude>
103 171
									<exclude>my/com/upass/gemalto/**/*.class</exclude>
104 172
									<exclude>my/com/upass/secure/**/*.class</exclude>
105 173
									<exclude>my/com/upass/security/**/*.class</exclude>
106 174
									<exclude>my/com/upass/vasco/**/*.class</exclude>
107
									<exclude>my/com/upass/tac/**/*.class</exclude>
108
									<exclude>my/com/upass/services/*Tac*.class</exclude>
109
									<exclude>my/com/upass/services/*Token*.class</exclude>
110
									<exclude>my/com/upass/services/*SecurityCode*.class</exclude>
111
									<exclude>my/com/upass/dao/*Token*.class</exclude>
112
									<exclude>my/com/upass/dao/*SecurityCode*.class</exclude>
113
									<exclude>my/com/upass/dao/**/*Token*.class</exclude>
114
									<exclude>my/com/upass/dao/**/*SecurityCode*.class</exclude>
115
									<exclude>my/com/upass/pojo/*Token*.class</exclude>
116
									<exclude>my/com/upass/pojo/SecurityCode*.class</exclude>
117 175
								</excludes>
118 176
							</instrumentation>
119 177

  
......
178 236
				</dependency>
179 237
			</dependencies>
180 238
		</profile>
239
		<profile>
240
			<id>env-staging-agro</id>
241
			<activation>
242
				<property>
243
					<name>env</name>
244
					<value>staging-agro</value>
245
				</property>
246
			</activation>
247
			<distributionManagement>
248
				<snapshotRepository>
249
					<id>agro.nexus.repo</id>
250
					<name>Agro Nexus Repo</name>
251
					<url>scp://10.6.6.20/cygdrive/d/programs/sonatype-work/nexus/storage/snapshots</url>
252
				</snapshotRepository>
253
			</distributionManagement>
254
		</profile>
181 255
	</profiles>
182 256
	<dependencies>
183 257
		<dependency>
184 258
			<groupId>net.penril</groupId>
259
			<artifactId>agro-hibernate-generic</artifactId>
260
			<version>0.0.1-SNAPSHOT</version>
261
		</dependency>
262
		<dependency>
263
			<groupId>log4j</groupId>
264
			<artifactId>log4j</artifactId>
265
			<version>1.2.14</version>
266
			<scope>compile</scope>
267
		</dependency>
268
		<dependency>
269
			<groupId>net.penril</groupId>
185 270
			<artifactId>aal2wrap</artifactId>
186 271
			<version>1</version>
187 272
		</dependency>
188 273
		<dependency>
189 274
			<groupId>com.microsoft</groupId>
190
			<artifactId>mssql-jdbc</artifactId>
191
			<version>3.0</version>
275
			<artifactId>sqljdbc4</artifactId>
276
			<version>4</version>
192 277
		</dependency>
193 278
		<dependency>
194 279
			<groupId>antlr</groupId>
......
243 328
			<version>1.0</version>
244 329
		</dependency>
245 330
		<dependency>
246
			<groupId>net.penril</groupId>
247
			<artifactId>jotpcore</artifactId>
248
			<version>3.2</version>
331
		  <groupId>net.penril</groupId>
332
		  <artifactId>jotpcore</artifactId>
333
		  <version>3.2</version>
249 334
		</dependency>
250 335
		<dependency>
251
			<groupId>net.penril</groupId>
252
			<artifactId>commons-logging</artifactId>
253
			<version>1.1.1</version>
336
		  <groupId>net.penril</groupId>
337
		  <artifactId>commons-logging</artifactId>
338
		  <version>1.1.1</version>
254 339
		</dependency>
255 340
		<dependency>
256
			<groupId>net.penril</groupId>
257
			<artifactId>proxool</artifactId>
258
			<version>0.9.1</version>
341
		  <groupId>net.penril</groupId>
342
		  <artifactId>proxool</artifactId>
343
		  <version>0.9.1</version>
259 344
		</dependency>
260 345
		<dependency>
261
			<groupId>net.penril</groupId>
262
			<artifactId>proxool-cglib</artifactId>
263
			<version>1</version>
346
		  <groupId>net.penril</groupId>
347
		  <artifactId>proxool-cglib</artifactId>
348
		  <version>1</version>
264 349
		</dependency>
265 350
		<dependency>
266
			<groupId>net.penril</groupId>
267
			<artifactId>bcprov-jdk</artifactId>
268
			<version>15-144</version>
351
		  <groupId>net.penril</groupId>
352
		  <artifactId>bcprov-jdk</artifactId>
353
		  <version>15-144</version>
269 354
		</dependency>
270 355
		<dependency>
271
			<groupId>net.penril</groupId>
272
			<artifactId>NCSO</artifactId>
273
			<version>1</version>
356
		  <groupId>net.penril</groupId>
357
		  <artifactId>NCSO</artifactId>
358
		  <version>1</version>
274 359
		</dependency>
275 360
		<dependency>
276 361
			<groupId>net.sourceforge.jtds</groupId>
277 362
			<artifactId>jtds</artifactId>
278 363
			<version>1.2.2</version>
279 364
		</dependency>
280
		<dependency>
281
			<groupId>commons-lang</groupId>
282
			<artifactId>commons-lang</artifactId>
283
			<version>2.5</version>
284
		</dependency>
285
		<!-- ORACLE database driver -->
286
		<dependency>
287
			<groupId>com.oracle.jdbc</groupId>
288
			<artifactId>com.springsource.oracle.jdbc</artifactId>
289
			<version>10.2.0.2</version>
290
		</dependency>
291
		<dependency>
292
			<groupId>net.penril</groupId>
293
			<artifactId>m2u-upass-min</artifactId>
294
			<version>2.0-SNAPSHOT</version>
295
			<classifier>${m2u-upass-classifier}</classifier>
296
		</dependency>
297
		<dependency>
298
			<groupId>org.hibernate</groupId>
299
			<artifactId>hibernate-c3p0</artifactId>
300
			<version>3.3.1.GA</version>
301
		</dependency>
302 365
	</dependencies>
303 366
</project>
304
	
resources/com/ib/hibernate/configuration/hibernate.cfg.xml
1
<?xml version='1.0' encoding='utf-8'?>
2
<!DOCTYPE hibernate-configuration PUBLIC "-//Hibernate/Hibernate Configuration DTD 3.0//EN"
3
                                         "http://hibernate.sourceforge.net/hibernate-configuration-3.0.dtd">
4

  
5
<hibernate-configuration>
6
	<session-factory>
7
		<!-- Database connection settings -->
8
		
9
		<!-- 
10
		<property name="connection.url">jdbc:sqlserver://10.6.6.21:1433;databaseName=agroib_db</property>
11
		<property name="hibernate.connection.username">agroib_user</property>
12
		<property name="hibernate.connection.password">P@$$w0rd</property>
13
		-->
14
		
15
		<property name="connection.url">jdbc:sqlserver://localhost:1433;databaseName=agroib_db</property>
16
		<property name="hibernate.connection.username">agroib_user</property>
17
		<property name="hibernate.connection.password">password</property>
18
		
19
		<!-- Database connection settings -->
20
		<property name="connection.driver_class">com.microsoft.sqlserver.jdbc.SQLServerDriver</property>
21
		<!-- SQL dialect -->
22
		<property name="dialect">org.hibernate.dialect.SQLServerDialect</property>
23

  
24
		<!-- Enable Hibernate's automatic session context management -->
25
		<property name="current_session_context_class">thread</property>
26

  
27
		<!-- Disable the second-level cache -->
28
		<property name="cache.provider_class">org.hibernate.cache.NoCacheProvider</property>
29

  
30
		<!-- Echo all executed SQL to stdout -->
31
		<property name="show_sql">true</property>
32
		<property name="format_sql">true</property>
33

  
34
		<property name="hibernate.hbm2ddl.auto">none</property>
35

  
36
		<!-- Mapping files -->
37
		<mapping resource="my/com/upass/hibernate/TbAmUsermas.hbm.xml" />
38
		<mapping resource="my/com/upass/hibernate/TbAmUser.hbm.xml" />
39
		<mapping resource="my/com/upass/hibernate/TbAmTac.hbm.xml" />
40
		<mapping resource="my/com/upass/hibernate/TbAmGemalto.hbm.xml" />
41
		<mapping resource="my/com/upass/hibernate/TbAmVasco.hbm.xml" />
42
		<mapping resource="my/com/upass/hibernate/TbAmAppserv.hbm.xml" />
43
		<mapping resource="my/com/upass/hibernate/TbAmConfig.hbm.xml" />
44
		<mapping resource="my/com/upass/hibernate/TbAmSecurityCode.hbm.xml" />
45
		<mapping resource="my/com/upass/hibernate/TbAmUserBackup.hbm.xml" />
46
		<mapping resource="my/com/upass/hibernate/TbAmUsermasBackup.hbm.xml" />
47
		<mapping resource="my/com/upass/hibernate/TbAmTacBackup.hbm.xml" />
48
	</session-factory>
49
</hibernate-configuration>
resources/com/ib/hibernate/configuration/hibernate.dev-penril.cfg.xml
1
<?xml version='1.0' encoding='utf-8'?>
2
<!DOCTYPE hibernate-configuration PUBLIC "-//Hibernate/Hibernate Configuration DTD 3.0//EN"
3
                                         "http://hibernate.sourceforge.net/hibernate-configuration-3.0.dtd">
4

  
5
<hibernate-configuration>
6
	<session-factory>
7
		<!-- Database connection settings -->
8

  
9
		<!-- 
10
		<property name="connection.url">jdbc:sqlserver://10.6.6.21:1433;databaseName=agroib_db</property>
11
		<property name="hibernate.connection.username">agroib_user</property>
12
		<property name="hibernate.connection.password">P@$$w0rd</property>
13
		-->
14
		
15
 		<property name="connection.url">jdbc:sqlserver://demosvr1.penril.net:1433;databaseName=agroib_db-phase2</property>
16
		<property name="hibernate.connection.username">agroib_user</property>
17
		<property name="hibernate.connection.password">P@$$w0rd</property>
18
		
19
		<!-- Database connection settings -->
20
		<property name="connection.driver_class">com.microsoft.sqlserver.jdbc.SQLServerDriver</property>
21
		<!-- SQL dialect -->
22
		<property name="dialect">org.hibernate.dialect.SQLServerDialect</property>
23

  
24
		<!-- Enable Hibernate's automatic session context management -->
25
		<property name="current_session_context_class">thread</property>
26

  
27
		<!-- Disable the second-level cache -->
28
		<property name="cache.provider_class">org.hibernate.cache.NoCacheProvider</property>
29

  
30
		<!-- Echo all executed SQL to stdout -->
31
		<property name="show_sql">false</property>
32
		<property name="format_sql">true</property>
33

  
34
		<property name="hibernate.hbm2ddl.auto">none</property>
35

  
36
		<!-- Mapping files -->
37
		<mapping resource="my/com/upass/hibernate/TbAmUsermas.hbm.xml" />
38
		<mapping resource="my/com/upass/hibernate/TbAmUser.hbm.xml" />
39
		<mapping resource="my/com/upass/hibernate/TbAmTac.hbm.xml" />
40
		<mapping resource="my/com/upass/hibernate/TbAmGemalto.hbm.xml" />
41
		<mapping resource="my/com/upass/hibernate/TbAmVasco.hbm.xml" />
42
		<mapping resource="my/com/upass/hibernate/TbAmAppserv.hbm.xml" />
43
		<mapping resource="my/com/upass/hibernate/TbAmConfig.hbm.xml" />
44
		<mapping resource="my/com/upass/hibernate/TbAmSecurityCode.hbm.xml" />
45
	</session-factory>
46
</hibernate-configuration>
resources/com/ib/hibernate/configuration/hibernate.staging-agro.cfg.xml
1
<?xml version="1.0" encoding="UTF-8"?>
2
<!DOCTYPE hibernate-configuration PUBLIC "-//Hibernate/Hibernate Configuration DTD//EN"
3
                                         "http://hibernate.sourceforge.net/hibernate-configuration-3.0.dtd">
4
<hibernate-configuration>
5
	<session-factory>
6
		<!-- Database connection settings -->
7
		
8
		<property name="connection.url">jdbc:sqlserver://10.6.6.21:1433;databaseName=agroib_db</property>
9
		<property name="connection.username">agroib_user</property>
10
		<property name="connection.password">P@$$w0rd</property>
11

  
12
		<!-- Database connection settings -->
13
		<property name="connection.driver_class">com.microsoft.sqlserver.jdbc.SQLServerDriver</property>
14
		<!-- SQL dialect -->
15
		<property name="dialect">org.hibernate.dialect.SQLServerDialect</property>
16

  
17
		<!-- Enable Hibernate's automatic session context management -->
18
		<property name="current_session_context_class">thread</property>
19

  
20
		<!-- Disable the second-level cache -->
21
		<property name="cache.provider_class">org.hibernate.cache.NoCacheProvider</property>
22

  
23
		<!-- Echo all executed SQL to stdout -->
24
		<property name="show_sql">true</property>
25
		<property name="format_sql">true</property>
26

  
27
		<property name="hibernate.hbm2ddl.auto">none</property>
28

  
29
		<!-- Mapping files -->
30
		<mapping resource="my/com/upass/hibernate/TbAmUsermas.hbm.xml" />
31
		<mapping resource="my/com/upass/hibernate/TbAmUser.hbm.xml" />
32
		<mapping resource="my/com/upass/hibernate/TbAmTac.hbm.xml" />
33
		<mapping resource="my/com/upass/hibernate/TbAmGemalto.hbm.xml" />
34
		<mapping resource="my/com/upass/hibernate/TbAmVasco.hbm.xml" />
35
		<mapping resource="my/com/upass/hibernate/TbAmAppserv.hbm.xml" />
36
		<mapping resource="my/com/upass/hibernate/TbAmConfig.hbm.xml" />
37
		<mapping resource="my/com/upass/hibernate/TbAmSecurityCode.hbm.xml" />
38
		<mapping resource="my/com/upass/hibernate/TbAmUserBackup.hbm.xml" />
39
		<mapping resource="my/com/upass/hibernate/TbAmUsermasBackup.hbm.xml" />
40
		<mapping resource="my/com/upass/hibernate/TbAmTacBackup.hbm.xml" />
41
	</session-factory>
42
</hibernate-configuration>
resources/com/ib/hibernate/configuration/hibernate.staging-ci.cfg.xml
1
<?xml version='1.0' encoding='utf-8'?>
2
<!DOCTYPE hibernate-configuration PUBLIC "-//Hibernate/Hibernate Configuration DTD 3.0//EN"
3
                                         "http://hibernate.sourceforge.net/hibernate-configuration-3.0.dtd">
4

  
5
<hibernate-configuration>
6
	<session-factory>
7
		<!-- Database connection settings -->
8

  
9
		<!-- 
10
		<property name="connection.url">jdbc:sqlserver://10.6.6.21:1433;databaseName=agroib_db</property>
11
		<property name="hibernate.connection.username">agroib_user</property>
12
		<property name="hibernate.connection.password">P@$$w0rd</property>
13
		-->
14

  
15
		<!-- <property name="connection.url">jdbc:sqlserver://192.168.56.2:1433;databaseName=agro-ci-db</property> -->
16
		<property name="connection.url">jdbc:sqlserver://demosvr1.penril.net:1433;databaseName=agro-ci-db</property>
17
		<property name="hibernate.connection.username">agro-ci-user</property>
18
		<property name="hibernate.connection.password">ci-123</property>
19

  
20
		<!-- Database connection settings -->
21
		<property name="connection.driver_class">com.microsoft.sqlserver.jdbc.SQLServerDriver</property>
22
		<!-- SQL dialect -->
23
		<property name="dialect">org.hibernate.dialect.SQLServerDialect</property>
24

  
25
		<!-- Enable Hibernate's automatic session context management -->
26
		<property name="current_session_context_class">thread</property>
27

  
28
		<!-- Disable the second-level cache -->
29
		<property name="cache.provider_class">org.hibernate.cache.NoCacheProvider</property>
30

  
31
		<!-- Echo all executed SQL to stdout -->
32
		<property name="show_sql">false</property>
33
		<property name="format_sql">true</property>
34

  
35
		<property name="hibernate.hbm2ddl.auto">none</property>
36

  
37
		<!-- Mapping files -->
38
		<mapping resource="my/com/upass/hibernate/TbAmUsermas.hbm.xml" />
39
		<mapping resource="my/com/upass/hibernate/TbAmUser.hbm.xml" />
40
		<mapping resource="my/com/upass/hibernate/TbAmTac.hbm.xml" />
41
		<mapping resource="my/com/upass/hibernate/TbAmGemalto.hbm.xml" />
42
		<mapping resource="my/com/upass/hibernate/TbAmVasco.hbm.xml" />
43
		<mapping resource="my/com/upass/hibernate/TbAmAppserv.hbm.xml" />
44
		<mapping resource="my/com/upass/hibernate/TbAmConfig.hbm.xml" />
45
		<mapping resource="my/com/upass/hibernate/TbAmSecurityCode.hbm.xml" />
46
		<mapping resource="my/com/upass/hibernate/TbAmUserBackup.hbm.xml" />
47
		<mapping resource="my/com/upass/hibernate/TbAmUsermasBackup.hbm.xml" />
48
		<mapping resource="my/com/upass/hibernate/TbAmTacBackup.hbm.xml" />
49
	</session-factory>
50
</hibernate-configuration>
resources/my/com/upass/hibernate/TbAmAppserv.hbm.xml
1
<?xml version="1.0" encoding="UTF-8"?>
2
<!DOCTYPE hibernate-mapping PUBLIC "-//Hibernate/Hibernate Mapping DTD 3.0//EN" "http://hibernate.sourceforge.net/hibernate-mapping-3.0.dtd">
3

  
4
<hibernate-mapping>
5
	<class name="my.com.upass.pojo.AppAccessBean" table="TB_AM_APPSERV">
6
		<composite-id>
7
			<key-property name="aappServId" column="A_APP_SERV_ID"
8
				type="string" length="10" />
9
			<key-many-to-one name="tbAmUser"
10
				class="my.com.upass.pojo.UserBean" column="A_USER_ID" />
11
		</composite-id>
12
		<property name="aappServAccess1" type="string">
13
			<column name="A_APP_SERV_ACCESS1" length="64" />
14
		</property>
15
		<property name="aappServAccess2" type="string">
16
			<column name="A_APP_SERV_ACCESS2" length="64" />
17
		</property>
18
		<property name="aappServAuthList" type="string">
19
			<column name="A_APP_SERV_AUTH_LIST" length="64" />
20
		</property>
21
	</class>
22
</hibernate-mapping>
23

  
resources/my/com/upass/hibernate/TbAmConfig.hbm.xml
1
<?xml version="1.0" encoding="UTF-8"?>
2
<!DOCTYPE hibernate-mapping PUBLIC "-//Hibernate/Hibernate Mapping DTD 3.0//EN" "http://hibernate.sourceforge.net/hibernate-mapping-3.0.dtd">
3

  
4
<hibernate-mapping>
5
	<class name="my.com.upass.pojo.ConfigurationBean" table="TB_AM_CONFIG">
6
		<composite-id>
7
            <key-property name="configName" type="string">
8
                <column name="CONFIG_NAME" length="64" />
9
            </key-property>
10
            <key-property name="applicationId" type="integer">
11
                <column name="APPLICATION_ID" length="9" not-null="true" />
12
            </key-property>
13
    	</composite-id>
14
		<property name="configValue" type="string">
15
			<column name="CONFIG_VALUE" length="64" not-null="true" />
16
		</property>
17
		<property name="configDescription" type="string">
18
			<column name="CONFIG_DESCRIPTION" length="256" />
19
		</property>
20
		<property name="mkPending" type="integer">
21
			<column name="MK_PENDING"/>
22
		</property>
23
	</class>
24
</hibernate-mapping>
25

  
resources/my/com/upass/hibernate/TbAmConfigChange.hbm.xml
1
<?xml version="1.0" encoding="UTF-8"?>
2
<!DOCTYPE hibernate-mapping PUBLIC "-//Hibernate/Hibernate Mapping DTD 3.0//EN" 
3
"http://hibernate.sourceforge.net/hibernate-mapping-3.0.dtd">
4

  
5
<hibernate-mapping>
6
	<class name="my.com.upass.pojo.TbAmConfigChange" table="TB_AM_CONFIG_CHANGE">
7
		<id name="configUpdate" type="integer">
8
			<column name="CONFIG_UPDATE" />
9
			<generator class="assigned" />
10
		</id>
11
	</class>
12
</hibernate-mapping>
resources/my/com/upass/hibernate/TbAmGemalto.hbm.xml
48 48
			<column name="G_USER_ID" precision="9" not-null="true" />
49 49
		</property>
50 50

  
51
		<many-to-one name="upassUser" class="my.com.upass.pojo.MinimalUserBean"
51
		<many-to-one name="upassUser" class="my.com.upass.pojo.UserBean"
52 52
			column="G_USER_ID" insert="false" update="false" fetch="join" />
53 53
	</class>
54 54
</hibernate-mapping>
resources/my/com/upass/hibernate/TbAmSecurityCode.hbm.xml
1
<?xml version="1.0" encoding="UTF-8"?>
2
<!DOCTYPE hibernate-mapping PUBLIC "-//Hibernate/Hibernate Mapping DTD 3.0//EN" "http://hibernate.sourceforge.net/hibernate-mapping-3.0.dtd">
3

  
4
<hibernate-mapping>
5
	<class name="my.com.upass.pojo.SecurityCodeBean" table="TB_AM_SECURITY_CODE">
6
		<id name="scOid" type="long">
7
			<column name="T_USER_ID" precision="9" />
8
			<generator class="native" />
9
		</id>
10
		
11
		<property name="scCipherText" type="string">
12
			<column name="SC_CIPHERTEXT" length="64" />
13
		</property>
14
		<property name="scState" type="int">
15
			<column name="SC_STATE" precision="1" not-null="true"
16
				default="0" />
17
		</property>
18
		<property name="scDateCreated" type="timestamp">
19
			<column name="SC_DATE_GENERATED" />
20
		</property>
21
		<property name="scDateFirstUsed" type="timestamp">
22
			<column name="SC_DATE_FIRST_USED" />
23
		</property>
24
		<property name="scDateLastUsed" type="timestamp">
25
			<column name="SC_DATE_LAST_USED" />
26
		</property>
27
		<property name="scUseCount" type="int">
28
			<column name="SC_USE_COUNT" precision="6" not-null="true"
29
				default="0" />
30
		</property>
31
		<property name="scErrorCount" type="int">
32
			<column name="SC_ERROR_COUNT" precision="2" not-null="true"
33
				default="0" />
34
		</property>
35
		<property name="scReferenceId" type="string">
36
			<column name="SC_REFERENCE_ID" unique="true" length="40" />
37
		</property>
38
	</class>
39
</hibernate-mapping>
40

  
resources/my/com/upass/hibernate/TbAmTac.hbm.xml
1
<?xml version="1.0" encoding="UTF-8"?>
2
<!DOCTYPE hibernate-mapping PUBLIC "-//Hibernate/Hibernate Mapping DTD 3.0//EN" "http://hibernate.sourceforge.net/hibernate-mapping-3.0.dtd">
3

  
4
<hibernate-mapping>
5
	<class name="my.com.upass.pojo.TacBean" table="TB_AM_TAC">
6
		<id name="userID" type="long">
7
			<column name="T_USER_ID" precision="9" />
8
			<generator class="assigned" />
9
		</id>
10

  
11
		<property name="cipherText" type="string">
12
			<column name="T_TAC_CIPHERTEXT" length="64" />
13
		</property>
14
		<property name="state" type="integer">
15
			<column name="T_TAC_STATE" precision="1" not-null="true"
16
				default="0" />
17
		</property>
18
		<property name="dateCreated" type="timestamp">
19
			<column name="T_DATE_GENERATED" />
20
		</property>
21
		<property name="dateFirstUsed" type="timestamp">
22
			<column name="T_DATE_FIRST_USED" />
23
		</property>
24
		<property name="dateLastUsed" type="timestamp">
25
			<column name="T_DATE_LAST_USED" />
26
		</property>
27
		<property name="useCount" type="integer">
28
			<column name="T_USE_COUNT" precision="6" not-null="true"
29
				default="0" />
30
		</property>
31
		<property name="errorCount" type="integer">
32
			<column name="T_ERROR_COUNT" precision="2" not-null="true"
33
				default="0" />
34
		</property>
35
		<property name="sessionId" type="string">
36
			<column name="T_SESSION_ID" length="32" />
37
		</property>
38

  
39
		<many-to-one name="upassUser" class="my.com.upass.pojo.UserBean"
40
			fetch="join" column="T_USER_ID" cascade="save-update, delete" insert="false"
41
			update="false" />
42
	</class>
43
</hibernate-mapping>
44

  
resources/my/com/upass/hibernate/TbAmTacBackup.hbm.xml
1
<?xml version="1.0" encoding="UTF-8"?>
2
<!DOCTYPE hibernate-mapping PUBLIC "-//Hibernate/Hibernate Mapping DTD 3.0//EN" 
3
"http://hibernate.sourceforge.net/hibernate-mapping-3.0.dtd">
4

  
5
<!-- Fine-tuned for cross-db migration. -->
6
<hibernate-mapping>
7
	<class name="my.com.upass.pojo.TbAmTacBackup" table="TB_AM_TAC_BACKUP">
8
		<id name="oid" type="integer">
9
			<column name="OID" precision="18" />
10
			<generator class="native" />
11
		</id>
12
		
13
		<property name="tuserId" type="long">
14
			<column name="T_USER_ID" precision="9" />
15
		</property>
16
		<property name="ttacCiphertext" type="string">
17
			<column name="T_TAC_CIPHERTEXT" length="64" />
18
		</property>
19
		<property name="ttacState" type="integer">
20
			<column name="T_TAC_STATE" precision="1" />
21
		</property>
22
		<property name="tdateGenerated" type="timestamp">
23
			<column name="T_DATE_GENERATED" />
24
		</property>
25
		<property name="tdateFirstUsed" type="timestamp">
26
			<column name="T_DATE_FIRST_USED" />
27
		</property>
28
		<property name="tdateLastUsed" type="timestamp">
29
			<column name="T_DATE_LAST_USED" />
30
		</property>
31
		<property name="tuseCount" type="integer">
32
			<column name="T_USE_COUNT" precision="6" />
33
		</property>
34
		<property name="terrorCount" type="integer">
35
			<column name="T_ERROR_COUNT" precision="2" />
36
		</property>
37
		<property name="tsessionId" type="string">
38
			<column name="T_SESSION_ID" length="32" />
39
		</property>
40
	
41
	</class>
42
</hibernate-mapping>
resources/my/com/upass/hibernate/TbAmUser.hbm.xml
1
<?xml version="1.0" encoding="UTF-8"?>
2
<!DOCTYPE hibernate-mapping PUBLIC "-//Hibernate/Hibernate Mapping DTD 3.0//EN" "http://hibernate.sourceforge.net/hibernate-mapping-3.0.dtd">
3

  
4
<hibernate-mapping>
5
	<class name="my.com.upass.pojo.UserBean" table="TB_AM_USER">
6
		<id name="userID" type="long">
7
			<column name="U_USER_ID" precision="9" />
8
			<generator class="assigned" />
9
		</id>
10

  
11
		<property name="userType" type="integer">
12
			<column name="U_USER_TYPE" precision="1" not-null="true" />
13
		</property>
14
		<property name="userAlias" type="string">
15
			<column name="U_USER_ALIAS" length="30" not-null="true" />
16
		</property>
17
		<property name="description" type="string">
18
			<column name="U_USER_DESC" length="40" />
19
		</property>
20
		<property name="udateCreated" type="timestamp">
21
			<column name="U_DATE_CREATED" not-null="true" />
22
		</property>
23
		<property name="udateLastUsed" type="timestamp">
24
			<column name="U_DATE_LAST_USED" />
25
		</property>
26
		<property name="uuseCount" type="integer">
27
			<column name="U_USE_COUNT" precision="6" not-null="true" />
28
		</property>
29
		<property name="udateLastActivated" type="timestamp">
30
			<column name="U_DATE_LAST_ACT" />
31
		</property>
32
		<property name="udateLastLocked" type="timestamp">
33
			<column name="U_DATE_LAST_LOCK" />
34
		</property>
35
		<property name="ustate" type="integer">
36
			<column name="U_USER_STATE" precision="1" not-null="true" />
37
		</property>
38
		<property name="udateLockedFrom" type="timestamp">
39
			<column name="U_DATE_LOCK_FROM" />
40
		</property>
41
		<property name="udateLockedTo" type="timestamp">
42
			<column name="U_DATE_LOCK_TO" />
43
		</property>
44
		<property name="pcipherText" type="string">
45
			<column name="P_PASSWD_CIPHERTEXT" length="64" />
46
		</property>
47
		<property name="pstate" type="integer">
48
			<column name="P_PASSWD_STATE" precision="1" not-null="true" />
49
		</property>
50
		<property name="pdateCreated" type="timestamp">
51
			<column name="P_DATE_GENERATED" not-null="true" />
52
		</property>
53
		<property name="pdateFirstUsed" type="timestamp">
54
			<column name="P_DATE_FIRST_USED" />
55
		</property>
56
		<property name="pdateLastUsed" type="timestamp">
57
			<column name="P_DATE_LAST_USED" />
58
		</property>
59
		<property name="puseCount" type="integer">
60
			<column name="P_USE_COUNT" precision="6" not-null="true" />
61
		</property>
62
		<property name="perrorCount" type="integer">
63
			<column name="P_ERROR_COUNT" precision="2" not-null="true" />
64
		</property>
65
		<property name="pexpiredStatus" type="integer">
66
			<column name="P_EXPIRED_STATUS" precision="1" not-null="true" />
67
		</property>
68
		<property name="pdateExpired" type="timestamp">
69
			<column name="P_DATE_EXPIRED" />
70
		</property>
71
		<property name="phistoryList" type="string">
72
			<column name="P_PASSWD_HIST" length="650" />
73
		</property>
74
<!-- 		<property name="ucustomerType" type="string"> -->
75
<!-- 			<column name="U_CUSTOMER_TYPE" length="10" /> -->
76
<!-- 		</property> -->
77
		<property name="applicationId" type="integer">
78
			<column name="U_APPLICATION_ID" precision="6" not-null="false" />
79
		</property>
80

  
81
		<one-to-one name="tacbean" class="my.com.upass.pojo.TacBean"
82
			fetch="join" cascade="save-update, delete"/>
83
		
84
		<many-to-one name="upassUserMaster" fetch="join" cascade="save-update, delete"
85
			class="my.com.upass.pojo.UserMasterBean" column="U_USER_ALIAS"
86
			insert="false" update="false" />
87
	
88
		<set name="upassUserTokens" fetch="join" cascade="save-update"
89
			inverse="true">
90
			<key column="V_USER_ID"></key>
91
			<one-to-many entity-name="vasco" class="my.com.upass.pojo.UserTokenBean"></one-to-many>
92
		</set>
93
	</class>
94
</hibernate-mapping>
95

  
resources/my/com/upass/hibernate/TbAmUserBackup.hbm.xml
1
<?xml version="1.0" encoding="UTF-8"?>
2
<!DOCTYPE hibernate-mapping PUBLIC "-//Hibernate/Hibernate Mapping DTD 3.0//EN" "http://hibernate.sourceforge.net/hibernate-mapping-3.0.dtd">
3

  
4
<hibernate-mapping>
5
	<class name="my.com.upass.pojo.UserBeanBackup" table="TB_AM_USER_BACKUP">
6
		<id name="oid" type="integer">
7
			<column name="OID" precision="18" />
8
			<generator class="native" />
9
		</id>
10
		<property name="userID" type="long">
11
			<column name="U_USER_ID" precision="9" />
12
		</property>
13
		<property name="userType" type="integer">
14
			<column name="U_USER_TYPE" precision="1" />
15
		</property>
16
		<property name="userAlias" type="string">
17
			<column name="U_USER_ALIAS" length="50" />
18
		</property>
19
		<property name="description" type="string">
20
			<column name="U_USER_DESC" length="40" />
21
		</property>
22
		<property name="udateCreated" type="timestamp">
23
			<column name="U_DATE_CREATED" />
24
		</property>
25
		<property name="udateLastUsed" type="timestamp">
26
			<column name="U_DATE_LAST_USED" />
27
		</property>
28
		<property name="uuseCount" type="integer">
29
			<column name="U_USE_COUNT" precision="6" />
30
		</property>
31
		<property name="udateLastActivated" type="timestamp">
32
			<column name="U_DATE_LAST_ACT" />
33
		</property>
34
		<property name="udateLastLocked" type="timestamp">
35
			<column name="U_DATE_LAST_LOCK" />
36
		</property>
37
		<property name="ustate" type="integer">
38
			<column name="U_USER_STATE" precision="1" />
39
		</property>
40
		<property name="udateLockedFrom" type="timestamp">
41
			<column name="U_DATE_LOCK_FROM" />
42
		</property>
43
		<property name="udateLockedTo" type="timestamp">
44
			<column name="U_DATE_LOCK_TO" />
45
		</property>
46
		<property name="pcipherText" type="string">
47
			<column name="P_PASSWD_CIPHERTEXT" length="64" />
48
		</property>
49
		<property name="pstate" type="integer">
50
			<column name="P_PASSWD_STATE" precision="1" />
51
		</property>
52
		<property name="pdateCreated" type="timestamp">
53
			<column name="P_DATE_GENERATED" />
54
		</property>
55
		<property name="pdateFirstUsed" type="timestamp">
56
			<column name="P_DATE_FIRST_USED" />
57
		</property>
58
		<property name="pdateLastUsed" type="timestamp">
59
			<column name="P_DATE_LAST_USED" />
60
		</property>
61
		<property name="puseCount" type="integer">
62
			<column name="P_USE_COUNT" precision="6"/>
63
		</property>
64
		<property name="perrorCount" type="integer">
65
			<column name="P_ERROR_COUNT" precision="2"/>
66
		</property>
67
		<property name="pexpiredStatus" type="integer">
68
			<column name="P_EXPIRED_STATUS" precision="1"/>
69
		</property>
70
		<property name="pdateExpired" type="timestamp">
71
			<column name="P_DATE_EXPIRED" />
72
		</property>
73
		<property name="phistoryList" type="string">
74
			<column name="P_PASSWD_HIST" length="650" />
75
		</property>
76
		<property name="applicationId" type="integer">
77
			<column name="U_APPLICATION_ID" precision="6"/>
78
		</property>
79

  
80
		<one-to-one name="tacbean" class="my.com.upass.pojo.TbAmTacBackup"
81
			fetch="join" cascade="save-update, delete"/>
82
		
83
		<many-to-one name="upassUserMasterBackup" fetch="join" cascade="save-update, delete"
84
			class="my.com.upass.pojo.UserMasterBeanBackup" column="U_USER_ALIAS"
85
			insert="false" update="false" />
86
	
87
	</class>
88
</hibernate-mapping>
89

  
resources/my/com/upass/hibernate/TbAmUsermas.hbm.xml
1
<?xml version="1.0" encoding="UTF-8"?>
2
<!DOCTYPE hibernate-mapping PUBLIC "-//Hibernate/Hibernate Mapping DTD 3.0//EN" "http://hibernate.sourceforge.net/hibernate-mapping-3.0.dtd">
3

  
4
<hibernate-mapping>
5
	<class name="my.com.upass.pojo.UserMasterBean" table="TB_AM_USERMAS">
6
		<id name="userAlias" type="string">
7
			<column name="M_USER_ALIAS" length="30" />
8
			<generator class="assigned" />
9
		</id>
10
		<property name="userID" type="long">
11
			<column name="M_USER_ID" precision="9" not-null="true" />
12
		</property>
13
	</class>
14
</hibernate-mapping>
15

  
resources/my/com/upass/hibernate/TbAmUsermasBackup.hbm.xml
1
<?xml version="1.0" encoding="UTF-8"?>
2
<!DOCTYPE hibernate-mapping PUBLIC "-//Hibernate/Hibernate Mapping DTD 3.0//EN" "http://hibernate.sourceforge.net/hibernate-mapping-3.0.dtd">
3

  
4
<hibernate-mapping>
5
	<class name="my.com.upass.pojo.UserMasterBeanBackup" table="TB_AM_USERMAS_BACKUP">
6
		<id name="userAlias" type="string">
7
			<column name="M_USER_ALIAS" length="50" />
8
			<generator class="assigned" />
9
		</id>
10
		<property name="userID" type="long">
11
			<column name="M_USER_ID" precision="9" />
12
		</property>
13
	</class>
14
</hibernate-mapping>
15

  
resources/my/com/upass/hibernate/TbAmVasco.hbm.xml
48 48
			<column name="V_USER_ID" precision="9" not-null="true" />
49 49
		</property>
50 50

  
51
		<many-to-one name="upassUser" class="my.com.upass.pojo.MinimalUserBean"
51
		<many-to-one name="upassUser" class="my.com.upass.pojo.UserBean"
52 52
			column="V_USER_ID" insert="false" update="false" fetch="join" />
53 53
	</class>
54 54
</hibernate-mapping>
resources/otpcore.xml
1
<otpcore-configuration>
2
	<session-factory name="otpcore">
3
		<!--proxool alias-->
4
		<property name="otpcore.proxool.pool_alias">agroib_db</property>
5
		<!--property name {proxool.properties}-->
6
		<property name="otpcore.proxool.properties">proxool.properties</property>
7
		<!--autocommit {true or false}-->
8
		<property name="otpcore.connection.autocommit">true</property>
9
		<!--isolation {1,2,3,4}-->
10
		<property name="otpcore.connection.isolation">2</property>
11
		<!--enable log {true or false}-->
12
		<property name="otpcore.log.enable">false</property>
13
		<!--log4j  properties {log4j.properties}-->
14
		<property name="otpcore.log4j.properties">log4j.xml</property>
15
		<!--cache count {1,2,3...500}-->
16
		<property name="otpcore.log.cache.count">1</property>
17
		<!--table prefix {ftotp_}-->
18
		<property name="otpcore.table.prefix">ftotp_</property>
19
		<!--user token}-->
20
		<property name="otpcore.user.token.type">-1</property>
21
	</session-factory>
22
</otpcore-configuration>
resources/proxool.dev-penril.properties
1
jdbc-0.proxool.alias=agroib_db
2

  
3
jdbc-0.proxool.driver-url=jdbc:jtds:sqlserver://10.6.6.21:1433/agroib_db
4
jdbc-0.proxool.driver-class=net.sourceforge.jtds.jdbc.Driver
5
jdbc-0.user=agroib_user
6
jdbc-0.password=P@$$w0rd
7

  
8
#jdbc-0.proxool.driver-url=jdbc:postgresql://localhost:5432/OTPDB
9
#jdbc-0.proxool.driver-class=org.postgresql.Driver
10
#jdbc-0.user=postgres
11
#jdbc-0.password=1234
12

  
13
#jdbc-0.proxool.driver-url=jdbc:mysql://192.168.16.33:3306/OTPDB
14
#jdbc-0.proxool.driver-class=com.mysql.jdbc.Driver
15
#jdbc-0.user=root
16
#jdbc-0.password=
17

  
18
#jdbc-0.proxool.driver-url= jdbc:oracle:thin:@127.0.0.1:1521:OTPDB
19
#jdbc-0.proxool.driver-class=oracle.jdbc.driver.OracleDriver
20
#jdbc-0.user=zengge3
21
#jdbc-0.password=zengge3
22

  
23
#jdbc-0.proxool.driver-url=jdbc:db2://127.0.0.1:50000/OTPDB
24
#jdbc-0.proxool.driver-class=com.ibm.db2.jcc.DB2Driver
25
#jdbc-0.user=topnethj
26
#jdbc-0.password=273122902
27

  
28
#jdbc-0.proxool.driver-url=jdbc:sybase:Tds:192.168.16.46:5000/OTPDB
29
#jdbc-0.proxool.driver-class=com.sybase.jdbc3.jdbc.SybDriver
30
#jdbc-0.user=otpdb
31
#jdbc-0.password=otpdb
32

  
33
#jdbc-0.proxool.verbose=true
34
#jdbc-0.proxool.house-keeping-sleep-time=10000
35

  
36
#max connection
37
jdbc-0.proxool.maximum-connection-count=8
38
#min connection
39
jdbc-0.proxool.minimum-connection-count=2
40
#init connection
41
jdbc-0.proxool.minimum-prototype-count=2
42

  
43
#Failing that an idle connection can be allocated in the queue waiting for the maximum number of requests, 
44
#more than the number of user connections this request will not be accepted
45

  
46
#jdbc-0.proxool.maximum-new-connections=20
47

  
48

  
49
#proxool automatically detect connection state at all time intervals (ms), 
50
#detected idle connection is immediately recovered, the destruction of overtime
51

  
52
jdbc-0.proxool.house-keeping-sleep-time=40000
53

  
54
#jdbc-0.proxool.house-keeping-test-sql=select CURRENT_DATE
55

  
56
#If the housekeeper to detect the activities of a thread longer than this value. It will kill this thread. 
57
#So sure about your server bandwidth. 
58
#And then set an appropriate value. The default is 5 minutes.
59

  
60
jdbc-0.proxool.maximum-active-time=300000
61

  
62
#Do not write the log
63

  
64
jdbc-0.proxool.trace=false
65

  
66
#Before using the connection is used to specify whether you want to test
67

  
68
#jdbc-0.proxool.testBeforeUse=false
69

  
resources/proxool.properties
1
jdbc-0.proxool.alias=agroib_db
2

  
3
jdbc-0.proxool.driver-url=jdbc:jtds:sqlserver://10.6.6.21:1433/agroib_db
4
jdbc-0.proxool.driver-class=net.sourceforge.jtds.jdbc.Driver
5
jdbc-0.user=agroib_user
6
jdbc-0.password=P@$$w0rd
7

  
8
#jdbc-0.proxool.driver-url=jdbc:postgresql://localhost:5432/OTPDB
9
#jdbc-0.proxool.driver-class=org.postgresql.Driver
10
#jdbc-0.user=postgres
11
#jdbc-0.password=1234
12

  
13
#jdbc-0.proxool.driver-url=jdbc:mysql://192.168.16.33:3306/OTPDB
14
#jdbc-0.proxool.driver-class=com.mysql.jdbc.Driver
15
#jdbc-0.user=root
16
#jdbc-0.password=
17

  
18
#jdbc-0.proxool.driver-url= jdbc:oracle:thin:@127.0.0.1:1521:OTPDB
19
#jdbc-0.proxool.driver-class=oracle.jdbc.driver.OracleDriver
20
#jdbc-0.user=zengge3
21
#jdbc-0.password=zengge3
22

  
23
#jdbc-0.proxool.driver-url=jdbc:db2://127.0.0.1:50000/OTPDB
24
#jdbc-0.proxool.driver-class=com.ibm.db2.jcc.DB2Driver
25
#jdbc-0.user=topnethj
26
#jdbc-0.password=273122902
27

  
28
#jdbc-0.proxool.driver-url=jdbc:sybase:Tds:192.168.16.46:5000/OTPDB
29
#jdbc-0.proxool.driver-class=com.sybase.jdbc3.jdbc.SybDriver
30
#jdbc-0.user=otpdb
31
#jdbc-0.password=otpdb
32

  
33
#jdbc-0.proxool.verbose=true
34
#jdbc-0.proxool.house-keeping-sleep-time=10000
35

  
36
#max connection
37
jdbc-0.proxool.maximum-connection-count=8
38
#min connection
39
jdbc-0.proxool.minimum-connection-count=2
40
#init connection
41
jdbc-0.proxool.minimum-prototype-count=2
42

  
43
#Failing that an idle connection can be allocated in the queue waiting for the maximum number of requests, 
44
#more than the number of user connections this request will not be accepted
45

  
46
#jdbc-0.proxool.maximum-new-connections=20
47

  
48

  
49
#proxool automatically detect connection state at all time intervals (ms), 
50
#detected idle connection is immediately recovered, the destruction of overtime
51

  
52
jdbc-0.proxool.house-keeping-sleep-time=40000
53

  
54
#jdbc-0.proxool.house-keeping-test-sql=select CURRENT_DATE
55

  
56
#If the housekeeper to detect the activities of a thread longer than this value. It will kill this thread. 
57
#So sure about your server bandwidth. 
58
#And then set an appropriate value. The default is 5 minutes.
59

  
60
jdbc-0.proxool.maximum-active-time=300000
61

  
62
#Do not write the log
63

  
64
jdbc-0.proxool.trace=false
65

  
66
#Before using the connection is used to specify whether you want to test
67

  
68
#jdbc-0.proxool.testBeforeUse=false
69

  
resources/proxool.staging-ci.properties
1
jdbc-0.proxool.alias=agroib_db
2

  
3
#jdbc-0.proxool.driver-url=jdbc:jtds:sqlserver://192.168.56.2:1433/agro-ci-db
4
jdbc-0.proxool.driver-url=jdbc:jtds:sqlserver://demosvr1.penril.net:1433/agro-ci-db
5
jdbc-0.proxool.driver-class=net.sourceforge.jtds.jdbc.Driver
6
jdbc-0.user=agro-ci-user
7
jdbc-0.password=ci-123
8

  
9
#jdbc-0.proxool.driver-url=jdbc:postgresql://localhost:5432/OTPDB
10
#jdbc-0.proxool.driver-class=org.postgresql.Driver
11
#jdbc-0.user=postgres
12
#jdbc-0.password=1234
13

  
14
#jdbc-0.proxool.driver-url=jdbc:mysql://192.168.16.33:3306/OTPDB
15
#jdbc-0.proxool.driver-class=com.mysql.jdbc.Driver
16
#jdbc-0.user=root
17
#jdbc-0.password=
18

  
19
#jdbc-0.proxool.driver-url= jdbc:oracle:thin:@127.0.0.1:1521:OTPDB
20
#jdbc-0.proxool.driver-class=oracle.jdbc.driver.OracleDriver
21
#jdbc-0.user=zengge3
22
#jdbc-0.password=zengge3
23

  
24
#jdbc-0.proxool.driver-url=jdbc:db2://127.0.0.1:50000/OTPDB
25
#jdbc-0.proxool.driver-class=com.ibm.db2.jcc.DB2Driver
26
#jdbc-0.user=topnethj
27
#jdbc-0.password=273122902
28

  
29
#jdbc-0.proxool.driver-url=jdbc:sybase:Tds:192.168.16.46:5000/OTPDB
30
#jdbc-0.proxool.driver-class=com.sybase.jdbc3.jdbc.SybDriver
31
#jdbc-0.user=otpdb
32
#jdbc-0.password=otpdb
33

  
34
#jdbc-0.proxool.verbose=true
35
#jdbc-0.proxool.house-keeping-sleep-time=10000
36

  
37
#max connection
38
jdbc-0.proxool.maximum-connection-count=8
39
#min connection
40
jdbc-0.proxool.minimum-connection-count=2
41
#init connection
42
jdbc-0.proxool.minimum-prototype-count=2
43

  
44
#Failing that an idle connection can be allocated in the queue waiting for the maximum number of requests, 
45
#more than the number of user connections this request will not be accepted
46

  
47
#jdbc-0.proxool.maximum-new-connections=20
48

  
49

  
50
#proxool automatically detect connection state at all time intervals (ms), 
51
#detected idle connection is immediately recovered, the destruction of overtime
52

  
53
jdbc-0.proxool.house-keeping-sleep-time=40000
54

  
55
#jdbc-0.proxool.house-keeping-test-sql=select CURRENT_DATE
56

  
57
#If the housekeeper to detect the activities of a thread longer than this value. It will kill this thread. 
58
#So sure about your server bandwidth. 
59
#And then set an appropriate value. The default is 5 minutes.
60

  
61
jdbc-0.proxool.maximum-active-time=300000
62

  
63
#Do not write the log
64

  
65
jdbc-0.proxool.trace=false
66

  
67
#Before using the connection is used to specify whether you want to test
68

  
69
#jdbc-0.proxool.testBeforeUse=false
70

  
resources/upass.cfg
1
# Flag to get parameters from Database
2
DB_USE_SETTING=1
src/my/com/upass/Config.java
1

  
2
package my.com.upass;
3

  
4
import java.io.FileInputStream;
5
import java.net.URL;
6
import java.net.URLDecoder;
7
import java.util.Properties;
8

  
9
import org.apache.log4j.Logger;
10

  
11
public class Config
12
{
13
	private static final Logger		logger		= Logger.getLogger (Config.class);
14
	private static final Properties	props		= new Properties ();
15
	private static Config			instance	= null;
16
	private static String			CONFIG		= "upass.cfg";
17

  
18
	public Config ()
19
	{
20
		try
21
		{
22
			// Load config file from classes directory
23
			URL url = this.getClass ().getClassLoader ().getResource (CONFIG); 
24
			String processedUrl = URLDecoder.decode (url.getFile (), "UTF-8");
25
			FileInputStream in = new FileInputStream (processedUrl);
26
			props.load (in);
27

  
28
			in.close ();
29
		}
30
		catch (Exception e)
31
		{
32
			logger.error ("Exception(1) " + getClass ().getName () + ":" + e.getMessage ());
33
		}
34
	}
35

  
36
	public void setConfig (String configFile)
37
	{
38
		CONFIG = configFile;
39
	}
40

  
41
	public void initInstance ()
42
	{
43
		if (instance == null)
44
		{
45
			instance = new Config ();
46
		}
47
		return;
48
	}
49

  
50
	public static Config getInstance ()
51
	{
52
		if (instance == null)
53
		{
54
			instance = new Config ();
55
		}
56
		return instance;
57
	}
58

  
59
	public Properties getConfig ()
60
	{
61
		return props;
62
	}
63

  
64
}
src/my/com/upass/ConfigBean.java
1
/**
2
 * Copyright (c) 2012 Penril Datability (M) Sdn Bhd All rights reserved.
3
 *
4
 * This software is copyrighted. Under the copyright laws, this software
5
 * may not be copied, in whole or in part, without prior written consent
6
 * of Penril Datability (MS) Sdn Bhd or its assignees. This software is
7
 * provided under the terms of a license between Penril Datability (M)
8
 * Sdn Bhd and the recipient, and its use is subject to the terms of that
9
 * license.
10
 */
11

  
12
package my.com.upass;
13

  
14
/**
15
 * @author penril
16
 *
17
 */
18
public class ConfigBean {
19
	//password controller
20
	int passwordMaxTryError = 3; //maximum allowable password error encountered per user
21
	int passwordMaxReuse = 6; //number of password non repeatable 
22
	int passwordExpiry = 0; //zero mean never expire, value is in number of day
23
	String passwordValidPattern = "(?=.*[a-z])(?=.*[A-Z])(?=.*[!@#$%^&*()_+<>?]).{8,}";
24
	String userNameValidPattern = "^[a-zA-Z0-9_-]{6,16}$";
25
	int userDormantPeriod = 0; //zero mean never dormant, value is in number of days
26
	int passwordMinLength = 0;
27
	int notifAlert = 0;
28
	int changePasswordInterval = 0;
29
	String passwordAcceptPattern= "^[a-zA-Z0-9!@#$%^&*()_+<>?]{0,}$";
30
	int autoLogoff = 0;
31
	int userDeactivatePeriod = 0;
32
	int singleSingon = 0;
33
	int passwordComplexity= 0;
34
	int passwordComplexityLowerAlpha = 0;
35
	int passwordComplexityNumeric = 0;
36
	int passwordComplexitySymbol=0;
37
	int passwordComplexityUpperAlpha=0;
38
	
39
	
40
	static String PASSWORD_MAX_ERROR = "PASSWORD_MAX_ERROR";
41
	static String PASSWORD_GENERATION = "PASSWORD_GENERATION";
42
	static String PASSWORD_EXPIRY_DAY = "PASSWORD_EXPIRY_DAY";
43
	static String PASSWORD_PATTERN = "PASSWORD_PATTERN";
44
	static String USERNAME_PATTERN = "USERNAME_PATTERN";
45
	static String USER_DORMANT_PERIOD = "USER_DORMANT_PERIOD";
46
	static String PASSWORD_MIN_LENGTH="PASSWORD_MIN_LENGTH";
47
	static String NOTIF_ALERT = "NOTIF_ALERT";
48
	static String CHANGE_PASSWORD_INTERVAL="CHANGE_PASSWORD_INTERVAL";
49
	static String PASSWORD_ACCEPT_PATTERN = "PASSWORD_ACCEPT_PATTERN";
50
	static String PASSWORD_COMPLEXITY = "PASSWORD_COMPLEXITY";
51
	static String PASSWORD_COMPLEXITY_LOWER_ALPHA = "PASSWORD_COMPLEXITY_LOWER_ALPHA";
52
	static String PASSWORD_COMPLEXITY_NUMERIC="PASSWORD_COMPLEXITY_NUMERIC";
53
	static String PASSWORD_COMPLEXITY_SYMBOL="PASSWORD_COMPLEXITY_SYMBOL";
54
	static String PASSWORD_COMPLEXITY_UPPER_ALPHA="PASSWORD_COMPLEXITY_UPPER_ALPHA";
55
	static String AUTO_LOGOFF = "AUTO_LOGOFF";
56
	static String USER_DEACTIVATE_PERIOD = "USER_DEACTIVATE_PERIOD";
57
	static String SINGLE_SIGNON = "SINGLE_SIGNON";
58
	
59

  
60
	//TAC Controller
61
	int TACMaxTryError = 3;
62
	int TACMaxUse = 3;
63
	int TACTTimeOut = 60000; //in minutes
64
	int TACRepeatTimeOut = 180; //in minutes
65
	int TACLifeSpanTimeOut = 3600; //in minutes
66
	
67
	static String TAC_TIME_OUT = "TAC_DEFAULT_TIMEOUT";
68
	static String TAC_MAX_ERROR = "TAC_MAX_ERROR";
69
	static String TAC_MAX_USE = "TAC_MAX_USE";
70
	static String TAC_LIFTSPAN_TIMEOUT = "TAC_LIFTSPAN_TIMEOUT";
71
	static String TAC_REPEAT_TIMEOUT = "TAC_REPEAT_TIMEOUT";
72
	
73
	private int SCTimeOut;
74
	private int SCMaxError;
75
	private int SCMaxUse;
76
	private int SCLifeSpanTimeOut;
77
	private int SCRepeatTimeOut;
78
	
79
	static String SC_TIME_OUT = "SC_TIME_OUT";
80
	static String SC_MAX_ERROR = "SC_MAX_ERROR";
81
	static String SC_MAX_USE = "SC_MAX_USE";
82
	static String SC_LIFTSPAN_TIMEOUT = "SC_LIFTSPAN_TIMEOUT";
83
	static String SC_REPEAT_TIMEOUT = "SC_REPEAT_TIMEOUT";
84
	
85
	public void setConfigBean(String paramName, String paramValue)
86
	{
87
		if (PASSWORD_MAX_ERROR.equalsIgnoreCase(paramName)) {
88
			this.setPasswordMaxTryError(Integer.valueOf(paramValue));
89
		} 
90
		else if (PASSWORD_GENERATION.equalsIgnoreCase(paramName)) {
91
			this.setPasswordMaxReuse(Integer.valueOf(paramValue));
92
		} 
93
		else if (PASSWORD_EXPIRY_DAY.equalsIgnoreCase(paramName)) {
94
			this.setPasswordExpiry(Integer.valueOf(paramValue));
95
		} 
96
		else if (PASSWORD_PATTERN.equalsIgnoreCase(paramName)) {
97
			this.setPasswordValidPattern(paramValue);
98
		} 
99
		else if (USERNAME_PATTERN.equalsIgnoreCase(paramName)) {
100
			this.setUserNameValidPattern(paramValue);
101
		}  
102
		else if (USER_DORMANT_PERIOD.equalsIgnoreCase(paramName)) {
103
			this.setUserDormantPeriod(Integer.valueOf(paramValue));
104
		} 
105
		else if (PASSWORD_MIN_LENGTH.equalsIgnoreCase(paramName)) {
106
			this.setPasswordMinLength(Integer.valueOf(paramValue));
107
		} 
108
		else if (NOTIF_ALERT.equalsIgnoreCase(paramName)){
109
			this.setNotifAlert(Integer.valueOf(paramValue));
110
		} 
111
		else if (CHANGE_PASSWORD_INTERVAL.equalsIgnoreCase(paramName)){
112
			this.setChangePasswordInterval(Integer.valueOf(paramValue));
113
		} 
114
		else if (PASSWORD_ACCEPT_PATTERN.equalsIgnoreCase(paramName)){
115
			this.setPasswordAcceptPattern(paramValue);
116
		} 
117
		else if (PASSWORD_COMPLEXITY.equalsIgnoreCase(paramName)){
118
			this.setPasswordComplexity(Integer.valueOf(paramValue));
119
		}
120
		else if (PASSWORD_COMPLEXITY_LOWER_ALPHA.equalsIgnoreCase(paramName)){
121
			this.setPasswordComplexityLowerAlpha(Integer.valueOf(paramValue));
122
		}
123
		else if (PASSWORD_COMPLEXITY_NUMERIC.equalsIgnoreCase(paramName)){
124
			this.setPasswordComplexityNumeric(Integer.valueOf(paramValue));
125
		}
126
		else if (PASSWORD_COMPLEXITY_SYMBOL.equalsIgnoreCase(paramName)){
127
			this.setPasswordComplexitySymbol(Integer.valueOf(paramValue));
128
		}
129
		else if (PASSWORD_COMPLEXITY_UPPER_ALPHA.equalsIgnoreCase(paramName)){
130
			this.setPasswordComplexityUpperAlpha(Integer.valueOf(paramValue));
131
		}
132
		else if (AUTO_LOGOFF.equalsIgnoreCase(paramName)){
133
			this.setAutoLogoff(Integer.valueOf(paramValue));
134
		} 
135
		else if (USER_DEACTIVATE_PERIOD.equalsIgnoreCase(paramName)){
136
			this.setUserDeactivatePeriod(Integer.valueOf(paramValue));
137
		}
138
		else if (SINGLE_SIGNON.equalsIgnoreCase(paramName)){
139
			this.setSingleSingon(Integer.valueOf(paramValue));
140
		}
141
		
142
		else if (TAC_TIME_OUT.equalsIgnoreCase(paramName)) {
143
			this.setTACTTimeOut (Integer.valueOf(paramValue));
144
		}  
145
		else if (TAC_MAX_ERROR.equalsIgnoreCase(paramName)) {
146
			this.setTACMaxTryError (Integer.valueOf(paramValue));
147
		}  
148
		else if (TAC_MAX_USE.equalsIgnoreCase(paramName)) {
149
			this.setTACMaxUse (Integer.valueOf(paramValue));
150
		}  
151
		else if (TAC_LIFTSPAN_TIMEOUT.equalsIgnoreCase(paramName)) {
152
			this.setTACLifeSpanTimeOut (Integer.valueOf(paramValue));
153
		}
154
		else if (TAC_REPEAT_TIMEOUT.equalsIgnoreCase(paramName)) {
155
			this.setTACRepeatTimeOut (Integer.valueOf(paramValue));
156
		}
157
		
158
		else if (SC_TIME_OUT.equalsIgnoreCase(paramName)) {
159
			this.setSCTimeOut (Integer.valueOf(paramValue));
160
		} 
161
		else if (SC_MAX_ERROR.equalsIgnoreCase(paramName)) {
162
			this.setSCMaxError (Integer.valueOf(paramValue));
163
		}  
164
		else if (SC_MAX_USE.equalsIgnoreCase(paramName)) {
165
			this.setSCMaxUse (Integer.valueOf(paramValue));
166
		}  
167
		else if (SC_LIFTSPAN_TIMEOUT.equalsIgnoreCase(paramName)) {
168
			this.setSCLifeSpanTimeOut (Integer.valueOf(paramValue));
169
		}
170
		else if (SC_REPEAT_TIMEOUT.equalsIgnoreCase(paramName)) {
171
			this.setSCRepeatTimeOut (Integer.valueOf(paramValue));
172
		}
173
	}
174
	
175

  
176

  
177
	/*======================getter setter for TAC Controller=======================*/
178
	public int getTACMaxTryError() {
179
		return TACMaxTryError;
180
	}
181

  
182
	/**
183
	 * @param tACMaxTryError the tACMaxTryError to set
184
	 */
185
	public void setTACMaxTryError(int tACMaxTryError) {
186
		TACMaxTryError = tACMaxTryError;
187
	}
188

  
189
	public int getTACMaxUse() {
190
		return TACMaxUse;
191
	}
192

  
193
	/**
... This diff was truncated because it exceeds the maximum size that can be displayed.

Also available in: Unified diff