megha.kumar

I have a table "HIS_RAW" with fields -TIMESTAMP,POINTID,VALUE .This table has historical average value stored for different datapoints. Iwant to query the table to get value of different pointid say {m1,m2,m3,m4} in the below format TIMESTAMP -VALUE OF POINTID1- VALUE OF POINTID2 ---VALUE OF POINTID3 If i use group on pointid,I get data in format : pointid1 timestamp value timestamp value timestamp value pointid2 timestamp value timestamp value

I am new to jaspersoft.I installed TIBCO Jaspersoft Studio.In project explorer->Myreport->Data adapter. I entered the following : Name: New adpter1 JDBC driver :org.hsqldb.jdbc.driver jdbc url :jdbc:hsqldb:hsqldb://localhost --->>>>not sure if this is correect username and password I gave to the oracle system of my database where i connect when i click on test connection it throws exception reason:java.sql.SQLException:Database lock acquisition failure :lockFile:org.hsqldb.persist.lockfile . Dont have any idea how to proceed further