Hello ,
I am very new to OJB .I have the following query .
I am using the class ReportQueryByCriteria and am using some group
functions in it .
Eg .
query = new ReportQueryByCriteria(Employee.class, criteria);
query.setAttributes(new String[] { dept__id ,
Hi Chandan,
Chandan AHUJA wrote:
Hello ,
I am very new to OJB .I have the following query .
I am using the class ReportQueryByCriteria and am using some group functions in it .
Eg .
query = new ReportQueryByCriteria(Employee.class, criteria);
query.setAttributes(new
Hi Bikram,
Bikram B Kapoor wrote:
But in a different scenario, where the table structure changes to
table: mycategory
ID - primary key
name varchar
table: myproducts -- the foriegn key of category table is not present
pid - primary key
prodname
table: mycategoryproduct
cpid primary key
ID --
Hello Armin ,
Thanx for your prompt help .
But the problem is not fully solved yet .
I am able to cast the return object of iterator.next() to an array of object
, its working fine .
Also I am able to cast the first element (Dept__id)of that array into (String)
, its also working
Chandan AHUJA wrote:
Hello Armin ,
Thanx for your prompt help .
But the problem is not fully solved yet .
I am able to cast the return object of iterator.next() to an array of object
, its working fine .
Also I am able to cast the first element (Dept__id)of that array into (String)
May I suggest that you simply dump the class to the stderr e.g. something
like this
Object tmp = result[1];
System.err.println( tmp == null ? Null : message.getClass().getName() +
= + String.valueOf(tmp));
This should show you what to cast to (as well as the value returned).
Tangent
Thanx Armin ,its class type is BigDecimal , and now its working fine when I
cast it to BigDecimal.
I got to know this when I did object[1].getClass() .
By the way armin , is there any rule which OJB follows for the data type of
the the results of query in these type of cases , or do one has to
hi all,
that's where the jdbcTypes fit in:
int types[] = new int[]{Types.DECIMAL, Types.VARCHAR, Types.BIGINT};
Criteria crit = new Criteria();
crit.addLike(firstname, %o%);
ReportQueryByCriteria q = QueryFactory.newReportQuery(Person.class, crit);
q.setAttributes(new String[]{id, firstname,
Hi All,
I'm currently having a problem with reordering of written objects done
by the org.apache.ojb.odmg.ObjectEnvelopeTable.reorder() method. I have
implicit locking off, and I always lock objects in the order they
would have to in order to maintain referrential integrity. That is, I
Hi Colin,
which version of OJB do you use?
Did you try to use TransactionExt.flush() calls to separate the calls
beginTxn();
B b = new B();
a.setCurrentB(b);
lock(b); // corresponds to an INSERT into B's table
((TransactionExt) tx).flush();
lock(a); // corresponds to an UPDATE on A's
Hi Armin, thanks for the response.
I'm using OJB 1.0.1. I've never noticed the TransactionExt.flush()
method. Calling it does seem to fix the problem. I do have 2
questions, however:
1. the javadoc says flush() is very similar to
Transaction.checkpoint(). How do they differ? and would
Sorry, I think I can answer my own questions: checkpoint() commits the
database transaction, while flush() only commits the ODMG transaction.
So it would seem that calling flush() defeats the purpose of having
transactions in the first place, and would therefore be inappropriate to
call
Hello
We use OJB in a websphere z/OS environment. If I set the
PersistenceBrokerFactoryClass to PersistenceBrokerSyncImpl as it
is recommended in the documentation I get following error if I try to
insert, update
or delete some thing:
Exception data: java.lang.UnsupportedOperationException:
In
Colin Kilburn wrote:
Hi Armin, thanks for the response.
I'm using OJB 1.0.1. I've never noticed the TransactionExt.flush()
method. Calling it does seem to fix the problem. I do have 2
questions, however:
1. the javadoc says flush() is very similar to
Transaction.checkpoint(). How do
Hi Matthias,
[EMAIL PROTECTED] wrote:
Hello
We use OJB in a websphere z/OS environment. If I set the
PersistenceBrokerFactoryClass to PersistenceBrokerSyncImpl as it
is recommended in the documentation I get following error if I try to
insert, update
or delete some thing:
Exception data:
Thanks Armin. flush() fixes the problem. I just tried upgrading to
1.0.2, but that doesn't appear to fix the problem. I can live with the
flush() workaround until that is solved.
Thanks again, I appreciate your help.
Colin
Armin Waibel wrote:
Colin Kilburn wrote:
Hi Armin, thanks for the
Hi I am a newbie to OJB. The OR mappings tutorial is kinda hard for me to
understand. Can somebody suggest a good book or tutorials in easy to understand
manner.
Thanks
__
Do You Yahoo!?
Tired of spam? Yahoo! Mail has the best spam protection
Hi,
I have 2 tables.
Table1
Products
prodID int
prodName varchar
categoryID char
suppID char
ordrID char
ProdID
ProdName
categoryID
suppID
ordrID
1
Xyzproduct
CA
SD
OD
2
ABCprod
CB
SE
OE
3
lmnprod
CC
SF
PO
Table 2
DescMaster
DescID
DescID2
DescName
Hi,
Sorry my tables were messed up before.
Here is my issue.
I have the follwoing 2 tables. products and descMaster tables. In products
table i have the ids for category,supplier,order. the descriptions for these
are stored in the descMaster table.
I need to create a list of all products
Hi, Sorry my tables were messed up before.i am attaching the word doc also with the tables this time. Here is my issue.I have the follwoing 2 tables. products and descMaster
tables. In products table i have the ids for category,supplier,order. the descriptions for these are stored in the
20 matches
Mail list logo
