Skip to Content
Last modified by christoph_lechleitner@iteg_at on 2013-07-09 04.08:43
From version 2.1
edited by christoph_lechleitner@iteg_at
on 2013-07-09 02.55:43
Change comment: There is no comment for this version
To 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

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 patterns:
13 +This package uses the configuration PID org.clazzes.jdbc.provider and may be configured with keys using the following pattern:
14 14  
15 15  |=(((
16 16  (% class="tablesorter-header-inner" %)
... ... @@ -31,31 +31,28 @@
31 31  JDBC URL
32 32  )))
33 33  |(((
34 -{{code language="none"}}
35 35  datasource.<datasourcename>.user
36 -{{/code}}
37 37  )))|(((
38 38  JDBC User
39 39  )))
40 40  |(((
41 -{{code language="none"}}
42 42  datasource.<datasourcename>.password
43 -{{/code}}
44 44  )))|(((
45 45  JDBC Password
46 46  )))
47 47  |(((
48 -{{code language="none"}}
49 49  datasource.<datasourcename>.validationQuery
50 -{{/code}}
51 51  )))|(((
52 52  Validation query, executed to ensure the application receives a valid connection
53 53  )))
48 +|(((
49 +datasource.<datasourcename>.maxActive
50 +)))|(((
51 +Optional
52 +)))
54 54  
55 55  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.
56 56  
57 -Typical JDBC URLs and validation queries can be found in our [[doc:KH.Database Tips.JDBC Snippets.WebHome]].
58 -
59 59  == {{id name="Multi-DataSourcepoolingwithJDBC-Provider-Configurationexample"/}}Configuration example ==
60 60  
61 61  (((
... ... @@ -62,6 +62,8 @@
62 62  Sample configuration file {{code language="none"}}/etc/apache-karaf/org.clazzes.jdbc.provider.cfg{{/code}}:
63 63  )))
64 64  
62 +
63 +
65 65  {{code language="none"}}
66 66  datasource.JPTEST.url = jdbc:mysql://localhost/JPTEST
67 67  datasource.JPTEST.username = jptest
... ... @@ -74,8 +74,10 @@
74 74  datasource.SPECTRUM.validationQuery = select SYSDATE from DUAL
75 75  {{/code}}
76 76  
77 -(% style="color: rgb(0,0,0);font-size: 24.0px;line-height: 1.25;" %)Developer Snippets
76 +
78 78  
78 += {{id name="Multi-DataSourcepoolingwithJDBC-Provider-DeveloperSnippets"/}}Developer Snippets =
79 +
79 79  == {{id name="Multi-DataSourcepoolingwithJDBC-Provider-pom.xmlSnippets"/}}pom.xml Snippets ==
80 80  
81 81  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 -689855
1 +689856
URL
... ... @@ -1,1 +1,1 @@
1 -https://clazzes.atlassian.net/wiki/spaces/UTIL/pages/689855/Multi-DataSource pooling with JDBC-Provider
1 +https://clazzes.atlassian.net/wiki/spaces/UTIL/pages/689856/Multi-DataSource pooling with JDBC-Provider