cm products Questions

When I navigate to http://inwpiccm02:8080/harweb I get the following error:
Can't get hDB from pool. Check your 'harweb.cfg' and restart your servlet server.<br>java.lang.NullPointerException

SCM Version: r12.1.3
JDBC for SQL Server version: 4.0
$JAVA_HOME:C:\Program Files\Java\jre7

harweb.cfg:

JDBCDriver=com.microsoft.sqlserver.jdbc.SQLServerDriver
JDBCConnectionURL=jdbc:sqlserver://INWPITSQL01;databaseName=cascm_test;integratedSecurity=false;selectMethod=cursor
Database=SQLServer
ConnectionPoolSize=5
ConnectionPoolMax=100
ConnectionUseCount=5
ConnectionTimeout = 2
Broker=inwpiccm02
AuthMode=Internal
WorkingDirectory=C:\\Program Files\\apache-tomcat-6.0.32\\webapps\\harweb\\temp
SessionTimeout=600
BusinessObjectsURL=http:// hostname:portnumber/InfoViewApp/logon.jsp
ContextsMaxCount=30
AllowedSwitchInBetween=true

Error log:
Java Runtime Environment (JRE) version 1.6 is not supported by this driver. Use the sqljdbc4.jar class library, which provides support for JDBC 4.0.

I am sure I am using the correct db credentials.

Any ideas? THanks

Can somebody tell me who uses Harvest? What corporations? I know AT&T, K-Mart use it.

Thanks!

I am running a query that returns multiple rows using HSQL. I only want the most current row so I added a group by statement and a MAX statement for the date/time. In problem resolution I have found that the group by is working but the MAX statement is giving me an error. Any ideas?

Query below

select harenvironment.environmentname,
harstate.statename,
harpackage.packagename,
harallusers.username,
harallusers.realname,
haritems.itemobjid,
haritems.itemname,
harpathfullname.pathfullname,
max(harversions.creationtime)

from harpackage

Inner Join harenvironment
on harenvironment.envobjid = harpackage.envobjid

Inner Join harstate
on harstate.stateobjid = harpackage.stateobjid

Inner Join harallusers
on harallusers.usrobjid = harpackage.creatorid

Inner Join harversions
on harversions.packageobjid = harpackage.packageobjid

Inner Join haritems
on haritems.itemobjid = harversions.itemobjid

Inner Join harpathfullname
on harpathfullname.itemobjid = haritems.parentobjid

WHERE HARENVIRONMENT.ENVISACTIVE = 'Y'

AND ( HARENVIRONMENT.ENVIRONMENTNAME LIKE 'EDW%'
OR HARENVIRONMENT.ENVIRONMENTNAME LIKE 'EMD%'
OR HARENVIRONMENT.ENVIRONMENTNAME LIKE 'HFDR%'
OR HARENVIRONMENT.ENVIRONMENTNAME LIKE 'MCWET%'
OR HARENVIRONMENT.ENVIRONMENTNAME LIKE 'FRED%' )

AND ( SUBSTR(HARPACKAGE.PACKAGENAME,4,10) = '_20120914_'
OR SUBSTR(HARPACKAGE.PACKAGENAME,5,10) = '_20120914_'
OR SUBSTR(HARPACKAGE.PACKAGENAME,6,10) = '_20120914_'
OR SUBSTR(HARPACKAGE.PACKAGENAME,7,10) = '_20120914_' )

GROUP BY harenvironment.environmentname,
harstate.statename,
harpackage.packagename,
harallusers.username,
harallusers.realname,
haritems.itemobjid,
haritems.itemname,
harpathfullname.pathfullname

ORDER BY haritems.itemobjid,
harversions.creationtime desc,
haritems.itemname,
harpackage.packagename;

I have performance problem with ClearCase over VPN.

I don't see problem with dynamic views on AIX. However, rebase/deliver for snapshot views on windows over VPN is extremely slow.

I would be interested in hearing if anyone's having the same issue and what are the solution.

Currently we are using cleracase version 8.