RE: problem with embedded driver

[Daniel A Keefe]

I have found that I need to include the path to the derby db in my connect 
string

dk

________________________________________
From: steve lescure [stevelesc...@yahoo.com]
Sent: Tuesday, April 19, 2011 10:36 PM
To: Derby Discussion
Subject: Re: problem with embedded driver

thanks that was a great big help!   never would have figured all that out.

i can now connect to the database............now i've encounter yet another 
mystery.

It keeps telling me it can't find my table JOBS....i've read that NETBEANS 
should create  a default schema NBUSER (the id I used to when i created the 
db).  When i check the properties of the database, the schema is indeed NBUSER. 
 however, to create a table i have to use the APP schema (NBUSER is not in the 
list).  I did that, but NETBEANS can't find the table even if i use APP.JOBS... 
I've tried JOBS  APP.JOBS NBUSER.JOBS all fail.

any thoughts?

        try {
            Properties props = new Properties(); // connection properties
            props.put("user", "nbuser");
            props.put("password", "nbuser");
            String dbName = "DEMAND"; // the name of the database

            conn = DriverManager.getConnection(protocol + dbName
                    + ";create=false", props);
            System.out.println("Connected to database " + dbName);

            conn.setAutoCommit(true);
            s = conn.createStatement();
            statements.add(s);
            rs = s.executeQuery(
                    "SELECT JOBNAME, USERID FROM APP.JOBS");
            (dies here)






--- On Tue, 4/19/11, Mark Eggers <mdegg...@gmail.com> wrote:

> From: Mark Eggers <mdegg...@gmail.com>
> Subject: Re: problem with embedded driver
> To: derby-user@db.apache.org
> Date: Tuesday, April 19, 2011, 4:46 PM
> On Tue, 19 Apr 2011 12:45:54 -0700,
> steve lescure wrote:
>
> > String dbName = "//localhost:1527/users";
>
> This is a connection to the network server. If you don't
> start the
> database prior to running your program, there will be no
> connection.
>
> If you're using the embedded driver, the database name is
> just the name
> of the database (users, in your case).
>
> Now the next problem is that with NetBeans, the database
> gets created in
> a strange spot - $HOME/.netbeans-derby by default. Probably
> the easiest
> way to run this program is by passing a value for the
> derby.system.home
> property. This tells Derby where to look for databases when
> the program
> is started.
>
> By default, the value is ".". This obviously won't work for
> your code,
> since you used NetBeans to create the database. However,
> setting this in
> NetBeans is pretty easy.
>
> 1. Right-mouse click on your project and select Properties
> 2. In the dialog box, click on the Run item
> 3. Add the following to your VM Options:
>
> -Dderby.system.home=$HOME/.netbeans-derby
>
> You might have to replace $HOME with the full path,
> depending on how
> NetBeans handles environment variables.
>
> Now the program will run from within NetBeans. When you run
> this from the
> command line (in the dist folder of your project), use the
> following
> syntax.
>
> java -Dderby.system.home=$HOME/.netbeans-derby -jar
> YourApp.jar
>
> Hope this helps.
>
> . . . . just my two cents.
>
> /mde/
>
>

NOTICE:  The information contained in this electronic mail transmission is 
intended by Convergys Corporation for the use of the named individual or entity 
to which it is directed and may contain information that is privileged or 
otherwise confidential.  If you have received this electronic mail transmission 
in error, please delete it from your system without copying or forwarding it, 
and notify the sender of the error by reply email or by telephone (collect), so 
that the sender's address records can be corrected.