You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@metamodel.apache.org by "Trane Slink (JIRA)" <ji...@apache.org> on 2017/07/26 12:51:00 UTC
[jira] [Commented] (METAMODEL-1100) Error while getting schema in
mysql
[ https://issues.apache.org/jira/browse/METAMODEL-1100?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16101628#comment-16101628 ]
Trane Slink commented on METAMODEL-1100:
----------------------------------------
Hello,
in the last driver-versions the default-value for the configuration-Property "nullNamePatternMatchesAll" changed from "true" to "false".
So to solve your problem, you can do this:
Class.forName("com.mysql.cj.jdbc.Driver");
Properties config = new Properties();
config.put("nullNamePatternMatchesAll", "true"); //is needed sice 6.0.2
config.put("user", userName);
config.put("password", userPassword);
Connection connection = DriverManager.getConnection("jdbc:mysql://localhost:3306", config);
Good luck ;-)
> 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.4.14#64029)