House of Fusion
Search over 2,500 ColdFusion resources here
  
Home of the ColdFusion Community

Mailing Lists
Home /  Groups /  ColdFusion Talk (CF-Talk)

Annoying SequeLink JDBC Driver failure

  << Previous Post |  RSS |  Sort Oldest First |  Sort Latest First |  Subscribe to this Group Next >> 
Richard Meredith-Hardy wrote:
Jochem van Dieten
06/05/08 08:41 A
Jochem
Richard Meredith-Hardy
06/06/08 03:50 A
Top  |   Reply  |   Original Post  |   RSS Feed  |   Subscribe to this Group
Author:
Richard Meredith-Hardy
06/05/2008 07:38 AM

I have a CF8 app which gets updates from an ancient ODBC datasource at 15 min intervals.  Generally it works fine, but once or twice a week it gets the error: Error Type: Database Message: Error Executing Database Query. Detail: [Macromedia][SequeLink JDBC Driver][ODBC Socket][TSODBC]FrameRead:NetRead header This is unavoidable and could be caused by any number of reasons, primarily because the datasource is the other side of London, but what happens next is the problem; from then onwards CF8 seems to get 'stuck' with the error: Error Type: Database Message: Error Executing Database Query. Detail: [Macromedia][SequeLink JDBC Driver]An internal error occurred. And it seems at least a CF8 service restart and sometimes a complete server reboot is the only thing which will fix it. Has anyone any ideas how to reset the SequeLink JDBC Driver in a more graceful fashion?  Preferably automatically.... Regards Richard

Top  |   Parent  |   Reply  |   Original Post  |   RSS Feed  |   Subscribe to this Group
Author:
Jochem van Dieten
06/05/2008 08:41 AM

Richard Meredith-Hardy wrote: ----- Excess quoted text cut - see Original Post for more ----- Looks like this error is actually in the ODBC network driver. > And it seems at least a CF8 service restart and sometimes a complete > server reboot is the only thing which will fix it. > > Has anyone any ideas how to reset the SequeLink JDBC Driver in a more > graceful fashion?  Preferably automatically.... Since the ODBC network driver is loaded in the ODBC Server process I would expect a restart of the ODBC Service to fix any problems between the ODBC Service and the remote database. Just uncheck the maintain connection checkbox for the connection between CF and the ODBC Service to make sure that connection gets reset every time (I don't think that will have significant performance impact compared to talking to a remote database). Jochem

Top  |   Parent  |   Reply  |   Original Post  |   RSS Feed  |   Subscribe to this Group
Author:
Richard Meredith-Hardy
06/06/2008 03:50 AM

Jochem maintain connection: What a good idea - didn't occur to me.  I'll try it.   Thanks Richard ----- Excess quoted text cut - see Original Post for more -----


<< Previous Thread Today's Threads Next Thread >>

Search cf-talk

November 21, 2014

<<   <   Today   >   >>
Su Mo Tu We Th Fr Sa
             1
2 3 4 5 6 7 8
9 10 11 12 13 14 15
16 17 18 19 20 21 22
23 24 25 26 27 28 29
30             

Designer, Developer and mobile workflow conference