Hi,
<1>
the foreign-key tag was genereted by the devgui
<2>
CLIENTNEEDS_LABEL field well exist with this case, but i have an idea where the
problem.
In fact there are two problems :
1 -
i have put in my dbforms-config isKey="true" on the CLIENTNEEDS_LABEL field but
the field on the DB is not a key at all !
i have put this because i use parent/child link in a single page for CLIENTNEEDS
table and dbforms tell me (it done the excpetion below) to do it, i guess
because LABEL is a NOT NULL field but not a key!
java.lang.IllegalArgumentException: ERROR: Make sure that field
CLIENTNEEDS_LABEL is a KEY of the table OTFE_CLIENTNEEDS! Otherwise you can not
use it as PARENT/CHILD LINK argument!
at org.dbforms.config.Table.mapChildFieldValues(Table.java:1864)
at
org.dbforms.taglib.DbFormTag.initChildFieldValues(DbFormTag.java:2334)
at org.dbforms.taglib.DbFormTag.doStartTag(DbFormTag.java:1445)
at
org.apache.jsp._OTFE_5F_CLIENTNEEDS_5F_single._jspService(_OTFE_5F_CLIENTNEEDS_5F_single.java:842)
at
com.ibm.ws.webcontainer.jsp.runtime.HttpJspBase.service(HttpJspBase.java:89)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:853)
i have on the CLIENTSNEEDS single page :
<db:dbform captionResource="true"
autoUpdate="false"
followUp="PRODUCTSERVICES_single.jsp"
childField="PRODSERV_CODE"
parentField="PRODSERV_CODE"
maxRows="5"
tableName="OTFE_OUTLETOFFERING">
and in the dbforms-config.xml
<table name="OTFE_CLIENTNEEDS"
defaultVisibleFields="CLIENTNEEDS_CODE,CLIENTNEEDS_LABEL">
<field name="CLIENTNEEDS_CODE" fieldType="char" size="20" isKey="true"/>
<field name="CLIENTNEEDS_LABEL" fieldType="char" size="100"/>
<field name="CLIENTNEEDS_DESCRIPTION" fieldType="char" size="400"
defaultValue=""/>
<field name="CLIENTNEEDS_TRANSLATION" fieldType="char" size="1000"
defaultValue=""/>
<field name="CLIENTNEEDS_PICTURE_NAME" fieldType="diskblob"
directory="d:/temp/upload" encoding="true" size="50"/>
</table>
<table name="OTFE_OUTLETOFFERING"
defaultVisibleFields="CLIENTNEEDS_CODE,OUTLET_CODE,PRODSERV_CODE">
<field name="OUTLET_CODE" fieldType="char" size="20" isKey="true"/>
<field name="CLIENTNEEDS_LABEL" fieldType="char" size="10"/>
<field name="PRODSERV_CODE" fieldType="char" size="20" isKey="true"/>
<field name="OFFERING_PRICE" fieldType="double" size="22" defaultValue=""/>
<field name="OFFERING_CURRENCY_UNIT" fieldType="char" size="20"
defaultValue=""/>
<field name="OFFERING_PRICE_VALIDITY_END" fieldType="date" size="7"
defaultValue=""/>
<field name="OFFERING_PROMOTION_FLAG" fieldType="char" size="1"
defaultValue=""/>
<foreign-key name="FK_OTFE_OUT_OTFE_OUTL_OTFE_CLI"
foreignTable="OTFE_CLIENTNEEDS"
displayType="select">
<reference local="CLIENTNEEDS_LABEL"
foreign="CLIENTNEEDS_LABEL"/>
</foreign-key>
<foreign-key name="FK_OTFE_OUTOFFERING_OUTLET"
foreignTable="OTFE_OUTLET"
displayType="select">
<reference local="OUTLET_CODE"
foreign="OUTLET_CODE"/>
</foreign-key>
<foreign-key name="FK_OTFE_OUT_OTFE_OUTL_OTFE_PRO"
foreignTable="OTFE_PRODUCTSERVICES"
displayType="select">
<reference local="PRODSERV_CODE"
foreign="PRODSERV_CODE"/>
</foreign-key>
</table>
<table name="OTFE_PRODUCTSERVICES" defaultVisibleFields="PRODSERV_CODE">
<field name="PRODSERV_CODE" fieldType="char" size="20" isKey="true"/>
<field name="CLIENTNEEDS_CODE" fieldType="char" size="21" sortable="true"/>
<field name="PRODSERV_LABEL" fieldType="char" size="100" defaultValue=""/>
<field name="PRODSERV_LANGUAGE" fieldType="char" size="2" defaultValue=""/>
<field name="PRODSERV_DESCRIPTION" fieldType="char" size="4000"
defaultValue=""/>
<field name="PRODSERV_WEBSITE" fieldType="char" size="100" defaultValue=""/>
<field name="PRODSERV_TRANSLATION" fieldType="char" size="1000"
defaultValue=""/>
<field name="PRODSERV_PICTURE_NAME" fieldType="diskblob"
directory="D:\TEMP\upload\productServices\picture" encoding="true" size="50"/>
<field name="PRODSERV_PICTURE1_NAME" fieldType="diskblob"
directory="D:\TEMP\upload\productServices\picture1" encoding="true" size="50"/>
<foreign-key name="FK_OTFE_PRO_OTFE_NEED_OTFE_CLI"
foreignTable="OTFE_CLIENTNEEDS"
displayType="select">
<reference local="CLIENTNEEDS_CODE"
foreign="CLIENTNEEDS_CODE"/>
</foreign-key>
2 ? I use the tableData in PRODUCTSERVICES single page where i have
foreing-key on the CLIENTNEEDS_CODE, and i want display CLIENTSNEEDS_LABEL, in a
drop down list for foreign value.
Thanks,
Pascal
Selon Ivan Codarin <[EMAIL PROTECTED]>:
> Hi,
> <1>
> tableData tag does not need to have the "foreignTable" in the
> dbforms-config.xml
> file. So you do not need to declare it!
> <2>
> It seems that in your DB does not exists a CLIENTNEEDS_LABEL field, I see
> that
> you are useing Oracle (and I don't know it so well). In my case with
> postgresq
> I have to use CASE SENSITIVE fields, are you sure that CLIENTNEEDS_LABEL
> appares with this CASE and name on your database.
> Tipically the tableData creates a query like
>
> SELECT CLIENTNEEDS_CODE,CLIENTNEEDS_LABEL FROM OTFE_CLIENTNEEDS
>
> try this query in a SQL-Query tool agaisnt your db! Or try to see the log of
> your DBMS.
>
> Hope this helps.
> Regards
> Ivan
>
>
> Quoting [EMAIL PROTECTED]:
>
> > Hi,
> >
> > I try to select data from another tables
> >
> > <db:message key="Code"/>
> > <db:select fieldName="CLIENTNEEDS_CODE">
> > <db:tableData storeField="CLIENTNEEDS_CODE"
> > visibleFields="CLIENTNEEDS_LABEL"
> > foreignTable="OTFE_CLIENTNEEDS"
> > name="FK_OTFE_PRO_OTFE_NEED_OTFE_CLI"/>
> > </db:select>
> >
> >
> > my table PRODUCTSERVICES is like this :
> >
> > <table name="OTFE_PRODUCTSERVICES" defaultVisibleFields="PRODSERV_CODE">
> > <field name="PRODSERV_CODE" Code" fieldType="char" size="20"
> isKey="true"/>
> > <field name="CLIENTNEEDS_CODE" fieldType="char" size="21"
> sortable="true"/>
> > <field name="PRODSERV_LABEL" fieldType="char" size="100" defaultValue=""/>
> > <field name="PRODSERV_LANGUAGE" fieldType="char" size="2"
> defaultValue=""/>
> > <field name="PRODSERV_DESCRIPTION" fieldType="char" size="4000"
> > defaultValue=""/>
> > <field name="PRODSERV_WEBSITE" fieldType="char" size="100"
> defaultValue=""/>
> > <field name="PRODSERV_TRANSLATION" fieldType="char" size="1000"
> > defaultValue=""/>
> > <field name="PRODSERV_PICTURE_NAME" fieldType="diskblob"
> > directory="D:\TEMP\upload\productServices\picture" encoding="true"
> > size="50"/>
> > <field name="PRODSERV_PICTURE1_NAME" fieldType="diskblob"
> > directory="D:\TEMP\upload\productServices\picture1" encoding="true"
> > size="50"/>
> > <foreign-key name="FK_OTFE_PRO_OTFE_NEED_OTFE_CLI"
> > foreignTable="OTFE_CLIENTNEEDS" displayType="select">
> > <reference local="CLIENTNEEDS_CODE"
> > foreign="CLIENTNEEDS_CODE"/>
> > </foreign-key>
> >
> > </table>
> >
> >
> > <table name="OTFE_CLIENTNEEDS"
> > defaultVisibleFields="CLIENTNEEDS_CODE,CLIENTNEEDS_LABEL">
> > <field name="CLIENTNEEDS_CODE" fieldType="char" size="20" isKey="true"/>
> > <field name="CLIENTNEEDS_LABEL" fieldType="char" size="100"
> defaultValue=""
> > isKey="true"/>
> > <field name="CLIENTNEEDS_DESCRIPTION" fieldType="char" size="400"
> > defaultValue=""/>
> > <field name="CLIENTNEEDS_TRANSLATION" fieldType="char" size="1000"
> > defaultValue=""/>
> > <field name="CLIENTNEEDS_PICTURE_NAME" fieldType="diskblob"
> > directory="d:/temp/upload" encoding="true" size="50"/>
> >
> > </table>
> >
> >
> > it work fine, except that i have this Exception in my consol !
> >
> > [16/06/05 11:42:12:747 CEST] 3fd9863 SqlUtil E
> > org.dbforms.util.SqlUtil
> > TRAS0014I: L'exception suivante a été consignée : java.sql.SQLException:
> > ORA-00904: "CLIENTNEEDS_LABEL": invalid identifier
> >
> > at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:134)
> > at oracle.jdbc.ttc7.TTIoer.processError(TTIoer.java(Inlined Compiled
> Code))
> > at oracle.jdbc.ttc7.Oall7.receive(Oall7.java(Compiled Code))
> > at oracle.jdbc.ttc7.TTC7Protocol.doOall7(TTC7Protocol.java:1891)
> > at
> oracle.jdbc.ttc7.TTC7Protocol.parseExecuteDescribe(TTC7Protocol.java:830)
> > at
> >
> oracle.jdbc.driver.OracleStatement.doExecuteQuery(OracleStatement.java:2391)
> > at
> >
>
oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:2672)
> > at
> >
>
oracle.jdbc.driver.OraclePreparedStatement.executeUpdate(OraclePreparedStatement.java:589)
> > at
> >
>
oracle.jdbc.driver.OraclePreparedStatement.executeQuery(OraclePreparedStatement.java:527)
> > at
> >
>
com.ibm.ws.rsadapter.jdbc.WSJdbcPreparedStatement.executeQuery(WSJdbcPreparedStatement.java:426)
> > at org.dbforms.config.Table.getDoSelectResultSet(Table.java:403)
> > at org.dbforms.config.Table.doConstrainedSelect(Table.java:1681)
> > at org.dbforms.event.classic.GotoEvent.processEvent(GotoEvent.java:254)
> > at org.dbforms.taglib.DbFormTag.doStartTag(DbFormTag.java:1829)
> > at
> >
>
org.apache.jsp._OTFE_5F_PRODUCTSERVICES_5F_single._jspService(_OTFE_5F_PRODUCTSERVICES_5F_single.java:1065)
> > at
> >
> com.ibm.ws.webcontainer.jsp.runtime.HttpJspBase.service(HttpJspBase.java:89)
> > at javax.servlet.http.HttpServlet.service(HttpServlet.java:853)
> >
> >
> > it seems to look for CLIENTNEEDS_LABEL as key of the table CLIENTNEEDS , i
> > have
> > also tried to put CLIENTSNEEDS_LABEL whitout isKey="true", but same things
> >
> > Does someone have an idea ?
> >
> > Pascal
> >
> >
> >
> > Selon Henner Kollmann <[EMAIL PROTECTED]>:
> >
> > > That's a problem of your data. Searching is always case sensitive!
> > >
> > > Cheers
> > > Henner
> > >
> > > > -----Ursprüngliche Nachricht-----
> > > > Von: [EMAIL PROTECTED]
> > > > [mailto:[EMAIL PROTECTED] Im
> > > > Auftrag von [EMAIL PROTECTED]
> > > > Gesendet: Donnerstag, 16. Juni 2005 10:24
> > > > An: jdbforms-interest@lists.sourceforge.net
> > > > Betreff: [dbforms] case sensitive search
> > > >
> > > > Hi,
> > > >
> > > > I do some search in my list page.
> > > > i have implemented the search with the scripting vars
> > > >
> > > > but the search is case sensitive that i don't want.
> > > >
> > > > Does it exist any solution or config to tell to dbforms, to
> > > > do the search without case sensitive or it's a problem with
> > > > my Oracle Database.
> > > >
> > > > expl :
> > > > If i search <begin with "ADT"> i have results, if i search
> > > > <begin with "adt"> i have no result :-( but i would like have
> > > > the same results.
> > > >
> > > > Thanks,
> > > > Pascal
> > > >
> > > >
> > > > Selon Henner Kollmann <[EMAIL PROTECTED]>:
> > > >
> > > > > Seems that the diskblobs resultset is closed to early. Code in
> > > > > DataSourceJDBC.java looks quite different.
> > > > > Best would be to copy the code from DataSourceJDBC into the
> > > > > classic.Delete class.
> > > > > If you succeed, please send me the patch!
> > > > >
> > > > > Thanks
> > > > > Henner
> > > > >
> > > > > > -----Ursprüngliche Nachricht-----
> > > > > > Von: [EMAIL PROTECTED]
> > > > > > [mailto:[EMAIL PROTECTED] Im Auftrag
> > > > > > von [EMAIL PROTECTED]
> > > > > > Gesendet: Montag, 13. Juni 2005 16:06
> > > > > > An: jdbforms-interest@lists.sourceforge.net
> > > > > > Betreff: [dbforms] delete problem resultset
> > > > > >
> > > > > > Hi,
> > > > > >
> > > > > > I'm using Websphere(WSAD5.1.2) dbforms2.5, and i have a delete
> > > > > > button on a list page and on a single page.
> > > > > > When i want to delete a row of my table i got the exception below
> > > > > > (ResultSet is closed), but the row is well deleted !
> > > > > > i have the same JSP as followUp in my dbforms tag, and my
> > > > list page
> > > > > > in my
> > > > > >
> > > > > > Does anybody know why ?
> > > > > >
> > > > > > [13/06/05 15:14:49:031 CEST] 900bde6 Controller E
> > > > > > org.dbforms.servlets.Controller TRAS0014I: L'exception
> > > > suivante a
> > > > > > été consignée :
> > > > > > com.ibm.websphere.ce.cm.ObjectClosedException: DSRA9110E:
> > > > > > ResultSet est fermé.
> > > > > > at
> > > > > > com.ibm.ws.rsadapter.jdbc.WSJdbcResultSet.runtimeXIfNotClosed(
> > > > > > WSJdbcResultSet.java:2631)
> > > > > > at
> > > > > > com.ibm.ws.rsadapter.jdbc.WSJdbcResultSet.next(WSJdbcResultSet
> > > > > > .java:2418)
> > > > > > at
> > > > > > org.dbforms.event.classic.DeleteEvent.processEvent(DeleteEvent
> > > > > > .java:201)
> > > > > > at org.dbforms.servlets.Controller.process(Controller.java:309)
> > > > > > at org.dbforms.servlets.Controller.doPost(Controller.java:107)
> > > > > > at javax.servlet.http.HttpServlet.service(HttpServlet.java:760)
> > > > > > at javax.servlet.http.HttpServlet.service(HttpServlet.java:853)
> > > > > >
> > > > > >
> > > > > >
> > > > > > Thanks you,
> > > > > >
> > > > > > Pascal
> > > > > >
> > > > > >
> > > > > >
> > > > > > ----------------------------------------------------------------
> > > > > > This message was sent using IMP, the Internet Messaging Program.
> > > > > >
> > > > > >
> > > > > > -------------------------------------------------------
> > > > > > This SF.Net email is sponsored by: NEC IT Guy Games. How far can
> > > > > > you shotput a projector? How fast can you ride your desk
> > > > chair down
> > > > > > the office luge track?
> > > > > > If you want to score the big prize, get to know the little guy.
> > > > > > Play to win an NEC 61" plasma display:
> > > > > > http://www.necitguy.com/?r
> > > > > > _______________________________________________
> > > > > > DbForms Mailing List
> > > > > >
> > > > > > http://www.wap-force.net/dbforms
> > > > > >
> > > > >
> > > > >
> > > > >
> > > > > -------------------------------------------------------
> > > > > This SF.Net email is sponsored by: NEC IT Guy Games. How
> > > > far can you
> > > > > shotput a projector? How fast can you ride your desk chair down the
> > > > > office luge track?
> > > > > If you want to score the big prize, get to know the little guy.
> > > > > Play to win an NEC 61" plasma display: http://www.necitguy.com/?r
> > > > > _______________________________________________
> > > > > DbForms Mailing List
> > > > >
> > > > > http://www.wap-force.net/dbforms
> > > > >
> > > >
> > > >
> > > >
> > > >
> > > > ----------------------------------------------------------------
> > > > This message was sent using IMP, the Internet Messaging Program.
> > > >
> > > >
> > > > -------------------------------------------------------
> > > > SF.Net email is sponsored by: Discover Easy Linux Migration
> > > > Strategies from IBM. Find simple to follow Roadmaps,
> > > > straightforward articles, informative Webcasts and more! Get
> > > > everything you need to get up to speed, fast.
> > > > http://ads.osdn.com/?ad_idt77&alloc_id492&op=ick
> > > > _______________________________________________
> > > > DbForms Mailing List
> > > >
> > > > http://www.wap-force.net/dbforms
> > > >
> > >
> > >
> > >
> >
> >
> >
> >
> > ----------------------------------------------------------------
> > This message was sent using IMP, the Internet Messaging Program.
> >
> >
> > -------------------------------------------------------
> > SF.Net email is sponsored by: Discover Easy Linux Migration Strategies
> > from IBM. Find simple to follow Roadmaps, straightforward articles,
> > informative Webcasts and more! Get everything you need to get up to
> > speed, fast. http://ads.osdn.com/?ad_idt77&alloc_id492&op=cick
> > _______________________________________________
> > DbForms Mailing List
> >
> > http://www.wap-force.net/dbforms
> >
>
>
> ------------
> Ivan Codarin
> ============
>
> ----------------------------------------------------------------
> This message was sent using IMP, the Internet Messaging Program.
>
----------------------------------------------------------------
This message was sent using IMP, the Internet Messaging Program.
-------------------------------------------------------
SF.Net email is sponsored by: Discover Easy Linux Migration Strategies
from IBM. Find simple to follow Roadmaps, straightforward articles,
informative Webcasts and more! Get everything you need to get up to
speed, fast. http://ads.osdn.com/?ad_idt77&alloc_id492&op=click
_______________________________________________
DbForms Mailing List
http://www.wap-force.net/dbforms
