��

��

I bumped into an interesting app "SQL Workbench/J" [1]��that lists URL connection strings for about 20 databases.�� I've extracted this mostly for curiousity (since we'll probably not support most of these), but it might be useful��for their formats to be possible.��Not sure how canonical these are or specific to the SQL Workbench application.

��

Adabas -- jdbc:adabasd://servername/name_of_database

Apache Derby Embedded -- jdbc:monetdb://(hostname)/(database)

Apache Derby Network Client -- jdbc:derby://(hostname):1527/(database)

Cubrid -- jdbc:cubrid:serverhost:33000:databasename

EnterpriseDB -- jdbc:edb://servername:port/database

FirebirdSQL -- jdbc:firebirdsql://host:port/name_of_database

H2 Databse Engine -- jdbc:h2:/path/to/database

HSQLDB -- jdbc:hsqldb:full_path_to_database

IBM DB2 -- jdbc:db2://server_name:50000/database_name

IBM BD2 UDB for AS/400 (iSeries) -- jdbc:as400://server_name/database_name

Informix -- jdbc:informix-sqli://host-name:port-number/dbName:INFORMIXSERVER=serverName

jTDS -- jdbc:jtds:sqlserver://serverName[:port][/;databaseName]

MaxDB -- jdbc:sapdb://hostname[:port]/database_name

Microsoft Access JDBC Driver --jdbc:ucanaccess://c:/path/to/database.mdb

MySQL -- jdbc:mysql://hostname:port/name_of_database

NuoDB -- jdbc:com.nuodb://localhost/test

Oracle -- jdbc:oracle:thin:@hostname:port:sid

Pervasive PSQL -- jdbc:pervasive://(hostname):(port)/(database)

PostgreSQL -- jdbc:postgresql://host:port/name_of_database

SQL Server 2005 -- jdbc:sqlserver://serverName[\instanceName][:portNumber];property=value;property=value

Sybase jConnect 6.0 -- jdbc:sybase:Tds:machine-name:port-number

Teradata -- jdbc:teradata://DatabaseServerName/Param1,Param2

��

The ones that caught my eye were:

* HSQLDB -- no slashes

* Microsoft Access -- file access

* SQL Server --��backslash, semicolons, equals

* Oracle -- multiple colons and @ symbol

* Teradata -- comma

��

��

btw, With Pharo wanting to appeal to businesses, SQLServer should probably be��on the��*long* term plan since many businesses are constrained by incumbent SQLServer installations. Documentation for their Tabular Data Stream protocol is apparently here [2].

��

[1] http://www.sql-workbench.net/downloads.html

[2] https://msdn.microsoft.com/en-us/library/ee320917(v=sql.105).aspx

��

��cheers -ben