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=click
_______________________________________________
DbForms Mailing List
http://www.wap-force.net/dbforms
