Hi, I am facing certain problem in writing repository_user.xml.
I have a table group which has a composite primary key with columns group_id and group_user_id as the primary key elements. and another table user which has primary key with column user_id. The two tables have many:many relationship sot there is an association table named group_user_assoc. I want to ask how should I describe collection descriptor for user in class descriptor of group. Here how will I mention about <fk-pointing-to-this-class>.Would there be two <fk-pointing-to-this-class /> each mentioning about the column of composite primary key. Could anyone help me in this Regards Alok >>-----Original Message----- >>From: Max Rydahl Andersen [mailto:[EMAIL PROTECTED]] >>Sent: Tuesday, September 17, 2002 12:53 PM >>To: OJB Users List >>Subject: Re: Additional JDBC Properties >> >> >>Some drivers allows you to appende the properties as a ; og , >>seperated list >>after the url. >> >>So try set this in your url >>url=whateverurl;CHARSET_CONVERTER_CLASS=com.sybase.jdbc2.utils >>.TruncationCon >>verter,CHARSET=roman8 >> >>lookup the doc for the sybase driver to see the correct syntax... >> >>/max >> >>----- Original Message ----- >>From: "Gibbs, Tim" <[EMAIL PROTECTED]> >>To: <[EMAIL PROTECTED]> >>Sent: Monday, September 16, 2002 6:33 PM >>Subject: Additional JDBC Properties >> >> >> >>I am back to trying to get OJB working with Sybase which is >>proving to be >>rather annoying. >> >>The problem that I am currently working on relates to passing >>additional >>JDBC information to the newly created connection. For example when we >>create a JDBC connection we do it as follows: >> >>Class.forName("com.sybase.jdbc2.jdbc.SybDriver"); >>conn = DriverManager.getConnection(connectionURL,props); >> >>where props = java.util.Properties >> >>which are: >> >>USER=myDBUser >>PASSWORD=myDBPassword >>CHARSET_CONVERTER_CLASS=com.sybase.jdbc2.utils.TruncationConverter >>CHARSET=roman8 >> >>Now pay special attention to the CHARSET_CONVERTER_CLASS and >>the CHARSET >>properties. These two properties MUST be set for our version >>of java (1.4) >>and Sybase or the connections throw an exception as follows: >> >>java.sql.SQLException: JZ006: Caught IOException: java.io.IOException: >>JZ0I6: An error occured converting UNICODE to the charset used by the >>server. Error message: java.io.CharConversionException: >>java.io.UnsupportedEncodingException: hp-roman8 >> >>Now, we know that to solve the exception in JDBC is to add the above >>properties to the connection creation but there doesn't seem >>to be any way >>to include "supplemental" properties to the JDBC connection >>handlers in OJB >>because after reviewing the source code for: >>AbstractConnectionFactory we >>find that the connection created using: >> >> if (jcd.getUserName() == null) >> { >> retval = java.sql.DriverManager.getConnection(url); >> } >> else >> { >> retval = java.sql.DriverManager.getConnection(url, >>jcd.getUserName(), jcd.getPassWord()); >> } >> >>which seems to preclude the use of additional properties. >> >>Can someone provide some guidance as to how I might fix this >>issue. Have I >>missed something in the connection descriptor? >> >>Thanks for any help! >> >>Tim >> >> >>-------------------------------------------- >>Tim Gibbs >>RBC Capital Markets >>Phone: (416) 842-4663 >>E-Mail: [EMAIL PROTECTED] >> >> >> >><font face="Times New Roman" size="3"> >><p>----------------------------------------------------------- >>-------------- >>-----</p> >><p> This e-mail may be privileged and/or confidential, and >>the sender does >>not waive any related rights and obligations. Any distribution, use or >>copying of this e-mail or the information it contains by other than an >>intended recipient is unauthorized. If you received this >>e-mail in error, >>please advise me (by return e-mail or otherwise) immediately.</p> >><p> Ce courriel est confidentiel et prot�g�. L'exp�diteur ne >>renonce pas aux >>droits et obligations qui s'y rapportent. Toute diffusion, >>utilisation ou >>copie de ce message ou des renseignements qu'il contient par >>une personne >>autre que le (les) destinataire(s) d�sign�(s) est interdite. >>Si vous recevez >>ce courriel par erreur, veuillez m'en aviser imm�diatement, >>par retour de >>courriel ou par un autre moyen.</p> >><p>====================================================</p> >></font> >> >> >> >> >>-- >>To unsubscribe, e-mail: <mailto:[EMAIL PROTECTED]> For additional commands, e-mail: <mailto:[EMAIL PROTECTED]> -- To unsubscribe, e-mail: <mailto:[EMAIL PROTECTED]> For additional commands, e-mail: <mailto:[EMAIL PROTECTED]>
