RE: generating sql for internal tables and schema

> After few days I managed to generate repository and torque schema with > XDoclet module and now I stucked trying to generate SQL for internal > tables and my model tables. > I use following target from my build file: > > > antfile="build-torque.xml" >

Dynamic statement, urgent

Hello, OJB uses prepared statements to run select statements. Is there a way to convince OJB to use dynamic statements instead? We are about to refactor a running system and want to use OJB instead of coded sql-statements. The problem is, that a prepared statement (=static statement) seems to limi

RE: PersistenceBroker Store not working

I am no expert, but I will try to help (use my advice at your own risk!) assumptions: payment contains ref to Account insert account insert payment assumes Account row exists in DB by the time the payment gets inserted. is that true? (I guess, if you didn't get

PersistenceBroker Store not working

Please excuse my ignorance (newbie) but I have a class Payment with a field "fromAccountId" which is a foreign key to an Account Class. Therefore I have a and which retrieves relevant information from the Account table for each Payment. However I have not been

Re: one last JOIN question

I didn't go to sql, that was just the representation of the sql that OJB now generates. SchoolCriteria sCriteria = new SchoolCriteria(); CollegeCriteria cCriteria = new CollegeCriteria(); cCriteria.addTypeOfInstEqualTo( "2" ); ReportQueryByCriteria subQuery = QueryFactory.newReportQuery( College.c

Re: one last JOIN question

hi charles, does this mean that you write the sql manually. one important point about o/r-mappers is, that you should have a clean object model before thinking of sql. i know that sometimes one knows the sql but not how to express it in pb-api or the like ;) jakob Charles N. Harvey III wrote: Ja

Re: one last JOIN question

Jakob, Thanks so much for all of your pointers. I finally decided to just use report queries. So far its just as fast and much much less hassle. SELECT * FROM SCHOOL AS sch INNER JOIN PROFILE AS pro WHERE sch.college_id IN (SELECT college_id FROM COLLEGE WHERE type = '1') Made life much easier.

Re: one last JOIN question

hi charles, Charles N. Harvey III wrote: Ok. Great suggestion. And I tried out the query and it works great. Here's the lousy part, there isn't just one COLLEGE table. There are 20. COLLEGE_ADMISSIONS, COLLEGE_FRESHMEN, COLLEGE_REQUIREMENTS So I don't think I can make SCHOOL.college_id a FK

Recursion Exception

Hi, I am trying to establish a recursive relationship for Employee-Manager. I am using the following OJBSchema Enclosed is the exception. I'd really appreciate any help/pointers.. thx, Sukesh java.lang.StackOverflowError [java

OJBDoclet plugin and fileset excludes

In a same project I have classes whitch must go in projectA-schema.xml and other in a projectB-schema.xml because I need to generate 2 differents sql with torque to generate the databases. I try to include / exclude some classes when i call the torqueschema task. I try with :

RE: Outer join in Report Query

