-
1. Re: Empty h2 database when installing JBoss DataVirtualization Quickstart Kit
rareddy Nov 21, 2016 11:50 AM (in response to lars.eicher)Lars,
Welcome JBoss Data Virtualization forum. Sorry I missed your post earlier, thus delay.
Can you tell me tell me which example (link?) you are following and where you see the empty H2? Often times it may be much more simple to connect to your database that you have access to rather than working with the Quick Start example's creation of database instance.
Ramesh..
-
2. Re: Empty h2 database when installing JBoss DataVirtualization Quickstart Kit
lars.eicher Nov 22, 2016 2:23 AM (in response to rareddy)Hello Ramesh
I am using the Quick Start example referenced in JBoss Data Virtualization - Get Started | 'Red Hat Developers' .
A colleague of mine also tried to install the quick start package, with the same result.
From the description on the internet I was expecting a self contained working example.
To move on I have populated the h2 database with some own data.
Lars
-
3. Re: Empty h2 database when installing JBoss DataVirtualization Quickstart Kit
rareddy Nov 22, 2016 10:03 AM (in response to lars.eicher)Lars,
I tried the example myself on my fedora machine this worked fine. After the installation, I stopped the server and started it with "start_server.sh" which also started the H2 database. The I used SquirreL SQL client to connect to H2 using the JDBC URL
url: jdbc:h2:tcp://localhost:9092/accounts
user: sa
password: sa
I was able to connect and see all the accounts tables fine.
Ramesh.. -
4. Re: Empty h2 database when installing JBoss DataVirtualization Quickstart Kit
lars.eicher Nov 24, 2016 5:30 AM (in response to rareddy)Ramesh,
thank you for verifying on your machine. After your response I had a look at the installation process and discovered that the automatic server start after 210 seconds was too early for the installation to complete (the server started while the patches were applied).
I therefore changed the timeout in the script file and reinstalled in a fresh directory.
It worked and the h2 database now contains the account tables which solves my problem.
Regards Lars
-
5. Re: Empty h2 database when installing JBoss DataVirtualization Quickstart Kit
rareddy Nov 26, 2016 12:21 PM (in response to lars.eicher)Thank you for that finding, I will see if we can change the default to little longer.
-
6. Re: Empty h2 database when installing JBoss DataVirtualization Quickstart Kit
rhn-engineering-vhalbert Nov 27, 2016 9:13 PM (in response to lars.eicher)Lars,
What did you increase 210 to?
Thanks.
Van
-
7. Re: Empty h2 database when installing JBoss DataVirtualization Quickstart Kit
lars.eicher Nov 28, 2016 6:04 AM (in response to rhn-engineering-vhalbert)Van,
I changed it to 400 (depending on the speed of your computer a lower value might also work)
Lars