Hello,
I’m using J2EEConnectionPool from tomcat 7 Datasource. But when I create SQLContainer using this datasource I’m unable to use Container Filters or Container Orderby. When I use the same code with SimpleJDBCConnectionPool the filtering and sorting works. Do you know why this happens? Is the sorting and filtering only supported by SimpleJDBCConnectionPool. Both the datasource and SimpleJDBCConnectionPool connects to the same MySQL database.
Thanks,
Jacob
Code
JDBCConnectionPool pool = new J2EEConnectionPool(“java:comp/env/jdbc/ossmtoolweb”);
Unfortunately it’s really hard to help without some more information. In what way doesn’t filtering or sorting work when using J2EEConnectionPool? Do you get exceptions?
I don’t see how switching between ConnectionPool implementations would affect filtering or sorting without also affecting everything else.
My DataSource is defined as Spring Bean in context xml and autowired in the vaadin application.
(Autowiring works since the test code for the connection works)
The Table with the J2EEConnectionPool works in case above but when I uncomment the line
I am wondering that it seems that nobody else run into that problem.
Can somebody give me a hint if there is any error in my example code ?
Can anybody provide me a running example with a SQLContainer, J2EEConnectionPool and Filtering support example ?