Urgent Help Required : Accessing DB with Derby Net Server

[Kapil Bajaj]

Hi All

I am trying to read a table from Cloudscape Database using Derby Net Server through Java Program

Every Time I run program I get the Error "No Suitable Driver"

Here is portion from Java Program

Connection connection = null;
        Driver driver = null;
        String s = "jdbc:derby:net://localhost:1527/TEST;";
        try
        {
            driver = (Driver)Class.forName("com.ibm.db2.jcc.DB2Driver").newInstance();
        }
        catch(Exception exception)
        {
            System.out.println("1");
            exception.printStackTrace();
        }
        try
        {
            DriverManager.registerDriver(driver);
            connection = DriverManager.getConnection(s, "", "");
        }
        catch(Exception exception1)
        {
            System.out.println("2");
            exception1.printStackTrace();
        }

I have made sure that db2jcc.jar is included in Classpath. I have not downloaded any jar File only used what is available in Cloudscape By Default.

My Cloudscape Server is running and I wanted to take connection from running Server without Stopping Server. Also I am setting derby.system.home Property to location in C Drive using -D Option while running Java File. I am setting system.home Property to Directory where my database is residing.

However if I use Embedded Driver DB2jDriver than my program works fine but I am getting Error with Network Server Mode.

Please help me with this issue as this is really urgent.

Thanks and Regards
------------------------------------------------------------------------------------------------------------------
Kapil Bajaj