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 <[email protected]> wrote:
> From: Mark Eggers <[email protected]>
> Subject: Re: problem with embedded driver
> To: [email protected]
> 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/
>
>
