java-sybase JDBC Connection

Hi All,

One of employee wrote java code and left now. I am just learning java and trying to figure out the applications he wrote. Well, it is a small company.. so I am the only one to figure out all this..

Anywayz,
I am connecting from JAVA to Sybase using jdbc drivers (jconn2.jar)..(not sure what version of jConnect is it..)

env. is  solaris 5.8

and I am getting famous JDBC exception,

java.sql.SQLException: JZ0SJ: Metadata accessor information was not found on this database. Please install the required tables as mentioned in the jConnect documentation.


I don't know how to resolve?

Can somebody pls help me..

well.. I am not sure..

But I am getting this error in some servers.. not all..

May be some servers have different configuration from others.. I don't know..

But I see this error in mails in some servers..

Below is method..
public void dbConnectionDsl() throws Exception {
try {
 SybDriver sybDriver = (SybDriver)
Class.forName(SYBASE_STR).newInstance();
sybDriver.setVersion(com.sybase.jdbcx.SybDriver.VERSION_5);
DriverManager.registerDriver(sybDriver);
m_connection = DriverManager.getConnection (
LOCAL_STR, LOCAL_USR, "");
m_connection.setAutoCommit(false);

} catch(SQLException ex){
      System.out.println("Exception: "+ex);
}
}


Even,

I don't know why,

but
I wrote just a test class

package DslCommon.Util;

import java.util.*;
import java.io.*;
import java.net.*;
import java.sql.*;                     // Package for JDBC classes
import com.sybase.jdbcx.*;             // Package for Sybase JDBC drivers



public class TestBean {

public static final String PORT_SYBASE = "2025";
public static final String LOCAL_STR1 = "jdbc:sybase:Tds:";
public static final String LOCAL_STR2 = ":" + PORT_SYBASE;
public static final String SYBASE_STR = "com.sybase.jdbc2.jdbc.SybDriver";
static Connection m_connection = null;  // Database connection object


public static  String LOCAL_STR = LOCAL_STR1+"10"+"."+"2"+"."+"25"+"."+"95"+LOCAL_STR2;
public static final String LOCAL_USR = "sa";


public static void main(String args[]) {


       try {



// Load the Sybase JDBC Driver and register it.
      SybDriver sybDriver = (SybDriver)
            Class.forName(SYBASE_STR).newInstance();

      sybDriver.setVersion(com.sybase.jdbcx.SybDriver.VERSION_5);

      DriverManager.registerDriver(sybDriver);
      m_connection = DriverManager.getConnection (
            LOCAL_STR, LOCAL_USR, ""); // Gets the database connection

      // Sets the auto-commit property for the connection to be false.
      // By default it is true.
      m_connection.setAutoCommit(false);

} catch(Exception ex){ // Trap SQL errors
      System.out.println("SybaseQuery: dbConnectionDsl: Connect to Dsl Exception: "+ex);
}

}

}




I was able to compile in one solaris box..
but got the below error in other solaris box

DslCommon/Util/TestBean.java:7: Package com.sybase.jdbcx not found in import.
import com.sybase.jdbcx.*;              // Package for Sybase JDBC drivers
       ^
1 error



I checked env for both..


Both doesn't have classpath in it..

any ideas for this too?