JDBC Drivers


DevX Home    Today's Headlines   Articles Archive   Tip Bank   Forums   

Results 1 to 3 of 3

Thread: JDBC Drivers

Hybrid View

  1. #1
    Eric Ries Guest

    JDBC Drivers


    I'm looking for a JDBC MS SQL Server driver type 4. I will also have the
    need to connect to other servers such as Oracle, Sybase, DB2 in the future.
    Our application is Internet Based, but the back-end database will reside
    at the customer site. I do not really want to load software on the client
    and or the back-end database server, that is why I'm looking at type 4 drivers.
    Any suggestions on Vendors/implementation would be greatly appreciated!

    ...Eric

  2. #2
    Dan Adamson Guest

    Re: JDBC Drivers


    "Eric Ries" <eries@sagencesystems.com> wrote:
    >
    >I'm looking for a JDBC MS SQL Server driver type 4.


    Try i-net Una driver, from i-net software.
    http://www.inetsoftware.de/

    >I will also have the
    >need to connect to other servers such as Oracle, Sybase, DB2 in the future.


    The Una Driver can do that for Oracle and Sybase, not sure about DB2. Why
    do you use so many different ones? You should pick a database system and
    use that.

    > Our application is Internet Based, but the back-end database will reside
    >at the customer site. I do not really want to load software on the client
    >and or the back-end database server, that is why I'm looking at type 4 drivers.
    > Any suggestions on Vendors/implementation would be greatly appreciated!


    OK... now it gets complicated. When you talk about Internet-based, I hope
    you don't mean you're using an applet. If you must use JDBC on the web, it
    can be a real headache, and can open up a big security hole. Java applications
    are another story. As long as you can figure out the path to your server,
    JDBC access from a Java application is easy. However, if you really don't
    want to load any software (meaning no applets or applications) on other computers,
    and want your database to be accessible from the web, then you need to use
    Java Server Pages. You will not have the same security problems with JSP,
    (similar issues to applications). I have done this stuff in our company,
    so if you have some specific questions, let me know

    /*********************************************
    Have a great day
    Dan Adamson dan.adamson@wallst.com

    "Not to end a sentence with a preposition is a
    rule, up with which, I do not intend to put!"
    Winston Churchill
    **********************************************/




  3. #3
    Arun Rajanala Guest

    Re: JDBC Drivers


    In addition to inet for SQL server we use OracleThin for Oracle and JConnect
    for Sybase.

    -Arun

    "Dan Adamson" <dna_man@yahoo.com> wrote:
    >
    >"Eric Ries" <eries@sagencesystems.com> wrote:
    >>
    >>I'm looking for a JDBC MS SQL Server driver type 4.

    >
    >Try i-net Una driver, from i-net software.
    >http://www.inetsoftware.de/
    >
    >>I will also have the
    >>need to connect to other servers such as Oracle, Sybase, DB2 in the future.

    >
    >The Una Driver can do that for Oracle and Sybase, not sure about DB2. Why
    >do you use so many different ones? You should pick a database system and
    >use that.
    >
    >> Our application is Internet Based, but the back-end database will reside
    >>at the customer site. I do not really want to load software on the client
    >>and or the back-end database server, that is why I'm looking at type 4

    drivers.
    >> Any suggestions on Vendors/implementation would be greatly appreciated!

    >
    >OK... now it gets complicated. When you talk about Internet-based, I hope
    >you don't mean you're using an applet. If you must use JDBC on the web,

    it
    >can be a real headache, and can open up a big security hole. Java applications
    >are another story. As long as you can figure out the path to your server,
    >JDBC access from a Java application is easy. However, if you really don't
    >want to load any software (meaning no applets or applications) on other

    computers,
    >and want your database to be accessible from the web, then you need to use
    >Java Server Pages. You will not have the same security problems with JSP,
    >(similar issues to applications). I have done this stuff in our company,
    >so if you have some specific questions, let me know
    >
    >/*********************************************
    > Have a great day
    >Dan Adamson dan.adamson@wallst.com
    >
    >"Not to end a sentence with a preposition is a
    >rule, up with which, I do not intend to put!"
    > Winston Churchill
    >**********************************************/
    >
    >
    >



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