Skip to Content

Changes for page JDBC Snippets

Last modified by christoph_lechleitner@iteg_at on 2015-05-23 06.25:19
From version 3.1
edited by wolfgang_glas@iteg_at
on 2013-12-22 05.46:12
Change comment: There is no comment for this version
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
Author
... ... @@ -1,1 +1,1 @@
1 -XWiki.wolfgang_glas@iteg_at
1 +XWiki.christoph_lechleitner@iteg_at
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,30 +81,14 @@
81 81  |(((
82 82  PostgreSQL
83 83  )))|(((
84 -{{code language="none"}}
85 -org.postgresql.Driver
86 -{{/code}}
44 +
87 87  )))|(((
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
46 +
95 95  )))
96 96  |(((
97 97  SQLite
98 98  )))|(((
99 -{{code language="none"}}
100 -org.sqlite.JDBC
101 -{{/code}}
51 +
102 102  )))|(((
103 -{{code language="none"}}
104 -jdbc:sqlite:/var/foo/MYDATABASE.db
105 -{{/code}}
106 -)))|(((
107 --
108 -)))|(((
109 109  
110 110  )))
Confluence.Code.ConfluencePageClass[0]
Id
... ... @@ -1,1 +1,1 @@
1 -657888
1 +657788
URL
... ... @@ -1,1 +1,1 @@
1 -https://clazzes.atlassian.net/wiki/spaces/KH/pages/657888/JDBC Snippets
1 +https://clazzes.atlassian.net/wiki/spaces/KH/pages/657788/JDBC Snippets