You are viewing a plain text version of this content. The canonical link for it is here.
Posted to torque-user@db.apache.org by "Zhang, Andy" <we...@lehman.com> on 2006/08/31 16:38:37 UTC

Generating SQL from XSD

I thought Torque can generate SQL DDL from an XSD file.  Am I correct?
If so, where can I find relavent documents?

Thanks,

------------------------------------------------------------------------------
This message is intended only for the personal and confidential use of the designated recipient(s) named above.  If you are not the intended recipient of this message you are hereby notified that any review, dissemination, distribution or copying of this message is strictly prohibited.  This communication is for information purposes only and should not be regarded as an offer to sell or as a solicitation of an offer to buy any financial product, an official confirmation of any transaction, or as an official statement of Lehman Brothers.  Email transmission cannot be guaranteed to be secure or error-free.  Therefore, we do not represent that this information is complete or accurate and it should not be relied upon as such.  All information is subject to change without notice.
----------
IRS Circular 230 Disclosure:
Please be advised that any discussion of U.S. tax matters contained within this communication (including any attachments) is not intended or written to be used and cannot be used for the purpose of (i) avoiding U.S. tax related penalties or (ii) promoting, marketing or recommending to another party any transaction or matter addressed herein.

--------
IRS Circular 230 Disclosure:
Please be advised that any discussion of U.S. tax matters contained within this communication (including any attachments) is not intended or written to be used and cannot be used for the purpose of (i) avoiding U.S. tax related penalties or (ii) promoting, marketing or recommending to another party any transaction or matter addressed herein.



---------------------------------------------------------------------
To unsubscribe, e-mail: torque-user-unsubscribe@db.apache.org
For additional commands, e-mail: torque-user-help@db.apache.org


Re[2]: Configuring encoding that is used for jdbc connection

Posted by Anton Tonchev <to...@xi-tec.com>.
Thanks for the help.

The problem was not in torque but in the data that i receive before
that.

Anyway the way to set the encoding is through the parameters of the
connection string.

Regards.


---------------------------------------------------------------------
To unsubscribe, e-mail: torque-user-unsubscribe@db.apache.org
For additional commands, e-mail: torque-user-help@db.apache.org


Re: Configuring encoding that is used for jdbc connection

Posted by Joe Carter <jo...@excite.com>.
Certainly for Sybase it's set via the database itself.
It's independent of Torque.
We moved to UTF-8 to avoid charset issues.

Joe

On 06/09/06, Thomas Fischer <fi...@seitenbau.net> wrote:
>
> Hi,
>
> I do not know of a feature of Torque that allows setting the encoding of
> characters sent to the database. I would expect one would have to set that
> inside the  database driver. Did you check the Mysql Driver documentation
> ?
>
>     Thomas
> Anton Tonchev <to...@xi-tec.com> schrieb am 06.09.2006 09:52:51:
>
> > Hello!
> >
> > I am trying to configure torque so that it manages cyrillic characters
> > correctly. The database (in my case MySQL) is configured to use as
> > default charset cp1251. Anyway when i try to save something in
> > cyrillic through torque i get "????" in the database.
> >
> > Where i can specify the encoding of the connection to the database?
> >
> > Thanks in advance.
> >
> >
> > ---------------------------------------------------------------------
> > To unsubscribe, e-mail: torque-user-unsubscribe@db.apache.org
> > For additional commands, e-mail: torque-user-help@db.apache.org
> >
>
>
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: torque-user-unsubscribe@db.apache.org
> For additional commands, e-mail: torque-user-help@db.apache.org
>
>

RE: Configuring encoding that is used for jdbc connection

Posted by Thomas Fischer <fi...@seitenbau.net>.
Hi,

I do not know of a feature of Torque that allows setting the encoding of
characters sent to the database. I would expect one would have to set that
inside the  database driver. Did you check the Mysql Driver documentation ?

    Thomas
Anton Tonchev <to...@xi-tec.com> schrieb am 06.09.2006 09:52:51:

> Hello!
>
> I am trying to configure torque so that it manages cyrillic characters
> correctly. The database (in my case MySQL) is configured to use as
> default charset cp1251. Anyway when i try to save something in
> cyrillic through torque i get "????" in the database.
>
> Where i can specify the encoding of the connection to the database?
>
> Thanks in advance.
>
>
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: torque-user-unsubscribe@db.apache.org
> For additional commands, e-mail: torque-user-help@db.apache.org
>


---------------------------------------------------------------------
To unsubscribe, e-mail: torque-user-unsubscribe@db.apache.org
For additional commands, e-mail: torque-user-help@db.apache.org


Configuring encoding that is used for jdbc connection

Posted by Anton Tonchev <to...@xi-tec.com>.
Hello!

I am trying to configure torque so that it manages cyrillic characters
correctly. The database (in my case MySQL) is configured to use as
default charset cp1251. Anyway when i try to save something in
cyrillic through torque i get "????" in the database.

Where i can specify the encoding of the connection to the database?

Thanks in advance.


---------------------------------------------------------------------
To unsubscribe, e-mail: torque-user-unsubscribe@db.apache.org
For additional commands, e-mail: torque-user-help@db.apache.org


RE: Generating SQL from XSD

Posted by Thomas Fischer <fi...@seitenbau.net>.
This is one of the secret features of Torque that have been hidden from me
hitherto. I do not think it exists, but I may be mistaken here. Where did
you get that information from ? And what do you mean by "SQL DDL" ?

   Thomas

"Zhang, Andy" <we...@lehman.com> schrieb am 31.08.2006 16:38:37:

>
> I thought Torque can generate SQL DDL from an XSD file.  Am I correct?
> If so, where can I find relavent documents?
>
> Thanks,
>
>
------------------------------------------------------------------------------

> This message is intended only for the personal and confidential use
> of the designated recipient(s) named above.  If you are not the
> intended recipient of this message you are hereby notified that any
> review, dissemination, distribution or copying of this message is
> strictly prohibited.  This communication is for information purposes
> only and should not be regarded as an offer to sell or as a
> solicitation of an offer to buy any financial product, an official
> confirmation of any transaction, or as an official statement of
> Lehman Brothers.  Email transmission cannot be guaranteed to be
> secure or error-free.  Therefore, we do not represent that this
> information is complete or accurate and it should not be relied upon
> as such.  All information is subject to change without notice.
> ----------
> IRS Circular 230 Disclosure:
> Please be advised that any discussion of U.S. tax matters contained
> within this communication (including any attachments) is not
> intended or written to be used and cannot be used for the purpose of
> (i) avoiding U.S. tax related penalties or (ii) promoting, marketing
> or recommending to another party any transaction or matter addressed
herein.
>
> --------
> IRS Circular 230 Disclosure:
> Please be advised that any discussion of U.S. tax matters contained
> within this communication (including any attachments) is not
> intended or written to be used and cannot be used for the purpose of
> (i) avoiding U.S. tax related penalties or (ii) promoting, marketing
> or recommending to another party any transaction or matter addressed
herein.
>
>
>
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: torque-user-unsubscribe@db.apache.org
> For additional commands, e-mail: torque-user-help@db.apache.org
>


---------------------------------------------------------------------
To unsubscribe, e-mail: torque-user-unsubscribe@db.apache.org
For additional commands, e-mail: torque-user-help@db.apache.org