Index: ssts-web/src/main/resources/jdbc.properties =================================================================== diff -u -r22051 -r22058 --- ssts-web/src/main/resources/jdbc.properties (.../jdbc.properties) (revision 22051) +++ ssts-web/src/main/resources/jdbc.properties (.../jdbc.properties) (revision 22058) @@ -1,23 +1,120 @@ -loggerLevel=ERROR -target=../logs/SterileSupplySystem.log -log4j.rootLogger=WARN, CON, FILE +# Targeted at system administrators, to avoid touching the context XML files. -log4j.appender.CON=org.apache.log4j.ConsoleAppender -log4j.appender.CON.layout=org.apache.log4j.PatternLayout -log4j.appender.CON.layout.ConversionPattern=%d %-5p %c - %m%n +hibernate.hbm2ddl.auto=update +hibernate.show_sql=true -log4j.appender.FILE=org.apache.log4j.RollingFileAppender -log4j.appender.FILE.File=${target} -log4j.appender.FILE.layout=org.apache.log4j.PatternLayout -log4j.appender.FILE.layout.ConversionPattern=%d %-5p %c - %m%n -log4j.appender.FILE.MaxFileSize=100MB -log4j.appender.FILE.MaxBackupIndex=20 +#project=zsxlrmyy +#project=gdsy +#project=fsfy +#project=cdlqyq1yy +#project=gyey +#project=gzzyyfs +#project=gyey +#project=zd5y +#project=sznsfy +#project=dgjszx +#project=gd2zyy +#project=gxzyyf1 +#project=zsykzx +#project=cszxyy +#project=zsly +#project=gzfdzl +#project=gzs12rmyy +#project=zsszyy +#project=zjyy +#project=gzspyqzyy +#project=dgsdhyy +#project=dgszyy +#project=jmrmyy +#project=dysyy +#project=zsyy +#project=hdqrmyy +#project=ljsrmyy +#project=hzszxrmyy +#project=demo +project=qifuyy -log4j.logger.com.forgon=DEBUG -log4j.logger.test.forgon=DEBUG -log4j.logger.org.hibernate=WARN -log4j.logger.org.springframework=${loggerLevel} -log4j.logger.org.springside=${loggerLevel} -log4j.logger.org.jbpm=${loggerLevel} -log4j.logger.net.sf=${loggerLevel} -log4j.logger.org.apache=${loggerLevel} \ No newline at end of file +#database=sqlserver +#hibernate.dialect=org.hibernate.dialect.SQLServerDialect +#jdbc.driverClassName=com.microsoft.sqlserver.jdbc.SQLServerDriver +##jdbc.url=jdbc:sqlserver://192.168.2.19:1433;databaseName=zsdxfsdyyySterile +##jdbc.url=jdbc:sqlserver://192.168.2.19:1433;databaseName=cdlqyq1yy +##jdbc.url=jdbc:sqlserver://localhost:1433;databaseName=gdsy +##jdbc.url=jdbc:sqlserver://localhost:1433;databaseName=dgzyytmzs +#jdbc.url=jdbc:sqlserver://192.168.2.19:1433;databaseName=unittest +###user name: unittest, password: p2ssword +# +#jdbc.username=c2E= +#jdbc.password=Rm9yZ29uMTIzNA== +##Rm9yZ29uMTIzNA== + +#Oralce +database=oracle +hibernate.dialect=org.hibernate.dialect.Oracle10gDialect +jdbc.driverClassName=oracle.jdbc.OracleDriver +jdbc.url=jdbc:oracle:thin:@//localhost:1521/ORCL +#fsfy +jdbc.username=ZnNmeQ== +jdbc.password=ZnNmeQ== + +#Oralce +#database=oracle +#hibernate.dialect=org.hibernate.dialect.Oracle10gDialect +#jdbc.driverClassName=oracle.jdbc.OracleDriver +#jdbc.url=jdbc:oracle:thin:@//localhost:1521/ORCL +##ljsrmyy +#jdbc.username=bGpzcm15eQ== +#jdbc.password=bGpzcm15eQ== + +#Oralce +#database=oracle +#hibernate.dialect=org.hibernate.dialect.Oracle10gDialect +#jdbc.driverClassName=oracle.jdbc.OracleDriver +#jdbc.url=jdbc:oracle:thin:@//localhost:1521/ORCL +##pyqzyy +#jdbc.username=cHlxenl5 +#jdbc.password=cHlxenl5 + +#Oralce +#database=oracle +#hibernate.dialect=org.hibernate.dialect.Oracle10gDialect +#jdbc.driverClassName=oracle.jdbc.OracleDriver +#jdbc.url=jdbc:oracle:thin:@//localhost:1521/ORCL +##zyyfs +#jdbc.username=enl5ZnM= +#jdbc.password=enl5ZnM= + +#Oralce +#database=oracle +#hibernate.dialect=org.hibernate.dialect.Oracle10gDialect +#jdbc.driverClassName=oracle.jdbc.OracleDriver +#jdbc.url=jdbc:oracle:thin:@//localhost:1521/ORCL +##zsykzx +#jdbc.username=enN5a3p4 +#jdbc.password=enN5a3p4 + +#Oracle +#database=oracle +#hibernate.dialect=org.hibernate.dialect.Oracle10gDialect +#jdbc.driverClassName=oracle.jdbc.OracleDriver +#jdbc.url=jdbc:oracle:thin:@//localhost:1521/ORCL +##ttt +#jdbc.username=dHR0 +#jdbc.password=dHR0 + +#MySQL +#database=mysql +#hibernate.dialect=org.hibernate.dialect.MySQL5Dialect +#jdbc.driverClassName=com.mysql.jdbc.Driver +#jdbc.url=jdbc:mysql://localhost:3306/oa +#jdbc.username=dW5pdHRlc3Q= +#jdbc.password=dW5pdHRlc3Q= + +#Production System PATH ---only for zsly +path.hibernate.dialect=org.hibernate.dialect.SQLServerDialect +path.driverClassName=com.microsoft.sqlserver.jdbc.SQLServerDriver +path.url=jdbc:sqlserver://192.168.17.22:1433;databaseName=HERP_PATH +#sm c20= +path.username=c20= +#sm@123 c21AMTIz +path.password=c21AMTIz