[daviejm]

I can successfully run the CustomersApp scaffolding tutorial, but when I try and repeat the steps but use my own MySQL db it connects fine finds all the tables and does everything apart from put an code in the default /generated folder.

The log file contain the following:

!ENTRY org.eclipse.osgi 2 1 2010-04-06 21:40:05.172
!MESSAGE NLS missing message: JavaMetaUtils_warning_default_package in: com.genuitec.eclipse.core.platformmessages

!ENTRY org.eclipse.osgi 2 1 2010-04-06 21:40:05.172
!MESSAGE NLS missing message: JavaVMUtility_dialog_jdk_doesnt_exist_message in: com.genuitec.eclipse.core.platformmessages

!ENTRY org.eclipse.osgi 2 1 2010-04-06 21:40:05.173
!MESSAGE NLS missing message: JavaVMUtility_dialog_jdk_doesnt_exist_title in: com.genuitec.eclipse.core.platformmessages

!ENTRY org.eclipse.osgi 2 1 2010-04-06 21:40:05.173
!MESSAGE NLS missing message: JavaVMUtility_dialog_jdk_not_jre_message in: com.genuitec.eclipse.core.platformmessages

!ENTRY org.eclipse.osgi 2 1 2010-04-06 21:40:05.182
!MESSAGE NLS missing message: JavaVMUtility_dialog_jdk_not_jre_title in: com.genuitec.eclipse.core.platformmessages

!ENTRY org.eclipse.osgi 2 1 2010-04-06 21:40:05.183
!MESSAGE NLS missing message: JavaVMUtility_launchconfig_default_server_type_id_attr in: com.genuitec.eclipse.core.platformmessages

!ENTRY org.eclipse.osgi 2 1 2010-04-06 21:40:05.183
!MESSAGE NLS missing message: MELibraryFieldEditor_dialog_browse_jar_title in: com.genuitec.eclipse.core.platformmessages

!ENTRY org.eclipse.osgi 2 1 2010-04-06 21:40:05.183
!MESSAGE NLS missing message: MELibraryFieldEditor_dialog_invalidfile_message in: com.genuitec.eclipse.core.platformmessages

!ENTRY org.eclipse.osgi 2 1 2010-04-06 21:40:05.184
!MESSAGE NLS missing message: MELibraryFieldEditor_dialog_invalidfile_title in: com.genuitec.eclipse.core.platformmessages

!ENTRY org.eclipse.osgi 2 1 2010-04-06 21:40:05.195
!MESSAGE NLS missing message: MELibraryFieldEditor_button_add_label in: com.genuitec.eclipse.core.platformmessages

!ENTRY org.eclipse.osgi 2 1 2010-04-06 21:40:05.195
!MESSAGE NLS missing message: MELibraryFieldEditor_button_down_label in: com.genuitec.eclipse.core.platformmessages

!ENTRY org.eclipse.osgi 2 1 2010-04-06 21:40:05.196
!MESSAGE NLS missing message: MELibraryFieldEditor_button_edit_label in: com.genuitec.eclipse.core.platformmessages

!ENTRY org.eclipse.osgi 2 1 2010-04-06 21:40:05.196
!MESSAGE NLS missing message: MELibraryFieldEditor_button_remove_label in: com.genuitec.eclipse.core.platformmessages

!ENTRY org.eclipse.osgi 2 1 2010-04-06 21:40:05.196
!MESSAGE NLS missing message: MELibraryFieldEditor_button_up_label in: com.genuitec.eclipse.core.platformmessages

!ENTRY org.eclipse.osgi 2 1 2010-04-06 21:40:05.197
!MESSAGE NLS missing message: MELibraryWizardPage_description in: com.genuitec.eclipse.core.platformmessages

!ENTRY org.eclipse.osgi 2 1 2010-04-06 21:40:05.197
!MESSAGE NLS missing message: MELibraryWizardPage_error_selection_onlyone in: com.genuitec.eclipse.core.platformmessages

!ENTRY org.eclipse.osgi 2 1 2010-04-06 21:40:05.197
!MESSAGE NLS missing message: MELibraryWizardPage_error_selection_zero in: com.genuitec.eclipse.core.platformmessages

!ENTRY org.eclipse.osgi 2 1 2010-04-06 21:40:05.198
!MESSAGE NLS missing message: MELibraryWizardPage_list_library_selector_label in: com.genuitec.eclipse.core.platformmessages

!ENTRY org.eclipse.osgi 2 1 2010-04-06 21:40:05.198
!MESSAGE NLS missing message: MELibraryWizardPage_title in: com.genuitec.eclipse.core.platformmessages

I’m running a Mac with Snow leopard, MyEclipse for Spring 8.5.0

When I start MyEclipse I get the following in the log if this helps

