Hi,
I installed JIRA Standalone on Windows Server 2003. I linked it to SQL Server 2008 R2 Database and it worked fine. Unfortunatly I restart the Jira server without stopping Jira service and since I have a 404 not found page when I try to connect to it.
I tried to restart the service and it is OK but it is impossible to acces to Jira.
When I check atlassian-jira.log, there is an error:
main ERROR [NoModule] Error getting datasource via DBCP: JdbcDatasourceInfo{uri='jdbc:jtds:sqlserver://SRVSQLSHAP:1433/JIRA', driverClassName='net.sourceforge.jtds.jdbc.Driver', username='SaV7', password='********', isolationLevel='null', connectionProperties=null, connectionPoolInfo=ConnectionPoolInfo{maxSize=20, minSize=20, initialSize=null, maxIdle=20, maxWait=30000, sleepTime=300000, lifeTime=600000, deadLockMaxWait=600000, deadLockRetryWait=10000, validationQuery=null, minEvictableTimeMillis=null, timeBetweenEvictionRunsMillis=null, poolPreparedStatements=null, testOnBorrow=null, testOnReturn=null, testWhileIdle=null, maxOpenPreparedStatements=null, numTestsPerEvictionRun=null, removeAbandonedTimeout=300, validationQueryTimeout=null, defaultCatalog=null}}
org.apache.commons.dbcp.SQLNestedException: Cannot create PoolableConnectionFactory (Network error IOException: Connection timed out: connect)
Could you tell me what is the problem?
Thanks.
BR
The error is pretty clear - your Jira server cannot connect to your database. You'll need to check the network connections and the parameters you're passing in.
If this is occuring after a system reboot, you may be running into the situation that the JIRA service is trying to start up before the database is ready for it. You might consider placing a delay or a dependency on your JIRA service, as described here (and here, for the delay). (I realize this is an old question, but I put this here in case others are having the same problem -- as I did this morning.)
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.