I can see the Support for the PG_CATALOG is part of the version 1.4.x
roadmap. Will it work with the MS Office applications like Access or Excel?
Any time frame for this to be available? I am trying to access than 2
database via ODBC using the PostgreSQL driver and am trying to link tables
and keep getting errors. Will the support for the PG_CATALOG wix those
issues?
Le lundi 22 février 2010 09:50:07 UTC-5, fd a écrit :
>
> When i connect a table from Access i see this error in the trace log
> of H2,
> and the operation fails
>
> Error: Table "PG_ATTRDEF" not found; SQL statement:
>
> I'm using
>
> > h2-1.2.129.jar
> > psqlodbc_08_04_0200.zip
> >Access 2007
>
> thanks
> F.D.
>
> Trace details *******************************************
>
> Connect
> Init
> StartupMessage
> version 196608 (3.0)
> param database=mimweb
> param user=MIMWEB
> param DateStyle=ISO
> param extra_float_digits=2
> param geqo=on
> param client_encoding=UTF8
> PasswordMessage
> Query
> select oid, typbasetype from pg_type where typname = 'lo';
> Query
> SELECT Config, nValue FROM MSysConf;
> org.h2.jdbc.JdbcSQLException: Table "MSYSCONF" not found; SQL
> statement:
> SELECT Config, nValue FROM MSysConf [42102-129]
> at org.h2.message.DbException.getJdbcSQLException(DbException.java:
> 317)
> at org.h2.message.DbException.get(DbException.java:168)
> at org.h2.message.DbException.get(DbException.java:145)
> at org.h2.command.Parser.readTableOrView(Parser.java:4334)
> at org.h2.command.Parser.readTableFilter(Parser.java:1002)
> at
> org.h2.command.Parser.parseSelectSimpleFromPart(Parser.java:1530)
> at org.h2.command.Parser.parseSelectSimple(Parser.java:1627)
> at org.h2.command.Parser.parseSelectSub(Parser.java:1524)
> at org.h2.command.Parser.parseSelectUnion(Parser.java:1369)
> at org.h2.command.Parser.parseSelect(Parser.java:1357)
> at org.h2.command.Parser.parsePrepared(Parser.java:396)
> at org.h2.command.Parser.parse(Parser.java:279)
> at org.h2.command.Parser.parse(Parser.java:251)
> at org.h2.command.Parser.prepareCommand(Parser.java:223)
> at org.h2.engine.Session.prepareLocal(Session.java:422)
> at org.h2.engine.Session.prepareCommand(Session.java:383)
> at org.h2.jdbc.JdbcConnection.prepareCommand(JdbcConnection.java:
> 1071)
> at
> org.h2.jdbc.JdbcStatement.executeInternal(JdbcStatement.java:163)
> at org.h2.jdbc.JdbcStatement.execute(JdbcStatement.java:151)
> at org.h2.server.pg.PgServerThread.process(PgServerThread.java:340)
> at org.h2.server.pg.PgServerThread.run(PgServerThread.java:76)
> at java.lang.Thread.run(Thread.java:619)
> Query
> select relname, nspname, relkind from pg_catalog.pg_class c,
> pg_catalog.pg_namespace n where relkind in ('r', 'v') and n.oid =
> relnamespace order by nspname, relname;
> Query
> select c.relhasrules, c.relkind, c.relhasoids from
> pg_catalog.pg_namespace u, pg_catalog.pg_class c where u.oid =
> c.relnamespace and c.relname = E'TMIMAMB' and u.nspname = E'MIMWEB';
> Query
> select n.nspname, c.relname, a.attname, a.atttypid, t.typname,
> a.attnum, a.attlen, a.atttypmod, a.attnotnull, c.relhasrules,
> c.relkind, c.oid, d.adsrc, case t.typtype when 'd' then t.typbasetype
> else 0 end, t.typtypmod from (((pg_catalog.pg_class c inner join
> pg_catalog.pg_namespace n on n.oid = c.relnamespace and c.relname like
> E'TMIMAMB' and n.nspname like E'MIMWEB') inner join
> pg_catalog.pg_attribute a on (not a.attisdropped) and a.attnum > 0 and
> a.attrelid = c.oid) inner join pg_catalog.pg_type t on t.oid =
> a.atttypid) left outer join pg_attrdef d on a.atthasdef and d.adrelid
> = a.attrelid and d.adnum = a.attnum order by n.nspname, c.relname,
> attnum;
> org.h2.jdbc.JdbcSQLException: Column "T.TYPTYPMOD" not found; SQL
> statement:
> select n.nspname, c.relname, a.attname, a.atttypid, t.typname,
> a.attnum, a.attlen, a.atttypmod, a.attnotnull, c.relhasrules,
> c.relkind, c.oid, d.adsrc, case t.typtype when 'd' then t.typbasetype
> else 0 end, t.typtypmod from (((pg_catalog.pg_class c inner join
> pg_catalog.pg_namespace n on n.oid = c.relnamespace and c.relname like
> E'TMIMAMB' and n.nspname like E'MIMWEB') inner join
> pg_catalog.pg_attribute a on (not a.attisdropped) and a.attnum > 0 and
> a.attrelid = c.oid) inner join pg_catalog.pg_type t on t.oid =
> a.atttypid) left outer join pg_attrdef d on a.atthasdef and d.adrelid
> = a.attrelid and d.adnum = a.attnum order by n.nspname, c.relname,
> attnum [42122-129]
> at org.h2.message.DbException.getJdbcSQLException(DbException.java:
> 317)
> at org.h2.message.DbException.get(DbException.java:168)
> at org.h2.message.DbException.get(DbException.java:145)
> at
> org.h2.expression.ExpressionColumn.optimize(ExpressionColumn.java:
> 126)
> at org.h2.command.dml.Select.prepare(Select.java:714)
> at org.h2.command.Parser.prepareCommand(Parser.java:224)
> at org.h2.engine.Session.prepareLocal(Session.java:422)
> at org.h2.engine.Session.prepareCommand(Session.java:383)
> at org.h2.jdbc.JdbcConnection.prepareCommand(JdbcConnection.java:
> 1071)
> at
> org.h2.jdbc.JdbcStatement.executeInternal(JdbcStatement.java:163)
> at org.h2.jdbc.JdbcStatement.execute(JdbcStatement.java:151)
> at org.h2.server.pg.PgServerThread.process(PgServerThread.java:340)
> at org.h2.server.pg.PgServerThread.run(PgServerThread.java:76)
> at java.lang.Thread.run(Thread.java:619)
> ^CException in thread "Thread-16" java.lang.AbstractMethodError:
> it.ubi.mimweb.h2.AutoInc.close()V
> at org.h2.schema.TriggerObject.close(TriggerObject.java:373)
> at org.h2.engine.Database.close(Database.java:1031)
> at org.h2.engine.DatabaseCloser.run(DatabaseCloser.java:80)
>
>
--
You received this message because you are subscribed to the Google Groups "H2
Database" group.
To unsubscribe from this group and stop receiving emails from it, send an email
to [email protected].
To post to this group, send email to [email protected].
Visit this group at http://groups.google.com/group/h2-database.
For more options, visit https://groups.google.com/d/optout.
