DatabaseLink`
DatabaseLink`
WriteDataSource
WriteDataSource[name]
writes a new HSQL data source name.
WriteDataSource[name,database]
writes a new data source for database.
Details and Options
- 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" Automatic URL to use in the JDBC setting "Username" Automatic username for the connection "Password" Automatic password for the connection "Properties" {} properties to set for this connection "Location" User where to install the data source "RelativePath" Automatic whether file-based databases have a relative path "UseConnectionPool" Automatic whether a connection pool should be used "ReadOnly" Automatic whether the connection should be read only
Examples
Basic Examples (2)Summary of the most common use cases
In[1]:=1
✖
https://wolfram.com/xid/0he30bcgp4h66-dqjb94
Create a new data source named testSource that will use the HSQL database:
In[2]:=2
✖
https://wolfram.com/xid/0he30bcgp4h66-bj2dw0
Out[2]=2
Open a connection to the new source:
In[3]:=3
✖
https://wolfram.com/xid/0he30bcgp4h66-qwo35w
Out[3]=3
In[4]:=4
✖
https://wolfram.com/xid/0he30bcgp4h66-qnl66w
In[5]:=5
✖
https://wolfram.com/xid/0he30bcgp4h66-zspnkc
In[1]:=1
✖
https://wolfram.com/xid/0he30bcgp4h66-9gwa7h
Create a new data source that includes the Username and Password and is available to the executing user:
In[2]:=2
✖
https://wolfram.com/xid/0he30bcgp4h66-fcvrf
Out[2]=2
View the created configuration file:
In[3]:=3
✖
https://wolfram.com/xid/0he30bcgp4h66-y6d88y
