Skip to Content

Changes for page JDBC Snippets

Last modified by christoph_lechleitner@iteg_at on 2015-05-23 06.25:19
From version 4.1
edited by christoph_lechleitner@iteg_at
on 2015-05-23 06.25:19
Change comment: Using default port for PostgreSQL example
To 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

Summary

Details

Page properties
Content
... ... @@ -1,47 +1,19 @@
1 -== {{id name="JDBCSnippets-TypicalJDBCURLsandvalidationQueries"/}}Typical JDBC URLs and validation Queries ==
1 +== {{id name="JDBCSnippets-TypicalJDBCURLsandvalidationQueries"/}}Typical JDBC URLs and validation Queries(% style="color: rgb(51,51,51);" %) (%%) ==
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 -
5 5  |=(((
6 6  Database
7 7  )))|=(((
8 -Driver class name
9 -)))|=(((
10 10  JDBC URL Example
11 11  )))|=(((
12 -JDBC URL Links
13 -)))|=(((
14 14  validation Query recommendation
15 15  )))
16 16  |(((
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 -|(((
33 33  MySQL
34 34  )))|(((
35 35  {{code language="none"}}
36 -com.mysql.jdbc.Driver
37 -{{/code}}
38 -)))|(((
39 -{{code language="none"}}
40 40  jdbc:mysql://myserver:3306/MYDATABASE
41 41  {{/code}}
42 42  )))|(((
43 -[[Connector/J Reference>>url:http://dev.mysql.com/doc/refman/5.5/en/connector-j-reference-configuration-properties.html||shape="rect"]]
44 -)))|(((
45 45  {{code language="none"}}
46 46  SELECT 1
47 47  {{/code}}
... ... @@ -50,15 +50,9 @@
50 50  MS SQL Server
51 51  )))|(((
52 52  {{code language="none"}}
53 -com.microsoft.sqlserver.jdbc.SQLServerDriver
54 -{{/code}}
55 -)))|(((
56 -{{code language="none"}}
57 57  jdbc:sqlserver://myserver:1433;databaseName=MYDATABASE
58 58  {{/code}}
59 59  )))|(((
60 -[[Building the Connection URL>>url:http://msdn.microsoft.com/en-us/library/ms378428.aspx||shape="rect"]]
61 -)))|(((
62 62  SELECT 1
63 63  )))
64 64  |(((
... ... @@ -65,16 +65,10 @@
65 65  Oracle
66 66  )))|(((
67 67  {{code language="none"}}
68 -oracle.jdbc.driver.OracleDriver
34 +jdbc:oracle:thin:@10.1.2.3:1521:XE
69 69  {{/code}}
70 70  )))|(((
71 71  {{code language="none"}}
72 -jdbc:oracle:thin:@myserver:1521:MYTNS
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"}}
78 78  SELECT SYSDATE FROM DUAL
79 79  {{/code}}
80 80  )))
... ... @@ -81,28 +81,14 @@
81 81  |(((
82 82  PostgreSQL
83 83  )))|(((
84 -{{code language="none"}}
85 -org.postgresql.Driver
86 -{{/code}}
44 +
87 87  )))|(((
88 -##jdbc:postgresql:~/~/myserver:(% style="color: rgb(0,0,0);" %)5432(%%)/MYDATABASE##
89 -)))|(((
90 -[[Connection Parameters>>url:http://jdbc.postgresql.org/documentation/91/connect.html#connection-parameters||shape="rect"]]
91 -)))|(((
92 -SELECT 1
46 +
93 93  )))
94 94  |(((
95 95  SQLite
96 96  )))|(((
97 -{{code language="none"}}
98 -org.sqlite.JDBC
99 -{{/code}}
51 +
100 100  )))|(((
101 -{{code language="none"}}
102 -jdbc:sqlite:/var/foo/MYDATABASE.db
103 -{{/code}}
104 -)))|(((
105 --
106 -)))|(((
107 107  
108 108  )))
Confluence.Code.ConfluencePageClass[0]
Id
... ... @@ -1,1 +1,1 @@
1 -657039
1 +657788
URL
... ... @@ -1,1 +1,1 @@
1 -https://clazzes.atlassian.net/wiki/spaces/KH/pages/657039/JDBC Snippets
1 +https://clazzes.atlassian.net/wiki/spaces/KH/pages/657788/JDBC Snippets