PGInterval Error

[ej197us]

Hi,

I have this query:

select custmaster.cmname, custmaster.id, custsp.spseq, custsp.spname, assets.astseq, assets.astalias, ticketline.*,   concat(concat(replace(linedatestamp, '.', '-'),' '), linetimestamp)  as linestamp, to_timestamp(replace (lineleave,'.','-'),'YYYY-MM-DD HH24:MI:SS') - to_timestamp(replace (linearrive,'.','-'),'YYYY-MM-DD HH24:MI:SS') as onjob   from ticketline
inner join  custmaster on(ticketline.id = custmaster.id)inner join custsp on(ticketline.linecustsp = custsp.spseq)

inner join assets on(ticketline.lineastseq = assets.astseq)

where $X{BETWEEN,ticketline.LINEDATESTAMP,TICKETLINE_From_Date,TICKETLINE_To_Date} and
$X{EQUAL,ticketline.LINECUSTSP,TICKETLINE_Service_Provider}
order by assets.astalias, ticketline.lineticket

Which work fine in webmin when I mnuually substitute vales.

 

Trows Exception

java.lang.ClassNotFoundException: org.postgresql.util.PGInterval cannot be found by net.sf.jasperreports_6.4.3.final --- net.sf.jasperreports.engine.design.JRDesignField@8e4c33    Technician_Activity.jrxml    /MyReports    line 0    JRXML Problem

My Posrgresql version is 9.4

My Jasper Studio Version is 6.4.3

PGInterval is missing, is there a jar that needs to be updated? I cant find it so far or is there a differenet method to get seconds?

Best regards

Ed

 

 

[reportdev]

 

org.postgresql.util.PGInterval can still be found in postgresql-9.4-1202.jdbc42.jar

download the jar from below path and use this in the build path. 

https://jdbc.postgresql.org/download/postgresql-9.4-1202.jdbc42.jar

 

[ej197us]

SOLVED: Placing the above jar file in MyReports solved the issue.

Thank You

Ed