by DaveM » Sat Jan 02, 2016 3:20 pm
I have been able to rename it but still unable to delete it and received the same error. Here are the details:
java.sql.SQLException: DELETE on table 'MMY_ACCOUNT' caused a violation of foreign key constraint 'F_MMY_FOLIO_ACCNT' for key (1). The statement has been rolled back.
DELETE FROM MMY_ACCOUNT WHERE MMY_ACCOUNT.ID=1
at MoneyRuntimeException.DELETE on table 'MMY_ACCOUNT' caused a violation of foreign key constraint 'F_MMY_FOLIO_ACCNT' for key (1). The statement has been rolled back.
DELETE FROM MMY_ACCOUNT WHERE MMY_ACCOUNT.ID=1(Original Exception::0)
at com.mth.mymoney.db.LoggableStatement.executeUpdate(LoggableStatement.java:441)
at com.mth.mymoney.shared.datatypes.dao.IdentifiableDAO.deleteRecord(IdentifiableDAO.java:669)
at com.mth.mymoney.shared.datatypes.dao.IdentifiableDAO.deleteRecord(IdentifiableDAO.java:609)
at com.mth.mymoney.shared.datatypes.dao.AccountDAO.delete(AccountDAO.java:1044)
at com.mth.mymoney.ui.actions.AccountsTableActions$actionDeleteEntry.actionPerformed(AccountsTableActions.java:461)
at com.mth.mymoney.core.SystemActionHub.routeCommand(SystemActionHub.java:228)
at com.mth.mymoney.core.SystemActionHub.actionPerformed(SystemActionHub.java:181)
at javax.swing.AbstractButton.fireActionPerformed(AbstractButton.java:2018)
at javax.swing.AbstractButton$Handler.actionPerformed(AbstractButton.java:2341)
at javax.swing.DefaultButtonModel.fireActionPerformed(DefaultButtonModel.java:402)
at javax.swing.DefaultButtonModel.setPressed(DefaultButtonModel.java:259)
at javax.swing.plaf.basic.BasicButtonListener.mouseReleased(BasicButtonListener.java:252)
at com.jidesoft.plaf.basic.BasicJideButtonListener.mouseReleased(Unknown Source)
at java.awt.AWTEventMulticaster.mouseReleased(AWTEventMulticaster.java:289)
at java.awt.Component.processMouseEvent(Component.java:6516)
at javax.swing.JComponent.processMouseEvent(JComponent.java:3320)
at java.awt.Component.processEvent(Component.java:6281)
at java.awt.Container.processEvent(Container.java:2229)
at java.awt.Component.dispatchEventImpl(Component.java:4872)
at java.awt.Container.dispatchEventImpl(Container.java:2287)
at java.awt.Component.dispatchEvent(Component.java:4698)
at java.awt.LightweightDispatcher.retargetMouseEvent(Container.java:4832)
at java.awt.LightweightDispatcher.processMouseEvent(Container.java:4492)
at java.awt.LightweightDispatcher.dispatchEvent(Container.java:4422)
at java.awt.Container.dispatchEventImpl(Container.java:2273)
at java.awt.Window.dispatchEventImpl(Window.java:2719)
at java.awt.Component.dispatchEvent(Component.java:4698)
at java.awt.EventQueue.dispatchEventImpl(EventQueue.java:735)
at java.awt.EventQueue.access$200(EventQueue.java:103)
at java.awt.EventQueue$3.run(EventQueue.java:694)
at java.awt.EventQueue$3.run(EventQueue.java:692)
at java.security.AccessController.doPrivileged(Native Method)
at java.security.ProtectionDomain$1.doIntersectionPrivilege(ProtectionDomain.java:76)
at java.security.ProtectionDomain$1.doIntersectionPrivilege(ProtectionDomain.java:87)
at java.awt.EventQueue$4.run(EventQueue.java:708)
at java.awt.EventQueue$4.run(EventQueue.java:706)
at java.security.AccessController.doPrivileged(Native Method)
at java.security.ProtectionDomain$1.doIntersectionPrivilege(ProtectionDomain.java:76)
at java.awt.EventQueue.dispatchEvent(EventQueue.java:705)
at com.mth.mymoney.thread.SmartEventQueue.dispatchEvent(SmartEventQueue.java:95)
at java.awt.EventDispatchThread.pumpOneEventForFilters(EventDispatchThread.java:242)
at java.awt.EventDispatchThread.pumpEventsForFilter(EventDispatchThread.java:161)
at java.awt.EventDispatchThread.pumpEventsForHierarchy(EventDispatchThread.java:150)
at java.awt.EventDispatchThread.pumpEvents(EventDispatchThread.java:146)
at java.awt.EventDispatchThread.pumpEvents(EventDispatchThread.java:138)
at java.awt.EventDispatchThread.run(EventDispatchThread.java:91)