!SESSION 2010-04-06 21:51:37.020 ———————————————–
eclipse.buildId=unknown
java.version=1.6.0_17
java.vendor=Apple Inc.
BootLoader constants: OS=macosx, ARCH=x86, WS=carbon, NL=en_US
Framework arguments: -keyring /Users/Jay/.eclipse_keyring -showlocation
Command-line arguments: -os macosx -ws carbon -arch x86 -keyring /Users/Jay/.eclipse_keyring -consoleLog -showlocation

!ENTRY org.eclipse.jface 2 0 2010-04-06 21:51:50.894
!MESSAGE Keybinding conflicts occurred. They may interfere with normal accelerator operation.
!SUBENTRY 1 org.eclipse.jface 2 0 2010-04-06 21:51:50.894
!MESSAGE A conflict occurred for SHIFT+DEL:
Binding(SHIFT+DEL,
ParameterizedCommand(Command(org.eclipse.datatools.sqltools.result.removeAllInstances,Remove All Visible Results,
,
Category(org.eclipse.datatools.sqltools.result.category,SQL Results View,null,true),
,
,,true),null),
org.eclipse.ui.defaultAcceleratorConfiguration,
org.eclipse.ui.contexts.window,,,system)
Binding(SHIFT+DEL,
ParameterizedCommand(Command(org.topcased.modeler.deleteModelObject,Delete From Model,
Allows the user to delete the selected graph element and its associated model element in a Topcased editor.,
Category(org.eclipse.ui.category.edit,Edit,null,true),
,
,,true),null),
org.eclipse.ui.defaultAcceleratorConfiguration,
org.eclipse.ui.contexts.window,,,system)

[davemeurer]

Hello,

Thank you for the details. Would you be able to help us understand the following, please?

