I think/hope this must be an easy question.

I try to have a simple connection to a mysql database.

Creating one for postgres was easy. But I just don't get why mysql doesn't work.

Maybe its a bug. I use xammp

Here're some detail:

com.mysql.jdbc.Driver

jdbc:mysql://localhost:3306/praxisboersesauber

name: root

pw:

there is no password, maybe thats the problem?

with same config it works well wit dbvusualizer and ireport and so on.

It's a project an it has to be finished in a few days, so I am a little bit desperate :/

Our_Org (single organizatin)

     SubA

          SubA1

          SubA2 

     SubB

          SubB1

          SubB2

In stead of getting Org structure info from LDAP and synchronize, we want the user to type-in the predefined org_name (i.e. SubA, or SubA1)  and authenticate the user into that org directly.

Anyone has done this or something similar? My thinking is to pass the org_id from login page to defaultOrganizationIfNotDetected in applicationContext-multiTenancy-security.xml...  Is it possible? How can it be done? Am I heading down the wrong path? Could someone point me to the right direction, please?  Thanks.

GET /jasperserver-pro/rest/resource/images/JRLogo?file=attachment HTTP/1.1

I entered into my browser:

http://jasperadmin:jasperadmin@localhost:8080/jasperserver/rest/resource/images/JRLogo?file=attachment   

as the example described, but instead of downloading the JRLogo file I was displayed the error message: 

request contains unsupported parameters

The only parameter I'm passing is file and the documentation specifically says that it is a parameter that can be passed here.  Is this functionality supported in the community version?

Any help would be appreciated, Thanks in advance.

check the below code. I am making webservice call to schedule a report to run after 5 mins. but this report is running immidiately. how to avoid that??

Thanks.

JobSimpleTrigger trigger = new JobSimpleTrigger();
            trigger.setOccurrenceCount(1);
            Calendar calendar = Calendar.getInstance();
            System.out.println("current calendar --->" + calendar) ;
            calendar.add(Calendar.MINUTE,5);
             System.out.println("After calendar --->" + calendar) ;
            trigger.setStartDate(calendar);
            trigger.setRecurrenceIntervalUnit(IntervalUnit.fromString(jr.getIntervalUnit()));
            job.setSimpleTrigger(trigger);

check the below code. I am making webservice call to schedule a report to run after 5 mins. but this report is running immidiately. how to avoid that??

Thanks.

JobSimpleTrigger trigger = new JobSimpleTrigger();
            trigger.setOccurrenceCount(1);
            Calendar calendar = Calendar.getInstance();
            System.out.println("current calendar --->" + calendar) ;
            calendar.add(Calendar.MINUTE,5);
             System.out.println("After calendar --->" + calendar) ;
            trigger.setStartDate(calendar);
            trigger.setRecurrenceIntervalUnit(IntervalUnit.fromString(jr.getIntervalUnit()));
            job.setSimpleTrigger(trigger);

when I tried to re-run the existing template , I got the below error in the jasperserver log.

2012-02-10 06:22:41,236 ERROR ViewAdhocReportAction,[ACTIVE] ExecuteThread: '4' for queue: 'weblogic.kernel.Default (self-tuning)':186 - error setting up repo
rt
java.lang.NullPointerException
        at com.jaspersoft.ji.semantic.service.SemanticDataService.rdq(SemanticDataService.java:832)
        at com.jaspersoft.commons.semantic.impl.SchemaImpl.getResourceObjectById(SchemaImpl.java:365)
 

Please help to resolve the issue.

$P{myCollection}.toString()

The string output from that looks like [1, 2, 3, 4]

I'd like to take that and convert it to something like:

WHERE myTableField IN ('1', '2', '3', '4')

This is similar to what Jasper seems to do in the report query anyway but I have a use case where I need to do this myself. I have this select for postgres that gets me close but it doesn't quite work:

select translate(translate(translate('[1, 2, 3, 4]', '[', ''''), ']', ''''), ', ', ',''') as value

Which outputs this in Postgres 9.1:

'1,'2,'3,'4'

I'm still missing the second quote on the inner numbers and I don't understand why because the last translate function should handle this correctly. I think anyway. Has anyone else done this?

I have a report with parameters using customized class. Report is working fine in i-report and jasper server reporsitory plugin too. 

I have added my .jar file that contains the class in "Add resources" section of server. But when I am running its throwing me an error saying "Error evaluating expression $P{dateUtils}.getEndDate( $P{DateChoice}, $P{Time_Interval}, $P{InputDate})". In the parameter I have specified the class which is com.redhat.eng.JasperDateUtils.

I am wondering why is it not working in japser server. Most probably, it is not able to get the classpath.

Please help...

I have a huge problem, when I run my report in iReport it works fine but when I run it in jasper it says the report is empty.

Any suggetions? Please Guys.

Thanks