IBM®
Skip to main content
    United States change      Terms of use
 
 
Select a scope:    
     Home      Products      Services & industry solutions      Support & downloads      My account     
alphaWorks  >  Java technology  >  

Web Data Access Developer

A simple, easy-to-use, Eclipse plug-in development environment for building a basic data access client.


Date Posted: June 30, 2005
Overview Requirements DownloadFAQsForum Reviews

1. What kind of applications can I build with this technology?
2. Can you use this tool to create a database schema based on a form you build using the AUIML or other GUI-building tool?
3. I got a SAX parser error and the Available Data dialog box does not show the database schema tables.
4. I got a Torque error about a task definition: "(taskdef -> A class (org.w3c.dom.ranges.DocumentRange) needed by class org.apache.torque.TorqueJDBCTransformTask cannot be found."
5. What should I do if I get a torque-data-model error stating that the generatejsf attribute is not supported?`


1. What kind of applications can I build with this technology?

The Web Data Access Developer builds very basic, form-based Web clients. You can either autogenerate the form using JSF or you can build the form yourself using a drag-and-drop GUI builder tool (the AUIML technology). Of course, since the Web developer technology is based on the Eclipse Web Tools Platform, you really have the flexibility to build more than just the data form clients that this tool addresses.
Back to top Back to top

2. Can you use this tool to create a database schema based on a form you build using the AUIML or other GUI-building tool?

No, this tool can only discover the schema of an existing database and generate data beans from that model. This technology assumes the user wants to build an application for accessing information from an existing database.
Back to top Back to top

3. I got a SAX parser error and the Available Data dialog box does not show the database schema tables.

You must launch Eclipse using an IBM JRE/JDK that supports the appropriate Xerces parser classes. We tried adding the relevant xerces JAR file to a Sun JRE/JDK as well as to the project build path, but for some reason it was not added to the classpath, so it still failed. We tested this technology using the 1.4.2 version of the IBM JDK.

Here is the relavant log error: 

	!ENTRY org.eclipse.core.runtime 4 2 Jul 19, 2005 15:37:59.327
	!MESSAGE Problems occurred when invoking code from plug-in: "org.eclipse.core.runtime".
	!STACK 0
	java.lang.NoClassDefFoundError: org.xml.sax.SAXException
		at java.lang.Throwable.(Throwable.java:52)
		at java.lang.Throwable.(Throwable.java:66)
		at java.lang.NoClassDefFoundError.(NoClassDefFoundError.java:57)
		at java.lang.Class.verifyImpl(Native Method)
		at java.lang.Class.verify(Class.java)
		at java.lang.Class.initialize(Class.java)
		at org.eclipse.core.internal.resources.LocalMetaArea.readOldWorkspace(LocalMetaArea.java:256)
		at org.eclipse.core.internal.resources.Workspace.open(Workspace.java:1521)
		at org.eclipse.core.resources.ResourcesPlugin.startup(ResourcesPlugin.java:268)
		at org.eclipse.core.internal.plugins.PluginDescriptor$1.run(PluginDescriptor.java:736)
		at org.eclipse.core.internal.runtime.InternalPlatform.run(InternalPlatform.java:1006)
		at org.eclipse.core.internal.plugins.PluginDescriptor.internalDoPluginActivation(PluginDescriptor.java:748)
		at org.eclipse.core.internal.plugins.PluginDescriptor.doPluginActivation(PluginDescriptor.java:188)
		at org.eclipse.core.internal.plugins.PluginClassLoader.activatePlugin(PluginClassLoader.java:112)
		at org.eclipse.core.internal.plugins.PluginClassLoader.internalFindClassParentsSelf(PluginClassLoader.java:185)
		at org.eclipse.core.internal.boot.DelegatingURLClassLoader.findClassParentsSelf(DelegatingURLClassLoader.java)
		at org.eclipse.core.internal.boot.DelegatingURLClassLoader.loadClass(DelegatingURLClassLoader.java:882)
		at org.eclipse.core.internal.boot.DelegatingURLClassLoader.access$0(DelegatingURLClassLoader.java:876)
		at org.eclipse.core.internal.boot.DelegatingURLClassLoader$DelegateLoader.loadClass(DelegatingURLClassLoader.java:90)
		at org.eclipse.core.internal.boot.DelegatingURLClassLoader.findClassPrerequisites(DelegatingURLClassLoader.java:554)
		at org.eclipse.core.internal.boot.DelegatingURLClassLoader.loadClass(DelegatingURLClassLoader.java:890)
		at org.eclipse.core.internal.boot.DelegatingURLClassLoader.loadClass(DelegatingURLClassLoader.java:862)
		at java.lang.ClassLoader.loadClass(ClassLoader.java:553)
		at java.lang.Class.verifyImpl(Native Method)
		at java.lang.Class.verify(Class.java)
		at java.lang.Class.initialize(Class.java)
		at java.lang.Class.newInstanceImpl(Native Method)
		at java.lang.Class.newInstance(Class.java:1451)
		at org.eclipse.core.internal.plugins.PluginDescriptor.createExecutableExtension(PluginDescriptor.java:138)
		at org.eclipse.core.internal.plugins.PluginDescriptor.createExecutableExtension(PluginDescriptor.java:167)
		at org.eclipse.core.internal.plugins.ConfigurationElement.createExecutableExtension(ConfigurationElement.java:103)
		at org.eclipse.core.internal.runtime.InternalPlatform.loaderGetRunnable(InternalPlatform.java:578)
		at java.lang.reflect.AccessibleObject.invokeL(AccessibleObject.java:207)
		at java.lang.reflect.Method.invoke(Method.java:271)
		at org.eclipse.core.internal.boot.InternalBootLoader.getRunnable(InternalBootLoader.java:471)
		at org.eclipse.core.internal.boot.InternalBootLoader.run(InternalBootLoader.java:854)
		at org.eclipse.core.boot.BootLoader.run(BootLoader.java:461)
		at java.lang.reflect.AccessibleObject.invokeL(AccessibleObject.java:207)
		at java.lang.reflect.Method.invoke(Method.java:271)
		at org.eclipse.core.launcher.Main.basicRun(Main.java:291)
		at org.eclipse.core.launcher.Main.run(Main.java:747)
		at org.eclipse.core.launcher.Main.main(Main.java:583)
Back to top Back to top

4. I got a Torque error about a task definition: "(taskdef -> A class (org.w3c.dom.ranges.DocumentRange) needed by class org.apache.torque.TorqueJDBCTransformTask cannot be found."

Ensure that you are using an IBM or similar SDK that supports XercesImpl.jar when you launch Eclipse. Here is the relevant log file entry for the taskdef error: 

	!ENTRY org.eclipse.ui 4 0 2005-06-20 15:13:55.74
	!MESSAGE org.eclipse.wst.rdb.internal.core.definition.DatabaseDefinition.getDatabaseCatalogProvider()Lorg/eclipse/wst/rdb/internal/core/rte/CatalogProvider;
	!STACK 0
	java.lang.NoSuchMethodError: org.eclipse.wst.rdb.internal.core.definition.DatabaseDefinition.getDatabaseCatalogProvider()Lorg/eclipse/wst/rdb/internal/core/rte/CatalogProvider;
		at org.eclipse.wst.rdb.server.internal.ui.explorer.content.DatabaseProviderHelper.getCatalogDatabase(DatabaseProviderHelper.java:39)
		at org.eclipse.wst.rdb.server.internal.ui.explorer.content.DatabaseProviderHelper.setDatabase(DatabaseProviderHelper.java:48)
		at org.eclipse.wst.rdb.server.internal.ui.explorer.actions.popup.AddConnectionAction.setDatabase(AddConnectionAction.java:93)
		at org.eclipse.wst.rdb.server.internal.ui.explorer.actions.popup.AddConnectionAction.displayNewServer(AddConnectionAction.java:61)
		at org.eclipse.wst.rdb.server.internal.ui.explorer.actions.popup.AddConnectionAction.run(AddConnectionAction.java:121)
		at org.eclipse.wst.rdb.server.internal.ui.explorer.actions.popup.AbstractAction.runWithEvent(AbstractAction.java:118)
		at org.eclipse.ui.internal.PluginAction.runWithEvent(PluginAction.java:234)
		at org.eclipse.jface.action.ActionContributionItem.handleWidgetSelection(ActionContributionItem.java:555)
		at org.eclipse.jface.action.ActionContributionItem.access$2(ActionContributionItem.java:505)
		at org.eclipse.jface.action.ActionContributionItem$6.handleEvent(ActionContributionItem.java:419)
		at org.eclipse.swt.widgets.EventTable.sendEvent(EventTable.java:82)
		at org.eclipse.swt.widgets.Widget.sendEvent(Widget.java:833)
		at org.eclipse.swt.widgets.Display.runDeferredEvents(Display.java:2803)
		at org.eclipse.swt.widgets.Display.readAndDispatch(Display.java:2448)
		at org.eclipse.ui.internal.Workbench.runEventLoop(Workbench.java:1569)
		at org.eclipse.ui.internal.Workbench.runUI(Workbench.java:1540)
		at org.eclipse.ui.internal.Workbench.createAndRunWorkbench(Workbench.java:285)
		at org.eclipse.ui.PlatformUI.createAndRunWorkbench(PlatformUI.java:144)
		at org.eclipse.ui.internal.ide.IDEApplication.run(IDEApplication.java:102)
		at org.eclipse.core.internal.runtime.PlatformActivator$1.run(PlatformActivator.java:220)
		at org.eclipse.core.runtime.adaptor.EclipseStarter.run(EclipseStarter.java:273)
		at org.eclipse.core.runtime.adaptor.EclipseStarter.run(EclipseStarter.java:129)
		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:324)
		at org.eclipse.core.launcher.Main.basicRun(Main.java:185)
		at org.eclipse.core.launcher.Main.run(Main.java:710)
		at org.eclipse.core.launcher.Main.main(Main.java:694)
Back to top Back to top

5. What should I do if I get a torque-data-model error stating that the generatejsf attribute is not supported?`

