Skip to Content

Changes for page JDBC Snippets

Last modified by christoph_lechleitner@iteg_at on 2015-05-23 06.25:19
From version 1.1
edited by christoph_lechleitner@iteg_at
on 2013-07-09 02.50:58
Change comment: There is no comment for this version
To version 2.1
edited by christoph_lechleitner@iteg_at
on 2013-07-10 11.30:34
Change comment: Added driver class names, Doc Links, more DMBSs

Summary

Details

Page properties
Content
... ... @@ -1,19 +1,47 @@
1 -== {{id name="JDBCSnippets-TypicalJDBCURLsandvalidationQueries"/}}Typical JDBC URLs and validation Queries(% style="color: rgb(51,51,51);" %) (%%) ==
1 +== {{id name="JDBCSnippets-TypicalJDBCURLsandvalidationQueries"/}}Typical JDBC URLs and validation Queries ==
2 2  
3 +The JDBC URL links usually refer to what we presume to be the most recent product version at the time we googled the links, earlier versions might not support all URL parameters.
4 +
3 3  |=(((
4 4  Database
5 5  )))|=(((
8 +Driver class name
9 +)))|=(((
6 6  JDBC URL Example
7 7  )))|=(((
12 +JDBC URL Links
13 +)))|=(((
8 8  validation Query recommendation
9 9  )))
10 10  |(((
17 +Apache Derby
18 +)))|(((
19 +{{code language="none"}}
20 +org.apache.derby.jdbc.EmbeddedDriver
21 +{{/code}}
22 +)))|(((
23 +(% class="code" %)
24 +(((
25 +jdbc:derby:[subsubprotocol:]MYDATABASE
26 +)))
27 +)))|(((
28 +[[Derby JDBC database connection URL>>url:http://db.apache.org/derby/docs/10.10/devguide/cdevdvlp17453.html||shape="rect"]]
29 +)))|(((
30 +
31 +)))
32 +|(((
11 11  MySQL
12 12  )))|(((
13 13  {{code language="none"}}
36 +com.mysql.jdbc.Driver
37 +{{/code}}
38 +)))|(((
39 +{{code language="none"}}
14 14  jdbc:mysql://myserver:3306/MYDATABASE
15 15  {{/code}}
16 16  )))|(((
43 +[[Connector/J Reference>>url:http://dev.mysql.com/doc/refman/5.5/en/connector-j-reference-configuration-properties.html||shape="rect"]]
44 +)))|(((
17 17  {{code language="none"}}
18 18  SELECT 1
19 19  {{/code}}
... ... @@ -22,9 +22,15 @@
22 22  MS SQL Server
23 23  )))|(((
24 24  {{code language="none"}}
53 +com.microsoft.sqlserver.jdbc.SQLServerDriver
54 +{{/code}}
55 +)))|(((
56 +{{code language="none"}}
25 25  jdbc:sqlserver://myserver:1433;databaseName=MYDATABASE
26 26  {{/code}}
27 27  )))|(((
60 +[[Building the Connection URL>>url:http://msdn.microsoft.com/en-us/library/ms378428.aspx||shape="rect"]]
61 +)))|(((
28 28  SELECT 1
29 29  )))
30 30  |(((
... ... @@ -31,10 +31,16 @@
31 31  Oracle
32 32  )))|(((
33 33  {{code language="none"}}
34 -jdbc:oracle:thin:@10.1.2.3:1521:XE
68 +oracle.jdbc.driver.OracleDriver
35 35  {{/code}}
36 36  )))|(((
37 37  {{code language="none"}}
72 +jdbc:oracle:thin:@myserver:1521:MYDATABASE
73 +{{/code}}
74 +)))|(((
75 +[[Oracle JDBC Driver and URL Information (@razorsql.com)>>url:http://www.razorsql.com/docs/help_oracle.html||shape="rect"]]
76 +)))|(((
77 +{{code language="none"}}
38 38  SELECT SYSDATE FROM DUAL
39 39  {{/code}}
40 40  )))
... ... @@ -41,14 +41,30 @@
41 41  |(((
42 42  PostgreSQL
43 43  )))|(((
44 -
84 +{{code language="none"}}
85 +org.postgresql.Driver
86 +{{/code}}
45 45  )))|(((
46 -
88 +{{code language="none"}}
89 +jdbc:postgresql://myserver:5740/MYDATABASE
90 +{{/code}}
91 +)))|(((
92 +[[Connection Parameters>>url:http://jdbc.postgresql.org/documentation/91/connect.html#connection-parameters||shape="rect"]]
93 +)))|(((
94 +SELECT 1
47 47  )))
48 48  |(((
49 49  SQLite
50 50  )))|(((
51 -
99 +{{code language="none"}}
100 +org.sqlite.JDBC
101 +{{/code}}
52 52  )))|(((
103 +{{code language="none"}}
104 +jdbc:sqlite:/var/foo/MYDATABASE.db
105 +{{/code}}
106 +)))|(((
107 +-
108 +)))|(((
53 53  
54 54  )))
Confluence.Code.ConfluencePageClass[0]
Id
... ... @@ -1,1 +1,1 @@
1 -657788
1 +657947
URL
... ... @@ -1,1 +1,1 @@
1 -https://clazzes.atlassian.net/wiki/spaces/KH/pages/657788/JDBC Snippets
1 +https://clazzes.atlassian.net/wiki/spaces/KH/pages/657947/JDBC Snippets