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]
<%0A%20%20https://groups.google.com/forum/?utm_source=digest&utm_medium=email#%21forum/h2-database/topics%0A>
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
<%0A%20%20https://groups.google.com/forum/?utm_source=digest&utm_medium=email#%21forum/h2-database/topics%0A>
* Table Not Found <#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]>: 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]>: 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]>: 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 <#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
<%0A%20%20https://groups.google.com/forum/?utm_source=digest&utm_medium=email#%21forum/h2-database/join%0A>.
To unsubscribe from this group and stop receiving emails from it send
an email to [email protected]
<mailto:[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.
