RE: [Re-post] PB query question

2003-08-20 Thread oliver . matz
Hello, > -Original Message- > From: Phil Warrick [mailto:[EMAIL PROTECTED] > Here is my model: > > [A] <1--n> [B] <1--n> [C] <1--1> [D] > | | > C1 C2 > > I want to query for A objects using a C1 timestamp field as > criteria (C1 > is a s

Re: OJB Console

2003-08-20 Thread Alexander Prozor
actually , your server http://www.scrashmeow.org/ojb/index.do is always down :( - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]

AW: OJB / MS SQL Server

2003-08-20 Thread Axel Hohaus
Have a look at http://jtds.sourceforge.net Axel > -Ursprüngliche Nachricht- > Von: Bonnie MacKellar [mailto:[EMAIL PROTECTED] > Gesendet: Mittwoch, 20. August 2003 22:18 > An: 'LAURENT Stephane '; 'OJB Users List ' > Betreff: RE: OJB / MS SQL Server > > > We're using MSQQLServer wit

Re: Problem inserting object when using SequenceManagerNativeImpl

2003-08-20 Thread Michael Becke
Hi Armin, Thank you for your response. I am definitely setting the PK value. Perhaps something is setting it to null inside the store? I do not have access to the code right now, but will step through in a debugger tomorrow. Any other thoughts as to the cause? Thanks, Mike On Wednesda

OJB Console

2003-08-20 Thread Alexander Bibighaus
I have been working on a SourceForge project that provides a web interface to OJB. I would like to announce it to this board simply to inform you of its availability. You can read more about it and download the application and full source code here: http://ojbc.sourceforge.net/ You can demo the a

Re: diferences between tutorial4 and code

2003-08-20 Thread Antonio Gallardo
Hi: Please comments. :) Antonio Gallardo Antonio Gallardo dijo: > Hi: > > I am seeing the tutorial4 and there I saw diference between > http://db.apache.org/ojb/tutorial4.html and the code at > src/jdori/org/apache/ojb/tutorial5. > > If we see close at the web page there is at "Updating Objects"

Re: Problem inserting object when using SequenceManagerNativeImpl

2003-08-20 Thread Armin Waibel
Hi Michael, > - Inserting an object that does not have an autoincrement field hmm, changes were made to SequenceManagerNativeImpl last 10 days, but no changes in detecting autoincrement fields. Each pk field must be set before storing or need an autoincrement attribute (set 'true') in field-desc

Re: diferences between tutorial4 and code

2003-08-20 Thread Armin Waibel
Hi Antonio, thanks for this hint - put it on my todo list. regards, Armin - Original Message - From: "Antonio Gallardo" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Tuesday, August 19, 2003 10:42 AM Subject: diferences between tutorial4 and code > Hi: > > I am seeing the tutorial4

Sub query

2003-08-20 Thread Dougall Squair
Hi, Is it possible to have a sub-querey within OJB that referers to its enclosing query? - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]

Re: creating DB from an XSD or XML

2003-08-20 Thread Clay Mitchell
Question - what's the actual difference in Torque and OJB? Both seem to have persistence, Object -> DB mapping, caching... what am I missing? -CLay Charles Anthony wrote: Hi, An XSDSchema is already in XML. Torque allows you to define an database schema in XML; OJB uses Torque to generate it's

Re: repost: subqueries

2003-08-20 Thread Jakob Braeuchi
hi oliver please see my post in dev-list '[vote] reference to a parent attribute in subquery' this allows you to reference attributes of the enclosing query. please be aware that this is a _temporary_ solution, the prefix may change ! jakob [EMAIL PROTECTED] wrote: Hello, on 04.08. I have as

RE: Dynamic Proxy: exception handling

