M:N question
Hello, I have a emergent question.Here I have designed 3 tables:User Domain Role and I have implemented User - Role M:N relation by add a table User_Role including the PK of table User & Role and write repository xml file(collection-descriptor, fk-pointing-to-this-class fk-pointing-to-element-class).Now I want to add a column of PK of Domain in table user_role,which means a user in a domain have a role,who can tell me how to implement it, thanks a lot.
答复: Re: One To More Implements
I have resolved it yesterday.remove: > name="account" >class-ref="webserverdemo.Account" > > > > will be ok! "Smilefish" <[EMAIL PROTECTED]> 2003-07-24 21:20 请答复 给 "OJB Users List" 收件人:"OJB Users List" <[EMAIL PROTECTED]> 抄送: 主题: Re: One To More Implements bian.xiaochun: So, is the jdk version of your testClient the same as the jdk version of the jboss? Smilefish [EMAIL PROTECTED] -- Reply -- 在 2003年7月24日 14:13:13 您写道: > Hi,I faced a small problem: > > Refer to the Tutorial,I created two tables and JavaBeans. > > class Account : > protected Integer userID; > protected String userName; > protected String userPassword; > protected VectoruserBills = null; > > ... > > class Bill : > > protected Integer flowNo; > protected Integer userID; > protected String telephoneNumber; > protected Integer lastTime; > protected Double fee; > protected InterfaceAccount account; > > ... > > Repository.xml: > > class="webserverdemo.Account" > table="account" > > > .. > >name="userBills" > element-class-ref="webserverdemo.Bill" > collection-class="java.util.Vector" > auto-retrieve="true" > auto-update="true" > auto-delete="true" > > > > > > > class="webserverdemo.Bill" > table="bill" > > > > .. > > name="account" >class-ref="webserverdemo.Account" > > > > > > >TestClient.java > > ... > > Bill a = new Bill(new Integer(1),new Integer(1),"1234567",new > Integer(100),new Double(1.20)); > Bill b = new Bill(new Integer(2),new Integer(1),"123456789",new > Integer(200),new Double(1.30)); > > Account account = new Account(new Integer(1),"bxc","k4hvd"); > account.addBill(a); > account.addBill(b); > > The Result is :In my DB(MySQL),in table Bill,column "userID" is NULL > . > > and if execute the following code even if I update table bill and > set > column "userID" > > the correct value,JBOSS3 will throws th exception: > > > Account queryAccount = new Account(); > queryAccount.setUserID(new Integer(1)); > Query query = new QueryByCriteria(queryAccount); > account = (Account)broker.getObjectByQuery(query); > > Exception: > > 14:07:14,471 ERROR [STDERR] java.lang.ClassCastException: java.util. > Vector > at > org.apache.ojb.broker.core.PersistenceBrokerImpl.getCollectionByQuery > (Unknown Source) > at > org.apache.ojb.broker.core.PersistenceBrokerImpl.getCollectionByQuery > (Unknown Source) > at > org.apache.ojb.broker.core.PersistenceBrokerImpl.retrieveCollection(U > nknown Source) > at > org.apache.ojb.broker.core.PersistenceBrokerImpl.retrieveCollections( > Unknown Source) > at > org.apache.ojb.broker.accesslayer.RsIterator.getObjectFromResultSet(U > nknown Source) > at org.apache.ojb.broker.accesslayer.RsIterator.next(Unknown > Source) > at > org.apache.ojb.broker.core.PersistenceBrokerImpl.getCollectionByQuery > (Unknown Source) > at > org.apache.ojb.broker.core.PersistenceBrokerImpl.getCollectionByQuery > (Unknown Source) > at > org.apache.ojb.broker.core.PersistenceBrokerImpl.getCollectionByQuery > (Unknown Source) > at > org.apache.ojb.broker.core.PersistenceBrokerImpl.getCollectionByQuery > (Unknown Source) > at > org.apache.ojb.broker.core.PersistenceBrokerImpl.getObjectByQuery(Unk > nown Source) > at > org.apache.ojb.broker.core.DelegatingPersistenceBroker.getObjectByQue > ry(Unknown Source) > at > webserverdemo.WebServerDemoBean.reportQuery(WebServerDemoBean.java:16 > 9) > at java.lang.reflect.Method.invoke(Native Method) > at > org.jboss.ejb.StatelessSessionContainer$ContainerInterceptor.invoke(S > tatelessSessionContainer.java:660) > at > org.jboss.resource.connectionmanager.CachedConnectionInterceptor.invo > ke(CachedConnectionInterceptor.java:186) > at > org.jboss.ejb.plugins.StatelessSessionInstanceInterceptor.invoke(Stat > elessSessionInstanceInterceptor.java:77) > at > org.jboss.ejb.plugins.AbstractTxInterceptor.invokeNext(AbstractTxInte > rceptor.java:107) > at > org.jboss.ejb.plugins.TxInterceptorCMT.runWithTransactions(TxIntercep > torCMT.java:237) > at > org.jboss.ejb.plugins.TxInterceptorCMT.invoke(TxInterceptorCMT.java:9 > 8) > at > org.jboss.ejb.plugins.SecurityInterceptor.invoke(SecurityInterceptor. > java:130) > at > org.jboss.ejb.plugins.LogInterceptor.invoke(LogInterceptor.java:208) > at > org.jboss.ejb.Stateles
答复: Integer fields not being populated
I think there is some problem in your java bean source file. Andrew Clute <[EMAIL PROTECTED]> 2003-07-25 02:01 请答复 给 "OJB Users List" 收件人:<[EMAIL PROTECTED]> 抄送: 主题: Integer fields not being populated I have a simple class with a couple of strings and a couple of integers (int), however, not matter how I try, when I restore the row, two of the integer fields are never populated (they just return 0). The first integer field (rowID) and the two String fields will populate, but the irn and applicationType will not. Any thoughts? Here is the class description: - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
答复: Re: Errormessages
Please paste your repository.xml "Roland Carlsson" <[EMAIL PROTECTED]> 2003-07-24 14:52 请答复 给 "OJB Users List" 收件人:"OJB Users List" <[EMAIL PROTECTED]> 抄送: 主题: Re: Errormessages Hi!The errormessage is below. I occurs if I do something wrong in the repository.xml. What I would like to know is what is wrong. javax.servlet.ServletException: Borrow broker from pool failed at org.apache.jasper.runtime.PageContextImpl.handlePageException(PageContextImp l.java:471) at org.apache.jsp.uploadfile$jsp._jspService(uploadfile$jsp.java:200) at org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:107) at javax.servlet.http.HttpServlet.service(HttpServlet.java:853) at org.netbeans.modules.tomcat.tomcat40.runtime.IDEJspServlet$JspServletWrapper .service(IDEJspServlet.java:173) at org.netbeans.modules.tomcat.tomcat40.runtime.IDEJspServlet.serviceJspFile(ID EJspServlet.java:246) at org.netbeans.modules.tomcat.tomcat40.runtime.IDEJspServlet.service(IDEJspSer vlet.java:339) at javax.servlet.http.HttpServlet.service(HttpServlet.java:853) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(Application FilterChain.java:247) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterCh ain.java:193) at org.netbeans.modules.web.monitor.server.MonitorFilter.doFilter(MonitorFilter .java:226) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(Application FilterChain.java:213) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterCh ain.java:193) at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.ja va:243) at org.apache.catalina.core.StandardPipeline.invokeNext(StandardPipeline.java:5 66) at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:472) at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:943) at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.ja va:190) at org.apache.catalina.core.StandardPipeline.invokeNext(StandardPipeline.java:5 66) at org.apache.catalina.valves.CertificatesValve.invoke(CertificatesValve.java:2 46) at org.apache.catalina.core.StandardPipeline.invokeNext(StandardPipeline.java:5 64) at org.netbeans.modules.web.monitor.catalina.MonitorValve.invoke(MonitorValve.j ava:148) at org.apache.catalina.core.StandardPipeline.invokeNext(StandardPipeline.java:5 64) at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:472) at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:943) at org.apache.catalina.core.StandardContext.invoke(StandardContext.java:2347) at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:180 ) at org.apache.catalina.core.StandardPipeline.invokeNext(StandardPipeline.java:5 66) at org.apache.catalina.valves.ErrorDispatcherValve.invoke(ErrorDispatcherValve. java:170) at org.apache.catalina.core.StandardPipeline.invokeNext(StandardPipeline.java:5 64) at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:170 ) at org.apache.catalina.core.StandardPipeline.invokeNext(StandardPipeline.java:5 64) at org.apache.catalina.valves.AccessLogValve.invoke(AccessLogValve.java:468) at org.apache.catalina.core.StandardPipeline.invokeNext(StandardPipeline.java:5 64) at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:472) at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:943) at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java :174) at org.apache.catalina.core.StandardPipeline.invokeNext(StandardPipeline.java:5 66) at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:472) at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:943) at org.apache.catalina.connector.http.HttpProcessor.process(HttpProcessor.java: 1027) at org.apache.catalina.connector.http.HttpProcessor.run(HttpProcessor.java:1125 ) at java.lang.Thread.run(Thread.java:534) root cause org.apache.ojb.broker.PBFactoryException: Borrow broker from pool failed at org.apache.ojb.broker.ta.PersistenceBrokerFactoryDefaultImpl.createPersisten ceBroker(Unknown Source) at org.apache.ojb.broker.ta.PersistenceBrokerFact
One To More Implements
Hi,I faced a small problem: Refer to the Tutorial,I created two tables and JavaBeans. class Account : protected Integer userID; protected String userName; protected String userPassword; protected VectoruserBills = null; ... class Bill : protected Integer flowNo; protected Integer userID; protected String telephoneNumber; protected Integer lastTime; protected Double fee; protected InterfaceAccount account; ... Repository.xml: .. .. TestClient.java ... Bill a = new Bill(new Integer(1),new Integer(1),"1234567",new Integer(100),new Double(1.20)); Bill b = new Bill(new Integer(2),new Integer(1),"123456789",new Integer(200),new Double(1.30)); Account account = new Account(new Integer(1),"bxc","k4hvd"); account.addBill(a); account.addBill(b); The Result is :In my DB(MySQL),in table Bill,column "userID" is NULL. and if execute the following code even if I update table bill and set column "userID" the correct value,JBOSS3 will throws th exception: Account queryAccount = new Account(); queryAccount.setUserID(new Integer(1)); Query query = new QueryByCriteria(queryAccount); account = (Account)broker.getObjectByQuery(query); Exception: 14:07:14,471 ERROR [STDERR] java.lang.ClassCastException: java.util.Vector at org.apache.ojb.broker.core.PersistenceBrokerImpl.getCollectionByQuery (Unknown Source) at org.apache.ojb.broker.core.PersistenceBrokerImpl.getCollectionByQuery (Unknown Source) at org.apache.ojb.broker.core.PersistenceBrokerImpl.retrieveCollection(U nknown Source) at org.apache.ojb.broker.core.PersistenceBrokerImpl.retrieveCollections( Unknown Source) at org.apache.ojb.broker.accesslayer.RsIterator.getObjectFromResultSet(U nknown Source) at org.apache.ojb.broker.accesslayer.RsIterator.next(Unknown Source) at org.apache.ojb.broker.core.PersistenceBrokerImpl.getCollectionByQuery (Unknown Source) at org.apache.ojb.broker.core.PersistenceBrokerImpl.getCollectionByQuery (Unknown Source) at org.apache.ojb.broker.core.PersistenceBrokerImpl.getCollectionByQuery (Unknown Source) at org.apache.ojb.broker.core.PersistenceBrokerImpl.getCollectionByQuery (Unknown Source) at org.apache.ojb.broker.core.PersistenceBrokerImpl.getObjectByQuery(Unk nown Source) at org.apache.ojb.broker.core.DelegatingPersistenceBroker.getObjectByQue ry(Unknown Source) at webserverdemo.WebServerDemoBean.reportQuery(WebServerDemoBean.java:16 9) at java.lang.reflect.Method.invoke(Native Method) at org.jboss.ejb.StatelessSessionContainer$ContainerInterceptor.invoke(S tatelessSessionContainer.java:660) at org.jboss.resource.connectionmanager.CachedConnectionInterceptor.invo ke(CachedConnectionInterceptor.java:186) at org.jboss.ejb.plugins.StatelessSessionInstanceInterceptor.invoke(Stat elessSessionInstanceInterceptor.java:77) at org.jboss.ejb.plugins.AbstractTxInterceptor.invokeNext(AbstractTxInte rceptor.java:107) at org.jboss.ejb.plugins.TxInterceptorCMT.runWithTransactions(TxIntercep torCMT.java:237) at org.jboss.ejb.plugins.TxInterceptorCMT.invoke(TxInterceptorCMT.java:9 8) at org.jboss.ejb.plugins.SecurityInterceptor.invoke(SecurityInterceptor. java:130) at org.jboss.ejb.plugins.LogInterceptor.invoke(LogInterceptor.java:208) at org.jboss.ejb.StatelessSessionContainer.invoke(StatelessSessionContai ner.java:313) at org.jboss.ejb.Container.invoke(Container.java:738) at org.jboss.mx.server.MBeanServerImpl.invoke(MBeanServerImpl.java:517) at org.jboss.invocation.jrmp.server.JRMPInvoker.invoke(JRMPInvoker.java: 383) at java.lang.reflect.Method.invoke(Native Method) at sun.rmi.server.UnicastServerRef.dispatch(UnicastServerRef.java:241) at sun.rmi.transport.Transport$1.run(Transport.java:152) at java.security.AccessController.doPrivileged(Native Method) at sun.rmi.transport.Transport.serviceCall(Transport.java:148) at sun.rmi.transport.tcp.TCPTransport.handleMessages(TCPTransport.java:4 65) at sun.rmi.transport.tcp.TCPTransport$ConnectionHandler.run(TCPTransport .java:706) at java.lang.Thread.run(Thread.java:484) rethrown as org.apache.ojb.broker.PersistenceBrokerException: java.util.Vector at org.apache.ojb.broker.core.PersistenceBrokerImpl.getCollectionByQuery (Unknown Source) at org.apache.ojb.broker.core.PersistenceBrokerImpl.retrieveCollection(U nknown Source) at org.apache.ojb.broker.core.PersistenceBrokerImpl.retrieveCollections( Unknown Source) at org.apache.ojb.broker.accesslayer.RsIterator.ge