jdbc 2 Answer(s) 4 years and 10 months ago
Posted in : JDBC
View Answers
July 18, 2008 at 1:40 PM
Question: Is the JDBC-ODBC Bridge multi-threaded? Answer: No. The JDBC-ODBC Bridge does not support concurrent access from different threads. The JDBC-ODBC Bridge uses synchronized methods to serialize all of the calls that it makes to ODBC. Multi-threaded Java programs may use the Bridge, but they won't get the advantages of multi-threading. In addition, deadlocks can occur between locks held in the database and the semaphore used by the Bridge. We are thinking about removing the synchronized methods in the future. They were added originally to make things simple for folks writing Java programs that use a single-threaded ODBC driver.
Hope above question will help you.
Thanks
July 18, 2008 at 1:41 PM
Answer:
No. The JDBC-ODBC Bridge does not support concurrent access from different threads. The JDBC-ODBC Bridge uses synchronized methods to serialize all of the calls that it makes to ODBC. Multi-threaded Java programs may use the Bridge, but they won?t get the advantages of multi-threading.
JDBC JDBC save a data in the database I need a code to save a data... between java and mysql using JDBC and saves the data into the database.
import... con = null;
String url = "jdbc:mysql://localhost:3306/";
String db
JDBC JDBC code to save a data in the database I need a code to save... the connection between java and mysql using JDBC and saves the data into the database...!");
Connection con = null;
String url = "jdbc:mysql://localhost:3306/";
String db
jdbc
how can we call stored procedure using jdbc how can we call stored procedure using jdbc
Call a Stored Procedure using...();
For more information, visit the following link:
JDBC call Stored Procedure
jdbc
how can we set transaction level through jdbc api how can we set transaction level through jdbc api
Use Connection.setTransactionIsolation(int) to set the desired tansaction level, which takes one of the 5 arguments
jdbc
jdbc hey sir i just wanna have some ppt on jdbc coz have my exams next week and i have not attended any classes coz of job... I m studyng frm niit
jdbc
jdbc I can't run my jdbc program because it has error in this line:
public static void main(String[] args)
the error is:illegal static declaration in inner class
would you please let me whats the problem?
regards
jdbc
using jdbc connection
import java.sql.*;
public class CreateTable... = DriverManager.getConnection("jdbc:odbc:student");
Class.forName
jdbc
jdbc i had written jdbc connection in method and i need to get connection in another class?
import java.sql.*;
class... driver = "com.mysql.jdbc.Driver";
String url = "jdbc:mysql://localhost:3306/test
jdbc
();
Connection conn = DriverManager.getConnection("jdbc:mysql://localhost... information, visit the following link:
JDBC Tutorials
jdbc
how can we set transaction level through jdbc api how can we set transaction level through jdbc api
Use Connection.setTransactionIsolation(int) to set the desired tansaction level, which takes one of the 5 arguments
jdbc
jdbc how to update int values of ms-access in jdbc program?
In MS Access database, use Number data type for int values.
import... =DriverManager.getConnection("jdbc:odbc:access","","");
Statement st=null;
st
JDBC - JDBC JDBC - limitations of jdbc What are the limitations of JDBC
JDBC
retrieve the value from database into dropdown list using JDBC SQL 2005 How to retrieve the value from database into dropdown list using JDBC &...").newInstance();
String connectionURL = "jdbc:mysql://localhost:3306/test";;
Connection
JDBC
JDBC write a JDBC program to display the result of any query on a student table in a JTable component.
import java.awt....").newInstance();
Connection con = DriverManager.getConnection("jdbc:mysql://localhost
jdbc
the Connection.setTransactionIsolation(int level) method isolation level can be set in JDBC. the method can
jdbc
define transactions define transactions
Whenever a connection is created by using the JDBC, then by default it is in auto- commit mode. This means that SQL statement will be automatically committed immediately after
jdbc
logical group of data with a number of columns. JDBC ResultSet Example
Stored
jdbc
level can be set in JDBC. the method can accept any of the arguments listed below
jdbc
what are different type of locks what are different type of locks
Types of locks in JDBC:
Row and Key Locks:: It is useful when updating the rows (update, insert or delete operations), as they increase concurrency