File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
The moose likes EJB and other Java EE Technologies and the fly likes J2EE Account example with SQL Server Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login

Win a copy of Java Interview Guide this week in the Jobs Discussion forum!
JavaRanch » Java Forums » Java » EJB and other Java EE Technologies
Bookmark "J2EE Account example with SQL Server" Watch "J2EE Account example with SQL Server" New topic

J2EE Account example with SQL Server

Richard Chu

Joined: Apr 17, 2001
Posts: 2
Im trying the J2EE Account example in Windows 2000 server. I don't want to use Cloudscape (because cloudscape is not working in my machine). I'd like to try it in MS SQL Server 2000. I'm thinking just use JDBC-ODBC bridge for testing. How should I configure the J2EE server. If anyone can provide step-by-step instruction, I appreciate it.

Mike Curwen
Ranch Hand

Joined: Feb 20, 2001
Posts: 3695

In your j2sdkee1.2.1 directory, find this document:

In this document (page 2 and 3), are instructions for setting up alternate databases.

Long story short: I tried to use MySQL because Cloudscape wouldn't work. Couldn't get either to work. Then I finally got Cloudscape to work, and went *back* to see if I could 'easily' swap databases. When I followed the instructions in this document, not only would MySQL *still* not work but the *other* applications also failed (the ones still using Cloudscape). So I finally gave up and just used the (now working) Cloudscape.

Note: I finally got Clouscape working by upgrading. Here is the URL for instructions:

Hope that helps. Let us know how you make out with SQLS2k
[This message has been edited by Mike Curwen (edited April 18, 2001).]

Joined: Apr 19, 2001
Posts: 3
i am also trying to run the account example in j2ee with
merant sqlserver driver.
i have set the paths in,,and the bean was deployed successfully..but when i run the give
me Rmi Exception can't create Entity EJB..
what may be the problem?
whether i haven't set the default.properities properly ..
please help
I agree. Here's the link:
subject: J2EE Account example with SQL Server
It's not a secret anymore!