You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@metamodel.apache.org by "Arun Pillai (JIRA)" <ji...@apache.org> on 2016/07/07 09:02:11 UTC
[jira] [Created] (METAMODEL-1100) Error while getting schema in
mysql
Arun Pillai created METAMODEL-1100:
--------------------------------------
Summary: Error while getting schema in mysql
Key: METAMODEL-1100
URL: https://issues.apache.org/jira/browse/METAMODEL-1100
Project: Apache MetaModel
Issue Type: Bug
Reporter: Arun Pillai
I'm trying to list all table names from a schema
I'm getting the following error
String connectionURL = "jdbc:mysql://localhost:3306";
String userName = "user";
String password = "pass";
DataContext dataContext =
DataContextFactory.createJdbcDataContext(connection);
Schema schemas = dataContext.getSchemaByName("exampledb");
Please find the error stack
org.apache.metamodel.MetaModelException: Could not retrieve table metadata for schemaName: Table name pattern can not be NULL or empty.
at org.apache.metamodel.jdbc.JdbcUtils.wrapException(JdbcUtils.java:70)
at org.apache.metamodel.jdbc.JdbcMetadataLoader.loadTables(JdbcMetadataLoader.java:144)
at org.apache.metamodel.jdbc.JdbcMetadataLoader.loadTables(JdbcMetadataLoader.java:89)
at org.apache.metamodel.jdbc.JdbcDataContext.getSchemaByNameInternal(JdbcDataContext.java:810)
at org.apache.metamodel.AbstractDataContext.getSchemaByName(AbstractDataContext.java:206)
at com.TableNames.getTableNames(TableNames.java:21)
at com.Main.main(Main.java:42)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
at java.lang.reflect.Method.invoke(Method.java:498)
at com.intellij.rt.execution.application.AppMain.main(AppMain.java:144)
Caused by: java.sql.SQLException: Table name pattern can not be NULL or empty.
at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:695)
at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:663)
at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:653)
at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:638)
at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:606)
at com.mysql.cj.jdbc.DatabaseMetaData.getTables(DatabaseMetaData.java:3835)
at org.apache.metamodel.jdbc.JdbcMetadataLoader.loadTables(JdbcMetadataLoader.java:105)
... 10 more
Exception in thread "main" org.apache.metamodel.MetaModelException: Could not retrieve table metadata for schemaName: Table name pattern can not be NULL or empty.
at org.apache.metamodel.jdbc.JdbcUtils.wrapException(JdbcUtils.java:70)
at org.apache.metamodel.jdbc.JdbcMetadataLoader.loadTables(JdbcMetadataLoader.java:144)
at org.apache.metamodel.jdbc.JdbcMetadataLoader.loadTables(JdbcMetadataLoader.java:89)
at org.apache.metamodel.jdbc.JdbcDataContext.getSchemaByNameInternal(JdbcDataContext.java:810)
at org.apache.metamodel.AbstractDataContext.getSchemaByName(AbstractDataContext.java:206)
at com.Main.main(Main.java:43)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
at java.lang.reflect.Method.invoke(Method.java:498)
at com.intellij.rt.execution.application.AppMain.main(AppMain.java:144)
Caused by: java.sql.SQLException: Table name pattern can not be NULL or empty.
at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:695)
at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:663)
at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:653)
at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:638)
at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:606)
at com.mysql.cj.jdbc.DatabaseMetaData.getTables(DatabaseMetaData.java:3835)
at org.apache.metamodel.jdbc.JdbcMetadataLoader.loadTables(JdbcMetadataLoader.java:105)
... 9 more
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)