Hello, Do all the tables have to share a common primary key? If so, my problem is not solved by this (see below in my first post). Could I solve it with a custom rowreader? Perhaps that would be ineffective. Arnar > -Original Message- > From: Jakob Braeuchi [mailto:[EMAIL PROTECTED] >

RE: generating sql for internal tables and schema

Thanks, it helped with the error message but the only thing I get are empty sqldb.map and empty report :( Bartosz > -Original Message- > From: [EMAIL PROTECTED] > [mailto:[EMAIL PROTECTED] > Sent: Monday, May 17, 2004 3:04 PM > To: OJB Users List > Subject: RE: generating sql for inter

Re: one last JOIN question

Ok. Great suggestion. And I tried out the query and it works great. Here's the lousy part, there isn't just one COLLEGE table. There are 20. COLLEGE_ADMISSIONS, COLLEGE_FRESHMEN, COLLEGE_REQUIREMENTS So I don't think I can make SCHOOL.college_id a FK to any of the COLLEGE.college_id's. I h

RE: generating sql for internal tables and schema

I have an error like this when I use the torque maven plugin. The reason of my error was that I didn't set the properties : torque.database = mysql Torque need the db kind the generate sql from the schema. Nicolas, "Bartosz Jankiewicz" <[EMAIL PROTECTED]> 17/05/2004 15:53 Veuillez répondre

generating sql for internal tables and schema

Hello, After few days I managed to generate repository and torque schema with XDoclet module and now I stucked trying to generate SQL for internal tables and my model tables. I use following target from my build file:

Re: SequenceManagerNativeImpl Problems

On Mon, 17 May 2004, Martin I. Levi wrote: > Hi Tom, > > I am working with rc5, could you please tell me what this "little issue" > is about? See this thread: http://nagoya.apache.org/eyebrowse/[EMAIL PROTECTED]&by=thread&from=684334 Tom --

SequenceManagerNativeImpl Problems

Hi Tom, I am working with rc5, could you please tell me what this "little issue" is about? Greets, Martin Ivan Levi Universistat Politecnica de Catalunya Centre Tecnologic de Transferencia de Calor On Thu, 2004-05-13 at 18:49, Thomas Dudziak wrote: > On Thu, 13 May 2004, Fred McCann wrote: >

Re: org.apache.ojb.broker.util.BrokerHelper javadoc?

Martin I. Levi wrote: Hi, Where can I find documentation about this class? doh! Only if you generate the whole javadoc using 'ant javadoc'. I will fix this and include this class in api-doc too. Thanks for the hint! regards, Armin Greets, Martin Ivan Levi Universistat Politecnica de Catalunya Cen

Re: Child Table insert at same time as Parent and Auto generated PK

Hi Martin, Martin I. Levi wrote: Oops! I already found where the auto-xxx settings should be placed, sorry! Anyway I still think you should put all these auto-xxx information together. The auto-xxx settings differ in each type of relation (1:1, 1:n, m:n) and belongs only to the associated relation

org.apache.ojb.broker.util.BrokerHelper javadoc?

Hi, Where can I find documentation about this class? Greets, Martin Ivan Levi Universistat Politecnica de Catalunya Centre Tecnologic de Transferencia de Calor - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional c

Re: Problems with Link references

Hi Martin, Martin I. Levi wrote: Hi, When I try to compile a code line similar to this one (importing org.apache.ojb.broker.util.BrokerHelper): broker.serviceBrokerHelper().link(an_object,"an_attrib_name",false); The compiler says that this method does not exist, I checked the file /src/org/apach

Problems with Link references

Hi, When I try to compile a code line similar to this one (importing org.apache.ojb.broker.util.BrokerHelper): broker.serviceBrokerHelper().link(an_object,"an_attrib_name",false); The compiler says that this method does not exist, I checked the file /src/org/apache/ojb/broker/util/BrokerHelper.

RE: problem with xdoclet generating torque schema

> -Original Message- > From: Thomas Dudziak [mailto:[EMAIL PROTECTED] > Sent: Monday, May 17, 2004 10:13 AM > To: OJB Users List > Subject: Re: problem with xdoclet generating torque schema > > > On Mon, 17 May 2004, Bartosz Jankiewicz wrote: > > > Hello, > > > > I've searched archiv

Re: Sequencers in clustered environment

Hi, Armin I restore the isolation level on the close() method, by asking if a private variable is informed and setting the isolation level to this variable (I always save the previous isolation level if I change it anywhere). From: Armin Waibel <[EMAIL PROTECTED]> Reply-To: "OJB Users List" <[E

RE: problem with xdoclet generating torque schema

> -Original Message- > From: Thomas Dudziak [mailto:[EMAIL PROTECTED] > Sent: Monday, May 17, 2004 10:13 AM > To: OJB Users List > Subject: Re: problem with xdoclet generating torque schema > > > On Mon, 17 May 2004, Bartosz Jankiewicz wrote: > > > Hello, > > > > I've searched archiv

Re: problem with xdoclet generating torque schema

On Mon, 17 May 2004, Bartosz Jankiewicz wrote: > Hello, > > I've searched archives of the group and didn't find any sollution to my > problem. > > I coppied necessary files after XDoclet module documentation, XDoclet > module generates repository_user.xml but throws exceptions when > generating

Re: Child Table insert at same time as Parent and Auto generated PK

Oops! I already found where the auto-xxx settings should be placed, sorry! Anyway I still think you should put all these auto-xxx information together. Greets, Martin Ivan Levi Universistat Politecnica de Catalunya Centre Tecnologic de Transferencia de Calor On Sat, 2004-05-08 at 03:13, Armin

Re: Child Table insert at same time as Parent and Auto generated PK

Hi As a hint to improve documentation: When reading the 1:1 auto-xxx settings (http://db.apache.org/ojb/tutorial3.html) i found that there's no place explaining where exactly in the repository_user.xml these settings should be specified (I suppose this place is the reference descriptor, am i righ

problem with xdoclet generating torque schema

Hello, I've searched archives of the group and didn't find any sollution to my problem. I coppied necessary files after XDoclet module documentation, XDoclet module generates repository_user.xml but throws exceptions when generating torque schema (project_schema.xml). Some parts of stack trace: