You are viewing a plain text version of this content. The canonical link for it is here.
Posted to ojb-user@db.apache.org by "Hiller, Frank RD-AS2" <Fr...@heidelberg.com> on 2006/09/11 15:23:47 UTC
Support of database views
Short question: I couldn't find a functionality to deal with database
views (create view...) within OJB.
Is there a reason for that?
Is the answer "use ReportQuery".
Thank you,
Frank
Confidentiality note:
The information in this email and any attachment may contain confidential and proprietary information of Heidelberger Druckmaschinen AG and/or its affiliates and may be privileged or otherwise protected from disclosure. If you are not the intended recipient, you are hereby notified that any review, reliance or distribution by others or forwarding without express permission is strictly prohibited and may cause liability. In case you have received this message due to an error in transmission, we kindly ask you to notify the sender immediately and to delete this email and any attachment from your system.
Re: Fetching Identity
Posted by Thomas Dudziak <to...@gmail.com>.
On 9/16/06, sachin@mechsoftgroup.com <sa...@mechsoftgroup.com> wrote:
> I am using MS Sql server 2000 as database server.
> Primary key of table is generated using Identity.
> How can we get currently generated identity?
After saving an object, its field that is mapped to the primary key,
should contain the value.
If you're sure that only one thread accesses the database, then you
could also use Sql Server specific SQL to get the value (via JDBC):
http://www.sqlteam.com/item.asp?ItemID=319
Tom
---------------------------------------------------------------------
To unsubscribe, e-mail: ojb-user-unsubscribe@db.apache.org
For additional commands, e-mail: ojb-user-help@db.apache.org
Fetching Identity
Posted by sa...@mechsoftgroup.com.
Hi,
I am using MS Sql server 2000 as database server.
Primary key of table is generated using Identity.
How can we get currently generated identity?
Thanks in advance.
From,
Sachin
---------------------------------------------------------------------
To unsubscribe, e-mail: ojb-user-unsubscribe@db.apache.org
For additional commands, e-mail: ojb-user-help@db.apache.org
AW: Support of database views
Posted by "Hiller, Frank RD-AS2" <Fr...@heidelberg.com>.
Good idea, works fine.
Thank you..................Frank
-----Ursprüngliche Nachricht-----
Von: Vasily Ivanov [mailto:basil.iv@gmail.com]
Gesendet: Dienstag, 12. September 2006 01:19
An: OJB Users List
Betreff: Re: Support of database views
Hi Frank,
We used to work with views without any issue, just put view's name as "table" attribute in "class-descriptor". However, you will only be able to read objects from that view.
Regards,
Vasily
On 9/11/06, Hiller, Frank RD-AS2 <Fr...@heidelberg.com> wrote:
> Short question: I couldn't find a functionality to deal with database
> views (create view...) within OJB.
> Is there a reason for that?
> Is the answer "use ReportQuery".
>
> Thank you,
> Frank
>
>
>
> Confidentiality note:
> The information in this email and any attachment may contain confidential and proprietary information of Heidelberger Druckmaschinen AG and/or its affiliates and may be privileged or otherwise protected from disclosure. If you are not the intended recipient, you are hereby notified that any review, reliance or distribution by others or forwarding without express permission is strictly prohibited and may cause liability. In case you have received this message due to an error in transmission, we kindly ask you to notify the sender immediately and to delete this email and any attachment from your system.
>
>
---------------------------------------------------------------------
To unsubscribe, e-mail: ojb-user-unsubscribe@db.apache.org
For additional commands, e-mail: ojb-user-help@db.apache.org
---------------------------------------------------------------------
To unsubscribe, e-mail: ojb-user-unsubscribe@db.apache.org
For additional commands, e-mail: ojb-user-help@db.apache.org
AW: Support of database views
Posted by "Hiller, Frank RD-AS2" <Fr...@heidelberg.com>.
Additional information: When I explicitely remove the objects from the brokers internal cache (broker.removeFromCache(obj)) it works.
Is it a bug?
Frank
-----Ursprüngliche Nachricht-----
Von: Hiller, Frank RD-AS2 [mailto:Frank.Hiller@heidelberg.com]
Gesendet: Dienstag, 19. September 2006 13:56
An: OJB Users List
Betreff: AW: Support of database views
Hi Vasily,
using the view as a table (following your recommendation) shows a strange behaviour.
When a field in a table is updated and the matching object returns the correct new value the object related to the view (spanning two tables ) still holds the old value for a long time (minutes).
Have you (or soneome else) ever had such a problem?
Is there something I can configure (in ojb.properties)?
I'm using OJB 1.0.3 with PB api.
Frank
-----Ursprüngliche Nachricht-----
Von: Vasily Ivanov [mailto:basil.iv@gmail.com]
Gesendet: Dienstag, 12. September 2006 01:19
An: OJB Users List
Betreff: Re: Support of database views
Hi Frank,
We used to work with views without any issue, just put view's name as "table" attribute in "class-descriptor". However, you will only be able to read objects from that view.
Regards,
Vasily
On 9/11/06, Hiller, Frank RD-AS2 <Fr...@heidelberg.com> wrote:
> Short question: I couldn't find a functionality to deal with database
> views (create view...) within OJB.
> Is there a reason for that?
> Is the answer "use ReportQuery".
>
> Thank you,
> Frank
>
>
>
> Confidentiality note:
> The information in this email and any attachment may contain confidential and proprietary information of Heidelberger Druckmaschinen AG and/or its affiliates and may be privileged or otherwise protected from disclosure. If you are not the intended recipient, you are hereby notified that any review, reliance or distribution by others or forwarding without express permission is strictly prohibited and may cause liability. In case you have received this message due to an error in transmission, we kindly ask you to notify the sender immediately and to delete this email and any attachment from your system.
>
>
---------------------------------------------------------------------
To unsubscribe, e-mail: ojb-user-unsubscribe@db.apache.org
For additional commands, e-mail: ojb-user-help@db.apache.org
Confidentiality note:
The information in this email and any attachment may contain confidential and proprietary information of Heidelberger Druckmaschinen AG and/or its affiliates and may be privileged or otherwise protected from disclosure. If you are not the intended recipient, you are hereby notified that any review, reliance or distribution by others or forwarding without express permission is strictly prohibited and may cause liability. In case you have received this message due to an error in transmission, we kindly ask you to notify the sender immediately and to delete this email and any attachment from your system.
---------------------------------------------------------------------
To unsubscribe, e-mail: ojb-user-unsubscribe@db.apache.org
For additional commands, e-mail: ojb-user-help@db.apache.org
Confidentiality note:
The information in this email and any attachment may contain confidential and proprietary information of Heidelberger Druckmaschinen AG and/or its affiliates and may be privileged or otherwise protected from disclosure. If you are not the intended recipient, you are hereby notified that any review, reliance or distribution by others or forwarding without express permission is strictly prohibited and may cause liability. In case you have received this message due to an error in transmission, we kindly ask you to notify the sender immediately and to delete this email and any attachment from your system.
---------------------------------------------------------------------
To unsubscribe, e-mail: ojb-user-unsubscribe@db.apache.org
For additional commands, e-mail: ojb-user-help@db.apache.org
AW: Support of database views
Posted by "Hiller, Frank RD-AS2" <Fr...@heidelberg.com>.
Hi Vasily,
using the view as a table (following your recommendation) shows a strange behaviour.
When a field in a table is updated and the matching object returns the correct new value the object related to the view (spanning two tables ) still holds the old value for a long time (minutes).
Have you (or soneome else) ever had such a problem?
Is there something I can configure (in ojb.properties)?
I'm using OJB 1.0.3 with PB api.
Frank
-----Ursprüngliche Nachricht-----
Von: Vasily Ivanov [mailto:basil.iv@gmail.com]
Gesendet: Dienstag, 12. September 2006 01:19
An: OJB Users List
Betreff: Re: Support of database views
Hi Frank,
We used to work with views without any issue, just put view's name as "table" attribute in "class-descriptor". However, you will only be able to read objects from that view.
Regards,
Vasily
On 9/11/06, Hiller, Frank RD-AS2 <Fr...@heidelberg.com> wrote:
> Short question: I couldn't find a functionality to deal with database
> views (create view...) within OJB.
> Is there a reason for that?
> Is the answer "use ReportQuery".
>
> Thank you,
> Frank
>
>
>
> Confidentiality note:
> The information in this email and any attachment may contain confidential and proprietary information of Heidelberger Druckmaschinen AG and/or its affiliates and may be privileged or otherwise protected from disclosure. If you are not the intended recipient, you are hereby notified that any review, reliance or distribution by others or forwarding without express permission is strictly prohibited and may cause liability. In case you have received this message due to an error in transmission, we kindly ask you to notify the sender immediately and to delete this email and any attachment from your system.
>
>
---------------------------------------------------------------------
To unsubscribe, e-mail: ojb-user-unsubscribe@db.apache.org
For additional commands, e-mail: ojb-user-help@db.apache.org
Confidentiality note:
The information in this email and any attachment may contain confidential and proprietary information of Heidelberger Druckmaschinen AG and/or its affiliates and may be privileged or otherwise protected from disclosure. If you are not the intended recipient, you are hereby notified that any review, reliance or distribution by others or forwarding without express permission is strictly prohibited and may cause liability. In case you have received this message due to an error in transmission, we kindly ask you to notify the sender immediately and to delete this email and any attachment from your system.
---------------------------------------------------------------------
To unsubscribe, e-mail: ojb-user-unsubscribe@db.apache.org
For additional commands, e-mail: ojb-user-help@db.apache.org
Re: Support of database views
Posted by Vasily Ivanov <ba...@gmail.com>.
Hi Frank,
We used to work with views without any issue, just put view's name as
"table" attribute in "class-descriptor". However, you will only be
able to read objects from that view.
Regards,
Vasily
On 9/11/06, Hiller, Frank RD-AS2 <Fr...@heidelberg.com> wrote:
> Short question: I couldn't find a functionality to deal with database
> views (create view...) within OJB.
> Is there a reason for that?
> Is the answer "use ReportQuery".
>
> Thank you,
> Frank
>
>
>
> Confidentiality note:
> The information in this email and any attachment may contain confidential and proprietary information of Heidelberger Druckmaschinen AG and/or its affiliates and may be privileged or otherwise protected from disclosure. If you are not the intended recipient, you are hereby notified that any review, reliance or distribution by others or forwarding without express permission is strictly prohibited and may cause liability. In case you have received this message due to an error in transmission, we kindly ask you to notify the sender immediately and to delete this email and any attachment from your system.
>
>
---------------------------------------------------------------------
To unsubscribe, e-mail: ojb-user-unsubscribe@db.apache.org
For additional commands, e-mail: ojb-user-help@db.apache.org