Connecting to DB Error

[Somnath Mallick]

Hi Everyone,

I am trying to connect to DB (Oracle 10g) through a Java code. Please take a look at the code:

public static void main(String args[]) {
Connection connection = null;
BBADataPurger bBADataPurger = new BBADataPurger();

try {
Class.forName("oracle.jdbc.xa.client.OracleXADataSource");
connection = DriverManager.getConnection("jdbc:odbc:thin@10.10.34.11:1522:CAPS", "***", "***");
PurgingUtilConstants.setConnection(connection);
} catch (ClassNotFoundException classNotFoundException)
{
classNotFoundException.printStackTrace();
} catch (SQLException sQLException)
{
sQLException.printStackTrace();
}
bBADataPurger.StartUp();
}

But the problem is i am getting an error while connecting to the database:

java.sql.SQLException: [Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified
at sun.jdbc.odbc.JdbcOdbc.createSQLException(JdbcOdbc.java:6957)
at sun.jdbc.odbc.JdbcOdbc.standardError(JdbcOdbc.java:7114)
at sun.jdbc.odbc.JdbcOdbc.SQLDriverConnect(JdbcOdbc.java:3073)
at sun.jdbc.odbc.JdbcOdbcConnection.initialize(JdbcOdbcConnection.java:323)
at sun.jdbc.odbc.JdbcOdbcDriver.connect(JdbcOdbcDriver.java:174)
at java.sql.DriverManager.getConnection(DriverManager.java:582)
at java.sql.DriverManager.getConnection(DriverManager.java:185)
at telecom.co.nz.bba.eai.BBADataPurger.BBADataPurger.main(BBADataPurger.java:75)

Could you please tell me what's the problem here?

[Paul Sturrock]

[Microsoft][ODBC Driver Manager]

Looks like you are trying to use the JDBC-ODBC bridge. I can't see that anywhere in the code you've posted (unless its in BBADataPurger?) so you are maybe not running the code you think you are.

That being said, the code you are trying to run seems to be trying to use a DataSource, not a Driver, which won't work. Also, are you intending to use the XA driver?

[Jan Cumps]

Hi.

You are mixing up the oracle jdbc driver and the Sun jdbcodbc bridge.

This point out that you want to use Oracle jdbc driver:
oracle.jdbc.xa.client.OracleXADataSource

and this is a mix between jdbcodbc and Oracle jdbc url:
jdbc:odbc:thin@10.10.34.11:1522:CAP

Regards, Jan

[Paul types faster]

[Somnath Mallick]

So what changes do i have to make here? Should i change this:

jdbc:odbc:thin@10.10.34.11:1522:CAPS

or

oracle.jdbc.xa.client.OracleXADataSource

I am trying to connect to a database which is on the server from my local system. Its a strandalone java class.
Complete class is:

import java.sql.Connection;

import java.sql.DriverManager;
import java.sql.SQLException;
import java.util.ArrayList;
import javax.activation.DataSource;
import javax.annotation.Resource;
import nz.co.telecom.bba.eai.utils.jdbc.JDBCHelper;
import telecom.co.nz.bba.eai.BBADataPurgerUtils.BBADBPurgingUtil;
import telecom.co.nz.bba.eai.BBADataPurgerUtils.PurgingUtilConstants;

/**
 *
 * @author ar0015564
 */
public class BBADataPurger {
    
    static boolean success = false;
    Connection connection = null;


    public void StartUp() {

        System.out.println("BBADataPurger :: Started....");

        try {


            connection = PurgingUtilConstants.getConnection();

            System.out.println("BBADataPurger :: 2");

            System.out.println("BBADataPurger :: 4");
            ArrayList txIdList = BBADBPurgingUtil.getCompletedOrders();

            if (txIdList.size() != 0) {
                System.out.println("BBADataPurger :: TXid finding() 66");

                // convert into comma separated list
                String txIds = "";
                for (int i = 0; i < txIdList.size(); i++) {
                    System.out.println("BBADataPurger :: 6 TxId " + (String) txIdList.get(i));
                    if (i < txIdList.size() - 1) {
                        txIds += "'" + (String) txIdList.get(i) + "'" + ",";
                    } else {
                        txIds += "'" + (String) txIdList.get(i) + "'";
                    }
                }
                System.out.println("BBADataPurger :: Purging to be done for " + txIds);

                success = BBADBPurgingUtil.deleteCompletedOrders(txIds);


                System.out.println("BBADataPurger :: 5");
            }
        } catch (Exception exception) {
            exception.printStackTrace();
        } finally {
            JDBCHelper.close(null, null, connection);
        }
    }

    public static void main(String args[]) {
        Connection connection = null;
        BBADataPurger bBADataPurger = new BBADataPurger();
        
        try {
            Class.forName("oracle.jdbc.xa.client.OracleXADataSource");
            connection = DriverManager.getConnection("jdbc:odbc:thin@10.10.34.11:1522:CAPS", "bba", "bba");
            PurgingUtilConstants.setConnection(connection);
             bBADataPurger.StartUp();
        } catch (ClassNotFoundException classNotFoundException)
        {
            classNotFoundException.printStackTrace();
        } catch (SQLException sQLException)
        {
            sQLException.printStackTrace();
        }
       
    }
}

[Jan Cumps]

You can find both the neccessary driver class info and the url instructions at Oracle.

[Somnath Mallick]

Is using an XA an advisale way to go about this?

I changed my code to:

connection = DriverManager.getConnection("jdbc:oracle:thin:@10.10.34.11:1522:CAPSD", "***", "***");

and now i get the error:

java.sql.SQLException: No suitable driver found for jdbc:oracle:thin:@10.10.34.11:1522:CAPSD
        at java.sql.DriverManager.getConnection(DriverManager.java:602)
        at java.sql.DriverManager.getConnection(DriverManager.java:185)
        at telecom.co.nz.bba.eai.BBADataPurger.BBADataPurger.main(BBADataPurger.java:73)

[Jan Cumps]

Somnath Mallick wrote:....
and now i get the error:

java.sql.SQLException: No suitable driver found for jdbc:oracle:thin:@10.10.34.11:1522:CAPSD
        at java.sql.DriverManager.getConnection(DriverManager.java:602)
        at java.sql.DriverManager.getConnection(DriverManager.java:185)
        at telecom.co.nz.bba.eai.BBADataPurger.BBADataPurger.main(BBADataPurger.java:73)

Solution on same url as in my previous post.
Look for: Installation
How do I install the Thin driver?

[Somnath Mallick]

The solution given:

How do I install the Thin driver?
Put the jar files in a convenient location and include the appropriate jar files in your classpath. See What are all these files for? to determine which files you need.

I have ojdbc14.jar and classes12.jar added in my classpath already. Are there any more jars to be added. I checked the list given in your link. All are different version of the two jars i already have!

[Jan Cumps]

Only put the correct .jar in the classpath.

Class.forName("oracle.jdbc.xa.client.OracleXADataSource");

How sure are you about this part of your code?

[Paul Sturrock]

Those are very old versions of the driver - are you running a 1.4 JDK or below? If not you'll need the correct files (see Jan's link)

