JDO help

[PLUCKYHD]

Anyone have any experience or knowledge of JDO? I am trying to read up on it but it is allot to follow for me a this point. If you do and would like to help me I would much appreciate it. Or if someone has a better/alternate to JDO that would be greatly appreciated as well.

Basically I am building custom mediaobjecst from a java class and I would like to store those objects and be able to modify/query that database of objects so I don't have to rebuild them over and over again. I was originally going to store them in SQL but can't seem to find an easy way to do that with MS SQL which is what I have to use.

cheers and TIA

[stuckless]

plucky... unfortunately, i've used every data persistence engine known to mankind, including writing a number of domain specic ones myself I can tell you that there is no holy grail of database persistence

JDO is ok, and i've acutllay used it a couple times for larger projects. Personally I like hibernate better. But other JDO and Hibernate add in so much more complexity and overhead that using for smaller projects hasn't been beneficial.

Next is ibatis, which isn't bad, but it's meant to be a means of storing your sql code outside the java code. I've only played with this one, but it seems ok. Probably more geared towards using spring in conjunction with it.

For really small projects (less than 20 tables), i'd probably use dbutils. It's not a framework at all. It just provides some utilities that make working with the db a little nicer. In the past, i've used this build my own domain specific db framework. It's work taking a look at it, since you can use it to easily create/execute insert statements, or interate over results, etc. It does have some very simple object/bean mapping capabilities as well.

For phoenix, i'm probably just going to use dbutils.

[stuckless]

One other note... I've also looked at JaQu (from the h2 project). It's ok for simple things as well. I didn't like it because it forces you to extend their objects... I'd prefer a framework that simply deal with my beans.

[PLUCKYHD]

Sean,

Thanks for the pointers I may use dbutils in the future. After reading and racking my brain as hard as I can I figured a way around this without using another database outside the Microsoft sql database. It seems to be working pretty well in my testing so I am hoping all is good with it.

Thanks for the advice and pointers as always this continues to be one big learning curve