RE: Anonymous keys

2006-12-05 Thread Vagula
 

Hi,

 

  I have some doubts though:

 

   1. In the access attribute for an reference field (as
given below in repository_user.xml) which is the best option?

a.  read only 

b.  read write 

c.  anonymous

2. When I use access=anonymous, I have to retrieve the references before
I store the object. This is causing problem when I run the use case for
35 concurrent users. Any suggestions?

 

3. When  I use access = read, I add the attributes in the Java bean. But
when I run the application it is giving an error "Cannot Insert Null
into a Not Null column"

 



  

  

  

  

  

  

  

  

  

   

  

  

   

  

  

   

  

  

   

  

  

   

  

   



   

  OJB version I use is 1.0.

 

  Thanks for the Help!

 

Regards,

Vagula 

 

-Original Message-
From: Armin Waibel [mailto:[EMAIL PROTECTED] 
Sent: Wednesday, December 06, 2006 7:26 AM
To: OJB Users List
Subject: Re: Anonymous keys

 

Hi Vagula,

 

I'm sorry for the late reply - I was ill last week.

 

Vagula wrote:

> 

> 

> 

> Hi,

> 

> 

> 

> 

> What are the drawbacks of using the anonymous keys?

> 

> Will there be performance bottleneck?

> 

> 

> 

> 

>   I have read the material in OJB site, it doesn't talk about

> drawbacks.

> 

 

Did you read this?

http://db.apache.org/ojb/docu/guides/advanced-technique.html#How+do

This section describe how AK work. One drawback is that you can't use AK


  (except in 1:1 refenences) if you want to cluster OJB. I don't know 

about a performance bottleneck when using AK, but I never made serious 

multi-threaded performance comparisons (with/without AK).

 

regards,

Armin

 

> 

> 

> 

> Regards,

> 

> Vagula

> 

> 

> 

> 

> 

> 

> 

> 

> 

> 

>  CAUTION - Disclaimer *

> This e-mail contains PRIVILEGED AND CONFIDENTIAL INFORMATION intended
solely for the use of the addressee(s). If you are not the intended
recipient, please notify the sender by e-mail and delete the original
message. Further, you are not to copy, disclose, or distribute this
e-mail or its contents to any other person and any such actions are
unlawful. This e-mail may contain viruses. Infosys has taken every
reasonable precaution to minimize this risk, but is not liable for any
damage you may sustain as a result of any virus in this e-mail. You
should carry out your own virus checks before opening the e-mail or
attachment. Infosys reserves the right to monitor and review the content
of all messages sent to or from this e-mail address. Messages sent to or
from this e-mail address may be stored on the Infosys e-mail system.

> ***INFOSYS End of Disclaimer INFOSYS***

 

 

-

To unsubscribe, e-mail: [EMAIL PROTECTED]

For additional commands, e-mail: [EMAIL PROTECTED]

 



Anonymous keys

2006-11-30 Thread Vagula



Hi,



What are the drawbacks of using the anonymous keys?

Will there be performance bottleneck?



  I have read the material in OJB site, it doesn't talk about
drawbacks.



Regards,

Vagula







 CAUTION - Disclaimer *
This e-mail contains PRIVILEGED AND CONFIDENTIAL INFORMATION intended solely 
for the use of the addressee(s). If you are not the intended recipient, please 
notify the sender by e-mail and delete the original message. Further, you are 
not to copy, disclose, or distribute this e-mail or its contents to any other 
person and any such actions are unlawful. This e-mail may contain viruses. 
Infosys has taken every reasonable precaution to minimize this risk, but is not 
liable for any damage you may sustain as a result of any virus in this e-mail. 
You should carry out your own virus checks before opening the e-mail or 
attachment. Infosys reserves the right to monitor and review the content of all 
messages sent to or from this e-mail address. Messages sent to or from this 
e-mail address may be stored on the Infosys e-mail system.
***INFOSYS End of Disclaimer INFOSYS***

RE: Clear cache issue!

2006-10-16 Thread Vagula
Hi,

I tried this:
broker.removeFromCache(entityOrId);
But this also results in dirty read.

Regards,
Vagula 
 

-Original Message-
From: Vasily Ivanov [mailto:[EMAIL PROTECTED] 
Sent: Monday, October 16, 2006 12:51 PM
To: OJB Users List
Subject: Re: Clear cache issue!

Hi Vagula,

Consider this one:
broker.removeFromCache(entityOrId);

Cheers,
  Vasily

On 10/16/06, Vagula <[EMAIL PROTECTED]> wrote:
>
> Hi All,
>
>
>
> I'm using the following code:
>
>
>
> QueryByCriteria queryByCriteria =
>
> new QueryByCriteria(RefInfoData.class,
criteria,
> true);
>
>
>
> broker.clearCache();
>
>
>
> Collection refInfo =
>
> (Collection)
> broker.getCollectionByQuery(queryByCriteria);
>
>
>
> For the class 'RefInfoData' we have set the cache level as
> default implementation.
>
>
>
> When we use the method "broker.clearCache()" we are facing
> performance issues.
>
> But when we don't clear cache there is dirty read.
>
>
>
> We are maintaining the cache for reference tables.
>
>
>
> Is there a way to clear cache for the specific object
> instead of whole cache?
>
>
>
>
>
> Regards,
>
> Vagula
>
>
>
>
>
>
>
>  CAUTION - Disclaimer *
> This e-mail contains PRIVILEGED AND CONFIDENTIAL INFORMATION intended
solely for the use of the addressee(s). If you are not the intended
recipient, please notify the sender by e-mail and delete the original
message. Further, you are not to copy, disclose, or distribute this
e-mail or its contents to any other person and any such actions are
unlawful. This e-mail may contain viruses. Infosys has taken every
reasonable precaution to minimize this risk, but is not liable for any
damage you may sustain as a result of any virus in this e-mail. You
should carry out your own virus checks before opening the e-mail or
attachment. Infosys reserves the right to monitor and review the content
of all messages sent to or from this e-mail address. Messages sent to or
from this e-mail address may be stored on the Infosys e-mail system.
> ***INFOSYS End of Disclaimer INFOSYS***
>

-
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]


-
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]



