4 Replies Latest reply on May 1, 2006 10:38 AM by Jason Levine

    Looking for JBossTM  4.2 JDBC Tutorials

    Mark Little Master

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

        • 1. Re: Looking for JBossTM  4.2 JDBC Tutorials
          Tomo Izumi Newbie

          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
            Mark Little Master

            You should look at the Bank example in the trailmap.

            • 3. Re: Looking for JBossTM  4.2 JDBC Tutorials
              Tomo Izumi Newbie

              Thanks, I found it.

              • 4. Re: Looking for JBossTM  4.2 JDBC Tutorials
                Jason Levine Newbie

                Where is the bank example please?