I have noticed some differences in OJB.properties: you: connection.FactoryClass=org.apache.ojb.broker.accesslayer.ConnectionFactoryStmtPooledImpl me: connection.FactoryClass=org.apache.ojb.broker.accesslayer.ConnectionFactoryConPooledImpl
you: useAutoCommit=0 me: useAutoCommit=1 you: PersistentFieldClass=org.ojb.broker.metadata.PersistentFieldMaxPerformanceImpl me: PersistentFieldClass=org.apache.ojb.broker.metadata.PersistentFieldPropertyImpl But when I change these parameters, nothing change!! I'm sure it's a little stupid stuff but what?? Thank you Sylvain -----Message d'origine----- De: Charles Anthony [mailto:[EMAIL PROTECTED]] Date: mardi, 10. septembre 2002 10:31 �: 'OJB Users List' Objet: RE: OJB.properties file needs change >Charles, thanks for your attention. No problems (although again, I haven't much time today - sorry !) >I have tested the same connection descriptor like you, but >there is the same problem. >Have you also a MS SQL Server 2000 database? Yes. >I don't use the setAutoCommit(false). You might not; OJB might ! [snip] >Could you maybe send me your OJB.properties file? Attached. >Thank you for your help. >Sylvain > >-----Message d'origine----- >De: Charles Anthony [mailto:[EMAIL PROTECTED]] >Date: mardi, 10. septembre 2002 09:58 >�: 'OJB Users List' >Objet: RE: OJB.properties file needs change > > >Hi Sylvain, > >SelectMethod=Cursor is an MS specific JDBC driver option. I >think that it >tells the SQLServer to use cursors in it's queries (whatever >that means), >but it also seems to be needed to allow setAutoCommit(false). See >http://forum.java.sun.com/thread.jsp?forum=48&thread=184797 > >Having said that, I'm using the same driver, and my connection >descriptor >looks like this : > ><jdbc-connection-descriptor platform="MsSQLServer" > jdbc-level="2.0" > driver="com.microsoft.jdbc.sqlserver.SQLServerDriver" > protocol="jdbc" > subprotocol="microsoft:sqlserver" > dbalias="//srv024:1433;DatabaseName=AquariusMetadataGenerated" > username="sa" > password=""/> > >It seems to be working just fine. > >Cheers, > >Charles. > >>-----Original Message----- >>From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] >>Sent: 10 September 2002 08:53 >>To: [EMAIL PROTECTED]; [EMAIL PROTECTED] >>Subject: RE: OJB.properties file needs change >> >> >>Thank you Armin. >> >>I add the close() method but it's still the same: my program >>is waiting for something. >> >>In my repository.xml file there is a dbalias parameter named >>"SelectMethod=cursor". Do you know what is it and which option >>can we choose for it? >> >> >>Thank you >>Sylvain >> >>-----Message d'origine----- >>De: Armin Waibel [mailto:[EMAIL PROTECTED]] >>Date: mardi, 10. septembre 2002 09:28 >>�: OJB Users List >>Objet: Re: OJB.properties file needs change >> >> >>Every seems OK, >>but don't forget to close the PB instance after use. >>See below. Maybe this helps. >> >> >>regards, >>Armin >> >>public class OjbTestApplication { >>private PersistenceBroker broker; >> >>/** >>* Constructor for OjbTestApplication. >>*/ >>public OjbTestApplication() { >> >>/** >>* Persistence Broker >>*/ >>broker = null; >>try { >>broker=PersistenceBrokerFactory.createPersistenceBroker("reposi >>tory.xml" >>); >>### >>is deprecated, better use PBF.defaultPersistenceBroker() >>or PBF.createPersistenceBroker(new PBKey("repository.xml")) >> >>} catch (Throwable t) { >>t.printStackTrace(); >>} >>} >> >>public void getAllApplications() { >>System.out.println("The list of all Applications:"); >> >>Query query = new QueryByCriteria(Application.class, null); >>try { >>Collection allApplications =broker.getCollectionByQuery(query); >>### >>// close the PB to return the instance to pool >>// this also returns the connection to the pool >>broker.close(); >>java.util.Iterator iter = allApplications.iterator(); >>while (iter.hasNext()); >>{ >>System.out.println(iter.next()); >>} >>} catch (Throwable t) { >>t.printStackTrace(); >>} >>} >> >> >>public static void main(String args[]) { >>System.out.println("OJB first test:"); >> >>OjbTestApplication test = new OjbTestApplication(); >> >>test.getAllApplications(); >>} >>} >> >> >>----- Original Message ----- >>From: <[EMAIL PROTECTED]> >>To: <[EMAIL PROTECTED]> >>Sent: Tuesday, September 10, 2002 8:51 AM >>Subject: OJB.properties file needs change >> >> >>Hello, >> >>Using OJB PersistenceBroker, I have problem with my connection pool. >>My program start and waiting for something; I have to stop it manually >>after a moment. >> >>Here is my OJB.properties pool section: >> >>#------------------------------------ >># PersistenceBrokerFactory pool >>#------------------------------------ >>maxActive=100 >>maxIdle=-1 >>maxWait=2000 >>timeBetweenEvictionRunsMillis=-1 >>minEvictableIdleTimeMillis=1000000 >>whenExhaustedAction=0 >>#------------------------------------- >> >>Is something needs to be changed?? >> >>Thank you >>Sylvain >> >>-- >>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]> -- To unsubscribe, e-mail: <mailto:[EMAIL PROTECTED]> For additional commands, e-mail: <mailto:[EMAIL PROTECTED]> This email and any attachments are strictly confidential and are intended solely for the addressee. If you are not the intended recipient you must not disclose, forward, copy or take any action in reliance on this message or its attachments. If you have received this email in error please notify the sender as soon as possible and delete it from your computer systems. Any views or opinions presented are solely those of the author and do not necessarily reflect those of HPD Software Limited or its affiliates. At present the integrity of email across the internet cannot be guaranteed and messages sent via this medium are potentially at risk. All liability is excluded to the extent permitted by law for any claims arising as a re- sult of the use of this medium to transmit information by or to HPD Software Limited or its affiliates. -- 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]> This email and any attachments are strictly confidential and are intended solely for the addressee. If you are not the intended recipient you must not disclose, forward, copy or take any action in reliance on this message or its attachments. If you have received this email in error please notify the sender as soon as possible and delete it from your computer systems. Any views or opinions presented are solely those of the author and do not necessarily reflect those of HPD Software Limited or its affiliates. At present the integrity of email across the internet cannot be guaranteed and messages sent via this medium are potentially at risk. All liability is excluded to the extent permitted by law for any claims arising as a re- sult of the use of this medium to transmit information by or to HPD Software Limited or its affiliates. -- To unsubscribe, e-mail: <mailto:[EMAIL PROTECTED]> For additional commands, e-mail: <mailto:[EMAIL PROTECTED]>