Clear cache issue!

2006-10-15 Thread Vagula

Hi All,



I'm using the following code:



QueryByCriteria queryByCriteria =

new QueryByCriteria(RefInfoData.class, criteria,
true);



broker.clearCache();



Collection refInfo =

(Collection)
broker.getCollectionByQuery(queryByCriteria);   



For the class 'RefInfoData' we have set the cache level as
default implementation.



When we use the method "broker.clearCache()" we are facing
performance issues.

But when we don't clear cache there is dirty read.

   

We are maintaining the cache for reference tables.



Is there a way to clear cache for the specific object
instead of whole cache?





Regards,

Vagula







 CAUTION - Disclaimer *
This e-mail contains PRIVILEGED AND CONFIDENTIAL INFORMATION intended solely 
for the use of the addressee(s). If you are not the intended recipient, please 
notify the sender by e-mail and delete the original message. Further, you are 
not to copy, disclose, or distribute this e-mail or its contents to any other 
person and any such actions are unlawful. This e-mail may contain viruses. 
Infosys has taken every reasonable precaution to minimize this risk, but is not 
liable for any damage you may sustain as a result of any virus in this e-mail. 
You should carry out your own virus checks before opening the e-mail or 
attachment. Infosys reserves the right to monitor and review the content of all 
messages sent to or from this e-mail address. Messages sent to or from this 
e-mail address may be stored on the Infosys e-mail system.
***INFOSYS End of Disclaimer INFOSYS***

Result set closed! Help Urgent!

2006-09-19 Thread Vagula
ws390.wc.httpcatcher.WS390Router$WS390RouterDispatcher.dispatchB
yURI(WS390Router.java:364)

  at

com.ibm.ws390.wc.httpcatcher.WS390Router$WS390RouterDispatcher.service(W
S390Router.java:318)

  at

com.ibm.ws.webcontainer.http.HttpConnection.handleRequest(HttpConnection
.java:70)

  at

com.ibm.ws390.wc.http.HttpConnection.readAndHandleRequest(HttpConnection
.java:810)

  at

com.ibm.ws390.wc.http.HttpConnection.handle390Request(HttpConnection.jav
a:701)

  at

com.ibm.ws390.wc.httpcatcher.WS390HttpTransport.handleRequest(WS390HttpT
ransport.java:94)

  at

com.ibm.ws390.wc.httpcatcher.WS390HttpTransportWrapper.httprequest(WS390
HttpTransportWrapper.java:58)

  at

