topic java.sql.SQLException: Can't create/write to file 'D:\temp\ in Alfresco Archive

java.sql.SQLException: Can't create/write to file 'D:\temp\

mahanare — Thu, 18 Dec 2008 13:40:48 GMT

Hi,After installing the latest community download, i am not able to start the server. It shows error and and it is not coming up.Here is a snippet from the exception stacktrace while starting the tomcat. It was actually throwing this error to c:\windows\temp folder, but then in changed the directory

Re: java.sql.SQLException: Can't create/write to file 'D:\temp\

pmonks — Thu, 18 Dec 2008 17:56:06 GMT

<disclaimer>
This is an issue with MySQL, so you will probably get more accurate information from their forums.
</disclaimer>

That said, I get this error occasionally too and in my case it appears to be caused by a problematic interaction between the virus scanner I have installed and the MySQL server. It's infrequent enough that I just live with it, but it is somewhat annoying and I wasn't able to find any better solutions / workarounds from my (albeit limited) trawling of the MySQL forums (short of shutting off my virus scanner, which I'm unwilling to do).

If you do find out further details from MySQL it'd be great if you could post them back here!

Cheers,
Peter

Re: java.sql.SQLException: Can't create/write to file 'D:\temp\

chraja — Thu, 08 Jan 2009 17:25:03 GMT

this is a MySql problem, Excluding the Temp folder from the MacAfee scan list solved the problem for me .

If not MacAfee , I guess there could be some other application which restricts writing this file into temp folder .

Here is the post related to the issue
http://forums.alfresco.com/en/viewtopic.php?f=4&t=5369