Hi Ben

BEN BOOKEY wrote:
Dear List,

I am not sure if this is the correct email address to post but here
goes.
no problem!

In my company we are deciding on what technology to use for a web based database entry tool. The application will store simple text in most cases, but there is also a picture (BLOB) as well. This will be a multi-user application, and should consider other changes made by others i.e. CREATE, READ ,UPDATE, and DELETE. i.e. a normal OLTP system. Perhaps someone could send a sample project which works with ORACLE or another DB ?

Good books covering STruts + OJB. Both contain sample projects ready for download:
<li>


<a href="http://www.amazon.com/exec/obidos/ASIN/0596003285/qid=1054656123/sr=2-1/ref=sr_2_1/103-9325116-6675068";>
The O'Reilly book on Struts programming by Chuck Cavaness has a
whole chapter about how to build an applications model layers based on OJB.
A must reading for everyone intending to use Struts and OJB.
</a>
All source code from the book can be found here:
<a href="http://examples.oreilly.com/jakarta/";>
Struts Programming sources.
</a>


</li>

<li>

<a href="http://www.amazon.com/exec/obidos/tg/detail/-/1861007817/qid=1054655953/sr=8-1/ref=sr_8_1/103-9325116-6675068?v=glance&s=books&n=507846";>
There's also a WROX book on Struts + OJB
</a>
All source code from the book can be found here:
<a href="http://web.wrox.com/download/code/professional/7817.zip";>
Professional Struts and OJB sources.
</a>


</li>


Somehow we have come up with the idea to do this using Apache Tomcat JDO (Apache OJB came to our attention)for data persistance Struts.

We want to deploy to  MySQL, Oracle and perhaps even later DB2.
Hopefully there will be no issues with this app. when using OJB(JDO
uses primative JDBC to accomplish this DB portability is this the
same with all JDO)

JDO is a generic persistence API. There are Implementations based on Object databases and tools like OJB that provide an O/R mapping.


OJB works good with MySql, Oracle, DB2 (and many more)


There are 2 developers who can work on this, and we have been told we should be finnished in 3 months..

I realise that this is still release candidate, but should we use OJB
or can someone recomend another free SUN JDO implementation?

There are no major issues with the current RC3. A lot of people use it in production evironments.


But there is an issue that you should be aware of. The OJB JDO implementation is not a standalone solution, but requires the SUN JDO Reference Implementation as the toplevel implementation.
Unfortunately the license for the JDO RI does not allow to use it in commercial applications (If I got the licence right, IANAL ;-))


I know there are other OSS JDO projects, like TJDO and XORM.
But I don't know much about them.

I do not
mean to insult anyone in this group, it would be great to get some
honest practial experience from commercial project developers who
have implemented this.


There are lots of people sucessfully using Struts + OJB! There are even two books available that cover these tool and that will help you a lot in properly designing your application.


But most of these user don't use the OJB JDO personality, but the simple PersistenceBroker API, or the more sophisticated ODMG personality.

I hope these lines will help you to make your decision.

cheers,
Thomas



Kind regards


Ben Bookey,




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



Reply via email to