Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- Windows PowerShell
- Copyright (C) Microsoft Corporation. All rights reserved.
- Try the new cross-platform PowerShell https://aka.ms/pscore6
- PS T:\> cd C:\Users\dariusz\Desktop\label_printing
- PS C:\Users\dariusz\Desktop\label_printing> java -jar label-printing_server.jar
- 2019-11-20 15:17:20:455 (KOIN)::[i] [PrintLogger] display debug = false
- 2019-11-20 15:17:20:507 (KOIN)::[i] [definition] declare Single [name='global.ApplicationConfigService',class='uk.co.ka21k.labelprinting.services.ApplicationConfigService', path:'global']
- 2019-11-20 15:17:20:508 (KOIN)::[i] [definition] declare Single [name='global.DatabaseProvider',class='uk.co.ka21k.labelprinting.services.DatabaseProvider', path:'global']
- 2019-11-20 15:17:20:508 (KOIN)::[i] [definition] declare Single [name='global.TimerService',class='uk.co.ka21k.labelprinting.services.TimerService', path:'global']
- 2019-11-20 15:17:20:508 (KOIN)::[i] [definition] declare Single [name='global.TemplateService',class='uk.co.ka21k.labelprinting.services.TemplateService', path:'global']
- 2019-11-20 15:17:20:508 (KOIN)::[i] [definition] declare Single [name='global.ClockCardDao',class='uk.co.ka21k.labelprinting.data.dao.ClockCardDao', path:'global']
- 2019-11-20 15:17:20:509 (KOIN)::[i] [definition] declare Single [name='global.SessionService',class='uk.co.ka21k.labelprinting.services.SessionService', path:'global']
- 2019-11-20 15:17:20:509 (KOIN)::[i] [definition] declare Single [name='global.CloneDatabaseService',class='uk.co.ka21k.labelprinting.services.CloneDatabaseService', path:'global']
- 2019-11-20 15:17:20:509 (KOIN)::[i] [definition] declare Single [name='global.BindService',class='uk.co.ka21k.labelprinting.services.BindService', path:'global']
- 2019-11-20 15:17:20:509 (KOIN)::[i] [definition] declare Single [name='global.SessionTimeout',class='uk.co.ka21k.labelprinting.services.SessionTimeout', path:'global']
- 2019-11-20 15:17:20:509 (KOIN)::[i] [modules] loaded 9 definitions
- 2019-11-20 15:17:20:511 (KOIN)::[i] [modules] loaded in 30.3821 ms
- 2019-11-20 15:17:20:511 (KOIN)::[i] [Koin] started in 47.7677 ms
- Nov 20, 2019 3:17:20 PM tornadofx.Stylesheet$Companion detectAndInstallUrlHandler
- INFO: Installing CSS url handler, since it was not picked up automatically
- 2019-11-20 15:17:20:853 (KOIN)::[i] +-- 'uk.co.ka21k.labelprinting.services.CloneDatabaseService'
- 2019-11-20 15:17:20:857 (KOIN)::[i] | +-- 'uk.co.ka21k.labelprinting.services.DatabaseProvider'
- 2019-11-20 15:17:20:857 (KOIN)::[i] | | +-- 'uk.co.ka21k.labelprinting.services.ApplicationConfigService'
- 2019-11-20 15:17:20:858 (KOIN)::[i] | | \-- (*) Created
- SLF4J: Failed to load class "org.slf4j.impl.StaticLoggerBinder".
- SLF4J: Defaulting to no-operation (NOP) logger implementation
- SLF4J: See http://www.slf4j.org/codes.html#StaticLoggerBinder for further details.
- 2019-11-20 15:17:21:531 (KOIN)::[i] | \-- (*) Created
- 2019-11-20 15:17:21:531 (KOIN)::[i] | +-- 'uk.co.ka21k.labelprinting.services.ApplicationConfigService'
- 2019-11-20 15:17:21:533 (KOIN)::[i] \-- (*) Created
- 2019-11-20 15:17:21:533 (KOIN)::[i] +-- 'uk.co.ka21k.labelprinting.services.CloneDatabaseService'
- [2019-11-20T15:17:21.556409100][INFO][TIMER] Success sync database.
- SQL: SELECT employee.emp_num, employee."name" FROM employee WHERE employee.term_date IS NULL
- 2019-11-20 15:17:22:249 (KOIN)::[i] +-- 'uk.co.ka21k.labelprinting.services.DatabaseProvider'
- SQL: SELECT PRINT_LOG.TIME_SPEND, PRINT_LOG.LOGIN_NAME FROM PRINT_LOG ORDER BY PRINT_LOG.TIME_SPEND ASC LIMIT 1
- SQL: SELECT job.job, job.item, item.drawing_nbr, item.Uf_nyl_drawing_issue_num FROM job INNER JOIN item ON job.item = item.item WHERE job."type" = 'J' AND job.stat = 'R' ORDER BY job.job ASC
- SQL: INSERT INTO JOB (drawing_issue_num, drawing_nbr, item, job) VALUES ('B', '1-D00294', 'SUSTA3053', 'MAN0006074')
- SQL: SELECT job.job, job.item, item.drawing_nbr, item.Uf_nyl_drawing_issue_num FROM job INNER JOIN item ON job.item = item.item WHERE job."type" = 'J' AND job.stat = 'R' ORDER BY job.job ASC
- SQL: INSERT INTO JOB (drawing_issue_num, drawing_nbr, item, job) VALUES ('02', '1000147619 / 2080101509', 'MLREA1330', 'ALT0000001')
- SQL: SELECT job.job, job.item, item.drawing_nbr, item.Uf_nyl_drawing_issue_num FROM job INNER JOIN item ON job.item = item.item WHERE job."type" = 'J' AND job.stat = 'R' ORDER BY job.job ASC
- SQL: INSERT INTO JOB (drawing_issue_num, drawing_nbr, item, job) VALUES ('02', '1000147619 / 2080101509', 'MLREA1330', 'ALT0000001')
- [2019-11-20T15:17:26.228534800][ERR][TIMER] Error during database update.
- org.jetbrains.exposed.exceptions.ExposedSQLException: org.sqlite.SQLiteException: [SQLITE_CONSTRAINT_PRIMARYKEY] A PRIMARY KEY constraint failed (UNIQUE constraint failed: JOB.job)
- SQL: [INSERT INTO JOB (drawing_issue_num, drawing_nbr, item, job) VALUES (?, ?, ?, ?)]
- at org.jetbrains.exposed.sql.statements.Statement.executeIn$exposed(Statement.kt:61)
- at org.jetbrains.exposed.sql.Transaction.exec(Transaction.kt:128)
- at org.jetbrains.exposed.sql.Transaction.exec(Transaction.kt:122)
- at org.jetbrains.exposed.sql.statements.Statement.execute(Statement.kt:29)
- at org.jetbrains.exposed.sql.QueriesKt.insert(Queries.kt:45)
- at uk.co.ka21k.labelprinting.services.CloneDatabaseServiceImpl$cloneJobWithClear$3$4$1.invoke(CloneDatabaseService.kt:54)
- at uk.co.ka21k.labelprinting.services.CloneDatabaseServiceImpl$cloneJobWithClear$3$4$1.invoke(CloneDatabaseService.kt:22)
- at org.jetbrains.exposed.sql.transactions.ThreadLocalTransactionManagerKt.inTopLevelTransaction(ThreadLocalTransactionManager.kt:104)
- at org.jetbrains.exposed.sql.transactions.ThreadLocalTransactionManagerKt.transaction(ThreadLocalTransactionManager.kt:75)
- at uk.co.ka21k.labelprinting.services.CloneDatabaseServiceImpl$cloneJobWithClear$3.invoke(CloneDatabaseService.kt:53)
- at uk.co.ka21k.labelprinting.services.CloneDatabaseServiceImpl$cloneJobWithClear$3.invoke(CloneDatabaseService.kt:22)
- at org.jetbrains.exposed.sql.transactions.ThreadLocalTransactionManagerKt.inTopLevelTransaction(ThreadLocalTransactionManager.kt:104)
- at org.jetbrains.exposed.sql.transactions.ThreadLocalTransactionManagerKt.transaction(ThreadLocalTransactionManager.kt:75)
- at org.jetbrains.exposed.sql.transactions.ThreadLocalTransactionManagerKt.transaction(ThreadLocalTransactionManager.kt:58)
- at uk.co.ka21k.labelprinting.services.CloneDatabaseServiceImpl.cloneJobWithClear(CloneDatabaseService.kt:48)
- at uk.co.ka21k.labelprinting.services.CloneDatabaseServiceImpl.cloneFromRemote(CloneDatabaseService.kt:29)
- at uk.co.ka21k.labelprinting.LabelPrintingApp$start$timerTask$1.run(Main.kt:80)
- at java.base/java.util.TimerThread.mainLoop(Unknown Source)
- at java.base/java.util.TimerThread.run(Unknown Source)
- Caused by: org.sqlite.SQLiteException: [SQLITE_CONSTRAINT_PRIMARYKEY] A PRIMARY KEY constraint failed (UNIQUE constraint failed: JOB.job)
- at org.sqlite.core.DB.newSQLException(DB.java:909)
- at org.sqlite.core.DB.newSQLException(DB.java:921)
- at org.sqlite.core.DB.execute(DB.java:825)
- at org.sqlite.core.DB.executeUpdate(DB.java:863)
- at org.sqlite.jdbc3.JDBC3PreparedStatement.executeUpdate(JDBC3PreparedStatement.java:99)
- at org.jetbrains.exposed.sql.statements.InsertStatement.execInsertFunction(InsertStatement.kt:102)
- at org.jetbrains.exposed.sql.statements.InsertStatement.executeInternal(InsertStatement.kt:111)
- at org.jetbrains.exposed.sql.statements.InsertStatement.executeInternal(InsertStatement.kt:13)
- at org.jetbrains.exposed.sql.statements.Statement.executeIn$exposed(Statement.kt:59)
- ... 18 more
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement