connection closed exception on query after several successful INSERTS with...
A pure Java JDBC driver for Microsoft Access database files
Brought to you by:
jamadei
Menu
▾
▴
I've encountered an exception error on a simple lookup query using ucanaccess-2.0.9.5 with hsqldb.jar and jackcess-.2.1.3 (developed in NetBeans 7.0.1). It had been working fine for several months but recently it occurs after several successful INSERTS and I am unable to figure this out.
Can anybody help me with this? I cannot find any reference to this error anywhere in online searchs!
Here is the dump:
IN LOADARRAYS WILL EXEC QUERY [SELECT [PatientLastName],[PatientFirstName],[PatientMI],[PatientBirthDate],[PatientStreetAddress],[PatientCity],[PatientSex],[PatientState],[PatientZipCode],[PatientPhoneNo],[PatientMarriedStatus],[PatientAccountNo],[SubscriberSSN],[PatientMemberID],[NameOfReferringProvider],[InsuredIDNo],[InsuredGroupNo],[InsuredEmployerName],[InsuredName],[InsuredPlanName],[InsuredDOB],[InsuredStreetAddress],[InsuredCity],[InsuredZipCode],[InsuredSex],[InsuredPhoneNo],[PrimaryPayerFKey],[SecondaryPayerFKey],[RenderingProviderFID],[PatientDateTimeCreated],[PatientDateTimeModified],[PatientID],[ContractID],[InsCardEffective],[InsCardTerminate],[PatientRel],[InsuredState],[PhoneNumberCell],[PhoneNumberWork],[PriorAuthorizationNo],[DefaultPlace],[DefaultModifier],[DefaultType],[Diagnosis1],[Diagnosis2],[Diagnosis3],[Diagnosis4],[Diagnosis5],[Diagnosis6],[Diagnosis7],[Diagnosis8],[CoPayAmount],[CoPayPercent],[CodeLibraryName],[DateOfInjury],[ReferringProviderFID],[FacilityFID],[PatientNotes],[PatientSigOnFile],[InsuranceType],[InsuredSigOnFile],[AnotherPlan],[AcceptAssignment],[DefaultDiagnosisCode],[DefaultCharge],[DefaultDays],[PrintSigDate],[DefaultfDays],[PriClaimFilingInd],[PrintHCFAForm],[DefaultProcedure],[DefaultClaimTemplate],[BillingProviderFID],[PhysicianSigOnFile],[Active],[bPhysicianPrintDate] FROM [Patient Table] WHERE (PatientAccountNo = '238911')] OF EZData.mdb
SQLException in loading mdb e = net.ucanaccess.jdbc.UcanaccessSQLException: connection exception: closed
at net.ucanaccess.jdbc.UcanaccessConnection.flushIO(UcanaccessConnection.java:317)
at net.ucanaccess.jdbc.UcanaccessConnection.commit(UcanaccessConnection.java:207)
at net.ucanaccess.jdbc.AbstractExecute.executeBase(AbstractExecute.java:147)
at net.ucanaccess.jdbc.Execute.execute(Execute.java:52)
at net.ucanaccess.jdbc.UcanaccessStatement.execute(UcanaccessStatement.java:143)
at absnjcmodaemon.ABSUCanAccess.getDBResults(ABSUCanAccess.java:131)
at absnjcmodaemon.ABSUCanAccess.doUpdateRec(ABSUCanAccess.java:298)
at absnjcmodaemon.ABSNJCMODaemonView.ProcessImportFile(ABSNJCMODaemonView.java:1571)
at absnjcmodaemon.ABSNJCMODaemonView.ImportNewClaims(ABSNJCMODaemonView.java:1056)
at absnjcmodaemon.ABSNJCMODaemonView.runImports(ABSNJCMODaemonView.java:2966)
at absnjcmodaemon.ABSNJCMODaemonView.access$300(ABSNJCMODaemonView.java:49)
at absnjcmodaemon.ABSNJCMODaemonView$4.actionPerformed(ABSNJCMODaemonView.java:2503)
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 java.awt.Component.processMouseEvent(Component.java:6505)
at javax.swing.JComponent.processMouseEvent(JComponent.java:3320)
at java.awt.Component.processEvent(Component.java:6270)
at java.awt.Container.processEvent(Container.java:2229)
at java.awt.Component.dispatchEventImpl(Component.java:4861)
at java.awt.Container.dispatchEventImpl(Container.java:2287)
at java.awt.Component.dispatchEvent(Component.java:4687)
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:4687)
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 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)
The stacktrace doesn't help. Could you create something reproduceable? What if you do the same insert via ucanaccess console? And with the 3.0.3.1?
Last edit: Marco Amadei 2016-02-12
Sorry, I'm not familiar with the ucanaccess console.
I was not aware that there was a newer version of ucanaccess.
I'll try that one to see if there's any improvement. I assume I'll I need newer versions of jackcess and hsqldb as well?