new to the api and have a question
Hello all, I'm new as of today, to this api. I sat down Friday to write one ;) and then though "someone else must have tried this already"... and here it is! Anyway, I'm going through the documentation now, but I wanted to know if its possible to make an object immutable... for instance, I've got a country list and the data doesn't change, and I want to make sure that one of my developers can't alter the table (particularly in the production env). Currently in my own design I'm using a fairly simple JavaBean system, and a factory behind the beans... this allows the factory to throw a veto exception if the data is immutable and someone tried to change it. Does anything like that exist in this API? My other questions is about storing objects in the app servers memory, but I saw something about that already, so I'll wait to ask questions if I can't get the answers. Anyway, it looks fantastic, and I'm fairly excited about trying it out... I particularly like the distributed thing, as we're running a fairly large server pool. - Brill Pappin - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
Re: Creation of a new PB instance failed
Hi, if you use rc1 all these entries are in OJB.properties file, thus you don't use rc1 or you mixed some files. Please check your classpath if you have more than one OJB.properties file in (maybe from the struts stuff) regards, Armin - Original Message - From: "BURT, RANDALL (CONTRACTOR)" <[EMAIL PROTECTED]> To: "OJB Users List" <[EMAIL PROTECTED]> Sent: Saturday, March 29, 2003 10:41 PM Subject: RE: Creation of a new PB instance failed Adding that line to the configuration didn't help, I'm still getting: [org.apache.ojb.broker.ta.PersistenceBrokerFactoryDefaultImpl] INFO: Set default PBKey: org.apache.ojb.broker.PBKey: repository=default, user=sa, password=* [org.apache.ojb.broker.accesslayer.JdbcAccessFactory] ERROR: ConfigurableFactory configuration key class 'null' does not exist. [org.apache.ojb.broker.ta.PersistenceBrokerFactoryDefaultImpl] ERROR: Creation of a new PB instance failed null Still stumped... Message- From: BURT, RANDALL (CONTRACTOR) Sent: Saturday, March 29, 2003 1:57 PM To: OJB Users List Subject: RE: Creation of a new PB instance failed Nope. I don't have that entry in OJB.properties. I have a ConnectionFactoryClass entry like so: ConnectionFactoryClass=org.apache.ojb.broker.accesslayer.ConnectionFacto ryDefaultImpl Not using pooling right now, as we are early in development. I will add the line you sent and let you know if it works. -Original Message- From: Jakob Braeuchi [mailto:[EMAIL PROTECTED] Sent: Saturday, March 29, 2003 1:43 PM To: OJB Users List Subject: Re: Creation of a new PB instance failed and this is the connection manager entry: ConnectionManagerClass=org.apache.ojb.broker.accesslayer.ConnectionManag erImpl hth jakob - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
misleading documentation regarding auto settings in refence and collection descriptors
Hello, the advanced o/r tutorial says: These default settings are mandatory for proper operation of the ODMG and JDO implementation. In the following code sample, a reference-descriptor and a collection-descriptor are configured to use cascading retrieve (auto-retrieve="true" ), insert and update (auto-update="true" ) and delete (auto-delete="true" ) operations In the repository.xml documentation one can read: The auto-update attribute specifies whether OJB automatically stores this reference attribute on storing the persistent object. This attribute must be set to false if using the OTM, ODMG or JDO layer. The auto-delete attribute specifies whether OJB automatically deletes this reference attribute on deleting the persistent object. This attribute must be set to false if using the OTM, ODMG or JDO layer. So what is the right setting? Thanks in advance, Vincenz - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
RE: Creation of a new PB instance failed
Adding that line to the configuration didn't help, I'm still getting: [org.apache.ojb.broker.ta.PersistenceBrokerFactoryDefaultImpl] INFO: Set default PBKey: org.apache.ojb.broker.PBKey: repository=default, user=sa, password=* [org.apache.ojb.broker.accesslayer.JdbcAccessFactory] ERROR: ConfigurableFactory configuration key class 'null' does not exist. [org.apache.ojb.broker.ta.PersistenceBrokerFactoryDefaultImpl] ERROR: Creation of a new PB instance failed null Still stumped... Message- From: BURT, RANDALL (CONTRACTOR) Sent: Saturday, March 29, 2003 1:57 PM To: OJB Users List Subject: RE: Creation of a new PB instance failed Nope. I don't have that entry in OJB.properties. I have a ConnectionFactoryClass entry like so: ConnectionFactoryClass=org.apache.ojb.broker.accesslayer.ConnectionFactoryDefaultImpl Not using pooling right now, as we are early in development. I will add the line you sent and let you know if it works. -Original Message- From: Jakob Braeuchi [mailto:[EMAIL PROTECTED] Sent: Saturday, March 29, 2003 1:43 PM To: OJB Users List Subject: Re: Creation of a new PB instance failed and this is the connection manager entry: ConnectionManagerClass=org.apache.ojb.broker.accesslayer.ConnectionManagerImpl hth jakob - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
RE: Creation of a new PB instance failed
Nope. I don't have that entry in OJB.properties. I have a ConnectionFactoryClass entry like so: ConnectionFactoryClass=org.apache.ojb.broker.accesslayer.ConnectionFactoryDefaultImpl Not using pooling right now, as we are early in development. I will add the line you sent and let you know if it works. -Original Message- From: Jakob Braeuchi [mailto:[EMAIL PROTECTED] Sent: Saturday, March 29, 2003 1:43 PM To: OJB Users List Subject: Re: Creation of a new PB instance failed and this is the connection manager entry: ConnectionManagerClass=org.apache.ojb.broker.accesslayer.ConnectionManagerImpl hth jakob BURT, RANDALL (CONTRACTOR) wrote: >Yes, as copied from my OJB.properties: >(...) ># The PersistenceBrokerFactoryClass entry decides which concrete ># PersistenceBrokerFactory implemention is to be used. ># Use this by for non-managed environments: >PersistenceBrokerFactoryClass=org.apache.ojb.broker.ta.PersistenceBrokerFactoryDefaultImpl >(...) ># The PersistenceBrokerClass entry decides which concrete PersistenceBroker ># implementation is to be served by the PersistenceBrokerFactory. ># This is the singlevm implementation: >PersistenceBrokerClass=org.apache.ojb.broker.singlevm.PersistenceBrokerImpl >(...) > >-Original Message- >From: Jakob Braeuchi [mailto:[EMAIL PROTECTED] >Sent: Saturday, March 29, 2003 1:22 PM >To: OJB Users List >Subject: Re: Creation of a new PB instance failed > > >hi burt, > >and you also have thse entries in ojb.properties ? > >PersistenceBrokerFactoryClass=org.apache.ojb.broker.ta.PersistenceBrokerFactoryDefaultImpl >PersistenceBrokerClass=org.apache.ojb.broker.singlevm.PersistenceBrokerImpl > >jakob > >- >To unsubscribe, e-mail: [EMAIL PROTECTED] >For additional commands, e-mail: [EMAIL PROTECTED] > > > > - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
Re: Creation of a new PB instance failed
and this is the connection manager entry: ConnectionManagerClass=org.apache.ojb.broker.accesslayer.ConnectionManagerImpl hth jakob BURT, RANDALL (CONTRACTOR) wrote: Yes, as copied from my OJB.properties: (...) # The PersistenceBrokerFactoryClass entry decides which concrete # PersistenceBrokerFactory implemention is to be used. # Use this by for non-managed environments: PersistenceBrokerFactoryClass=org.apache.ojb.broker.ta.PersistenceBrokerFactoryDefaultImpl (...) # The PersistenceBrokerClass entry decides which concrete PersistenceBroker # implementation is to be served by the PersistenceBrokerFactory. # This is the singlevm implementation: PersistenceBrokerClass=org.apache.ojb.broker.singlevm.PersistenceBrokerImpl (...) -Original Message- From: Jakob Braeuchi [mailto:[EMAIL PROTECTED] Sent: Saturday, March 29, 2003 1:22 PM To: OJB Users List Subject: Re: Creation of a new PB instance failed hi burt, and you also have thse entries in ojb.properties ? PersistenceBrokerFactoryClass=org.apache.ojb.broker.ta.PersistenceBrokerFactoryDefaultImpl PersistenceBrokerClass=org.apache.ojb.broker.singlevm.PersistenceBrokerImpl jakob - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
RE: Creation of a new PB instance failed
Yes, as copied from my OJB.properties: (...) # The PersistenceBrokerFactoryClass entry decides which concrete # PersistenceBrokerFactory implemention is to be used. # Use this by for non-managed environments: PersistenceBrokerFactoryClass=org.apache.ojb.broker.ta.PersistenceBrokerFactoryDefaultImpl (...) # The PersistenceBrokerClass entry decides which concrete PersistenceBroker # implementation is to be served by the PersistenceBrokerFactory. # This is the singlevm implementation: PersistenceBrokerClass=org.apache.ojb.broker.singlevm.PersistenceBrokerImpl (...) -Original Message- From: Jakob Braeuchi [mailto:[EMAIL PROTECTED] Sent: Saturday, March 29, 2003 1:22 PM To: OJB Users List Subject: Re: Creation of a new PB instance failed hi burt, and you also have thse entries in ojb.properties ? PersistenceBrokerFactoryClass=org.apache.ojb.broker.ta.PersistenceBrokerFactoryDefaultImpl PersistenceBrokerClass=org.apache.ojb.broker.singlevm.PersistenceBrokerImpl jakob - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
RE: Creation of a new PB instance failed
No, this is the only version I have used. However, ConnectionManagerClass does not seem to be specified in my OJB.properties file... -Original Message- From: Armin Waibel [mailto:[EMAIL PROTECTED] Sent: Saturday, March 29, 2003 1:17 PM To: OJB Users List Subject: Re: Creation of a new PB instance failed Do you update from an older version and do not replace all configuration files? E.g. do not replace OJB.properties file? Or the OJB.properties file was not found? Seems property 'ConnectionManagerClass' could not be found. regards, Armin - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
Re: Creation of a new PB instance failed
hi burt, and you also have thse entries in ojb.properties ? PersistenceBrokerFactoryClass=org.apache.ojb.broker.ta.PersistenceBrokerFactoryDefaultImpl PersistenceBrokerClass=org.apache.ojb.broker.singlevm.PersistenceBrokerImpl jakob BURT, RANDALL (CONTRACTOR) wrote: Yup. My connection descriptor looks like: -Original Message- From: Jakob Braeuchi [mailto:[EMAIL PROTECTED] Sent: Saturday, March 29, 2003 1:09 PM To: OJB Users List Subject: Re: Creation of a new PB instance failed hi burt, do you have a default jcd-alias in your conncetion-descriptor ? jakob BURT, RANDALL (CONTRACTOR) wrote: Hi! I'm new to OJB, and was banging my head against the following error: [org.apache.ojb.broker.ta.PersistenceBrokerFactoryDefaultImpl] INFO: Set default PBKey: org.apache.ojb.broker.PBKey: repository=default, user=sa, password=* [org.apache.ojb.broker.accesslayer.ConnectionManagerFactory] ERROR: Configurable Factory configuration key class 'null' does not exist. [org.apache.ojb.broker.ta.PersistenceBrokerFactoryDefaultImpl] ERROR: Creation of a new PB instance failed null I'm using OJB 1.0-rc1, Tomcat 4.1, Struts (latest stable release), MSSql Server 7, and the jtds-0.4 jdbc driver on Windows 2000. I can't seem to find the problem and was wondering if anyone had any suggestions. I'll provide my repository metadata and database layout if you need it. As an aside, I tried searching the mailing list archives, but could not get the page to display message contents other than: $msgHeaders - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
Re: Creation of a new PB instance failed
Do you update from an older version and do not replace all configuration files? E.g. do not replace OJB.properties file? Or the OJB.properties file was not found? Seems property 'ConnectionManagerClass' could not be found. regards, Armin - Original Message - From: "BURT, RANDALL (CONTRACTOR)" <[EMAIL PROTECTED]> To: "OJB Users List" <[EMAIL PROTECTED]> Sent: Saturday, March 29, 2003 8:10 PM Subject: RE: Creation of a new PB instance failed Yup. My connection descriptor looks like: -Original Message- From: Jakob Braeuchi [mailto:[EMAIL PROTECTED] Sent: Saturday, March 29, 2003 1:09 PM To: OJB Users List Subject: Re: Creation of a new PB instance failed hi burt, do you have a default jcd-alias in your conncetion-descriptor ? Hi! I'm new to OJB, and was banging my head against the following error: > >[org.apache.ojb.broker.ta.PersistenceBrokerFactoryDefaultImpl] INFO: Set default PBKey: org.apache.ojb.broker.PBKey: repository=default, user=sa, password=* >[org.apache.ojb.broker.accesslayer.ConnectionManagerFactory] ERROR: Configurable Factory configuration key class 'null' does not exist. >[org.apache.ojb.broker.ta.PersistenceBrokerFactoryDefaultImpl] ERROR: Creation of a new PB instance failed >null > >I'm using OJB 1.0-rc1, Tomcat 4.1, Struts (latest stable release), MSSql Server 7, and the jtds-0.4 jdbc driver on Windows 2000. I can't seem to find the problem and was wondering if anyone had any suggestions. I'll provide my repository metadata and database layout if you need it. > >As an aside, I tried searching the mailing list archives, but could not get the page to display message contents other than: > >$msgHeaders > >- >To unsubscribe, e-mail: [EMAIL PROTECTED] >For additional commands, e-mail: [EMAIL PROTECTED] > > > > - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
RE: Creation of a new PB instance failed
Yup. My connection descriptor looks like: -Original Message- From: Jakob Braeuchi [mailto:[EMAIL PROTECTED] Sent: Saturday, March 29, 2003 1:09 PM To: OJB Users List Subject: Re: Creation of a new PB instance failed hi burt, do you have a default jcd-alias in your conncetion-descriptor ? Hi! I'm new to OJB, and was banging my head against the following error: > >[org.apache.ojb.broker.ta.PersistenceBrokerFactoryDefaultImpl] INFO: Set default >PBKey: org.apache.ojb.broker.PBKey: repository=default, user=sa, password=* >[org.apache.ojb.broker.accesslayer.ConnectionManagerFactory] ERROR: Configurable >Factory configuration key class 'null' does not exist. >[org.apache.ojb.broker.ta.PersistenceBrokerFactoryDefaultImpl] ERROR: Creation of a >new PB instance failed >null > >I'm using OJB 1.0-rc1, Tomcat 4.1, Struts (latest stable release), MSSql Server 7, >and the jtds-0.4 jdbc driver on Windows 2000. I can't seem to find the problem and >was wondering if anyone had any suggestions. I'll provide my repository metadata and >database layout if you need it. > >As an aside, I tried searching the mailing list archives, but could not get the page >to display message contents other than: > >$msgHeaders > >- >To unsubscribe, e-mail: [EMAIL PROTECTED] >For additional commands, e-mail: [EMAIL PROTECTED] > > > > - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
Re: [GURU HELP NEEDED] Distinct on Field
ha jacob, although ojb supports subselects it's not yet possible to reference columns of the enclosing select. hth jakob Jacob Hookom wrote: The goal is to select children based on a distinct parent id. Example of the sql code: SELECT f.ForumTitle, (SELECT Max(p.PostDateTime) FROM tbl_Posts p WHERE p.Forum_ID = f.Forum_ID) as MaxPostDateTime FROM tbl_Forum f ORDER BY MaxPostDateTime DESC I would like to be able to accomplish this query in OJB getting Forums ordered by the most recent posts to that Forum. I thought it would be possible to do a Query first on the Posts table to get all Posts distinct by Forum_ID, but I don't see a way of doing that with OJB's Query syntax. Best Regards, Jacob - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
Re: Creation of a new PB instance failed
hi burt, do you have a default jcd-alias in your conncetion-descriptor ? jakob BURT, RANDALL (CONTRACTOR) wrote: Hi! I'm new to OJB, and was banging my head against the following error: [org.apache.ojb.broker.ta.PersistenceBrokerFactoryDefaultImpl] INFO: Set default PBKey: org.apache.ojb.broker.PBKey: repository=default, user=sa, password=* [org.apache.ojb.broker.accesslayer.ConnectionManagerFactory] ERROR: Configurable Factory configuration key class 'null' does not exist. [org.apache.ojb.broker.ta.PersistenceBrokerFactoryDefaultImpl] ERROR: Creation of a new PB instance failed null I'm using OJB 1.0-rc1, Tomcat 4.1, Struts (latest stable release), MSSql Server 7, and the jtds-0.4 jdbc driver on Windows 2000. I can't seem to find the problem and was wondering if anyone had any suggestions. I'll provide my repository metadata and database layout if you need it. As an aside, I tried searching the mailing list archives, but could not get the page to display message contents other than: $msgHeaders - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
Creation of a new PB instance failed
Hi! I'm new to OJB, and was banging my head against the following error: [org.apache.ojb.broker.ta.PersistenceBrokerFactoryDefaultImpl] INFO: Set default PBKey: org.apache.ojb.broker.PBKey: repository=default, user=sa, password=* [org.apache.ojb.broker.accesslayer.ConnectionManagerFactory] ERROR: Configurable Factory configuration key class 'null' does not exist. [org.apache.ojb.broker.ta.PersistenceBrokerFactoryDefaultImpl] ERROR: Creation of a new PB instance failed null I'm using OJB 1.0-rc1, Tomcat 4.1, Struts (latest stable release), MSSql Server 7, and the jtds-0.4 jdbc driver on Windows 2000. I can't seem to find the problem and was wondering if anyone had any suggestions. I'll provide my repository metadata and database layout if you need it. As an aside, I tried searching the mailing list archives, but could not get the page to display message contents other than: $msgHeaders - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
Re: regression test errors
Thanks to both Thomas and Armin for their replies on this thread. Speaking for myself, I'm nervous about using OJB on my current project, too, but I don't think the source is entirely OJB. A big part of it is fear of what I DON'T know. I very much liked the idea of using a tool, developed by folks more expert than me. I know enought about JDBC to be able to do CRUD operations and simple transactions, but the idea of having a layer to abstract all that out of business objects was appealing. I heard Martin Fowler talk a few months ago. He mentioned using JAXOR as an O/R mapping tool. When I looked into it, I found NO documentation whatsoever. Google quickly turned up OJB as an alternative. I liked it right away, because it had more documentation than JAXOR, it the cachet of being a Jakarta project, and the stuff that I did actually worked. Now I've got a tree of four tables linked with m:n associations, all working in JUnit tests. All that's well and good, but now I'm nervous about that learning curve and what I'm ignorant of. I've done everything with the PersistenceBroker API because it was easy to follow in the docs. But now I'm thinking that I should really be doing all of this using ODMG API instead. More learning, with a deadline approaching. Here's a fundamental question: RDBMS developers have put a lot of effort into maintaining referential integrity, managing transactions, etc. It seems to me that OJB is taking over a lot of that stuff. When I created my tables, I didn't add foreign key constraints. I left all that to OJB. The ODMG API will handle true transactions and object/row locking. But what if OJB isn't the only path into the database? A DBA might balk at leaving all those things that the RDBMS would handle to OJB. Is it possible still leave foreign key constraints in the database so others could use them without OJB? My compliments to Thomas, Armin, and the team that created OJB. None of this fear is a reflection on your excellent work. It has more to do with the fact that this is still a version 1.0 release candidate and my own ignorance. Sincerely, MOD --- Thomas Mahler <[EMAIL PROTECTED]> wrote: > Hi Bonnie, > > Bonnie MacKellar wrote: > > I was not at Mobius before 1999, so I really would > not know... > > > > Yes, this is for an important project and I am not > feeling > > very good about this. The alternatives though, are > to buy > > something or do it ourselves. Our company tends to > be of > > the "do it yourself" mentality. Since what we > need is exactly > > what OJB provides, it seems silly to replicate it. > > On the other hand, it is often easier to deal with > bugs > > in your own code then with bugs in someone else's > code. > > OJB is 3 years of heavy designed code by experts in > the O/R area. > We have a complete regression testsuite that covers > each and every > aspect of the system. > > Do it yourself is definitely a bad idea in this > area. If you don't trust > us better use a commercial tool like TopLink. > > OJB is in production use in large projects for 2 > years now. > My company is using OJB in several large and mission > critical software > projects since a year now. > > > > > I would feel a lot better about this if the mail > archives > > worked. My usual approach with this kind of system > is > > to really sift through user archives, looking for > similar > > experiences. > > I admit this is really annoying. But this is clearly > not an OJB problem, > but an infrastructure problem with some Apache > server. > For the time being use archive mirrors at GMANE or > at > http://www.mail-archive.com/ojb-user%40db.apache.org/ > > cheers, > Thomas > > > > > Bonnie > > > > -Original Message- > > From: Michael Duffy [mailto:[EMAIL PROTECTED] > > Sent: Friday, March 28, 2003 1:19 PM > > To: OJB Users List > > Subject: RE: regression test errors > > > > > > > > Bonnie, > > > > I'm responding to a note you sent to the OJB > mailing > > list. > > > > Is Mobius based in the NYC area? I knew a guy > named > > Howard Deiner who worked at a company named > Mobius. > > His tenure would have been prior to 1999. Just > > curious. > > > > Also curious - will the system you'll be > installing > > OJB into be a large production application? I've > been > > getting OJB up and running for a smaller > production > > project, and I'm nervous about it. I see all the > > problems on the mailing list and sketchy > documentation > > and wonder what I'm getting myself into. JMHO, of > > course. Are you feeling the same way? Thanks - > MOD > > > > > > --- Bonnie MacKellar <[EMAIL PROTECTED]> wrote: > > > >>Thanks for the advice. > >>This parameter is set in > >> > > > > > C:\db-ojb-1.0.rc1\target\test\ojb\repository_database.xml, > > > >>right? Do I need to change anything else to modify > >>this behavior? > >> > >>I'm still trying to feel my way around this > system. > >>Basically, I have > >>about a week to mak
Re: Mapping compound primary key in OJB
Hi Tong Kiat, If you have a table with a compound primary key, you must declare all java attributes mapped to the primary key columns as primarykey="true". In Colletcion and ReferenceDescriptors you have to provide one foreignkey entry for each primary key column. cheers, Thomas Chiah Tong Kiat wrote: Hi I’m trying to map table that contains compound keys. I cant’ seems to find any documentation in regards to this. Could anyone tell me or refer me to the correct documentation for it? Thanks Tong Kiat - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
Re: regression test errors
Hi Bonnie, Bonnie MacKellar wrote: I was not at Mobius before 1999, so I really would not know... Yes, this is for an important project and I am not feeling very good about this. The alternatives though, are to buy something or do it ourselves. Our company tends to be of the "do it yourself" mentality. Since what we need is exactly what OJB provides, it seems silly to replicate it. On the other hand, it is often easier to deal with bugs in your own code then with bugs in someone else's code. OJB is 3 years of heavy designed code by experts in the O/R area. We have a complete regression testsuite that covers each and every aspect of the system. Do it yourself is definitely a bad idea in this area. If you don't trust us better use a commercial tool like TopLink. OJB is in production use in large projects for 2 years now. My company is using OJB in several large and mission critical software projects since a year now. I would feel a lot better about this if the mail archives worked. My usual approach with this kind of system is to really sift through user archives, looking for similar experiences. I admit this is really annoying. But this is clearly not an OJB problem, but an infrastructure problem with some Apache server. For the time being use archive mirrors at GMANE or at http://www.mail-archive.com/ojb-user%40db.apache.org/ cheers, Thomas Bonnie -Original Message- From: Michael Duffy [mailto:[EMAIL PROTECTED] Sent: Friday, March 28, 2003 1:19 PM To: OJB Users List Subject: RE: regression test errors Bonnie, I'm responding to a note you sent to the OJB mailing list. Is Mobius based in the NYC area? I knew a guy named Howard Deiner who worked at a company named Mobius. His tenure would have been prior to 1999. Just curious. Also curious - will the system you'll be installing OJB into be a large production application? I've been getting OJB up and running for a smaller production project, and I'm nervous about it. I see all the problems on the mailing list and sketchy documentation and wonder what I'm getting myself into. JMHO, of course. Are you feeling the same way? Thanks - MOD --- Bonnie MacKellar <[EMAIL PROTECTED]> wrote: Thanks for the advice. This parameter is set in C:\db-ojb-1.0.rc1\target\test\ojb\repository_database.xml, right? Do I need to change anything else to modify this behavior? I'm still trying to feel my way around this system. Basically, I have about a week to make a recommendation on using it, in a large project. Ease of use is an important consideration, especially to the powers-that-be who are managing this project. Bonnie -Original Message- From: Armin Waibel [mailto:[EMAIL PROTECTED] Sent: Wednesday, March 26, 2003 6:42 PM To: OJB Users List Subject: Re: regression test errors Seems a problem with the used sequence manager (SequenceManagerHighLowImpl). Try to run the test cases with SequenceManagerInMemoryImpl Do you get the same results? __ Do you Yahoo!? Yahoo! Platinum - Watch CBS' NCAA March Madness, live on your desktop! http://platinum.yahoo.com - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
Re: regression test errors
Hi Bonnie, Bonnie MacKellar wrote: Thanks for the advice. This parameter is set in C:\db-ojb-1.0.rc1\target\test\ojb\repository_database.xml, right? Do I need to change anything else to modify this behavior? I'm still trying to feel my way around this system. Basically, I have about a week to make a recommendation on using it, in a large project. Ease of use is an important consideration, especially to the powers-that-be who are managing this project. I understand the managements concerns. I'm working in a management heavy company... I know from projects that I have been coaching that OJB has definitely a learning curve. This is a fact that may not be visible at first sight. But OJB (and any other full blown O/R mapping tool) deals with so many complex problems that it will take some time to get familiar with all bells and whistles. An O/R tool frees the developers from manually coding several abstract application layers. Martin Fowlers latest book "Patterns of Enterprise Application Architecture" (must have reading!) dedicates several chapters on all issues of Mapping Object-oriented applications to relational databases. Many of the patterns he presents are implemented in OJB. To benefit most from OJB it is crucial to be familar with the design principles, patterns and strategies behind it. Developers that are used to full fledged commercial O/R tools like TopLink do not find it hard to switch to OJB. (The main difference is the price tag :->) But developers that are not familiar with O/R tools will need some training or extra time for learning. I don't want to discourage you, but I think that it is important to frankly tell the management that your team will need additional training if they are not used to other O/R tools already. And this is *not* and OJB specific problem! Good readings: - Fowlers "Patterns of Enterprise Application Architecture" - books mentioned on this page: http://db.apache.org/ojb/links.html cheers, Thomas Bonnie -Original Message- From: Armin Waibel [mailto:[EMAIL PROTECTED] Sent: Wednesday, March 26, 2003 6:42 PM To: OJB Users List Subject: Re: regression test errors Seems a problem with the used sequence manager (SequenceManagerHighLowImpl). Try to run the test cases with SequenceManagerInMemoryImpl Do you get the same results? - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
Re: log4j with jBoss
I'll be happy to send the settings that I use. But it will have to wait till Monday when I get back to the office. Off hand tho' this does look correct. With the addition of Categories to the JBoss log4j.xml you should see log entries in the JBoss server.log (by default). - Original Message - From: "Phil Warrick" <[EMAIL PROTECTED]> To: "OJB Users List" <[EMAIL PROTECTED]> Sent: Thursday, March 27, 2003 11:41 PM Subject: Re: log4j with jBoss > Hi Dave, > > These settings in log4j.xml don't seem to be having an effect. Could > you tell me what are your relevant log4j.xml and OJB.properties file > settings (or send entire file as attachment?). My OJB.properties > settings are as follows (Is the LoggerConfigFile entry used/not used?) > > #--- - > # Logging > #--- - > # The LoggerClass entry tells OJB which concrete Logger > # implementation is to be used. > # > # Commons-logging > #LoggerClass=org.apache.ojb.broker.util.logging.CommonsLoggerImpl > # log4j based logging > LoggerClass=org.apache.ojb.broker.util.logging.Log4jLoggerImpl > # OJB's own simple looging support > #LoggerClass=org.apache.ojb.broker.util.logging.PoorMansLoggerImpl > LoggerConfigFile=log4j.properties > > > Thanks, > > Phil > > Dave Derry wrote: > > Check in the conf directory of the server that you are using (we use > > 'default'). You'll find a log4j.xml file there. Just add the entries > > that you want, and bounce JBoss. > > > > > > - Original Message - From: "Phil Warrick" > > <[EMAIL PROTECTED]> To: "OJB Users List" > > <[EMAIL PROTECTED]> Sent: Wednesday, March 26, 2003 12:12 AM > > Subject: log4j with jBoss > > > > > > > >> Hi, > >> > >> Can someone tell me if there's something special to do to get OJB > >> logging to log4j within jBoss. OJB log4j logging works fine for me > >> standalone. > >> > >> Thanks, > >> > >> Phil > >> > >> > >> - > >> To unsubscribe, e-mail: [EMAIL PROTECTED] For > >> additional commands, e-mail: [EMAIL PROTECTED] > >> > >> > > > > > > > > - > > To unsubscribe, e-mail: [EMAIL PROTECTED] For > > additional commands, e-mail: [EMAIL PROTECTED] > > > > > o > > > - > To unsubscribe, e-mail: [EMAIL PROTECTED] > For additional commands, e-mail: [EMAIL PROTECTED] > > - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
Re: client / server through ejb
Hi Jürgen, The problem with C/S mode is that I had to maintain a lot of infrasture code (e.g. the HTTP-server like server engine) that has not much to to with object relational mapping. It was also quite a lot of work to maintain all changes to the PB kernel in the C/S mode too. Testing was also very ugly, A single run of the PB testsuite took half an hour... The PersistenceBrokerBean is an EJB Session Bean that implements the PersistenceBroker interface. The bean is a wrapper an delegates all call to a singlevm PersistenceBroker. By running this SessionBean in a EJB container you can connect your clients to a remote PersistenceBroker server through standard J2EE EJB mechanisms. This is completely different from using entity beans. My experience from the last 2 years is that there is not a single case where it really is a must to use the OJB C/S mode. SO maybe we should discuss your requirements in details! cheers, Thomas [EMAIL PROTECTED] wrote: hi! i read some tutorials on ejb and have one question. in my posting some days ago, you told, that the client / server concept will be replaced with ejb session beans. i told, i just read some ejb tutorials, and have no experience, but why isn't this this done with ejb ENTITY beans? juergen - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
Re: primary key initialisation
Set the values to 0. Lars Soltau wrote: I am sorry if this has already been answered on this list, but the list archives are offline and I am kinda in a hurry. In the tutorial it says: 8< On storing of newProduct OJB detects that the attribute is not properly set and assigns a unique id. 8< How does OJB determine if a primary key attribute "is not properly set" if it is an primitive type (as in int) and not an object type? Should I initialise the PK attribute to any special value (0, -1, whatever) in the constructor? Greetings Lars Soltau - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
Re: using OJB's JDO api from enterprise beans.
Hi Shyam, Shyam wrote: Thanks for the Info Armin. when is the expected OJB2.0 release ? in June'03 ? Good One! As OJB is develeoped by volunteers. Thus there is no fixed team with fixed deliverables , fixed plans, fixed assignments and responsibilities. So there is also no fixed relese schedule. If someone volunteers to make the OJB PersistanceManagerFactory JNDI capable i will integrate it into the codebase. cheers, Thomas - Shyam On Friday 28 March 2003 03:58 pm, Armin Waibel wrote: Hi Shyam, currently JDO-api implementation is a prototype, thus we do not add any support for j2ee appServer integration. When we finished OTM-api and JCA resource adapter (time-frame a couple of months) appServer integration of the JDO-api implementation should be easy to realize. regards, Armin - Original Message - From: "Shyam" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Friday, March 28, 2003 11:09 AM Subject: using OJB's JDO api from enterprise beans. Hi .. could any one help me on the following I would like to use OJB's JDO api from enterprise beans. i am able to run the sample JDOs examples .. as standalone. but , not able to do it from the enterprise beans .. i have followed the steps specified in the documentation of integarting JDOs with ejb. for jboss. 1) acc. to any jdo access from enterprise beans, we need to look for the PersistanceManagerFactory thro' JNDI and get the persistance manager to do any further operations. though the OJB provided MBeans for PersistanceBroker api and ODMG api. but not to jdo. so , how do i look up OJB's JDO PMF ? Are there any samples or steps to achieve this ? pl. do help me .. i am sorry , if this is an already answered question . [ sorry , though there are few threads on "JDOs in entity context" but .. the messages are not present in the archive .] Thanks, Shyam - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
Re: Deploy OJB in WebLogic Server
Is it not the same code ? Check in the bea doc, the weblogic packages used for a startup class. I think it is the same. Christophe Jem McCombe wrote: Hi, At 22:36 18/03/2003 +0100, you wrote: Just to complete the information provided by Lucy, you can find here how to deploy OJB (PB) on weblogic. It is quite similar to Jboss. I think Thomas should be interested to receive this small install guide for weblogic (Tested only on Weblogic 7): Has anyone successfully adapted Christophe/Lucy's WebLogic 7 approach fro WebLogic 6.1? Tks, Jem - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
RE: Mailing list archive problems..
In my experience the GMANE archive van be quite useful. It allows searching, and is quite up to date (just a couple of hours late) http://news.gmane.org/thread.php?group=gmane.comp.jakarta.ojb.user I have no idea if and how the Jakarta OJB mailing list is managed, but these things can be hard to fix so it may take some time :-<. Cheers, Theo > -Oorspronkelijk bericht- > Van: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] > Verzonden: vrijdag 28 maart 2003 18:15 > Aan: OJB Users List > Onderwerp: Re: Mailing list archive problems.. > > > > We all seem to have the same issue... > > Regards, > > Patrick Reyes > > > > > Spiegs > > <[EMAIL PROTECTED] To: OJB Users List <[EMAIL > PROTECTED]> > .com>cc: (bcc: Patrick Reyes/CDS/CG/CAPITAL) > > Subject: Mailing list archive > problems.. > 03/28/2003 > > 06:11 PM > > Please respond > > to "OJB Users > > List" > > > > > > > > > > I am a ojb newbie struggling to get up and running with mysql. I have > experienced problems trying to use the mailing list archive at > http://db.apache.org/ojb/mail-lists.html. Clicking either 'Archive' link > results in an error on the page.You can get around this by clicking on > 'List Index' and scrolling down to the ojb mail lists. > > However, clicking on the [EMAIL PROTECTED] link, then 'All', then > drilling down all the way to an individual message, only '$msgHeaders' > is displayed. > > I experienced this a about two weeks ago and when I saw it still > occurred today I decided to post to the list. Hopefully this was the > appropriate place to report it and it is an easy issue to fix. > > -- > Spiegs <[EMAIL PROTECTED]> > > > > > > - > To unsubscribe, e-mail: [EMAIL PROTECTED] > For additional commands, e-mail: [EMAIL PROTECTED] > > - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
RE: [DBMS] MS SQL Server
Max and others, this was a useful thread for me, and i hope others will find it useful also :-> I think you are right in your search for database independence, but as someone mentioned, CLOBs and BLOBs probably should not be autoconverted by OJB (as they can become very large, and then probably are best suited for stream i/o ?) It does not strike me as the most efficient interface if they are transparantely read and written for every retrieve and store of the object. On the other hand, keeping them as stream-interface would not work well in EJB environments because I do not know of a good way to serialise such a stream and its associated database connection. In our EJB webapplication by the way we have our documents stored in files on a network file system, referenced as UNC filesname strings in OJB, because we could not really think of a good solution to manage large text and binary files. Not ideal from a transctional point of view, but quite useful in other ways. Thanks for the information, Theo > -Oorspronkelijk bericht- > Van: Geigl Maximilian, R235 [mailto:[EMAIL PROTECTED] > Verzonden: vrijdag 28 maart 2003 13:33 > Aan: OJB Users List > Onderwerp: AW: [DBMS] MS SQL Server > > > Hello Theo, > > I try to explain the reason, why (I thought) we need CLOB: > a) we need to support different DBMS (at least oracle, ms sql server, db2) so we > have to find java-side datatypes that > have similar domains in the various dbms' > b) we have a protocol object which must be able to store long character values > > our aproach was to use String in java, habe LONGVARCHAR in the ojb repository and > use the dbms datatypes acording to the > jdbc documentation of the respective driver, i.e. > DBMS type domain > -- > MSS TEXT 2 GB > ORA LONG 2 GB > DB2 LONG VARCHAR 32 KB > > The problem is the small domain of LONG VARCHAR. > > So the idea was to swutch to CLOB, but apparently I have no jdbc driver for MSS > which can process CLOB fields. > That was the background of my question. > > Acording to Mario Toffias reply I tried the following successfully: > as ojb (or some instance between the dbms and our java application) coverts (oracle) > CLOB field into String fields, I > left LONGVARCHAR in the repository, use String in the application and use CLOB in > the DB2 database. This would work for us. > > Ok, I think this is undocumented (if not unintended) behviour - and in this respect > I agree with Mario - as acording to > the docs the (java) CLOBs should map to (jdbc) CLOBs in the reposotory and to CLOBs > in DB2. > > Well, that's how I understand it and I can live with it for now. > > I want to thank everyone for contributing and helping - I think this is really a > great and interesting/useful mailing list. > > Theo, you find some thoughts in the text of your mail below. > > Regards > Max > > > > > -Ursprüngliche Nachricht- > > Von: Theo Niemeijer [mailto:[EMAIL PROTECTED] > > Gesendet: Donnerstag, 27. März 2003 15:17 > > An: OJB Users List > > Betreff: RE: [DBMS] MS SQL Server > > > > > > > > Max, > > > > Have not tried it, sorry. My problem with CLOB fields (and > > BLOB fields) is that they are not really "Object Oriented" in > > JDBC: AFAIK > > you would have to use _streams_ for input and output wouldn't you ? > > maybe this is, why the mapping between String and Clob works > > > (I have used BLOB's in Oracle in a previous Bea Weblogic > > based JSP/servlet/JDBC website project, for storing uploaded > > images and > > retrieving them lateron to write them to the webserver > > filesystem. I remember I had to open the uploaded file as a > > stream, give this > > stream to JDBC, and on retrieval I got a stream handle back). > > > > I would have no idea how to use this all the way through OJB, > > so please enlighten me on this: > > We use these "TEXT" fields in the database,and these are > > mapped to JDBC type "LONGVARCHAR", to > > get the same effect as a CLOB (Character Large OBject isn't > > it?) > > right > > > , namely to store arbitary long strings in the database. > > with MSS, ORA (and MySQL I think) this works fine, my problem is actually the > limited range of the DB2 type LONG VARCHAR > > > (By the > > way, we use OJB 0.9.5 with JBoss in production, and are > > moving to OJB 1.0rc? when we feel confident that nothing got > > broken in our > > application. So maybe support for CLOB's is different from > > 0.9.5, and I do not really have initimate knowledge of all > > the low-level > > parts of OJB anyway. Would OJB automatically convert a string > > datatype to a CLOB stream or something ?) > > seems so, but acording to the type mapping table in the docs I don't think it is > really intended (?) > > > Why would you want to use CLOB's ? > > > > > > By the way: This is the class descriptor for the TextBlock object: > > > > > class="nl.casthere.uib.ojb.Textblock" > > table="@[EMAIL PROTECTED]" > > > > >
primary key initialisation
I am sorry if this has already been answered on this list, but the list archives are offline and I am kinda in a hurry. In the tutorial it says: 8< On storing of newProduct OJB detects that the attribute is not properly set and assigns a unique id. 8< How does OJB determine if a primary key attribute "is not properly set" if it is an primitive type (as in int) and not an object type? Should I initialise the PK attribute to any special value (0, -1, whatever) in the constructor? Greetings Lars Soltau smime.p7s Description: S/MIME Cryptographic Signature
Re: regression test errors
Hi Bonnie, - Original Message - From: "Bonnie MacKellar" <[EMAIL PROTECTED]> To: "OJB Users List" <[EMAIL PROTECTED]> Sent: Friday, March 28, 2003 7:24 PM Subject: RE: regression test errors > I was not at Mobius before 1999, so I really would not know... > > Yes, this is for an important project and I am not feeling > very good about this. The alternatives though, are to buy > something or do it ourselves. Our company tends to be of > the "do it yourself" mentality. Since what we need is exactly > what OJB provides, it seems silly to replicate it. > On the other hand, it is often easier to deal with bugs > in your own code then with bugs in someone else's code. I think this is the wrong way, because to implement your own layer you have to write thousands of LOC's and your 'own code project' will lead into the same problems. Use open source, if you got problems browse the sources, patch it or change it by your own. If you think OJB is not comply with your requirements try one of the other powerful open source persistence layer like Hibernate (very well documented), Castor, Cayenne. But keep in mind, none of these layer (including OJB) is 'bug-free' ;-) (and none of the commercial) > > I would feel a lot better about this if the mail archives > worked. My usual approach with this kind of system is > to really sift through user archives, looking for similar > experiences. Sorry for the mail archive hassle, hope the apache admins will solve the problem soon. Try to use http://www.mail-archive.com/ojb-user%40db.apache.org/ to browse the archive. or the older archive http://www.mail-archive.com/ojb-user%40jakarta.apache.org/ regards, Armin > > Bonnie > > -Original Message- > From: Michael Duffy [mailto:[EMAIL PROTECTED] > Sent: Friday, March 28, 2003 1:19 PM > To: OJB Users List > Subject: RE: regression test errors > > > > Bonnie, > > I'm responding to a note you sent to the OJB mailing > list. > > Is Mobius based in the NYC area? I knew a guy named > Howard Deiner who worked at a company named Mobius. > His tenure would have been prior to 1999. Just > curious. > > Also curious - will the system you'll be installing > OJB into be a large production application? I've been > getting OJB up and running for a smaller production > project, and I'm nervous about it. I see all the > problems on the mailing list and sketchy documentation > and wonder what I'm getting myself into. JMHO, of > course. Are you feeling the same way? Thanks - MOD > > > --- Bonnie MacKellar <[EMAIL PROTECTED]> wrote: > > > > Thanks for the advice. > > This parameter is set in > > > C:\db-ojb-1.0.rc1\target\test\ojb\repository_database.xml, > > right? Do I need to change anything else to modify > > this behavior? > > > > I'm still trying to feel my way around this system. > > Basically, I have > > about a week to make a recommendation on using it, > > in a large project. > > Ease of use is an important consideration, > > especially to the powers-that-be > > who are managing this project. > > > > Bonnie > > > > -Original Message- > > From: Armin Waibel > > [mailto:[EMAIL PROTECTED] > > Sent: Wednesday, March 26, 2003 6:42 PM > > To: OJB Users List > > Subject: Re: regression test errors > > > > Seems a problem with the used sequence manager > > (SequenceManagerHighLowImpl). > > Try to run the test cases with > > SequenceManagerInMemoryImpl > > Do you get the same results? > > > > > > > __ > Do you Yahoo!? > Yahoo! Platinum - Watch CBS' NCAA March Madness, live on your desktop! > http://platinum.yahoo.com > > - > To unsubscribe, e-mail: [EMAIL PROTECTED] > For additional commands, e-mail: [EMAIL PROTECTED] > - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
Re: regression test errors
Hi Bonnie, - Original Message - From: "Bonnie MacKellar" <[EMAIL PROTECTED]> To: "OJB Users List" <[EMAIL PROTECTED]> Sent: Friday, March 28, 2003 9:38 PM Subject: RE: regression test errors > OK, I figured out how to run the tests with SequenceManagerInMemoryImpl. > I still get the messages > --- > JTurbo 3.0.2 JDBC 2.1 Driver]: Communication Link Failure. Socket Closed > [org.apache.ojb.broker.util.sequence.SequenceManagerHelper] WARN: Cannot > lookup max value from table SM_KEY for column STRING_KEY, PB was > --- > This is what I got before with the default sequence manager. ** Before the sequence manager first time assign a new id for a (primary key) field, SequenceManagerHelper try to figure out the current max value of the field (select max...). This does not work in your case. > > I notice that these messages are marked WARN. There are also messages marked > ERROR and 2 marked FAILURE. What is the difference between these levels? Do > I need to worry about WARN messages? Yes, this means you should watch what's going on. OJB try to ignore the problems or to go an alternative way. ERROR was used if something definite goes wrong and there is no way to bypass the problem. > > One FAIL message looks like this > -- > Testcase: testMaxKeySearch1 took 0.11 sec > FAILED > Expected 131, something goes wrong when try to identify max PK id in the > prepared database tables - Check the ...SMMAX... database tables for id 131, > if id was found in one of the tables, test fails expected:<131> but was:<0> > -- Result of ** > > The other looks like this > -- > Testcase: testIterator took 0.01 sec > FAILED > org.apache.ojb.broker.PersistenceBrokerSQLException: > java.net.SocketException: Socket Closed AFAIK there some other postings on the list report the same problem with MSSQL server / jdbc driver. But I think there some people using OJB and MSSQL server with success (sorry, I use hsql/sapDB only). regards, Armin > junit.framework.AssertionFailedError: > org.apache.ojb.broker.PersistenceBrokerSQLException: > java.net.SocketException: Socket Closed > at > org.apache.ojb.broker.RsIteratorTest.testIterator(RsIteratorTest.java:59 ) > at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) > at > sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.jav a:39 > ) > at > sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessor Impl > .java:25) > > > I have not a clue what either failure means. > > thanks, > Bonnie MacKellar > -Original Message- > From: Armin Waibel [mailto:[EMAIL PROTECTED] > Sent: Wednesday, March 26, 2003 6:42 PM > To: OJB Users List > Subject: Re: regression test errors > > > Hi Bonnie, > > - Original Message - > From: "Bonnie MacKellar" <[EMAIL PROTECTED]> > To: "OJB Users List" <[EMAIL PROTECTED]> > Sent: Wednesday, March 26, 2003 11:27 PM > Subject: regression test errors > > > > > > OK, now that I have a build, how do I go about understanding > > and fixing errors in the regressions tests? > > > > My environment : built with JSDK1.4.0_03 > > DBMS is MSSqlServer2000 > > JDBC driver is JTurbo 3.0.2 JDBC 2.1 Driver > > > > I get several errors in the broker tests : > > Testsuite: org.apache.ojb.broker.AllTests > > Tests run: 187, Failures: 2, Errors: 10, Time elapsed: 50.583 sec > > > > Most of these errors seem to be socket failures > > JTurbo 3.0.2 JDBC 2.1 Driver]: Communication Link Failure. Socket > Closed > > [org.apache.ojb.broker.util.sequence.SequenceManagerHelper] WARN: > Cannot > > lookup max value from table SM_TAB_BB for column SM_ID, PB was > > [EMAIL PROTECTED], using > > jdbc-descriptor > > [EMAIL PROTECTED] > > > > Seems a problem with the used sequence manager > (SequenceManagerHighLowImpl). > Try to run the test cases with SequenceManagerInMemoryImpl > Do you get the same results? > > > or connection problems > > > > Error getting Connection from DriverManager with url > > (jdbc:JTurbo://W2KBMACKELL/ActiveBill) and driver > > (com.newatlanta.jturbo.driver.Driver): Login failed for user > '!!TestCase: > > This should fail!!'. > > Used ConnectionManager instance could not obtain a connection: Could > not > > borrow connection from pool - > > org.apache.ojb.broker.metadata.JdbcConnectionDescriptor: > > [EMAIL PROTECTED] > > This test case have to fail, ignore the error message. > > > > > Now, I have successfully used JTurbo and this DBMS in the past to do > > connection pooling under Weblogic, so I don't think there is a DBMS > > configuration problem. > > > > What is the best way to attack this sort of problem? What files should > I be > > looking at? > > All ;-) > > OK, good initial point are the ConnectionFactory implementation > classes (default is ConnectionFactoryPooledImpl) manage the connections. > > ConnectionManagerImpl does the connection tx/life cycle handling. > > regards, > Armin
