facebook
  1. MyEclipse Archived
    2.  > 
  2. Database Tools (DB Explorer, Hibernate, etc.)

SQL Editor

  1. MyEclipse Archived
    2.  > 
  2. Database Tools (DB Explorer, Hibernate, etc.)
Viewing 11 posts - 1 through 11 (of 11 total)
  • Author
    Posts
  • October 5, 2005 at 4:38 pm #238782 Reply

    CasadosRalphL
    Member

    I am connecting to and Informix database via the Database Explorer when in a view I generate the SQL statement to run the view I get an error on the data field “String to date Conversion Error” can you tell me where and how I can fix this ???

    October 6, 2005 at 3:39 am #238808 Reply

    Brian Fernandes
    Moderator

    Could you please answer all the questions in Posting Guidelines?

    Also, I’m afraid I couldn’t understand your explaination of the problem. Could you please give me a step wise series of actions you performed to arrive at this issue?

    Do you use one of the MyEclipse features to generate some SQL (which is not working as expected)
    OR
    when you’re running some SQL (which you created) using our SQL editor, you see the “String to date Conversion Error” message?

    Best,
    Brian.

    October 6, 2005 at 12:24 pm #238831 Reply

    CasadosRalphL
    Member

    What is happening is when in the Database Explorer I connect via the Informix JDBC driver and it works just fine for connecting and viewing the Tables and Views in the DB Explorer. I right click on the Informix View and select the option to Generate Select Statement for view. I select the Running ran icon to execute the SQL Statement to retrieve the view and thats when I get the Error: String to date conversion error when it tries to run.

    Here is the Error Log:

    !ENTRY com.genuitec.eclipse.sqlexplorer 4 4 2005-10-06 11:14:21.79
    !MESSAGE Error processing query: ‘select ofndr_num, rlse_dt, rlse_typ, nmcd, lgl_stat, chg_rsn, bed_id, cmplx_id, fclty_id, cmplx_name, fclty_name from otrk:dba.v_nm_rlse_fclty
    ‘
    !STACK 0
    java.sql.SQLException: String to date conversion error
    at com.informix.util.IfxErrMsg.getSQLException(IfxErrMsg.java:373)
    at com.informix.jdbc.IfxSqli.a(IfxSqli.java:3207)
    at com.informix.jdbc.IfxSqli.E(IfxSqli.java:3517)
    at com.informix.jdbc.IfxSqli.dispatchMsg(IfxSqli.java:2352)
    at com.informix.jdbc.IfxSqli.receiveMessage(IfxSqli.java:2268)
    at com.informix.jdbc.IfxSqli.executeExecute(IfxSqli.java:2156)
    at com.informix.jdbc.IfxSqli.executeExecute(IfxSqli.java:2131)
    at com.informix.jdbc.IfxResultSet.b(IfxResultSet.java:378)
    at com.informix.jdbc.IfxStatement.a(IfxStatement.java:1279)
    at com.informix.jdbc.IfxStatement.executeImpl(IfxStatement.java:1249)
    at com.informix.jdbc.IfxStatement.c(IfxStatement.java:969)
    at com.informix.jdbc.IfxStatement.execute(IfxStatement.java:855)
    at com.genuitec.eclipse.sqlexplorer.views.SqlExecProgress.processQuery(SqlExecProgress.java:156)
    at com.genuitec.eclipse.sqlexplorer.views.SqlExecProgress.run(SqlExecProgress.java:117)
    at org.eclipse.jface.operation.ModalContext$ModalContextThread.run(ModalContext.java:113)

    Here is a copy of my config file:

    C:\Downloads\Eclipse\eclipse-SDK-3.1-win32\eclipse\eclipse.exe
    -name
    Eclipse
    -showsplash
    600
    -exitdata
    a4c_60
    -vm
    C:\WINDOWS\system32\javaw.exe
    eclipse.product=org.eclipse.sdk.ide
    eclipse.startTime=1128618321785
    eclipse.vm=C:\WINDOWS\system32\javaw.exe
    eclipse.vmargs=-Duser.language=en
    -Xmx512M
    -Dosgi.splashLocation=C:\Downloads\Eclipse\MyEclipse40GA\eclipse\MyEclipseSplash.bmp
    -jar
    C:\Downloads\Eclipse\eclipse-SDK-3.1-win32\eclipse\startup.jar
    eof=eof
    file.encoding=Cp1252
    file.encoding.pkg=sun.io
    file.separator=\
    java.awt.graphicsenv=sun.awt.Win32GraphicsEnvironment
    java.awt.printerjob=sun.awt.windows.WPrinterJob
    java.class.path=C:\Downloads\Eclipse\eclipse-SDK-3.1-win32\eclipse\startup.jar
    java.class.version=49.0
    java.endorsed.dirs=C:\Program Files\Java\jre1.5.0_04\lib\endorsed
    java.ext.dirs=C:\Program Files\Java\jre1.5.0_04\lib\ext
    java.home=C:\Program Files\Java\jre1.5.0_04
    java.io.tmpdir=C:\DOCUME~1\casar474\LOCALS~1\Temp\
    java.library.path=C:\WINDOWS\system32;.;C:\WINDOWS\system32;C:\WINDOWS;C:\Sun\Tomcat 5.5\bin;C:\Program Files\Common Files\Business Objects\3.0\bin\NOTES\;C:\Program Files\Common Files\Business Objects\3.0\bin\NOTES\DATA\;C:\WINDOWS\system32;C:\WINDOWS;C:\WINDOWS\System32\Wbem;C:\Sun\Java\jdk1.5.0\bin;C:\Sun\apache-ant-1.6.2\bin;C:\Sun\Tomcat 5.5\bin\bin;C:\Sun\Java\jdk1.5.0;C:\Program Files\Common Files\Adaptec Shared\System;C:\Program Files\Sybase70\Adaptive Server Anywhere 6.0\win32;G\bin;c:\informix;C:\Program Files\Microsoft SQL Server\80\Tools\BINN;C:\Program Files\Informix\Connect\bin;C:\PROGRAM FILES\INFORMIX\CONNECT20\BIN
    java.naming.factory.initial=org.apache.naming.java.javaURLContextFactory
    java.naming.factory.url.pkgs=org.apache.naming
    java.runtime.name=Java(TM) 2 Runtime Environment, Standard Edition
    java.runtime.version=1.5.0_04-b05
    java.specification.name=Java Platform API Specification
    java.specification.vendor=Sun Microsystems Inc.
    java.specification.version=1.5
    java.vendor=Sun Microsystems Inc.
    java.vendor.url=http://java.sun.com/
    java.vendor.url.bug=http://java.sun.com/cgi-bin/bugreport.cgi
    java.version=1.5.0_04
    java.vm.info=mixed mode, sharing
    java.vm.name=Java HotSpot(TM) Client VM
    java.vm.specification.name=Java Virtual Machine Specification
    java.vm.specification.vendor=Sun Microsystems Inc.
    java.vm.specification.version=1.0
    java.vm.vendor=Sun Microsystems Inc.
    java.vm.version=1.5.0_04-b05
    line.separator=

    org.osgi.framework.bootdelegation=*
    org.osgi.framework.executionenvironment=J2SE-1.5
    org.osgi.framework.language=en
    org.osgi.framework.os.name=WindowsXP
    org.osgi.framework.os.version=5.1
    org.osgi.framework.processor=x86
    org.osgi.framework.system.packages=javax.accessibility,javax.activity,javax.crypto,javax.crypto.interfaces,javax.crypto.spec,javax.imageio,javax.imageio.event,javax.imageio.metadata,javax.imageio.plugins.bmp,javax.imageio.plugins.jpeg,javax.imageio.spi,javax.imageio.stream,javax.management,javax.management.loading,javax.management.modelmbean,javax.management.monitor,javax.management.openmbean,javax.management.relation,javax.management.remote,javax.management.remote.rmi,javax.management.timer,javax.naming,javax.naming.directory,javax.naming.event,javax.naming.ldap,javax.naming.spi,javax.net,javax.net.ssl,javax.print,javax.print.attribute,javax.print.attribute.standard,javax.print.event,javax.rmi,javax.rmi.CORBA,javax.rmi.ssl,javax.security.auth,javax.security.auth.callback,javax.security.auth.kerberos,javax.security.auth.login,javax.security.auth.spi,javax.security.auth.x500,javax.security.cert,javax.security.sasl,javax.sound.midi,javax.sound.midi.spi,javax.sound.sampled,javax.sound.sampled.spi,javax.sql,javax.sql.rowset,javax.sql.rowset.serial,javax.sql.rowset.spi,javax.swing,javax.swing.border,javax.swing.colorchooser,javax.swing.event,javax.swing.filechooser,javax.swing.plaf,javax.swing.plaf.basic,javax.swing.plaf.metal,javax.swing.plaf.multi,javax.swing.plaf.synth,javax.swing.table,javax.swing.text,javax.swing.text.html,javax.swing.text.html.parser,javax.swing.text.rtf,javax.swing.tree,javax.swing.undo,javax.transaction,javax.transaction.xa,javax.xml,javax.xml.datatype,javax.xml.namespace,javax.xml.parsers,javax.xml.transform,javax.xml.transform.dom,javax.xml.transform.sax,javax.xml.transform.stream,javax.xml.validation,javax.xml.xpath,org.ietf.jgss,org.omg.CORBA,org.omg.CORBA_2_3,org.omg.CORBA_2_3.portable,org.omg.CORBA.DynAnyPackage,org.omg.CORBA.ORBPackage,org.omg.CORBA.portable,org.omg.CORBA.TypeCodePackage,org.omg.CosNaming,org.omg.CosNaming.NamingContextExtPackage,org.omg.CosNaming.NamingContextPackage,org.omg.Dynamic,org.omg.DynamicAny,org.omg.DynamicAny.DynAnyFactoryPackage,org.omg.DynamicAny.DynAnyPackage,org.omg.IOP,org.omg.IOP.CodecFactoryPackage,org.omg.IOP.CodecPackage,org.omg.Messaging,org.omg.PortableInterceptor,org.omg.PortableInterceptor.ORBInitInfoPackage,org.omg.PortableServer,org.omg.PortableServer.CurrentPackage,org.omg.PortableServer.POAManagerPackage,org.omg.PortableServer.POAPackage,org.omg.PortableServer.portable,org.omg.PortableServer.ServantLocatorPackage,org.omg.SendingContext,org.omg.stub.java.rmi,org.w3c.dom,org.w3c.dom.bootstrap,org.w3c.dom.events,org.w3c.dom.ls,org.xml.sax,org.xml.sax.ext,org.xml.sax.helpers
    org.osgi.framework.vendor=Eclipse
    org.osgi.framework.version=1.3.0
    org.osgi.supports.framework.extension=true
    os.arch=x86
    os.name=Windows XP
    os.version=5.1
    osgi.arch=x86
    osgi.bundles=org.eclipse.core.runtime@2:start, org.eclipse.update.configurator@3:start
    osgi.bundlestore=c:\Downloads\Eclipse\eclipse-SDK-3.1-win32\eclipse\configuration\org.eclipse.osgi\bundles
    osgi.configuration.area=file:/c:/Downloads/Eclipse/eclipse-SDK-3.1-win32/eclipse/configuration/
    osgi.framework=file:/c:/Downloads/Eclipse/eclipse-SDK-3.1-win32/eclipse/plugins/org.eclipse.osgi_3.1.0.jar
    osgi.framework.beginningstartlevel=1
    osgi.framework.shape=jar
    osgi.framework.version=3.0.0
    osgi.install.area=file:/c:/Downloads/Eclipse/eclipse-SDK-3.1-win32/eclipse/
    osgi.instance.area=file:/C:/Downloads/Eclipse/eclipse-SDK-3.1-win32/workspace/
    osgi.instance.area.default=file:/C:/Documents and Settings/casar474/workspace/
    osgi.logfile=C:\Downloads\Eclipse\eclipse-SDK-3.1-win32\workspace\.metadata\.log
    osgi.manifest.cache=c:\Downloads\Eclipse\eclipse-SDK-3.1-win32\eclipse\configuration\org.eclipse.osgi\manifests
    osgi.nl=en_US
    osgi.os=win32
    osgi.splashLocation=C:\Downloads\Eclipse\MyEclipse40GA\eclipse\MyEclipseSplash.bmp
    osgi.splashPath=platform:/base/plugins/org.eclipse.platform
    osgi.syspath=c:\Downloads\Eclipse\eclipse-SDK-3.1-win32\eclipse\plugins
    osgi.ws=win32
    path.separator=;
    sun.arch.data.model=32
    sun.boot.class.path=C:\Program Files\Java\jre1.5.0_04\lib\rt.jar;C:\Program Files\Java\jre1.5.0_04\lib\i18n.jar;C:\Program Files\Java\jre1.5.0_04\lib\sunrsasign.jar;C:\Program Files\Java\jre1.5.0_04\lib\jsse.jar;C:\Program Files\Java\jre1.5.0_04\lib\jce.jar;C:\Program Files\Java\jre1.5.0_04\lib\charsets.jar;C:\Program Files\Java\jre1.5.0_04\classes
    sun.boot.library.path=C:\Program Files\Java\jre1.5.0_04\bin
    sun.cpu.endian=little
    sun.cpu.isalist=
    sun.desktop=windows
    sun.io.unicode.encoding=UnicodeLittle
    sun.jnu.encoding=Cp1252
    sun.management.compiler=HotSpot Client Compiler
    sun.os.patch.level=Service Pack 2
    user.country=US
    user.dir=C:\Downloads\Eclipse\eclipse-SDK-3.1-win32\eclipse
    user.home=C:\Documents and Settings\casar474
    user.language=en
    user.name=casar474
    user.timezone=America/Denver
    user.variant=

    *** Features:
    com.genuitec.myeclipse.ast (4.0.1) “MyEclipse Application Server Tooling”
    com.genuitec.myeclipse.bugzilla (4.0.0) “MyEclipse Bugzilla Feature”
    com.genuitec.myeclipse.core (4.0.1) “MyEclipse Core Feature”
    com.genuitec.myeclipse.database (4.0.1) “MyEclipse Database Feature”
    com.genuitec.myeclipse.enterprise.workbench (4.0.1) “MyEclipse Enterprise Workbench Feature”
    com.genuitec.myeclipse.help (4.0.1) “MyEclipse Help Feature”
    com.genuitec.myeclipse.hibernate (4.0.1) “MyEclipse Hibernate Feature”
    com.genuitec.myeclipse.jsf (4.0.1) “MyEclipse JSF Feature”
    com.genuitec.myeclipse.jspdesign (4.0.1) “MyEclipse JSP Design Feature”
    com.genuitec.myeclipse.platform (4.0.0) “MyEclipse Base Platform Feature”
    com.genuitec.myeclipse.spring (4.0.1) “MyEclipse Spring Feature”
    com.genuitec.myeclipse.struts (4.0.1) “MyEclipse Struts Feature”
    com.genuitec.myeclipse.tapestry (4.0.0) “MyEclipse Tapestry / Spindle Feature”
    com.genuitec.myeclipse.uml (4.0.1) “MyEclipse UML Feature”
    com.genuitec.myeclipse.wdt (4.0.1) “MyEclipse Web Development Feature”
    org.eclipse.emf (2.1.0) “Eclipse Modeling Framework (EMF)”
    org.eclipse.emf.doc (2.1.0) “Eclipse Modeling Framework (EMF) Programmers Guide”
    org.eclipse.emf.ecore.sdo (2.1.0) “EMF Service Data Objects (SDO)”
    org.eclipse.emf.ecore.sdo.doc (2.1.0) “EMF Service Data Objects (SDO) Programmers Guide”
    org.eclipse.emf.ecore.sdo.source (2.1.0) “EMF Service Data Objects (SDO) Source”
    org.eclipse.emf.examples (2.1.0) “Eclipse Modeling Framework (EMF) Examples”
    org.eclipse.emf.source (2.1.0) “Eclipse Modeling Framework (EMF) Source”
    org.eclipse.gef (3.1.0) “Graphical Editing Framework”
    org.eclipse.gef.examples (3.1.0) “GEF Examples”
    org.eclipse.gef.sdk (3.1.0) “Graphical Editing Framework Developer Resources”
    org.eclipse.gef.source (3.1.0) “Graphical Editing Framework Developer Resources”
    org.eclipse.jdt (3.1.0) “Eclipse Java Development Tools”
    org.eclipse.jdt.source (3.1.0) “Eclipse Java Development Tools SDK”
    org.eclipse.jem (1.1.0) “Java EMF Model”
    org.eclipse.jem.sdk (1.1.0) “Java EMF Model SDK”
    org.eclipse.jem.source (1.1.0) “Java EMF Model Source”
    org.eclipse.jst (0.7.0) “J2EE Standard Tools”
    org.eclipse.jst.sdk (0.7.0) “J2EE Standard Tools SDK”
    org.eclipse.pde (3.1.0) “Eclipse Plug-in Development Environment”
    org.eclipse.pde.source (3.1.0) “Eclipse Plug-in Development Environment Developer Resources”
    org.eclipse.platform (3.1.0) “Eclipse Platform”
    org.eclipse.platform.source (3.1.0) “Eclipse Platform Plug-in Developer Resources”
    org.eclipse.rcp (3.1.0) “Eclipse RCP”
    org.eclipse.rcp.source (3.1.0) “Eclipse RCP Plug-in Developer Resources”
    org.eclipse.sdk (3.1.0) “Eclipse Project SDK”
    org.eclipse.sdk.examples (3.0.1) “Eclipse SDK Examples”
    org.eclipse.team.extras (3.0.0) “Eclipse FTP and WebDAV Support”
    org.eclipse.uml2 (1.1.0) “UML2”
    org.eclipse.uml2.doc (1.1.0) “UML2 Documentation”
    org.eclipse.uml2.examples (1.1.0) “UML2 Examples”
    org.eclipse.uml2.examples.source (1.1.0) “UML2 Examples Source”
    org.eclipse.uml2.source (1.1.0) “UML2 Source”
    org.eclipse.ve (1.1.0) “Visual Editor”
    org.eclipse.ve.sdk (1.1.0) “Visual Editor SDK”
    org.eclipse.ve.source (1.1.0) “Visual Editor Source”
    org.eclipse.wst (0.7.0) “Web Standard Tools”
    org.eclipse.wst.sdk (0.7.0) “Web Standard Tools SDK”
    org.eclipse.xsd (2.1.0) “XML Schema Infoset Model (XSD)”
    org.eclipse.xsd.doc (2.1.0) “XML Schema Infoset Model (XSD) Programmers Guide”
    org.eclipse.xsd.source (2.1.0) “XML Schema Infoset Model (XSD) Source”

    *** Plug-in Registry:
    com.genuitec.eclipse.ast.deploy.core (4.0.1) “Deployment Core Plug-in” [Active]
    com.genuitec.eclipse.browser (3.8.4) “Web Browser Plug-in” [Resolved]
    com.genuitec.eclipse.bugzilla (3.9.310) “MyEclipse Bugzilla Integration Plug-in” [Resolved]
    com.genuitec.eclipse.core (4.0.1) “Genuitec Core” [Active]
    com.genuitec.eclipse.cross.easystruts.eclipse (4.0.1) “MyEclipse Stuts Support” [Active]
    com.genuitec.eclipse.easie.bejy (3.8.1) “Genuitec EASIE Bejy Tiger” [Active]
    com.genuitec.eclipse.easie.core (4.0.1) “Genuitec EASIE Core” [Active]
    com.genuitec.eclipse.easie.geronimo1 (3.9.310) “Genuitec EASIE Geronimo 1” [Active]
    com.genuitec.eclipse.easie.jboss (3.9.310) “Genuitec EASIE JBoss” [Active]
    com.genuitec.eclipse.easie.jboss2 (3.8.1) “Genuitec EASIE JBoss 2” [Active]
    com.genuitec.eclipse.easie.jboss3 (3.9.310) “Genuitec EASIE JBoss 3” [Active]
    com.genuitec.eclipse.easie.jboss4 (3.9.310) “Genuitec EASIE JBoss 4” [Active]
    com.genuitec.eclipse.easie.jetty (4.0.1) “Genuitec EASIE Jetty” [Active]
    com.genuitec.eclipse.easie.jetty4 (3.8.1) “Genuitec EASIE Jetty 4” [Active]
    com.genuitec.eclipse.easie.jetty5 (3.8.1) “Genuitec EASIE Jetty 5” [Active]
    com.genuitec.eclipse.easie.jonas (3.9.310) “Genuitec EASIE Jonas” [Active]
    com.genuitec.eclipse.easie.jonas3 (3.8.3) “Genuitec EASIE Jonas 3” [Active]
    com.genuitec.eclipse.easie.jonas4 (3.8.3) “Genuitec EASIE Jonas 4” [Active]
    com.genuitec.eclipse.easie.jrun (3.9.310) “Genuitec EASIE JRun” [Active]
    com.genuitec.eclipse.easie.jrun4 (3.8.1) “Genuitec EASIE JRun 4” [Active]
    com.genuitec.eclipse.easie.oracle (3.9.310) “Genuitec EASIE Oracle AS” [Active]
    com.genuitec.eclipse.easie.oracle9 (3.8.1) “Genuitec EASIE Oracle 9i/AS” [Active]
    com.genuitec.eclipse.easie.orion1 (3.8.1) “Genuitec EASIE Orion 1” [Active]
    com.genuitec.eclipse.easie.orion2 (3.8.1) “Genuitec EASIE Orion 2” [Active]
    com.genuitec.eclipse.easie.resin (3.8.1) “Genuitec EASIE Resin” [Active]
    com.genuitec.eclipse.easie.resin2 (3.8.1) “Genuitec EASIE Resin 2” [Active]
    com.genuitec.eclipse.easie.resin3 (3.8.3) “Genuitec EASIE Resin 3” [Active]
    com.genuitec.eclipse.easie.sun (3.9.310) “Genuitec EASIE Sun One” [Active]
    com.genuitec.eclipse.easie.sun8 (3.8.3) “Genuitec EASIE Sun 8” [Active]
    com.genuitec.eclipse.easie.sun81 (3.9.310) “Genuitec EASIE Sun 8.1” [Active]
    com.genuitec.eclipse.easie.tomcat (3.9.310) “Genuitec EASIE Tomcat” [Active]
    com.genuitec.eclipse.easie.tomcat4 (3.8.1) “Genuitec EASIE Tomcat 4” [Active]
    com.genuitec.eclipse.easie.tomcat5 (3.8.1) “Genuitec EASIE Tomcat 5” [Active]
    com.genuitec.eclipse.easie.weblogic (4.0.0) “Genuitec EASIE WebLogic” [Active]
    com.genuitec.eclipse.easie.weblogic6 (3.8.1) “Genuitec EASIE WebLogic 6” [Active]
    com.genuitec.eclipse.easie.weblogic7 (3.8.1) “Genuitec EASIE WebLogic 7” [Active]
    com.genuitec.eclipse.easie.weblogic8 (3.8.1) “Genuitec EASIE WebLogic 8” [Active]
    com.genuitec.eclipse.easie.weblogic9 (3.9.310) “Genuitec EASIE WebLogic 9” [Active]
    com.genuitec.eclipse.easie.websphere (3.9.310) “Genuitec EASIE WebSphere 4” [Active]
    com.genuitec.eclipse.easie.websphere5 (3.9.310) “Genuitec EASIE WebSphere 5” [Active]
    com.genuitec.eclipse.easie.websphere6 (3.9.310) “Genuitec EASIE WebSphere 6” [Active]
    com.genuitec.eclipse.export.wizard (3.9.210) “MyEclipse J2EE Export Wizards” [Resolved]
    com.genuitec.eclipse.hibernate (4.0.1) “MyEclipse Hibernate Capabilities” [Active]
    com.genuitec.eclipse.integration (4.0.1) “MyEclipse Integration Utilities” [Active]
    com.genuitec.eclipse.j2eedt.core (4.0.1) “Genuitec J2EE Development Tooling” [Active]
    com.genuitec.eclipse.jface.text.wtpfragment (3.8.1) “Wtpextendfragment Fragment” [Resolved]
    com.genuitec.eclipse.jsf (4.0.1) “MyEclipse JSF Capabilities” [Active]
    com.genuitec.eclipse.modeling.core (4.0.1) “MyEclipse Modeling Core” [Resolved]
    com.genuitec.eclipse.springframework (4.0.1) “Springframework Plug-in” [Resolved]
    com.genuitec.eclipse.sqlexplorer (4.0.1) “MyEclipse Database Explorer Plugin” [Active]
    com.genuitec.eclipse.sqlexplorer.doc (4.0.1) “MyEclipse Database Explorer Help Plug-in” [Resolved]
    com.genuitec.eclipse.sqlexplorer.oracle (4.0.1) “Oracle Database Explorer Plug-in” [Active]
    com.genuitec.eclipse.struts (4.0.1) “MyEclipse Struts Capabilities” [Active]
    com.genuitec.eclipse.tapestry (3.9.310) “MyEclipse Tapestry Integration Plug-in” [Active]
    com.genuitec.eclipse.tapestry.ui.contrib (4.0.0) “MyEclipse Tapestry UI Integration Fragment” [Resolved]
    com.genuitec.eclipse.uml (4.0.1) “MyEclipse UML Plug-in” [Resolved]
    com.genuitec.eclipse.wdt.jsp.debug (3.9.310) “MyEclipse JSP Debug Tooling” [Active]
    com.genuitec.eclipse.web.imagepreviewer (3.9.210) “MyEclipse Image Previewer Plug-in” [Active]
    com.genuitec.eclipse.webdesigner (4.0.1) “Web Designer Plug-in” [Active]
    com.genuitec.eclipse.webdesigner.support (3.9.211) “WebDesigner Support” [Resolved]
    com.genuitec.eclipse.wizards (4.0.1) “MyEclipse File Creation Wizards” [Active]
    com.genuitec.eclipsetidy (3.9.310) “MyEclipse HTML Formatting” [Active]
    com.genuitec.jboss.ide.eclipse.apache.xalan (3.8.1) “Genuitec XDoclet Apache Xalan Plug-in” [Resolved]
    com.genuitec.jboss.ide.eclipse.core (4.0.0) “Genuitec XDoclet Support Core Plug-in” [Resolved]
    com.genuitec.jboss.ide.eclipse.xdoclet.assist (3.9.210) “Genuitec XDoclet Assist Plug-in” [Resolved]
    com.genuitec.jboss.ide.eclipse.xdoclet.core (4.0.0) “Genuitec XDoclet Core Plug-in” [Resolved]
    com.genuitec.jboss.ide.eclipse.xdoclet.run (4.0.0) “Genuitec XDoclet Runner Plug-in” [Resolved]
    com.genuitec.jboss.ide.eclipse.xdoclet.ui (4.0.1) “Genuitec XDoclet UI Plug-in” [Resolved]
    com.genuitec.myeclipse.ast (4.0.1) “MyEclipse Application Server Tooling” [Resolved]
    com.genuitec.myeclipse.bugzilla (4.0.0) “MyEclipse Bugzilla Feature” [Resolved]
    com.genuitec.myeclipse.core (4.0.1) “MyEclipse Core Feature” [Resolved]
    com.genuitec.myeclipse.database (4.0.1) “MyEclipse Database Feature” [Resolved]
    com.genuitec.myeclipse.doc (4.0.1) “MyEclipse Documentation” [Resolved]
    com.genuitec.myeclipse.enterprise.workbench (4.0.1) “MyEclipse Enterprise Workbench Feature” [Resolved]
    com.genuitec.myeclipse.help (4.0.1) “MyEclipse Help Feature” [Resolved]
    com.genuitec.myeclipse.hibernate (4.0.1) “MyEclipse Hibernate Feature” [Resolved]
    com.genuitec.myeclipse.jsf (4.0.1) “MyEclipse JSF Feature” [Resolved]
    com.genuitec.myeclipse.jspdesign (4.0.1) “MyEclipse JSP Design Feature” [Resolved]
    com.genuitec.myeclipse.perspective (4.0.1) “MyEclipse Perspective Plug-in” [Active]
    com.genuitec.myeclipse.platform (4.0.0) “MyEclipse Base Platform Feature” [Resolved]
    com.genuitec.myeclipse.spring (4.0.1) “MyEclipse Spring Feature” [Resolved]
    com.genuitec.myeclipse.struts (4.0.1) “MyEclipse Struts Feature” [Resolved]
    com.genuitec.myeclipse.tapestry (4.0.0) “MyEclipse Tapestry / Spindle Feature” [Resolved]
    com.genuitec.myeclipse.uml (4.0.1) “MyEclipse UML Feature” [Resolved]
    com.genuitec.myeclipse.wdt (4.0.1) “MyEclipse Web Development Feature” [Resolved]
    com.ibm.base.extensions (13.8.1) “Eclipse base extensions” [Resolved]
    com.ibm.base.extensions.ui (13.9.310) “Eclipse Base UI extensions” [Active]
    com.ibm.encoding.resource (13.9.210) “Coded Resource” [Active]
    com.ibm.etools.contentmodel (13.8.4) “Content Model” [Resolved]
    com.ibm.etools.contentmodel.dtd (13.8.2) “Content Model for DTD” [Resolved]
    com.ibm.etools.contentmodel.xsd (13.8.1) “Content Model for XML Schema” [Resolved]
    com.ibm.etools.dtdmodel (14.0.0) “DTD Model” [Resolved]
    com.ibm.etools.dtdparser (13.8.1) “DTD Parser” [Resolved]
    com.ibm.etools.emf.event (3.0.0.1) “Event Model” [Resolved]
    com.ibm.etools.internet (13.8.1) “Internet Preferences” [Active]
    com.ibm.etools.uri.resolver (13.8.3) “com.ibm.etools.uri.resolver” [Resolved]
    com.ibm.etools.validation (13.8.4) “Validation Framework” [Resolved]
    com.ibm.etools.validation.core (13.8.4) “Validation Framework Core” [Resolved]
    com.ibm.etools.validation.dtd (13.8.4) “DTD Validator” [Resolved]
    com.ibm.etools.validation.html (13.8.3) “HTML Validation” [Resolved]
    com.ibm.etools.validation.mof (13.8.1) “Validation Framework MOF support” [Resolved]
    com.ibm.etools.validation.ui (13.8.3) “Validation Framework UI” [Resolved]
    com.ibm.etools.validation.xml (13.8.4) “XML Validator” [Resolved]
    com.ibm.etools.validation.xmltools (13.8.1) “XML Tools Validation” [Resolved]
    com.ibm.etools.validation.xsd (13.8.4) “XML Schema Validator” [Resolved]
    com.ibm.etools.xml.gef.util (13.9.210) “XML Tools Common GEF Utilities” [Resolved]
    com.ibm.etools.xmlcatalog (13.8.4) “com.ibm.etools.xmlcatalog” [Resolved]
    com.ibm.etools.xmlcatalog.ui (13.9.310) “XML Catalog UI” [Active]
    com.ibm.etools.xmlutility (13.8.1) “XML Utility” [Resolved]
    com.ibm.sse.contentproperties (13.8.1) “Content Properties” [Active]
    com.ibm.sse.editor (14.0.1) “MyEclipse Source Editors” [Active]
    com.ibm.sse.editor.css (14.0.1) “SSE CSS Source Editor” [Resolved]
    com.ibm.sse.editor.dtd (14.0.1) “SSE DTD Source Editor” [Resolved]
    com.ibm.sse.editor.extensions (13.8.1) “Structured Source Editing Editor Extensions” [Resolved]
    com.ibm.sse.editor.html (14.0.1) “SSE HTML Source Editor” [Resolved]
    com.ibm.sse.editor.javascript (14.0.1) “SSE JavaScript Source Editor” [Resolved]
    com.ibm.sse.editor.jsp (14.0.1) “SSE JSP Source Editor” [Resolved]
    com.ibm.sse.editor.xml (14.0.1) “SSE XML Source Editor” [Resolved]
    com.ibm.sse.javascript.common.ui (14.0.1) “SSE JavaScript Common UI” [Resolved]
    com.ibm.sse.model (14.0.1) “Structured Text Model” [Active]
    com.ibm.sse.model.css (13.9.310) “Structured Source CSS Model” [Active]
    com.ibm.sse.model.dtd (14.0.1) “Structured Source DTD Model” [Resolved]
    com.ibm.sse.model.html (13.9.310) “Structured Source HTML Model” [Active]
    com.ibm.sse.model.javascript (13.9.310) “Structured Source JavaScript Model” [Resolved]
    com.ibm.sse.model.jsp (14.0.1) “Structured Source JSP Model” [Active]
    com.ibm.sse.model.xml (14.0.1) “Structured Source XML Model” [Active]
    com.ibm.sse.snippets (14.0.1) “SSE Snippets View” [Active]
    com.ibm.webtooling.system.dtds (14.0.1) “Known DTDs” [Resolved]
    com.ibm.wtp.annotations.controller (13.8.1) “Annotation Controller Plug-in” [Resolved]
    com.ibm.wtp.annotations.core (13.9.210) “Annotation Core Plug-in” [Resolved]
    com.ibm.wtp.annotations.ui (13.8.1) “Ui Plug-in” [Resolved]
    com.ibm.wtp.common (13.8.1) “com.ibm.wtp.common” [Active]
    com.ibm.wtp.common.ui (13.8.1) “WTP UI Plug-in” [Resolved]
    com.ibm.wtp.common.util (1.0.0) “Logging Plug-in” [Active]
    com.ibm.wtp.emf (14.0.0) “EMF Utilities” [Resolved]
    com.ibm.wtp.emf.workbench (1.0.0) “EMF Workbench” [Resolved]
    com.ibm.wtp.emf.workbench.edit (14.0.0) “EMF Workbench Edit Plug-in” [Resolved]
    com.ibm.wtp.jdt.integration (13.8.1) “Integration Plug-in” [Resolved]
    com.ibm.xmleditor (14.0.0) “SSE XML Editor” [Resolved]
    com.ibm.xmlwizard (13.9.310) “XML Wizards” [Resolved]
    com.ibm.xsdeditor (13.9.310) “MyEclipse Schema Editor” [Active]
    com.ibm.xtools.common.ui.properties (14.0.1) “IBM Rational Common UI Properties” [Resolved]
    com.iw.plugins.spindle.core (4.0.0) “Spindle Core Plugin” [Resolved]
    com.iw.plugins.spindle.docs (3.9.310) “Spindle 3 Documentation” [Resolved]
    com.iw.plugins.spindle.ui (4.0.0) “Spindle UI plugin” [Resolved]
    de.bb.bje.eclipse (3.8.1) “BJE Plug-in” [Resolved]
    net.sf.solareclipse.ui (0.4.0.spindle-dep-6) “SolarEclipse UI” [Resolved]
    net.sf.solareclipse.xml.ui (0.4.0.spindle-dep-6) “XML Development Tools UI” [Resolved]
    org.apache.ant (1.6.5) “Apache Ant” [Resolved]
    org.apache.axis (1.2.1) “Axis121 Plug-in” [Resolved]
    org.apache.lucene (1.4.3) “Apache Lucene” [Resolved]
    org.apache.wsil4j (1.0.0) “Apache WSIL4J 1.0” [Resolved]
    org.apache.xerces (4.0.13) “Spindle 3 Xerces Plug-in” [Resolved]
    org.apache.xerces (2.7.0) “Xerces 2.7.0” [Resolved]
    org.eclipse.ant.core (3.1.0) “Ant Build Tool Core” [Resolved]
    org.eclipse.ant.ui (3.1.0) “Ant UI” [Resolved]
    org.eclipse.compare (3.1.0) “Compare Support” [Resolved]
    org.eclipse.compare.examples (3.0.0) “Compare Example” [Resolved]
    org.eclipse.compare.examples.xml (3.0.0) “XML Compare Support” [Resolved]
    org.eclipse.core.boot (3.1.0) “Core Boot” [Resolved]
    org.eclipse.core.commands (3.1.0) “Commands” [Active]
    org.eclipse.core.expressions (3.1.0) “Expression Language” [Active]
    org.eclipse.core.filebuffers (3.1.0) “File Buffers” [Active]
    org.eclipse.core.resources (3.1.0) “Core Resource Management” [Active]
    org.eclipse.core.resources.compatibility (3.1.0) “Core Resource Management Compatibility Fragment” [Resolved]
    org.eclipse.core.resources.win32 (3.1.0) “Core Resource Management Win32 Fragment” [Resolved]
    org.eclipse.core.runtime (3.1.0) “Core Runtime” [Active]
    org.eclipse.core.runtime.compatibility (3.1.0) “Core Runtime Plug-in Compatibility” [Active]
    org.eclipse.core.variables (3.1.0) “Core Variables” [Resolved]
    org.eclipse.debug.core (3.1.0) “Debug Core” [Active]
    org.eclipse.debug.ui (3.1.0) “Debug UI” [Active]
    org.eclipse.draw2d (3.1.0) “Draw2d” [Active]
    org.eclipse.draw2d.doc.isv (3.1.0) “Draw2D Documentation” [Resolved]
    org.eclipse.emf (2.1.0) “Eclipse Modeling Framework (EMF)” [Resolved]
    org.eclipse.emf.activities (2.1.0) “EMF Activities” [Resolved]
    org.eclipse.emf.ant (2.1.0) “EMF Ant Tasks” [Resolved]
    org.eclipse.emf.codegen (2.1.0) “EMF Template Code Generator” [Resolved]
    org.eclipse.emf.codegen.ecore (2.1.0) “EMF Ecore Code Generation” [Resolved]
    org.eclipse.emf.codegen.ecore.ui (2.1.0) “EMF Ecore Code Generation UI” [Resolved]
    org.eclipse.emf.codegen.ui (2.1.0) “EMF Template Code Generator UI” [Resolved]
    org.eclipse.emf.common (2.1.0) “EMF Common” [Resolved]
    org.eclipse.emf.common.ui (2.1.0) “EMF Common UI” [Resolved]
    org.eclipse.emf.commonj.sdo (2.1.0) “CommonJ SDO” [Resolved]
    org.eclipse.emf.doc (2.1.0) “Eclipse Modeling Framework (EMF) Programmers Guide” [Resolved]
    org.eclipse.emf.ecore (2.1.0) “EMF Ecore” [Resolved]
    org.eclipse.emf.ecore.change (2.1.0) “EMF Ecore Change Model” [Resolved]
    org.eclipse.emf.ecore.change.edit (2.1.0) “EMF Ecore Change Edit Support” [Resolved]
    org.eclipse.emf.ecore.edit (2.1.0) “EMF Ecore Edit Support” [Resolved]
    org.eclipse.emf.ecore.editor (2.1.0) “Sample Ecore Editor” [Resolved]
    org.eclipse.emf.ecore.sdo (2.1.0) “EMF Service Data Objects (SDO)” [Resolved]
    org.eclipse.emf.ecore.sdo.doc (2.1.0) “EMF Service Data Objects (SDO) Programmers Guide” [Resolved]
    org.eclipse.emf.ecore.sdo.edit (2.1.0) “EMF Service Data Objects (SDO) Edit Support” [Resolved]
    org.eclipse.emf.ecore.sdo.editor (2.1.0) “EMF Service Data Objects (SDO) Editor” [Resolved]
    org.eclipse.emf.ecore.sdo.source (2.1.0) “EMF Service Data Objects (SDO) Source” [Resolved]
    org.eclipse.emf.ecore.xmi (2.1.0) “EMF XMI” [Resolved]
    org.eclipse.emf.edit (2.1.0) “EMF Edit” [Resolved]
    org.eclipse.emf.edit.ui (2.1.0) “EMF Edit UI” [Resolved]
    org.eclipse.emf.examples (2.1.0) “Eclipse Modeling Framework (EMF) Examples” [Resolved]
    org.eclipse.emf.importer (2.1.0) “EMF Model Import Support” [Resolved]
    org.eclipse.emf.importer.ecore (2.1.0) “EMF Ecore Importer” [Resolved]
    org.eclipse.emf.importer.java (2.1.0) “EMF Annotated Java Importer” [Resolved]
    org.eclipse.emf.importer.rose (2.1.0) “EMF Rose Importer” [Resolved]
    org.eclipse.emf.java (2.1.0) “EMF Java” [Resolved]
    org.eclipse.emf.java.edit (2.1.0) “EMF Java Edit” [Resolved]
    org.eclipse.emf.java.editor (2.1.0) “EMF Java Editor” [Resolved]
    org.eclipse.emf.mapping (2.1.0) “EMF Mapping” [Resolved]
    org.eclipse.emf.mapping.ecore2ecore (2.1.0) “Ecore to Ecore Mapping” [Resolved]
    org.eclipse.emf.mapping.ecore2ecore.editor (2.1.0) “Ecore to Ecore Mapping Editor” [Resolved]
    org.eclipse.emf.mapping.ecore2xml (2.1.0) “Ecore to XML Mapping” [Resolved]
    org.eclipse.emf.mapping.ecore2xml.ui (2.1.0) “Ecore to XML Mapping UI” [Resolved]
    org.eclipse.emf.mapping.ui (2.1.0) “EMF Mapping UI” [Resolved]
    org.eclipse.emf.mapping.xsd2ecore (2.1.0) “XSD to Ecore Mapping” [Resolved]
    org.eclipse.emf.mapping.xsd2ecore.editor (2.1.0) “XSD to Ecore Mapping Editor” [Resolved]
    org.eclipse.emf.source (2.1.0) “Eclipse Modeling Framework (EMF) Source” [Resolved]
    org.eclipse.gef (3.1.0) “Graphical Editing Framework” [Resolved]
    org.eclipse.gef.doc.isv (3.1.0) “Graphical Editing Framework Documentation” [Resolved]
    org.eclipse.gef.examples.flow (3.1.0) “GEF Flow Editor Example” [Resolved]
    org.eclipse.gef.examples.logic (3.1.0) “GEF Logic Editor Example” [Resolved]
    org.eclipse.gef.examples.shapes (3.1.0) “GEF Shape Editor Example” [Resolved]
    org.eclipse.gef.examples.source (3.1.0) “GEF Examples” [Resolved]
    org.eclipse.gef.examples.text (3.1.0) “GEF Text Editor Example” [Resolved]
    org.eclipse.gef.source (3.1.0) “Graphical Editing Framework Developer Resources” [Resolved]
    org.eclipse.help (3.1.0) “Help System Core” [Active]
    org.eclipse.help.appserver (3.1.0) “Help Application Server” [Active]
    org.eclipse.help.base (3.1.0) “Help System Base” [Active]
    org.eclipse.help.examples.ex1 (3.0.0) “Online Help Sample” [Resolved]
    org.eclipse.help.ui (3.1.0) “Help System UI” [Active]
    org.eclipse.help.webapp (3.1.0) “Help System Webapp” [Resolved]
    org.eclipse.jdt (3.1.0) “Eclipse Java Development Tools” [Resolved]
    org.eclipse.jdt.core (3.1.0) “Java Development Tools Core” [Active]
    org.eclipse.jdt.debug (3.1.0) “JDI Debug Model” [Active]
    org.eclipse.jdt.debug.ui (3.1.0) “JDI Debug UI” [Resolved]
    org.eclipse.jdt.doc.isv (3.1.0) “Eclipse JDT Plug-in Developer Guide” [Resolved]
    org.eclipse.jdt.doc.user (3.1.0) “Eclipse Java Development User Guide” [Resolved]
    org.eclipse.jdt.junit (3.1.0) “Java Development Tools JUnit support” [Resolved]
    org.eclipse.jdt.junit.runtime (3.1.0) “Java Development Tools JUnit runtime support” [Resolved]
    org.eclipse.jdt.launching (3.1.0) “Java Development Tools Launching Support” [Resolved]
    org.eclipse.jdt.source (3.1.0) “Eclipse Java Development Tools SDK” [Resolved]
    org.eclipse.jdt.ui (3.1.0) “Java Development Tools UI” [Resolved]
    org.eclipse.jdt.ui.examples.projects (3.0.1) “Java Development Tools Example Projects” [Resolved]
    org.eclipse.jem (1.1.0) “Java EMF Model” [Resolved]
    org.eclipse.jem.beaninfo (1.1.0) “Java EMF Model BeanInfo (Introspection) Support” [Resolved]
    org.eclipse.jem.proxy (1.1.0) “Java EMF Model Proxy Support” [Resolved]
    org.eclipse.jem.sdk (1.1.0) “Java EMF Model SDK” [Resolved]
    org.eclipse.jem.source (1.1.0) “Java EMF Model Source” [Resolved]
    org.eclipse.jem.ui (1.1.0) “Java EMF Model UI” [Resolved]
    org.eclipse.jem.util (1.1.0) “Java EMF Model Utilities” [Resolved]
    org.eclipse.jem.workbench (1.1.0) “Java EMF Model Workbench Support” [Resolved]
    org.eclipse.jface (3.1.0) “JFace” [Active]
    org.eclipse.jface.text (3.1.0) “JFace Text” [Active]
    org.eclipse.jst (0.7.0) “J2EE Standard Tools” [Resolved]
    org.eclipse.jst.common.annotations.controller (0.7.0) “Annotation Controller Plug-in” [Resolved]
    org.eclipse.jst.common.annotations.core (0.7.0) “Annotation Core Plug-in” [Resolved]
    org.eclipse.jst.common.annotations.ui (0.7.0) “Ui Plug-in” [Resolved]
    org.eclipse.jst.common.frameworks (0.7.0) “Integration Plug-in” [Resolved]
    org.eclipse.jst.common.navigator.java (0.7.0) “Navigator Plug-in” [Resolved]
    org.eclipse.jst.doc.isv (0.7.0) “JST ISV Documentation” [Resolved]
    org.eclipse.jst.doc.user (0.7.0) “JST User Doc Plug-in” [Resolved]
    org.eclipse.jst.ejb.ui (0.7.0) “WTP EJB UI Plug-in” [Resolved]
    org.eclipse.jst.j2ee (0.7.0) “J2EE Component” [Resolved]
    org.eclipse.jst.j2ee.core (0.7.0) “J2EE Core Component” [Resolved]
    org.eclipse.jst.j2ee.ejb (0.7.0) “EJB component Plug-in” [Resolved]
    org.eclipse.jst.j2ee.ejb.annotation.model (0.7.0) “EJB Annotation Model Plug-in” [Resolved]
    org.eclipse.jst.j2ee.ejb.annotations.emitter (0.7.0) “EJB Emitter Plug-in” [Resolved]
    org.eclipse.jst.j2ee.ejb.annotations.ui (0.7.0) “EJB Annotations Ui Plug-in” [Resolved]
    org.eclipse.jst.j2ee.ejb.annotations.xdoclet (0.7.0) “Xdoclet Annotations Plug-in” [Resolved]
    org.eclipse.jst.j2ee.jca (0.7.0) “JCA Plug-in” [Resolved]
    org.eclipse.jst.j2ee.jca.ui (0.7.0) “WTP JCA UI Plug-in” [Resolved]
    org.eclipse.jst.j2ee.navigator.ui (0.7.0) “J2EE Extensions to Common Navigator” [Resolved]
    org.eclipse.jst.j2ee.ui (0.7.0) “WTP J2EE UI Plug-in” [Resolved]
    org.eclipse.jst.j2ee.web (0.7.0) “Web Plug-in” [Resolved]
    org.eclipse.jst.j2ee.webservice (0.7.0) “Web Service Plug-in” [Resolved]
    org.eclipse.jst.j2ee.webservices.ui (0.7.0) “WTP Webservice UI Plug-in” [Resolved]
    org.eclipse.jst.jsp.core (0.7.0) “Structured Source JSP Model” [Resolved]
    org.eclipse.jst.jsp.ui (0.7.0) “SSE JSP Source Editor” [Resolved]
    org.eclipse.jst.server.core (0.7.0) “Java Server Support” [Resolved]
    org.eclipse.jst.server.generic.core (0.7.0) “Generic Server Plugin” [Resolved]
    org.eclipse.jst.server.generic.serverdefinitions (0.7.0) “Generic server example definitions” [Resolved]
    org.eclipse.jst.server.generic.ui (0.7.0) “Generic Server Plugin UI” [Resolved]
    org.eclipse.jst.server.geronimo.core (0.7.0) “Geronimo server support” [Resolved]
    org.eclipse.jst.server.geronimo.ui (0.7.0) “Geronimo server UI support” [Resolved]
    org.eclipse.jst.server.tomcat.core (0.7.0) “Apache Tomcat Support” [Resolved]
    org.eclipse.jst.server.tomcat.ui (0.7.0) “Apache Tomcat UI Support” [Resolved]
    org.eclipse.jst.server.ui (0.7.0) “Java Server UI Support” [Resolved]
    org.eclipse.jst.server.websphere.core (0.7.0) “WebSphere Generic Server Definition Core Plug-in” [Resolved]
    org.eclipse.jst.servlet.ui (0.7.0) “WTP Servlet UI Plug-in” [Resolved]
    org.eclipse.jst.source (0.7.0) “J2EE Standard Tools SDK” [Resolved]
    org.eclipse.jst.ws (0.7.0) “Web Services” [Resolved]
    org.eclipse.jst.ws.axis.consumption.core (0.7.0) “Web service Axis Consumption Core” [Resolved]
    org.eclipse.jst.ws.axis.consumption.ui (0.7.0) “Webservice Axis Consumption UI” [Resolved]
    org.eclipse.jst.ws.axis.creation.ui (0.7.0) “Webservice Axis Creation UI” [Resolved]
    org.eclipse.jst.ws.consumption (0.7.0) “Web Services Consumption” [Resolved]
    org.eclipse.jst.ws.consumption.ui (0.7.0) “Web Services Consumption Graphical User Interface” [Resolved]
    org.eclipse.jst.ws.creation.ejb.ui (0.7.0) “Web Services Creation EJB Graphical User Interface” [Resolved]
    org.eclipse.jst.ws.creation.ui (0.7.0) “Web Services Creation Graphical User Interface” [Resolved]
    org.eclipse.jst.ws.uddiregistry (0.7.0) “Web Services Universal Description Discovery and Integration Registry” [Resolved]
    org.eclipse.jst.ws.ui (0.7.0) “Web Services Graphical User Interface” [Resolved]
    org.eclipse.ltk.core.refactoring (3.1.0) “Refactoring Core” [Resolved]
    org.eclipse.ltk.ui.refactoring (3.1.0) “Refactoring UI” [Resolved]
    org.eclipse.monitor.core (13.8.1) “Monitor” [Resolved]
    org.eclipse.monitor.ui (13.8.1) “TCP/IP Monitor” [Resolved]
    org.eclipse.osgi.services (3.1.0) “OSGi Release 3 Services” [Resolved]
    org.eclipse.osgi.util (3.1.0) “OSGi R3 Utility Classes” [Resolved]
    org.eclipse.pde (3.1.0) “Eclipse Plug-in Development Environment” [Resolved]
    org.eclipse.pde.build (3.1.0) “Plug-in Development Environment Build Support” [Resolved]
    org.eclipse.pde.core (3.1.0) “Plug-in Development Core” [Resolved]
    org.eclipse.pde.doc.user (3.1.0) “Eclipse Plug-in Development User Guide” [Resolved]
    org.eclipse.pde.junit.runtime (3.1.0) “PDE JUnit Plug-in Test” [Resolved]
    org.eclipse.pde.runtime (3.1.0) “Plug-in Development Environment Runtime” [Resolved]
    org.eclipse.pde.source (3.1.0) “Eclipse Plug-in Development Environment Developer Resources” [Resolved]
    org.eclipse.pde.ui (3.1.0) “Plug-in Development UI” [Resolved]
    org.eclipse.platform (3.1.0) “Eclipse Platform” [Resolved]
    org.eclipse.platform.doc.isv (3.1.0) “Eclipse Platform Plug-in Developer Guide” [Resolved]
    org.eclipse.platform.doc.user (3.1.0) “Eclipse Workbench User Guide” [Resolved]
    org.eclipse.platform.source (3.1.0) “Eclipse Platform Plug-in Developer Resources” [Resolved]
    org.eclipse.platform.source.win32.win32.x86 (3.1.0) “Eclipse Platform Plug-in Developer Resources” [Resolved]
    org.eclipse.rcp (3.1.0) “Eclipse RCP” [Resolved]
    org.eclipse.rcp.source (3.1.0) “Eclipse RCP Plug-in Developer Resources” [Resolved]
    org.eclipse.rcp.source.win32.win32.x86 (3.1.0) “Eclipse RCP Plug-in Developer Resources” [Resolved]
    org.eclipse.sdk (3.1.0) “Eclipse Project SDK” [Resolved]
    org.eclipse.sdk.examples (3.0.1) “Eclipse SDK Examples” [Resolved]
    org.eclipse.sdk.examples.source (3.0.1) “Eclipse Platform Plug-in Developer Resources” [Resolved]
    org.eclipse.sdk.examples.source.win32.win32.x86 (3.0.1) “Eclipse Platform Plug-in Developer Resources” [Resolved]
    org.eclipse.search (3.1.0) “Search Support” [Resolved]
    org.eclipse.swt (3.1.0) “Standard Widget Toolkit” [Resolved]
    org.eclipse.swt.examples (3.0.0) “SWT Standalone Examples Plugin” [Resolved]
    org.eclipse.swt.examples.browser (3.0.0) “SWT Browser Example Plugin” [Resolved]
    org.eclipse.swt.examples.controls (3.0.0) “SWT Controls Example Plugin” [Resolved]
    org.eclipse.swt.examples.launcher (3.0.0) “SWT Launcher Example Plugin” [Resolved]
    org.eclipse.swt.examples.layouts (3.0.0) “SWT Layout Example Plugin” [Resolved]
    org.eclipse.swt.examples.ole.win32 (3.0.0) “SWT OLE Example Plugin (Win32)” [Resolved]
    org.eclipse.swt.examples.paint (3.0.0) “SWT Paint Example Plugin” [Resolved]
    org.eclipse.swt.win32.win32.x86 (3.1.0) “Standard Widget Toolkit for Windows” [Resolved]
    org.eclipse.team.core (3.1.0) “Team Support Core” [Active]
    org.eclipse.team.cvs.core (3.1.0) “CVS Team Provider Core” [Resolved]
    org.eclipse.team.cvs.ssh (3.1.0) “CVS SSH Core” [Resolved]
    org.eclipse.team.cvs.ssh2 (3.1.0) “CVS SSH2” [Resolved]
    org.eclipse.team.cvs.ui (3.1.0) “CVS Team Provider UI” [Resolved]
    org.eclipse.team.examples.filesystem (3.0.0) “Eclipse Team File System Example” [Resolved]
    org.eclipse.team.extras (3.0.0) “Eclipse FTP and WebDAV Support” [Resolved]
    org.eclipse.team.extras.source (3.0.0) “Eclipse Team Extras Plug-in Developer Resources” [Resolved]
    org.eclipse.team.ftp (3.0.0) “FTP Deployment Provider” [Resolved]
    org.eclipse.team.ui (3.1.0) “Team Support UI” [Resolved]
    org.eclipse.team.webdav (3.0.0) “WebDAV Team Provider” [Resolved]
    org.eclipse.text (3.1.0) “Text” [Active]
    org.eclipse.tomcat (4.1.30.1) “Tomcat Wrapper” [Active]
    org.eclipse.ui (3.1.0) “Eclipse UI” [Active]
    org.eclipse.ui.browser (3.1.0) “Browser Support” [Resolved]
    org.eclipse.ui.cheatsheets (3.1.0) “Cheat Sheets” [Resolved]
    org.eclipse.ui.console (3.1.0) “Console” [Resolved]
    org.eclipse.ui.editors (3.1.0) “Default Text Editor” [Active]
    org.eclipse.ui.examples.javaeditor (3.0.0) “JFace Text Example” [Resolved]
    org.eclipse.ui.examples.multipageeditor (2.1.0) “Multi-Page Editor Example” [Resolved]
    org.eclipse.ui.examples.propertysheet (2.1.0) “User File Editor” [Resolved]
    org.eclipse.ui.examples.readmetool (2.1.0) “Readme File Editing Tool” [Resolved]
    org.eclipse.ui.externaltools (3.1.0) “External Tools” [Active]
    org.eclipse.ui.forms (3.1.0) “Eclipse Forms” [Active]
    org.eclipse.ui.ide (3.1.0) “Eclipse IDE UI” [Active]
    org.eclipse.ui.intro (3.1.0) “Welcome Framework” [Resolved]
    org.eclipse.ui.presentations.r21 (3.1.0) “R21 Presentation Plug-in” [Resolved]
    org.eclipse.ui.views (3.1.0) “Views” [Active]
    org.eclipse.ui.views.navigator (13.8.1) “Navigator View” [Resolved]
    org.eclipse.ui.win32 (3.1.0) “Eclipse UI Win32 Enhancements” [Resolved]
    org.eclipse.ui.workbench (3.1.0) “Workbench” [Active]
    org.eclipse.ui.workbench.compatibility (3.1.0) “Workbench Compatibility” [Resolved]
    org.eclipse.ui.workbench.texteditor (3.1.0) “Text Editor Framework” [Active]
    org.eclipse.uml2 (1.1.0) “UML2” [Resolved]
    org.eclipse.uml2.codegen.ecore (1.1.0) “UML2 Ecore Code Generation” [Resolved]
    org.eclipse.uml2.codegen.ecore.ui (1.1.0) “UML2 Ecore Code Generation UI” [Resolved]
    org.eclipse.uml2.common (1.1.0) “UML2 Common” [Resolved]
    org.eclipse.uml2.common.edit (1.1.0) “UML2 Common Edit” [Resolved]
    org.eclipse.uml2.doc (1.1.0) “UML2 Documentation” [Resolved]
    org.eclipse.uml2.ecore.importer (1.1.0) “UML2 Importer for EMF” [Resolved]
    org.eclipse.uml2.edit (1.1.0) “UML2 Edit Support” [Resolved]
    org.eclipse.uml2.editor (1.1.0) “UML2 Editor” [Resolved]
    org.eclipse.uml2.examples (1.1.0) “UML2 Examples” [Resolved]
    org.eclipse.uml2.examples.emof2ecore (1.1.0) “UML2 EMOF2Ecore Example” [Resolved]
    org.eclipse.uml2.examples.source (1.1.0) “UML2 Examples Source” [Resolved]
    org.eclipse.uml2.examples.ui (1.1.0) “UML2 Examples UI” [Resolved]
    org.eclipse.uml2.resources (1.1.0) “UML2 Resources” [Resolved]
    org.eclipse.uml2.source (1.1.0) “UML2 Source” [Resolved]
    org.eclipse.update.configurator (3.1.0) “Install/Update Configurator” [Active]
    org.eclipse.update.core (3.1.0) “Install/Update Core” [Resolved]
    org.eclipse.update.core.win32 (3.1.0) “Install/Update Core for Windows” [Resolved]
    org.eclipse.update.scheduler (3.1.0) “Automatic Updates Scheduler” [Active]
    org.eclipse.update.ui (3.1.0) “Install/Update UI” [Resolved]
    org.eclipse.ve (1.1.0) “Visual Editor” [Resolved]
    org.eclipse.ve.cde (1.1.0) “Visual Editor Common Data Editor” [Resolved]
    org.eclipse.ve.doc (1.1.0) “Visual Editor for Java User Guide” [Resolved]
    org.eclipse.ve.java.core (1.1.0) “Visual Editor Java Core” [Resolved]
    org.eclipse.ve.jfc (1.1.0) “Visual Editor for Java Foundation Classes” [Resolved]
    org.eclipse.ve.propertysheet (1.1.0) “Visual Editor PropertySheet” [Resolved]
    org.eclipse.ve.sdk (1.1.0) “Visual Editor SDK” [Resolved]
    org.eclipse.ve.source (1.1.0) “Visual Editor Source” [Resolved]
    org.eclipse.ve.swt (1.1.0) “Visual Editor for Standard Widget Toolkit” [Resolved]
    org.eclipse.webbrowser (14.0.1) “Web Browser” [Active]
    org.eclipse.webdav (3.0.0) “WebDAV Client” [Resolved]
    org.eclipse.wst (0.7.0) “Web Standard Tools” [Resolved]
    org.eclipse.wst.command.env (0.7.0) “Environment Command Framework (headless)” [Resolved]
    org.eclipse.wst.command.env.core (0.7.0) “Environment Command Framework (core)” [Resolved]
    org.eclipse.wst.command.env.ui (0.7.0) “Environment Command Framework (GUI)” [Resolved]
    org.eclipse.wst.common.emf (0.7.0) “EMF Utilities” [Resolved]
    org.eclipse.wst.common.emfworkbench.integration (0.7.0) “EMF Workbench Edit Plug-in” [Resolved]
    org.eclipse.wst.common.frameworks (0.7.0) “org.eclipse.wst.common.frameworks” [Resolved]
    org.eclipse.wst.common.frameworks.ui (0.7.0) “WTP UI Plug-in” [Resolved]
    org.eclipse.wst.common.modulecore (0.7.0) “Modulecore Plug-in” [Resolved]
    org.eclipse.wst.common.navigator.views (0.7.0) “Common Navigator View” [Resolved]
    org.eclipse.wst.common.navigator.workbench (0.7.0) “Navigator Workbench Components” [Resolved]
    org.eclipse.wst.common.snippets (0.7.0) “Snippets View” [Resolved]
    org.eclipse.wst.common.ui (0.7.0) “Eclipse Base UI extensions” [Resolved]
    org.eclipse.wst.common.ui.properties (0.7.0) “Common Properties UI” [Resolved]
    org.eclipse.wst.common.uriresolver (0.7.0) “org.eclipse.wst.common.uriresolver” [Resolved]
    org.eclipse.wst.css.core (0.7.0) “Structured Source CSS Model” [Resolved]
    org.eclipse.wst.css.ui (0.7.0) “SSE CSS Source Editor” [Resolved]
    org.eclipse.wst.doc.isv (0.7.0) “WST ISV Documentation” [Resolved]
    org.eclipse.wst.doc.user (0.7.0) “Web Standard Tools Help User Doc Plug-in” [Resolved]
    org.eclipse.wst.dtd.core (0.7.0) “Structured Source DTD Core” [Resolved]
    org.eclipse.wst.dtd.ui (0.7.0) “SSE DTD Source Editor” [Resolved]
    org.eclipse.wst.html.core (0.7.0) “Structured Source HTML Model” [Resolved]
    org.eclipse.wst.html.standard.dtds (0.7.0) “Known DTDs” [Resolved]
    org.eclipse.wst.html.ui (0.7.0) “HTML UI Source Editor” [Resolved]
    org.eclipse.wst.internet.cache (0.7.0) “Cache URI Resolver Plug-in” [Resolved]
    org.eclipse.wst.internet.monitor.core (0.7.0) “Monitor” [Resolved]
    org.eclipse.wst.internet.monitor.ui (0.7.0) “TCP/IP Monitor” [Resolved]
    org.eclipse.wst.internet.proxy (0.7.0) “Internet Proxy Preferences” [Active]
    org.eclipse.wst.javascript.core (0.7.0) “Structured Source JavaScript Model” [Resolved]
    org.eclipse.wst.javascript.ui (0.7.0) “SSE JavaScript Source Editor” [Resolved]
    org.eclipse.wst.rdb.connection.ui (0.7.0) “RDB Connection.ui” [Resolved]
    org.eclipse.wst.rdb.core (0.7.0) “RDB Core” [Resolved]
    org.eclipse.wst.rdb.core.ui (0.7.0) “Core UI plugin” [Resolved]
    org.eclipse.wst.rdb.data.core (0.7.0) “Data Core Plugin” [Resolved]
    org.eclipse.wst.rdb.data.ui (0.7.0) “Data UI Plugin” [Resolved]
    org.eclipse.wst.rdb.dbdefinition.db2.iseries (1.0.0) “DB2 UDB iSeries Database Definition Plug-in” [Resolved]
    org.eclipse.wst.rdb.dbdefinition.db2.luw (0.7.0) “DB2 UDB Database Definition Plug-in” [Resolved]
    org.eclipse.wst.rdb.dbdefinition.db2.zseries (0.7.0) “DB2 UDB Database Definition Plug-in” [Resolved]
    org.eclipse.wst.rdb.dbdefinition.derby (0.7.0) “IBM Cloudscape Database Definition” [Resolved]
    org.eclipse.wst.rdb.dbdefinition.informix (0.7.0) “Informix Database Definition Plug-in” [Resolved]
    org.eclipse.wst.rdb.dbdefinition.mysql (0.7.0) “DBDefinition Mysql Plug-in” [Resolved]
    org.eclipse.wst.rdb.dbdefinition.oracle (0.7.0) “Oracle Database Definition Plug-in” [Resolved]
    org.eclipse.wst.rdb.dbdefinition.sqlserver (0.7.0) “SQL Server Database Definition Plug-in” [Resolved]
    org.eclipse.wst.rdb.dbdefinition.sybase (0.7.0) “Sybase Database Definition Plug-in” [Resolved]
    org.eclipse.wst.rdb.derby (0.7.0) “RDB Derby Plug-in” [Resolved]
    org.eclipse.wst.rdb.derby.ui (0.7.0) “RDB Derby Ui Plug-in” [Resolved]
    org.eclipse.wst.rdb.fe.ui (0.7.0) “FE Ui Plug-in” [Resolved]
    org.eclipse.wst.rdb.fe.ui.actions (0.7.0) “FE Ui Actions Plug-in” [Resolved]
    org.eclipse.wst.rdb.models.dbdefinition (0.7.0) “DBDefinition Model” [Resolved]
    org.eclipse.wst.rdb.models.sql (0.7.0) “SQLModel Plug-in” [Resolved]
    org.eclipse.wst.rdb.models.sql.edit (0.7.0) “SQLModel Edit Plug-in” [Resolved]
    org.eclipse.wst.rdb.mysql (0.7.0) “RDB Mysql Plug-in” [Resolved]
    org.eclipse.wst.rdb.outputview (0.7.0) “Data Output Plug-in” [Resolved]
    org.eclipse.wst.rdb.server.extensions (0.7.0) “Server Explorer Extensions Plug-in” [Resolved]
    org.eclipse.wst.rdb.server.ui (0.7.0) “Server Explorer plugin” [Resolved]
    org.eclipse.wst.rdb.sqleditor (0.7.0) “SQL Source Editor Plugin” [Resolved]
    org.eclipse.wst.rdb.sqlscrapbook (0.7.0) “Sqlscrapbook Plug-in” [Resolved]
    org.eclipse.wst.server.core (0.7.0) “Server Core” [Resolved]
    org.eclipse.wst.server.ui (0.7.0) “Server UI” [Resolved]
    org.eclipse.wst.source (0.7.0) “Web Standard Tools SDK” [Resolved]
    org.eclipse.wst.sse.core (0.7.0) “Structured Text Model” [Resolved]
    org.eclipse.wst.sse.ui (0.7.0) “Structured Source Editor” [Resolved]
    org.eclipse.wst.validation (0.7.0) “Validation Framework” [Resolved]
    org.eclipse.wst.validation.ui (0.7.0) “Validation Framework UI” [Resolved]
    org.eclipse.wst.web (0.7.0) “Simple Web Plug-in” [Resolved]
    org.eclipse.wst.web.ui (0.7.0) “Simple Web UI Plug-in” [Resolved]
    org.eclipse.wst.ws (0.7.0) “Web Services” [Resolved]
    org.eclipse.wst.ws.explorer (0.7.0) “Web Services Explorer” [Resolved]
    org.eclipse.wst.ws.parser (0.7.0) “Web Services Description Parser” [Resolved]
    org.eclipse.wst.ws.ui (0.7.0) “Web Services UI” [Resolved]
    org.eclipse.wst.wsdl (0.7.0) “WSDL Model” [Resolved]
    org.eclipse.wst.wsdl.ui (0.7.0) “WSDL Editor” [Resolved]
    org.eclipse.wst.wsdl.validation (0.7.0) “WSDL Validator” [Resolved]
    org.eclipse.wst.wsi (0.7.0) “WSI Conformance Tools” [Resolved]
    org.eclipse.wst.wsi.ui (0.7.0) “Soap Monitor” [Resolved]
    org.eclipse.wst.xml.core (0.7.0) “Structured Source XML Model” [Resolved]
    org.eclipse.wst.xml.ui (0.7.0) “XML UI Plugin” [Resolved]
    org.eclipse.wst.xsd.core (0.7.0) “XSD Core Plugin” [Resolved]
    org.eclipse.wst.xsd.ui (0.7.0) “XML Schema Editor” [Resolved]
    org.eclipse.xsd (2.1.0) “XML Schema Infoset Model (XSD)” [Resolved]
    org.eclipse.xsd.doc (2.1.0) “XML Schema Infoset Model (XSD) Programmers Guide” [Resolved]
    org.eclipse.xsd.ecore.importer (2.1.0) “XML Schema Importer for EMF” [Resolved]
    org.eclipse.xsd.edit (2.0.1) “XML Schema Edit Framework” [Resolved]
    org.eclipse.xsd.edit (2.1.0) “XML Schema Edit Framework” [Resolved]
    org.eclipse.xsd.editor (2.1.0) “XML Schema Editor” [Resolved]
    org.eclipse.xsd.example (2.1.0) “XML Schema Infoset Model Example” [Resolved]
    org.eclipse.xsd.source (2.1.0) “XML Schema Infoset Model (XSD) Source” [Resolved]
    org.junit (3.8.1) “JUnit Testing Framework” [Resolved]
    org.springframework.ide.eclipse.beans.core (4.0.1) “MyEclipse Spring IDE Beans Support Core” [Resolved]
    org.springframework.ide.eclipse.beans.ui (4.0.1) “MyEclipse Spring IDE Beans UI” [Resolved]
    org.springframework.ide.eclipse.beans.ui.doc (4.0.1) “MyEclipse Spring IDE Support Documentation” [Resolved]
    org.springframework.ide.eclipse.beans.ui.graph (4.0.1) “MyEclipse Spring IDE Support Graph” [Resolved]
    org.springframework.ide.eclipse.core (4.0.1) “MyEclipse Spring IDE Core” [Resolved]
    org.springframework.ide.eclipse.core.doc (4.0.0) “MyEclipse Spring Framework Reference Documentation” [Resolved]
    org.springframework.ide.eclipse.ui (4.0.1) “pluginName” [Resolved]
    org.uddi4j (2.0.3) “UDDI4J 2.0.3” [Resolved]
    org.wsdl4j (1.4.0) “WSDL4J 1.4” [Resolved]
    system.bundle (3.1.0) “OSGi System Bundle” [Active]

    October 6, 2005 at 1:50 pm #238839 Reply

    Brian Fernandes
    Moderator

    Thank you for all that detail, I understand your issue exactly.

    
