JDBC DriverType & JTA

[Nitin Katdare]

Hello All,
I have two questions, please help
1) Can we check programatically which type of driver we are using (out of JDBC 4 types of drivers)?
2) Does JDBC internally uses JTA?

Thanks.

[Wendy Gibbons]

well this was all I could find:

                DBConnection local = new DBConnection();
		Connection connection = local.getConnection();
		Properties clientInfo = connection.getClientInfo();
		for(Object key : clientInfo.keySet())
		{
			if( key instanceof String )
			{
				String keyString = (String) key;
				System.out.println(key + ":" + clientInfo.getProperty(keyString));
			}
			else
			{
				System.out.println(key);
			}

		}
		DatabaseMetaData metaData = connection.getMetaData();
		System.out.println("major version     :" + metaData.getDatabaseMajorVersion());
		System.out.println("minor version     :" + metaData.getDatabaseMinorVersion());
		System.out.println("db name           :" + metaData.getDatabaseProductName());
		System.out.println("db product version:" + metaData.getDatabaseProductVersion());

produced the output
major version :10
minor version :4
db name :Apache Derby
db product version:10.4.2.0 - (689064)

[Paul Clapham]

Nitin Katdare wrote:1) Can we check programatically which type of driver we are using (out of JDBC 4 types of drivers)?

Why would you want to do that? Or to put it another way, why would you want your program to do something differently if you were using a Type 2 driver versus a Type 4 driver?