Hello,
when using identical code, working in standalone environment in jboss, the
following error is thrown:
12:30:32,012 INFO [TxConnectionManager] throwable from unregister connection
java.lang.IllegalStateException: Trying to return an unknown connection2! [EMAIL
PROTECTED]
...
...
I'm using auto-increment fields.
The OJB defines the new ID for this fields when I insert a new record.
I would like to know how can I know those new ID's values after the
insert task using ODMG.
There's a function that record the object in the database and return the
ID value?
Otherwise, what
Hello everyone,
I've got a 1:1 Association, like a Customer and its Address. In the object model, the
Address should be navigable from the Customer, but not the other way round.
The existing database model has got a customer_id foreign key pointing from the
Address to the primary id of the
HEEELPP!
I've worked throught most of the my configuration woes with OJB, JBoss
3.0.8 and HSQLDB. Everthing seems to be in place and I can query objects
from the DB without a problem. The only problem is saving my objects to
the DB. I get a SQL error (function not supported).
Here's the
Hello all,
i'm inserting a timestamp with obj rc4 in mysql, with a null value, but mysql
insert the actual date. It's a bug, must i make a special mapping??
Thanks a lot
I am posting to both the USER and the DEV mailing lists because I have
searched for answers on both archives and the topics are mentioned (but
not resolved) on both lists.
I am using W2K, MySQL 4.0 and OJB 1.0 RC5. I performed a clean source
install and build using the documented procedures
Can't you just look at the primary key field (eg myObject.oid) of the object to
retrieve the id value? OJB/ODMG will automatically set this value when the object is
persisted/retrieved...
Rob :)
-Original Message-
From: Fabiano Fernandes de Souza [mailto:[EMAIL PROTECTED]
Sent:
If you use hsqldb in client-server mode you can set it up to log all the
sql queries (see Advanced Topics in the HSQLDB docs). Or configure p6spy
to do the same thing on the OJB side... This might give you some ideas
about what it is trying to do...
I assume that your db connection in the
Coup, Robert Muir wrote:
If you use hsqldb in client-server mode you can set it up to log all the
sql queries (see Advanced Topics in the HSQLDB docs). Or configure p6spy
to do the same thing on the OJB side... This might give you some ideas
about what it is trying to do...
I assume that your db
Well...
From the tutorial...
public class Product
{
/** Artificial primary-key */
private Integer id;
/** price per item*/
private Double price;
/** stock of currently available items*/
private Integer stock;
/** product name*/
private String name;
/*
Hi,
AFAIK, fields of TIMESTAMP type in mysql automatically fill themselves
with the current time/date if you INSERT or UPDATE them to null
values... Maybe you should use a mysql DATETIME field which is
essentially the same data type, just without the automatic cleverness?
Rob :)
-Original
Hi,
I have the following problem:
I have a table keywords which has two non-decomposed m:n mappings to the tables
document and file. The latter two both implement the interface SupportItem. In
my Keyword class i would like to have a collection of all SupportItems for this
keyword.
Is it
Hi,
Did you see my response to your other post? Please reply to the list.
Cheers,
Rob :)
-Original Message-
From: Patrick Scheuerer [mailto:[EMAIL PROTECTED]
Sent: Tuesday, 6 January 2004 10:17 a.m.
To: OJB Users List
Subject: How to combine two non-decomposed m:n mappings in one
Coup, Robert Muir wrote:
Hi,
Did you see my response to your other post? Please reply to the list.
No I didn't, sorry! I somehow gave up on this post...
Idea #2:
How about:
class-descriptor class=SupportItemI
extent-class class-ref=Document/
extent-class class-ref=Download/
There was some trick I remember about that - try using java.sql.Date ...
Rob :)
-Original Message-
From: Brian Sam-Bodden [mailto:[EMAIL PROTECTED]
Sent: Tuesday, 6 January 2004 11:04 a.m.
To: [EMAIL PROTECTED]
Subject: Re: HSQLDB + JBoss Help (Function is Not Supported SQL
Exception)
Hi,
This sounds interesting. Just let me make sure I got it right: I have
to create a new table t_download_supportitemI which has a m:n mappings
to
t_download and and one to t_document (pretty much a replacement for
t_pal_model)
Well, I would call it t_pal_model_supportitemI, and its a
Hi!
I'm facing a problem: I've a nice piece of sofware that load modules at runtime.
Mostly, each module has their own .xml file with necessary configuration. So, there
are no problem here.
But imagine that I've a customer_repository.xml, that references a quite large table
(let's say 100.000,
Coup, Robert Muir wrote:
Well, I would call it t_pal_model_supportitemI, and its a replacement
for t_pal_model_document AND t_pal_model_download
I guess that's what I wanted to say :-)
Tell us how you get on.
To remove any potential for misunderstanding (and since I'm a visual person :-))
I
As you can see on the picture i adopted your t_ prefix for tables :-) It makes
the repository.xml a lot easier to read! I hope you don't have a copyright on it ;-)
I will let you know how I get along. Thanks again!
Patrick
-
Hi,
As you can see on the picture i adopted your t_ prefix for tables :-)
It makes
the repository.xml a lot easier to read! I hope you don't have a
copyright on it ;-)
Yes. Well, I also got sick of playing with tables named 'user' and
'group' in projects - they need to be specified as
Coup, Robert Muir wrote:
Hmmm... now I'm confused again. :) Ah, you snuck in some other changes -
keyword now relates to pal_model? Or maybe not...
*** Assuming you want keyword and pal_model separate ***
The scenario is this: a PalModel should have a collection of SupportItemsI and a
Keyword
... and now for something completely different:
do i even have define foreign key constraints in my database??? I'm having the
impression that OJB is handling all the joins. Is it enough to have some loose
tables in my DB ???
Patrick
... and now for something completely different:
do i even have define foreign key constraints in my
database??? I'm having the
impression that OJB is handling all the joins. Is it enough
to have some loose
tables in my DB ???
Well, it's up to you.
OJB can and will do it anyway. If
The scenario is this: a PalModel should have a collection of
SupportItemsI and a
Keyword should have a collection of support items.
Keyword doesn't relate to pal_model.
Okay. So what was in my last email should work :)
Something else just came to my mind: a category should also
have a
One more important thing.
Make sure your primary keys are unique across Documents _and_ Downloads.
Ie. If there is document #10 there should never be download #10
This is because they are in the same extent. If you retrieve a
collection of SupportItemI's then they need to have unique IDs, or a
Thank you very much for your time and effort Robert!
I'm trying to get your solution to work now (keep your fingers crossed! :-) )
Since this is all for my thesis paper you will get an honorable mention in the
acknowledgment section :-)
Thanks again and I'll let you know If it works!
Take
26 matches
Mail list logo
