You are viewing a plain text version of this content. The canonical link for it is here.

Posted to user@turbine.apache.org by Erik Hatcher <ja...@ehatchersolutions.com> on 2002/02/23 02:38:56 UTC

Hypersonic problems - Unknown JDBC driver

Is this the right place to ask Torque questions?  I'm a newbie to Torque,
but very jazzed about getting it rolling.  I'm impressed with the amount of
documentation and infrastructure that is in place for it.  Unfortunately I'm
having a problem that I haven't seen mentioned in the archives or
documentation - so I must be doing something really dumb....

I'm using the latest fresh build from CVS, but I've tried other builds with
the same problem so I'm not suspecting a Torque code problem. I've also
succesfully connected to MSSQL (with the beta drivers), but my goal is to
use hsqldb for something lightweight.

My code is very simply:

        try {
            Torque.init("c:/temp/torque/Torque.properties");
        }
        catch (Exception e) {
            e.printStackTrace();
        }

        Vector users = null;
        User user = null;
        String username = "erik";
        String password = "";
        Criteria criteria = new Criteria();
        criteria.add(UserPeer.USERNAME, username.toLowerCase());
        criteria.add(UserPeer.PASSWORD, password);

        try {
            users = UserPeer.doSelect(criteria);
        }
        catch (Exception e) {
            e.printStackTrace();
        }

And I'm getting this exception (running <java> from within Ant):
     [java] java.lang.InstantiationException: Unknown JDBC driver:
org.hsqldb.jdbcDriver: Check your configuration file
     [java]     at
org.apache.torque.adapter.DBFactory.create(DBFactory.java:223
)
     [java]     at org.apache.torque.Torque.initDatabaseMap(Torque.java:542)
     [java]     at org.apache.torque.Torque.getDatabaseMap(Torque.java:518)
     [java]     at
org.apache.torque.util.Criteria.containsObjectColumn(Criteria
.java:410)
     [java]     at
org.apache.torque.util.BasePeer.doSelect(BasePeer.java:1207)
     [java]     at
org.example.testdb.om.torque.BaseUserPeer.doSelectVillageRec
ords(BaseUserPeer.java:275)
     [java]     at
org.example.testdb.om.torque.BaseUserPeer.doSelectVillageRec
ords(BaseUserPeer.java:245)
     [java]     at
org.example.testdb.om.torque.BaseUserPeer.doSelect(BaseUserP
eer.java:223)
     [java]     at Test.main(Test.java:30)
     [java] rethrown as org.apache.torque.TorqueException: Unknown JDBC
driver:
org.hsqldb.jdbcDriver: Check your configuration file
     [java]     at org.apache.torque.Torque.initDatabaseMap(Torque.java:552)
     [java]     at org.apache.torque.Torque.getDatabaseMap(Torque.java:518)
     [java]     at
org.apache.torque.util.Criteria.containsObjectColumn(Criteria
.java:410)
     [java]     at
org.apache.torque.util.BasePeer.doSelect(BasePeer.java:1207)
     [java]     at
org.example.testdb.om.torque.BaseUserPeer.doSelectVillageRec
ords(BaseUserPeer.java:275)
     [java]     at
org.example.testdb.om.torque.BaseUserPeer.doSelectVillageRec
ords(BaseUserPeer.java:245)
     [java]     at
org.example.testdb.om.torque.BaseUserPeer.doSelect(BaseUserP
eer.java:223)
     [java]     at Test.main(Test.java:30)

I've most definitely got hsqldb.jar (v. 1.61) in my classpath.  I've tried
this many many ways (embedded in a webapp at first, now narrowed to a simple
main barebones example).

Why is it not finding it?   Its driving me nuts and its bound to be
something very simple I'm missing.

My Torque.properties file has this:
torque.database.default.driver = org.hsqldb.jdbcDriver
torque.database.default.url = jdbc:hsqldb:c:/temp/torque/db/testdb
torque.database.default.username = sa
torque.database.default.password =

Help!  I look forward to the answer being a RTFM or something like that, so
be gentle on me but point me in the right direction.  :)

Thanks,
    Erik



--
To unsubscribe, e-mail:   <ma...@jakarta.apache.org>
For additional commands, e-mail: <ma...@jakarta.apache.org>