What specific operation are you trying to do? Since you don't have autocommit
set to true, you may be having transaction problems.
I found it helpful to create a Test.java file with the same operations
as creating the datasource (with the same parameters), a connection and
doing a sample select statement. It helped to confirm where errors
might be happening.
JOEL VOGT wrote:
> later on in a servlet I have
>
> javax.sql.DataSource dataSource = servlet.findDataSource(null);
> con = dataSource.getConnection();
>
> When I try to use this however, I get an java.sql exception :
> 'no data found'