API tools faq
paste
Advertisement
Guest User

Untitled

a guest
Oct 7th, 2016
106
0
Never
Add comment
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 13.84 KB | None | 0 0
raw download clone embed print report
  1. server.port=10000
  2. spring.jpa.hibernate.naming.physical-strategy=org.hibernate.boot.model.naming.PhysicalNamingStrategyStandardImpl
  3. spring.jpa.databasePlatform=org.hibernate.dialect.SybaseDialect
  4.  
  5.  
  6. # SQL dialect for generating optimized queries
  7. spring.jpa.hibernate.ddl-auto=none
  8. spring.jpa.database=SYBASE
  9. spring.jpa.show-sql=true
  10.  
  11. # hikariCP
  12.  
  13. spring.datasource.dataSourceClassName=com.sybase.jdbc4.jdbc.SybDataSource
  14. spring.datasource.type=com.zaxxer.hikari.HikariDataSource
  15. spring.datasource.connectionTestQuery=SELECT 1
  16. spring.datasource.username=dev
  17. spring.datasource.password=developer
  18. spring.datasource.databaseName=test
  19. spring.datasource.serverName=localhost
  20. spring.datasource.portNumber=5000
  21.  
  22. import javax.persistence.Column;
  23. import javax.persistence.Entity;
  24. import javax.persistence.Id;
  25. import javax.persistence.Table;
  26.  
  27. @Entity
  28. @Table(name = "wallettest")
  29. public class wallet {
  30.  
  31. @Id
  32. @Column(name = "orderId")
  33. private long id;
  34.  
  35. @Column(name = "orderInternalId")
  36. private int orderInternalId;
  37.  
  38. @Column(name = "orderStatus")
  39. private int orderStatus;
  40.  
  41. public long getId() {
  42. return id;
  43. }
  44.  
  45. public void setId(long id) {
  46. this.id = id;
  47. }
  48.  
  49. public int getOrderInternalId() {
  50. return orderInternalId;
  51. }
  52.  
  53. public void setOrderInternalId(int orderInternalId) {
  54. this.orderInternalId = orderInternalId;
  55. }
  56.  
  57. public int getOrderStatus() {
  58. return orderStatus;
  59. }
  60.  
  61. public void setOrderStatus(int orderStatus) {
  62. this.orderStatus = orderStatus;
  63. }
  64.  
  65. }
  66.  
  67. import org.springframework.data.jpa.repository.Modifying;
  68. import org.springframework.data.jpa.repository.Query;
  69. import org.springframework.data.repository.CrudRepository;
  70. import org.springframework.data.repository.query.Param;
  71. import org.springframework.stereotype.Component;
  72. import org.springframework.stereotype.Repository;
  73. import org.springframework.transaction.annotation.Transactional;
  74.  
  75. @Repository
  76. @Component
  77. @Transactional
  78. // Logically No need @Transactional if there is only one table involved
  79. public interface WalletRepository extends CrudRepository<wallet, Long> {
  80. @Modifying
  81. @Query(value = "UPDATE wallet SET orderStatus = :orderStatus WHERE id = :orderId AND orderInternalId= :orderInternalId")
  82. public int updateWalletStatus(@Param("orderId") long orderId, @Param("orderInternalId") int orderInternalId,
  83. @Param("orderStatus") int orderStatus);
  84. }
  85.  
  86. import java.util.ArrayList;
  87. import java.util.List;
  88.  
  89. import org.springframework.beans.factory.annotation.Autowired;
  90. import org.springframework.stereotype.Component;
  91.  
  92.  
  93. @Component("WalletUpdatorServiceImpl")
  94. public class WalletUpdatorServiceImpl implements WalletUpdatorService {
  95.  
  96. private WalletRepository walletRepository;
  97.  
  98. private WalletItemTransformer walletItemTransformer;
  99.  
  100. private ExtendedLogger logger = ExtendedLogger.create(WalletUpdatorServiceImpl.class);
  101.  
  102. List<OrderUpdateItem> walletUpdateItemsSucceded = null;
  103. List<OrderUpdateItem> walletUpdateItemsFailed = null;
  104.  
  105. @Autowired
  106. public WalletUpdatorServiceImpl(WalletRepository walletRepository, WalletItemTransformer walletItemTransformer) {
  107. this.walletRepository = walletRepository;
  108. this.walletItemTransformer = walletItemTransformer;
  109. }
  110.  
  111. @Override
  112. public List<OrderUpdateItem> updateWalletStatus(List<OrderUpdateItem> orderUpdateItems) {
  113. walletUpdateItemsSucceded = new ArrayList<OrderUpdateItem>();
  114. walletUpdateItemsFailed = new ArrayList<OrderUpdateItem>();
  115.  
  116. for (OrderUpdateItem orderUpdateItem : orderUpdateItems) {
  117. wallet wallet = walletItemTransformer.transformToOrder(orderUpdateItem);
  118.  
  119. System.out.println("^^^^^^^^^^^^^^^^^^^^^^^^^^");
  120. System.out.println("wallet id:" + wallet.getId());
  121. System.out.println("wallet id:" + wallet.getOrderInternalId());
  122. System.out.println("wallet status:" + wallet.getOrderStatus());
  123. System.out.println("^^^^^^^^^^^^^^^^^^^^^^^^^^");
  124.  
  125. int count = walletRepository.updateWalletStatus(wallet.getId(), wallet.getOrderInternalId(),
  126. wallet.getOrderStatus());
  127.  
  128. if (count == 1) {
  129. logger.audit("%%%%%%%%%%%% SUCCESS %%%%%%%%%%%%%%%%%%%%");
  130. logger.audit(wallet);
  131. logger.audit("%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%");
  132. walletUpdateItemsSucceded.add(orderUpdateItem);
  133. } else {
  134. logger.audit("@@@@@@@@@@@@@@@@@@ FAILED @@@@@@@@@@@@@@@@@@@@@2");
  135. logger.audit(wallet);
  136. logger.audit("@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@2");
  137. walletUpdateItemsFailed.add(orderUpdateItem);
  138. }
  139.  
  140. }
  141.  
  142. return walletUpdateItemsSucceded;
  143.  
  144. }
  145.  
  146. public WalletRepository getWalletRepository() {
  147. return walletRepository;
  148. }
  149.  
  150. public void setWalletRepository(WalletRepository walletRepository) {
  151. this.walletRepository = walletRepository;
  152. }
  153.  
  154. public WalletItemTransformer getWalletItemTransformer() {
  155. return walletItemTransformer;
  156. }
  157.  
  158. public void setWalletItemTransformer(WalletItemTransformer walletItemTransformer) {
  159. this.walletItemTransformer = walletItemTransformer;
  160. }
  161.  
  162. public ExtendedLogger getLogger() {
  163. return logger;
  164. }
  165.  
  166. public void setLogger(ExtendedLogger logger) {
  167. this.logger = logger;
  168. }
  169.  
  170. }
  171.  
  172. 2016-10-07 20:57:28 [localhost-startStop-1] INFO FilterRegistrationBean:258 - Mapping filter: 'requestContextFilter' to: [/*]
  173. 2016-10-07 20:57:28 [main] INFO LocalContainerEntityManagerFactoryBean:349 - Building JPA container EntityManagerFactory for persistence unit 'default'
  174. 2016-10-07 20:57:28 [main] INFO LogHelper:31 - HHH000204: Processing PersistenceUnitInfo [
  175. name: default
  176. ...]
  177. 2016-10-07 20:57:28 [main] INFO Version:37 - HHH000412: Hibernate Core {5.0.11.Final}
  178. 2016-10-07 20:57:28 [main] INFO Environment:213 - HHH000206: hibernate.properties not found
  179. 2016-10-07 20:57:28 [main] INFO Environment:317 - HHH000021: Bytecode provider name : javassist
  180. 2016-10-07 20:57:28 [main] INFO Version:66 - HCANN000001: Hibernate Commons Annotations {5.0.1.Final}
  181. 2016-10-07 20:57:29 [main] INFO HikariDataSource:93 - HikariPool-1 - Started.
  182. 2016-10-07 20:57:29 [main] INFO Dialect:156 - HHH000400: Using dialect: org.hibernate.dialect.SybaseDialect
  183. 2016-10-07 20:57:29 [main] INFO LocalContainerEntityManagerFactoryBean:382 - Initialized JPA EntityManagerFactory for persistence unit 'default'
  184. 2016-10-07 20:57:30 [main] INFO QueryTranslatorFactoryInitiator:47 - HHH000397: Using ASTQueryTranslatorFactory
  185. 2016-10-07 20:57:30 [main] INFO OrderUpdateEndpoint:25 - Endpoint loaded
  186. 2016-10-07 20:57:31 [main] INFO RequestMappingHandlerAdapter:534 - Looking for @ControllerAdvice: org.springframework.boot.context.embedded.AnnotationConfigEmbeddedWebApplicationContext@519753fd: startup date [Fri Oct 07 20:57:24
  187. IST 2016]; root of context hierarchy
  188. 2016-10-07 20:57:31 [main] INFO RequestMappingHandlerMapping:543 - Mapped "{[/error]}" onto public org.springframework.http.ResponseEntity<java.util.Map<java.lang.String, java.lang.Object>> org.springframework.boot.autoconfigure.
  189. web.BasicErrorController.error(javax.servlet.http.HttpServletRequest)
  190. 2016-10-07 20:57:31 [main] INFO RequestMappingHandlerMapping:543 - Mapped "{[/error],produces=[text/html]}" onto public org.springframework.web.servlet.ModelAndView org.springframework.boot.autoconfigure.web.BasicErrorController.
  191. errorHtml(javax.servlet.http.HttpServletRequest,javax.servlet.http.HttpServletResponse)
  192. 2016-10-07 20:57:31 [main] INFO SimpleUrlHandlerMapping:354 - Mapped URL path [/webjars/**] onto handler of type [class org.springframework.web.servlet.resource.ResourceHttpRequestHandler]
  193. 2016-10-07 20:57:31 [main] INFO SimpleUrlHandlerMapping:354 - Mapped URL path [/**] onto handler of type [class org.springframework.web.servlet.resource.ResourceHttpRequestHandler]
  194. 2016-10-07 20:57:31 [main] INFO SimpleUrlHandlerMapping:354 - Mapped URL path [/**/favicon.ico] onto handler of type [class org.springframework.web.servlet.resource.ResourceHttpRequestHandler]
  195. 2016-10-07 20:57:31 [main] INFO AnnotationMBeanExporter:431 - Registering beans for JMX exposure on startup
  196. 2016-10-07 20:57:31 [main] INFO AnnotationMBeanExporter:912 - Bean with name 'dataSource' has been autodetected for JMX exposure
  197. 2016-10-07 20:57:31 [main] INFO AnnotationMBeanExporter:667 - Located MBean 'dataSource': registering with JMX server as MBean [com.zaxxer.hikari:name=dataSource,type=HikariDataSource]
  198. 2016-10-07 20:57:31 [main] INFO Http11NioProtocol:179 - Initializing ProtocolHandler ["http-nio-10000"]
  199. 2016-10-07 20:57:31 [main] INFO Http11NioProtocol:179 - Starting ProtocolHandler [http-nio-10000]
  200. 2016-10-07 20:57:31 [main] INFO NioSelectorPool:179 - Using a shared selector for servlet write/read
  201. 2016-10-07 20:57:31 [main] INFO TomcatEmbeddedServletContainer:185 - Tomcat started on port(s): 10000 (http)
  202. 2016-10-07 20:57:31 [main] INFO Application:57 - Started Application in 7.788 seconds (JVM running for 12.563)
  203. 2016-10-07 20:57:40 [http-nio-10000-exec-1] INFO [/]:179 - Initializing Spring FrameworkServlet 'messageDispatcherServlet'
  204. 2016-10-07 20:57:40 [http-nio-10000-exec-1] INFO MessageDispatcherServlet:489 - FrameworkServlet 'messageDispatcherServlet': initialization started
  205. 2016-10-07 20:57:40 [http-nio-10000-exec-1] INFO SaajSoapMessageFactory:139 - Creating SAAJ 1.3 MessageFactory with SOAP 1.1 Protocol
  206. 2016-10-07 20:57:40 [http-nio-10000-exec-1] INFO MessageDispatcherServlet:508 - FrameworkServlet 'messageDispatcherServlet': initialization completed in 40 ms
  207. ^^^^^^^^^^^^^^^^^^^^^^^^^^
  208. wallet id:1
  209. wallet id:102
  210. wallet status:9
  211. ^^^^^^^^^^^^^^^^^^^^^^^^^^
  212. Hibernate: update wallettest set orderStatus=? where orderId=? and orderInternalId=?
  213. 2016-10-07 20:57:40 [http-nio-10000-exec-1] WARN SqlExceptionHelper:127 - SQL Error: 42102, SQLState: 42S02
  214. 2016-10-07 20:57:40 [http-nio-10000-exec-1] ERROR SqlExceptionHelper:129 - Table "WALLETTEST" not found; SQL statement:
  215. update wallettest set orderStatus=? where orderId=? and orderInternalId=? [42102-192]
  216.  
  217. 2016-10-07 21:20:19 [main] INFO LocalContainerEntityManagerFactoryBean:349 - Building JPA container EntityManagerFactory for persistence unit 'default'
  218. 2016-10-07 21:20:19 [main] INFO LogHelper:31 - HHH000204: Processing PersistenceUnitInfo [
  219. name: default
  220. ...]
  221. 2016-10-07 21:20:19 [main] INFO Version:37 - HHH000412: Hibernate Core {5.0.11.Final}
  222. 2016-10-07 21:20:19 [main] INFO Environment:213 - HHH000206: hibernate.properties not found
  223. 2016-10-07 21:20:19 [main] INFO Environment:317 - HHH000021: Bytecode provider name : javassist
  224. 2016-10-07 21:20:19 [main] INFO Version:66 - HCANN000001: Hibernate Commons Annotations {5.0.1.Final}
  225. 2016-10-07 21:20:20 [main] INFO HikariDataSource:93 - HikariPool-1 - Started.
  226. 2016-10-07 21:20:20 [main] INFO Dialect:156 - HHH000400: Using dialect: org.hibernate.dialect.SybaseDialect
  227. 2016-10-07 21:20:21 [main] INFO SchemaUpdate:105 - HHH000228: Running hbm2ddl schema update
  228. 2016-10-07 21:20:21 [main] INFO InformationExtractorJdbcDatabaseMetaDataImpl:365 - HHH000262: Table not found: wallettest
  229. 2016-10-07 21:20:21 [main] INFO InformationExtractorJdbcDatabaseMetaDataImpl:365 - HHH000262: Table not found: wallettest
  230. 2016-10-07 21:20:21 [main] INFO LocalContainerEntityManagerFactoryBean:382 - Initialized JPA EntityManagerFactory for persistence unit 'default'
  231. 2016-10-07 21:20:21 [main] INFO QueryTranslatorFactoryInitiator:47 - HHH000397: Using ASTQueryTranslatorFactory
  232. 2016-10-07 21:20:21 [main] INFO OrderUpdateEndpoint:25 - Endpoint loaded
  233. 2016-10-07 21:20:22 [main] INFO RequestMappingHandlerAdapter:534 - Looking for @ControllerAdvice: org.springframework.boot.context.embedded.AnnotationConfigEmbeddedWebApplicationContext@65cefb8b: startup date [Fri Oct 07 21:20:15
  234. IST 2016]; root of context hierarchy
  235. 2016-10-07 21:20:22 [main] INFO RequestMappingHandlerMapping:543 - Mapped "{[/error]}" onto public org.springframework.http.ResponseEntity<java.util.Map<java.lang.String, java.lang.Object>> org.springframework.boot.autoconfigure.
  236. web.BasicErrorController.error(javax.servlet.http.HttpServletRequest)
  237. 2016-10-07 21:20:22 [main] INFO RequestMappingHandlerMapping:543 - Mapped "{[/error],produces=[text/html]}" onto public org.springframework.web.servlet.ModelAndView org.springframework.boot.autoconfigure.web.BasicErrorController.
  238. errorHtml(javax.servlet.http.HttpServletRequest,javax.servlet.http.HttpServletResponse)
  239. 2016-10-07 21:20:22 [main] INFO SimpleUrlHandlerMapping:354 - Mapped URL path [/webjars/**] onto handler of type [class org.springframework.web.servlet.resource.ResourceHttpRequestHandler]
  240. 2016-10-07 21:20:22 [main] INFO SimpleUrlHandlerMapping:354 - Mapped URL path [/**] onto handler of type [class org.springframework.web.servlet.resource.ResourceHttpRequestHandler]
  241. 2016-10-07 21:20:22 [main] INFO SimpleUrlHandlerMapping:354 - Mapped URL path [/**/favicon.ico] onto handler of type [class org.springframework.web.servlet.resource.ResourceHttpRequestHandler]
  242. 2016-10-07 21:20:23 [main] INFO AnnotationMBeanExporter:431 - Registering beans for JMX exposure on startup
  243. 2016-10-07 21:20:23 [main] INFO AnnotationMBeanExporter:912 - Bean with name 'dataSource' has been autodetected for JMX exposure
  244. 2016-10-07 21:20:23 [main] INFO AnnotationMBeanExporter:667 - Located MBean 'dataSource': registering with JMX server as MBean [com.zaxxer.hikari:name=dataSource,type=HikariDataSource]
  245. 2016-10-07 21:20:23 [main] INFO Http11NioProtocol:179 - Initializing ProtocolHandler ["http-nio-10000"]
  246. 2016-10-07 21:20:23 [main] INFO Http11NioProtocol:179 - Starting ProtocolHandler [http-nio-10000]
  247. 2016-10-07 21:20:23 [main] INFO NioSelectorPool:179 - Using a shared selector for servlet write/read
  248. 2016-10-07 21:20:23 [main] INFO TomcatEmbeddedServletContainer:185 - Tomcat started on port(s): 10000 (http)
  249. 2016-10-07 21:20:23 [main] INFO Application:57 - Started Application in 8.57 seconds (JVM running for 13.413)
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement
Public Pastes
Advertisement
We use cookies for various purposes including analytics. By continuing to use Pastebin, you agree to our use of cookies as described in the Cookies Policy.  OK, I Understand
Not a member of Pastebin yet?
Sign Up, it unlocks many cool features!