You must regenerate the torque generator JAR file (torque-gen-3.1.1.jar).

Here are the relevant console debug messages: 

	Adding ewd.xml
	Adding ewd.properties
	Adding lib/commons-lang-2.0.jar
	Adding lib/commons-logging-1.0.4.jar
	Adding lib/commons-configuration-1.0.jar
	Adding lib/commons-beanutils-1.6.1.jar
	Adding lib/commons-dbcp-1.2.1.jar
	Adding lib/commons-digester.jar
	Adding lib/stratum-1.0-b5.jar
	Adding lib/velocity-1.3.1.jar
	Adding lib/xercesImpl.jar
	Adding lib/torque-3.1.1.jar
	Adding lib/logkit-1.0.1.jar
	Adding lib/commons-pool-1.2.jar
	Adding lib/village-2.0-dev.jar
	Adding lib/commons-collections-3.0.jar
	Adding lib/jsf/jsf-api.jar
	Adding lib/jsf/jsf-impl.jar
	Adding lib/jsf/jstl.jar
	Adding lib/torque-gen-3.1.1.jar
	Copying C:\IBM\Cloudscape_10.0\lib\db2jcc_license_c.jar to C:/eclipse/runtime-workspace/Yada/ewd/lib/db2jcc_license_c.jar
	Copying C:\IBM\Cloudscape_10.0\lib\db2jcc.jar to C:/eclipse/runtime-workspace/Yada/ewd/lib/db2jcc.jar

	ewd:prepare:
	[propertyfile] Updating property file: C:\eclipse\runtime-workspace\Yada\ewd\ewd.properties

	jdbc:
		 [echo] +-----------------------------------------------+
		 [echo] | |
		 [echo] | Generating XML from JDBC connection ! |
		 [echo] | |
		 [echo] +-----------------------------------------------+
	[torque-jdbc-transform] Torque - JDBCToXMLSchema starting
	[torque-jdbc-transform] Your DB settings are:
	[torque-jdbc-transform] driver : com.ibm.db2.jcc.DB2Driver
	[torque-jdbc-transform] URL : jdbc:derby:net://localhost:1527/patientdb
	[torque-jdbc-transform] user : PATIENT
	[torque-jdbc-transform] schema : PATIENT
	[torque-jdbc-transform] DB driver sucessfuly instantiated
	[torque-jdbc-transform] DB connection established
	[torque-jdbc-transform] Getting table list...
	[torque-jdbc-transform] Building column/table map...
	[torque-jdbc-transform] Processing table: PATIENT
	[torque-jdbc-transform] Processing table: STATE
	[torque-jdbc-transform] C:/eclipse/runtime-workspace/Yada/ewd/xml/Yada-schema.xml
	[torque-jdbc-transform] Torque - JDBCToXMLSchema finished

	BUILD FAILED
	C:\eclipse\runtime-workspace\Yada\ewd\ewd.xml:498: The <torque-data-model> type doesn't support the "generatejsf" attribute.

	Total time: 6 seconds

	check-use-classpath:

	om-classpath:
	[torque-data-model] Using contextProperties file: C:\eclipse\runtime-workspace\Yada\ewd\ewd.properties
	C:\eclipse\runtime-workspace\Yada\ewd\ewd.xml:498: The  type doesn't support the "generatejsf" attribute.
		at org.apache.tools.ant.IntrospectionHelper.setAttribute(IntrospectionHelper.java:516)
		at org.apache.tools.ant.RuntimeConfigurable.maybeConfigure(RuntimeConfigurable.java:368)
		at org.apache.tools.ant.RuntimeConfigurable.maybeConfigure(RuntimeConfigurable.java:322)
		at org.apache.tools.ant.Task.maybeConfigure(Task.java:254)
		at org.apache.tools.ant.UnknownElement.configure(UnknownElement.java:189)
		at org.apache.tools.ant.UnknownElement.maybeConfigure(UnknownElement.java:158)
		at org.apache.tools.ant.Task.perform(Task.java:363)
		at org.apache.tools.ant.Target.execute(Target.java:341)
		at org.apache.tools.ant.Target.performTasks(Target.java:369)
		at org.apache.tools.ant.Project.executeTarget(Project.java:1214)
		at com.ibm.extremeblue.expresswebdev.actions.JavaServerFacesGenerator.run(JavaServerFacesGenerator.java:61)
		at org.eclipse.jface.operation.ModalContext$ModalContextThread.run(ModalContext.java:105)
Back to top Back to top
Download now Download now

Related technologies

For platform(s):
Windows

For topics:
data access, Lotus Workplace, small and medium businesses (SMB)


Related resources

Press Articles
 

    About IBM      Privacy      Contact