-
1. Re: Looking for JBossTM 4.2 JDBC Tutorials
chanta Apr 28, 2006 5:19 AM (in response to marklittle)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) -
2. Re: Looking for JBossTM 4.2 JDBC Tutorials
marklittle Apr 28, 2006 5:53 AM (in response to marklittle)You should look at the Bank example in the trailmap.
-
3. Re: Looking for JBossTM 4.2 JDBC Tutorials
chanta Apr 30, 2006 10:22 PM (in response to marklittle)Thanks, I found it.
-
4. Re: Looking for JBossTM 4.2 JDBC Tutorials
jlevine47 May 1, 2006 10:38 AM (in response to marklittle)Where is the bank example please?