Re: ODBC Error

I've never been able to get it to work. I always have access say unknown 
error -4744 or something like that, do you get that also?


fd wrote:
> 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 post to this group, send email to [EMAIL PROTECTED]
To unsubscribe from this group, send email to [EMAIL PROTECTED]
For more options, visit this group at 
http://groups.google.com/group/h2-database?hl=en.