Win a copy of Murach's Python Programming this week in the Jython/Python forum!
  • Post Reply Bookmark Topic Watch Topic
  • New Topic

EJB and JDBC-ODBC compliant database?  RSS feed

 
marlon tan
Ranch Hand
Posts: 53
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Hi,
I want to try out EJB, but I don't want to install Oracle or similar resource intensive database. Can I use MS Access instead to try out EJB?
If yes, will it still work if I use VisualAge for Java?
Thanks a lot!
 
mcd
Greenhorn
Posts: 4
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
I've never tried it, but I've heard cloudscape is excellent, and it's cross-platform to boot! Now that's exciting.
As far as Access, I would stay away from it because it's not portable, although it's an outstanding solution for Windows desktop development.
 
Madhu Juneja
Ranch Hand
Posts: 176
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
You can use MS Access. But I am not sure if it will still work in Visual Age. You can also download the j2ee reference implementation. This has got the cloudscape database and very good gui for db operations as well.
Refer : http://www.javaranch.com/ubb/Forum26/HTML/000207.html
for the link.

 
Monty Ireland
Ranch Hand
Posts: 161
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
If you are new to JDBC I would figure out the basic's with ms-access. The odbc/jdbc driver the is bundled with the jdk is very stable. Infact there are some java/odbc/jdbc examples that come bundled with the jdk. A great stand alone DB when you are learning jdbc ver 1.0.
For more advanced jdbc features. I would download CloudScape ver 3.6. A stable db engine with a good tourtial... Avoid using the J2EE version of CloudScape.
As for oracle.... Unless you are an oracle developer and/or friends with one... Stay away from this database...
Learning Time EST. for an average programmer with alittle RDBMS experience.
SQL-92 to learn the basics, a day at most 'SQL in 10 Minutes'
ODBC to learn the basics, a day or two
ACCESS to learn the basics, a day or two
JDBC to learn the basics, a week or two
Cloudscape to learn the basics, a day or two
Oracle to learn the basics, a week or two
Hope This Helps
------------------
Multi-Platform Database Developer ( on E.S.T. )
 
nobody
Greenhorn
Posts: 3
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Haven't tried it but it should work. MS Access just uses the jdbc-odbc bridge. Those classes should already be in the VA repository. Just make sure that you set up a profile with the odbc manager.
Hi,
I want to try out EJB, but I don't want to install Oracle or similar resource intensive database. Can I use MS Access instead to try out EJB?
If yes, will it still work if I use VisualAge for Java?
Thanks a lot!

 
It is sorta covered in the JavaRanch Style Guide.
  • Post Reply Bookmark Topic Watch Topic
  • New Topic
Boost this thread!