Annonce
#1 Wed 17 June 2009 13:01
- bahia_zib
- Juste Inscrit !
- Date d'inscription: 10 Nov 2008
- Messages: 9
PostGIS 3.2 dans Mapguide Studio
Salut à tous,
Voilà maintenant que j'arrive a crée une connexion aux données POSTGIS 3.2 sur mon DEBIAN,
dans mapgude studio (ie maestro) j' n'arrive pas à afficher la classe d'objets !
cf fichier joint
Quelqu'un a-t-il une idée ?
Hors ligne
#2 Wed 17 June 2009 15:00
- bahia_zib
- Juste Inscrit !
- Date d'inscription: 10 Nov 2008
- Messages: 9
Re: PostGIS 3.2 dans Mapguide Studio
si vous souhaité je joins la log FDOpodtgis 3.2 :*
14:58:06:062 (0x00001280) : ==========================================================
Log started on 17.06.2009, at 14:58:06:062
Module: C:\Program Files\MapGuideOpenSource2.0\Server\Bin\MgServer.exe (ProcID: 0x00001364)
Compile time: Sep 11 2007 09:27:10
14:58:06:062 (0x00001280) : ==========================================================
14:58:06:062 (0x00001280) : >>[fdo::postgis::CreateConnection]
14:58:06:062 (0x00001280) : Connection instance ready.
14:58:06:062 (0x00001280) : <<[fdo::postgis::CreateConnection]
14:58:06:062 (0x00001280) : >>[ConnectionInfo::+GetConnectionProperties]
14:58:06:062 (0x00001280) : Creating connection properties:
14:58:06:062 (0x00001280) : 1. Username
14:58:06:062 (0x00001280) : 2. Password
14:58:06:062 (0x00001280) : 3. Service
14:58:06:062 (0x00001280) : 4. DataStore
14:58:06:062 (0x00001280) : <<[ConnectionInfo::+GetConnectionProperties]
14:58:06:062 (0x00001280) : >>[Connection::+SetConnectionString]
14:58:06:062 (0x00001280) : >>[ConnectionInfo::+GetConnectionProperties]
14:58:06:062 (0x00001280) : <<[ConnectionInfo::+GetConnectionProperties]
14:58:06:062 (0x00001280) : Connection string is valid
14:58:06:062 (0x00001280) : <<[Connection::+SetConnectionString]
14:58:06:062 (0x00001280) : >>[Connection::+SetConnectionString]
14:58:06:062 (0x00001280) : >>[ConnectionInfo::+GetConnectionProperties]
14:58:06:062 (0x00001280) : <<[ConnectionInfo::+GetConnectionProperties]
14:58:06:062 (0x00001280) : Connection string is valid
14:58:06:062 (0x00001280) : <<[Connection::+SetConnectionString]
14:58:06:062 (0x00001280) : >>[Connection::+SetConnectionString]
14:58:06:062 (0x00001280) : >>[ConnectionInfo::+GetConnectionProperties]
14:58:06:062 (0x00001280) : <<[ConnectionInfo::+GetConnectionProperties]
14:58:06:062 (0x00001280) : Connection string is valid
14:58:06:062 (0x00001280) : <<[Connection::+SetConnectionString]
14:58:06:062 (0x00001280) : >>[Connection::+SetConnectionString]
14:58:06:062 (0x00001280) : >>[ConnectionInfo::+GetConnectionProperties]
14:58:06:062 (0x00001280) : <<[ConnectionInfo::+GetConnectionProperties]
14:58:06:062 (0x00001280) : Connection string is valid
14:58:06:062 (0x00001280) : <<[Connection::+SetConnectionString]
14:58:06:062 (0x00001280) : >>[Connection::+Open]
14:58:06:062 (0x00001280) : - Start validation of connection properties
14:58:06:062 (0x00001280) : >>[ConnectionInfo::+GetConnectionProperties]
14:58:06:062 (0x00001280) : <<[ConnectionInfo::+GetConnectionProperties]
14:58:06:062 (0x00001280) : >>[ConnectionInfo::+GetConnectionProperties]
14:58:06:062 (0x00001280) : <<[ConnectionInfo::+GetConnectionProperties]
14:58:06:062 (0x00001280) : - OK
14:58:06:062 (0x00001280) : >>[ConnectionInfo::+GetConnectionProperties]
14:58:06:062 (0x00001280) : <<[ConnectionInfo::+GetConnectionProperties]
14:58:06:062 (0x00001280) : Step 1 - start - connecting to PostgreSQL server
14:58:06:062 (0x00001280) : >>[Connection::-GetPgConnectionParams]
14:58:06:062 (0x00001280) : Connection string:
host=10.231.132.19
port=5432
db=SIG
login=postgres
14:58:06:062 (0x00001280) : <<[Connection::-GetPgConnectionParams]
14:58:06:093 (0x00001280) : Step 1 - finish - connection is pending
14:58:06:093 (0x00001280) : Step 2 - start - opening FDO datastore
14:58:06:093 (0x00001280) : >>[Connection::-SetPgCurrentSchema]
14:58:06:093 (0x00001280) : SET search_path TO public, public
14:58:06:093 (0x00001280) : <<[Connection::-SetPgCurrentSchema]
14:58:06:093 (0x00001280) : Step 2 - FDO datastore open: public
14:58:06:093 (0x00001280) : Step 2 - finish
14:58:06:093 (0x00001280) : <<[Connection::+Open]
14:58:06:093 (0x00001280) : >>[Connection::+CreateCommand]
14:58:06:093 (0x00001280) : Command type enumerator: 4
14:58:06:093 (0x00001280) : <<[Connection::+CreateCommand]
14:58:06:093 (0x00001280) : >>[DescribeSchemaCommand::+Execute]
14:58:06:093 (0x00001280) : >>[Connection::+GetLogicalSchema]
14:58:06:093 (0x00001280) : >>[Connection::-DescribeSchema]
14:58:06:093 (0x00001280) : >>[SchemaDescription::+DescribeSchema]
14:58:06:093 (0x00001280) : >>[ConnectionInfo::+GetConnectionProperties]
14:58:06:093 (0x00001280) : <<[ConnectionInfo::+GetConnectionProperties]
14:58:06:093 (0x00001280) : >>[Connection::+PgExecuteQuery]
14:58:06:093 (0x00001280) : SQL:
SELECT current_schema()
14:58:06:093 (0x00001280) : <<[Connection::+PgExecuteQuery]
14:58:06:093 (0x00001280) : >>[PgSpatialTablesReader::+Open]
14:58:06:093 (0x00001280) : >>[Connection::+CreateCommand]
14:58:06:093 (0x00001280) : Command type enumerator: 15
14:58:06:093 (0x00001280) : <<[Connection::+CreateCommand]
14:58:06:093 (0x00001280) : >>[SQLCommand::+SetSQLStatement]
14:58:06:093 (0x00001280) : SQL:
SELECT n.nspname AS schemaname, c.relname AS tablename FROM pg_class c, pg_namespace n, geometry_columns g WHERE c.relkind = 'r' AND c.relname !~ '^(pg_|sql_)' AND c.relnamespace = n.oid AND n.nspname = g.f_table_schema AND c.relname::TEXT = g.f_table_name::TEXT AND n.nspname = 'public' GROUP BY schemaname, tablename
14:58:06:093 (0x00001280) : <<[SQLCommand::+SetSQLStatement]
14:58:06:093 (0x00001280) : >>[SQLCommand::+ExecuteReader]
14:58:06:093 (0x00001280) : >>[Connection::+PgCreateCursor]
14:58:06:093 (0x00001280) : Cursor name (based on time: 20090617T145806.093750): crsSQLCmd_175e93649b29a5eb829ec9dd955c8b34
14:58:06:093 (0x00001280) : <<[Connection::+PgCreateCursor]
14:58:06:093 (0x00001280) : >>[Command::-PgGenerateExecParams]
14:58:06:093 (0x00001280) : Number of parameters: 0
14:58:06:093 (0x00001280) : <<[Command::-PgGenerateExecParams]
14:58:06:093 (0x00001280) : >>[PgCursor::+Declare]
14:58:06:093 (0x00001280) : >>[Connection::+PgBeginSoftTransaction]
14:58:06:093 (0x00001280) : BEGIN TRANSACTION
14:58:06:093 (0x00001280) : <<[Connection::+PgBeginSoftTransaction]
14:58:06:093 (0x00001280) : >>[Connection::+PgExecuteCommand]
14:58:06:093 (0x00001280) : SQL:
DECLARE crssqlcmd_175e93649b29a5eb829ec9dd955c8b34 CURSOR FOR SELECT n.nspname AS schemaname, c.relname AS tablename FROM pg_class c, pg_namespace n, geometry_columns g WHERE c.relkind = 'r' AND c.relname !~ '^(pg_|sql_)' AND c.relnamespace = n.oid AND n.nspname = g.f_table_schema AND c.relname::TEXT = g.f_table_name::TEXT AND n.nspname = 'public' GROUP BY schemaname, tablename
Number of parameters: 0
14:58:06:093 (0x00001280) : Affected tuples: 0
14:58:06:093 (0x00001280) : <<[Connection::+PgExecuteCommand]
14:58:06:093 (0x00001280) : <<[PgCursor::+Declare]
14:58:06:093 (0x00001280) : <<[SQLCommand::+ExecuteReader]
14:58:06:093 (0x00001280) : <<[PgSpatialTablesReader::+Open]
14:58:06:093 (0x00001280) : >>[Connection::+PgExecuteQuery]
14:58:06:093 (0x00001280) : SQL:
FETCH 500 FROM crssqlcmd_175e93649b29a5eb829ec9dd955c8b34
14:58:06:093 (0x00001280) : <<[Connection::+PgExecuteQuery]
14:58:06:093 (0x00001280) : >>[Connection::+PgExecuteCommand]
14:58:06:093 (0x00001280) : SQL:
CLOSE crssqlcmd_175e93649b29a5eb829ec9dd955c8b34
14:58:06:093 (0x00001280) : Affected tuples: 0
14:58:06:093 (0x00001280) : <<[Connection::+PgExecuteCommand]
14:58:06:093 (0x00001280) : >>[Connection::+PgCommitSoftTransaction]
14:58:06:093 (0x00001280) : COMMIT TRANSACTION
14:58:06:093 (0x00001280) : <<[Connection::+PgCommitSoftTransaction]
14:58:06:093 (0x00001280) : <<[SchemaDescription::+DescribeSchema]
14:58:06:093 (0x00001280) : <<[Connection::-DescribeSchema]
14:58:06:093 (0x00001280) : <<[Connection::+GetLogicalSchema]
14:58:06:093 (0x00001280) : Number of schema elements fetched: 1
14:58:06:093 (0x00001280) : <<[DescribeSchemaCommand::+Execute]
Hors ligne
