ej197us Posted October 17, 2017 Share Posted October 17, 2017 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 ticketlineinner 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.lineticketWhich work fine in webmin when I mnuually substitute vales. Trows Exceptionjava.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 ProblemMy Posrgresql version is 9.4My Jasper Studio Version is 6.4.3PGInterval 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 regardsEd Link to comment Share on other sites More sharing options...
reportdev Posted October 17, 2017 Share Posted October 17, 2017 org.postgresql.util.PGInterval can still be found in postgresql-9.4-1202.jdbc42.jardownload the jar from below path and use this in the build path. https://jdbc.postgresql.org/download/postgresql-9.4-1202.jdbc42.jar Link to comment Share on other sites More sharing options...
ej197us Posted October 18, 2017 Author Share Posted October 18, 2017 SOLVED: Placing the above jar file in MyReports solved the issue.Thank YouEd Link to comment Share on other sites More sharing options...
Recommended Posts
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 accountSign in
Already have an account? Sign in here.
Sign In Now