thanks! i'm trying your suggestions right now. Is there a book on derby that anybody would recommend? i'd like to get something that goes beyond the basics..
steve --- On Wed, 4/20/11, Knut Anders Hatlen <[email protected]> wrote: > From: Knut Anders Hatlen <[email protected]> > Subject: Re: problem with embedded driver > To: "Derby Discussion" <[email protected]> > Date: Wednesday, April 20, 2011, 3:09 AM > steve lescure <[email protected]> > writes: > > > 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) > > Did you set derby.system.home to ~/.netbeans-derby for your > application. > If you didn't, the code above will connect to a database in > the current > working directory (if there is one with that name) instead > of the > database in ~/.netbeans-derby. > > Alternatively, you can specify the full path to the > database in the > connection URL: > > jdbc:derby:/home/steve/.netbeans-derby/DEMAND > > If you've already done this and it doesn't work, you could > make your > application print all your tables and which schema they're > in by > changing your query to: > > rs = s.executeQuery( > "select schemaname || '.' || > tablename from " + > "sys.systables t, > sys.sysschemas s " + > "where t.schemaid=s.schemaid > and schemaname not like 'SYS%'"); > System.out.println("Tables:"); > while (rs.next()) { > > System.out.println(rs.getString(1)); > } > > -- > Knut Anders >
