Re: Difference b/w Sybase client driver and Weblogic default
drivers

Gopal Allam wrote:

> Joe,
> 
> Thanks for your reply.
> 
> So BEA shipped sybase driver is a BEA developed driver for sybase DB ? I
was under impression that jconn3.jar was obtained from Sybase and shipped with
Weblogic 92MP2.
> 
> Can you please clarify.
> 
> Also, if you could let me know some of the technical differences b/w BEA
shipped drives and Sybase client install - that would really helpful.
> 
> Thanks again
> 
> --agr

The BEA-branded driver is available as weblogic.jdbc.sybase.SybaseDriver, or
the XADataSource analog, and will be one of the dirver class options the
console offers you when creating a Sybase-targetted pool/datasource. I
do not know/have Sybase's latest version of it's jconn3.jar so I can't
compare. If you make a simple connection in a simple standalone
program, you can find the version via:

import java.sql.*;
import java.util.*;

public class jconnect_version
{
   public static void main(String argv[])
     throws Exception
   {
     java.sql.Connection c = null;
     try
     {
       java.util.Properties props = new java.util.Properties();
       props.put("user",     "sa");
       props.put("password", "secret");

       Driver d =
(Driver)Class.forName("com.sybase.jdbc3.jdbc.SybDriver").newInstance()
;
       c = d.connect("jdbc:sybase:Tds:lcw2kdb1:4100", props );

       System.out.println("The driver is " +
c.getMetaData().getDriverVersion() );
     }
     catch (SQLException e)
     {
      e.printStackTrace();
     }
     finally
     {
       try {c.close();}    catch (Exception e) {;}
     }
   }