Skip to Content

Changes for page JDBC2XML Usage

Last modified by christoph_lechleitner@iteg_at on 2013-10-08 03.37:51
From version 8.1
edited by christoph_lechleitner@iteg_at
on 2013-07-09 02.57:16
Change comment: Link to JDBC snippets
To version 6.1
edited by christoph_lechleitner@iteg_at
on 2012-11-27 04.29:08
Change comment: added exclude hint for MSSQL system tables

Summary

Details

Page properties
Content
... ... @@ -255,13 +255,33 @@
255 255  --debug-startup
256 256  {{/code}}
257 257  
258 -=== {{id name="JDBC2XMLUsage-Driverpackagesandpaths,andotherBackendspecifictips"/}}Driver packages and paths, and other Backend specific tips ===
258 +=== {{id name="JDBC2XMLUsage-Driverpackagesandpaths"/}}Driver packages and paths ===
259 259  
260 -See
260 +====== {{id name="JDBC2XMLUsage-MySQL-Driver"/}}MySQL-Driver ======
261 261  
262 -(% style="list-style-type: square;" %)
263 -* [[MySQL Tips>>doc:JDBC2XML.JDBC2XML Usage.MySQL Tips.WebHome]]
264 -* [[doc:JDBC2XML.JDBC2XML Usage.MSSQL Tips.WebHome]]
265 -* [[doc:KH.Database Tips.JDBC Snippets.WebHome]] with common JDBC URL examples
262 +{{code language="none"}}
263 +apt-get install libmysql-java
264 + 
265 +jdbc2xml ... --jdbc-drivers /usr/share/java/mysql-connector-java.jar
266 +{{/code}}
266 266  
268 +====== {{id name="JDBC2XMLUsage-MSSQL-Driver"/}}MSSQL-Driver ======
269 +
270 +{{code language="none"}}
271 +apt-get install apache-karaf-mssql
272 + 
273 +jdbc2xml ... --jdbc-drivers /usr/share/apache-karaf/lib/sqljdbc4.jar
274 +{{/code}}
275 +
276 +=== {{id name="JDBC2XMLUsage-Typicalspecialoptions"/}}Typical special options ===
277 +
278 +===== {{id name="JDBC2XMLUsage-MSSQL"/}}MSSQL =====
279 +
280 +{{code language="none"}}
281 +# MSSQL likes to create system tables which should not be exported or imported
282 +jdbc2xml ... --exclude-tables sysdiagrams,trace_xe_event_map,trace_xe_action_map
283 +{{/code}}
284 +
267 267  
286 +
287 +
Confluence.Code.ConfluencePageClass[0]
Id
... ... @@ -1,1 +1,1 @@
1 -656896
1 +656820
URL
... ... @@ -1,1 +1,1 @@
1 -https://clazzes.atlassian.net/wiki/spaces/JDBC2XML/pages/656896/JDBC2XML Usage
1 +https://clazzes.atlassian.net/wiki/spaces/JDBC2XML/pages/656820/JDBC2XML Usage