2003-08-20 Thread Tal Yalon
Correction: the new catch clause should be in the outer try/catch clause (or else the outer catch will catch the inner throw ...) -Original Message- From: Tal Yalon [mailto:[EMAIL PROTECTED] Sent: Wednesday, August 20, 2003 6:55 PM To: OJB User List (E-mail) Subject: Dynamic Proxy: except

Re: orderby attribute ignored in collection-descriptor

2003-08-20 Thread Jakob Braeuchi
hi jürgen, this works for me: results in the following sql: SELECT A0.idPerson,A0.saldo,A0.nummer,A0.id FROM tabKonto A0 WHERE A0.idPerson = '2' ORDER BY 2 ordered by the second column (saldo). the problem in your case is the abstract superclass ! ojb executes a selec

RE: OJB / MS SQL Server

2003-08-20 Thread Bonnie MacKellar
We're using MSQQLServer with the JSQLConnect driver without any major problems. But that is not a free driver... Bonnie MacKellar -Original Message- From: LAURENT Stephane To: OJB Users List Sent: 8/20/03 10:18 AM Subject: OJB / MS SQL Server Hi, is anybody working with SQL Server 7 ? c

Re: Editing multiple objects. Can it be done?

2003-08-20 Thread Philippe Hacquin
Hi, I am relatively fresh using OJB and the ODMG API, and I am not sure to understand your problem, but as far as I have understood it: - you may not have more than one transaction active per thread (well, one Transaction object bound to one thread) - every object modified within a thread, start

RE: creating DB from an XSD or XML

2003-08-20 Thread Rostislav Georgiev
Hi, there There no such tool, I thing. :)) I create a simple parcer, which parce my xsd-es and generate ojb classes with xdoclet tags added.It's useful in my current project( I run Ant script, and ... :)) ). But I think the use of XSLT i much more flexible, if have some specific mapping you must

Re: Question re prefetched relationsbips

2003-08-20 Thread Jakob Braeuchi
hi john, could you please send it to me as well ? jakob John M wrote: I submitted a patch earlier that allows a different method of prefetching related objects and does indeed allow prefetching for more than one level deep. All data is returned in one query by joining tables and getting all

[Re-post] PB query question

2003-08-20 Thread Phil Warrick
Hi again, I posted this a few weeks ago, perhaps when the best person to answer wasn't around (Jakob?). Your suggestions would be welcome. Here is my model: [A] <1--n> [B] <1--n> [C] <1--1> [D] | | C1 C2 I want to query for A objects using a C1 time

Problem inserting object when using SequenceManagerNativeImpl

2003-08-20 Thread Michael Becke
I just updated to the latest code from CVS and have come across a new issue. Here's the scenario: - Websphere 4.0 and DB2 - Using SequenceManagerNativeImpl - Inserting an object that does not have an autoincrement field All seems to work with Objects that have an autoincrement field. Also,

Dynamic Proxy: exception handling

