[Hexose]

So I am new to MyEclipse for Spring and this is my situation. Yesterday I created a new project and used the Scaffold feature with an Oracle DB test table to see if the connections and whatnot would work. The Scaffold went through fine and completed, however I have have issues with connection to the DB when running the application.

Now I have fixed the issue witht he connection to the DB (added the .jar file to the Java Build Path) and now that project works fine.

With that project working fine, I decided to add another table to the mix. I created a new table and tried to create and scaffold a new project and immediately I received a “Generation Job Failed” error. I suspected it had to do with my new DB table. So I dropped the table and tried it again with just the test table I made, and got the same Generation Job Failed error. No matter what I do I cannot get a scaffold to work now even though everything is the same as when I got the first scaffold to go through without error.

Is there something that I am doing wrong? I am at a complete loss here. Any help would be greatly appreciated.

This is the error log I receive…

java.lang.RuntimeException: Error invoking function: initializeCrud with parameters: [Ljava.lang.Object;@ab809cc
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@39755d33]
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.HibernateException: Dialect class not found: (Auto-Detect)
at org.hibernate.dialect.DialectFactory.buildDialect(DialectFactory.java:81)
at org.hibernate.dialect.DialectFactory.buildDialect(DialectFactory.java:42)
at org.hibernate.cfg.SettingsFactory.determineDialect(SettingsFactory.java:426)
at org.hibernate.cfg.SettingsFactory.buildSettings(SettingsFactory.java:128)
at org.hibernate.cfg.Configuration.buildSettingsInternal(Configuration.java:2090)
at org.hibernate.cfg.Configuration.buildSettings(Configuration.java:2082)
at org.hibernate.cfg.JDBCMetaDataConfiguration.readFromJDBC(JDBCMetaDataConfiguration.java:40)
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

[Hexose]

Apparently the issue was with the Auto-Detect Dialect. When I posted my error log the Auto-Detect caught my eye. I switch the Dialect to Oracle10 and there were no errors during Scaffolding. I will now try to add more tables. If a moderator sees this, they can delete the post if they would like.

[jkennedy]

We will keep this post because it may help someone else who scaffolds from a DB where the dialect is not automatically detected. Thanks for posting the resolution, and keeping us up to date on your progress.

We appreciate it.

Jack

[guylking]

Can you give me detail on exactly how you changed the dialect? I’ve changed my JDBC driver from 11g to 10g with little luck and not sure what to do to get this working.

[jkennedy]

On the scaffolding wizard there is a place where you choose the connection and below that is a drop down with a list of the dialects.
Can you check the errors view under window / show view / other / errors and post any error that may have to do with the issue you are seeing.

Appreciate any additional details about the issue you are seeing and the environment you are using.

Thanks,
Jack

[guylking]

Thanks Jack, I guess either old age or not opening my eyes was the issue. As for the exceptions I recieved, they are very similar to the earlier post.

[jkennedy]

Were you able to resolve the issues by choosing a different dialect?

I just want to make sure that you were able to get things working.

Thanks,
Jack

[Author]

Posts