On Mon, May 18, 2015 at 4:48 PM, Guillermo Polito <guillermopol...@gmail.com > wrote:
> I wanted in general to have a single easy-to-learn way to build a database > connection string for all drivers. > > [driverid]://[host][:port]/[databasename]?[properties] > > 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
