MS SQL Server and JDBC

[CH]

I'm in the process of developing an intranet site that will use ASP on the
front end, Java Objects as the "middle tier" to retrieve/save/manipulate
data, and SQLServer 7.0 as the backend database. All running on NT 4.0 with
IIS 4.0. I am experienced in working with Oracle 8i and JSP, not with SQLServer
7.0 and ASP, so forgive me if this question is somewhat dumb.

Since Oracle comes with it's own JVM, JDBC driver, and Transaction Server,
a programmer is NOT required to develop multi-threaded capable Java objects
to call/save data back to Oracle. Oracle handled all that behind the scenes.
I will be purchasing a Type IV JDBC driver in the near future. What I am
NOT clear on is whether I will need to develop my Java objects as multi-threaded
capable objects, around my Type IV JDBC driver, or can I find some Type IV
drivers for SQLServer that will relieve me of having to do this, as Oracle
does. Thanks in advance for any advice/insight into this subject.

[gg]

As long as you are using any application server feel free to develop java
objects single threaded. but if this is not the scenario and no corba involvement
your java objects must be multi threaded.

Question: Why are you using ASP while you are using JAVA technology on your
middle tier and server side?

[CH]

"gg" <ggggg@ggggg.com> wrote:
>
>As long as you are using any application server feel free to develop java
>objects single threaded. but if this is not the scenario and no corba involvement
>your java objects must be multi threaded.
>
>Question: Why are you using ASP while you are using JAVA technology on your
>middle tier and server side?
>
Thank you for you advice. I would much prefer to use JSP, but the client
is insistent on using ASP, mainly because their comfort level is with MS
technologies. The reason we are using Java as the middle tier is that we
will need to "talk" across other platforms in the future, including communication
with some of the manufacturing equipment on the plant floor. There was no
way the MS platform could communicate with his manufactuing equipment, at
least not any way I could think of, nor any way his IT people could think
of either. But much of the new equipment the company is looking at purchasing
has software/drivers written in Java. Therefore, Java was the logical choice
for the middle layer, but convincing the IT department was a monumental task.

One additional question, what exactly do you mean by application server?
Are you referring to Microsoft's Transaction Server (MTS), or are you referring
to MS IIS 4.0? Currently, the company does NOT have a license for MTS, but
we can get one if we need to. Nor were we planning on using CORBA at this
time, this will be straight Java class objects with methods to retrieve and
save data back to the db. The SQLServer database will be residing on a dedicated
NT box running IIS 4.0. The java class objects will also reside on the same
box. In the ASP pages, I will instatiate the Java class objects via the
CreateObject method, and then just access the db via my Java class methods.

[gg]

How do you access java objects through your ASP pages?

MTS is microsoft type of application server but an application server
for java technology is deff. like IBM websphere, BEA weblogic and many more.
while IIS or apache and other like this are HTTP servers.

[Mark]

I would agree. MS is different. Part of IIS is the HTTP server and part
of IIS would be like the Application server. Combine that with MTS and you
get some sort of application server.


"gg" <gggg@gggg.com> wrote:
>
>How do you access java objects through your ASP pages?
>
> MTS is microsoft type of application server but an application server
>for java technology is deff. like IBM websphere, BEA weblogic and many more.
>while IIS or apache and other like this are HTTP servers.
>
>

[Justin Campbell]

"gg" <gggg@gggg.com> wrote:
>
>How do you access java objects through your ASP pages?
>
> MTS is microsoft type of application server but an application server
>for java technology is deff. like IBM websphere, BEA weblogic and many more.
>while IIS or apache and other like this are HTTP servers.
>
>

I am ashamed to admit it, but I can say from experience that Java objects
are instantiable from ASP pages via the CreateObject method. We were using
a combination of IIS and MTS, but I am unsure as to the degree of necessity
of MTS when not using VB WebClasses in conjunction with your Java objects.
Undoubtedly Microsoft will have some horrendously vague answer for you on
that one.

Best of luck!

- Justin