• Open Menu Close Menu
  • Apple
  • Shopping Bag
  • Apple
  • Mac
  • iPad
  • iPhone
  • Watch
  • TV
  • Music
  • Support
  • Search apple.com
  • Shopping Bag

Lists

Open Menu Close Menu
  • Terms and Conditions
  • Lists hosted on this site
  • Email the Postmaster
  • Tips for posting to public mailing lists
SQL Error
[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

SQL Error

  • Subject: SQL Error
  • From: David Griffith <email@hidden>
  • Date: Mon, 2 Apr 2007 11:13:21 +0200
Hi all,

Things have been working well for over a year and now suddenly I have started to get this error:

com.webobjects.eoaccess.EOGeneralAdaptorException: EvaluateExpression failed: <com.webobjects.jdbcadaptor.MySQLPlugIn$MySQLExpression: "UPDATE WEB_HOSTING SET WH_NEXT_RENEWAL_DATE = ?, WH_SIGN_UP_DATE = ? WHERE (WH_ID = ? AND WH_CUSTOMER_ID = ? AND WH_HOSTING_PLAN_ID = ? AND WH_SIGN_UP_DATE is NULL AND WH_NEXT_RENEWAL_DATE is NULL AND WH_HOSTING_ACTIVE = ? AND WH_DOMAIN_NAME = ? AND WH_IVA_RATE_ID = ?)" withBindings: 1:2008-03-06 00:00:00(whNextRenewalDate), 2:2005-03-07 00:00:00(whSignUpDate), 3:51(whID), 4:3098(whCustomerID), 5:1(whHostingPlanID), 6:true(whHostingActive), 7:"servicios-mirador.com"(whDomainName), 8:2(whIVARateID)>: Next exception:SQL State:08S01 -- error code: 0 -- msg: Communication link failure: java.io.EOFException, underlying cause: null ** BEGIN NESTED EXCEPTION ** java.io.EOFException STACKTRACE: java.io.EOFException at com.mysql.jdbc.MysqlIO.readFully(MysqlIO.java:1395) at com.mysql.jdbc.MysqlIO.reuseAndReadPacket(MysqlIO.java:1539) at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:1930) at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1168) at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:1279) at com.mysql.jdbc.Connection.execSQL(Connection.java:2281) at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:1825) at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:1667) at com.webobjects.jdbcadaptor.JDBCChannel._bindInputVariablesWithBindingsAndExecute(JDBCChannel.java:229) at com.webobjects.jdbcadaptor.JDBCChannel._evaluateExpression(JDBCChannel.java:303) at com.webobjects.jdbcadaptor.JDBCChannel.updateValuesInRowsDescribedByQualifier(JDBCChannel.java:143) at com.webobjects.eoaccess.EOAdaptorChannel.updateValuesInRowDescribedByQualifier(EOAdaptorChannel.java:637) at com.webobjects.eoaccess.EOAdaptorChannel.performAdaptorOperation(EOAdaptorChannel.java:1403) at com.webobjects.eoaccess.EOAdaptorChannel.performAdaptorOperations(EOAdaptorChannel.java:1481) at com.webobjects.eoaccess.EODatabaseContext._performChangesWithAdaptorOps(EODatabaseContext.java:6270) at com.webobjects.eoaccess.EODatabaseContext.performChanges(EODatabaseContext.java:6376) at com.webobjects.eocontrol.EOObjectStoreCoordinator.saveChangesInEditingContext(EOObjectStoreCoordinator.java:415) at com.webobjects.eocontrol.EOEditingContext.saveChanges(EOEditingContext.java:3187) at er.extensions.ERXEC.saveChanges(ERXEC.java:467) at UpdateCustomerHosting.saveChanges(UpdateCustomerHosting.java:108) at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source) at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source) at java.lang.reflect.Method.invoke(Unknown Source) at KeyValueCodingProtectedAccessor.methodValue(KeyValueCodingProtectedAccessor.java:54) at com.webobjects.foundation.NSKeyValueCoding$_MethodBinding.valueInObject(NSKeyValueCoding.java:1160) at com.webobjects.foundation.NSKeyValueCoding$DefaultImplementation.valueForKey(NSKeyValueCoding.java:1268) at com.webobjects.appserver.WOComponent.valueForKey(WOComponent.java:1539) at com.webobjects.foundation.NSKeyValueCoding$Utility.valueForKey(NSKeyValueCoding.java:498) at com.webobjects.foundation.NSKeyValueCodingAdditions$DefaultImplementation.valueForKeyPath(NSKeyValueCodingAdditions.java:212) at com.webobjects.appserver.WOComponent.valueForKeyPath(WOComponent.java:1600) at com.webobjects.appserver._private.WOKeyValueAssociation.valueInComponent(WOKeyValueAssociation.java:46) at com.webobjects.appserver._private.WOSubmitButton.invokeAction(WOSubmitButton.java:59) at com.webobjects.appserver._private.WODynamicGroup.invokeChildrenAction(WODynamicGroup.java:101) at com.webobjects.appserver._private.WODynamicGroup.invokeAction(WODynamicGroup.java:110) at com.webobjects.appserver._private.WOForm.invokeAction(WOForm.java:82) at com.webobjects.appserver._private.WODynamicGroup.invokeChildrenAction(WODynamicGroup.java:101) at com.webobjects.appserver._private.WODynamicGroup.invokeAction(WODynamicGroup.java:110) at com.webobjects.appserver._private.WOConditional.invokeAction(WOConditional.java:55) at com.webobjects.appserver._private.WODynamicGroup.invokeChildrenAction(WODynamicGroup.java:101) at com.webobjects.appserver._private.WODynamicGroup.invokeAction(WODynamicGroup.java:110) at com.webobjects.appserver.WOComponent.invokeAction(WOComponent.java:945) at com.webobjects.appserver._private.WOComponentReference.invokeAction(WOComponentReference.java:104) at com.webobjects.appserver._private.WODynamicGroup.invokeChildrenAction(WODynamicGroup.java:101) at com.webobjects.appserver._private.WODynamicGroup.invokeAction(WODynamicGroup.java:110) at com.webobjects.appserver._private.WOConditional.invokeAction(WOConditional.java:55) at com.webobjects.appserver._private.WODynamicGroup.invokeChildrenAction(WODynamicGroup.java:101) at com.webobjects.appserver._private.WODynamicGroup.invokeAction(WODynamicGroup.java:110) at com.webobjects.appserver._private.WOComponentContent.invokeAction(WOComponentContent.java:31) at com.webobjects.appserver._private.WODynamicGroup.invokeChildrenAction(WODynamicGroup.java:101) at com.webobjects.appserver._private.WODynamicGroup.invokeAction(WODynamicGroup.java:110) at com.webobjects.appserver._private.WOHTMLURLValuedElement.invokeAction(WOHTMLURLValuedElement.java:115) at com.webobjects.appserver._private.WODynamicGroup.invokeChildrenAction(WODynamicGroup.java:101) at com.webobjects.appserver._private.WODynamicGroup.invokeAction(WODynamicGroup.java:110) at com.webobjects.appserver.WOComponent.invokeAction(WOComponent.java:945) at com.webobjects.appserver._private.WOComponentReference.invokeAction(WOComponentReference.java:104) at com.webobjects.appserver._private.WODynamicGroup.invokeChildrenAction(WODynamicGroup.java:101) at com.webobjects.appserver._private.WODynamicGroup.invokeAction(WODynamicGroup.java:110) at com.webobjects.appserver.WOComponent.invokeAction(WOComponent.java:945) at com.webobjects.appserver.WOSession.invokeAction(WOSession.java:1168) at com.webobjects.appserver.WOApplication.invokeAction(WOApplication.java:1375) at com.webobjects.appserver._private.WOComponentRequestHandler._dispatchWithPreparedPage(WOComponentRequestHandler.java:196) at com.webobjects.appserver._private.WOComponentRequestHandler._dispatchWithPreparedSession(WOComponentRequestHandler.java:287) at com.webobjects.appserver._private.WOComponentRequestHandler._dispatchWithPreparedApplication(WOComponentRequestHandler.java:322) at com.webobjects.appserver._private.WOComponentRequestHandler._handleRequest(WOComponentRequestHandler.java:358) at com.webobjects.appserver._private.WOComponentRequestHandler.handleRequest(WOComponentRequestHandler.java:432) at com.webobjects.appserver.WOApplication.dispatchRequest(WOApplication.java:1306) at com.webobjects.appserver._private.WOWorkerThread.runOnce(WOWorkerThread.java:173) at com.webobjects.appserver._private.WOWorkerThread.run(WOWorkerThread.java:254) at java.lang.Thread.run(Unknown Source) ** END NESTED EXCEPTION **

It seems to be some kind of error communicating with the database?  It happens fairly regularly but not always.  Does anyone have any pointers as to what this might be?

Kind regards,
David.
 _______________________________________________
Do not post admin requests to the list. They will be ignored.
Webobjects-dev mailing list      (email@hidden)
Help/Unsubscribe/Update your Subscription:

This email sent to email@hidden
  • Follow-Ups:
    • Re: SQL Error
      • From: "Jerry W. Walker" <email@hidden>
  • Prev by Date: Re: Problem in using WOConditional with in a WORepitition
  • Next by Date: Re: Generate HTML from a WOComponent programmatically
  • Previous by thread: Re: Problem in using WOConditional with in a WORepitition
  • Next by thread: Re: SQL Error
  • Index(es):
    • Date
    • Thread