OSGeo.org › OSGeo Software and Data Projects › Feature Data Objects (FDO) › FDO Users

Mapguide studio do not read objets of provider postgis

1 message Options
Embed this post
Permalink
euskalmap

Mapguide studio do not read objets of provider postgis

Reply Threaded More More options
Print post
Permalink
Hi,
I'm use the fdo provider postgis 3.2 with mapguide ose 2.0.2 under windows xp pro sp2
When i create a layer with Mapguide studio (or maestro) it do not read objets of provider postgis : i have a warning and the popup is empty; see here : My Message

See the log file :

_________________________________________________________________________________

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]


_________________________________________________________________________________

Thanks
Free Embeddable Forum Powered by Nabble Help