[Matt_X]

Hello:

I’m trying to use the MyEclipse scaffold tool, however it is failing for me. I’m connecting to a MySql database. The wizard is able to connect fine and retrieve the list of tables, however at the “finish” step, the scaffold generation fails.

I used “Database Schema” as the source, then a new connection “com.mysql.jdbc.Driver” I setup, selected “org.hibernate.dialect.MySQLDialect” for dialect, I tried both (“Default”, then “org.hibernate.cfg.reveng.dialect.OracleMetaDataDialect”) for the MetaData Dialect dropdown option. Then selected all tables, some associations checked, however both times the generation failed before creating any classes.

Below is the stack trace:

selecting (Default)
java.lang.RuntimeException: Error invoking function: initializeCrud with parameters: [Ljava.lang.Object;@4768eb
at org.skyway.core.generate.snippet.function.FunctionInvoker.invoke(FunctionInvoker.java:102)
at org.skyway.core.generate.snippet.function.FunctionSnippetExpression.evaluate(FunctionSnippetExpression.java:26)
at org.skyway.core.generate.snippet.SnippetRegistry.evaluate(SnippetRegistry.java:88)
at org.skyway.core.generate.snippet.SnippetRegistry.getObjectAttribute(SnippetRegistry.java:99)
at org.skyway.core.generate.generator.invoke.InvokeSnippetGenerator.generate(InvokeSnippetGenerator.java:24)
at org.skyway.core.generate.generator.DescendantGenerator.generateChild(DescendantGenerator.java:28)
at org.skyway.core.generate.generator.DescendantGenerator.generateChildren(DescendantGenerator.java:21)
at org.skyway.core.generate.generator.DescendantGenerator.generate(DescendantGenerator.java:14)
at org.skyway.core.generate.generator.control.ResourceGenerator.generate(ResourceGenerator.java:19)
at org.skyway.core.generate.execute.GenerationJob.generate(GenerationJob.java:115)
at org.skyway.core.generate.execute.GenerationJob$1.run(GenerationJob.java:59)
at org.eclipse.core.internal.resources.Workspace.run(Workspace.java:1975)
at org.skyway.core.generate.execute.GenerationJob.run(GenerationJob.java:55)
at org.eclipse.core.internal.jobs.Worker.run(Worker.java:54)
Caused by: java.lang.RuntimeException: Unable to load data type from table(s): [org.skyway.integration.data.persistence.provider.datatype.TableDataTypeInput@16a859c, org.skyway.integration.data.persistence.provider.datatype.TableDataTypeInput@69d7f4, org.skyway.integration.data.persistence.provider.datatype.TableDataTypeInput@e10fe1, org.skyway.integration.data.persistence.provider.datatype.TableDataTypeInput@1d9a642, org.skyway.integration.data.persistence.provider.datatype.TableDataTypeInput@326c52, org.skyway.integration.data.persistence.provider.datatype.TableDataTypeInput@657c9e, org.skyway.integration.data.persistence.provider.datatype.TableDataTypeInput@d8880c, org.skyway.integration.data.persistence.provider.datatype.TableDataTypeInput@1cbe1cd, org.skyway.integration.data.persistence.provider.datatype.TableDataTypeInput@55920b, org.skyway.integration.data.persistence.provider.datatype.TableDataTypeInput@1e743a3, org.skyway.integration.data.persistence.provider.datatype.TableDataTypeInput@999e0, org.skyway.integration.data.persistence.provider.datatype.TableDataTypeInput@5556af, org.skyway.integration.data.persistence.provider.datatype.TableDataTypeInput@ae2a84, org.skyway.integration.data.persistence.provider.datatype.TableDataTypeInput@6974c6, org.skyway.integration.data.persistence.provider.datatype.TableDataTypeInput@1718e0b, org.skyway.integration.data.persistence.provider.datatype.TableDataTypeInput@24b170, org.skyway.integration.data.persistence.provider.datatype.TableDataTypeInput@fd50f6, org.skyway.integration.data.persistence.provider.datatype.TableDataTypeInput@ce5b80, org.skyway.integration.data.persistence.provider.datatype.TableDataTypeInput@1d93818, org.skyway.integration.data.persistence.provider.datatype.TableDataTypeInput@1f1b6c2, org.skyway.integration.data.persistence.provider.datatype.TableDataTypeInput@159325, org.skyway.integration.data.persistence.provider.datatype.TableDataTypeInput@6f75ab, org.skyway.integration.data.persistence.provider.datatype.TableDataTypeInput@19657d5, org.skyway.integration.data.persistence.provider.datatype.TableDataTypeInput@1606afe, org.skyway.integration.data.persistence.provider.datatype.TableDataTypeInput@11084df, org.skyway.integration.data.persistence.provider.datatype.TableDataTypeInput@1836cd1, org.skyway.integration.data.persistence.provider.datatype.TableDataTypeInput@15d3933, org.skyway.integration.data.persistence.provider.datatype.TableDataTypeInput@1565775, org.skyway.integration.data.persistence.provider.datatype.TableDataTypeInput@187f025, org.skyway.integration.data.persistence.provider.datatype.TableDataTypeInput@1a72791, org.skyway.integration.data.persistence.provider.datatype.TableDataTypeInput@116b1d9, org.skyway.integration.data.persistence.provider.datatype.TableDataTypeInput@f65168, org.skyway.integration.data.persistence.provider.datatype.TableDataTypeInput@15a9e02, org.skyway.integration.data.persistence.provider.datatype.TableDataTypeInput@3ba148, org.skyway.integration.data.persistence.provider.datatype.TableDataTypeInput@d99de3, org.skyway.integration.data.persistence.provider.datatype.TableDataTypeInput@10cc14a, org.skyway.integration.data.persistence.provider.datatype.TableDataTypeInput@661c48, org.skyway.integration.data.persistence.provider.datatype.TableDataTypeInput@1cae120, org.skyway.integration.data.persistence.provider.datatype.TableDataTypeInput@82384a, org.skyway.integration.data.persistence.provider.datatype.TableDataTypeInput@13db0b2, org.skyway.integration.data.persistence.provider.datatype.TableDataTypeInput@11b8416, org.skyway.integration.data.persistence.provider.datatype.TableDataTypeInput@17cf956, org.skyway.integration.data.persistence.provider.datatype.TableDataTypeInput@1d5ba63]
at org.skyway.integration.data.persistence.provider.datatype.TableDataTypeInputProvider.generateDataTypes(TableDataTypeInputProvider.java:222)
at org.skyway.integration.data.persistence.provider.datatype.TableDataTypeInputProvider.getDataTypes(TableDataTypeInputProvider.java:73)
at com.skyway.scaffolding.crud.datatype.FilteredDataTypeInputProvider.getDataTypes(FilteredDataTypeInputProvider.java:33)
at com.skyway.scaffolding.crud.util.ContextAwareCrudFunctions.getDataTypes(ContextAwareCrudFunctions.java:181)
at com.skyway.scaffolding.crud.util.ContextAwareCrudFunctions.initializeCrud(ContextAwareCrudFunctions.java:55)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
at java.lang.reflect.Method.invoke(Method.java:597)
at org.skyway.core.generate.snippet.function.FunctionInvoker.invoke(FunctionInvoker.java:94)
… 13 more
Caused by: org.hibernate.cfg.JDBCBinderException: Could not load MetaDataDialect: (Default)
at org.hibernate.cfg.JDBCReaderFactory.newMetaDataDialect(JDBCReaderFactory.java:42)
at org.hibernate.cfg.JDBCReaderFactory.newJDBCReader(JDBCReaderFactory.java:24)
at org.hibernate.cfg.JDBCBinder.readDatabaseSchema(JDBCBinder.java:119)
at org.hibernate.cfg.JDBCBinder.readFromDatabase(JDBCBinder.java:94)
at org.hibernate.cfg.JDBCMetaDataConfiguration.readFromJDBC(JDBCMetaDataConfiguration.java:42)
at org.skyway.integration.data.persistence.importer.hibernate.HibernateModelGenerator.createJDBCConfiguration(HibernateModelGenerator.java:227)
at org.skyway.integration.data.persistence.importer.hibernate.HibernateModelGenerator.generateModel(HibernateModelGenerator.java:96)
at org.skyway.integration.data.persistence.provider.datatype.TableDataTypeInputProvider.generateDataTypes(TableDataTypeInputProvider.java:208)
… 22 more
Caused by: java.lang.ClassNotFoundException: (Default)
at org.eclipse.osgi.internal.loader.BundleLoader.findClassInternal(BundleLoader.java:506)
at org.eclipse.osgi.internal.loader.BundleLoader.findClass(BundleLoader.java:422)
at org.eclipse.osgi.internal.loader.BundleLoader.findClass(BundleLoader.java:410)
at org.eclipse.osgi.internal.baseadaptor.DefaultClassLoader.loadClass(DefaultClassLoader.java:107)
at java.lang.ClassLoader.loadClass(ClassLoader.java:252)
at java.lang.ClassLoader.loadClassInternal(ClassLoader.java:320)
at java.lang.Class.forName0(Native Method)
at java.lang.Class.forName(Class.java:247)
at org.hibernate.util.ReflectHelper.classForName(ReflectHelper.java:147)
at org.hibernate.cfg.JDBCReaderFactory.newMetaDataDialect(JDBCReaderFactory.java:38)
… 29 more

selecting oracle

java.lang.RuntimeException: Error invoking function: initializeCrud with parameters: [Ljava.lang.Object;@c32da8
at org.skyway.core.generate.snippet.function.FunctionInvoker.invoke(FunctionInvoker.java:102)
at org.skyway.core.generate.snippet.function.FunctionSnippetExpression.evaluate(FunctionSnippetExpression.java:26)
at org.skyway.core.generate.snippet.SnippetRegistry.evaluate(SnippetRegistry.java:88)
at org.skyway.core.generate.snippet.SnippetRegistry.getObjectAttribute(SnippetRegistry.java:99)
at org.skyway.core.generate.generator.invoke.InvokeSnippetGenerator.generate(InvokeSnippetGenerator.java:24)
at org.skyway.core.generate.generator.DescendantGenerator.generateChild(DescendantGenerator.java:28)
at org.skyway.core.generate.generator.DescendantGenerator.generateChildren(DescendantGenerator.java:21)
at org.skyway.core.generate.generator.DescendantGenerator.generate(DescendantGenerator.java:14)
at org.skyway.core.generate.generator.control.ResourceGenerator.generate(ResourceGenerator.java:19)
at org.skyway.core.generate.execute.GenerationJob.generate(GenerationJob.java:115)
at org.skyway.core.generate.execute.GenerationJob$1.run(GenerationJob.java:59)
at org.eclipse.core.internal.resources.Workspace.run(Workspace.java:1975)
at org.skyway.core.generate.execute.GenerationJob.run(GenerationJob.java:55)
at org.eclipse.core.internal.jobs.Worker.run(Worker.java:54)
Caused by: java.lang.RuntimeException: Unable to load data type from table(s): [org.skyway.integration.data.persistence.provider.datatype.TableDataTypeInput@6df91e, org.skyway.integration.data.persistence.provider.datatype.TableDataTypeInput@1fe4ef3, org.skyway.integration.data.persistence.provider.datatype.TableDataTypeInput@f169e2, org.skyway.integration.data.persistence.provider.datatype.TableDataTypeInput@15e909c, org.skyway.integration.data.persistence.provider.datatype.TableDataTypeInput@16803e8, org.skyway.integration.data.persistence.provider.datatype.TableDataTypeInput@1d87f52, org.skyway.integration.data.persistence.provider.datatype.TableDataTypeInput@8f11a6, org.skyway.integration.data.persistence.provider.datatype.TableDataTypeInput@cfea33, org.skyway.integration.data.persistence.provider.datatype.TableDataTypeInput@18ecf3, org.skyway.integration.data.persistence.provider.datatype.TableDataTypeInput@6c6665, org.skyway.integration.data.persistence.provider.datatype.TableDataTypeInput@b68391, org.skyway.integration.data.persistence.provider.datatype.TableDataTypeInput@77c9e2, org.skyway.integration.data.persistence.provider.datatype.TableDataTypeInput@673892, org.skyway.integration.data.persistence.provider.datatype.TableDataTypeInput@b32bb6, org.skyway.integration.data.persistence.provider.datatype.TableDataTypeInput@faee66, org.skyway.integration.data.persistence.provider.datatype.TableDataTypeInput@39aaa4, org.skyway.integration.data.persistence.provider.datatype.TableDataTypeInput@1f214e6, org.skyway.integration.data.persistence.provider.datatype.TableDataTypeInput@3a26c9, org.skyway.integration.data.persistence.provider.datatype.TableDataTypeInput@1c85f78, org.skyway.integration.data.persistence.provider.datatype.TableDataTypeInput@1f3d3af, org.skyway.integration.data.persistence.provider.datatype.TableDataTypeInput@ceb138, org.skyway.integration.data.persistence.provider.datatype.TableDataTypeInput@1d4ea83, org.skyway.integration.data.persistence.provider.datatype.TableDataTypeInput@1705a11, org.skyway.integration.data.persistence.provider.datatype.TableDataTypeInput@1292965, org.skyway.integration.data.persistence.provider.datatype.TableDataTypeInput@15cbc06, org.skyway.integration.data.persistence.provider.datatype.TableDataTypeInput@13c3bf2, org.skyway.integration.data.persistence.provider.datatype.TableDataTypeInput@183c0ca, org.skyway.integration.data.persistence.provider.datatype.TableDataTypeInput@e639a2, org.skyway.integration.data.persistence.provider.datatype.TableDataTypeInput@d1d9ea, org.skyway.integration.data.persistence.provider.datatype.TableDataTypeInput@139a9a9, org.skyway.integration.data.persistence.provider.datatype.TableDataTypeInput@b1c0ee, org.skyway.integration.data.persistence.provider.datatype.TableDataTypeInput@1f18208, org.skyway.integration.data.persistence.provider.datatype.TableDataTypeInput@900853, org.skyway.integration.data.persistence.provider.datatype.TableDataTypeInput@129a0d, org.skyway.integration.data.persistence.provider.datatype.TableDataTypeInput@13fec58, org.skyway.integration.data.persistence.provider.datatype.TableDataTypeInput@1b58819, org.skyway.integration.data.persistence.provider.datatype.TableDataTypeInput@fa35ac, org.skyway.integration.data.persistence.provider.datatype.TableDataTypeInput@d9f054, org.skyway.integration.data.persistence.provider.datatype.TableDataTypeInput@314a6b, org.skyway.integration.data.persistence.provider.datatype.TableDataTypeInput@cec3d, org.skyway.integration.data.persistence.provider.datatype.TableDataTypeInput@69d86b, org.skyway.integration.data.persistence.provider.datatype.TableDataTypeInput@ff73af, org.skyway.integration.data.persistence.provider.datatype.TableDataTypeInput@103eee0]
at org.skyway.integration.data.persistence.provider.datatype.TableDataTypeInputProvider.generateDataTypes(TableDataTypeInputProvider.java:222)
at org.skyway.integration.data.persistence.provider.datatype.TableDataTypeInputProvider.getDataTypes(TableDataTypeInputProvider.java:73)
at com.skyway.scaffolding.crud.datatype.FilteredDataTypeInputProvider.getDataTypes(FilteredDataTypeInputProvider.java:33)
at com.skyway.scaffolding.crud.util.ContextAwareCrudFunctions.getDataTypes(ContextAwareCrudFunctions.java:181)
at com.skyway.scaffolding.crud.util.ContextAwareCrudFunctions.initializeCrud(ContextAwareCrudFunctions.java:55)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
at java.lang.reflect.Method.invoke(Method.java:597)
at org.skyway.core.generate.snippet.function.FunctionInvoker.invoke(FunctionInvoker.java:94)
… 13 more
Caused by: org.hibernate.exception.SQLGrammarException: Could not get list of tables from database. Probably a JDBC driver problem.
Configured schema:null
Configured catalog:null
Available schemas:
Available catalogs:
information_schema
item_directory
mysql
performance_schema
test
xaristo

at org.hibernate.exception.SQLStateConverter.convert(SQLStateConverter.java:67)
at org.hibernate.cfg.reveng.dialect.OracleMetaDataDialect.getTables(OracleMetaDataDialect.java:257)
at org.hibernate.cfg.reveng.JDBCReader.processTables(JDBCReader.java:476)
at org.hibernate.cfg.reveng.JDBCReader.readDatabaseSchema(JDBCReader.java:74)
at org.hibernate.cfg.reveng.JDBCReader.readDatabaseSchema(JDBCReader.java:860)
at org.hibernate.cfg.JDBCBinder.readDatabaseSchema(JDBCBinder.java:121)
at org.hibernate.cfg.JDBCBinder.readFromDatabase(JDBCBinder.java:94)
at org.hibernate.cfg.JDBCMetaDataConfiguration.readFromJDBC(JDBCMetaDataConfiguration.java:42)
at org.skyway.integration.data.persistence.importer.hibernate.HibernateModelGenerator.createJDBCConfiguration(HibernateModelGenerator.java:227)
at org.skyway.integration.data.persistence.importer.hibernate.HibernateModelGenerator.generateModel(HibernateModelGenerator.java:96)
at org.skyway.integration.data.persistence.provider.datatype.TableDataTypeInputProvider.generateDataTypes(TableDataTypeInputProvider.java:208)
… 22 more
Caused by: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Table ‘xaristo.all_tables’ doesn’t exist
at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:39)
at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:27)
at java.lang.reflect.Constructor.newInstance(Constructor.java:513)
at com.mysql.jdbc.Util.handleNewInstance(Util.java:407)
at com.mysql.jdbc.Util.getInstance(Util.java:382)
at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1052)
at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3603)
at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3535)
at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1989)
at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2150)
at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2626)
at com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:2119)
at com.mysql.jdbc.PreparedStatement.executeQuery(PreparedStatement.java:2281)
at org.hibernate.cfg.reveng.dialect.OracleMetaDataDialect.getTableResultSet(OracleMetaDataDialect.java:667)
at org.hibernate.cfg.reveng.dialect.OracleMetaDataDialect.getTables(OracleMetaDataDialect.java:221)
… 31 more

