You are viewing a plain text version of this content. The canonical link for it is here.
Posted to slide-user@jakarta.apache.org by Doug Harmon <dh...@justice.loyola.edu> on 2003/06/09 15:06:05 UTC

J2EE Store vs JDBC Store

Could someone explain the difference between using a JDBC Store and a J2EE Store?  Under which situations would it be ideal to use a J2EE Store vs a JDBC Store? What are the pros and cons of each type of store? I am mainly interested in using Slide for content management/versioning. 

-doug



---------------------------------------------------------------------
To unsubscribe, e-mail: slide-user-unsubscribe@jakarta.apache.org
For additional commands, e-mail: slide-user-help@jakarta.apache.org


RE: J2EE Store vs JDBC Store

Posted by Kevin Moran <gr...@yahoo.com>.
Jacob,
    Thank you for the practical information!  That
clarifies things quite a bit.  I will definitely test
out the J2EE stores.  The only lingering question I
have is the same one Willie Vu posted recently
regarding transactions
(http://marc.theaimsgroup.com/?l=slide-user&m=105426962022618&w=2).
 Perhaps one of the Slide developers could comment on
that?  Anyway, thanks again for your help.

Best,
-kevin

--- Jacob Lund <jl...@qualiware.com> wrote:
> I believe that the jdbc store does not operate on a
> relative database design
> however there is some rdbmsJDBC somewhere!
> The j2eestore is using a relational database design,
> and is based on the
> XADatasourse and is thereby multithreaded while the
> JDBC connection is
> singelthreaded.
> 
> My tests are showing nice results with 500.000+
> files with slide and
> SQLserver on one machine! The limitation on the
> number of concurrent users
> is increased by the j2ee store!
> 
> I am working on putting some on the standard Meta
> tag into a separate table
> and thereby avoiding a really large properties
> table!
> 
> As I see it the JDBC store should not bee used in
> any kind of production
> environment!
> 
> /Jacob 
> 


__________________________________
Do you Yahoo!?
Yahoo! Calendar - Free online calendar with sync to Outlook(TM).
http://calendar.yahoo.com

---------------------------------------------------------------------
To unsubscribe, e-mail: slide-user-unsubscribe@jakarta.apache.org
For additional commands, e-mail: slide-user-help@jakarta.apache.org


RE: J2EE Store vs JDBC Store

Posted by Jacob Lund <jl...@qualiware.com>.
I believe that the jdbc store does not operate on a relative database design
however there is some rdbmsJDBC somewhere!
The j2eestore is using a relational database design, and is based on the
XADatasourse and is thereby multithreaded while the JDBC connection is
singelthreaded.

My tests are showing nice results with 500.000+ files with slide and
SQLserver on one machine! The limitation on the number of concurrent users
is increased by the j2ee store!

I am working on putting some on the standard Meta tag into a separate table
and thereby avoiding a really large properties table!

As I see it the JDBC store should not bee used in any kind of production
environment!

/Jacob 

-----Original Message-----
From: Kevin Moran [mailto:gridplan@yahoo.com] 
Sent: 11. juni 2003 03:46
To: Slide Users Mailing List
Subject: Re: J2EE Store vs JDBC Store


Hi,
    Can someone please weigh in on this subject?  I'd
like to know too.  Currently I'm using the JDBC store.
 But I'd be interested in knowing if the J2EE stores
are more appropriate if one is using Slide within an
EJB.

TIA,
-kevin

--- Doug Harmon <dh...@justice.loyola.edu> wrote:
> Could someone explain the difference between using a
> JDBC Store and a J2EE Store?  Under which situations
> would it be ideal to use a J2EE Store vs a JDBC
> Store? What are the pros and cons of each type of
> store? I am mainly interested in using Slide for
> content management/versioning.
> 
> -doug
>

__________________________________
Do you Yahoo!?
Yahoo! Calendar - Free online calendar with sync to Outlook(TM).
http://calendar.yahoo.com

---------------------------------------------------------------------
To unsubscribe, e-mail: slide-user-unsubscribe@jakarta.apache.org
For additional commands, e-mail: slide-user-help@jakarta.apache.org


---------------------------------------------------------------------
To unsubscribe, e-mail: slide-user-unsubscribe@jakarta.apache.org
For additional commands, e-mail: slide-user-help@jakarta.apache.org


Re: J2EE Store vs JDBC Store

Posted by Kevin Moran <gr...@yahoo.com>.
Hi,
    Can someone please weigh in on this subject?  I'd
like to know too.  Currently I'm using the JDBC store.
 But I'd be interested in knowing if the J2EE stores
are more appropriate if one is using Slide within an
EJB.

TIA,
-kevin

--- Doug Harmon <dh...@justice.loyola.edu> wrote:
> Could someone explain the difference between using a
> JDBC Store and a J2EE Store?  Under which situations
> would it be ideal to use a J2EE Store vs a JDBC
> Store? What are the pros and cons of each type of
> store? I am mainly interested in using Slide for
> content management/versioning. 
> 
> -doug
>

__________________________________
Do you Yahoo!?
Yahoo! Calendar - Free online calendar with sync to Outlook(TM).
http://calendar.yahoo.com

---------------------------------------------------------------------
To unsubscribe, e-mail: slide-user-unsubscribe@jakarta.apache.org
For additional commands, e-mail: slide-user-help@jakarta.apache.org