Re: [OJB-ODMG] foreign key constraint

2005-04-11 Thread Armin Waibel
Hi Jean-Yves, I always have a violation of foreign key constraint, because OJB seem's to try to persists instance of this class before the instance of Location linked with it. Is that normal ? Do I have to persists the Location object first, or is OJB supposed to be able to deal with that ?

Re: Used ConnectionManager instance could not obtain a connection, retrying...

2005-04-11 Thread Martin Kalén
Hari Om wrote: hello I am using JDK1.4, OJB, and Oracle 9.2.0.2 on SuSE Linux 9.0 We ha dthis Web Application Running for few months... and there was NO ACTIVITY on this web site in past 4-6 weeks... and now when I log on to that I get following ERRORS...wonder why... Oracle RDBMS will

Re: mapping one object in different RDBMS - source

2005-04-11 Thread Armin Waibel
Hi, Stas Ostapenko wrote: I have a problem with inserting all table data of one table to another table in other RDBMS. Following code works, but it stores not all the data, but only first object. Where I`m wrong ? First you have to take care that metadata changes are global operations, all

Help Getting Started

2005-04-11 Thread Scott Purcell
Hello, I would like to try and get started using the OJB product. I am on the website, but do not see where to begin. So I downloaded this: db-ojb-1.0.3-bin.zip and extracted it, hoping for some simple webapp example. Back at the website I tried following the ODGM Tutorial. But it goes

Re: Help Getting Started

2005-04-11 Thread Thomas Dudziak
Try the ojb-blank.jar from the same source, it is a blanco preconfigured project where you only have to add your classes (that is, for simple projects) Also related is the Getting starting section of the doc: http://db.apache.org/ojb/docu/getting-started.html Tom

Re: Help Getting Started

2005-04-11 Thread Brian McCallister
The getting started page is probably the most useful. http://db.apache.org/ojb/docu/getting-started.html -Brian On Apr 11, 2005, at 9:55 AM, Scott Purcell wrote: Hello, I would like to try and get started using the OJB product. I am on the website, but do not see where to begin. So I downloaded

RE: Help Getting Started

2005-04-11 Thread Scott Purcell
Thanks Thomas, Do I rename this .jar to a .war and deploy it? Or extract it and check the docs? Thanks, Scott -Original Message- From: Thomas Dudziak [mailto:[EMAIL PROTECTED] Sent: Monday, April 11, 2005 9:00 AM To: OJB Users List Subject: Re: Help Getting Started Try the

Need Assistance Getting Started, have baseline.

2005-04-11 Thread Scott Purcell
Ok, I am finally rolling ... a little bit. I have the ojb-blank.jar and put it into a folder on my drive C:/OBJ_PLay. Then according to the directions, I extracted it, and renamed it to projectmanager: eg: C:/OJB_PLay/projectmanager Dir -build Dir -lib DIR -src .classpath

Re: Need Assistance Getting Started, have baseline.

2005-04-11 Thread Thomas Dudziak
Please try the normal tutorial 1 (tutorial1-src.jar) first, not the struts one. The latter builds upon the first which is a basic console application and primarily intended to show the basics of OJB and of the ojb-blank Tom - To

Re: Runtime Connection (PROGRESING BUT... )

2005-04-11 Thread Mauricio Montblanch
Hi, I Keep Having problems before the conection MetadataManager metadataManager = MetadataManager.getInstance(); ConnectionRepository repository = metadataManager.readConnectionRepository(getXmlconection(servidor));

generator, create-db on Oracle

2005-04-11 Thread Laran Evans
So is there some trick to running the create-db task in the generator to create a database in Oracle? When I run the task I get a The Network Adapter could not establish the connection. However I know the host name is correct (I'm echoing it out in the ant target.). I can ping that host. And I

Re: generator, create-db on Oracle

2005-04-11 Thread Thomas Dudziak
You could try to do a simple select or the like via Ant's SQL task (http://ant.apache.org/manual/CoreTasks/sql.html) to see whether the jdbc connection works. Tom - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional

Re: Runtime Connection (PROGRESING BUT... )

2005-04-11 Thread Armin Waibel
Hi, in current OJB version it's not possible to reset the default connection setting (to avoid side-effects). If try to set the default PBKey more than one, you will get an exception. In the OJB_1_0_RELEASE branch I changed this behavior (MetadataManager + ConnectionRepository). You can patch

Feature request - or maybe something similar exists and I don't k now it

2005-04-11 Thread Charles Anthony
Hi, I'm trying to help one of my developers with a query - and I have to say, I don't OJB can cope with it at the moment. Essentially, we want OJB to generate some SQL to do some arithmetic in the where clause - e.g. SELECT FROM ... WHERE (COLUMNA + COLUMNB - COLUMNC) = 0 I'd like a

Re: mapping one object in different RDBMS - source

2005-04-11 Thread Stas Ostapenko
Armin, thanks for your reply. But one more thing. I use table with something like 100 000 records. Using of PB.getCollectionByQuery may couse problems with memory. Out Of Memory Exception for example. This is not a problem - I can increase heap size for JVM, etc.In this case using

RE: Used ConnectionManager instance could not obtain a connection, retrying...

2005-04-11 Thread Hari Om
Thanks Martin...any other input on this? THANKs! --- Martin Kalén Mon, 11 Apr 2005 02:27:25 -0700 Oracle RDBMS will disconnect any inactive clients after a certain (server-side configurable) amount of time. See

Re: Used ConnectionManager instance could not obtain a connection, retrying...

2005-04-11 Thread Martin Kalén
Hari Om wrote: Thanks Martin...any other input on this? You're most welcome. Not sure what you mean with other input... Just click the link below and read my previous reply in the mail archive, for more detailed info on how to enable a validation query for OJB pooled connections: See

NewBie: How to specify sql table creation order

2005-04-11 Thread Z N
Hi, I am a newbie to OJB. I am going thru the documentation and trying to create a couple of simple entities/relations. I am facing a problem : The sql that gets generated uses the wrong table creation first, my primary entities are created last and the dependent table sql gets generated

Re: generator, create-db on Oracle

2005-04-11 Thread Martin Kalén
Laran Evans wrote: So is there some trick to running the create-db task in the generator to create a database in Oracle? Just make sure that database hostname, port number and Oracle SID are all set in the oracle or oracle9i profile you are using in OJB. When I run the task I get a The Network

Re: NewBie: How to specify sql table creation order

2005-04-11 Thread Thomas Dudziak
This sounds more like a problem with Torque which is per default used to generate the tables in the database. You can try to use commons-sql instead (http://jakarta.apache.org/commons/sandbox/sql/), it groks the same table schema but it splits the table generation and the creation of foreignkeys

Re: generator, create-db on Oracle

2005-04-11 Thread Martin Kalén
Martin Kalén wrote: So is there some trick to running the create-db task in the generator to create a database in Oracle? Just make sure that database hostname, port number and Oracle SID are all set in the oracle or oracle9i profile you are using in OJB. P.S. I assume you performed check 1A,

Re: generator, create-db on Oracle

2005-04-11 Thread Laran Evans
Yes. I had been connecting to mysql previously. So my url was in the format jdbc:mysql://host:port/dbname. I was trying to connect with a similar string of the format jdbc:oracle://host:port/schema. This clearly didn't work. I changed the url format to jdbc:oracle:thin:@host:port:SID and it

Re: NewBie: How to specify sql table creation order

2005-04-11 Thread Z N
Hi Tom, Thanks a lot for responding. I'm grappling with the basic concepts. I see, so instead of specifying an entity creation order, we'd rather let another tool (commons-sql) that can decipher primary and dependent entities, split them up, and order them by this distinction, and let it

Re: NewBie: How to specify sql table creation order

2005-04-11 Thread Thomas Dudziak
I'm grappling with the basic concepts. I see, so instead of specifying an entity creation order, we'd rather let another tool (commons-sql) that can decipher primary and dependent entities, split them up, and order them by this distinction, and let it resolve the dependencies. Is my

Re: NewBie: How to specify sql table creation order

2005-04-11 Thread Z N
Hi Tom, Awesome. That was very insightful. I'll try it out now that I think I understand it much better. Thanks again. ZN --- Thomas Dudziak [EMAIL PROTECTED] wrote: I'm grappling with the basic concepts. I see, so instead of specifying an entity creation order, we'd rather

NewBie: How to specify sql table creation order

2005-04-11 Thread Z N
Hi, I am a newbie to OJB. I am going thru the documentation and trying to create a couple of simple entities/relations. I am facing a problem. I guess that option must be provided, but I am just not finding how to do it : The sql that gets generated uses the wrong table creation first, my

Re: [OJB-ODMG] foreign key constraint

2005-04-11 Thread jyjeanyves
Thanks for your answer Armin, I'am using OJB 1.0.3, but instead of database.makePersistent(dbc) i'am using tx.lock(dbc, WRITE) Don't know if it matters. The relation is a simple 1:1, but the Location object has itself childs that are Location too, so maybe that's not so simple because OJB

Re: [OJB-ODMG] foreign key constraint

2005-04-11 Thread Armin Waibel
[EMAIL PROTECTED] wrote: Thanks for your answer Armin, I'am using OJB 1.0.3, but instead of database.makePersistent(dbc) i'am using tx.lock(dbc, WRITE) Don't know if it matters. This shouldn't matter, but it's recommended to use database.makePersistent(dbc) when insert new objects. The relation

partial materialization?..

2005-04-11 Thread Kirill Petrov
Hello everybody, I have a database that has very complex objects called Models. From time to time I need to present the user only with the names of those models. Since I don't want to instantiate every model only for that, I used dynamic proxies for all the classes that comprise a particular