[Peter]

Hi matt,

i experienced a similar problem herre: https://www.genuitec.com/forums/topic/generation-job-failed/

Are you pressing “Next” in the wizard all the way to the end or are you clicking “Finish” before the last page in the wizard? if your pressing finish early trying waiting till the last page. If you are still experiencing this problem please try to scaffold a CRUD application using the derby database and see what happens…

[jkennedy]

There is also an issue with MySQL Connections where if you don’t specify the database name in the text field on the Connection screen that says DataBase Name and use the same name that you are using in the connect String that the calls we make to get the Database meta data fail like this. Please open you connection and check to see if you have a database name that matches the one in the connect String.

Thanks,
Jack

[Matt_X]

I have the database connection string configured with the database name appended. I can connect and get the database list (I have to choose the 3rd option as “all schemas” shows nothing) and then it connects and will retrieve table lists later in the wizard process. The failure is in the generation step after pressing “Finish” at the last wizard screen.

I’m 100% sure the issue is due to the “Scaffold Spring CRUD Application : Select Database Tables” dialog MetaData Dialect droplist only having the following option listed for MySql connection types:
“org.hibernate.cfg.reveng.dialect.OracleMetaDataDialect”.

Googling for all_tables, this is an Oracle specific metadata table that you can query for a list of the tables in a given database.

MySql does not support this system table ( doing a query MySql responds the table does not exist ).
Can the wizard be fixed to use another metadata provider for MySql database instead of the Oracle metadata provider?

I’d like to purchase licenses of MyEclipse if I can get this wizard working…

Thanks!
Matt

[Matt_X]

I’m using the com.mysql.jdbc.Driver class from the mysql-connector-java-5.1.16.jar

[jkennedy]

Matt,

I would like to make sure we get this issue resolved, would you be open to jumping on a quick GoToMeeting so that we can walk through the process together and so that I can see it first hand?

There are two Dialect drop downs on this screen.
Can you confirm which dialect you are choosing for the first one?
Also, can you please leave the second drop down (The metadata dialect) as Default.

You are correct, you would not want to pick the Oracle option.

Please email me at [email protected] to coordinate a time when we can do a quick meeting, and if you can provide these additional details I would appreciate it.

thanks,
Jack

[jkennedy]

Sorry, I see in your original post you already confirmed this information, lets spend a few minutes on a GoToMeeting then to walk through to see the issue.

I will look for your email, thanks

Jack

[Author]

Posts