WriteDataSource
This feature is not supported on the Wolfram Cloud.

WriteDataSource[name]
writes a new HSQL data source name.

WriteDataSource[name,database]
writes a new data source for database.

DetailsDetails

  • To use WriteDataSource, you first need to load DatabaseLink using Needs["DatabaseLink`"].
  • The following options can be given:
  • "Description"""textual description of the data source
    "URL"AutomaticURL to use in the JDBC setting
    "Username"Automaticusername for the connection
    "Password"Automaticpassword for the connection
    "Properties"{}properties to set for this connection
    "Location"Userwhere to install the data source
    "RelativePath"Automaticwhether file-based databases have a relative path
    "UseConnectionPool"Automaticwhether a connection pool should be used
    "ReadOnly"Automaticwhether the connection should be read only

ExamplesExamplesopen allclose all

Basic Examples  (2)Basic Examples  (2)

In[1]:=
Click for copyable input

Create a new data source named that will use the HSQL database:

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

Open a connection to the new source:

In[3]:=
Click for copyable input
Out[3]=
In[4]:=
Click for copyable input
Out[4]//Short=
In[5]:=
Click for copyable input
In[1]:=
Click for copyable input

Create a new data source that includes the and and is available to the executing user:

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

View the created configuration file: