Quoting Frank Mamone <[EMAIL PROTECTED]>:
> Hi,
>
> Everytime I re-start CF services the DSN's no longer work. I need to
> go into edit mode with each one and re-submit to make them work.
> Recreating doesn't help either. I'm thinking there's something wrong
> with the datasource xml file and maybe deleting it and recreating
> datasources.
That should be easy to find out. Is the datasource information
different when they work? Just compare the output of:
<cflock name="serviceFactory" type="exclusive" timeout="10">
<cfscript>
factory = CreateObject("java", "coldfusion.server.ServiceFactory");
ds_service = factory.datasourceservice;
dsources = ds_service.datasources;
</cfscript>
<cfdump var="#dsources#">
</cflock>
Taking a small leap of faith here from something I read the other day
but haven't played with yet, it might be easier to compare the
hashcodes:
<cflock name="serviceFactory" type="exclusive" timeout="10">
<cfscript>
factory = CreateObject("java", "coldfusion.server.ServiceFactory");
ds_service = factory.datasourceservice;
dsources = ds_service.datasources;
</cfscript>
<cfdump var="#dsources.hashcode()#">
</cflock>
If there is a difference, it might be possible to solve it by
restarting just the datasourceservice, instead of the entire CF MX
Service:
<cflock name="serviceFactory" type="exclusive" timeout="10">
<cfscript>
factory = CreateObject("java", "coldfusion.server.ServiceFactory");
ds_service = factory.datasourceservice;
ds_service.restart();
</cfscript>
</cflock>
BTW, are all your datsources not working anymore or just those with a
certain driver?
Jochem
______________________________________________________________________
Your ad could be here. Monies from ads go to support these lists and provide more
resources for the community. http://www.fusionauthority.com/ads.cfm
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/[email protected]/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
