Databases & beans

Visit us here and  you will find

much more tips!

Receive our  newsletter with new tips!  Almost 6,000 subscribers (by June 2001) can not be wrong! 

They read our tips every week! 

 To subscribe to The Java FAQ Daily send empty e mail to:

javafaq tips subscribe@topica.com

  or visit at:

http://www.topica.com/lists/javafaq tips/

 Databases & beans

 Q: Anybody does know a freeware JDBC driver for a dsn less connection to MS

SQL Server? Would even consider a "cheapware" version.

Answer: Go to http://industry.java.sun.com/products/jdbc/drivers and search for

Microsoft SQL Server. Any Type4 (i.e. pure Java) driver should work without a DSN.

The only free one I m aware of is at http://www.freetds.org   but it is rather limited in

what it can do. You d need to try it out to see whether it fits your requirements.

Stefan

P.S. DSN   Data Source Name

 Q: I just want to know which programs and virtual machines you have to have to

make and run enterprise java beans...

Answer: To compile and run Enterprise JavaBeans, you need a couple of things.

First, you need the J2EE SDK. This kit includes APIs full of packages which are

considered extensions to the standard Java language APIs, as well as other tools,

which come with the J2SE SDK, which you should already have. Install the SDK and

make sure its jar file is in your development environment s classpath.

Second, you need a container, which in this case you can also refer to as an

application server, though technically a container is just one part of the server. The

container acts as a liaison between the client object and the Enterprise JavaBean.

When you talk to an Enterprise JavaBean, you actually talk to a proxy (a substitute),

and the proxy, which knows how to do networking stuff, talks to the container, which

in turn talks to the actual implementation object which is what you think of when you

think of an Enterprise JavaBean.

The J2EE SDK, fortunately, comes with a server/container, as well as a GUI based

tool which allows you to deploy your Enterprise JavaBeans in the server. See

java.sun.com/j2ee.

Third, you need a lot of patience. The learning curve is rather steep unless you have

file:///F|/a_jsite/350_tips/database_beans.htm (1 of 2) [2001 07 08 11:24:47]