Return-Path: Delivered-To: apmail-db-torque-dev-archive@www.apache.org Received: (qmail 22777 invoked from network); 3 Sep 2008 17:12:20 -0000 Received: from hermes.apache.org (HELO mail.apache.org) (140.211.11.2) by minotaur.apache.org with SMTP; 3 Sep 2008 17:12:20 -0000 Received: (qmail 592 invoked by uid 500); 3 Sep 2008 17:12:18 -0000 Delivered-To: apmail-db-torque-dev-archive@db.apache.org Received: (qmail 581 invoked by uid 500); 3 Sep 2008 17:12:18 -0000 Mailing-List: contact torque-dev-help@db.apache.org; run by ezmlm Precedence: bulk List-Unsubscribe: List-Help: List-Post: List-Id: "Apache Torque Developers List" Reply-To: "Apache Torque Developers List" Delivered-To: mailing list torque-dev@db.apache.org Received: (qmail 570 invoked by uid 99); 3 Sep 2008 17:12:18 -0000 Received: from athena.apache.org (HELO athena.apache.org) (140.211.11.136) by apache.org (qpsmtpd/0.29) with ESMTP; Wed, 03 Sep 2008 10:12:18 -0700 X-ASF-Spam-Status: No, hits=-0.0 required=10.0 tests=SPF_PASS X-Spam-Check-By: apache.org Received-SPF: pass (athena.apache.org: local policy) Received: from [212.86.208.21] (HELO mailgw01.vps.de) (212.86.208.21) by apache.org (qpsmtpd/0.29) with ESMTP; Wed, 03 Sep 2008 17:11:20 +0000 X-IronPort-AV: E=Sophos;i="4.32,320,1217800800"; d="p7s'?scan'208";a="164331" Received: from unknown (HELO scuderia09.vps.local) ([10.0.0.19]) by mailgate01.vps.de with ESMTP; 03 Sep 2008 19:11:48 +0200 Content-class: urn:content-classes:message MIME-Version: 1.0 X-MimeOLE: Produced By Microsoft Exchange V6.5 Subject: AW: Importing binary data using data.xml Date: Wed, 3 Sep 2008 19:11:45 +0200 Content-Type: multipart/signed; protocol="application/x-pkcs7-signature"; micalg=SHA1; boundary="----=_NextPart_000_009B_01C90DF8.E7E9F5D0" Message-ID: <0765101BA5724F4DAC1607B4CF4BC171D0D1A0@scuderia09.vps.local> In-Reply-To: X-MS-Has-Attach: yes X-MS-TNEF-Correlator: Thread-Topic: Importing binary data using data.xml thread-index: AckN3a2eMcOghIHEQKCwBAfv0++67AACfxiQ References: <0765101BA5724F4DAC1607B4CF4BC171D0D192@scuderia09.vps.local> From: "Tobias Hilka" To: "Apache Torque Developers List" X-Virus-Checked: Checked by ClamAV on apache.org ------=_NextPart_000_009B_01C90DF8.E7E9F5D0 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable Hello, I tried to export some data from the database using dbunit. They encode = the binary data in base64. The import also worked. Are there any plans to = add such an import/export functionality to torque? For now, I think I will combine both torque and dbunit to fullfill our requirements. Thank you for your answer. Tobias -----Urspr=FCngliche Nachricht----- Von: Thomas Fischer [mailto:fischer@seitenbau.net]=20 Gesendet: Mittwoch, 3. September 2008 17:53 An: Apache Torque Developers List Betreff: RE: Importing binary data using data.xml The datadump and insert-sql tasks were never able to do more than basic=20 stuff. But to be specific: > we are facing the requirement to initialize our database not only=20 > with textual data but also with binary data (mostly xml data).=20 >=20 > We have a running database with the initial data on MSSQL 2005 and=20 > we need to have the same for Oracle. We used the datadump mechanism=20 > provided by torque to get the data from the MSSQL database. But the=20 > binary data is missing. > Is there any possibility to handle binary data using torque with the > datadump and insert-sql tasks? Not without a patch. Probably adding this is easy. My first idea would = be=20 to base64-encode the data before storing it in xml. > Another problem with the datadump task are special characters. Is=20 > there any possibility to give some codepage to the datadump task? >=20 > The format of date values generated by datadump is ?2008-01-01 20: > 00:00.123?.=20 This probably dependas on the database against which you are running the = datadump :-( > When I tried to insert the datadump result into the=20 > MSSQL database again, the MSSQL server does not understand this=20 > format, since the server is running on a german system. Any chance=20 > to add the format as a parameter? Also not without a patch. There would be two formats: a) the format for xml b ) the format for the database In principle, Torque knows b), but this is not used in the datadump and=20 insert-sql tasks. a) would have to vbe defined by configuration. >=20 > For the binary problem I was thinking about using some tool like=20 > DBUnit, which (as far as I read) can import binary data into tables. > Does anyone have any experience with this? As far as I know, dbunit can do this, but it cannot store binary data in = xml. But I may be mistaken. Thomas ------=_NextPart_000_009B_01C90DF8.E7E9F5D0 Content-Type: application/x-pkcs7-signature; name="smime.p7s" Content-Transfer-Encoding: base64 Content-Disposition: attachment; filename="smime.p7s" MIAGCSqGSIb3DQEHAqCAMIACAQExCzAJBgUrDgMCGgUAMIAGCSqGSIb3DQEHAQAAoIIPSzCCBJUw ggN9oAMCAQICAwMOlTANBgkqhkiG9w0BAQUFADBLMQswCQYDVQQGEwJERTEVMBMGA1UECgwMRC1U cnVzdCBHbWJIMSUwIwYDVQQDDBxELVRSVVNUIFJvb3QgQ2xhc3MgMiBDQSAyMDA3MB4XDTA3MDUx NjA1MjA0N1oXDTIyMDUxNjA1MjA0N1owSzELMAkGA1UEBhMCREUxFTATBgNVBAoMDEQtVHJ1c3Qg R21iSDElMCMGA1UEAwwcRC1UUlVTVCBSb290IENsYXNzIDIgQ0EgMjAwNzCCASIwDQYJKoZIhvcN AQEBBQADggEPADCCAQoCggEBALPN5IQVSfjk1s6Es5qt9jB1kA2E6+7as3p1KuI7pOowLOs9d42B hGhKpqRo3JBzYTRlBx0jpQzmv9PdM13aMu2mDVOmdGpcGVmmTLUveQFenn9K+rrJJ37U/80AWSDr BsyzRM/WhentOwxsweqMXOC5qQLwEwAnk5xQ/s0TT20baqrdD/9GJRnc4V5QrBp/Dsva7iD8w/Sc Sng1bu4xx0UWcoXSgiDbUkV8PL9ZV/mHdFaYWx1Qjswvs7M/i+7sN0kBiO/YIQyT0/ZuiU+6F8tE gbd7pyO7dArT2Oo3RSf/3PCeQ+O6e4obmn3phqD+L9HW9odXqvIplIdzFfpqTq0CAwEAAaOCAYAw ggF8MA8GA1UdEwEB/wQFMAMBAf8wHQYDVR0OBBYEFJEwq/bzxkS3690ovA8Un1JdYn8CMDkGCCsG AQUFBwEBBC0wKzApBggrBgEFBQcwAYYdaHR0cDovL3VzZXJzLm9jc3AuZC10cnVzdC5uZXQwMwYD VR0RBCwwKoEQaW5mb0BkLXRydXN0Lm5ldIYWaHR0cDovL3d3dy5kLXRydXN0Lm5ldDAOBgNVHQ8B Af8EBAMCAQYwgckGA1UdHwSBwTCBvjCBu6CBuKCBtYZ2bGRhcDovL2RpcmVjdG9yeS5kLXRydXN0 Lm5ldC9DTj1ELVRSVVNUJTIwUm9vdCUyMENsYXNzJTIwMiUyMENBJTIwMjAwNyxPPUQtVHJ1c3Ql MjBHbWJILEM9REU/Y2VydGlmaWNhdGVyZXZvY2F0aW9ubGlzdIY7aHR0cDovL3d3dy5kLXRydXN0 Lm5ldC9jcmwvZC10cnVzdF9yb290X2NsYXNzXzJfY2FfMjAwNy5jcmwwDQYJKoZIhvcNAQEFBQAD ggEBAFuL8kPjBS5kH9WSqVFrZPwORswHmeK3/JMpINz8L2DkrH0lMu0Q4Q9v2/K8Tu5BybPUB0h6 Cq+ktv9RMO3L0pzrf1DuS+JipzTCIPbz9vU2wMuREOvtLo30BxohDDV39HwtjUml1wtEaNXS4uUM eDgTyrFMUqoq5dWvXAU5nS2tviNW1S9V896dq4I2oE23WZFH7t6Dpeo7XicFgAttLFD0ATfVo3cX 7P7dhPTF+FCS0EvGLqOLQOTDN6N3vc4sVeKs311kALq+p2oxBvyZa1AVJZ2pdpqnTSqaAmPrcOf+ ESbQGMWmHwpDk/IY2fU5ebgHXYwf5j/zxcshZjF7e88wggUcMIIEBKADAgECAgMDDpswDQYJKoZI hvcNAQEFBQAwSzELMAkGA1UEBhMCREUxFTATBgNVBAoMDEQtVHJ1c3QgR21iSDElMCMGA1UEAwwc RC1UUlVTVCBSb290IENsYXNzIDIgQ0EgMjAwNzAeFw0wNzA1MTYwNTIwNDdaFw0xMjA1MTYwNTIw NDdaME8xCzAJBgNVBAYTAkRFMRUwEwYDVQQKDAxELVRydXN0IEdtYkgxKTAnBgNVBAMMIEQtVFJV U1QgQWR2YW5jZWQgQ2xhc3MgMiBDQSAyMDA3MIIBIjANBgkqhkiG9w0BAQEFAAOCAQ8AMIIBCgKC AQEAqaO5i/9YVAfdViGRwhI/6OzkKRmtZYolb2d1l7ADZgu/OiSF9F66YtvSKfx6LwdkHQ6Ags/I AnGyE9TG9eUihDyMg5/kiNK90WdBEcI7tkdI0o+MQmll9l7ZJQXGZr9PtZi26+ZW8+vL2zD16pa6 o7/Ysm6meCnOM1a/1Wf2+syVKOVzs2MI08B46OAShjItvwkwJ3nB2rL6nQ8HF2A6q28NVsZklNlS jTTnVU3r93Mi7YVKPDV6FMVzD5zBhiiLW/DyqD8cDvBT6OW031TnfpUqUNKZM1AoPApqVHA0GE9w EGyKRjTdzLQavEPBR2qV+sVTxX5sMCPIS5oCi+8iiQIDAQABo4ICAzCCAf8wHwYDVR0jBBgwFoAU kTCr9vPGRLfr3Si8DxSfUl1ifwIwOQYIKwYBBQUHAQEELTArMCkGCCsGAQUFBzABhh1odHRwOi8v dXNlcnMub2NzcC5kLXRydXN0Lm5ldDBdBgNVHSAEVjBUMFIGCysGAQQBpTQCgUgBMEMwQQYIKwYB BQUHAgEWNWh0dHA6Ly93d3cuZC10cnVzdC5uZXQvcmVwb3NpdG9yeS9DUFNfQ2xhc3NfM18yXzEu cGRmMDMGA1UdEQQsMCqBEGluZm9AZC10cnVzdC5uZXSGFmh0dHA6Ly93d3cuZC10cnVzdC5uZXQw gckGA1UdHwSBwTCBvjCBu6CBuKCBtYZ2bGRhcDovL2RpcmVjdG9yeS5kLXRydXN0Lm5ldC9DTj1E LVRSVVNUJTIwUm9vdCUyMENsYXNzJTIwMiUyMENBJTIwMjAwNyxPPUQtVHJ1c3QlMjBHbWJILEM9 REU/Y2VydGlmaWNhdGVyZXZvY2F0aW9ubGlzdIY7aHR0cDovL3d3dy5kLXRydXN0Lm5ldC9jcmwv ZC10cnVzdF9yb290X2NsYXNzXzJfY2FfMjAwNy5jcmwwHQYDVR0OBBYEFP6XXHdVtcf2fFA0EgKD +cqbpcy2MA4GA1UdDwEB/wQEAwIBBjASBgNVHRMBAf8ECDAGAQH/AgEAMA0GCSqGSIb3DQEBBQUA A4IBAQALdi1JoliAfmvyCEJpLPnbUNUEayALfqwXraesmrNALJs5l3Ii3HKIrhYt8TOFA/JoFIgD wD6Dh1rucoYlCVfr7XnLJByE9WxXkHkPTaxCQK+W5ATFRQEeGdXMYf1RzUPRQU4Dpl+V9YbsIn0u zGN2OrDiKMI+GpxvMFtibvhfX0xUnk2M7yEV4TNegb819fKWQQL+fR4pudUo3M5L6QAkO1t2dG8R AytoN4d+81zATT0zCqHXdLKqancpa4niYAzVVJJfI70sI3UFd8viFRdbT7QEES82hoqxEkv8tumv HTk/OmBnY9tPspdRL7MbxjEvN34LYBHLDhRUEzvwP2gPMIIFjjCCBHagAwIBAgIDB1qIMA0GCSqG SIb3DQEBBQUAME8xCzAJBgNVBAYTAkRFMRUwEwYDVQQKDAxELVRydXN0IEdtYkgxKTAnBgNVBAMM IEQtVFJVU1QgQWR2YW5jZWQgQ2xhc3MgMiBDQSAyMDA3MB4XDTA4MDUxNjA2NTk0NFoXDTEwMDUy NjA4NDUyNVowgYkxCzAJBgNVBAYTAkRFMRwwGgYDVQQKDBN2cHMgSUQgU3lzdGVtZSBHbWJIMRUw EwYDVQQDDAxUb2JpYXMgSGlsa2ExFjAUBgNVBCoMDVRvYmlhcyBNYXJrdXMxDjAMBgNVBAQMBUhp bGthMR0wGwYDVQQFExREVFJXRTIwOTM5MTE5Mjg0NDkyMjCCASIwDQYJKoZIhvcNAQEBBQADggEP ADCCAQoCggEBAJjFFdpJcy/Keh0gpEhXnruzSp+OTrt09vG8R5toHxRy0ZWbjK7DM+rjx04/AWDG oHaNSpvPxU3fHESU2VUUVjPXui21A3FsHHZ6xSs+ILsbFnv2pg9SWNvXF6jpcJotVeIIB/Ln+mQb iPBnWMonzWq+edMnAcm8ahXNrYax6m+JyNc6CdyMUpVouCCixkAMWm3Ku7VoKHdsIi3OX4ROdGKI 6kCKCHaVLSICHCQB2H0JdKuRB9B1rCS9C96P6DWSQ6sFwLWMDdm9zpe+ZVeV2nAWKlLsv2PKrSPK zwaGzrKEPnNTFFolRaio3F5/5qY1lcDmLkV3lQ269CsqfgPNVukCAwEAAaOCAjYwggIyMCMGA1Ud JQQcMBoGCCsGAQUFBwMCBggrBgEFBQcDBAYEVR0lADAfBgNVHSMEGDAWgBT+l1x3VbXH9nxQNBIC g/nKm6XMtjA5BggrBgEFBQcBAQQtMCswKQYIKwYBBQUHMAGGHWh0dHA6Ly91c2Vycy5vY3NwLmQt dHJ1c3QubmV0MF0GA1UdIARWMFQwUgYLKwYBBAGlNAKBSAEwQzBBBggrBgEFBQcCARY1aHR0cDov L3d3dy5kLXRydXN0Lm5ldC9yZXBvc2l0b3J5L0NQU19DbGFzc18zXzJfMS5wZGYwgdEGA1UdHwSB yTCBxjCBw6CBwKCBvYZ6bGRhcDovL2RpcmVjdG9yeS5kLXRydXN0Lm5ldC9DTj1ELVRSVVNUJTIw QWR2YW5jZWQlMjBDbGFzcyUyMDIlMjBDQSUyMDIwMDcsTz1ELVRydXN0JTIwR21iSCxDPURFP2Nl cnRpZmljYXRlcmV2b2NhdGlvbmxpc3SGP2h0dHA6Ly93d3cuZC10cnVzdC5uZXQvY3JsL2QtdHJ1 c3RfYWR2YW5jZWRfY2xhc3NfMl9jYV8yMDA3LmNybDAzBgNVHRIELDAqgRBpbmZvQGQtdHJ1c3Qu bmV0hhZodHRwOi8vd3d3LmQtdHJ1c3QubmV0MB0GA1UdDgQWBBSKL7RPrzylTNKvJ2aJIq/mX2Ew azAOBgNVHQ8BAf8EBAMCBLAwGAYDVR0RBBEwD4ENdGhpbGthQHZwcy5kZTANBgkqhkiG9w0BAQUF AAOCAQEAFDzpVKX8EsEJssScG4fMgZq4+AlTdG7GNFJw3cW7EqIu/grU2qgCTyrw9vXOp6cpzD3H jSpYZ4eUGHYGs1yF7VjoHdwXPjLdR3NUArnNSDeEMGfNIAWY/lZThr0Go2DXTjM7rmAumnp86/bc JBRALYq1AOGTVXQ5qW548FuIMIvQ+9KN4clrBZMSRvEAFVtIAE8EpHPuLUITlpg7Q8b2gVCqmG38 2kUN0ISwyE8PR9kahO9WaktWMawYVeWn2LDR6GOCUwPip2RhDAmCqzHLWUrEBDcOMuwh+eFziICV pDFM/kX3ES1yinyp8CFvlg0uinyPN9w449PBCSHfuVfzSTGCA2gwggNkAgEBMFYwTzELMAkGA1UE BhMCREUxFTATBgNVBAoMDEQtVHJ1c3QgR21iSDEpMCcGA1UEAwwgRC1UUlVTVCBBZHZhbmNlZCBD bGFzcyAyIENBIDIwMDcCAwdaiDAJBgUrDgMCGgUAoIIB5zAYBgkqhkiG9w0BCQMxCwYJKoZIhvcN AQcBMBwGCSqGSIb3DQEJBTEPFw0wODA5MDMxNzExNDVaMCMGCSqGSIb3DQEJBDEWBBThiFaFRLrt VL4ZbAQrexW2sLTsBjBlBgkrBgEEAYI3EAQxWDBWME8xCzAJBgNVBAYTAkRFMRUwEwYDVQQKDAxE LVRydXN0IEdtYkgxKTAnBgNVBAMMIEQtVFJVU1QgQWR2YW5jZWQgQ2xhc3MgMiBDQSAyMDA3AgMH WogwZwYLKoZIhvcNAQkQAgsxWKBWME8xCzAJBgNVBAYTAkRFMRUwEwYDVQQKDAxELVRydXN0IEdt YkgxKTAnBgNVBAMMIEQtVFJVU1QgQWR2YW5jZWQgQ2xhc3MgMiBDQSAyMDA3AgMHWogwgbcGCSqG SIb3DQEJDzGBqTCBpjALBglghkgBZQMEASowCwYJYIZIAWUDBAEWMAoGCCqGSIb3DQMHMAsGCWCG SAFlAwQBAjAOBggqhkiG9w0DAgICAIAwDQYIKoZIhvcNAwICAUAwBwYFKw4DAgcwDQYIKoZIhvcN AwICASgwBwYFKw4DAhowCwYJYIZIAWUDBAIDMAsGCWCGSAFlAwQCAjALBglghkgBZQMEAgEwCgYI KoZIhvcNAgUwDQYJKoZIhvcNAQEBBQAEggEAUrFR2q4t5nAyy8YeCb57mSIgeDDoSMbtWsZwdoF7 im8n4Qtapuxs+VyY4Xr1icjh2MaaiVcWZxdlO1xdkk/Vl6gnYIzZu8Jb5cPfOWtITjQskXwgYgCK BU63TAxifp+JqETuNvv93s+0a69hBflbxm+PB62cWZvG4Jq7ZrkvWRO3O2tY/SjRjelcx3C5KMKv fhZsoNfzr/+nGMvur85/SL1dsaQw6tWJOdUD5gACe3Ihb9uTTSqGUAB6UQ/hgCpCU1gJBAj5hEfK Wd16uHw6ncjmXandRxkPAOLYVvhijqEgvhpQqifywcoNN3Kdqpen3UtXJE+Gsy8KsrwjIna/ygAA AAAAAA== ------=_NextPart_000_009B_01C90DF8.E7E9F5D0--