Sorry about this, I forgot that replying to these emails, has adverse consequences. Will delete this stupidity soon, if no one else does. Eek.
On Monday, 30 July 2018 11:59:56 UTC+12, witerat wrote: > > Best to add ";IFEXISTS=true" to the url, to avoid this sort of confusion > and other problems. > > On 29/07/18 16:08, [email protected] wrote: > > [email protected] Google Groups > <https://groups.google.com/forum/?utm_source=digest&utm_medium=email/#%21overview> > > <https://groups.google.com/forum/?utm_source=digest&utm_medium=email/#%21overview> > > Topic digest > View all topics > > - Table Not Found > <#[email protected]_group_thread_0> - 3 > Updates > > Table Not Found > <http://groups.google.com/group/h2-database/t/dc6a10ab73295f7f?utm_source=digest&utm_medium=email> > > Marving Jr <[email protected]> <[email protected]>: Jul 28 06:12AM > -0700 > > Hi > I'm trying to use explicit relative path url, but I get error Table Not > Found > > Project Netbeans > AppDatabase > build > dist > nbproject > res > db > ENTERPRISE.mv.db > src > > =================================== > DaoFactoryAbs df = DaoFactoryAbs.getInstance("jdbc", "h2", "ENTERPRISE"); > CustomerDaoAbs customerDao = df.getCustomerDao(); > customerDao.findAll().forEach(System.out::println); > =================================== > > connection = DriverManager.getConnection(url, user, password); > > > if url is "jdbc:h2:~/Code/project/nb/AppDatabase/res/db/ENTERPRISE"; > All is ok > > but > if url is "jdbc:h2:./res/db/ENTERPRISE"; > connection is ok > but get error > Caused by: appdatabase.dao.exception.DaoException: > org.h2.jdbc.JdbcSQLException: Tabla "CUSTOMER" no encontrada > Table "CUSTOMER" not found; SQL statement: > SELECT * FROM CUSTOMER [42102-197] > > Can someone tell me the reason for this error? > Andrei Tokar <[email protected]> <[email protected]>: Jul 28 > 11:44AM -0700 > > Make sure your current directory on JVM startup is AppDatabase. > Connection is "Ok", because it probably creates a new empty database > somwhere else under ./res/db/, whatever it is. > Marving Jr <[email protected]> <[email protected]>: Jul 28 11:59AM > -0700 > > El sábado, 28 de julio de 2018, 20:44:54 (UTC+2), Andrei Tokar escribió: > > > Make sure your current directory on JVM startup is AppDatabase. > > Connection is "Ok", because it probably creates a new empty database > > somwhere else under ./res/db/, whatever it is. > > Hi Andrei > I am sorry. I apologize for my mistake. I did not want to waste your time > I just found the solution and at the same time I saw your answer . > You are right > I've created the database in ~/Code/project/nb/ > AppDatabase/res/db/ENTERPRISE > and my netbeans project in > ~/Code/projects/nb/AppDatabase/res/db/ENTERPRISE > --- projects--- with s > in netbeans project exist database ENTERPRISE but without table CUSTOMER > in ~/Code/project/nb/AppDatabase/res/db/ENTERPRISE exist DATABASE with > table CUSTOMER. > Many hours in front of the computer. I need glasses. :) > > Apologize again > Many Thanks Andrei > Regards > Back to top <#[email protected]_digest_top> > You received this digest because you're subscribed to updates for this > group. You can change your settings on the group membership page. > To unsubscribe from this group and stop receiving emails from it send an > email to [email protected]. > > > -- You received this message because you are subscribed to the Google Groups "H2 Database" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. To post to this group, send email to [email protected]. Visit this group at https://groups.google.com/group/h2-database. For more options, visit https://groups.google.com/d/optout.
