Skip to Content

Changes for page JDBC2XML Usage

Last modified by christoph_lechleitner@iteg_at on 2013-10-08 03.37:51
From version 3.1
edited by christoph_lechleitner@iteg_at
on 2012-08-06 10.41:57
Change comment: debian package and driver path mysql
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
... ... @@ -60,12 +60,14 @@
60 60  
61 61  {{code language="none"}}
62 62  # MySQL
63 -jdbc:mysql://localhost:3306/MYDATABASE
63 +jdbc:mysql://localhost:3306/MYDATABASE?useCursorFetch=true
64 64   
65 65  # MSSQL
66 66  jdbc:sqlserver://localhost:1433;databaseName=MYDATABASE;
67 67  {{/code}}
68 68  
69 +The use of cursor fetching in mysql is highly recommended in order to circumvent java heap space exceptions while dumping the content of large tables.
70 +
69 69  == {{id name="JDBC2XMLUsage-Fulllistofoptions"/}}Full list of options ==
70 70  
71 71  ==== {{id name="JDBC2XMLUsage-Databaseaccess"/}}Database access ====
... ... @@ -263,6 +263,23 @@
263 263  jdbc2xml ... --jdbc-drivers /usr/share/java/mysql-connector-java.jar
264 264  {{/code}}
265 265  
266 -TBC.
268 +====== {{id name="JDBC2XMLUsage-MSSQL-Driver"/}}MSSQL-Driver ======
267 267  
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 +
268 268  
286 +
287 +
Confluence.Code.ConfluencePageClass[0]
Id
... ... @@ -1,1 +1,1 @@
1 -656818
1 +656820
URL
... ... @@ -1,1 +1,1 @@
1 -https://clazzes.atlassian.net/wiki/spaces/JDBC2XML/pages/656818/JDBC2XML Usage
1 +https://clazzes.atlassian.net/wiki/spaces/JDBC2XML/pages/656820/JDBC2XML Usage