MS SQL Server and JDBC


DevX Home    Today's Headlines   Articles Archive   Tip Bank   Forums   

Results 1 to 6 of 6

Thread: MS SQL Server and JDBC

  1. #1
    CH Guest

    MS SQL Server and JDBC


    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.






  2. #2
    gg Guest

    Re: MS SQL Server and JDBC


    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?


  3. #3
    CH Guest

    Re: MS SQL Server and JDBC


    "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.



  4. #4
    gg Guest

    Re: MS SQL Server and JDBC


    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.



  5. #5
    Mark Guest

    Re: MS SQL Server and JDBC


    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.
    >
    >



  6. #6
    Justin Campbell Guest

    Re: MS SQL Server and JDBC


    "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

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
HTML5 Development Center
 
 
FAQ
Latest Articles
Java
.NET
XML
Database
Enterprise
Questions? Contact us.
C++
Web Development
Wireless
Latest Tips
Open Source


   Development Centers

   -- Android Development Center
   -- Cloud Development Project Center
   -- HTML5 Development Center
   -- Windows Mobile Development Center