Hello all.
I'm currently running H2 1.3.174 and get the following error when I try to
connect the web console to my H2 server running in Postgresql mode. The web
console still connects but this error is still displayed in the left-hand
panel after I connect. Any ideas?
Thanks for your time!
-Robert
Details are below:
I run the H2 server inside a simple Java class which I run in debug mode in
Eclipse.
import org.h2.tools.Server;
public class H2Test {
public static void main(String[] args) throws Exception {
String[] serverArgs = {"-pgAllowOthers"};
Server server = Server.createPgServer(args).start();
server.stop(); // i set a break point here
}
}
Then I start the web console like so:
java -cp ./h2-1.3.174.jar:./postgresql-9.3-1100.jdbc4.jar
org.h2.tools.Server -web
When I open the web console at http://localhost:8082, I see the following:
ERROR: Function "CURRENT_SCHEMAS" not found; SQL statement:
SELECT nspname AS TABLE_SCHEM , NULL AS TABLE_CATALOG FROM
pg_catalog.pg_namespace WHERE nspname <> 'pg_toast' AND (nspname !~
'^pg_temp_' OR nspname = (pg_catalog.current_schemas(true))[1]) AND
(nspname !~ '^pg_toast_temp_' OR nspname =
replace((pg_catalog.current_schemas(true))[1], 'pg_temp_',
'pg_toast_temp_')) ORDER BY TABLE_SCHEM [90022-174]
Detail: org.h2.jdbc.JdbcSQLException: Function "CURRENT_SCHEMAS" not
found; SQL statement:
SELECT nspname AS TABLE_SCHEM , NULL AS TABLE_CATALOG FROM
pg_catalog.pg_namespace WHERE nspname <> 'pg_toast' AND (nspname !~
'^pg_temp_' OR nspname = (pg_catalog.current_schemas(true))[1]) AND
(nspname !~ '^pg_toast_temp_' OR nspname =
replace((pg_catalog.current_schemas(true))[1], 'pg_temp_',
'pg_toast_temp_')) ORDER BY TABLE_SCHEM [90022-174] 90022/0
org.postgresql.util.PSQLException: ERROR: Function "CURRENT_SCHEMAS" not
found; SQL statement:
SELECT nspname AS TABLE_SCHEM , NULL AS TABLE_CATALOG FROM
pg_catalog.pg_namespace WHERE nspname <> 'pg_toast' AND (nspname !~
'^pg_temp_' OR nspname = (pg_catalog.current_schemas(true))[1]) AND
(nspname !~ '^pg_toast_temp_' OR nspname =
replace((pg_catalog.current_schemas(true))[1], 'pg_temp_',
'pg_toast_temp_')) ORDER BY TABLE_SCHEM [90022-174]
Detail: org.h2.jdbc.JdbcSQLException: Function "CURRENT_SCHEMAS" not
found; SQL statement:
SELECT nspname AS TABLE_SCHEM , NULL AS TABLE_CATALOG FROM
pg_catalog.pg_namespace WHERE nspname <> 'pg_toast' AND (nspname !~
'^pg_temp_' OR nspname = (pg_catalog.current_schemas(true))[1]) AND
(nspname !~ '^pg_toast_temp_' OR nspname =
replace((pg_catalog.current_schemas(true))[1], 'pg_temp_',
'pg_toast_temp_')) ORDER BY TABLE_SCHEM [90022-174]
at
org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:2161)
at
org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1890)
at
org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:255)
at
org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:560)
at
org.postgresql.jdbc2.AbstractJdbc2Statement.executeWithFlags(AbstractJdbc2Statement.java:403)
at
org.postgresql.jdbc2.AbstractJdbc2Statement.executeQuery(AbstractJdbc2Statement.java:283)
at
org.postgresql.jdbc2.AbstractJdbc2DatabaseMetaData.getSchemas(AbstractJdbc2DatabaseMetaData.java:2251)
at
org.postgresql.jdbc3.AbstractJdbc3DatabaseMetaData.getSchemas(AbstractJdbc3DatabaseMetaData.java:378)
at org.h2.bnf.context.DbContents.getSchemaNames(DbContents.java:202)
at org.h2.bnf.context.DbContents.readContents(DbContents.java:165)
at org.h2.server.web.WebApp.tables(WebApp.java:666)
at org.h2.server.web.WebApp.process(WebApp.java:223)
at org.h2.server.web.WebApp.processRequest(WebApp.java:168)
at org.h2.server.web.WebThread.process(WebThread.java:138)
at org.h2.server.web.WebThread.run(WebThread.java:94)
at java.lang.Thread.run(Thread.java:695)
--
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.
