facebook

Scaffolding from DB2 (IBM, AS400, iSeries) does

  1. MyEclipse IDE
  2.  > 
  3. Spring Development
Viewing 15 posts - 1 through 15 (of 15 total)
  • Author
    Posts
  • #308537 Reply

    rogerrolf
    Member

    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

    #308549 Reply

    Heflin Hogan
    Member

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

    #308553 Reply

    rogerrolf
    Member

    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?

    #308554 Reply

    rogerrolf
    Member

    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.

    #308561 Reply

    Heflin Hogan
    Member

    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.

    #308564 Reply

    rogerrolf
    Member

    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.

    #308567 Reply

    rogerrolf
    Member

    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?

    #308568 Reply

    rogerrolf
    Member

    I am 8.5 pro for spring.

    #308594 Reply

    Heflin Hogan
    Member

    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.

    #308600 Reply

    rogerrolf
    Member

    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

    #310603 Reply

    Ed
    Member

    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.

    #310638 Reply

    Heflin Hogan
    Member

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

    #312058 Reply

    BedBath-2
    Participant

    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.

    #312092 Reply

    davemeurer
    Member

    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.

    #312094 Reply

    BedBath-2
    Participant

    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.

Viewing 15 posts - 1 through 15 (of 15 total)
Reply To: Scaffolding from DB2 (IBM, AS400, iSeries) does

You must be logged in to post in the forum log in