use JDBC to execute non-standard features that my DBMS provides.
Can I use JDBC to execute non-standard features that my DBMS provides?
View Answers
November 15, 2010 at 4:46 PM
Hi friends,
The answer is a qualified yes. As discussed under SQL Conformance: "One way the JDBC API deals with this problem is to allow any query string to be passed through to an underlying DBMS driver. This means that an application is free to use as much SQL functionality as desired, but it runs the risk of receiving an error on some DBMSs. In fact, an application query may be something other than SQL, or it may be a specialized derivative of SQL designed for specific DBMSs (for document or image queries, for example)." Clearly this means either giving up portability or checking the DBMS curently used before invoking specific operations.
Thanks.
Related Tutorials/Questions & Answers:
use JDBC to execute non-standard features that my DBMS provides.
use JDBC to execute non-standard features that my DBMS provides. Can I use JDBC to execute non-standard features that my DBMS provides
use JDBC to execute non-standard features that my DBMS provides. Can I use JDBC to execute non-standard features that my DBMS provides
the isolation levels supported by my DBMS
the isolation levels supported by my DBMS How can I determine the isolation levels supported by my DBMS
the isolation levels supported by my DBMS How can I determine the isolation levels supported by my DBMS
Advertisements
JDBC features
JDBC features In this section we will see the features of JDBC. The Java Database Connectivity or JDBC for short is the API available in Java for accessing... of JDBC JDBC API provides the methods to access the data base easily
JDBC features In this section we will see the features of JDBC. The Java Database Connectivity or JDBC for short is the API available in Java for accessing... of JDBC JDBC API provides the methods to access the data base easily
steps required to execute a query in JDBC
steps required to execute a query in JDBC What are the steps required to execute a query in JDBC
steps required to execute a query in JDBC What are the steps required to execute a query in JDBC
JDBC 4 Features, JDBC 4.0 Features
.style1 { margin-left: 40px; } JDBC 4 Features In this section we are discussing about the new features of JDBC 4.0. Jdbc 4.0 ships with Java SE 6..., SQL XML data type etc. Here are some features of jdbc 4.0ADS_TO_REPLACE_1 1
.style1 { margin-left: 40px; } JDBC 4 Features In this section we are discussing about the new features of JDBC 4.0. Jdbc 4.0 ships with Java SE 6..., SQL XML data type etc. Here are some features of jdbc 4.0ADS_TO_REPLACE_1 1
New Features in JDBC 4.0
New Features in JDBC 4.0 ... Database session can be connected by JDBC API which can execute the Queries to get... The three most important features of Driver and Connection Management in JDBC
New Features in JDBC 4.0 ... Database session can be connected by JDBC API which can execute the Queries to get... The three most important features of Driver and Connection Management in JDBC
JDBC Execute Query
JDBC Execute Query The Execute Query in JDBC retrieve the elements from a database. In this Tutorial we want to describe you a code that helps you to understand JDBC Execute Query
JDBC Execute Query The Execute Query in JDBC retrieve the elements from a database. In this Tutorial we want to describe you a code that helps you to understand JDBC Execute Query
JDBC Execute Update Example
JDBC Execute Update Example JDBC... a simple example from JDBC Execute update Example. In this Tutorial we want to describe you a code that helps you in understanding JDBC Execute update Example
JDBC Execute Update Example JDBC... a simple example from JDBC Execute update Example. In this Tutorial we want to describe you a code that helps you in understanding JDBC Execute update Example
My sql - JDBC
My sql hi, I have a table in MySql, having fields, emp_id,emp_name,emp_vertical,emp_supervisor. i need a JDBC program with driver mangager... out. i need insert and update queries. Hi friend, For JDBC
My sql hi, I have a table in MySql, having fields, emp_id,emp_name,emp_vertical,emp_supervisor. i need a JDBC program with driver mangager... out. i need insert and update queries. Hi friend, For JDBC
JDBC Execute Statement
JDBC Execute Statement JDBC Execute Statement is used to execute SQL Statement, The Execute... a database. In this Tutorial, the code illustrates an example from JDBC Execute
JDBC Execute Statement JDBC Execute Statement is used to execute SQL Statement, The Execute... a database. In this Tutorial, the code illustrates an example from JDBC Execute
get UnsatisfiedLinkError when I try to use my JDBC driver.
get UnsatisfiedLinkError when I try to use my JDBC driver. Why do I get UnsatisfiedLinkError when I try to use my JDBC driver
get UnsatisfiedLinkError when I try to use my JDBC driver. Why do I get UnsatisfiedLinkError when I try to use my JDBC driver
Features of JDBC
of database using JDBC. Features of JDBC Following are the features of JDBC 1... .style1 { text-align: center; } Feature A JDBC JDBC JDBC java database connectivity (JDBC) is an API (Application Programming Interface
of database using JDBC. Features of JDBC Following are the features of JDBC 1... .style1 { text-align: center; } Feature A JDBC JDBC JDBC java database connectivity (JDBC) is an API (Application Programming Interface
Help on JDBC and my SQL 5 database - JDBC
Help on JDBC and my SQL 5 database Dear Sir, I had create a statement for the JDBC as shown below: try... the connection c = DriverManager.getConnection ("jdbc:mysql
Help on JDBC and my SQL 5 database Dear Sir, I had create a statement for the JDBC as shown below: try... the connection c = DriverManager.getConnection ("jdbc:mysql
What is the return type of execute mehtod in jdbc - Java Beginners
. My interview asked wat is return type of execute() in jdbc . should...What is the return type of execute mehtod in jdbc Hi Deepak, u... java.sql.Statement or java.sql.PreparedStatement or java.sql.CallableStatement, the execute
. My interview asked wat is return type of execute() in jdbc . should...What is the return type of execute mehtod in jdbc Hi Deepak, u... java.sql.Statement or java.sql.PreparedStatement or java.sql.CallableStatement, the execute
Features of JDBC 4.0
directly with the JDBC API. The new features availble in J2SE 1.5 added ease-of-development features in JDBC 4 In addition to ease-of-use, JDBC 4 introduces... Features of JDBC 4.0 JDBC 4
directly with the JDBC API. The new features availble in J2SE 1.5 added ease-of-development features in JDBC 4 In addition to ease-of-use, JDBC 4 introduces... Features of JDBC 4.0 JDBC 4
ModuleNotFoundError: No module named 'dbms'
ModuleNotFoundError: No module named 'dbms' Hi, My Python program is throwing following error: ModuleNotFoundError: No module named 'dbms' How to remove the ModuleNotFoundError: No module named 'dbms' error
ModuleNotFoundError: No module named 'dbms' Hi, My Python program is throwing following error: ModuleNotFoundError: No module named 'dbms' How to remove the ModuleNotFoundError: No module named 'dbms' error
ModuleNotFoundError: No module named 'dbms'
ModuleNotFoundError: No module named 'dbms' Hi, My Python program is throwing following error: ModuleNotFoundError: No module named 'dbms' How to remove the ModuleNotFoundError: No module named 'dbms' error
ModuleNotFoundError: No module named 'dbms' Hi, My Python program is throwing following error: ModuleNotFoundError: No module named 'dbms' How to remove the ModuleNotFoundError: No module named 'dbms' error
i need project for shopping cart in struts 1 with the oracle database and give clear explanation for how to execute it in my eclipse
i need project for shopping cart in struts 1 with the oracle database and give clear explanation for how to execute it in my eclipse i need... explanation for how to execute it in my eclipse and where to copy the files as i am
i need project for shopping cart in struts 1 with the oracle database and give clear explanation for how to execute it in my eclipse i need... explanation for how to execute it in my eclipse and where to copy the files as i am
How to execute my query fast..When A date filter is there in a query it takes more time for execution.?
How to execute my query fast..When A date filter is there in a query it takes more time for execution.? When A date filter is there in a query... in 30 seconds with 5000 records... what is the problem ... how to execute my query
How to execute my query fast..When A date filter is there in a query it takes more time for execution.? When A date filter is there in a query... in 30 seconds with 5000 records... what is the problem ... how to execute my query
Insert option does not work in my jstl... - JDBC
Insert option does not work in my jstl... I have problem with this jstl code... This will extract and displays details from xml... But i cant able to store that values in a database... Pls solve my problem...... Joe
Insert option does not work in my jstl... I have problem with this jstl code... This will extract and displays details from xml... But i cant able to store that values in a database... Pls solve my problem...... Joe
Features
Features Give me java1.6 features with examples? Please visit the following links: Java 1.6 features Some Examples of Java 1.6
Features Give me java1.6 features with examples? Please visit the following links: Java 1.6 features Some Examples of Java 1.6
The required JDBC drivers to establish connectivity to my database part of the JDK.
The required JDBC drivers to establish connectivity to my database part of the JDK. Are all the required JDBC drivers to establish connectivity to my database part of the JDK
The required JDBC drivers to establish connectivity to my database part of the JDK. Are all the required JDBC drivers to establish connectivity to my database part of the JDK
JDBC - JDBC
bridge provides JDBC API access via one or more ODBC drivers. Note that some...-enabled driver translates JDBC API calls into a DBMS-independent net protocol...explanation of JDBC drivers Need tutorial on JDBC driversThanks
bridge provides JDBC API access via one or more ODBC drivers. Note that some...-enabled driver translates JDBC API calls into a DBMS-independent net protocol...explanation of JDBC drivers Need tutorial on JDBC driversThanks
DBMs - SQL
Entity Relationship Diagram (ERD). Use ONLY UML NOTATION AS SHOWN IN THE TEXT... the output (6(a) until 6 (j) 9 ** TAKE NOTE THAT YOU HAVE TO USE TR
Entity Relationship Diagram (ERD). Use ONLY UML NOTATION AS SHOWN IN THE TEXT... the output (6(a) until 6 (j) 9 ** TAKE NOTE THAT YOU HAVE TO USE TR
Isolation level is used by the DBMS.
Isolation level is used by the DBMS. What isolation level is used by the DBMS when inserting, updating and selecting rows from a database
Isolation level is used by the DBMS. What isolation level is used by the DBMS when inserting, updating and selecting rows from a database
hi, Everyone ,i'm learning jdbc, i got an nullpointerexception when execute this program.
hi, Everyone ,i'm learning jdbc, i got an nullpointerexception when execute this program. ConnectionProvider.java import java.util.*; import... class=oracle.jdbc.driver.OracleDriver url=jdbc:oracle:thin:@localhost:1521:xe user
hi, Everyone ,i'm learning jdbc, i got an nullpointerexception when execute this program. ConnectionProvider.java import java.util.*; import... class=oracle.jdbc.driver.OracleDriver url=jdbc:oracle:thin:@localhost:1521:xe user
Database Connectivity Example In Java
a connection between the database and Java program Java provides the JDBC API... source JDBC provides a JDBC-to-ODBC bridge. Driver Manager acts as a connection... the DBMS can understand. JDBC drivers (either commercial or free) are generally
a connection between the database and Java program Java provides the JDBC API... source JDBC provides a JDBC-to-ODBC bridge. Driver Manager acts as a connection... the DBMS can understand. JDBC drivers (either commercial or free) are generally
JDBC Training, Learn JDBC yourself
Types, JDBC Versions From First To Latest, New Features in JDBC 4.0.... A large character data file can be stored as CLOB type. JDBC provides... you how to use JDBC's rich data type BLOB. The BLOB type stores/retreives large
Types, JDBC Versions From First To Latest, New Features in JDBC 4.0.... A large character data file can be stored as CLOB type. JDBC provides... you how to use JDBC's rich data type BLOB. The BLOB type stores/retreives large
Ask DBMS Questions online
Ask DBMS Questions online DBMS stands for Data Base Management System (DBMS) is a set of computer programs that controls the creation, organization
Ask DBMS Questions online DBMS stands for Data Base Management System (DBMS) is a set of computer programs that controls the creation, organization
Advanced DBMS questions
Advanced DBMS questions Five company/organization that involves in SQL Server database migration. what is the Transaction Recovery Method. What does Cloud Computing contributes in the RDBMS? Importance? (adsbygoogle
Advanced DBMS questions Five company/organization that involves in SQL Server database migration. what is the Transaction Recovery Method. What does Cloud Computing contributes in the RDBMS? Importance? (adsbygoogle
New features in PHP 5.5
New features in PHP 5.5 - The latest version of PHP version 5.5 provides many news features for the development of application in PHP framework The PHP 5.5.... Which provides great performance enhancements. 8. Now you can use the list
New features in PHP 5.5 - The latest version of PHP version 5.5 provides many news features for the development of application in PHP framework The PHP 5.5.... Which provides great performance enhancements. 8. Now you can use the list
JSF Features
JSF Features JSF is a rich featured framework of JAVA technology. JSF provides a set of standard features that makes it a powerful and standard among the existing
JSF Features JSF is a rich featured framework of JAVA technology. JSF provides a set of standard features that makes it a powerful and standard among the existing
Database Management System (DBMS)
Database Management System (DBMS) A Database Management System (DBMS) sometimes called a database manager or database system is a set... or entities to easily access and use the data from database. An excellent
Database Management System (DBMS) A Database Management System (DBMS) sometimes called a database manager or database system is a set... or entities to easily access and use the data from database. An excellent
Features of EJB 3.0
Features of EJB 3.0 Now its time to look over the new features of EJB 3.0 that provides some... interface. Made use of java annotations. Simplifies APIs to make flexible
Features of EJB 3.0 Now its time to look over the new features of EJB 3.0 that provides some... interface. Made use of java annotations. Simplifies APIs to make flexible
ModuleNotFoundError: No module named 'execute'
ModuleNotFoundError: No module named 'execute' Hi, My Python... 'execute' How to remove the ModuleNotFoundError: No module named 'execute... to install padas library. You can install execute python with following command
ModuleNotFoundError: No module named 'execute' Hi, My Python... 'execute' How to remove the ModuleNotFoundError: No module named 'execute... to install padas library. You can install execute python with following command
Features of Java
Features of Java: Java is one of the most popular language in the field... programming is its large number of important and robust features. Java can be used... applications. Java has various important features: SIMPLE Java
Features of Java: Java is one of the most popular language in the field... programming is its large number of important and robust features. Java can be used... applications. Java has various important features: SIMPLE Java
JDBC batch
JDBC batch JDBC is simply a Java Database Connectivity. This Connectivity provides you an API, that provides you.... The backend can be SQL-2000,2005,MySql. A batch in JDBC is a set of sql statement
JDBC batch JDBC is simply a Java Database Connectivity. This Connectivity provides you an API, that provides you.... The backend can be SQL-2000,2005,MySql. A batch in JDBC is a set of sql statement
JDBC Driver and Its Types
DBMS vendor. A Java program that uses the JDBC API loads the specified... platform. A JDBC-ODBC bridge provides JDBC API access via one or more... by the ODBC driver. Sun provides a JDBC-ODBC Bridge driver
DBMS vendor. A Java program that uses the JDBC API loads the specified... platform. A JDBC-ODBC bridge provides JDBC API access via one or more... by the ODBC driver. Sun provides a JDBC-ODBC Bridge driver
JDBC Batch Processing Example
JDBC Batch Processing Example: Batch processing mechanism provides a way to create group of related database statements in to a batch and execute them... used to execute batch and the setAutoCommit() method used to set auto commit
JDBC Batch Processing Example: Batch processing mechanism provides a way to create group of related database statements in to a batch and execute them... used to execute batch and the setAutoCommit() method used to set auto commit
JDBC Tutorial, JDBC API Tutorials
to use JDBC API effectively to develop database driven applications in Java. You can use JDBC in your console, AWT, Swing and Web applications. JDBC API provides... versions Features of JDBC Understanding Database concepts
to use JDBC API effectively to develop database driven applications in Java. You can use JDBC in your console, AWT, Swing and Web applications. JDBC API provides... versions Features of JDBC Understanding Database concepts
dbms_change_notification new_reg_start
dbms_change_notification new_reg_start Please explain it "dbmschangenotification newregstart" Thanks in advance
dbms_change_notification new_reg_start Please explain it "dbmschangenotification newregstart" Thanks in advance
What is JDBC?
) that provides cross-DBMS connectivity to a wide range of SQL databases and access.... JDBC API provides the API for: Connecting to database Getting the database...What is JDBC? hello, What is JDBC? hello,ADS
) that provides cross-DBMS connectivity to a wide range of SQL databases and access.... JDBC API provides the API for: Connecting to database Getting the database...What is JDBC? hello, What is JDBC? hello,ADS
Ads
