{"action":"opened","issue":{"url":"https://api.github.com/repos/bd2kccd/ccd-annotations-cytoscape/issues/45","repository_url":"https://api.github.com/repos/bd2kccd/ccd-annotations-cytoscape","labels_url":"https://api.github.com/repos/bd2kccd/ccd-annotations-cytoscape/issues/45/labels{/name}","comments_url":"https://api.github.com/repos/bd2kccd/ccd-annotations-cytoscape/issues/45/comments","events_url":"https://api.github.com/repos/bd2kccd/ccd-annotations-cytoscape/issues/45/events","html_url":"https://github.com/bd2kccd/ccd-annotations-cytoscape/issues/45","id":313057637,"number":45,"title":"SQL batch mode exception","user":{"login":"marksilvis","id":4442580,"avatar_url":"https://avatars0.githubusercontent.com/u/4442580?v=4","gravatar_id":"","url":"https://api.github.com/users/marksilvis","html_url":"https://github.com/marksilvis","followers_url":"https://api.github.com/users/marksilvis/followers","following_url":"https://api.github.com/users/marksilvis/following{/other_user}","gists_url":"https://api.github.com/users/marksilvis/gists{/gist_id}","starred_url":"https://api.github.com/users/marksilvis/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/marksilvis/subscriptions","organizations_url":"https://api.github.com/users/marksilvis/orgs","repos_url":"https://api.github.com/users/marksilvis/repos","events_url":"https://api.github.com/users/marksilvis/events{/privacy}","received_events_url":"https://api.github.com/users/marksilvis/received_events","type":"User","site_admin":false},"labels":[{"id":616824403,"url":"https://api.github.com/repos/bd2kccd/ccd-annotations-cytoscape/labels/bug","name":"bug","color":"ee0701","default":true},{"id":746716560,"url":"https://api.github.com/repos/bd2kccd/ccd-annotations-cytoscape/labels/db","name":"db","color":"55dbd4","default":false}],"state":"open","locked":false,"assignee":null,"assignees":[],"milestone":null,"comments":0,"created_at":"2018-04-10T19:25:32Z","updated_at":"2018-04-10T19:25:32Z","closed_at":null,"author_association":"COLLABORATOR","body":"When opening Cytoscape and starting a new session with an empty network I receive an `SQLException` due to the statement not being in batch mode.\r\n\r\nHere is the entire stack trace:\r\n```\r\njava.sql.SQLException: statement is not in batch mode\r\n\tat org.hsqldb.jdbc.JDBCUtil.sqlException(Unknown Source)\r\n\tat org.hsqldb.jdbc.JDBCUtil.sqlException(Unknown Source)\r\n\tat org.hsqldb.jdbc.JDBCUtil.sqlExceptionSQL(Unknown Source)\r\n\tat org.hsqldb.jdbc.JDBCPreparedStatement.executeBatch(Unknown Source)\r\n\tat edu.pitt.cs.admt.cytoscape.annotations.db.StorageDelegate.insertNodes(StorageDelegate.java:139)\r\n\tat edu.pitt.cs.admt.cytoscape.annotations.db.NetworkStorageUtility.importToDatabase(NetworkStorageUtility.java:22)\r\n\tat edu.pitt.cs.admt.cytoscape.annotations.network.NetworkListener.handleEvent(NetworkListener.java:131)\r\n\tat sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)\r\n\tat sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)\r\n\tat sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)\r\n\tat java.lang.reflect.Method.invoke(Method.java:498)\r\n\tat org.cytoscape.event.internal.CyListenerAdapter.fireEvent(CyListenerAdapter.java:120)\r\n\tat org.cytoscape.event.internal.CyEventHelperImpl.fireEvent(CyEventHelperImpl.java:84)\r\n\tat org.cytoscape.view.model.internal.CyNetworkViewManagerImpl.fireEvent(CyNetworkViewManagerImpl.java:204)\r\n\tat org.cytoscape.view.model.internal.CyNetworkViewManagerImpl.addNetworkView(CyNetworkViewManagerImpl.java:193)\r\n\tat org.cytoscape.view.model.internal.CyNetworkViewManagerImpl.addNetworkView(CyNetworkViewManagerImpl.java:164)\r\n\tat org.cytoscape.task.internal.creation.NewEmptyNetworkTask.run(NewEmptyNetworkTask.java:205)\r\n\tat org.cytoscape.work.internal.task.JDialogTaskManager$TaskRunnable.innerRun(JDialogTaskManager.java:326)\r\n\tat org.cytoscape.work.internal.task.JDialogTaskManager$TaskRunnable.run(JDialogTaskManager.java:355)\r\n\tat java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:511)\r\n\tat java.util.concurrent.FutureTask.run(FutureTask.java:266)\r\n\tat java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149)\r\n\tat java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624)\r\n\tat java.lang.Thread.run(Thread.java:748)\r\nCaused by: org.hsqldb.HsqlException: statement is not in batch mode\r\n\tat org.hsqldb.error.Error.error(Unknown Source)\r\n\tat org.hsqldb.error.Error.error(Unknown Source)\r\n\t... 22 more\r\n```"}}
{"actor":{"display_login":"marksilvis"}}