Jump to content
Changes to the Jaspersoft community edition download ×

PGInterval Error


ej197us

Recommended Posts

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

 

 

Link to comment
Share on other sites

  • Replies 2
  • Created
  • Last Reply

Top Posters In This Topic

Top Posters In This Topic

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now

×
×
  • Create New...