com.ibm.ws390.orb.ServerRegionBridge.httpinvoke(ServerRegionBridge.java:
704)

  at

com.ibm.ws390.orb.ORBEJSBridge.httpinvoke(ORBEJSBridge.java(Inlined

Compiled Code))

  at

com.ibm.ws390.orb.parameters.HTTPInvoke.HTTPInvokeParmSetter(HTTPInvoke.
java(Compiled

 Code))

Caused by: org.apache.ojb.broker.PersistenceBrokerSQLException: Calling

ResultSet.next() failed

  at org.apache.ojb.broker.accesslayer.RsIterator.hasNext(Unknown

Source)

  at org.apache.ojb.broker.accesslayer.RsIterator.next(Unknown
Source)

  at org.apache.ojb.broker.accesslayer.PagingIterator.next(Unknown

Source)

  at

org.apache.ojb.broker.core.QueryReferenceBroker.getCollectionByQuery(Unk
nown

 Source)

  ... 57 more

Caused by: com.ibm.db2.jcc.a.SqlException: Invalid operation: result set
closed

  at com.ibm.db2.jcc.a.ue.mb(ue.java(Inlined Compiled Code))

  at com.ibm.db2.jcc.a.ue.c(ue.java(Compiled Code))

  at com.ibm.db2.jcc.a.ue.next(ue.java(Compiled Code))

  at

com.ibm.ws.rsadapter.jdbc.WSJdbcResultSet.next(WSJdbcResultSet.java(Comp
iled

 Code))

  ... 61 more 







Information's:

1.   We are Using OJB 1.0

2.   We are setting the isolation level as READ_COMMITTED through
web.xml & ibm-web-ext.xmi.

3.   We are using WAS server

4.   The database used is DB2



Please help.





Regards,

Vagula







 CAUTION - Disclaimer *
This e-mail contains PRIVILEGED AND CONFIDENTIAL INFORMATION intended solely 
for the use of the addressee(s). If you are not the intended recipient, please 
notify the sender by e-mail and delete the original message. Further, you are 
not to copy, disclose, or distribute this e-mail or its contents to any other 
person and any such actions are unlawful. This e-mail may contain viruses. 
Infosys has taken every reasonable precaution to minimize this risk, but is not 
liable for any damage you may sustain as a result of any virus in this e-mail. 
You should carry out your own virus checks before opening the e-mail or 
attachment. Infosys reserves the right to monitor and review the content of all 
messages sent to or from this e-mail address. Messages sent to or from this 
e-mail address may be stored on the Infosys e-mail system.
***INFOSYS End of Disclaimer INFOSYS***

RE: Concurrent Users-Please Help!

2006-09-05 Thread Vagula

Hi,

Let's say there is a Table A with columns Col1 (Id primary key), Col2, 
Col3, and Col4.
Say the data for the combination of col2 and col3 should be unique.

Both user1 and user2 are trying to insert (create) the same data
Col1- (id self generated)
Col2-A
Col3-1
Col4-abc

In my case two rows are inserted.
What are the settings that I can make for adding a single row and 
updating the same?

Regards,
Vagula

-Original Message-
From: Matthias Roth [mailto:[EMAIL PROTECTED]
Sent: Tuesday, September 05, 2006 11:50 AM
To: ojb-user@db.apache.org
Subject: RE: Concurrent Users-Please Help!

Hi
With the default settings from ojb it works.
But every thread must have it's one borker!

Matthias Roth


-Ursprüngliche Nachricht-
Von: Vagula [mailto:[EMAIL PROTECTED]
Gesendet: Dienstag, 5. September 2006 06:31
An: OJB Users List
Betreff: RE: Concurrent Users-Please Help!




I get the broker from the PB pool.
I close the transaction in a finally block,

Please let me know

1. What are the settings that are to be made for handling concurrent 
transaction
using PB API?


Regards,
Vagula



-
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]


 CAUTION - Disclaimer *
This e-mail contains PRIVILEGED AND CONFIDENTIAL INFORMATION intended solely 
for the use of the addressee(s). If you are not the intended recipient, please 
notify the sender by e-mail and delete the original message. Further, you are 
not to copy, disclose, or distribute this e-mail or its contents to any other 
person and any such actions are unlawful. This e-mail may contain viruses. 
Infosys has taken every reasonable precaution to minimize this risk, but is not 
liable for any damage you may sustain as a result of any virus in this e-mail. 
You should carry out your own virus checks before opening the e-mail or 
attachment. Infosys reserves the right to monitor and review the content of all 
messages sent to or from this e-mail address. Messages sent to or from this 
e-mail address may be stored on the Infosys e-mail system.
***INFOSYS End of Disclaimer INFOSYS***

-
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]



