Problem described fully here: http://stackoverflow.com/questions/7177662/running-jasper-reports-against-an-in-memory-h2-datasource
I have two datasources; one is a BasicDataSource, and one is a TransactionalAwareDataSourceProxy. I'm using both to build reports from Jasper, and I send in .getConnection() from both data sources to run the reports. HOWEVER, any queries run against the TransactionalAwareDataSourceProxy are case sensitive, even though the startup parameter said it shouldn't be! This breaks my reports. Here's my database startup URL: jdbc:h2:mem:testDb;MODE=PostgreSQL;IGNORECASE=TRUE;DATABASE_TO_UPPER=false What's going on here? -- You received this message because you are subscribed to the Google Groups "H2 Database" group. To post to this group, send email to [email protected]. To unsubscribe from this group, send email to [email protected]. For more options, visit this group at http://groups.google.com/group/h2-database?hl=en.
