JDBC connection to Cache - error

[javavick]

Hi,

I'm new to JDBC and trying to write a simple program to connect to Cache database. the program is pasted below.

import java.sql.*;
import com.intersys.jdbc.CacheDriver;
public class test
{
public static void main(String args[])
{

System.out.println("hello world");
}
}
When I compile it, it gives the following error

test.java:1: package com.intersys.jdbc does not exist
import com.intersys.jdbc.CacheDriver;

I have included the CacheDB.jar file in the CLASSPATH of user variables, which is C:\InterSystems\Cache\Dev\java\lib\JDK14; but still I get this error and I'm able to compile simple programs and run , those that doesnt involve com.intersys.... packages.

Please help if anyone knows the cause.

[Tolls]

You need to include the jar file, not just the directory.
It's also not advisable to stick these things in the CLASSPATH, but to use the proper switch for javac (-cp), or to set up your project correctly in an IDE.