API tools faq
paste
Fanadia_Friska

error TestGetVehicleList.java

Fanadia_Friska
Aug 28th, 2016
91
0
Never
Add comment
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 11.36 KB | None | 0 0
raw download clone embed print report
  1. Running org.jleaf.pos2.test.vehicle.TestGetVehicleList
  2. 2016-08-29 11:07:17.314 [WARN] org.jleaf.common.bo.realm.RealmActiveDirectory:48 - Activate Realm LDAP without any configuration
  3. 2016-08-29 11:07:19.333 [INFO] org.springframework.test.jdbc.SimpleJdbcTestUtils:71 - Deleted 0 rows from table m_vehicle
  4. 2016-08-29 11:07:19.337 [INFO] org.springframework.test.jdbc.SimpleJdbcTestUtils:71 - Deleted 2 rows from table m_vehicle_group
  5. 2016-08-29 11:07:19.340 [INFO] org.springframework.test.jdbc.SimpleJdbcTestUtils:71 - Deleted 2 rows from table m_vehicle_type
  6. 2016-08-29 11:07:19.341 [INFO] org.springframework.test.jdbc.SimpleJdbcTestUtils:133 - Executing SQL script from class path resource [scripts/TestGetVehicleList.sql]
  7. 2016-08-29 11:07:19.347 [DEBUG] org.springframework.test.jdbc.SimpleJdbcTestUtils:151 - 3 rows affected by SQL: INSERT INTO m_vehicle(
  8. vehicle_code,license_no, owner_name, chassis_no,
  9. engine_no, vehicle_group_code,
  10. vehicle_type_code, year_made, customer_name,
  11. address1, address2, address3, phone1,phone2,
  12. active, active_datetime, non_active_datetime,
  13. version, create_datetime,
  14. create_username, update_datetime, update_username)
  15. VALUES ('HND','H 6634 SS','Mail','222-442-2442-244',
  16. '123-432-1234-201','PBD',
  17. 'MTR','2016','Rika',
  18. 'Boja','Mijen','Ngaliyan','087865433421','0878987661234',
  19. 'Y','20160801000000','20160802000000',
  20. 0,'20160804000000',
  21. 'Nurfitria','20160805000000','Dewi'),
  22. ('YMH','H 2434 BP','juky','222-443-2443-245',
  23. '123-432-1234-202','KTR',
  24. 'MTR','2016','Ayu',
  25. 'gunung_pati','sedayu','Ngaliyan','087865466666','0878987669876',
  26. 'Y','20160728000000','20160713000000',0,'20160714000000',
  27. 'efa','20160714000000','tania'),
  28. ('DCY','DA 1987 BB','Bone','222-442-2442-246',
  29. '123-432-1234-201','PBD',
  30. 'MTR','2016','Rika',
  31. 'Boja','Mijen','Ngaliyan','087865433421','0878987665678',
  32. 'N','20160728000000','20160729000000',0,'20160713000000',
  33. 'fitri','20160714000000','Nofi')
  34. 2016-08-29 11:07:19.347 [INFO] org.springframework.test.jdbc.SimpleJdbcTestUtils:167 - Done executing SQL scriptBuilder from class path resource [scripts/TestGetVehicleList.sql] in 5 ms.
  35. Hibernate: SELECT A.vehicle_code, A.license_no, A.owner_name, A.chassis_no, A.engine_no, A.vehicle_group_code, B.vehicle_group_name, A.vehicle_type_code, C.vehicle_type_name, A.year_made, A.customer_name, A.address1, A.address2, A.address3, A.phone1, A.phone2, A.active, A.version FROM m_vehicle A JOIN m_vehicle_group B ON A.vehicle_group_code = B.vehicle_group_code JOIN m_vehicle_type A.vehicle_type_code = C.vehicle_type_code WHERE true AND ( UPPER( A.owner_name ) like '%YMH%' OR UPPER( A.license_no ) like '%YMH%' OR UPPER( A.customer_name ) like '%YMH%' ) AND UPPER(A.active) = 'N' ORDER BY A.vehicle_code ASC LIMIT 7 OFFSET 0
  36. 2016-08-29 11:07:19.383 [DEBUG] org.hibernate.util.JDBCExceptionReporter:225 - could not execute query [ SELECT A.vehicle_code, A.license_no, A.owner_name, A.chassis_no, A.engine_no, A.vehicle_group_code, B.vehicle_group_name, A.vehicle_type_code, C.vehicle_type_name, A.year_made, A.customer_name, A.address1, A.address2, A.address3, A.phone1, A.phone2, A.active, A.version FROM m_vehicle A JOIN m_vehicle_group B ON A.vehicle_group_code = B.vehicle_group_code JOIN m_vehicle_type A.vehicle_type_code = C.vehicle_type_code WHERE true AND ( UPPER( A.owner_name ) like '%YMH%' OR UPPER( A.license_no ) like '%YMH%' OR UPPER( A.customer_name ) like '%YMH%' ) AND UPPER(A.active) = 'N' ORDER BY A.vehicle_code ASC LIMIT 7 OFFSET 0]
  37. org.postgresql.util.PSQLException: ERROR: syntax error at or near "."
  38. Position: 399
  39. at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:2198)
  40. at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1927)
  41. at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:255)
  42. at org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:561)
  43. at org.postgresql.jdbc2.AbstractJdbc2Statement.executeWithFlags(AbstractJdbc2Statement.java:419)
  44. at org.postgresql.jdbc2.AbstractJdbc2Statement.executeQuery(AbstractJdbc2Statement.java:304)
  45. at org.hibernate.jdbc.AbstractBatcher.getResultSet(AbstractBatcher.java:208)
  46. at org.hibernate.loader.Loader.getResultSet(Loader.java:1953)
  47. at org.hibernate.loader.Loader.doQuery(Loader.java:802)
  48. at org.hibernate.loader.Loader.doQueryAndInitializeNonLazyCollections(Loader.java:274)
  49. at org.hibernate.loader.Loader.doList(Loader.java:2533)
  50. at org.hibernate.loader.Loader.listIgnoreQueryCache(Loader.java:2276)
  51. at org.hibernate.loader.Loader.list(Loader.java:2271)
  52. at org.hibernate.loader.custom.CustomLoader.list(CustomLoader.java:316)
  53. at org.hibernate.impl.SessionImpl.listCustomQuery(SessionImpl.java:1842)
  54. at org.hibernate.impl.AbstractSessionImpl.list(AbstractSessionImpl.java:165)
  55. at org.hibernate.impl.SQLQueryImpl.list(SQLQueryImpl.java:157)
  56. at org.hibernate.ejb.QueryImpl.getResultList(QueryImpl.java:246)
  57. at org.jleaf.pos2.bo.vehicle.GetVehicleList.execute(GetVehicleList.java:105)
  58. at org.jleaf.pos2.test.vehicle.TestGetVehicleList.testGetListIfKeywordByvehicleCodeAndActiveNo(TestGetVehicleList.java:128)
  59. at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
  60. at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
  61. at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
  62. at java.lang.reflect.Method.invoke(Method.java:597)
  63. at org.junit.runners.model.FrameworkMethod$1.runReflectiveCall(FrameworkMethod.java:44)
  64. at org.junit.internal.runners.model.ReflectiveCallable.run(ReflectiveCallable.java:15)
  65. at org.junit.runners.model.FrameworkMethod.invokeExplosively(FrameworkMethod.java:41)
  66. at org.junit.internal.runners.statements.InvokeMethod.evaluate(InvokeMethod.java:20)
  67. at org.junit.internal.runners.statements.RunBefores.evaluate(RunBefores.java:28)
  68. at org.springframework.test.context.junit4.statements.RunBeforeTestMethodCallbacks.evaluate(RunBeforeTestMethodCallbacks.java:74)
  69. at org.springframework.test.context.junit4.statements.RunAfterTestMethodCallbacks.evaluate(RunAfterTestMethodCallbacks.java:82)
  70. at org.springframework.test.context.junit4.statements.SpringRepeat.evaluate(SpringRepeat.java:72)
  71. at org.springframework.test.context.junit4.SpringJUnit4ClassRunner.runChild(SpringJUnit4ClassRunner.java:231)
  72. at org.junit.runners.BlockJUnit4ClassRunner.runChild(BlockJUnit4ClassRunner.java:50)
  73. at org.junit.runners.ParentRunner$3.run(ParentRunner.java:193)
  74. at org.junit.runners.ParentRunner$1.schedule(ParentRunner.java:52)
  75. at org.junit.runners.ParentRunner.runChildren(ParentRunner.java:191)
  76. at org.junit.runners.ParentRunner.access$000(ParentRunner.java:42)
  77. at org.junit.runners.ParentRunner$2.evaluate(ParentRunner.java:184)
  78. at org.springframework.test.context.junit4.statements.RunBeforeTestClassCallbacks.evaluate(RunBeforeTestClassCallbacks.java:61)
  79. at org.springframework.test.context.junit4.statements.RunAfterTestClassCallbacks.evaluate(RunAfterTestClassCallbacks.java:70)
  80. at org.junit.runners.ParentRunner.run(ParentRunner.java:236)
  81. at org.springframework.test.context.junit4.SpringJUnit4ClassRunner.run(SpringJUnit4ClassRunner.java:174)
  82. at org.apache.maven.surefire.junit4.JUnit4Provider.execute(JUnit4Provider.java:264)
  83. at org.apache.maven.surefire.junit4.JUnit4Provider.executeTestSet(JUnit4Provider.java:153)
  84. at org.apache.maven.surefire.junit4.JUnit4Provider.invoke(JUnit4Provider.java:124)
  85. at org.apache.maven.surefire.booter.ForkedBooter.invokeProviderInSameClassLoader(ForkedBooter.java:200)
  86. at org.apache.maven.surefire.booter.ForkedBooter.runSuitesInProcess(ForkedBooter.java:153)
  87. at org.apache.maven.surefire.booter.ForkedBooter.main(ForkedBooter.java:103)
  88. 2016-08-29 11:07:19.385 [WARN] org.hibernate.util.JDBCExceptionReporter:233 - SQL Error: 0, SQLState: 42601
  89. 2016-08-29 11:07:19.385 [ERROR] org.hibernate.util.JDBCExceptionReporter:234 - ERROR: syntax error at or near "."
  90. Position: 399
  91. 2016-08-29 11:07:19.386 [DEBUG] org.hibernate.ejb.AbstractEntityManagerImpl:948 - mark transaction for rollback
  92. Tests run: 1, Failures: 0, Errors: 1, Skipped: 0, Time elapsed: 10.586 sec <<< FAILURE! - in org.jleaf.pos2.test.vehicle.TestGetVehicleList
  93. testGetListIfKeywordByvehicleCodeAndActiveNo(org.jleaf.pos2.test.vehicle.TestGetVehicleList) Time elapsed: 10.339 sec <<< ERROR!
  94. javax.persistence.PersistenceException: org.hibernate.exception.SQLGrammarException: could not execute query
  95. at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:2198)
  96. at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1927)
  97. at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:255)
  98. at org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:561)
  99. at org.postgresql.jdbc2.AbstractJdbc2Statement.executeWithFlags(AbstractJdbc2Statement.java:419)
  100. at org.postgresql.jdbc2.AbstractJdbc2Statement.executeQuery(AbstractJdbc2Statement.java:304)
  101. at org.hibernate.jdbc.AbstractBatcher.getResultSet(AbstractBatcher.java:208)
  102. at org.hibernate.loader.Loader.getResultSet(Loader.java:1953)
  103. at org.hibernate.loader.Loader.doQuery(Loader.java:802)
  104. at org.hibernate.loader.Loader.doQueryAndInitializeNonLazyCollections(Loader.java:274)
  105. at org.hibernate.loader.Loader.doList(Loader.java:2533)
  106. at org.hibernate.loader.Loader.listIgnoreQueryCache(Loader.java:2276)
  107. at org.hibernate.loader.Loader.list(Loader.java:2271)
  108. at org.hibernate.loader.custom.CustomLoader.list(CustomLoader.java:316)
  109. at org.hibernate.impl.SessionImpl.listCustomQuery(SessionImpl.java:1842)
  110. at org.hibernate.impl.AbstractSessionImpl.list(AbstractSessionImpl.java:165)
  111. at org.hibernate.impl.SQLQueryImpl.list(SQLQueryImpl.java:157)
  112. at org.hibernate.ejb.QueryImpl.getResultList(QueryImpl.java:246)
  113. at org.jleaf.pos2.bo.vehicle.GetVehicleList.execute(GetVehicleList.java:105)
  114. at org.jleaf.pos2.test.vehicle.TestGetVehicleList.testGetListIfKeywordByvehicleCodeAndActiveNo(TestGetVehicleList.java:128)
  115.  
  116.  
  117. Results :
  118.  
  119. Tests in error:
  120. TestGetVehicleList.testGetListIfKeywordByvehicleCodeAndActiveNo:128 » Persistence
  121.  
  122. Tests run: 1, Failures: 0, Errors: 1, Skipped: 0
  123.  
  124. [INFO] ------------------------------------------------------------------------
  125. [INFO] BUILD FAILURE
  126. [INFO] ------------------------------------------------------------------------
  127. [INFO] Total time: 19.921s
  128. [INFO] Finished at: Mon Aug 29 11:07:19 WIT 2016
  129. [INFO] Final Memory: 18M/335M
  130. [INFO] ------------------------------------------------------------------------
  131. [ERROR] Failed to execute goal org.apache.maven.plugins:maven-surefire-plugin:2.16:test (default-test) on project master-bo: There are test failures.
  132. [ERROR]
  133. [ERROR] Please refer to /home/sts/workspace/master-bo-vehicle2/target/surefire-reports for the individual test results.
  134. [ERROR] -> [Help 1]
  135. [ERROR]
  136. [ERROR] To see the full stack trace of the errors, re-run Maven with the -e switch.
  137. [ERROR] Re-run Maven using the -X switch to enable full debug logging.
  138. [ERROR]
  139. [ERROR] For more information about the errors and possible solutions, please read the following articles:
  140. [ERROR] [Help 1] http://cwiki.apache.org/confluence/display/MAVEN/MojoFailureException
  141. sts@anjar:~/workspace/master-bo-vehicle2$
Advertisement
Add Comment
Please, Sign In to add comment
Public Pastes
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!