RE: Concurrent Users-Please Help!

2006-09-04 Thread Vagula



I get the broker from the PB pool.
I close the transaction in a finally block,

Please let me know
1. What are the settings that are to be made for handling concurrent 
transactionusing PB API?


Regards,
Vagula


-Original Message-
From: Matthias Roth [mailto:[EMAIL PROTECTED]
Sent: Tuesday, September 05, 2006 2:24 AM
To: ojb-user@db.apache.org
Subject: AW: Concurrent Users-Please Help!

Hi
How do you get the broker?
In your code snip the statement
broker=PersistenceBrokerFactory.defaultPersistenceBroker();
and
broker.close is missing. Where do you do this calls?
is missing. where do you do this calls?

Matthias Roth

-Ursprüngliche Nachricht-
Von: Vagula [mailto:[EMAIL PROTECTED]
Gesendet: Montag, 4. September 2006 14:52
An: OJB Users List
Betreff: RE: Concurrent Users-Please Help!



Hi All,





I'm using:

1.   OJB version 1.0

2.   The block looks like:

  broker.beginTransaction();   

  broker.store(Object);

  broker.commitTransaction();

Regards,

Vagula



-
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]


 CAUTION - Disclaimer *
This e-mail contains PRIVILEGED AND CONFIDENTIAL INFORMATION intended solely 
for the use of the addressee(s). If you are not the intended recipient, please 
notify the sender by e-mail and delete the original message. Further, you are 
not to copy, disclose, or distribute this e-mail or its contents to any other 
person and any such actions are unlawful. This e-mail may contain viruses. 
Infosys has taken every reasonable precaution to minimize this risk, but is not 
liable for any damage you may sustain as a result of any virus in this e-mail. 
You should carry out your own virus checks before opening the e-mail or 
attachment. Infosys reserves the right to monitor and review the content of all 
messages sent to or from this e-mail address. Messages sent to or from this 
e-mail address may be stored on the Infosys e-mail system.
***INFOSYS End of Disclaimer INFOSYS***

-
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]



RE: Concurrent Users-Please Help!

2006-09-04 Thread Vagula
 

Hi All,

 

 

I'm using:

1.   OJB version 1.0

2.   The block looks like:

  broker.beginTransaction();

  broker.store(Object); 

  broker.commitTransaction();

Regards,

Vagula 

 

 

