Skip to Content

Wiki source code of JDBC Snippets

Version 1.1 by christoph_lechleitner@iteg_at on 2013-07-09 02.50:58
Show last authors
1 == {{id name="JDBCSnippets-TypicalJDBCURLsandvalidationQueries"/}}Typical JDBC URLs and validation Queries(% style="color: rgb(51,51,51);" %) (%%) ==
2
3 |=(((
4 Database
5 )))|=(((
6 JDBC URL Example
7 )))|=(((
8 validation Query recommendation
9 )))
10 |(((
11 MySQL
12 )))|(((
13 {{code language="none"}}
14 jdbc:mysql://myserver:3306/MYDATABASE
15 {{/code}}
16 )))|(((
17 {{code language="none"}}
18 SELECT 1
19 {{/code}}
20 )))
21 |(((
22 MS SQL Server
23 )))|(((
24 {{code language="none"}}
25 jdbc:sqlserver://myserver:1433;databaseName=MYDATABASE
26 {{/code}}
27 )))|(((
28 SELECT 1
29 )))
30 |(((
31 Oracle
32 )))|(((
33 {{code language="none"}}
34 jdbc:oracle:thin:@10.1.2.3:1521:XE
35 {{/code}}
36 )))|(((
37 {{code language="none"}}
38 SELECT SYSDATE FROM DUAL
39 {{/code}}
40 )))
41 |(((
42 PostgreSQL
43 )))|(((
44
45 )))|(((
46
47 )))
48 |(((
49 SQLite
50 )))|(((
51
52 )))|(((
53
54 )))