Schemas and XSL for new 'driver' configuration option v_0
authorFrantišek Kučera <franta-hg@frantovo.cz>
Sun, 24 May 2015 17:35:37 +0200
branchv_0
changeset 198 03d8492e2ca8
parent 197 7a2f535017e4
child 199 88de2602deb3
Schemas and XSL for new 'driver' configuration option
xml/config.rnc
xml/config.xml
xml/config.xsd
xml/config.xsl
--- a/xml/config.rnc	Mon May 18 00:36:23 2015 +0200
+++ b/xml/config.rnc	Sun May 24 17:35:37 2015 +0200
@@ -24,6 +24,7 @@
 			element url { text },
 			element userName { text }?,
 			element password { text }?,
+			element driver { text }?,
 			element property {
 				attribute name { text },
 				text
--- a/xml/config.xml	Mon May 18 00:36:23 2015 +0200
+++ b/xml/config.xml	Sun May 24 17:35:37 2015 +0200
@@ -9,6 +9,7 @@
 		<url>jdbc:postgresql://localhost:5432/database_name</url>
 		<userName>dbuser</userName>
 		<password>dbpass</password>
+		<driver>org.postgresql.Driver</driver>
 	</database>
 	
 	<database>
@@ -16,6 +17,7 @@
 		<url>jdbc:mysql://localhost:3306/database_name</url>
 		<userName>dbuser</userName>
 		<password>dbpass</password>
+		<driver>com.mysql.jdbc.Driver</driver>
 	</database>
 	
 	<database>
--- a/xml/config.xsd	Mon May 18 00:36:23 2015 +0200
+++ b/xml/config.xsd	Sun May 24 17:35:37 2015 +0200
@@ -39,6 +39,7 @@
 				<xs:element ref="c:url"/>
 				<xs:element minOccurs="0" ref="c:userName"/>
 				<xs:element minOccurs="0" ref="c:password"/>
+				<xs:element minOccurs="0" ref="c:driver"/>
 				<xs:element minOccurs="0" maxOccurs="unbounded" ref="c:property"/>
 			</xs:sequence>
 		</xs:complexType>
@@ -48,6 +49,7 @@
 	<xs:element name="url" type="xs:string"/>
 	<xs:element name="userName" type="xs:string"/>
 	<xs:element name="password" type="xs:string"/>
+	<xs:element name="driver" type="xs:string"/>
 	
 	<xs:element name="property">
 		<xs:complexType mixed="true">
--- a/xml/config.xsl	Mon May 18 00:36:23 2015 +0200
+++ b/xml/config.xsl	Sun May 24 17:35:37 2015 +0200
@@ -103,6 +103,13 @@
 					li {
 						padding: 0px;
 					}
+					
+					.notes {
+						font-size: 66%;
+					}
+					.notes p {
+						margin-bottom: 0px;
+					}
 				</style>
 			</head>
 			<body>
@@ -126,6 +133,7 @@
 									<td>name</td>
 									<td>username</td>
 									<td>url</td>
+									<td>JDBC driver</td>
 									<td>properties</td>
 								</tr>
 							</thead>
@@ -135,6 +143,7 @@
 									<td><xsl:value-of select="c:name"/></td>
 									<td><xsl:value-of select="c:userName"/></td>
 									<td><xsl:value-of select="c:url"/></td>
+									<td><xsl:value-of select="c:driver"/></td>
 									<td><ul><xsl:apply-templates select="c:property"/></ul></td>
 								</tr>
 								</xsl:for-each>
@@ -144,7 +153,13 @@
 					<xsl:otherwise><p>no databases are configured</p></xsl:otherwise>
 				</xsl:choose>
 				
-				<p>(passwords are hidden in this output)</p>
+				<div class="notes">
+					<p>Notes:</p>
+					<ul>
+						<li>passwords are hidden in this output</li>
+						<li>JDBC drivers are not mandatory – not needed in SQL-DK, but sometimes useful when <code>jdbc-dk-driver</code> is used in other applications to load SQL-DK's database connections</li>
+					</ul>
+				</div>
 				
 				
 				<h2>Output formatters</h2>