POST
|
Hello, I have to add flex viewer in my geoportal. I configure \webapps\flexviewer\apps\fr_FR\config.xml of flex viewer. I add my MapServer but it does not display if my mapserver is "tiled". It displays when type="dynamic". [HTML]<basemaps> <layer label="Topo" type="dynamic" visible="true" url="http://...[/HTML] My coordinate system is Lambert93 (Spatial Reference: 2154) How I can to change system of projection by default of viewer ? Because I 'll want to put type="tired". Thank you.
... View more
05-19-2011
12:13 AM
|
0
|
0
|
671
|
POST
|
I noticed that SQL server receives no request when I connect me with the geoportal
... View more
05-09-2011
11:06 PM
|
0
|
0
|
779
|
POST
|
I use dbVisualizer from the tomcat machine and I point to the same database driver that is in Tomcat/lib. I don't now if I have a 2nd database driver that might be conflicting. This would indicate that the username logon is not allowed/configured to remotely log in to your SQL Server. With dbVisualizer, I use the same user and password. And It's OK.
... View more
05-09-2011
03:43 AM
|
0
|
0
|
779
|
POST
|
I use dbVisualizer from the tomcat machine and I point to the same database driver that is in Tomcat/lib. I don't now if I have a 2nd database driver that might be conflicting. With dBVisualizer you are pointing to the same database driver that is in Tomcat/lib? Then I would next look through Tomcat/lib and Tomcat/webapps/geoportal/WEB-INF/lib and make sure you don't have a 2nd database driver that might be conflicting.
... View more
05-09-2011
03:31 AM
|
0
|
0
|
779
|
POST
|
I tryed Dbvizualizer and with this software, I can connect me with tcp port 1354. But with geoportal, this error appear : Cannot create PoolableConnectionFactory (�?chec de l'ouverture de session de l'utilisateur ''. L'utilisateur n'est pas associé à une connexion SQL Server approuvée.) I use exactly the same user, password, database, driver ... I don't understand why it work with dbvizualizer but not SQL Server ... I would strongly recommend you stick to a JDBC driver and JDBC url connection. Another tool to try (with the goal of getting the JDBC driver/url combination correct for your system) is DbVisualizer. It would allow you to choose a driver and quickly test different connection strings. Still, I think the primary focus needs to be determining which TCP port your SQLServer database machine is configured to accept outside connections.
... View more
05-06-2011
04:06 AM
|
0
|
0
|
779
|
POST
|
The problem is that I can not have access firewall, nor cnfiguration sql server. The persons of this service are in vacancy. I can only to use ODBC
... View more
05-03-2011
06:29 AM
|
0
|
0
|
777
|
POST
|
Thanks you, but now I have not the choice. I owe to use odbc connection. <!-- Context configuration file for the Geoportal Web App -->
<Context docBase="geoportal" path="/geoportal" debug="0" reloadable="true" crossContext="true">
<Resource name="jdbc/gpt" auth="Container" type="javax.sql.DataSource"
driverClassName="sun.jdbc.odbc.JdbcOdbcDriver"
url="jdbc:odbc:geoportal"
user="admincarto54"
password="xxxxxxxxxx"
maxActive="20"
maxIdle="10"
maxWait="-1" />
</Context> I created odbc system connection. His name is geoportal Now, I have this error : Cannot create PoolableConnectionFactory ([Microsoft][Gestionnaire de pilotes ODBC] Source de données introuvable et nom de pilote non spécifié)
... View more
05-03-2011
05:02 AM
|
0
|
0
|
777
|
POST
|
I have to change the port (1431) in SQL Server and geoportal.xml but I always have the same error 2 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 cartosql Z:\tomcat6\webapps\geocarto54
... View more
05-02-2011
01:36 AM
|
0
|
0
|
2144
|
POST
|
ATTENTION: [SYNCHRONIZER] Error fetching next task org.apache.tomcat.dbcp.dbcp.SQLNestedException: Cannot create PoolableConnectionFactory (The TCP/IP connection to the host CARTOSQL, port 1433 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 1433 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 I don't understand all, can you help me please with this errors ? thank you
... View more
04-22-2011
05:58 AM
|
0
|
0
|
2144
|
POST
|
I downloaded geoportal-1.1.zip, I use tomcat6 and Yes I have the rights. <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:1433;databaseName=carto54"
user="admin"
password="admin"
maxActive="20"
maxIdle="10"
maxWait="-1" />
</Context> Z:\tomcat6\webapps\geocarto54 My database is carto54, server is CARTOSQL I download sqljdbc4.jar, I copy the database jdbc driver whitin tomcat6\lib
... View more
04-22-2011
12:50 AM
|
0
|
0
|
2144
|
POST
|
Hello, I installed GeoPortal but still having the problem when I connect me: Cannot create JDBC driver of class '' for connect URL 'null' How can I to do !?
... View more
04-20-2011
06:29 AM
|
0
|
22
|
10971
|
Online Status |
Offline
|
Date Last Visited |
11-11-2020
02:23 AM
|