2003-08-20 Thread Tal Yalon
Hi, IndirectionHandler invokes the target method (after materializing). However, if the target method throws an exception it is wrapped by PersistenceBrokerException no matter what (not just for materialization issues)! The code looks like: Method m = subject.getClass().getMethod(method.getName(

RE: Editing multiple objects. Can it be done?

2003-08-20 Thread Adam Griffiths
Hi again, I have an idea to solve my problem bellow and would very grateful for any suggestions or comments. It seems that odmg / jdo don't have great provisions for locking and multiple transactions so here is my work around: I believe that it's not possible to have multiple transactions open at

Primary keys and custom conversions

2003-08-20 Thread Lance Eason
Using 1.0 rc2. Is there a known issue with using custom conversions for primary keys and is it resolved in a later version? I've got a table Workspace: workspace_idint, <- primary key base_workspace_id int<- recursive foreign key back to the workspace table with an OJB ma

reverse-db status

2003-08-20 Thread Brian McCallister
What is the status of reverse-db? I seem to be unable to make it work with PostgreSQL still =/ -Brian - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]

RE: creating DB from an XSD or XML

2003-08-20 Thread Charles Anthony
>as I understand, please correct me, the XSLT transformation is for >converting my non-database aware XML schema in an database aware schema >(Torque-schema.xml). So all the works lies on writting the >right XSL. The >rest is "mechanical work". Correct. [..] > >Is not there any way *automathical

OJB / MS SQL Server

2003-08-20 Thread LAURENT Stephane
Hi, is anybody working with SQL Server 7 ? can't find free JDBC driver working fine ... can you send me your repository_database and where to find good driver ? Microsoft's driver work only with SQL Server2000, where can I find V7 compatible version ? actualy use com.jnetdirect.jsql.JSQLDriver, b

RE: creating DB from an XSD or XML

2003-08-20 Thread "Rodríguez Miguélez, Adolfo"
Thanks Jose, as far as I know Jakarta`s digester, which packs with Struts distribution, allows to fill Java Objects from an XML source. Howevere I found the syntax quite cumbersome. For this task I find easier to use JAXB from Sun or Castor, even Quick. My focus would be to save the time working

Re: Configure OJB in WAS Testenvironment

2003-08-20 Thread Michael Becke
Oliver, The WebSphereTransactionManagerFactory included in RC4 does not work in WAS 4. This has been fixed in the latest version in CVS. Mike On Wednesday, August 20, 2003, at 05:24 AM, [EMAIL PROTECTED] wrote: Hi to all, can anybody please tell me how OJB has to be configured to use the

RE: Editing multiple objects. Can it be done?

2003-08-20 Thread Adam Griffiths
Hi again, I have an idea to solve my problem bellow and would very grateful for any suggestions or comments. It seems that odmg / jdo don't have great provisions for locking and multiple transactions so here is my work around: I believe that it's not possible to have multiple transactions open at

RE: creating DB from an XSD or XML

2003-08-20 Thread "Rodríguez Miguélez, Adolfo"
Thanks Charles for your response, as I understand, please correct me, the XSLT transformation is for converting my non-database aware XML schema in an database aware schema (Torque-schema.xml). So all the works lies on writting the right XSL. The rest is "mechanical work". I wonder if, probably u

Re: creating DB from an XSD or XML

2003-08-20 Thread jgaliana
Hi, Adolfo I´dont know any tool to make a DDL from a DTD. I´ve do itby hand. Usuarlly, a dtd maps against a unique table and it doesn´t so difficult. For extract xml we use digister (jakarta.apache.org/commons). It has a good works to map xml/object. My database has a table with the data, I use

RE: creating DB from an XSD or XML

2003-08-20 Thread Charles Anthony
Hi, An XSDSchema is already in XML. Torque allows you to define an database schema in XML; OJB uses Torque to generate it's database tables. So, it follows that (Depending upon then complexity of the XSD schema) you should be able to write a XSLT transformation to create the Torque schema. It wo

Re: Error in ojb when handling through a eclipse plugin

2003-08-20 Thread Andrew McCall
HI, I had the same problem when the OJB.properties file was not on my classpath. It took some searching in the source but eventually realized that the ExceptionInInitializerError I was getting was because the OJB.properties file was not on my class path. I added it and everything worke

creating DB from an XSD or XML

2003-08-20 Thread "Rodríguez Miguélez, Adolfo"
>From time ago I am loooking fo a way to do the following. Assuming that I have some kind of DTD or XSD for XMLs. I would like to create, a database, or DDL, to reproduce the DTD or XSD estructure in my database schema. Could be this done with an automathic procedure. In other words, is currently

Re: Antwort: How to create a LIKE Statement???

2003-08-20 Thread LAURENT Stephane
With MS SQL Server the like clause work fine on numeric field (field like '%1%') So, I can also set values using quotes. In this case, Field can be declared as Varchar on repository, it should work (I don't know if OJB ask database for table's definition or not, like I think) and you can add y

Configure OJB in WAS Testenvironment

2003-08-20 Thread oliver . urbitsch
Hi to all, can anybody please tell me how OJB has to be configured to use the Webshere Application Server connection pooling? We are using the WAS 4.03 Testenvironment and OJB RC4. The following configuration is used: - OJB-properties: ...

Antwort: How to create a LIKE Statement???

2003-08-20 Thread Carsten Spräner_Ext
Heah? i thing the problem is in front of the computer :-) try a select * from CUVZ where CUVZ_CDNR like '%1%' CUVZ_CDNR is a DECIMAL-Field. That would result in a Databaseerror (here db2): SQL0440N Im Funktionspfad wurde keine Funktion mit Namen "LIKE" und kompatiblen Argumenten gefunden. SQ

Re: How to create a LIKE Statement???

2003-08-20 Thread LAURENT Stephane
Hi, I'm not sure you can have a "like" clause on numeric field in sql queries or you are using database specific function. When your (database) field is numeric, the generated query don't have quotes (like myField=3) so in your case, you try to generate a clause like this : myField=3% ... if you ca

Re: How to create a LIKE Statement???

2003-08-20 Thread Alexander Prozor
It works well with non number fields. I think that you have to look at generated SQL and trying to build right criteria. (you can see all generated SQL queries by setting driver="com.p6spy.engine.spy.P6SpyDriver" in datavase_repository.xml file) sorry, if it will not help you, but I've never used

How to create a LIKE Statement???

2003-08-20 Thread RBaron-Riege
Hi, I´m trying to make a SELECT * FROM Table WHERE Field LIKE 'XY%' I thought a Criteria theCriteria = new Criteria(); theCriteria.addLike("myAttributeName", anAttributeValue); // where the Attribute Type is BigDecimal should do the Job. But I´m getting a ClassCastException (I think becaus