Latest Tutorials| Questions and Answers|Ask Questions?|Site Map



Home Answers Viewqa JDBC use JDBC to execute non-standard features that my DBMS provides.
Login         

View Questions and Answers by Category

Advertisements


 
Have Programming Question? Ask it here!
 
 
 


Clark
use JDBC to execute non-standard features that my DBMS provides.
1 Answer(s)      4 years and 2 months ago
Posted in : JDBC


Can I use JDBC to execute non-standard features that my DBMS provides?


Advertisement
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
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
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
JDBC features
JDBC features In this section we will see the features of JDBC. The Java... the programmers to access data from Java program. Here is the features of JDBC JDBC API provides the methods to access the data base easily. JDBC drivers
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.0 1. Auto loading
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
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 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
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
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
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
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
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
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
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 use dirivers - JDBC
how to use dirivers  i try connecting to a database with this code... to the connector to my classpath variable. here is the code; import java.sql.Connection..."); connection = DriverManager.getConnection("jdbc:mysql://localhost:3306/test","root
How could I use Socket in my application?
How could I use Socket in my application?  I created an application... out today that I have to use also Socket and I don't know exactly what I could do with it in my project. Sorry for being too general. But maybe someone has
Use JDBC to connect Microsoft Access
Use JDBC to connect Microsoft Access  How to use JDBC to connect Microsoft Access
Features
Features  Give me java1.6 features with examples?   Please visit the following links: Java 1.6 features Some Examples of Java 1.6
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
why to use hibernet vs jdbc
in JDBC there is a use of SQL. 3) As Hibernate Supports two level of cache, you...why to use hibernet vs jdbc  plz send me the reply   Hi Friend, Differences: 1) Hibernate is data base independent Where JDBC is database
Advertisements
 

 

 

DMCA.com