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



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

Have Programming Question? Ask it here!
 
 
 


Clark
use JDBC to execute non-standard features that my DBMS provides.
1 Answer(s)      3 years and 10 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
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
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
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
how do i use sql like query in my jsp page
how do i use sql like query in my jsp page  how do i use sql like query in my jsp page   Hi Friend, Try the following code: <%@ page..."); Connection con = DriverManager.getConnection("jdbc:odbc:student
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
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
how can i use toggle button in my application
how can i use toggle button in my application  i want a on/off toggle button by dragging left-right..not by pressing on button
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
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
how to use yield(),join() methods in program.where it is usefull in my program
how to use yield(),join() methods in program.where it is usefull in my program  Hi i am using yield() in my program but the out put i can't... thread with same priority .but in my example i can't findout exact function
how to use yield(),join() methods in program.where it is usefull in my program
how to use yield(),join() methods in program.where it is usefull in my program  Hi i am using yield() in my program but the out put i can't... thread with same priority .but in my example i can't findout exact function
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
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 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.... Including the Driver Manager JDBC also provides some of the interfaces
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... and features. There are many new exiting features which is added to the PHP 5.5
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
JDBC Training, Learn JDBC yourself
, New Features in JDBC 4.0 and More APIs Become Available. Understanding.... 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
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
dbms_change_notification new_reg_start
dbms_change_notification new_reg_start  Please explain it "dbmschangenotification newregstart" Thanks in advance
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
Advertisements
 

 

 

DMCA.com