-Original Message-
From: Matthias Roth [mailto:[EMAIL PROTECTED] 
Sent: Monday, September 04, 2006 5:49 PM
To: 'OJB Users List'
Subject: AW: Concurrent Users-Please Help!

 

Hi Vagula

It is difficult to answer if there is not code sequence and properties.

Your problem can be in some OJB settings but it is also possible

That you have a kind of anti pattern. For example same reference to

The data object in both threads.

 

We work with over 1000 concurrent threads on the same data object and have

no problem. Hear some example:

 

1. We work with ojb version 1.04

2. we work not with a cash (the cash in version rc1 was corrupt), but

perhaps it works now.

2. each call looks like:

   Try{

 broker = PersistenceBrokerFactory.defaultPersistenceBroker();

 // in J2EE do not handle transctions

 broker.store(yourObject);

   }finaly{

 if (broker != null && ! broker.isClosed())

broker.close();

   }



 

 

Matthias Roth

 

-Ursprüngliche Nachricht-

Von: Vagula [mailto:[EMAIL PROTECTED] 

Gesendet: Montag, 4. September 2006 11:00

An: OJB Users List

Betreff: RE: Concurrent Users-Please Help!

 

Hi All,

 

I'm using PB API. When concurrent threads are running on a

particular object, the data

gets corrupted.

 

Let say Thread1 sends data 1,2,3,4

 Thread2 sends data 5,6,7,8

 

In the DB data stored is 1,2,5,6.

 

How can I solve this issue? 

Please Help!! Urgently need solution!!

 

Thanks in Advance!

Regards,

Vagula 

 

 

-Original Message-

From: Vagula [mailto:[EMAIL PROTECTED] 

Sent: Sunday, September 03, 2006 11:55 AM

To: OJB Users List

Subject: RE: Concurrent Users

 

Hi,

 

Yes I need info about concurrent connections. What are the settings

to be in OJB.properties? 

 

Thanks!    

 

Regards,

Vagula 

 

 

-Original Message-

From: Antonio Gallardo [mailto:[EMAIL PROTECTED] 

Sent: Friday, September 01, 2006 8:25 PM

To: OJB Users List

Subject: Re: Concurrent Users

 

Hi Vagula,

 

Would you explain more your idea? If you are talking about concurrent 

connections to the database, OJB has database connection pool, which can 

be configured in the OJB.properties.

 

Best Regards,

 

Antonio Gallardo.

 

Vagula escribió:

> Hi All,

> 

> 

> 

> How can I handle concurrent users using OJB?

> 

>    

> 

> TIA.

> 

> 

> 

> Regards,

> 

> Vagula

> 

> 

> 

> It may be more worthwhile, to find out what is right than-who is right.

> 

> 

> 

> 

> 

> 

> 

>  CAUTION - Disclaimer *

> This e-mail contains PRIVILEGED AND CONFIDENTIAL INFORMATION intended

solely for the use of the addressee(s). If you are not the intended

recipient, please notify the sender by e-mail and delete the original

message. Further, you are not to copy, disclose, or distribute this e-mail

or its contents to any other person and any such actions are unlawful. This

e-mail may contain viruses. Infosys has taken every reasonable precaution to

minimize this risk, but is not liable for any damage you may sustain as a

result of any virus in this e-mail. You should carry out your own virus

checks before opening the e-mail or attachment. Infosys reserves the right

to monitor and review the content of all messages sent to or from this

e-mail address. Messages sent to or from this e-mail address may be stored

on the Infosys e-mail system.

> ***INFOSYS End of Disclaimer INFOSYS***

>   

 

 

-

To unsubscribe, e-mail: [EMAIL PROTECTED]

For additional commands, e-mail: [EMAIL PROTECTED]

 

 

-

To unsubscribe, e-mail: [EMAIL PROTECTED]

For additional commands, e-mail: [EMAIL PROTECTED]

 

 

-

To unsubscribe, e-mail: [EMAIL PROTECTED]

For additional commands, e-mail: [EMAIL PROTECTED]

 

 

 

 

-

To unsubscribe, e-mail: [EMAIL PROTECTED]

For additional commands, e-mail: [EMAIL PROTECTED]

 



RE: Concurrent Users-Please Help!

2006-09-04 Thread Vagula
Hi All,

I'm using PB API. When concurrent threads are running on a particular 
object, the data
gets corrupted.

Let say Thread1 sends data 1,2,3,4
 Thread2 sends data 5,6,7,8

In the DB data stored is 1,2,5,6.

How can I solve this issue? 
Please Help!! Urgently need solution!!

Thanks in Advance!
Regards,
Vagula 
 

-Original Message-
From: Vagula [mailto:[EMAIL PROTECTED] 
Sent: Sunday, September 03, 2006 11:55 AM
To: OJB Users List
Subject: RE: Concurrent Users

Hi,

Yes I need info about concurrent connections. What are the settings to 
be in OJB.properties? 

Thanks! 

Regards,
Vagula 
 

-Original Message-
From: Antonio Gallardo [mailto:[EMAIL PROTECTED] 
Sent: Friday, September 01, 2006 8:25 PM
To: OJB Users List
Subject: Re: Concurrent Users

Hi Vagula,

Would you explain more your idea? If you are talking about concurrent 
connections to the database, OJB has database connection pool, which can 
be configured in the OJB.properties.

Best Regards,

Antonio Gallardo.

Vagula escribió:
> Hi All,
>
>
>
> How can I handle concurrent users using OJB?
>
>
>
> TIA.
>
>
>
> Regards,
>
> Vagula
>
>
>
> It may be more worthwhile, to find out what is right than-who is right.
>
>
>
>
>
>
>
>  CAUTION - Disclaimer *
> This e-mail contains PRIVILEGED AND CONFIDENTIAL INFORMATION intended solely 
> for the use of the addressee(s). If you are not the intended recipient, 
> please notify the sender by e-mail and delete the original message. Further, 
> you are not to copy, disclose, or distribute this e-mail or its contents to 
> any other person and any such actions are unlawful. This e-mail may contain 
> viruses. Infosys has taken every reasonable precaution to minimize this risk, 
> but is not liable for any damage you may sustain as a result of any virus in 
> this e-mail. You should carry out your own virus checks before opening the 
> e-mail or attachment. Infosys reserves the right to monitor and review the 
> content of all messages sent to or from this e-mail address. Messages sent to 
> or from this e-mail address may be stored on the Infosys e-mail system.
> ***INFOSYS End of Disclaimer INFOSYS***
>   


-
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]


-
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]


-
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]



RE: Concurrent Users

2006-09-02 Thread Vagula
Hi,

Yes I need info about concurrent connections. What are the settings to 
be in OJB.properties? 

Thanks! 

Regards,
Vagula 
 

-Original Message-
From: Antonio Gallardo [mailto:[EMAIL PROTECTED] 
Sent: Friday, September 01, 2006 8:25 PM
To: OJB Users List
Subject: Re: Concurrent Users

Hi Vagula,

Would you explain more your idea? If you are talking about concurrent 
connections to the database, OJB has database connection pool, which can 
be configured in the OJB.properties.

Best Regards,

Antonio Gallardo.

Vagula escribió:
> Hi All,
>
>
>
> How can I handle concurrent users using OJB?
>
>
>
> TIA.
>
>
>
> Regards,
>
> Vagula
>
>
>
> It may be more worthwhile, to find out what is right than-who is right.
>
>
>
>
>
>
>
>  CAUTION - Disclaimer *
> This e-mail contains PRIVILEGED AND CONFIDENTIAL INFORMATION intended solely 
> for the use of the addressee(s). If you are not the intended recipient, 
> please notify the sender by e-mail and delete the original message. Further, 
> you are not to copy, disclose, or distribute this e-mail or its contents to 
> any other person and any such actions are unlawful. This e-mail may contain 
> viruses. Infosys has taken every reasonable precaution to minimize this risk, 
> but is not liable for any damage you may sustain as a result of any virus in 
> this e-mail. You should carry out your own virus checks before opening the 
> e-mail or attachment. Infosys reserves the right to monitor and review the 
> content of all messages sent to or from this e-mail address. Messages sent to 
> or from this e-mail address may be stored on the Infosys e-mail system.
> ***INFOSYS End of Disclaimer INFOSYS***
>   


-
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]


-
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]



Concurrent Users

2006-08-31 Thread Vagula

Hi All,



How can I handle concurrent users using OJB?

   

TIA.



Regards,

Vagula



It may be more worthwhile, to find out what is right than-who is right.







 CAUTION - Disclaimer *
This e-mail contains PRIVILEGED AND CONFIDENTIAL INFORMATION intended solely 
for the use of the addressee(s). If you are not the intended recipient, please 
notify the sender by e-mail and delete the original message. Further, you are 
not to copy, disclose, or distribute this e-mail or its contents to any other 
person and any such actions are unlawful. This e-mail may contain viruses. 
Infosys has taken every reasonable precaution to minimize this risk, but is not 
liable for any damage you may sustain as a result of any virus in this e-mail. 
You should carry out your own virus checks before opening the e-mail or 
attachment. Infosys reserves the right to monitor and review the content of all 
messages sent to or from this e-mail address. Messages sent to or from this 
e-mail address may be stored on the Infosys e-mail system.
***INFOSYS End of Disclaimer INFOSYS***

RE: Order By not working!

2006-03-29 Thread Vagula
Hi,

 

Even after using addOrderByAscending(),addOrderBydesending()
the sorting of data is not working.

 

The repository user xml mapping is as follows:

 



 



 



 



 



 



 



 



 











 

 

We are querying on this table sorting by the entity acronym
field. 



java version : jdk 1.4 

OJB version : 1.0

error messages : none. Only data not sorted

 

 

Please Help!

Very urgently needed.  

 



Thanks and Regards,

Vagula 

 

-Original Message-
From: Danilo Tommasina [mailto:[EMAIL PROTECTED] 
Sent: Tuesday, March 21, 2006 4:42 PM
To: OJB Users List
Subject: Re: Order By not working!

 

Hi,

 

Criteria.addOrderBy(...) is deprecated, you should use the
addOrderByAscending(...) or addOrderByDescending(...) on the
QueryByCriteria instance.

 

If this does not work, please provide more information, java version,
OJB version, error messages, repository XML definition for the table,
table DDL or anthing 

that could be helpful to figure out what the problem is.

 

bye

danilo

 

> Hi,

> 

> 

> 

> The following query is not working for wild character
search

> (%, ?,  *)

> 

>

> 

> criteria.addLike("UPPER(ACRONYM)

> ",entityAcronym.trim().toUpperCase());

> 

> criteria.addOrderBy("entityAcronym");

> 

> query = new QueryByCriteria(EntityData.class,

> criteria);  

> 

> 

> 

> entityAcronym: can either be simple string or any of the wild
characters

> 

> 

> 

> 

> This is an urgent requirement.

> 

> 

> 

> Please Help!

> 

> 

> 

> Thanks and Regards,

> 

> Vagula

> 

> 

> 

> 

> 

> 

> 

>  CAUTION - Disclaimer *

> This e-mail contains PRIVILEGED AND CONFIDENTIAL INFORMATION intended
solely for the use of the addressee(s). If you are not the intended
recipient, please notify the sender by e-mail and delete the original
message. Further, you are not to copy, disclose, or distribute this
e-mail or its contents to any other person and any such actions are
unlawful. This e-mail may contain viruses. Infosys has taken every
reasonable precaution to minimize this risk, but is not liable for any
damage you may sustain as a result of any virus in this e-mail. You
should carry out your own virus checks before opening the e-mail or
attachment. Infosys reserves the right to monitor and review the content
of all messages sent to or from this e-mail address. Messages sent to or
from this e-mail address may be stored on the Infosys e-mail system.

> ***INFOSYS End of Disclaimer INFOSYS***

 

-

To unsubscribe, e-mail: [EMAIL PROTECTED]

For additional commands, e-mail: [EMAIL PROTECTED]

 



Order By not working!

2006-03-20 Thread Vagula

Hi,



The following query is not working for wild character search
(%, ?,  *)

   

criteria.addLike("UPPER(ACRONYM)
",entityAcronym.trim().toUpperCase());

criteria.addOrderBy("entityAcronym");

query = new QueryByCriteria(EntityData.class,
criteria);  



entityAcronym: can either be simple string or any of the wild characters




This is an urgent requirement.



Please Help!



Thanks and Regards,

Vagula







 CAUTION - Disclaimer *
This e-mail contains PRIVILEGED AND CONFIDENTIAL INFORMATION intended solely 
for the use of the addressee(s). If you are not the intended recipient, please 
notify the sender by e-mail and delete the original message. Further, you are 
not to copy, disclose, or distribute this e-mail or its contents to any other 
person and any such actions are unlawful. This e-mail may contain viruses. 
Infosys has taken every reasonable precaution to minimize this risk, but is not 
liable for any damage you may sustain as a result of any virus in this e-mail. 
You should carry out your own virus checks before opening the e-mail or 
attachment. Infosys reserves the right to monitor and review the content of all 
messages sent to or from this e-mail address. Messages sent to or from this 
e-mail address may be stored on the Infosys e-mail system.
***INFOSYS End of Disclaimer INFOSYS***

remove all references.

2006-03-08 Thread Vagula

Hi All,



I have a table A which references tables B & C.

The auto-retrieve of B & C has been set to true.

While I retrieve a record from table A can I some how stop
the auto-retrieval of B & C.

   





Thanks and Regards,

Vagula







 CAUTION - Disclaimer *
This e-mail contains PRIVILEGED AND CONFIDENTIAL INFORMATION intended solely 
for the use of the addressee(s). If you are not the intended recipient, please 
notify the sender by e-mail and delete the original message. Further, you are 
not to copy, disclose, or distribute this e-mail or its contents to any other 
person and any such actions are unlawful. This e-mail may contain viruses. 
Infosys has taken every reasonable precaution to minimize this risk, but is not 
liable for any damage you may sustain as a result of any virus in this e-mail. 
You should carry out your own virus checks before opening the e-mail or 
attachment. Infosys reserves the right to monitor and review the content of all 
messages sent to or from this e-mail address. Messages sent to or from this 
e-mail address may be stored on the Infosys e-mail system.
***INFOSYS End of Disclaimer INFOSYS***

RE: Problem in retrieving data

2006-02-03 Thread Vagula
Hi,

 
After the insert transaction is committed, I try to read the
same record.

Actually it's like this:

In for loop 

I check to see if there is
Record for a particular
combination (let's say record for name="A"). 

< TRANSACTION 2 BEGIN>
If the record does not
exist I insert the record
(with name="A").
< TRANSACTION 2 END>

When the I come across same
combination and check if r  record
exists (with name="A"),
A null record is returned.  
    < TRANSACTION 1 END>

 
Regards,
Vagula 
 
-Original Message-
From: Armin Waibel [mailto:[EMAIL PROTECTED] 
Sent: Friday, February 03, 2006 7:43 PM
To: OJB Users List
Subject: Re: Problem in retrieving data

Hi Vagula,

 > I insert a record (if the record does not exists for a particular
 > combination) into a table in a (broker) transaction and try to access
 > the same record in a different (broker) transaction.

Could you give us more details.
OJB version?
Did the second broker instance try to read the record before the first 
broker commits?

regards,
Armin

Vagula wrote:
> Hi,
> 
> 
> 
> 
> 
> 
> 
> I'm facing a problem.
> 
> 
> 
> 
> 
> The problem description is as follows:
> 
> 
> 
> 
> I insert a record (if the record does not exists for a particular
> combination) into a table in a (broker) transaction and try to access
> the same record in a different (broker) transaction.
> 
> 
> 
> 
> Though the record gets inserted in
> the physical database, OJB is not retrieving the record.
> 
> 
> 
> 
> 
> When I stop the server and run the
> application again the data is retrieved.
> 
> 
> 
> 
> 
> The sequence:
> 
>
> 
> 
> INSERT > RETREIVE data
> is not working.
> 
> 
> 
> 
> RETREIVE data is
working
> 
> 
> 
> 
>
> 
> 
>
> 
> 
> Please Help!!!
> 
> 
> 
> 
> 
> 
> 
> 
> 
> TIA,
> 
> Vagula
> 
> 
> 
> 
> 
> 
> 
> 
> 
> 
>  CAUTION - Disclaimer *
> This e-mail contains PRIVILEGED AND CONFIDENTIAL INFORMATION intended
solely for the use of the addressee(s). If you are not the intended
recipient, please notify the sender by e-mail and delete the original
message. Further, you are not to copy, disclose, or distribute this
e-mail or its contents to any other person and any such actions are
unlawful. This e-mail may contain viruses. Infosys has taken every
reasonable precaution to minimize this risk, but is not liable for any
damage you may sustain as a result of any virus in this e-mail. You
should carry out your own virus checks before opening the e-mail or
attachment. Infosys reserves the right to monitor and review the content
of all messages sent to or from this e-mail address. Messages sent to or
from this e-mail address may be stored on the Infosys e-mail system.
> ***INFOSYS End of Disclaimer INFOSYS***

-
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]


-
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]



Problem in retrieving data

2006-02-03 Thread Vagula

Hi,





I'm facing a problem.



The problem description is as follows:



I insert a record (if the record does not exists for a particular
combination) into a table in a (broker) transaction and try to access
the same record in a different (broker) transaction.



Though the record gets inserted in
the physical database, OJB is not retrieving the record.




When I stop the server and run the
application again the data is retrieved.



The sequence:

   

INSERT > RETREIVE data
is not working.



RETREIVE data is working



   

   

Please Help!!!







TIA,

Vagula







 CAUTION - Disclaimer *
This e-mail contains PRIVILEGED AND CONFIDENTIAL INFORMATION intended solely 
for the use of the addressee(s). If you are not the intended recipient, please 
notify the sender by e-mail and delete the original message. Further, you are 
not to copy, disclose, or distribute this e-mail or its contents to any other 
person and any such actions are unlawful. This e-mail may contain viruses. 
Infosys has taken every reasonable precaution to minimize this risk, but is not 
liable for any damage you may sustain as a result of any virus in this e-mail. 
You should carry out your own virus checks before opening the e-mail or 
attachment. Infosys reserves the right to monitor and review the content of all 
messages sent to or from this e-mail address. Messages sent to or from this 
e-mail address may be stored on the Infosys e-mail system.
***INFOSYS End of Disclaimer INFOSYS***

identity column !! Please Help!!

2005-05-12 Thread Vagula
Hi All,

I have an identity column in my database.

Lets day for example in Activity table we have identity
column act_code.

What are the steps I should be following?

Please Help

TIA

 

Regards,

Vagula