Is there any way to determine via the JDBC which code page is being used for
character translation? My DBA swears we're using ISO-8859-1, but character
0x96 keeps coming out as 0x13.
Thanks!
_
Dont just search. Find. Check out the
cannot map arguments
from
the foreign class descriptor in the same tag. I hope I
am
making sense. Anyway I appreciate any input. I will keep plugging away at
it
to see if I can get any joy
Thanks!
Fiona
- Original Message -
From: "Glenn Barnard" <[EMAIL PROTECTED]>
To
ributes in
the of the transactions class. Would it be necessary to
create a class that 'joins' Payments and Transactions together (eg in a new
Deposits entity) and then map that to a class descriptor which would have a
that could access all the attributes of both classes?
Thanks again
Fiona, a couple of questions/issues...
1) Iin your repository.xml, have you declared the as
SequenceManagerNativeImpl? Let me know if you need the syntax
2) I think you need also "autoincrement="true"" in the
for PaymentID in the Payments table
From: "Fiona Magner" <[EMAIL PROTECTED]>
Rep
se
{
columnList = appendListOfColumns(columns, stmt);
}
In this case, columns are ones that are specified, which ReportQuery is
used for.
-Andrew
-Original Message-
From: Glenn Barnard [mailto:[EMAIL PROTECTED]
Sent: Thursday, May 20, 2004 2:10 PM
To: [EM
I posted this yesterdayWould someone PLEASE help me. Am running out of
time.
We use Oracle 9 and have several different functions we can call. In
OJB, they are all mapped with the table name of DUAL. For example:
SELECT function(args) AS column FROM DUAL
Our repository.xml has a table e
We use Oracle 9 and have several different functions we can call. In OJB,
they are all mapped with the table name of DUAL. For example:
SELECT function(args) AS column FROM DUAL
Our repository.xml has a table entry for each function so that the result is
kept in it's own class. For example
WOW! Are you saying name="super" works Or, just a suggestion. This is
some good s!
From: Phil Warrick <[EMAIL PROTECTED]>
Reply-To: "OJB Users List" <[EMAIL PROTECTED]>
To: OJB Users List <[EMAIL PROTECTED]>
Subject: extent mapping (was: another JOIN question)
Date: Wed, 12 May 2004 11:2
It should be returned in the data object that was just inserted.
From: "Mindy Pereira" <[EMAIL PROTECTED]>
Reply-To: "OJB Users List" <[EMAIL PROTECTED]>
To: "OJB Users List" <[EMAIL PROTECTED]>
Subject: Retrieve auto-incremeneted primary-key? Date: Thu, 29 Apr 2004
11:21:28 -0400
Is there a wa
hanks Glenn,
Yes I am using OJB rc6. And I have also tried
without
using any sequence manager. Do I neeed to create my own sequence manager.
How will it help and how do I do that ? Please tell me if you have any
idea.
Thanks again.
Regards,
Nilesh.
- Original Message -
Your settings look good. I use this technique with MS SQL Server and all is
working well. Please note which version of OJB you're using. Hopefully, its
rc6!
From: "Nilesh" <[EMAIL PROTECTED]>
Reply-To: "OJB Users List" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
CC: <[EMAIL PROTECTED]>
Subject:
fortunately the only solutions is to use a queryBySql or you do the
intersect processing programmatically.
jakob
Glenn Barnard wrote:
I need to perform the following SQL query against my db. Can anyone steer
me in the right direction?
SELECT * FROM keywords WHERE keyword_id IN
(
SELECT keywo
at was the cause?
Also I had autoincrement set to "database" in my XDoclet comments.
I'll reconvert it back and see if this was the culprit. Thanks for your
time!
-Stijn
P.S. To my understanding I should use the NativeImpl sequence manager for
- Original Message -
From: &qu
Just a stab at trying to help. Hopefully I have read your problem statement
correctly.
I'm using auto increment for a MS SQL Server 2000 DB. It needs rc6--but
that's just MS SQL Server.
OK. If you're having the DB assign the PK value, then you need an attribute
"autoincrement="true"" and "acc
]>
Reply-To: "OJB Users List" <[EMAIL PROTECTED]>
To: OJB Users List <[EMAIL PROTECTED]>
Subject: Re: Primary Key from Insert
Date: Thu, 18 Mar 2004 01:34:41 +0100
Hi,
Glenn Barnard wrote:
Armin:
My suspicions are confirmed. JdbcAccessImpl closes its Statement after the
i
I need to perform the following SQL query against my db. Can anyone steer me
in the right direction?
SELECT * FROM keywords WHERE keyword_id IN
(
SELECT keyword_id FROM listing_keywords WHERE listing_id=3289923 AND
location_id=1007869
intersect
SELECT keyword_id FROM listing_keywords WHERE listi
Congratulations!!!
I have a couple of questions...
First, will it have a debuggable version? rc5 didn't (at least as far as I
could see)?
McCaffrey, John G. <[EMAIL PROTECTED]> and I have been working with
OJB to get the primary key from a native sequence manager. John's using DB2
and I'm usi
ion was a new connection so that the call to get the identity
would not happen within the same tx that the row was inserted with, but now
I see that that isn't the case.(though I haven't run any multithreaded
tests)
-Original Message-
From: Glenn Barnard [mailto:[EMAIL PROTECTED]
Sent:
ist' <[EMAIL PROTECTED]>
Subject: RE: Primary Key from Insert
Date: Fri, 26 Mar 2004 10:37:28 -0600
Glenn,
well, I am no expert at this, but I would like to try to help.
can you give me a quick run down of your situation again (I know its in
previous posts, just give me a summary)
details:
I'm dead in the water. Can't get the PK query to return anything. Am at wits
end as all my development efforts are dependent on this working. No further
responses from the OJB guys leading me to try something else.
From: "McCaffrey, John G." <[EMAIL PROTECTED]>
T
From: Armin Waibel <[EMAIL PROTECTED]>
Reply-To: "OJB Users List" <[EMAIL PROTECTED]>
To: OJB Users List <[EMAIL PROTECTED]>
Subject: Re: Primary Key from Insert
Date: Thu, 18 Mar 2004 01:34:41 +0100
Hi,
Glenn Barnard wrote:
Armin:
My suspicions are confirmed
s the insert,
and that's where I'm having a problem with OJB.
I'm away for the weekend and will be looking at the problem in more depth.
Will post my results Monday.
From: "McCaffrey, John G." <[EMAIL PROTECTED]>
To: 'Glenn Barnard' <[EMAIL PROTECTED]>
l the transactions with that same
object
Thanks for being patient with me.
From: Armin Waibel <[EMAIL PROTECTED]>
Reply-To: "OJB Users List" <[EMAIL PROTECTED]>
To: OJB Users List <[EMAIL PROTECTED]>
Subject: Re: Primary Key from Insert
Date: Wed, 17 Mar 2004 1
st case called ...NativeIdentifierTest.
This test use database based identity columns for PK assignment and pass
against hsql and mysql.
Can post more detailed what you are doing? Source or pseudo code?
regards,
Armin
Glenn Barnard wrote:
Interesting exercise, but it didn't work.
I extended
ing (for my multi-joined object) and insert one table, get
the identity, then insert the children objects (that are relying on that ID
as a FK).
What I would really like is to tell OJB to get the Identity, for the
parent,
and insert it into the children, all on its own.
Let me know if you solve your
ected.
Any suggestions?
From: Armin Waibel <[EMAIL PROTECTED]>
Reply-To: "OJB Users List" <[EMAIL PROTECTED]>
To: OJB Users List <[EMAIL PROTECTED]>
Subject: Re: Primary Key from Insert
Date: Wed, 17 Mar 2004 17:43:02 +0100
Glenn Barnard wrote:
Armin, thanks for
ed" by Maven, with
"ant htmldoc" you can generate the local documentation)
or your persistent capable objects can implement PersistenceBrokerAware
interface and you assign the PK by hand in the afterInsert method (obtain
connection from PB instance and perform sql query by your
I'm using SQL Server 2000 and need to get the primary key returned in the
data model after an insert. My research shows that the query "SELECT
SCOPE_IDENTITY() AS newID" needs to be executed. What do I need to do to get
OJB to automatically populate the PK field in the data model it returns?
__
That's easy:
Query query = new QueryByCriteria(, null)
Collection c = broker.getCollectionByQuery(query);
From: "Robert S. Sfeir" <[EMAIL PROTECTED]>
Reply-To: "OJB Users List" <[EMAIL PROTECTED]>
To: OJB Users List <[EMAIL PROTECTED]>
Subject: Criteria with select with no where clause?
Date: T
29 matches
Mail list logo
