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)