declarative transaction via JDBC

[chenrici]

Question: how are you testing?
The reason i am asking = the Transactional Proxy - your case "pmis1" - needs to be referenced, where the bean "userLogic", if you want transactional behaviour.

In the following a TestCase, which works fine ... eventually selecting from the database manually, to check if anything is there ;-)
So the connection stuff was really misleading, sorry about that...
The testcase works both against SingleConnectionDataSource and DriverManagerDataSource.


import junit.framework.TestCase;

import org.springframework.context.support.FileSystemXmlA pplicationContext;
import org.springframework.dao.DataAccessException;

public class TestInsert extends TestCase
{

private FileSystemXmlApplicationContext ctx;
private JdbcUser userLogic;
/*
* @see TestCase#setUp()
*/
protected void setUp() throws Exception
{
super.setUp();
String path[] = {"/war/WEB-INF/applicationContext.xml"};
ctx = new FileSystemXmlApplicationContext(path);
ctx.refresh();
Object obj = ctx.getBean("pmis1"); // and not userLogic
if (!(obj instanceof JdbcUser))
{
throw new Exception("Bean Configuration wrong");
}
userLogic = (JdbcUser) obj;
}

public void testInsert() throws Exception
{
try {
final User aUser = new User();
aUser.setName("Some name");
aUser.setPasswd("Some Passwd");
userLogic.storeUsers(aUser);
fail("Unexpected");
} catch (DataAccessException e)
{
System.out.println(e.toString());
// Ok, but test some more
}
}

/*
* @see TestCase#tearDown()
*/
protected void tearDown() throws Exception
{
super.tearDown();
ctx = null;
userLogic = null;
}

}

[chenrici]

BTW: the test output looked as follows
<snip>
[junit] 01.11.2004 14:52:14 org.springframework.jdbc.object.RdbmsOperation compile
[junit] INFO: RdbmsOperation with SQL [INSERT INTO testusers VALUES(?,?)] compiled
[junit] 01.11.2004 14:52:14 org.springframework.jdbc.support.SQLErrorCodesFact ory getErrorCodes
[junit] INFO: Looking up default SQLErrorCodes for DataSource
[junit] 01.11.2004 14:52:14 org.springframework.jdbc.support.SQLErrorCodesFact ory getErrorCodes
[junit] INFO: Database product name found in cache for DataSource [org.springframework.jdbc.datasource.DriverManagerD ataSource@9be79a]. Name is 'Oracle'.
[junit] 01.11.2004 14:52:14 org.springframework.jdbc.object.RdbmsOperation compile
[junit] INFO: RdbmsOperation with SQL [INSERT INTO testusers1 VALUES(?,?)] compiled
[junit] 01.11.2004 14:52:14 org.springframework.jdbc.support.SQLErrorCodeSQLEx ceptionTranslator logTranslation
[junit] WARNUNG: Translating SQLException with SQLState '42000' and errorCode '942' and message [ORA-00942: table or view does not exist
[junit] ]; SQL was [INSERT INTO testusers1 VALUES(?,?)] for task [executing PreparedStatementCallback [PreparedStatementCreatorFactory.PreparedStatementC reatorImpl: sql=[INSERT INTO testusers1 VALUES(?,?)]: params=[Some name,Some Passwd]]]
[junit] .From prgm: org.springframework.jdbc.BadSqlGrammarException: Bad SQL grammar [INSERT INTO testusers1 VALUES(?,?)] in task 'executing PreparedStatementCallback [PreparedStatementCreatorFactory.PreparedStatementC reatorImpl: sql=[INSERT INTO testusers1 VALUES(?,?)]: params=[Some name,Some Passwd]]'; nested exception is java.sql.SQLException: ORA-00942: table or view does not exist
[junit] 01.11.2004 14:52:14 org.springframework.transaction.interceptor.Transa ctionInterceptor onThrowable
[junit] INFO: Invoking rollback for transaction on method 'storeUsers' in class [JdbcUser] due to throwable [org.springframework.jdbc.BadSqlGrammarException: Bad SQL grammar [INSERT INTO testusers1 VALUES(?,?)] in task 'executing PreparedStatementCallback [PreparedStatementCreatorFactory.PreparedStatementC reatorImpl: sql=[INSERT INTO testusers1 VALUES(?,?)]: params=[Some name,Some Passwd]]'; nested exception is java.sql.SQLException: ORA-00942: table or view does not exist
[junit] ]
[junit] 01.11.2004 14:52:14 org.springframework.transaction.support.AbstractPl atformTransactionManager rollback
[junit] INFO: Initiating transaction rollback
[junit] org.springframework.jdbc.BadSqlGrammarException: Bad SQL grammar [INSERT INTO testusers1 VALUES(?,?)] in task 'executing PreparedStatementCallback [PreparedStatementCreatorFactory.PreparedStatementC reatorImpl: sql=[INSERT INTO testusers1 VALUES(?,?)]: params=[Some name,Some Passwd]]'; nested exception is java.sql.SQLException: ORA-00942: table or view does not exist
[junit] Time: 1,344
[junit] OK (1 test)
<snip>