Please take our Survey
logo       

Choosing A Webhost:
A web hosting service is a type of Internet hosting service that allows individuals and organizations to provide their own website accessible via the World Wide Web. Web hosts are companies that provide space on a server they own for use by their clients as well as providing Internet connectivity, typically in a data center. Web hosts can also provide data center space and connectivity to the Internet for servers they do not own to be located in their data center, called colocation. more...

java -jar lib/hsqldb.jar localhost-sa skips the database with localhost-sa : msg#00007

java.hsqldb.user

Subject: java -jar lib/hsqldb.jar localhost-sa skips the database with localhost-sa urlid

calling the database with urlid "mem" works just fine.

however, calling the database with urlid "localhost-sa" falls through to a
ms-sql urlid for some reason. I am using 1.8.0.7 and did not alter the
server.properties or sqltool.rc files. I was following the Unix Quick Start
(though I am on Windows/Cygwin).

Administrator@LIFEBOOK ~/install/hsqldb : echo $CLASSPATH
C:\cygwin\home\Administrator\install\hsqldb\lib\hsqldb.jar
# -------------------------------------- successful with "mem"
Administrator@LIFEBOOK ~/install/hsqldb : java -jar lib/hsqldb.jar mem
JDBC Connection established to a HSQL Database Engine v. 1.8.0 database as 'SA'.
SqlTool v. 1.55. (SqlFile processor v. 1.135)
Distribution is permitted under the terms of the HSQLDB license.
(c) 2004-2005 Blaine Simpson and the HSQLDB Development Group.

\q to Quit.
\? lists Special Commands.
:? lists Buffer/Editing commands.
*? lists PL commands (including alias commands).

SPECIAL Commands begin with '\' and execute when you hit ENTER.
BUFFER Commands begin with ':' and execute when you hit ENTER.
COMMENTS begin with '/*' and end with the very next '*/'.
PROCEDURAL LANGUAGE commands begin with '*' and end when you hit ENTER.
All other lines comprise SQL Statements.
SQL Statements are terminated by either a blank line (which moves the
statement into the buffer without executing) or a line ending with ';'
(which executes the statement).
SQL Statements may begin with '/PLVARNAME' and/or contain *{PLVARNAME}s.

sql>
# ------------------------------- no luck with "localhost-sa"
Administrator@LIFEBOOK ~/install/hsqldb : java -jar lib/hsqldb.jar localhost-sa
java.lang.ClassNotFoundException: com.microsoft.jdbc.sqlserver.SQLServerDriver
at java.net.URLClassLoader$1.run(Unknown Source)
at java.security.AccessController.doPrivileged(Native Method)
at java.net.URLClassLoader.findClass(Unknown Source)
at java.lang.ClassLoader.loadClass(Unknown Source)
at sun.misc.Launcher$AppClassLoader.loadClass(Unknown Source)
at java.lang.ClassLoader.loadClass(Unknown Source)
at java.lang.ClassLoader.loadClassInternal(Unknown Source)
at java.lang.Class.forName0(Native Method)
at java.lang.Class.forName(Unknown Source)
at org.hsqldb.util.RCData.getConnection(Unknown Source)
at org.hsqldb.util.SqlTool.main(Unknown Source)
Failed to get a connection to
jdbc:microsoft:sqlserver://hostname;DatabaseName=DbName;SelectMethod=Cursor as
myuser. com.microsoft.jdbc.sqlserver.SQLServerDriver



-------------------------------------------------------------------------
This SF.net email is sponsored by DB2 Express
Download DB2 Express C - the FREE version of DB2 express and take
control of your XML. No limits. Just data. Click to get it now.
http://sourceforge.net/powerbar/db2/


<Prev in Thread] Current Thread [Next in Thread>
Google Custom Search

Recently Viewed:
qplus.devel/200...    network.jabber....    debian.qa-packa...    encryption.gpg....    python.dabo.dev...    uclinux.devel/2...    science.mathema...    recreation.pesc...    kernel.ck/2004-...    mozilla.devel.e...    tex.latex.prosp...    ietf.multi6/200...    bbc.cvs/2002-11...    xfree86.newbie/...    jakarta.taglibs...    altlinux.hardwa...    comedi/2002-05/...    horde.bugs/2004...    games.diplomacy...    finance.e-gold....    web.dom.test-su...    lang.ruby.rails...    os.netbsd.devel...    video.gstreamer...   
Home | advertise | OSDir is an inevitable website. super tiny logo

Free Magazines

Cisco News
Receive a free quarterly e-newsletter with exclusive articles on how Cisco IT uses its own products and solutions to enable the business.
subscribe

Systems Management News, the newspaper for IT systems administration and data center managers! Each issue of Systems Management News is chock-full of news and analysis to help you understand what's happening in your field.
subscribe

The Enterprise Newsweekly eWeek is the essential technology information source for builders of e-business.
subscribe

Oracle Magazine Oracle Magazine contains technology strategy articles, sample code, tips, Oracle and partner news, how to articles for developers and DBAs, and more. Oracle (NASDAQ: ORCL) is the world's largest enterprise software company.
subscribe

Total Telecom Total Telecom is "The Economist of the communications industry".
subscribe

Navigation