Hi Armin, Another question! I try using scrollable resultset in PB query. I found that, when i hot-redeploy the beans in Jboss the OJB won't obey the index I set, but will return back the whole resultset. But, if I restart Jboss, this problems will gone, and the beans will obey the index I set. What's the problems anywhere?
Thanks Regards, Stephen > -----Original Message----- > From: Armin Waibel [mailto:[EMAIL PROTECTED]] > Sent: 15 January 2003 16:00 > To: OJB Users List; Stephen Ting Tiew Ung > Subject: Re: Failed to deploy in JBoss 3.0.4 > > > Hi Stephen, > > ----- Original Message ----- > From: "Stephen Ting" <[EMAIL PROTECTED]> > To: "'OJB Users List'" <[EMAIL PROTECTED]>; > "Stephen Ting Tiew Ung" <[EMAIL PROTECTED]> > Sent: Wednesday, January 15, 2003 4:05 AM > Subject: RE: Failed to deploy in JBoss 3.0.4 > > > > I am getting nearer. Now I am able to deploy the session bean > > succesfully, create the PB. However, when I try get data from > databases > > (MSSQL server). Seems there are problems in Sequence manger. The > errors > > message said, > > RuntimeException: java.lang.UnsupportedOperationException: Not > supported > > in managed environment > > > > I had try all the sequence manager and seems the same > errors occured. > > You have to use datasources from the appServer, > instead of direct connect via DriverManager. > Example see the Datasource jdbc-connection-descriptor in > the repository and 'deployment' doc from CVS. > For testing with MSSql use the SequenceInMemoryImpl, > SequenceManagerNextValImpl does currently not support MSSql > (we have to adapt PlatformMsSQLServerImpl first). > > regards, > Armin > > > > > > > My jdbc connection descriptor is as follow; > > > > Any help is very much appreciated. > > > > Thanks > > > > Regards, > > Stephen > > > > > > <jdbc-connection-descriptor > > jcd-alias="default" > > default-connection="true" > > platform="MsSQLServer" > > jdbc-level="2.0" > > eager-release="true" > > driver="com.jnetdirect.jsql.JSQLDriver" > > protocol="jdbc" > > subprotocol="JSQLConnect" > > dbalias="//syemail:1433/database=bpcs" > > username="sa" > > password="" > > batch-mode="false"> > > > > <connection-pool > > maxActive="21" > > validationQuery="" /> > > > > <sequence-manager > > > className="org.apache.ojb.broker.util.sequence.SequenceManager > NextValImp > > l"> > > <attribute attribute-name="grabSize" > attribute-value="20"/> > > </sequence-manager> > > </jdbc-connection-descriptor> > > > > > > 2003-01-15 10:56:15,588 INFO [STDOUT] > > > [org.apache.ojb.broker.ta.PersistenceBrokerFactoryDefaultImpl] INFO: > > 2003-01-15 10:56:15,588 INFO [STDOUT] Create PersistenceBroker > instance > > pool, pool configuration was {whenExhaustedAction=0, maxIdle=-1, > > maxActive=100, maxWait=2000, removeAbandoned=false, > > numTestsPerEvictionRun=10, testWhileIdle=false, > > minEvictableIdleTimeMillis=1000000, testOnReturn=false, > > logAbandoned=false, removeAbandonedTimeout=300, > > timeBetweenEvictionRunsMillis=-1, testOnBorrow=false} 2003-01-15 > > 10:56:15,651 INFO [STDOUT] > > [org.apache.ojb.broker.metadata.RepositoryPersistor] INFO: > 2003-01-15 > > 10:56:15,651 INFO [STDOUT] OJB Descriptor Repository: > > > jar:file:/G:/jboss/jboss-3.0.4/server/default/tmp/deploy/serve > r/default/ > > > deploy/webeinout-beans.jar/112.webeinout-beans.jar-contents/re > pository.j > > ar!/repository.xml > > 2003-01-15 10:56:15,948 INFO [STDOUT] > > [org.apache.ojb.broker.metadata.RepositoryPersistor] INFO: > 2003-01-15 > > 10:56:15,948 INFO [STDOUT] Read repository from file took 328 ms > > 2003-01-15 10:56:15,948 INFO [STDOUT] > > [org.apache.ojb.broker.metadata.RepositoryPersistor] INFO: > > 2003-01-15 10:56:15,948 INFO [STDOUT] OJB Descriptor Repository: > > > jar:file:/G:/jboss/jboss-3.0.4/server/default/tmp/deploy/serve > r/default/ > > > deploy/webeinout-beans.jar/112.webeinout-beans.jar-contents/re > pository.j > > ar!/repository.xml > > 2003-01-15 10:56:16,010 INFO [STDOUT] > > [org.apache.ojb.broker.metadata.RepositoryPersistor] INFO: > 2003-01-15 > > 10:56:16,010 INFO [STDOUT] Read connection repository from > file took > > 62 ms 2003-01-15 10:56:16,088 INFO [STDOUT] > > [org.apache.ojb.broker.ta.PersistenceBrokerFactoryDefaultImpl] INFO: > > 2003-01-15 10:56:16,088 INFO [STDOUT] Set default PBKey: > > org.apache.ojb.broker.PBKey: repository=default, user=sa, > password=***** > > 2003-01-15 10:56:16,213 INFO [STDOUT] > > [org.apache.ojb.broker.util.sequence.SequenceManagerFactory] INFO: > > 2003-01-15 10:56:16,213 INFO [STDOUT] Default sequence > manager class > > was org.apache.ojb.broker.util.sequence.SequenceManagerHighLowImpl > > 2003-01-15 10:56:16,307 ERROR [org.jboss.ejb.plugins.LogInterceptor] > > RuntimeException: > > java.lang.UnsupportedOperationException: Not supported in managed > > environment at > > > org.apache.ojb.broker.accesslayer.ConnectionFactoryManagedImpl > .newConnec > > tionFromDriverManager(Unknown Source) > > at > > > org.apache.ojb.broker.accesslayer.ConnectionFactoryNotPooledIm > pl.getConn > > ectionFromPool(Unknown Source) > > at > > > org.apache.ojb.broker.accesslayer.ConnectionFactoryAbstractImp > l.lookupCo > > nnection(Unknown Source) > > at > > > org.apache.ojb.broker.accesslayer.ConnectionFactoryManagedImpl > .lookupCon > > nection(Unknown Source) > > at > > > org.apache.ojb.broker.accesslayer.ConnectionManager.getConnect > ion(Unknow > > n Source) > > at > > > org.apache.ojb.broker.accesslayer.StatementManager.getGenericS > tatement(U > > nknown Source) > > at org.apache.ojb.broker.accesslayer.JdbcAccess.executeSQL(Unknown > Source) > > at > org.apache.ojb.broker.accesslayer.SqlBasedRsIterator.<init>(Unknown > > Source) > > at > > > org.apache.ojb.broker.singlevm.RsIteratorFactoryImpl.createRsI > terator(Un > > known Source) > > at > > > org.apache.ojb.broker.singlevm.PersistenceBrokerImpl.getRsIter > atorFromQu > > ery(Unknown Source) > > at > > > org.apache.ojb.broker.singlevm.PersistenceBrokerImpl.getRsIter > atorFromQu > > eryExtentAware(Unknown Source) > > at > > > org.apache.ojb.broker.singlevm.PersistenceBrokerImpl.getIterat > orFromQuer > > y(Unknown Source) > > at > > > org.apache.ojb.broker.singlevm.PersistenceBrokerImpl.getCollec > tionByQuer > > y(Unknown Source) > > at > > > org.apache.ojb.broker.singlevm.PersistenceBrokerImpl.getCollec > tionByQuer > > y(Unknown Source) > > at > > > org.apache.ojb.broker.singlevm.PersistenceBrokerImpl.getCollec > tionByQuer > > y(Unknown Source) > > at > > > org.apache.ojb.broker.singlevm.PersistenceBrokerImpl.getCollec > tionByQuer > > y(Unknown Source) > > at > > > org.apache.ojb.broker.singlevm.DelegatingPersistenceBroker.get > Collection > > ByQuery(Unknown Source) > > at > > > my.com.shinyang.einout.pr.PurchaseRequisitionSessionBean.getPR > BySite(Unk > > nown Source) > > at > > > my.com.shinyang.einout.pr.PurchaseRequisitionSessionBean.getPR(Unknown > > Source) > > at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at > > > sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccess > orImpl.jav > > a:39) > > at > > > sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMeth > odAccessor > > Impl.java:25) > > at java.lang.reflect.Method.invoke(Method.java:324) > > at > > > org.jboss.ejb.StatelessSessionContainer$ContainerInterceptor.i > nvoke(Stat > > elessSessionContainer.java:660) > > at > > > org.jboss.resource.connectionmanager.CachedConnectionIntercept > or.invoke( > > CachedConnectionInterceptor.java:186) > > at > > > org.jboss.ejb.plugins.StatelessSessionInstanceInterceptor.invo > ke(Statele > > ssSessionInstanceInterceptor.java:77) > > at > > > org.jboss.ejb.plugins.AbstractTxInterceptor.invokeNext(Abstrac > tTxInterce > > ptor.java:107) > > at > > > org.jboss.ejb.plugins.TxInterceptorCMT.runWithTransactions(TxI > nterceptor > > CMT.java:178) > > at > > > org.jboss.ejb.plugins.TxInterceptorCMT.invoke(TxInterceptorCMT > .java:60) > > at > > > org.jboss.ejb.plugins.SecurityInterceptor.invoke(SecurityInter > ceptor.jav > > a:130) > > at > > org.jboss.ejb.plugins.LogInterceptor.invoke(LogInterceptor.java:204) > > at > > > org.jboss.ejb.StatelessSessionContainer.invoke(StatelessSessio > nContainer > > .java:313) > > at org.jboss.ejb.Container.invoke(Container.java:712) > > at > > org.jboss.mx.server.MBeanServerImpl.invoke(MBeanServerImpl.java:517) > > at > > > org.jboss.invocation.jrmp.server.JRMPInvoker.invoke(JRMPInvoke > r.java:382 > > ) > > at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at > > > sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccess > orImpl.jav > > a:39) > > at > > > sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMeth > odAccessor > > Impl.java:25) > > at java.lang.reflect.Method.invoke(Method.java:324) > > at > > sun.rmi.server.UnicastServerRef.dispatch(UnicastServerRef.java:261) > > at sun.rmi.transport.Transport$1.run(Transport.java:148) > > at java.security.AccessController.doPrivileged(Native Method) at > > sun.rmi.transport.Transport.serviceCall(Transport.java:144) > > at > > > sun.rmi.transport.tcp.TCPTransport.handleMessages(TCPTransport > .java:460) > > at > > > sun.rmi.transport.tcp.TCPTransport$ConnectionHandler.run(TCPTr > ansport.ja > > va:701) > > at java.lang.Thread.run(Thread.java:536) > > > > > -----Original Message----- > > > From: Stephen Ting [mailto:[EMAIL PROTECTED]] > > > Sent: 15 January 2003 08:53 > > > To: 'OJB Users List' > > > Subject: RE: Failed to deploy in JBoss 3.0.4 > > > > > > > > > Yeah it's my fault. Truly my repository_internal.xml is outdated. > > > Anyway, after I update it to the latest version, found in > CVS head > > > that errors gone. But again there is this error message, could > > > anyone help. > > > > > > Thanks > > > > > > Regards > > > stephen > > > > > > > > > 2003-01-15 08:34:40,229 ERROR > [org.jboss.ejb.plugins.LogInterceptor] > > > Unexpected Error: > > > java.lang.NoClassDefFoundError > > > at org.apache.ojb.broker.ta.PersistenceBrokerFactoryDefaultImpl.b > > > uildDefaul > > > tKey(Unknown Source) > > > at > > > org.apache.ojb.broker.ta.PersistenceBrokerFactoryDefaultImpl.< > > > init>(Unkn > > > own Source) > > > at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native > > > Method) > > > at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeCo > > > nstructorA > > > ccessorImpl.java:39) > > > at > > > sun.reflect.DelegatingConstructorAccessorImpl.newInstance(Dele > > > gatingCons > > > tructorAccessorImpl.java:27) > > > at > > > java.lang.reflect.Constructor.newInstance(Constructor.java:274) > > > at java.lang.Class.newInstance0(Class.java:296) > > > at java.lang.Class.newInstance(Class.java:249) > > > at > > > org.apache.ojb.broker.ta.PersistenceBrokerFactoryFactory.insta > > > ntiate(Unk > > > nown Source) > > > at > > > org.apache.ojb.broker.ta.PersistenceBrokerFactoryFactory.insta > > > nce(Unknow > > > n Source) > > > at org.jboss.ojb.pb.PBFactory.getInstance(Unknown Source) > > > at > > > my.com.shinyang.einout.pr.PurchaseRequisitionSessionBean.ejbCr > > > eate(Unkno > > > wn Source) > > > at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) > > > at > > > sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccess > > > orImpl.jav > > > a:39) > > > at > > > sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMeth > > > odAccessor > > > Impl.java:25) > > > at java.lang.reflect.Method.invoke(Method.java:324) > > > at > > > org.jboss.ejb.StatelessSessionEnterpriseContext.<init>(Statele > > > ssSessionE > > > nterpriseContext.java:52) > > > at > > > org.jboss.ejb.plugins.StatelessSessionInstancePool.create(Stat > > > elessSessi > > > onInstancePool.java:61) > > > at > > > org.jboss.ejb.plugins.AbstractInstancePool.get(AbstractInstanc > > > ePool.java > > > :209) > > > at > > > org.jboss.ejb.plugins.StatelessSessionInstanceInterceptor.invo > > > ke(Statele > > > ssSessionInstanceInterceptor.java:63) > > > at > > > org.jboss.ejb.plugins.AbstractTxInterceptor.invokeNext(Abstrac > > > tTxInterce > > > ptor.java:107) > > > at > > > org.jboss.ejb.plugins.TxInterceptorCMT.runWithTransactions(TxI > > > nterceptor > > > CMT.java:178) > > > at > > > org.jboss.ejb.plugins.TxInterceptorCMT.invoke(TxInterceptorCMT > > > .java:60) > > > at > > > org.jboss.ejb.plugins.SecurityInterceptor.invoke(SecurityInter > > > ceptor.jav > > > a:130) > > > at > > > > org.jboss.ejb.plugins.LogInterceptor.invoke(LogInterceptor.java:204) > > > at > > > org.jboss.ejb.StatelessSessionContainer.invoke(StatelessSessio > > > nContainer > > > .java:313) > > > at org.jboss.ejb.Container.invoke(Container.java:712) > > > at > > > > org.jboss.mx.server.MBeanServerImpl.invoke(MBeanServerImpl.java:517) > > > at > > > org.jboss.invocation.jrmp.server.JRMPInvoker.invoke(JRMPInvoke > > > r.java:382 > > > ) > > > at sun.reflect.GeneratedMethodAccessor68.invoke(Unknown Source) > > > at > > > sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMeth > > > odAccessor > > > Impl.java:25) > > > at java.lang.reflect.Method.invoke(Method.java:324) > > > at > > > > sun.rmi.server.UnicastServerRef.dispatch(UnicastServerRef.java:261) > > > at sun.rmi.transport.Transport$1.run(Transport.java:148) > > > at java.security.AccessController.doPrivileged(Native Method) > > > at sun.rmi.transport.Transport.serviceCall(Transport.java:144) > > > at > > > sun.rmi.transport.tcp.TCPTransport.handleMessages(TCPTransport > > > .java:460) > > > at > > > sun.rmi.transport.tcp.TCPTransport$ConnectionHandler.run(TCPTr > > > ansport.ja > > > va:701) > > > at java.lang.Thread.run(Thread.java:536) > > > > > > > -----Original Message----- > > > > From: Michael Ansley [mailto:[EMAIL PROTECTED]] > > > > Sent: 15 January 2003 02:50 > > > > To: OJB Users List > > > > Subject: Re: Failed to deploy in JBoss 3.0.4 > > > > > > > > > > > > Right at the bottom these are your critical messages, and they > > > > indicate that while the default repository.xml is being found, > > > > rather than whatever you > > > > specify (although this may be right), it seems that it can't > > > > find the class > > > > SequenceEntry. Now, I just checked through my source and > > > > couldn't find it, > > > > so it's possible that your repository_internal.xml is out > > > of date or > > > > something. > > > > > > > > Cheers... > > > > > > > > > > > > MikeA > > > > > > > > > > > > > Caused by: > > > > org.apache.ojb.broker.metadata.MetadataException: Could not > > > > > read repository class descriptor data, using repository: > > > > > repository.xml: Class > > > > > org.apache.ojb.broker.util.sequence.SequenceEntry could not > > > > be found > > > > > in the classpath. This could cause unexpected behaviour of > > > > OJB, please > > > > > remove or comment out this class descriptor in the > repository.xml > > > > > file.: org.apache.ojb.broker.util.sequence.SequenceEntry > > > > > at > org.apache.ojb.broker.metadata.MetadataManager.<init>(Unknown > > > > > Source) > > > > > at > > > org.apache.ojb.broker.metadata.MetadataManager.<clinit>(Unknown > > > > > Source) > > > > > ... 40 more > > > > > Caused by: > > > org.apache.ojb.broker.metadata.MetadataException: Class > > > > > org.apache.ojb.broker.util.sequence.SequenceEntry could not > > > > be found in > > > > > the classpath. This could cause unexpected behaviour of > > > OJB, please > > > > > remove or comment out this class descriptor in the > > > > repository.xml file.: > > > > > org.apache.ojb.broker.util.sequence.SequenceEntry > > > > > at > > > > > org.apache.crimson.parser.Parser2.parseInternal(Parser2.java:524) > > > > > at org.apache.crimson.parser.Parser2.parse(Parser2.java:305) > > > > > at > > > > > > > > > > > > > org.apache.crimson.parser.XMLReaderImpl.parse(XMLReaderImpl.java:442) > > > > > at > > > > > > > > > > > > > org.apache.crimson.parser.XMLReaderImpl.parse(XMLReaderImpl.java:396) > > > > > at > > > > > > > > > org.apache.ojb.broker.metadata.RepositoryPersistor.buildReposi > > > > tory(Unkno > > > > > wn Source) > > > > > at > > > > > > > > > org.apache.ojb.broker.metadata.RepositoryPersistor.readDescrip > > > > torReposit > > > > > ory(Unknown Source) > > > > > ... 42 more > > > > > > > > > > > > > > > can anyone who had successfully deployed OJB in Jboss assist. > > > > > > > > > > Thanks > > > > > > > > > > Stephen > > > > > > > > > > > > -- > > > > To unsubscribe, e-mail: > > > > <mailto:ojb-user-> [EMAIL PROTECTED]> > > > > For > > > > additional commands, > > > > e-mail: <mailto:[EMAIL PROTECTED]> > > > > > > > > > > > > > > > > > -- > > > To unsubscribe, e-mail: > > > <mailto:ojb-user-> [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]> > > > > > > > > > -- > To unsubscribe, e-mail: > <mailto:ojb-user-> [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]>
