scphantm

got it. i see now its distributed with jre 5. switched it and all is well. now back to my normal problem, you think this approach with a custom data source is the way to go?

im trying to get the custom datasource examples to deploy. when i restart the server i get class version errors on the new class files. what version of the JVM is this built with? im using jvm 6 for everything so i would imagine it should work

im researching the custom datasource code thats distributed with the server. if i use the hibernate example, how exactly could i pass the name of the role that the user is a member of to the HibernateDataSourceService class? it looks like if i accomplish that then i can simply define all my databases in the application context file of my datasource and have the roles in jasperserver match. if i can somehow pass the data source the role name, i should have it right?

the way my system works is i need to have a report that can run against about 100 or so identical databases. when the user logs in, jasperserver has to associate a specific data source to that user and when a report is run use that data source thats specific to the user for their reports. that way i can have one instance of jasperserver running several hundred user accounts. is that possible?