JDBC
This feature is not supported on the Wolfram Cloud.

JDBC[arg,]
is an object that holds parameters for making a JDBC connection to a database.

DetailsDetails

  • Typically, the first argument to JDBC is a named configuration or driver class name, and the second argument is a filename or connection URL.
  • To use JDBC, you first need to load DatabaseLink using Needs["DatabaseLink`"].

ExamplesExamplesopen allclose all

Basic Examples  (1)Basic Examples  (1)

In[1]:=
Click for copyable input

If you find that the examples in this section do not work as shown, you may need to install or restore the example database with the package, as described in Using the Example Databases.

Open a connection using the built-in JDBC configuration :

In[2]:=
Click for copyable input
Out[2]=
In[3]:=
Click for copyable input
Out[3]=

The connection protocol for this database type is specified in the driver documentation and is reflected in the JDBC configuration file. Alternatively, connect to the same resource using the driver class name and an explicit connection URL:

In[4]:=
Click for copyable input
Out[4]=
In[5]:=
Click for copyable input
Out[5]=