Looking for JBossTM 4.2 JDBC Tutorials

[marklittle]

Depends what you are after, but you should probably look at the binary rather than the source.

[chanta]

Mark,

Thank you for your reply.
I am insterested in 1. transaction management and 2. connection pooling
on stand alone JBossTM. I am not using JBoss App server.
My installation option was "ant jta"
On page 30 of "JBoss Transactions API 4.2 Programmers Guide"(JBTA-PG-3/22/06),
JDBC example,I having a hard time understanding this sample because it's a partially written Java code.

I am trying to write my own sample code with Oracle 9i and,
my code looks as follows:

String url="jdbc:oracle:thin:@127.0.0.1:1521:orcl";
Properties p = System.getProperties();
p.put("jdbc.drivers","com.arjuna.ats.jdbc.TransactionalDriver");

Connection conn = null;
DriverManager.registerDriver(new TransactionalDriver());
Properties dbProps = new Properties();
dbProps.put(TransactionalDriver.userName,"jbosstm");
dbProps.put(TransactionalDriver.password,"jbosstm");

//this class really exists?
dbProps.put(TransactionalDriver.dynamicClass,"com.arjuna.ats.internal.jdbc.drivers.oracle_8_1_6");

conn = DriverManager.getConnection(url,dbProps);

I am getting No suitable driver exception when calling "DriverManager.getConnection(url,dbProps)"

java.sql.SQLException: No suitable driver
at java.sql.DriverManager.getConnection(DriverManager.java:532)
at java.sql.DriverManager.getConnection(DriverManager.java:140)
at test.TestJDBCSample.main(TestJDBCSample.java:37)

[marklittle]

You should look at the Bank example in the trailmap.

[chanta]

Thanks, I found it.

[jlevine47]

Where is the bank example please?