[Somnath Mallick]

Pretty much sure. Because i used this many times in other places where i was able to connect and work on DB's.

[Somnath Mallick]

Paul Sturrock wrote:Those are very old versions of the driver - are you running a 1.4 JDK or below? If not you'll need the correct files (see Jan's link)

Could you please let me know what are the latest versions of the jar? I have to catch a flight in 2 hours. and i am already running late. I will download them when i get home!

[Paul Sturrock]

Somnath Mallick wrote:Pretty much sure. Because i used this many times in other places where i was able to connect and work on DB's.

Its odd to see someone load a DataSource this way. More normally you would register a Driver with the DriveManager not a DataSource. And using the XA tends to be the exception rather than the rule. Do you need an XA driver?

[Paul Sturrock]

Somnath Mallick wrote:
Could you please let me know what are the latest versions of the jar? I have to catch a flight in 2 hours. and i am already running late. I will download them when i get home!

I'm not sure I could answer this any better than Oracle do in Jan's link. Have a read of those FAQs.

[Somnath Mallick]

Could you please show me an example which shows a proper way of getting data from a DataSource. I have loaded XA drivers this way in quite a few codes and they all worked without any issues.

[Jan Cumps]

I'm getting a bit lost.
Do you still have issues with the original code from the first post?
Or is the original code now working, and do you want to go a step further?

Regards, Jan

[Somnath Mallick]

The code is not working!

And would definitely like a step further!

[Jan Cumps]

What if you take a brand new start?

- get the correct version of the jar file for matches your database version, and stop using any other Oracle JDBC .jar
- register the correct driver. (see also the linc toOracle basic instructions below.
- use the correct url to connect to your Oracle database.
- test.

Oracle's First Steps in JDBC.

I have loaded XA drivers this way in quite a few codes and they all worked without any issues.

We don't believe that anymore

Regards, Jan