History | Log In     View a printable version of the current page.  
Issue Details (XML | Word | Printable)

Key: JRA-6872
Type: Bug Bug
Status: Resolved Resolved
Resolution: Invalid
Priority: Major Major
Assignee: Unassigned
Reporter: Jeff Turner [Atlassian]
Votes: 0
Watchers: 0
Operations

If you were logged in you would be able to see more operations.
JIRA

Database errors with MS SQL Server: Error establishing socket

Created: 02/Jun/05 03:17 AM   Updated: 30/Jul/06 07:37 PM
Component/s: Backend / Domain Model
Affects Version/s: None
Fix Version/s: None

Time Tracking:
Not Specified

Environment: Microsoft JDBC driver sp2
Issue Links:
Reference
 

Participants: Jeff Turner [Atlassian]
Since last comment: 163 weeks, 6 days ago
Resolution Date: 02/Jun/05 03:19 AM
Labels:


 Description  « Hide
Various users have reported (eg. http://forums.atlassian.com/thread.jspa?messageID=257216865곴?) getting intermittent errors with the MS JDBC driver:

Exception reindexing: com.atlassian.jira.issue.index.IndexException:
Error: com.atlassian.jira.exception.DataAccessException:
org.ofbiz.core.entity.GenericDataSourceException: Unable to esablish a
connection with the database. ([Microsoft][SQLServer 2000 Driver for
JDBC]Error establishing socket.)

or:

  • javax.servlet.error.message : Unable to esablish a connection with the database. ([Microsoft][SQLServer 2000 Driver for JDBC]Error establishing socket.)<p><small><small><pre>com.opensymphony.module.propertyset.PropertyImplementationException: Unable to esablish a connection with the database. ([Microsoft][SQLServer 2000 Driver for JDBC]Error establishing socket.) at com.opensymphony.module.propertyset.ofbiz.OFBizPropertySet.findPropertyEntry(OFBizPropertySet.java:231) at com.opensymphony.module.propertyset.ofbiz.OFBizPropertySet.setImpl(OFBizPropertySet.java:167) at com.opensymphony.module.propertyset.AbstractPropertySet.set(AbstractPropertySet.java:570) at com.opensymphony.module.propertyset.AbstractPropertySet.setString(AbstractPropertySet.java:368) at com.atlassian.jira.propertyset.JiraCachingPropertySet.setString(JiraCachingPropertySet.java:317) at com.atlassian.jira.config.properties.ApplicationPropertiesImpl.setString(ApplicationPropertiesImpl.java:120) at com.atlassian.jira.web.action.setup.Setup.setLanguage(Setup.java:111) at com.atlassian.jira.web.action.setup.Setup.doDefault(Setup.java:58) at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25) at java.lang.reflect.Method.invoke(Method.java:324) at webwork.util.InjectionUtils$DefaultInjectionImpl.invoke(InjectionUtils.java:61) at webwork.util.InjectionUtils.invoke(InjectionUtils.java:52) at webwork.action.ActionSupport.invokeCommand(ActionSupport.java:417) at webwork.action.ActionSupport.execute(ActionSupport.java:146) at com.atlassian.jira.action.JiraActionSupport.execute(JiraActionSupport.java:46) at webwork.dispatcher.GenericDispatcher.executeAction(GenericDispatcher.java:131) at com.atlassian.jira.web.dispatcher.JiraServletDispatcher.service(JiraServletDispatcher.java:186) at javax.servlet.http.HttpServlet.service(HttpServlet.jav


 All   Comments   Work Log   Change History      Sort Order: Ascending order - Click to sort in descending order
Jeff Turner [Atlassian] - 02/Jun/05 03:19 AM
As a JDBC driver bug there is not much we can do except recommend that people use the JTDS drivers instead:

http://jtds.sourceforge.net/

We have never had any problem reports relating to jTDS.