Re: Simple DISTINCT query

A-hah! - Original Message - From: "Gelhar, Wallace Joseph" <[EMAIL PROTECTED]> To: "OJB Users List" <[EMAIL PROTECTED]> Sent: Thursday, September 30, 2004 1:51 PM Subject: RE: Simple DISTINCT query getCollectionByQuery(q) is not the correct method call for a Report Query. Try broker.g

Re: Simple DISTINCT query

rce) > > at com.microsoft.jdbc.base.BaseResultSet.getDouble(Unknown Source) > > at > > org.apache.ojb.broker.util.JdbcTypesHelper$T_Float.readValueFromResultSet(Jd > > bcTypesHelper.java:773) > > at > > org.apache.ojb.broker.util.JdbcTypesHelper$BaseType.getOb

Re: Simple DISTINCT query

PROTECTED]> Sent: Thursday, September 30, 2004 12:33 PM Subject: Re: Simple DISTINCT query > Look at ReportQueries, they are part of the PersistenceBroker interface > and let you perform selects where the result is not a complete object. > > -Stijn > > Ian Hunter wrote: > >

Simple DISTINCT query

I've been pulling my ahir out trying to accomplish something simple. Say I have a table called FOO, with fields FOOID (int), FOODATE (datetime), and FOOAMOUNT (double). Some process writes data to this table, where FOOID is a autoincrement field, FOODATE is a datestamp, for which there can be dup

Where can I see the generated SQL query?

I'm attached to a database I don't have rights to profile -- how can I see the SQL query that gets called when I execute a search? I'm using the PB API getCollectionByQuery call. --- Aoccdrnig to a rscheearch at Cmabrigde Uinervtisy, it deosn't mttaer in waht oredr the ltteers in a wrod are, the

Object with links to objects from a different database

I have a system that uses one database for storing 95% of it's data, but 5% of it lives in a separate ERP that I'm linking to. OJB is talking to both databases just fine, but when I try to load an object that has auto-retrieve turned on that also happens to reference an object in a different datab

auto-retrieve across jdbc-connections

I'm using the PB API, and I have data in two separate databases (on two separate machines). I have an object class in one database that contains another object class from another database. The problem comes when I set auto-retrieve on for the containing class -- OJB doesn't seem to realize that t

Can't unsubscribe

I hate to spam the list with this, but someone please help, I can't unsubscribe. I've sent many messages to [EMAIL PROTECTED], and tried through the website, to no avail. Ian Hunter, Staff Consultant [EMAIL PROTECTED] Inovis USA, Inc. 11720 Amberpark Drive Parkway 400,

RE: Question about OJB references and manually setting foreign keys (Struts app)

Thanks! -Original Message- From: Armin Waibel [mailto:[EMAIL PROTECTED] Sent: Thursday, June 10, 2004 2:10 PM To: OJB Users List Subject: Re: Question about OJB references and manually setting foreign keys (Struts app) Ian Hunter wrote: > So in short, only when calling store() on

RE: Question about OJB references and manually setting foreign keys (Struts app)

subsequently use a > validationQuery for the next n number of calls, and then ditch the > validationQuery again for speed. That worked out great. I'm interested in your solution. In OJB 1.1 we will introduce a pluggable ValidationStrategy interface which will allows the user to impl

Question about OJB references and manually setting foreign keys (Struts app)

I'm pretty new to OJB, so be gentle. I'm working on a Struts app, using the PB API, and I have a "Customer" object with an "Account Manager" reference to a "User" object. For instance, something like: public Class User { public int getId(); public String getName(); } Public Cla

DB Connections reset

a validationQuery to the connection pool (I guess, haven't tried it yet) after a failure, and wrap the calls to the PB API with a counter that would clear the validationQuery after xxx number of successful accesses. Food for thought... Ian Hunter, Staff Consultant [EMAIL PROTECTED