banniere

Le portail francophone de la géomatique


Toujours pas inscrit ? Mot de passe oublié ?
Nom d'utilisateur    Mot de passe              Toujours pas inscrit ?   Mot de passe oublié ?

#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 ?


Fichier(s) joint(s) :
Pour accéder aux fichiers vous devez vous inscrire.

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

 

Pied de page des forums

Powered by FluxBB