Re: cloudscape

From: Jared Dykstra (dyksjare_at_hotmail.com)
Date: 02/04/04


Date: 4 Feb 2004 10:27:56 -0800


"Rob" <talon2lm@yahoo.com> wrote in message news:<LISdnfS4BtZVFb3dRVn-uQ@comcast.com>...
> I'm a newbie in cloudscape (Java too) and I'm having a problem. I've
> followed the tutorial that comes with cloudscape to the letter. Everything
> worked as advertised up untill this program:
>
> /*
> * Licensed Materials - Property of IBM
> *
> * (C) Copyright IBM Corp. 2000, 2001
> * All Rights Reserved.
> */
> import java.sql.*;
>
> public class CreateWorldDB {
>
>
>
> public static void main (String[] args) {
>
> try {
>
> Class.forName("com.ibm.db2j.jdbc.DB2jDriver").newInstance();
> System.out.println("Loaded the Cloudscape JDBC
> driver. Hello, World!");
> Connection conn =
>
> DriverManager.getConnection("jdbc:db2j:HelloWorldDB;create=true")
>
> ;
> System.out.println("Created and connected to
>
> database HelloWorldDB");
>
> } catch (Throwable e) {
> System.out.println("exception thrown");
> e.printStackTrace();
> }
>
> }
>
>
> }
>
> I run it with "java -Dbd2j.system.home=C:\tutorial_system CreateWorldDB"
>
> And results in:
> Loaded the Cloudscape JDBC driver. Hello, World!
> exception thrown
> java.sql.SQLException: No suitable driver
> at java.sql.DriverManager.getConnection(Unknown Source)
> at java.sql.DriverManager.getConnection(Unknown Source)
> at CreateWorldDB.main(CreateWorldDB.java:18)
>
> What's going on? It can connect with that driver but it can't create/access?
> I'm highly confused...
>
> I'm running J2SE/HotSpot VM 1.4.2_03 and cloudscape5.1
>
> Thanks,
> Rob

You define "bd2j.system.home" when running the code, but the package
name is "db2j.system.home" If what you're defining is important, the
program is not going to be able to find it. Use:

java -Ddb2j.system.home=C:\tutorial_system CreateWorldDB

You might have other problems, but start with that.

---
Jared Dykstra
http://www.bork.org/~jared


Relevant Pages

  • cloudscape
    ... I'm a newbie in cloudscape (Java too) and I'm having a problem. ... public class CreateWorldDB { ... Loaded the Cloudscape JDBC driver. ...
    (comp.lang.java)
  • Anyone know where to download JDBC driver
    ... DB2jDriver for use with IBM's Cloudscape? ... they reference as the driver of choice for use with Cloudscape. ...
    (comp.lang.java.programmer)
  • Re: Cloudscape - usage of?
    ... For more information about how to use Apache Derby...the newest incarnation of Cloudscape, you can check out this online article: ... Using Java DB in Desktop Applications ...
    (comp.lang.java.databases)
  • Cloudspace including in Solaris!
    ... Sun's distribution will be called Java DB (IBM's is called ... Cloudscape)!! ... Prev by Date: ...
    (comp.databases.informix)
  • Re: Cloudscape - usage of?
    ... For more information about how to use Apache Derby...the newest incarnation of Cloudscape, you can check out this online article: ... Using Java DB in Desktop Applications ...
    (comp.lang.java.databases)