Mailing-List: contact torque-user-help@db.apache.org; run by ezmlm
Precedence: bulk
Reply-To: "Apache Torque Users List" <torque-user@db.apache.org>
Received-SPF: pass (nike.apache.org: local policy)
From: Thoralf Rickert <thoralf.rickert@cadooz.de>
To: "'Apache Torque Users List'" <torque-user@db.apache.org>
Date: Fri, 11 Apr 2008 15:29:23 +0200
Thread-Topic: RE: Column names with spaces
Thread-Index: AcibKLoJRFjASgSSTiWU6wwzhna/BgAAovQQACjqhpAAAQVl4AABIj9A
Message-ID: 
 <A864307CE9C0D54191507125C95FC59E0C6DEED7@srv-exchange.cadooz-ag.intern>
References: 
 <A864307CE9C0D54191507125C95FC59E0C6DEECB@srv-exchange.cadooz-ag.intern>
 <OF5540D949.55C0D6BF-ONC1257427.005AD8AD-C1257427.005AF75F@seitenbau.net>
 <8F5843B903F59D4C8C6806BB49A3911906238570@dukece-mail3.dukece.com>
 <A864307CE9C0D54191507125C95FC59E0C6DEED6@srv-exchange.cadooz-ag.intern>
 <8F5843B903F59D4C8C6806BB49A3911906238B63@dukece-mail3.dukece.com>
In-Reply-To: 
 <8F5843B903F59D4C8C6806BB49A3911906238B63@dukece-mail3.dukece.com>
Accept-Language: de-DE
acceptlanguage: de-DE
MIME-Version: 1.0
Subject: AW: RE: Column names with spaces
MIME-Version: 1.0
Content-Type: multipart/signed; protocol="application/x-pkcs7-signature";
 micalg=sha1; boundary="----534746975D16AFA3FFE9965B991747E1"

------534746975D16AFA3FFE9965B991747E1
Content-Language: de-DE
Content-Type: text/plain; charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable

Hi,

Thanks for the answers.

I think the View is the best solution for now.

The changes to all the Base* classes and Base*Peers is not a problem, but t=
he criteria and the generated sql commands don't like the spaces if it isn'=
t escaped.

bye
Thoralf

