Skip to Content
Last modified by christoph_lechleitner@iteg_at on 2013-07-09 04.08:43
From version 1.1
edited by christoph_lechleitner@iteg_at
on 2013-07-09 02.32:04
Change comment: There is no comment for this version
To version 3.1
edited by christoph_lechleitner@iteg_at
on 2013-07-09 03.09:12
Change comment: There is no comment for this version

Summary

Details

Page properties
Content
... ... @@ -10,7 +10,7 @@
10 10  
11 11  = {{id name="Multi-DataSourcepoolingwithJDBC-Provider-ConfiguringJDBC-ProviderDataSources"/}}Configuring JDBC-Provider DataSources =
12 12  
13 -This package uses the configuration PID org.clazzes.jdbc.provider and may be configured with keys using the following pattern:
13 +This package uses the configuration PID org.clazzes.jdbc.provider and may be configured with keys using the following patterns:
14 14  
15 15  |=(((
16 16  (% class="tablesorter-header-inner" %)
... ... @@ -31,28 +31,31 @@
31 31  JDBC URL
32 32  )))
33 33  |(((
34 -datasource.<datasourcename>.user
34 +{{code language="none"}}
35 +datasource.<datasourcename>.username
36 +{{/code}}
35 35  )))|(((
36 36  JDBC User
37 37  )))
38 38  |(((
41 +{{code language="none"}}
39 39  datasource.<datasourcename>.password
43 +{{/code}}
40 40  )))|(((
41 41  JDBC Password
42 42  )))
43 43  |(((
48 +{{code language="none"}}
44 44  datasource.<datasourcename>.validationQuery
50 +{{/code}}
45 45  )))|(((
46 46  Validation query, executed to ensure the application receives a valid connection
47 47  )))
48 -|(((
49 -datasource.<datasourcename>.maxActive
50 -)))|(((
51 -Optional
52 -)))
53 53  
54 54  For more supported key patterns take a look at the JavaDoc of the [[org.clazzes.util.jdbc.provider.JdbcProvider>>url:http://svn.clazzes.org/svn/util/trunk/jdbc-provider/src/main/java/org/clazzes/util/jdbc/provider/JdbcProvider.java||shape="rect"]] class.
55 55  
57 +Typical JDBC URLs and validation queries can be found in our [[doc:KH.Database Tips.JDBC Snippets.WebHome]].
58 +
56 56  == {{id name="Multi-DataSourcepoolingwithJDBC-Provider-Configurationexample"/}}Configuration example ==
57 57  
58 58  (((
... ... @@ -59,8 +59,6 @@
59 59  Sample configuration file {{code language="none"}}/etc/apache-karaf/org.clazzes.jdbc.provider.cfg{{/code}}:
60 60  )))
61 61  
62 -
63 -
64 64  {{code language="none"}}
65 65  datasource.JPTEST.url = jdbc:mysql://localhost/JPTEST
66 66  datasource.JPTEST.username = jptest
... ... @@ -73,10 +73,8 @@
73 73  datasource.SPECTRUM.validationQuery = select SYSDATE from DUAL
74 74  {{/code}}
75 75  
76 -
77 +(% style="color: rgb(0,0,0);font-size: 24.0px;line-height: 1.25;" %)Developer Snippets
77 77  
78 -= {{id name="Multi-DataSourcepoolingwithJDBC-Provider-DeveloperSnippets"/}}Developer Snippets =
79 -
80 80  == {{id name="Multi-DataSourcepoolingwithJDBC-Provider-pom.xmlSnippets"/}}pom.xml Snippets ==
81 81  
82 82  It's important for the maven-bundle-plugin to import the Package {{code language="none"}}javax.sql{{/code}}:
Confluence.Code.ConfluencePageClass[0]
Id
... ... @@ -1,1 +1,1 @@
1 -689856
1 +689858
URL
... ... @@ -1,1 +1,1 @@
1 -https://clazzes.atlassian.net/wiki/spaces/UTIL/pages/689856/Multi-DataSource pooling with JDBC-Provider
1 +https://clazzes.atlassian.net/wiki/spaces/UTIL/pages/689858/Multi-DataSource pooling with JDBC-Provider