[rogerrolf]

From Database Explorer I have successfully connected to an IBM iSeries database (DB2). I would like to use the Scaffolding function for a web project to generate code for new project. I can add the database and tables in the scaffolding function, however when the code generator is completed no source has been generated.

Please Help

[Heflin Hogan]

Can you check your error log and attach any relevant errors?

[rogerrolf]

I run the Scaffolding and it runs through without errors, however there is no generated source. Is there any other joblog created that I should look for?

[rogerrolf]

The only possible errors I can find,

!SESSION 2010-05-21 09:47:03.441 ———————————————–
eclipse.buildId=unknown
java.version=1.6.0_13
java.vendor=Sun Microsystems Inc.
BootLoader constants: OS=win32, ARCH=x86, WS=win32, NL=en_US
Command-line arguments: -os win32 -ws win32 -arch x86

!ENTRY org.eclipse.jface 2 0 2010-05-21 09:47:24.605
!MESSAGE Keybinding conflicts occurred. They may interfere with normal accelerator operation.
!SUBENTRY 1 org.eclipse.jface 2 0 2010-05-21 09:47:24.605
!MESSAGE A conflict occurred for CTRL+F9:
Binding(CTRL+F9,
ParameterizedCommand(Command(org.eclipse.mylyn.tasks.ui.command.activateTask,Activate Task,
,
Category(org.eclipse.ui.category.navigate,Navigate,null,true),
,
,,true),null),
org.eclipse.ui.defaultAcceleratorConfiguration,
org.eclipse.ui.contexts.window,,,system)
Binding(CTRL+F9,
ParameterizedCommand(Command(RunSQLAction,Run SQL,
Run SQL,
Category(org.eclipse.ui.category.edit,Edit,null,true),
,
,,true),null),
org.eclipse.ui.defaultAcceleratorConfiguration,
org.eclipse.ui.contexts.window,,,system)
!SUBENTRY 1 org.eclipse.jface 2 0 2010-05-21 09:47:24.605
!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.eclipse.ui.edit.cut,Cut,
Cut the selection to the clipboard,
Category(org.eclipse.ui.category.edit,Edit,null,true),
org.eclipse.ui.internal.handlers.WidgetMethodHandler@166c37e,
,,true),null),
org.eclipse.ui.defaultAcceleratorConfiguration,
org.eclipse.ui.contexts.dialogAndWindow,,,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)

!ENTRY com.genuitec.eclipse.core.common 1 0 2010-05-21 09:47:38.532
!MESSAGE ClasspathContainer requery for classpath-string: com.skyway.myeclipseforspring.lib.web

!ENTRY com.genuitec.eclipse.core.common 1 0 2010-05-21 09:47:39.218
!MESSAGE ClasspathContainer requery for classpath-string: com.skyway.myeclipseforspring.lib.atomikos

!ENTRY org.eclipse.osgi 2 1 2010-05-21 09:50:23.836
!MESSAGE NLS unused message: DeploymentManagerDialog_status_deployment_Sucessful_overwrite_mode_ in: com.genuitec.eclipse.ast.deploy.core.messages

!ENTRY org.eclipse.osgi 2 1 2010-05-21 09:50:23.839
!MESSAGE NLS missing message: DeploymentManagerDialog_status_deployment_Sucessful_overwrite_mode in: com.genuitec.eclipse.ast.deploy.core.messages

!ENTRY org.eclipse.ui.workbench 2 0 2010-05-21 09:50:24.427
!MESSAGE A handler conflict occurred. This may disable some commands.
!SUBENTRY 1 org.eclipse.ui.workbench 2 0 2010-05-21 09:50:24.427
!MESSAGE Conflict for ‘com.genuitec.eclipse.ast.deploy.core.runonservershortcut.debug’:
HandlerActivation(commandId=com.genuitec.eclipse.ast.deploy.core.runonservershortcut.debug,
handler=org.eclipse.debug.internal.ui.launchConfigurations.LaunchShortcutExtension$LaunchCommandHandler@1d26ddd,
expression=,sourcePriority=0)
HandlerActivation(commandId=com.genuitec.eclipse.ast.deploy.core.runonservershortcut.debug,
handler=org.eclipse.debug.internal.ui.launchConfigurations.LaunchShortcutExtension$LaunchCommandHandler@2aff78,
expression=,sourcePriority=0)

!ENTRY org.eclipse.ui 4 4 2010-05-21 10:02:04.361
!MESSAGE Category org.eclipse.ajdt.ui.cat not found for view org.eclipse.contribution.xref.ui.views.XReferenceView. This view added to ‘Other’ category.

!ENTRY org.eclipse.ui 4 4 2010-05-21 10:02:04.415
!MESSAGE Category org.eclipse.ajdt.ui.cat not found for view org.eclipse.contribution.xref.ui.views.XReferenceView. This view added to ‘Other’ category.

[Heflin Hogan]

Have you tried scaffolding a single, simple table? If you have and it still doesn’t work, the problem might be a known issue with non-default databases. In the jdbc connection string, are you specifying a database other than the one you are trying to scaffold from? For example, if the connection URL is jdbc:db2://testhost/app and you are trying to scaffold from a database called “sample”, it may fail to generate. You can work around the problem by specifying the database you are working with in the connection string.

[rogerrolf]

Yes the table is a single simple table. I have tested my connection in the Database Explorer view by updating the table etc without any problems. The connection URL is pointing to a IBM iSeries which has only one instant of the database, so that cannot make any differance. What is frustrating is that when I run the Scafolding function it does not give any errors, it just fail to generate any source. My connection is using IBM’s jdbc connection with jar file jt400.jar and the URL is defined as jdbc:as400:IPADDRESS;prompt=false. I would think that Scafolding does not care what kind of connection I am having as long as I can connect. I kno w I have Read/Write premissions because in Database Explorer view I can modify table rows without any problem.

[rogerrolf]

I forgot to mention that the connection driver for My Eclipse must support DB2 enbedded database for OS on AS400 and iSeries. Could I miss a plugin or update?

[rogerrolf]

I am 8.5 pro for spring.

[Heflin Hogan]

This looks like a variant of an existing issue. We have a fixed scheduled for the next release which will hopefully address your specific problem.

[rogerrolf]

Sounds great, I wanted to just add that I have installed latest JTOPEN 7_0 and are using jt400 to connect. I also added the JTOPEN_7_0 to my build path please confirm if that step should be nessassary or if the fix does not use JTOPEN for the iSeries connections. Thanks

[Ed]

I am using MyEclipse for Spring 8.6.0 and experiencing the same problem. The CRUD scaffolding wizard starts building the application but exits with no errors. None of the application folders are created.

[Heflin Hogan]

Have you checked your error view and/or the .log file for your workspace?

[BedBath-2]

I am using MyEclipse for Spring 8.6 and experiencing the same issue. Using jt400.jar to connect to iSeries – V5R4.
The CRUD scaffolding wizard starts building the application but exits with no errors. src folder is empty.

[davemeurer]

In the jdbc connection string, are you specifying a database other than the one you are trying to scaffold from? For example, if the connection URL is jdbc:db2://testhost/app and you are trying to scaffold from a database called “sample”, it may fail to generate. You can work around the problem by specifying the database you are working with in the connection string.

[BedBath-2]

My URL was jdbc:as400://servername;naming=system;libraries=sample,*LIBL;
(sample is the collection name)

Removed ‘*LIBL’ and it worked.
jdbc:as400://servername;naming=system;libraries=sample;
Thanks.

[Author]

Posts