MULTIPLE TABLES - DATA retrieval

2004-09-09 Thread kishore talagadadeevi
I really appreciate if someone could suggest me on the following .. I have three independent tables . All three tables have part_num and part_serial as part of composite primary key in addition to other columns. Question: How do I retrieve qty,cost and size by joining all three tables on part_

Re: maven+ojb

2004-09-09 Thread Pedro Salgado
Thank you! :) That sure was quick!! On 10/9/04 12:44 am, "Brian McCallister" <[EMAIL PROTECTED]> wrote: > http://www.ibiblio.org/maven/ojb/jars/ > > Includes the 1.0.1 I pushed last night. > > -Brian > > On Sep 9, 2004, at 7:38 PM, Pedro Salgado wrote: > >> >> I am searching the ibiblio

Re: maven+ojb

2004-09-09 Thread Brian McCallister
http://www.ibiblio.org/maven/ojb/jars/ Includes the 1.0.1 I pushed last night. -Brian On Sep 9, 2004, at 7:38 PM, Pedro Salgado wrote: I am searching the ibiblio repository and I cant find ojb 1.0rc7 anywhere (just db-ojb-1.0.rc6.jar - 7 Apr 2004)... isnt it supposed to be on ojb/jars? I do s

maven+ojb

2004-09-09 Thread Pedro Salgado
I am searching the ibiblio repository and I cant find ojb 1.0rc7 anywhere (just db-ojb-1.0.rc6.jar - 7 Apr 2004)... isnt it supposed to be on ojb/jars? I do see the ojb-xdoclet-module (16 Aug 2004)... Thank you, Pedro Salgado -

OJB under Oracle 10g ?

2004-09-09 Thread Andy Malakov
Hello All, Has anybody tried to use OJB with Oracle 10g? More specifically with OC4J application server? The reason I am asking is that I am getting some exceptions and after I patch some of them, I am getting more of a different kind :-) Thus, I wonder has anybody actually used OJB with Oracl

Hsqldb validation query

2004-09-09 Thread David Durham
What's a good Hsql validation query? - Dave - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]

Re: When Should we use m_parentStatement in SqlQueryStatement?

2004-09-09 Thread Jakob Braeuchi
hi gene, this instvar is not null if the statement is a subquery (see getSubQuerySQL() ). hth jakob Gene schrieb: Anyone can tell me in which circumstance will m_parentStatement(which is also a instance of SqlQueryStatement) NOT be null? Please give me a example. Thanks in advance. Gene -

RE: JBoss have to close connection in managed environment and nes ted EJB calls

2004-09-09 Thread Clute, Andrew
I don't know if this was every acknowledged on the list, my Jboss recognizes that they do it this way, and it is how they want to do it. You can turn off the Connection checking. http://www.jboss.org/wiki/Wiki.jsp?page=WhatDoesTheMessageDoYourOwnHousekeepingMean See "Thread Local Pattern" -And

RE: JDO Enhancing error

2004-09-09 Thread GuptaTTG
I got it worked, the issue was that I was ignoring the fact that the attribute names are case sensitive Could anybody tell if OJB supports the functionality of specifying "Fetch groups" in the queries like in case of Kodo (Which I know that its not a JDO standard) If not then How can I achieve t

JDO Enhancing error

2004-09-09 Thread GuptaTTG
Hi   I am getting following error while running the Enhancer   com.sun.jdori.enhancer.util.InternalError: assertion failed: JDO metadata: managed fields exceed annotated fields.    at com.sun.jdori.enhancer.util.Assertion.affirm(Unknown Source)    at com.sun.jdori.enhancer.core.Analyzer.s

Re: MSSQL And OJB/Torque issue with image datatype..Will Velocity solve my problem?

2004-09-09 Thread Brian McCallister
This is a limitation of (MS) SQL: [org.apache.ojb.broker.accesslayer.JdbcAccessImpl] ERROR: SQLException during the execution of the query (for a com.xxx.Property): The text, ntext, and image data types cannot be compared or sorted, except when using IS NULL or LIKE operator. What does the actual S