API tools faq
paste
Advertisement
Guest User

Untitled

a guest
Jun 14th, 2017
561
0
Never
Add comment
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 15.80 KB | None | 0 0
raw download clone embed print report
  1. NetBeans: Executing 'D:\Software\Development\JAVA\apache-maven-2.2.1\bin\mvn.bat -Dmaven.test.skip=true -Dexec.classpathScope=runtime -Dexec.args=-classpath %classpath com.databasetest2.App -Dexec.executable=C:\Program Files\Java\jdk1.6.0_10\bin\java.exe -Dnetbeans.execution=true -Dmaven.repo.local=C:\repository\.m2\repository2 process-classes org.codehaus.mojo:exec-maven-plugin:1.1.1:exec'
  2. NetBeans: JAVA_HOME=C:\Program Files\Java\jdk1.6.0_10
  3. Scanning for projects...
  4. ------------------------------------------------------------------------
  5. Building Databasetest2
  6. task-segment: [process-classes, org.codehaus.mojo:exec-maven-plugin:1.1.1:exec]
  7. ------------------------------------------------------------------------
  8. [resources:resources]
  9. [WARNING] File encoding has not been set, using platform encoding Cp1252, i.e. build is platform dependent!
  10. [WARNING] Using platform encoding (Cp1252 actually) to copy filtered resources, i.e. build is platform dependent!
  11. Copying 26 resources
  12. skip non existing resourceDirectory C:\Documents and Settings\victor\My Documents\NetBeansProjects\Databasetest2\src\main\resources
  13. [compiler:compile]
  14. Nothing to compile - all classes are up to date
  15. [exec:exec]
  16. log4j:WARN No appenders could be found for logger (org.springframework.context.support.ClassPathXmlApplicationContext).
  17. log4j:WARN Please initialize the log4j system properly.
  18. Testing database url ==== jdbc:postgresql://localhost:5432/ database name testdb
  19. [Debug] executing statement CREATE DATABASE testdb
  20. [Error] ERROR: database "testdb" already exists
  21. Ignoring error..... continue with other operations
  22. [debug] new connection Url: jdbc:postgresql://localhost:5432/testdb?autoReconnect=true
  23.  
  24.  
  25.  
  26. Testing change log com/postgresql/liquibase-create-tables.xml
  27. Sep 7, 2010 10:58:33 AM liquibase.database.template.JdbcTemplate comment
  28. INFO: Lock Database
  29. Sep 7, 2010 10:58:33 AM liquibase.lock.LockHandler acquireLock
  30. INFO: Successfully acquired change log lock
  31. Sep 7, 2010 10:58:34 AM liquibase.database.AbstractDatabase getRanChangeSetList
  32. INFO: Reading from databasechangelog
  33. Sep 7, 2010 10:58:34 AM liquibase.database.template.JdbcTemplate comment
  34. INFO: Release Database Lock
  35. Sep 7, 2010 10:58:34 AM liquibase.lock.LockHandler releaseLock
  36. INFO: Successfully released change log lock
  37.  
  38.  
  39. [debug ========================= ] finished writting to target database
  40.  
  41.  
  42.  
  43.  
  44.  
  45. Test Passed
  46.  
  47.  
  48.  
  49.  
  50.  
  51.  
  52.  
  53.  
  54. Testing change log com/postgresql/liquibase-insert-data.xml
  55. Sep 7, 2010 10:58:34 AM liquibase.database.template.JdbcTemplate comment
  56. INFO: Lock Database
  57. Sep 7, 2010 10:58:34 AM liquibase.lock.LockHandler acquireLock
  58. INFO: Successfully acquired change log lock
  59. Sep 7, 2010 10:58:34 AM liquibase.database.AbstractDatabase getRanChangeSetList
  60. INFO: Reading from databasechangelog
  61. Sep 7, 2010 10:58:35 AM liquibase.database.template.JdbcTemplate comment
  62. INFO: Release Database Lock
  63. Sep 7, 2010 10:58:35 AM liquibase.lock.LockHandler releaseLock
  64. INFO: Successfully released change log lock
  65.  
  66.  
  67. [debug ========================= ] finished writting to target database
  68.  
  69.  
  70.  
  71.  
  72.  
  73. Test Passed
  74.  
  75.  
  76.  
  77.  
  78.  
  79.  
  80.  
  81.  
  82. Testing change log com/postgresql/liquibase-mobile-menu.xml
  83. Sep 7, 2010 10:58:35 AM liquibase.database.template.JdbcTemplate comment
  84. INFO: Lock Database
  85. Sep 7, 2010 10:58:35 AM liquibase.lock.LockHandler acquireLock
  86. INFO: Successfully acquired change log lock
  87. Sep 7, 2010 10:58:35 AM liquibase.database.AbstractDatabase getRanChangeSetList
  88. INFO: Reading from databasechangelog
  89. Sep 7, 2010 10:58:35 AM liquibase.database.template.JdbcTemplate comment
  90. INFO: Changeset com/postgresql/liquibase-mobile-menu.xml::mobile-menu-09::Mark::(MD5Sum: c2f1fdbc52947ae76bf2dca7c30a858)
  91. Sep 7, 2010 10:58:35 AM liquibase.database.template.JdbcTemplate comment
  92. INFO: Adding Error Text for Missing Form Definition
  93. Sep 7, 2010 10:58:35 AM liquibase.database.template.JdbcTemplate comment
  94. INFO: Release Database Lock
  95. Sep 7, 2010 10:58:35 AM liquibase.lock.LockHandler releaseLock
  96. INFO: Successfully released change log lock
  97. liquibase.exception.MigrationFailedException: Migration failed for change set com/postgresql/liquibase-mobile-menu.xml::mobile-menu-09::Mark:
  98. Reason: liquibase.exception.JDBCException: Error executing SQL INSERT INTO mobile_menu (menu_id, description, name) VALUES ('-3', 'Error Text for Missing Form Definition', 'Menu Text Download'):
  99. Caused By: Error executing SQL INSERT INTO mobile_menu (menu_id, description, name) VALUES ('-3', 'Error Text for Missing Form Definition', 'Menu Text Download'):
  100. Caused By: ERROR: duplicate key value violates unique constraint "mobile_menu_name_key"
  101. at liquibase.ChangeSet.execute(ChangeSet.java:260)
  102. at liquibase.parser.visitor.UpdateVisitor.visit(UpdateVisitor.java:26)
  103. at liquibase.parser.ChangeLogIterator.run(ChangeLogIterator.java:41)
  104. at liquibase.Liquibase.update(Liquibase.java:112)
  105. at com.databasetest2.TestMigration.runChangeLog(TestMigration.java:56)
  106. at com.databasetest2.TestMigration.showStatus(TestMigration.java:67)
  107. at com.databasetest2.App.main(App.java:39)
  108. Caused by: liquibase.exception.JDBCException: Error executing SQL INSERT INTO mobile_menu (menu_id, description, name) VALUES ('-3', 'Error Text for Missing Form Definition', 'Menu Text Download')
  109. at liquibase.database.template.JdbcTemplate.execute(JdbcTemplate.java:55)
  110. at liquibase.database.template.JdbcTemplate.execute(JdbcTemplate.java:86)
  111. at liquibase.change.AbstractChange.execute(AbstractChange.java:247)
  112. at liquibase.change.AbstractChange.executeStatements(AbstractChange.java:93)
  113. at liquibase.ChangeSet.execute(ChangeSet.java:236)
  114. ... 6 more
  115. Caused by: org.postgresql.util.PSQLException: ERROR: duplicate key value violates unique constraint "mobile_menu_name_key"
  116. at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:2062)
  117.  
  118. at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1795)
  119.  
  120. at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:257)
  121.  
  122. at org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:479)
  123.  
  124. at org.postgresql.jdbc2.AbstractJdbc2Statement.executeWithFlags(AbstractJdbc2Statement.java:353)
  125.  
  126. at org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:345)
  127. at liquibase.database.template.JdbcTemplate$1ExecuteStatementCallback.doInStatement(JdbcTemplate.java:78)
  128. at liquibase.database.template.JdbcTemplate.execute(JdbcTemplate.java:48)
  129. ... 10 more
  130. Sep 7, 2010 10:58:35 AM liquibase.database.template.JdbcTemplate comment
  131. INFO: Lock Database
  132. Sep 7, 2010 10:58:35 AM liquibase.lock.LockHandler acquireLock
  133. INFO: Successfully acquired change log lock
  134. Sep 7, 2010 10:58:35 AM liquibase.database.AbstractDatabase getRanChangeSetList
  135. INFO: Reading from databasechangelog
  136. Sep 7, 2010 10:58:35 AM liquibase.database.template.JdbcTemplate comment
  137. INFO: Release Database Lock
  138. Sep 7, 2010 10:58:35 AM liquibase.lock.LockHandler releaseLock
  139. INFO: Successfully released change log lock
  140. Sep 7, 2010 10:58:36 AM liquibase.database.template.JdbcTemplate comment
  141. INFO: Lock Database
  142. Sep 7, 2010 10:58:36 AM liquibase.lock.LockHandler acquireLock
  143. INFO: Successfully acquired change log lock
  144. Test failed
  145.  
  146.  
  147.  
  148.  
  149.  
  150.  
  151.  
  152.  
  153. Testing change log com/postgresql/liquibase-create-foreignkeys.xml
  154.  
  155.  
  156. [debug ========================= ] finished writting to target database
  157.  
  158.  
  159.  
  160.  
  161.  
  162. Test Passed
  163.  
  164.  
  165.  
  166.  
  167.  
  168.  
  169.  
  170.  
  171. Testing change log com/postgresql/liquibase-update-to-1.0.xml
  172. Sep 7, 2010 10:58:36 AM liquibase.database.AbstractDatabase getRanChangeSetList
  173. INFO: Reading from databasechangelog
  174. Sep 7, 2010 10:58:36 AM liquibase.database.template.JdbcTemplate comment
  175. INFO: Changeset com/postgresql/liquibase-update-to-1.0.xml::1247499691484-5::daniel::(MD5Sum: ecf48d494b26541588a76c639a5d9c2)
  176. Sep 7, 2010 10:58:36 AM liquibase.database.template.JdbcTemplate comment
  177. INFO: Adding smsFieldSepChar setting
  178. Sep 7, 2010 10:58:36 AM liquibase.database.template.JdbcTemplate comment
  179. INFO: Release Database Lock
  180. Sep 7, 2010 10:58:36 AM liquibase.lock.LockHandler releaseLock
  181. INFO: Successfully released change log lock
  182. liquibase.exception.MigrationFailedException: Migration failed for change set com/postgresql/liquibase-update-to-1.0.xml::1247499691484-5::daniel:
  183. Reason: liquibase.exception.JDBCException: Error executing SQL INSERT INTO setting (setting_group_id, description, name, value) VALUES (4, 'The separator for form fields in an text sms used to submit data', 'smsFieldSepChar', '='):
  184. Caused By: Error executing SQL INSERT INTO setting (setting_group_id, description, name, value) VALUES (4, 'The separator for form fields in an text sms used to submit data', 'smsFieldSepChar', '='):
  185. Caused By: ERROR: duplicate key value violates unique constraint "setting_pkey"
  186. at liquibase.ChangeSet.execute(ChangeSet.java:260)
  187. at liquibase.parser.visitor.UpdateVisitor.visit(UpdateVisitor.java:26)
  188. at liquibase.parser.ChangeLogIterator.run(ChangeLogIterator.java:41)
  189. at liquibase.Liquibase.update(Liquibase.java:112)
  190. at com.databasetest2.TestMigration.runChangeLog(TestMigration.java:56)
  191. at com.databasetest2.TestMigration.showStatus(TestMigration.java:67)
  192. at com.databasetest2.App.main(App.java:41)
  193. Caused by: liquibase.exception.JDBCException: Error executing SQL INSERT INTO setting (setting_group_id, description, name, value) VALUES (4, 'The separator for form fields in an text sms used to submit data', 'smsFieldSepChar', '=')
  194. at liquibase.database.template.JdbcTemplate.execute(JdbcTemplate.java:55)
  195. at liquibase.database.template.JdbcTemplate.execute(JdbcTemplate.java:86)
  196. at liquibase.change.AbstractChange.execute(AbstractChange.java:247)
  197. at liquibase.change.AbstractChange.executeStatements(AbstractChange.java:93)
  198. at liquibase.ChangeSet.execute(ChangeSet.java:236)
  199. ... 6 more
  200. Caused by: org.postgresql.util.PSQLException: ERROR: duplicate key value violates unique constraint "setting_pkey"
  201. at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:2062)
  202. at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1795)
  203. at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:257)
  204. at org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:479)
  205. at org.postgresql.jdbc2.AbstractJdbc2Statement.executeWithFlags(AbstractJdbc2Statement.java:353)
  206. at org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:345)
  207. at liquibase.database.template.JdbcTemplate$1ExecuteStatementCallback.doInStatement(JdbcTemplate.java:78)
  208. at liquibase.database.template.JdbcTemplate.execute(JdbcTemplate.java:48)
  209. ... 10 more
  210. Sep 7, 2010 10:58:37 AM liquibase.database.template.JdbcTemplate comment
  211. INFO: Lock Database
  212. Sep 7, 2010 10:58:37 AM liquibase.lock.LockHandler acquireLock
  213. INFO: Successfully acquired change log lock
  214.  
  215.  
  216.  
  217.  
  218.  
  219. Test failed
  220.  
  221.  
  222.  
  223.  
  224.  
  225.  
  226.  
  227.  
  228. Testing change log com/postgresql/liquibase-permissions.xml
  229. Sep 7, 2010 10:58:37 AM liquibase.database.AbstractDatabase getRanChangeSetList
  230. INFO: Reading from databasechangelog
  231. Sep 7, 2010 10:58:37 AM liquibase.database.template.JdbcTemplate comment
  232. INFO: Changeset com/postgresql/liquibase-permissions.xml::permissions_change_id_00::Mark::(MD5Sum: 333d5bd643e8c53abf5258fb9e0175a)
  233. Sep 7, 2010 10:58:37 AM liquibase.database.template.JdbcTemplate comment
  234. INFO: Adding administrator user to the users table
  235. Sep 7, 2010 10:58:37 AM liquibase.database.template.JdbcTemplate comment
  236. INFO: Release Database Lock
  237. Sep 7, 2010 10:58:37 AM liquibase.lock.LockHandler releaseLock
  238. INFO: Successfully released change log lock
  239. liquibase.exception.MigrationFailedException: Migration failed for change set com/postgresql/liquibase-permissions.xml::permissions_change_id_00::Mark:
  240. Reason: liquibase.exception.JDBCException: Error executing SQL INSERT INTO users (changed_by, date_changed, middle_name, date_created, secret_question, password, creator, user_name, first_name, email, phone_no, last_name, user_id, salt, secret_answer) VALUES (NULL, '2009-03-13', 'administrator', '2009-11-13', 'what is the name of the organisation that developed oxd?', '7357bec928a1af86415f7b8c11245296ec1779d', 2, 'admin', 'administrator', 'cattabanks@gmail.com', '000-000-0000-01', 'administrator', 2, 'e2597cf74095403889c6b07b46d8af5d94b8e6', 'MUK and Mark'):
  241. Caused By: Error executing SQL INSERT INTO users (changed_by, date_changed, middle_name, date_created, secret_question, password, creator, user_name, first_name, email, phone_no, last_name, user_id, salt, secret_answer) VALUES (NULL, '2009-03-13', 'administrator', '2009-11-13', 'what is the name of the organisation that developed oxd?', '7357bec928a1af86415f7b8c11245296ec1779d', 2, 'admin', 'administrator', 'cattabanks@gmail.com', '000-000-0000-01', 'administrator', 2, 'e2597cf74095403889c6b07b46d8af5d94b8e6', 'MUK and Mark'):
  242. Caused By: ERROR: column "email" of relation "users" does not exist
  243. Position: 132
  244. at liquibase.ChangeSet.execute(ChangeSet.java:260)
  245. at liquibase.parser.visitor.UpdateVisitor.visit(UpdateVisitor.java:26)
  246. at liquibase.parser.ChangeLogIterator.run(ChangeLogIterator.java:41)
  247. at liquibase.Liquibase.update(Liquibase.java:112)
  248. at com.databasetest2.TestMigration.runChangeLog(TestMigration.java:56)
  249. at com.databasetest2.TestMigration.showStatus(TestMigration.java:67)
  250. at com.databasetest2.App.main(App.java:42)
  251. Caused by: liquibase.exception.JDBCException: Error executing SQL INSERT INTO users (changed_by, date_changed, middle_name, date_created, secret_question, password, creator, user_name, first_name, email, phone_no, last_name, user_id, salt, secret_answer) VALUES (NULL, '2009-03-13', 'administrator', '2009-11-13', 'what is the name of the organisation that developed oxd?', '7357bec928a1af86415f7b8c11245296ec1779d', 2, 'admin', 'administrator', 'cattabanks@gmail.com', '000-000-0000-01', 'administrator', 2, 'e2597cf74095403889c6b07b46d8af5d94b8e6', 'MUK and Mark')
  252. at liquibase.database.template.JdbcTemplate.execute(JdbcTemplate.java:55)
  253. at liquibase.database.template.JdbcTemplate.execute(JdbcTemplate.java:86)
  254. at liquibase.change.AbstractChange.execute(AbstractChange.java:247)
  255. at liquibase.change.AbstractChange.executeStatements(AbstractChange.java:93)
  256. at liquibase.ChangeSet.execute(ChangeSet.java:236)
  257. ... 6 more
  258. Caused by: org.postgresql.util.PSQLException: ERROR: column "email" of relation "users" does not exist
  259. Position: 132
  260. at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:2062)
  261. at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1795)
  262. at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:257)
  263. at org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:479)
  264. at org.postgresql.jdbc2.AbstractJdbc2Statement.executeWithFlags(AbstractJdbc2Statement.java:353)
  265. at org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:345)
  266. at liquibase.database.template.JdbcTemplate$1ExecuteStatementCallback.doInStatement(JdbcTemplate.java:78)
  267. at liquibase.database.template.JdbcTemplate.execute(JdbcTemplate.java:48)
  268. ... 10 more
  269.  
  270.  
  271.  
  272.  
  273.  
  274. Test failed
  275.  
  276.  
  277.  
  278.  
  279.  
  280. ------------------------------------------------------------------------
  281. BUILD SUCCESSFUL
  282. ------------------------------------------------------------------------
  283. Total time: 18 seconds
  284. Finished at: Tue Sep 07 10:58:37 EAT 2010
  285. Final Memory: 10M/19M
  286. ----------------------------------
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!