1. Are there any errors in the Error View in MyEclipse for Spring? (Window > Show View > [Other…] > Error log
2. What is the schema of the table(s) you are trying to pull into the scaffolding wizard?

Kind regards,
Dave

[Pedro Riera]

I am having the same problem. The tutorial works fine, but when I try to generate from an existing MS SqlServer schema (from which I have generated JPA entities perfectly in the past), I get nothing. The error log reads:

Problems occurred when invoking code from plug-in: “org.eclipse.core.resources”.

java.lang.NullPointerException
at org.eclipse.wst.jsdt.internal.compiler.ast.EqualExpression.analyseCode(EqualExpression.java:76)
at org.eclipse.wst.jsdt.internal.compiler.ast.AND_AND_Expression.analyseCode(AND_AND_Expression.java:50)
at org.eclipse.wst.jsdt.internal.compiler.ast.IfStatement.analyseCode(IfStatement.java:70)
at org.eclipse.wst.jsdt.internal.compiler.ast.MethodDeclaration.analyseCode(MethodDeclaration.java:94)
at org.eclipse.wst.jsdt.internal.compiler.ast.AbstractMethodDeclaration.analyseCode(AbstractMethodDeclaration.java:112)
at org.eclipse.wst.jsdt.internal.compiler.ast.FunctionExpression.analyseCode(FunctionExpression.java:73)
at org.eclipse.wst.jsdt.internal.compiler.ast.ObjectLiteralField.analyseCode(ObjectLiteralField.java:78)
at org.eclipse.wst.jsdt.internal.compiler.ast.ObjectLiteral.analyseCode(ObjectLiteral.java:95)
at org.eclipse.wst.jsdt.internal.compiler.ast.ObjectLiteralField.analyseCode(ObjectLiteralField.java:78)
at org.eclipse.wst.jsdt.internal.compiler.ast.ObjectLiteral.analyseCode(ObjectLiteral.java:95)
at org.eclipse.wst.jsdt.internal.compiler.ast.MessageSend.analyseCode(MessageSend.java:86)
at org.eclipse.wst.jsdt.internal.compiler.ast.Block.analyseCode(Block.java:43)
at org.eclipse.wst.jsdt.internal.compiler.ast.IfStatement.analyseCode(IfStatement.java:92)
at org.eclipse.wst.jsdt.internal.compiler.ast.MethodDeclaration.analyseCode(MethodDeclaration.java:94)
at org.eclipse.wst.jsdt.internal.compiler.ast.AbstractMethodDeclaration.analyseCode(AbstractMethodDeclaration.java:112)
at org.eclipse.wst.jsdt.internal.compiler.ast.FunctionExpression.analyseCode(FunctionExpression.java:73)
at org.eclipse.wst.jsdt.internal.compiler.ast.Expression.analyseCode(Expression.java:223)
at org.eclipse.wst.jsdt.internal.compiler.ast.MessageSend.analyseCode(MessageSend.java:77)
at org.eclipse.wst.jsdt.internal.compiler.ast.CompilationUnitDeclaration.analyseCode(CompilationUnitDeclaration.java:164)
at org.eclipse.wst.jsdt.internal.compiler.Compiler.process(Compiler.java:598)
at org.eclipse.wst.jsdt.internal.compiler.Compiler.compile(Compiler.java:356)
at org.eclipse.wst.jsdt.internal.core.builder.AbstractImageBuilder.compile(AbstractImageBuilder.java:311)
at org.eclipse.wst.jsdt.internal.core.builder.BatchImageBuilder.compile(BatchImageBuilder.java:168)
at org.eclipse.wst.jsdt.internal.core.builder.AbstractImageBuilder.compile(AbstractImageBuilder.java:248)
at org.eclipse.wst.jsdt.internal.core.builder.BatchImageBuilder.build(BatchImageBuilder.java:58)
at org.eclipse.wst.jsdt.internal.core.builder.JavaBuilder.buildAll(JavaBuilder.java:291)
at org.eclipse.wst.jsdt.internal.core.builder.JavaBuilder.build(JavaBuilder.java:199)
at org.eclipse.core.internal.events.BuildManager$2.run(BuildManager.java:627)
at org.eclipse.core.runtime.SafeRunner.run(SafeRunner.java:42)
at org.eclipse.core.internal.events.BuildManager.basicBuild(BuildManager.java:170)
at org.eclipse.core.internal.events.BuildManager.basicBuild(BuildManager.java:201)
at org.eclipse.core.internal.events.BuildManager$1.run(BuildManager.java:253)
at org.eclipse.core.runtime.SafeRunner.run(SafeRunner.java:42)
at org.eclipse.core.internal.events.BuildManager.basicBuild(BuildManager.java:256)
at org.eclipse.core.internal.events.BuildManager.basicBuildLoop(BuildManager.java:309)
at org.eclipse.core.internal.events.BuildManager.build(BuildManager.java:341)
at org.eclipse.core.internal.events.AutoBuildJob.doBuild(AutoBuildJob.java:140)
at org.eclipse.core.internal.events.AutoBuildJob.run(AutoBuildJob.java:238)
at org.eclipse.core.internal.jobs.Worker.run(Worker.java:55)

[Heflin Hogan]

I have a few questions to help us isolate the issue.

Does this happen every time you try scaffolding from you tables?
Can you scaffold from a single table in your database?
Can you provide us with a schema for your database?

If you could also clear your error log and run the scaffolding again, it would be very helpful to have a complete error log and a step by step description of the actions that result in the problem.

Regards,
Heflin

[daviejm]

Sorry for the delay I’ve been ill and on holiday – great combination

It happens every time and I’m getting nothing in the Error log I’ve tried a single table in the Schema namely one called User and that doesn’t work either. I’ve got the SQL so you can recreate the Schema where would you like me to send it

[Heflin Hogan]

You can PM me and attach the SQL file. Could you tell me what version of MySQL, which driver, and whether it’s on your local machine or not? Also, have you tried a clean installation?

[Heflin Hogan]

I finally managed to reproduce the MySQL issue, and it really had me stumped, especially since I was able to scaffold from a remote MySQL database with the same driver. It turns out that there is a bug in handling the specific database for your tables. I had initially set up my database connection like this:

jdbc:mysql://localhost/test

But I had created a database called heflin, and loaded your schema into it. This failed in the same manner as you had described. However, when I changed the connection url to

jdbc:mysql://localhost/heflin

I was able to successfully scaffold from your database. If you could verify your settings and let me know if this approach works for you, I would appreciate it. I will be enetering a bug report for this item.

Regards,
Heflin

[Glen Ihrig]

@ Heflin: For the record, what was the condition triggering the bug? Same database and table name, or simply a db named ‘test’?

Thanks,

Glen

[Heflin Hogan]

@gihrig wrote:

@ Heflin: For the record, what was the condition triggering the bug? Same database and table name, or simply a db named ‘test’?

Thanks,

Glen

It would occur in any scenario where you tried to scaffold a table or tables that existed in a database other than the one specified in the connection URL for MySQL.

[chyang@aol.com]

Hello Dave,
Trying to follow your tutorial MVC -> Spring, while I get to the derby connection, I have no table or DB schema listed. I assume that there need some import to DB or setup. please point me a direction how to proceed. I’d love to get through that tutorial. Thanks

[davemeurer]

Hello,

You may need to start the Derby Database before doing Scaffolding. I have seen cases where the wizard pane is enabled before the Derby connection can start.

On the other hand, if you don’t see any schemas or tables when looking in the MyEclipse DB Browser window, then restoring the Derby database may help. Ensure the connection is closed, and go to Windows > Preferences > MyEclipse > Servers > Integrated Sandbox > MyEclipse Derby. The buttons to Restore Sample Database are on that pane.

Let me know if this helps,
Dave

[Satwa S. Rao]

I’ve posted a problem with mysql on a db2 thread, as I didn’t see the topic, found it over google.

I am reposting the issue here

Scaffolding Spring MVC CRUD Application failed.

The problem is related with the default metadata stuff.

I am using mysql innodb

The details can be found on the db2 thread, as I don’t want to bloat the forum.

Please rescue a merely mortal willing to see this really in action and maybe forget about crudding for some time and rule the world of crud.

Thanks
Satwa S. RAO

[Author]

Posts