I have to change the port (1431) in SQL Server and geoportal.xml but I always have the same error2 mai 2011 16:19:39 com.esri.gpt.control.webharvest.engine.TaskQueue next
ATTENTION: [SYNCHRONIZER] Error fetching next task
org.apache.tomcat.dbcp.dbcp.SQLNestedException: Cannot create PoolableConnectionFactory (The TCP/IP connection to the host CARTOSQL, port 1431 has failed. Error: Connection refused: connect. Please verify the connection properties and check that a SQL Server instance is running on the host and accepting TCP/IP connections at the port, and that no firewall is blocking TCP connections to the port.)
at org.apache.tomcat.dbcp.dbcp.BasicDataSource.createPoolableConnectionFactory(BasicDataSource.java:1549)
at org.apache.tomcat.dbcp.dbcp.BasicDataSource.createDataSource(BasicDataSource.java:1388)
at org.apache.tomcat.dbcp.dbcp.BasicDataSource.getConnection(BasicDataSource.java:1044)
at com.esri.gpt.framework.sql.DatabaseReference.openJndiConnection(Unknown Source)
at com.esri.gpt.framework.sql.DatabaseReference.openConnection(Unknown Source)
at com.esri.gpt.framework.sql.ManagedConnection.<init>(Unknown Source)
at com.esri.gpt.framework.sql.ManagedConnections.returnConnection(Unknown Source)
at com.esri.gpt.framework.sql.ConnectionBroker.returnConnection(Unknown Source)
at com.esri.gpt.framework.sql.BaseDao.returnConnection(Unknown Source)
at com.esri.gpt.catalog.harvest.jobs.HjGetNextRequest.execute(Unknown Source)
at com.esri.gpt.control.webharvest.engine.TaskQueue.next(Unknown Source)
at com.esri.gpt.control.webharvest.engine.Worker.next(Unknown Source)
at com.esri.gpt.control.webharvest.engine.Worker.execute(Unknown Source)
at com.esri.gpt.control.webharvest.engine.WorkerBase.run(Unknown Source)
at java.lang.Thread.run(Unknown Source)
Caused by: com.microsoft.sqlserver.jdbc.SQLServerException: The TCP/IP connection to the host CARTOSQL, port 1431 has failed. Error: Connection refused: connect. Please verify the connection properties and check that a SQL Server instance is running on the host and accepting TCP/IP connections at the port, and that no firewall is blocking TCP connections to the port.
at com.microsoft.sqlserver.jdbc.SQLServerException.makeFromDriverError(SQLServerException.java:130)
at com.microsoft.sqlserver.jdbc.SQLServerConnection.connectHelper(SQLServerConnection.java:1195)
at com.microsoft.sqlserver.jdbc.SQLServerConnection.loginWithoutFailover(SQLServerConnection.java:1054)
at com.microsoft.sqlserver.jdbc.SQLServerConnection.connect(SQLServerConnection.java:758)
at com.microsoft.sqlserver.jdbc.SQLServerDriver.connect(SQLServerDriver.java:842)
at org.apache.tomcat.dbcp.dbcp.DriverConnectionFactory.createConnection(DriverConnectionFactory.java:38)
at org.apache.tomcat.dbcp.dbcp.PoolableConnectionFactory.makeObject(PoolableConnectionFactory.java:582)
at org.apache.tomcat.dbcp.dbcp.BasicDataSource.validateConnectionFactory(BasicDataSource.java:1556)
at org.apache.tomcat.dbcp.dbcp.BasicDataSource.createPoolableConnectionFactory(BasicDataSource.java:1545)
... 14 more
My file geoportal.xml <!-- Context configuration file for the Geoportal Web App -->
<Context docBase="geocarto54" path="/geocarto54" debug="0" reloadable="true" crossContext="true">
<Resource name="jdbc/gpt" auth="Container" type="javax.sql.DataSource"
driverClassName="com.microsoft.sqlserver.jdbc.SQLServerDriver"
url="jdbc:sqlserver://CARTOSQL:1431;databaseName=carto54"
user="admincarto54"
password="xxxxxxxxx"
maxActive="20"
maxIdle="10"
maxWait="-1" />
</Context>
My database is carto54, server is cartosqlZ:\tomcat6\webapps\geocarto54