{"action":"created","issue":{"url":"https://api.github.com/repos/sualeh/SchemaCrawler/issues/85","repository_url":"https://api.github.com/repos/sualeh/SchemaCrawler","labels_url":"https://api.github.com/repos/sualeh/SchemaCrawler/issues/85/labels{/name}","comments_url":"https://api.github.com/repos/sualeh/SchemaCrawler/issues/85/comments","events_url":"https://api.github.com/repos/sualeh/SchemaCrawler/issues/85/events","html_url":"https://github.com/sualeh/SchemaCrawler/issues/85","id":169867956,"number":85,"title":"catalog.getTables(schema) returns empty list","user":{"login":"AlexLuya","id":303353,"avatar_url":"https://avatars.githubusercontent.com/u/303353?v=3","gravatar_id":"","url":"https://api.github.com/users/AlexLuya","html_url":"https://github.com/AlexLuya","followers_url":"https://api.github.com/users/AlexLuya/followers","following_url":"https://api.github.com/users/AlexLuya/following{/other_user}","gists_url":"https://api.github.com/users/AlexLuya/gists{/gist_id}","starred_url":"https://api.github.com/users/AlexLuya/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/AlexLuya/subscriptions","organizations_url":"https://api.github.com/users/AlexLuya/orgs","repos_url":"https://api.github.com/users/AlexLuya/repos","events_url":"https://api.github.com/users/AlexLuya/events{/privacy}","received_events_url":"https://api.github.com/users/AlexLuya/received_events","type":"User","site_admin":false},"labels":[],"state":"closed","locked":false,"assignee":null,"assignees":[],"milestone":null,"comments":10,"created_at":"2016-08-08T08:23:17Z","updated_at":"2016-08-11T03:17:03Z","closed_at":"2016-08-08T13:14:23Z","body":"Hello,\r\n     blow is my test code,schema got printed out,but tables not,doesn't SchemaCrawler support MariaDB yet.\r\n```\r\npublic static void main(final String[] args) throws Exception\r\n\t{\r\n\t\t// Create a database connection\r\n\t\tfinal DataSource dataSource = new DatabaseConnectionOptions(\"jdbc:mariadb://host:3306/vsi_dw_etl\");\r\n\t\tfinal Connection connection = dataSource.getConnection(\"user\", \"password\");\r\n\r\n\t\t// Create the options\r\n\t\tfinal SchemaCrawlerOptions options = new SchemaCrawlerOptions();\r\n\t\toptions.setSchemaInfoLevel(SchemaInfoLevelBuilder.standard());\r\n\r\n\t\toptions.setTableTypes(Lists.newArrayList(\"TABLE\",\"VIEW\",\"SYSTEM\tTABLE\"));\r\n\t\t// options.setRoutineInclusionRule(new ExcludeAll());\r\n\t\toptions.setSchemaInclusionRule(new RegularExpressionInclusionRule(\"vsi_dw_etl\"));\r\n\r\n\t\t// Get the schema definition\r\n\t\tfinal Catalog catalog = SchemaCrawlerUtility.getCatalog(connection, options);\r\n\r\n\t\tfor (final Schema schema : catalog.getSchemas())\r\n\t\t{\r\n\t\t\tSystem.out.print(\"c--> \" + schema.getCatalogName() + \"\\n\");\r\n\t\t\t\r\n\t\t\tfor (final Table table : catalog.getTables(schema))\r\n\t\t\t{\r\n\r\n\t\t\t\tSystem.out.print(\"o--> \" + table);\r\n\t\t\t\tif (table instanceof View)\r\n\t\t\t\t{\r\n\t\t\t\t\tSystem.out.println(\" (VIEW)\");\r\n\t\t\t\t} else\r\n\t\t\t\t{\r\n\t\t\t\t\tSystem.out.println();\r\n\t\t\t\t}\r\n\r\n\t\t\t\tfor (final Column column : table.getColumns())\r\n\t\t\t\t{\r\n\t\t\t\t\tSystem.out.println(\"     o--> \" + column + \" (\" + column.getColumnDataType() + \")\");\r\n\t\t\t\t}\r\n\t\t\t}\r\n\t\t}\r\n\t}\r\n```"},"comment":{"url":"https://api.github.com/repos/sualeh/SchemaCrawler/issues/comments/239063246","html_url":"https://github.com/sualeh/SchemaCrawler/issues/85#issuecomment-239063246","issue_url":"https://api.github.com/repos/sualeh/SchemaCrawler/issues/85","id":239063246,"user":{"login":"sualeh","id":58572,"avatar_url":"https://avatars.githubusercontent.com/u/58572?v=3","gravatar_id":"","url":"https://api.github.com/users/sualeh","html_url":"https://github.com/sualeh","followers_url":"https://api.github.com/users/sualeh/followers","following_url":"https://api.github.com/users/sualeh/following{/other_user}","gists_url":"https://api.github.com/users/sualeh/gists{/gist_id}","starred_url":"https://api.github.com/users/sualeh/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/sualeh/subscriptions","organizations_url":"https://api.github.com/users/sualeh/orgs","repos_url":"https://api.github.com/users/sualeh/repos","events_url":"https://api.github.com/users/sualeh/events{/privacy}","received_events_url":"https://api.github.com/users/sualeh/received_events","type":"User","site_admin":false},"created_at":"2016-08-11T03:17:03Z","updated_at":"2016-08-11T03:17:03Z","body":"Try getting rid of the schema exclusion rule?"}}
{"actor":{"display_login":"sualeh"}}