Grouper Developers Forum

["GW Brown, Information Systems and Computing" <>]

Hi Simon,

Have you looked at conf/hibernate.properties?

There are setttings such as:

hibernate.dialect= net.sf.hibernate.dialect.OracleDialect
hibernate.connection.driver_class= oracle.jdbc.driver.OracleDriver

hibernate.connection.url= jdbc:oracle:thin:@<host>:1521:HDESKT

These are what Grouper uses when exercising the API.

Gary

--On 09 June 2005 16:20 +0100 Simon McLeish 
<>
 wrote:

> Hi,
>
> I've been trying to build grouper against the postgres database; I've
> created working schema and test data files, and ant build and ant db-
> init run fine to create the database. When I run ant test, though, I get
> the data insertion OK but then every test fails with errors like:
>
>    [junit] 113) testReplaceThenFetchDescNewSession
> (test.edu.internet2.middleware.grouper.TestGroupsAttrsRep)java.lang.Runti
> meException: Unable to create connection to
> jdbc:hsqldb:dist/run/grouper:java.sql.SQLException: The database is
> already in use by another process: 
> org.hsqldb.NIOLockFile@77097ff5[file
> =/usr/local/grouper-0.5.6/dist/run/grouper.lck, exists=true,
> locked=false, valid=false, fl =null]: java.lang.Exception:
> checkHeartbeat(): lock file
> [/usr/local/grouper-0.5.6/dist/run/grouper.lck] is presumably locked by
> another process.     [junit]     at
> test.edu.internet2.middleware.grouper.DB._connect (Unknown Source)
>     [junit]     at
> test.edu.internet2.middleware.grouper.DB.<init>(Unknown Source)
>     [junit]     at
> test.edu.internet2.middleware.grouper.TestGroupsAttrsRep.setUp(Unknown
> Source)
>
> I presume this means that the hsqldb URI is hardcoded somewhere rather
> than picked up from the build.xml file where I put the equivalent
> postgres URI (and the lock file part of the error is present because the
> previous tests didn't complete). If I'm wrong and there's a fix, could
> you let me know?
>
> Cheers,
> Simon
> --
> Simon McLeish 
> <>
> London School of Economics



----------------------
GW Brown, Information Systems and Computing