Re: Support for SQL Server JDBC Driver

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

On Jul 21, 9:43 am, Leonidas <Leoni...@xxxxxxxxxxxxxxxxxxxxxxxxx>
wrote:
Dear Friends,

I have following two questions :-

1. What needs to be done to get support if we run into any issues with sql
jdbc driver?Can we contact Microsoft for this if we have a valid MS SQL
Server  2000/2005 license ?

2. Is it possible to communicate with SQL Server 2000/2005 dataserver over
SSL channel even if the dataserver itself is running in Non SSL mode ? Goal
for this is we need to keep the communication channel secured/encrypted with
SSL irrespective of dataserver's mode of operation - SSL/Non SSL.

Thanks in advance for your time and help on this.

Regards,
Leo

I'll let MS folks say anything about support, but clearly, if the DBMS
isn't
speaking SSL, whoever is speaking to the DBMS can't either. The only
way
you can do what you want is to have a middleman process, running on
the
same machine (or at least inside your firewall) that talks SSL/JDBC to/
from
your clients, and uses the actual MS JDBC driver to relay requests and
results to/from the DBMS. This will be slow.
If you want better performance, you should do *all* your JDBC inside
the firewall, close to the DBMS, in a middleware process, and have
your
clients interact with the middleware process in a light-weight
protocol
such as HTTP (which can be HTTPS).
.

Relevant Pages

  • Re: Support for SQL Server JDBC Driver
    ... What needs to be done to get support if we run into any issues with sql ... jdbc driver?Can we contact Microsoft for this if we have a valid MS SQL ... SSL channel even if the dataserver itself is running in Non SSL mode? ... I'll let MS folks say anything about support, but clearly, if the DBMS ...
    (microsoft.public.sqlserver.jdbcdriver)
  • Re: Support for SQL Server JDBC Driver
    ... Support is tied to the version of SQL ... SSL channel even if the dataserver itself is running in Non SSL mode? ... I'll let MS folks say anything about support, but clearly, if the DBMS ...
    (microsoft.public.sqlserver.jdbcdriver)
  • Re: JDBC Driver: Connection reset by peer: socket write error
    ... > and the DBMS, or the DBMS had a failure which required it to ... I reboot the server that hosts both JDBC & the SQL ...
    (microsoft.public.sqlserver.jdbcdriver)
  • Re: JDBC:how to compare char[] and int
    ... The DBMS is Himalaya. ... > longskyhw wrote: ... > JDBC won't help you; it will have to be SQL. ...
    (comp.lang.java.databases)
  • Re: JDBC PreparedStatements, Java Data Objects/O-R mapping, and SQL Injection
    ... "PreparedStatement objects represent SQL statements that can be prepared, ... the MySQL JDBC driver, since it's open source and widely used. ... protection against SQL injection gained by using PreparedStatements, ...
    (SecProg)