|

»

Eclipse Data Source Explorer does not show user tables

View: New views

9 Messages — Rating Filter: Alert me

	Eclipse Data Source Explorer does not show user tables by mslinn :: Rate this Message: Reply to Author \| View Threaded \| Show Only this Message I'm using hsqldb 1.8.1. From a DOS prompt, I can see tables using this script, which is in the same directory as the other files. startdb.bat java -cp ../lib/hsqldb.jar org.hsqldb.util.SqlTool --inlineRc "URL=jdbc:hsqldb:file:data,USER=SA,PASSWORD=" --sql "select * from contact;" @if exist data.lck del data.lck server.properties server.database.0=file:data server.dbname.0=data server.port=9002 #server.silent=false server.trace=false data.properties #HSQL Database Engine 1.8.0.10 #Tue Oct 20 11:51:26 PDT 2009 hsqldb.script_format=0 runtime.gc_interval=0 hsqldb.incremental_backup=false sql.enforce_strict_size=false hsqldb.cache_size_scale=8 readonly=false hsqldb.nio_data_file=true hsqldb.cache_scale=14 version=1.8.1 hsqldb.default_table_type=memory hsqldb.cache_file_scale=1 hsqldb.lock_file=true hsqldb.log_size=200 modified=yes hsqldb.cache_version=1.7.0 hsqldb.original_version=1.8.1 hsqldb.compatible_version=1.8.0 data.script CREATE SCHEMA PUBLIC AUTHORIZATION DBA CREATE MEMORY TABLE CONTACT(CONTACT_ID INTEGER GENERATED BY DEFAULT AS IDENTITY(START WITH 10) NOT NULL PRIMARY KEY,FIRST_NAME VARCHAR(50),LAST_NAME VARCHAR(50),TITLE VARCHAR(50),PHONE VARCHAR(30),EMAIL VARCHAR(30)) ALTER TABLE CONTACT ALTER COLUMN CONTACT_ID RESTART WITH 10 CREATE USER SA PASSWORD "" GRANT DBA TO SA SET WRITE_DELAY 10 SET SCHEMA PUBLIC INSERT INTO CONTACT VALUES(1,'Christophe','Coenraets','','617-219-2003','ccoenrae@adobe.com') INSERT INTO CONTACT VALUES(2,'Basil','Simpson','','617-873-8877','') INSERT INTO CONTACT VALUES(3,'Chloe','Jones','President','415-908-2244','') INSERT INTO CONTACT VALUES(4,'Myriam','Wong','COO','781-987-2344','') INSERT INTO CONTACT VALUES(5,'John','Baker','QA Manager','617-200-9876','') INSERT INTO CONTACT VALUES(6,'Lisa','Mona','','617-298-1122','') INSERT INTO CONTACT VALUES(7,'Jeff','King','Engineer','781-234-5678','') INSERT INTO CONTACT VALUES(8,'Jacky','Dupont','Architect','212-897-2288','') INSERT INTO CONTACT VALUES(9,'Mike','Slinn','Author and contractor','415-367-3789','mslinn@mslinn.com') Command Line Results java -cp ../lib/hsqldb.jar org.hsqldb.util.SqlTool --inlineRc "URL=jdbc:hsqldb:file:data,USER=SA,PASSWORD=" --sql "select * from contact;" CONTACT_ID FIRST_NAME LAST_NAME TITLE PHONE EMAIL ---------- ---------- --------- --------------------- ------------ ------------------ 1 Christophe xx 617-219-2003 xx@adobe.com 2 Basil Simpson 617-873-8877 3 Chloe Jones President 415-908-2244 4 Myriam Wong COO 781-987-2344 5 John Baker QA Manager 617-200-9876 6 Lisa Mona 617-298-1122 7 Jeff King Engineer 781-234-5678 8 Jacky Dupont Architect 212-897-2288 9 Mike Slinn Author and contractor 415-367-3789 mslinn@mslinn.com Fetched 9 rows. C:\sites\slinnbooks.com\www\production\webapps\ROOT\books\serverSide\examples\dataServices\dmsAirSync\WebContent\WEB-INF\data> Eclipse Data Source Profile Properties hsqldb.jar points to the correct jar. Database: data Database location: c:\blah\blah\data user name: SA password: The database pings fine. Eclipse 3.5 Data Source Explorer Results No user tables are shown. [banging head against hard surface] There must be something about the setup that works from a command line, but not from Eclipse. What could this be? Eclipse does not appear to provide a facility to show debug output. How can I direct hsqldb debug log output to a file?
	Re: Eclipse Data Source Explorer does not show user tables by Fred Toussi-2 :: Rate this Message: Reply to Author \| View Threaded \| Show Only this Message Some parts of this message have been removed. Learn more about Nabble's security policy. You cannot access a database simultaneously from two programs. Run a server instance instead and connect to it from multiple clients. Fred On Tue, 20 Oct 2009 12:35 -0700, "mslinn" <mslinn@...> wrote: I'm using hsqldb 1.8.1. From a DOS prompt, I can see tables using this script, which is in the same directory as the other files. startdb.bat java -cp ../lib/hsqldb.jar org.hsqldb.util.SqlTool --inlineRc "URL=jdbc:hsqldb:file:data,USER=SA,PASSWORD=" --sql "select * from contact;" @if exist data.lck del data.lck server.properties server.database.0=file:data server.dbname.0=data server.port=9002 #server.silent=false server.trace=false data.properties #HSQL Database Engine 1.8.0.10 #Tue Oct 20 11:51:26 PDT 2009 hsqldb.script_format=0 runtime.gc_interval=0 hsqldb.incremental_backup=false sql.enforce_strict_size=false hsqldb.cache_size_scale=8 readonly=false hsqldb.nio_data_file=true hsqldb.cache_scale=14 version=1.8.1 hsqldb.default_table_type=memory hsqldb.cache_file_scale=1 hsqldb.lock_file=true hsqldb.log_size=200 modified=yes hsqldb.cache_version=1.7.0 hsqldb.original_version=1.8.1 hsqldb.compatible_version=1.8.0 data.script CREATE SCHEMA PUBLIC AUTHORIZATION DBA CREATE MEMORY TABLE CONTACT(CONTACT_ID INTEGER GENERATED BY DEFAULT AS IDENTITY(START WITH 10) NOT NULL PRIMARY KEY,FIRST_NAME VARCHAR(50),LAST_NAME VARCHAR(50),TITLE VARCHAR(50),PHONE VARCHAR(30),EMAIL VARCHAR(30)) ALTER TABLE CONTACT ALTER COLUMN CONTACT_ID RESTART WITH 10 CREATE USER SA PASSWORD "" GRANT DBA TO SA SET WRITE_DELAY 10 SET SCHEMA PUBLIC INSERT INTO CONTACT VALUES(1,'Christophe','Coenraets','','617-219-2003','ccoenrae@...') INSERT INTO CONTACT VALUES(2,'Basil','Simpson','','617-873-8877','') INSERT INTO CONTACT VALUES(3,'Chloe','Jones','President','415-908-2244','') INSERT INTO CONTACT VALUES(4,'Myriam','Wong','COO','781-987-2344','') INSERT INTO CONTACT VALUES(5,'John','Baker','QA Manager','617-200-9876','') INSERT INTO CONTACT VALUES(6,'Lisa','Mona','','617-298-1122','') INSERT INTO CONTACT VALUES(7,'Jeff','King','Engineer','781-234-5678','') INSERT INTO CONTACT VALUES(8,'Jacky','Dupont','Architect','212-897-2288','') INSERT INTO CONTACT VALUES(9,'Mike','Slinn','Author and contractor','415-367-3789','mslinn@...') Command Line Results java -cp ../lib/hsqldb.jar org.hsqldb.util.SqlTool --inlineRc "URL=jdbc:hsqldb:file:data,USER=SA,PASSWORD=" --sql "select * from contact;" CONTACT_ID FIRST_NAME LAST_NAME TITLE PHONE EMAIL ---------- ---------- --------- --------------------- ------------ ------------------ 1 Christophe xx 617-219-2003 xx@... 2 Basil Simpson 617-873-8877 3 Chloe Jones President 415-908-2244 4 Myriam Wong COO 781-987-2344 5 John Baker QA Manager 617-200-9876 6 Lisa Mona 617-298-1122 7 Jeff King Engineer 781-234-5678 8 Jacky Dupont Architect 212-897-2288 9 Mike Slinn Author and contractor 415-367-3789 mslinn@... Fetched 9 rows. C:\sites\slinnbooks.com\www\production\webapps\ROOT\books\serverSide\examples\dataServices\dmsAirSync\WebContent\WEB-INF\data> Eclipse Data Source Profile Properties hsqldb.jar points to the correct jar. Database: data Database location: c:\blah\blah\data user name: SA password: The database pings fine. Eclipse 3.5 Data Source Explorer Results No user tables are shown. [banging head against hard surface] There must be something about the setup that works from a command line, but not from Eclipse. What could this be? Eclipse does not appear to provide a facility to show debug output. How can I direct hsqldb debug log output to a file? View this message in context: Eclipse Data Source Explorer does not show user tables Sent from the HSQLDB - User mailing list archive at Nabble.com. ------------------------------------------------------------------------------ Come build with us! The BlackBerry(R) Developer Conference in SF, CA is the only developer event you need to attend this year. Jumpstart your developing skills, take BlackBerry mobile applications to market and stay ahead of the curve. Join us from November 9 - 12, 2009. Register now! http://p.sf.net/sfu/devconference _______________________________________________ Hsqldb-user mailing list Hsqldb-user@... https://lists.sourceforge.net/lists/listinfo/hsqldb-user
	Re: Eclipse Data Source Explorer does not show user tables by mslinn :: Rate this Message: Reply to Author \| View Threaded \| Show Only this Message Fred, Only one program accesses the database at any given time. Mike
	Re: Eclipse Data Source Explorer does not show user tables by Fred Toussi-2 :: Rate this Message: Reply to Author \| View Threaded \| Show Only this Message Then please use the ifexist property to throw an exception if URL's are not matched. I don't know about the Eclipse module anyway, there may be an issue there, but not likely so. Fred On Tue, 20 Oct 2009 14:29 -0700, "mslinn" <mslinn@...> wrote: > > Fred, > > Only one program accesses the database at any given time. > > Mike > -- > View this message in context: > http://www.nabble.com/Eclipse-Data-Source-Explorer-does-not-show-user-tables-tp25981160p25982910.html > Sent from the HSQLDB - User mailing list archive at Nabble.com. > > > ------------------------------------------------------------------------------ > Come build with us! The BlackBerry(R) Developer Conference in SF, CA > is the only developer event you need to attend this year. Jumpstart your > developing skills, take BlackBerry mobile applications to market and stay > ahead of the curve. Join us from November 9 - 12, 2009. Register now! > http://p.sf.net/sfu/devconference > _______________________________________________ > Hsqldb-user mailing list > Hsqldb-user@... > https://lists.sourceforge.net/lists/listinfo/hsqldb-user ------------------------------------------------------------------------------ Come build with us! The BlackBerry(R) Developer Conference in SF, CA is the only developer event you need to attend this year. Jumpstart your developing skills, take BlackBerry mobile applications to market and stay ahead of the curve. Join us from November 9 - 12, 2009. Register now! http://p.sf.net/sfu/devconference _______________________________________________ Hsqldb-user mailing list Hsqldb-user@... https://lists.sourceforge.net/lists/listinfo/hsqldb-user
	Re: Eclipse Data Source Explorer does not show user tables by mslinn :: Rate this Message: Reply to Author \| View Threaded \| Show Only this Message The URL matches because the pings succeed and no new database is created. I tried the Data Source Explorer because Hibernate also throws the same error. I had hoped that by removing dependencies that I would be able to determine the problem. Unfortunately I also see the same problem with Eclipse 3.4, when using a program that invokes hibernate, and also with the v3.4 Data source explorer. I'm completely stuck. Does anyone have experience with using Eclipse with HSQLDB?
	Re: Eclipse Data Source Explorer does not show user tables by Fred Toussi-2 :: Rate this Message: Reply to Author \| View Threaded \| Show Only this Message Where can I get this "database explorer" to work with Eclipse 3.5 and java tools 1.2.1? Fred On Tue, 20 Oct 2009 14:41 -0700, "mslinn" <mslinn@...> wrote: > > The URL matches because the pings succeed and no new database is created. > I > tried the Data Source Explorer because Hibernate also throws the same > error. > I had hoped that by removing dependencies that I would be able to > determine > the problem. Unfortunately I also see the same problem with Eclipse 3.4, > when using a program that invokes hibernate, and also with the v3.4 Data > source explorer. > > I'm completely stuck. Does anyone have experience with using Eclipse > with > HSQLDB? > -- > View this message in context: > http://www.nabble.com/Eclipse-Data-Source-Explorer-does-not-show-user-tables-tp25981160p25983061.html > Sent from the HSQLDB - User mailing list archive at Nabble.com. > > > ------------------------------------------------------------------------------ > Come build with us! The BlackBerry(R) Developer Conference in SF, CA > is the only developer event you need to attend this year. Jumpstart your > developing skills, take BlackBerry mobile applications to market and stay > ahead of the curve. Join us from November 9 - 12, 2009. Register now! > http://p.sf.net/sfu/devconference > _______________________________________________ > Hsqldb-user mailing list > Hsqldb-user@... > https://lists.sourceforge.net/lists/listinfo/hsqldb-user ------------------------------------------------------------------------------ Come build with us! The BlackBerry(R) Developer Conference in SF, CA is the only developer event you need to attend this year. Jumpstart your developing skills, take BlackBerry mobile applications to market and stay ahead of the curve. Join us from November 9 - 12, 2009. Register now! http://p.sf.net/sfu/devconference _______________________________________________ Hsqldb-user mailing list Hsqldb-user@... https://lists.sourceforge.net/lists/listinfo/hsqldb-user
	Re: Eclipse Data Source Explorer does not show user tables by mslinn :: Rate this Message: Reply to Author \| View Threaded \| Show Only this Message The Eclipse Data Source Explorer is a standard Eclipse component, but is not installed by default. Installation instructions vary slightly between Eclipse versions. For v3.5 (Galileo, the current version of Eclipse): Select Help / Install new software Select the Galileo site in the "Work with" pull-down: Galileo - http://download.eclipse.org/releases/galileo In a few seconds, the available packages from the Galileo site appear. Open the Database Development tree and select Data Tools Platform Extender SDK and Data Tools Platform Enablement Extender SDK. Click the Install button and follow the instructions. Mike Where can I get this "database explorer" to work with Eclipse 3.5 and java tools 1.2.1? ------------------------------------------------------------------------------ Come build with us! The BlackBerry(R) Developer Conference in SF, CA is the only developer event you need to attend this year. Jumpstart your developing skills, take BlackBerry mobile applications to market and stay ahead of the curve. Join us from November 9 - 12, 2009. Register now! http://p.sf.net/sfu/devconference _______________________________________________ Hsqldb-user mailing list Hsqldb-user@... https://lists.sourceforge.net/lists/listinfo/hsqldb-user
	Re: Eclipse Data Source Explorer does not show user tables by Fred Toussi-2 :: Rate this Message: Reply to Author \| View Threaded \| Show Only this Message Some parts of this message have been removed. Learn more about Nabble's security policy. It is installing. I will get back to you soon. Fred On Tue, 20 Oct 2009 15:04 -0700, "Michael Slinn" <mslinn@...> wrote: The Eclipse Data Source Explorer is a standard Eclipse component, but is not installed by default. Installation instructions vary slightly between Eclipse versions. For v3.5 (Galileo, the current version of Eclipse): Select Help / Install new software Select the Galileo site in the "Work with" pull-down: Galileo - http://download.eclipse.org/releases/galileo In a few seconds, the available packages from the Galileo site appear. Open the Database Development tree and select Data Tools Platform Extender SDK and Data Tools Platform Enablement Extender SDK. Click the Install button and follow the instructions. Mike Where can I get this "database explorer" to work with Eclipse 3.5 and java tools 1.2.1? ------------------------------------------------------------------------------ Come build with us! The BlackBerry(R) Developer Conference in SF, CA is the only developer event you need to attend this year. Jumpstart your developing skills, take BlackBerry mobile applications to market and stay ahead of the curve. Join us from November 9 - 12, 2009. Register now! http://p.sf.net/sfu/devconference _______________________________________________ Hsqldb-user mailing list Hsqldb-user@... https://lists.sourceforge.net/lists/listinfo/hsqldb-user
	Re: Eclipse Data Source Explorer does not show user tables by Fred Toussi-2 :: Rate this Message: Reply to Author \| View Threaded \| Show Only this Message Some parts of this message have been removed. Learn more about Nabble's security policy. The Eclipse explorer works this way. 1. Eclipse must be closed 2. You database must be present in the given directory. You should open the database with our DatabaseManager and check the tables exist, then perform the sql command "SHUTDOWN" 3. Eclipse must be pointing at the jar for the specific hsqldb version you are using. 4. Open Eclipse and connect to a completely different database. Note the "database location" for the database is misleading and badly implemented for file browsing. For example you may select a folder called c:\\ft through browsing. But this is passed as the full path in the URL, which means a database with files named ft.* located at the root or the c: drive. 4. Now connect to your intended database. 5. The Eclipse explorer will show the tables and views, but not the sequences. 6. While Eclipse is open, the connection to the database is maintained, despite your closing the connection. Therefore, you cannot access the database from outside Eclipse (the reason for point 1 above) 7. The Eclipse explorer view allows connecting to a server, which is considered the prefered option for new users (if you read the Guide). BTW, if you just want to explore the tables and other objects in the database, use something like Squirrel or DBVisualiser, which are up to date. You shouldn't have a problem connecting with Hibernate either. Fred On Tue, 20 Oct 2009 15:04 -0700, "Michael Slinn" <mslinn@...> wrote: The Eclipse Data Source Explorer is a standard Eclipse component, but is not installed by default. Installation instructions vary slightly between Eclipse versions. For v3.5 (Galileo, the current version of Eclipse): Select Help / Install new software Select the Galileo site in the "Work with" pull-down: Galileo - http://download.eclipse.org/releases/galileo In a few seconds, the available packages from the Galileo site appear. Open the Database Development tree and select Data Tools Platform Extender SDK and Data Tools Platform Enablement Extender SDK. Click the Install button and follow the instructions. Mike Where can I get this "database explorer" to work with Eclipse 3.5 and java tools 1.2.1? ------------------------------------------------------------------------------ Come build with us! The BlackBerry(R) Developer Conference in SF, CA is the only developer event you need to attend this year. Jumpstart your developing skills, take BlackBerry mobile applications to market and stay ahead of the curve. Join us from November 9 - 12, 2009. Register now! http://p.sf.net/sfu/devconference _______________________________________________ Hsqldb-user mailing list Hsqldb-user@... https://lists.sourceforge.net/lists/listinfo/hsqldb-user