select ofndr_num, rlse_dt, rlse_typ, nmcd, lgl_stat, chg_rsn, bed_id, cmplx_id, fclty_id, cmplx_name, fclty_name from otrk:dba.v_nm_rlse_fclty

    this seems to be the select statement that was generated by “Generate Select Statement for view” (please confirm).

    The error looks like it’s caused becuase the generated SQL query is incorrect somehow.
    The from part of the query looks incorrect to me, what is the name of your view and your schema? Conversely, what do otrk, dba nd v_nm_rlse_fclty represent?

    I’m investigating this now, in the meanwhile can you tell me what the “correct” select statement for the view should be?

    Best,
    Brian.

    October 6, 2005 at 2:47 pm #238846 Reply

    CasadosRalphL
    Member

    You are correct, however the SQL statement looks fine. Below is a similar select state ment example that works dealing with 2 tables from a diff. Informix database and works fine.
    Ihave tried different variations and no success on this not sure what to do.

    select ofndr.ofndr_num, ofndr.sex,ofndr.eye_color_cd,ofndr.hair_color_cd,eye_color_cd.eye_color_desc
    from ofndr left outer join eye_color_cd ON ofndr.eye_color_cd = eye_color_cd.eye_color_cd;

    October 6, 2005 at 2:52 pm #238848 Reply

    CasadosRalphL
    Member

    Here is an example that works from the same database but not using a view it uses a table and it works just fine. 🙁

    select ppt_id, ofndr_num, audit_start_dt, audit_start_id, pp_stat, pp_stat_dt, pp_sent_dt, pp_reg_loc, rec_fac_dt, rec_pb_dt, pcert_gen_dt, pcert_sent_dt, audit_cmts, pb_cmts, par_cert_num, cert_cmplx_sent, cert_fac_sent, cert_return_dt, updt_dt, updt_usr_id from otrk:dba.nm_ppts

    October 6, 2005 at 3:23 pm #238850 Reply

    Brian Fernandes
    Moderator

    Could you please confirm that otrk is the name of your database, dba is your schema and v_nm_rlse_fclty is your view?

    What happens if you try “select * from otrk:dba.v_nm_rlse_fclty”?

    Can you try executing the query outside our SQL editor? Does it work then?

    It looks like one of your date fields has invalid data, (perhaps rlse_dt is the field causing issues – is that your date field?)

    1) Try out a “select *” query on the table which contains the rlse_dt field (or your date field).
    2) Modify the query generated for the view to omit the date field.

    The SQL used to create the view would be helpful.

    Best,
    Brian.

    October 6, 2005 at 3:41 pm #238851 Reply

    CasadosRalphL
    Member

    I have tried your suggestions on the view and no success, I even recreated the view and excluded the date field same error. I can access and get the view to run in MS Access, Sybase Sql editor and it runs fine. I have tried different variations and it will run fine in other software sql editors not sure what to do.

    October 6, 2005 at 4:01 pm #238859 Reply

    CasadosRalphL
    Member

    Well here’s another good for you Brian. I went to a couple other views via the Informix with date fields and they work fine. I recreated the view in MyEclipse from the tables themselves and it works, so Im unsure as to what to do to make this happen. Or what the cause could be any suggestions??

    Regards
    Ralph

    October 6, 2005 at 4:05 pm #238862 Reply

    CasadosRalphL
    Member

    Here’s even a better on for you on the DB Explorer you can see the
    table info shows the colums, indexs, primary key and so on. If I click the preview
    for this view it will display the data :). But go generate the SQL statement and gives you the error.

    How you like them apples :s

    October 6, 2005 at 4:12 pm #238867 Reply

    Brian Fernandes
    Moderator

    So you’re able to execute the exact same query on the same view in other editors, but if you try executing it in the MyEclipse SQL editor, you get the error?
    If this is the case, then it looks like we’re doing something wrong, I’d appreciate your assistance tracking it down.

    Also, you’re saying that other views with date fields in Informix can be queried from MyEclipse, but this one isn’t working?

    1) Try out a “select *” query on the table (not the view) which contains the rlse_dt field (or your date field).

    What happens when you do this in our SQL editor, do the results appear fine?

    I even recreated the view and excluded the date field same error.

    Could you please confirm this, you re-created the view such that the date field was omitted and then ran select on the re-created view and you still get a “String to date conversion error”?
    Just confirming that “recreating the view” means writing a new “create view v_nm_rlse_fclty as ….” and not simply leaving out the date field from the select statment in the same view.

    Is all the date data in the rlse_dt field valid (if it is possible for you to ascertain this manually)?

    Best,
    Brian.

  • Author
    Posts
Viewing 11 posts - 1 through 11 (of 11 total)
Reply To: SQL Editor

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