> -----Urspr=FCngliche Nachricht-----
> Von: Greg Monroe [mailto:Greg.Monroe@DukeCE.com]
> Gesendet: Freitag, 11. April 2008 15:16
> An: Apache Torque Users List
> Betreff: RE: Column names with spaces
>
> OK, short version:  If you can't change the existing schema,
> use a view to get valid names.
>
> Longer version:
>
> Actually, the "[" syntax is not the only one that can be used
> with MS SQL. It also supports the SQL Standard defined
> delimited identifiers.  In the standard, normal identifiers
> (e.g. column/table names) have the same rules as Java/C
> variables. (with the exception that they are case insensitive...)
>
> If you want/need to use characters outside of this set, you
> need to use delimited identifiers.  These have the Standard
> defined syntax of "My Table!" (double quote's included).
> Delimited identifiers ARE case sensitive.
> So, the standards version id of a column in your table would
> be written like: "Time after".time_col
>
> AFAIK, this syntax is pretty widely supported by the major DB players.
>
> As Thomas F said, getting Torque to recognize and map the
> Java names to the real names is going to be a hard thing.
>
> One thing that *might* work out of the box is the various ant
> tasks.  If you define your names in the XML to include the
> double quotes, the SQL generated by these should work.
>
> To be complete, I guess you could also try to generate the
> code with the delimited cases and then "fix up" the classes
> that don't compile.  You'd also have to make sure the Map
> classes used the correct strings as well.  Not very
> maintainable but...
>
>
> > -----Original Message-----
> > From: Thoralf Rickert [mailto:thoralf.rickert@cadooz.de]
> > Sent: Friday, April 11, 2008 8:39 AM
> > To: 'Apache Torque Users List'
> > Subject: Column names with spaces
> >
> > Hi,
> >
> > Of course the list of problems with mssql doesn't stop...
> >
> > I've got now a xml schema from the existing database. Some "lovely
> boy"
> > decided years ago that it would be nice to use spaces inside the
> column
> > names of the database scheme. For example: "Time after".
> This is not a
> > problem if you use the special syntax "[Time after]" in a
> select. But
> I
> > don't have this kind of access with Torque (prove me wrong, if not).
> If
> > I try to make a Criteria, Torque quits this selection with
> >
> > Malformed column name in Criteria getTableName: 'T_Stammdaten.Time
> > after' is not of the form 'table.column'
> >
> > Okay, actually this is an error that doesn't have something
> to do with
> > the real problem. Is there a way to setup a database
> specific syntax
> > for column names. So in MySQL it would be "`" or in MSSQL/Sybase it
> > would be "[" and "]".
> >
> > Additionally - I think the "torque" task that generates the classes
> > should escape the spaces if it uses the database column names to
> > generate column constants (currently it produces
> >
> > public static String TIME AFTER =3D "...".
> >
> > Has somebody an idea, how to get around this problem?
> >
> >
> > Bye
> > Thoralf
> DukeCE Privacy Statement:
> Please be advised that this e-mail and any files transmitted
> with it are confidential communication or may otherwise be
> privileged or confidential and are intended solely for the
> individual or entity to whom they are addressed. If you are
> not the intended recipient you may not rely on the contents
> of this email or any attachments, and we ask that you please
> not read, copy or retransmit this communication, but reply to
> the sender and destroy the email, its contents, and all
> copies thereof immediately. Any unauthorized dissemination,
> distribution or copying of this communication is strictly prohibited.
>
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: torque-user-unsubscribe@db.apache.org
> For additional commands, e-mail: torque-user-help@db.apache.org
>
>

------534746975D16AFA3FFE9965B991747E1
Content-Type: application/x-pkcs7-signature; name="smime.p7s"
Content-Transfer-Encoding: base64
Content-Disposition: attachment; filename="smime.p7s"

MIIHqAYJKoZIhvcNAQcCoIIHmTCCB5UCAQExCzAJBgUrDgMCGgUAMAsGCSqGSIb3
DQEHAaCCBQUwggUBMIIEaqADAgECAg5usgABAAIwWJT7ToAkejANBgkqhkiG9w0B
AQUFADB9MQswCQYDVQQGEwJERTEcMBoGA1UEChMTVEMgVHJ1c3RDZW50ZXIgR21i
SDElMCMGA1UECxMcVEMgVHJ1c3RDZW50ZXIgQ2xhc3MgMiBMMSBDQTEpMCcGA1UE
AxMgVEMgVHJ1c3RDZW50ZXIgQ2xhc3MgMiBMMSBDQSBJSUkwHhcNMDcwNTE2MTIw
NTA0WhcNMTAwNTE2MTIwNTA0WjCBljELMAkGA1UEBhMCREUxEDAOBgNVBAgTB0hh
bWJ1cmcxEDAOBgNVBAcTB0hhbWJ1cmcxEjAQBgNVBAoTCWNhZG9veiBBRzELMAkG
A1UECxMCSVQxGDAWBgNVBAMTD1Rob3JhbGYgUmlja2VydDEoMCYGCSqGSIb3DQEJ
ARYZdGhvcmFsZi5yaWNrZXJ0QGNhZG9vei5kZTCCASIwDQYJKoZIhvcNAQEBBQAD
ggEPADCCAQoCggEBANLarRU9ocw5XFnWhBVYbZig9mXoA5bI71uXdK1oQoP53+QU
0T+G0smP2jBhW6cLJkRQFB7Ptzh4jL8C2cJjRDh5WVXq5nt8dLTu7u25cXwGMN0h
dsijyy6bDPbDInseGWS9v7Pzeh1+ViGUzGPBaPGzT1oppspiyMpcnv9lCO+zSLSn
oT978lznh33Depj1cXt4ubukST5F3nguk2tzQ9IyRvCkw8oQvG5V+NbUb+PW4zdM
inpokpZjkNSYgnoVQmz8nTzuplxmSSRW6QGtlxRAowEVRwZ9hob6X63asIP8qume
+HXy0gvUWSWtPYSUq7/753Utd3L7douIsn/xmYECAwEAAaOCAeQwggHgMIGZBggr
BgEFBQcBAQSBjDCBiTBSBggrBgEFBQcwAoZGaHR0cDovL3d3dy50cnVzdGNlbnRl
ci5kZS9jZXJ0c2VydmljZXMvY2FjZXJ0cy90Y19jbGFzczJfTDFfQ0FfSUlJLmNy
dDAzBggrBgEFBQcwAYYnaHR0cDovL29jc3AuSUlJLnRjY2xhc3MyLnRydXN0Y2Vu
dGVyLmRlMB8GA1UdIwQYMBaAFEcQCFHz6oagh8omxZiNP+H2H93eMAwGA1UdEwEB
/wQCMAAwSgYDVR0gBEMwQTA/BgkqghQALAEBAQIwMjAwBggrBgEFBQcCARYkaHR0
cDovL3d3dy50cnVzdGNlbnRlci5kZS9ndWlkZWxpbmVzMA4GA1UdDwEB/wQEAwIF
4DAdBgNVHQ4EFgQUPr9JFP1QLqQCmjeJ/a1pcrpbtBMwSQYDVR0fBEIwQDA+oDyg
OoY4aHR0cDovL3d3dy50cnVzdGNlbnRlci5kZS9jcmwvdjIvdGNfY2xhc3MyX0wx
X0NBX0lJSS5jcmwwJwYDVR0lBCAwHgYIKwYBBQUHAwIGCCsGAQUFBwMEBggrBgEF
BQcDBzAkBgNVHREEHTAbgRl0aG9yYWxmLnJpY2tlcnRAY2Fkb296LmRlMA0GCSqG
SIb3DQEBBQUAA4GBAMqXmavyS4bgt3+JBHaUkMZL53wq92a1fZUs7DbFiXE6owdO
FSLtLkSMy9ag+kT5R4v6AFgm6J0hmR9NEjIF/3k/CxjrsrIVQxEBOFy/VN2M2Mek
dFCiuX5QoxegZiBwzCIrRbwziXxVwGWl7xnqsgepZY5R51jaX6o6HdmVJwmLMYIC
azCCAmcCAQEwgY8wfTELMAkGA1UEBhMCREUxHDAaBgNVBAoTE1RDIFRydXN0Q2Vu
dGVyIEdtYkgxJTAjBgNVBAsTHFRDIFRydXN0Q2VudGVyIENsYXNzIDIgTDEgQ0Ex
KTAnBgNVBAMTIFRDIFRydXN0Q2VudGVyIENsYXNzIDIgTDEgQ0EgSUlJAg5usgAB
AAIwWJT7ToAkejAJBgUrDgMCGgUAoIGxMBgGCSqGSIb3DQEJAzELBgkqhkiG9w0B
BwEwHAYJKoZIhvcNAQkFMQ8XDTA4MDQxMTEzMjkyNlowIwYJKoZIhvcNAQkEMRYE
FKZ5z6GEXpB6OBZ7ubVX+sdNRH2UMFIGCSqGSIb3DQEJDzFFMEMwCgYIKoZIhvcN
AwcwDgYIKoZIhvcNAwICAgCAMA0GCCqGSIb3DQMCAgFAMAcGBSsOAwIHMA0GCCqG
SIb3DQMCAgEoMA0GCSqGSIb3DQEBAQUABIIBAIbSFcPY6QxuaPDPLlOS6bJu3jGF
0ljbubxIyY5IQDc8EbsmQbNNN4yLMTnpNpv7qSdHf2H1AvjzCwOi5lOzmWKseGmx
HoOi50JvGxjlHnbraY9cO0ZLdikvguh1ZtCYkTlcXhSZZReWzFCQtRl3fbpB5z2P
0qkw/AVizaZRB0sNd8MUAV8RH6EMqtEGrhQhsH2oO2AbSSaailZ01S2PQHvxmKRu
UcxI7A7fNutVf/cLL7zAEmTtkeKpL0PrEpXF8wjaphyb+rTDFcUY7//1PAPbph4x
JF+rjIHImm/J7vVfKLjMN+xT/5VKSH0kEXTPZTipPlhxpCSqVk4Cef7tJA8=

------534746975D16AFA3FFE9965B991747E1--