Re: sequence number for the last insert

2003-11-11 Thread Morgan Soe
Thank you, Antonio. Appreciate it. Antonio Gallardo <[EMAIL PROTECTED]> wrote:Morgan Soe dijo: > Hello, I am trying to find out if there is a simple way to get the > sequence number for the last insert from a table with auto-incremented > primary key column. Check this: http://db.apache.org/oj

Re: sequence number for the last insert

2003-11-11 Thread Antonio Gallardo
Morgan Soe dijo: > Hello, I am trying to find out if there is a simple way to get the > sequence number for the last insert from a table with auto-incremented > primary key column. Check this: http://db.apache.org/ojb/howto-use-db-sequences.html Best Regards, Antonio Gallardo

sequence number for the last insert

2003-11-11 Thread Morgan Soe
Hello, I am trying to find out if there is a simple way to get the sequence number for the last insert from a table with auto-incremented primary key column. Thank you, Morgan - Do you Yahoo!? Protect your identity with Yahoo! Mail AddressGuard

Re: with-jdori broken?

2003-11-11 Thread Antonio Gallardo
Hi Gus: First, you dont need to said: > I am getting the feeling that the JDO > implementation here is sketchy and really very beta or alpha, not so RC > ish... But I am probably doing something very wrong. Please remember: You will find help on the list without making this type of comments. No

RE: Mysql4.0?

2003-11-11 Thread Sukesh Garg
ditto On Tue, 2003-11-11 at 13:35, Robert J Celestino wrote: > Hello Gus, > > As far as the newsgroup: its quality not quantity here :-) > > I am using MySql4.0 with OJB. I am using the PersistenceBroker and ODMG APIs with > good success. I am waiting until the JDO support is a little more soli

RE: Mysql4.0?

2003-11-11 Thread Robert J Celestino
Hello Gus, As far as the newsgroup: its quality not quantity here :-) I am using MySql4.0 with OJB. I am using the PersistenceBroker and ODMG APIs with good success. I am waiting until the JDO support is a little more solid before I switch over to that API. Bob c ---

with-jdori broken?

2003-11-11 Thread Gus Heck
Hi, Still hacking around trying to get OJB's JDO stuff working on my system. Although I am worried about the problems with rollback that seem to be evident from the regression tests, It might not turn out to be important so I figured I might as well see if I can't at least get it setup while I

Re: Any body can help me?

2003-11-11 Thread A Leg
Hi Antonio No it has no "caused by" nor "nest exception". The rest of error was some list of application calling tree. I am creating som JINI service accessing the persistence layer. The way JINI services access class is particular, it use a class loader. I had first many errors, because it did'

RE: Any body can help me?

2003-11-11 Thread Kollivakkam R. Raghavan
I have noticed that if you have some class files missing, the initialization fails with this exception. The way I debugged this was to (I use Jbuilder, although I suspect this will work with Eclipse as well) set an exception breakpoint and look at the trace file. It's probably a ClassNotFoundExce

Re: Any body can help me?

2003-11-11 Thread Antonio Gallardo
Can you send the full stack trace? Maybe you miss a "caused by" or a "nested exception". Best Regards, Antonio Gallardo - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]

Any body can help me?

2003-11-11 Thread A Leg
Hi When I start my application I get this error. It's probably a beginner error, but I get stuck Thank's for any help to enable me to go ahead with ojb. Andre [org.apache.ojb.broker.core.PersistenceBrokerFactoryDefaultImpl] ERROR: Creation of a new PB instance failed null java.lang.reflect.Inv

Re: Mysql4.0?

2003-11-11 Thread Gus Heck
Wow this list is quiet. I'm used to Ant lists that are 80+message a day :) Is anyone out there using MySQL 4.0 with OJB (particular for JDO) ? -Gus Gus Heck wrote: Is MySQL 4.0 supported? I ran the regression tests against my database (/usr/sbin/mysqld Ver 4.0.14-standard for pc-linux on

Re: only grab 10 records

2003-11-11 Thread Joseph Campbell
Actually that will work provided you original query is correct In SQL if you said SELECT * FROM QUEUE WHERE X = 'Not Processed' Then you limit that to the first 100 rows you should be fine... Because the returning result set will start numbered @ rownum 1 and move to 100 - remember resu

Re: only grab 10 records

2003-11-11 Thread Andy Czerwonka
Again, I don't think this will work, because I want 100 records, but I want the first 100 where column x = y. On November 11, 2003 7:07 am, Charles Anthony wrote: > In which case, I believe you can use the pseudo column "rownum". See > previous message > http://article.gmane.org/gmane.comp.jakart

Re: only grab 10 records

2003-11-11 Thread Andy Czerwonka
Well, that really won't work, because the table i'm selecting from has the following properties. - It's a queue. - Each record has a status (not_processed and error) - I need to select only (not_processed) - If, while processing, it get a business error, i set the record to error and move to the

Re: only grab 10 records

2003-11-11 Thread Andy Czerwonka
the setStartAtIndex() and setEndAtIndex() seems to work... so I could get the first record, get the unique id, and then ask for the next, say 20 records. I could do that each time in the loop. Thoughts? I do need to do two selects each time though any way to get it down to 1? On November

RE: only grab 10 records

2003-11-11 Thread Charles Anthony
In which case, I believe you can use the pseudo column "rownum". See previous message http://article.gmane.org/gmane.comp.jakarta.ojb.user/4038/match=rownum for an example of adding the appropriate SQL to a query... Note, this will tie your application to Oracle. Cheers, Charles. > -Origina

Re: only grab 10 records

2003-11-11 Thread Andy Czerwonka
Oracle 9i On November 11, 2003 6:49 am, Charles Anthony wrote: > Which Database ? > > > -Original Message- > > From: Andy Czerwonka [mailto:[EMAIL PROTECTED] > > Sent: 11 November 2003 13:55 > > To: OJB Users List > > Subject: Re: only grab 10 records > > > > > > Then I have a problem. Is

RE: only grab 10 records

2003-11-11 Thread Charles Anthony
Which Database ? > -Original Message- > From: Andy Czerwonka [mailto:[EMAIL PROTECTED] > Sent: 11 November 2003 13:55 > To: OJB Users List > Subject: Re: only grab 10 records > > > Then I have a problem. Is there a way to say 'select next > record order by > column' in OJB? My issue

Re: only grab 10 records

2003-11-11 Thread Andy Czerwonka
Then I have a problem. Is there a way to say 'select next record order by column' in OJB? My issue is I have a queue table with 200,000 records in it, and I'm doing a getIterator() which works fine on a few (<1) records, but anything more than that it's very slow. I need to select less re

ERROR: Creation of a new PB instance failed

2003-11-11 Thread A Leg
Hi When I start my application I get this error. In fact I don't understand because my application jar contain, org/apache/ojb/broker/util/ClassHelper I try differents things but in fact I get stuck. It's probably a beginner error. Thank's for any help. Andre [org.apache.ojb.broker.core.Persis

RE: only grab 10 records

2003-11-11 Thread Charles Anthony
Hi, It is not possible to do this in a cross platform way, so No, currently this is not possible in OJB. For an explanation of the reasons why, see http://article.gmane.org/gmane.comp.jakarta.ojb.user/10065/match=paging+perf ormance+issues Cheers, Charles. > -Original Message- > From:

broken pipe

2003-11-11 Thread Aldo Carlino
      Hi all, i have see this error in my application using oracle 9i and ojb rc4   Caused by: java.sql.SQLException: Eccezione IO: Connection timed out   at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:180)   at oracle.jdbc.dbaccess.DBError.throwSqlException(D

only grab 10 records

2003-11-11 Thread Andy Czerwonka
Does anyone know if its possible to do something like this in OJB: select * from table where criteria but only return me a maximum of 10 records. Is this possible? - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional comm

RE: PersistenceBrokerFactory exception

2003-11-11 Thread Boyes, Carl
Hi Armin, I'm using OJB 1.0.rc4. Looking though the code I see that in one instance the following code is used: ... Transaction tx = TxManagerFactory.instance().getTransaction(); PBCapsule capsule = new PBCapsule(((OJB) SessionFactory.getInstance().getOdmg()).getCurrentPBKey(), t

Re: Error at run time by a beginner, next step

2003-11-11 Thread A Leg
Hello Oliver Thank's a lot for your help. You are right it did'nt find the class. In fact the cause was coming from how compile services using ojb. One more question : I have many processes which will have to access the persistence layer. (not web pages, processes) What is the best way to save

RE: Error at run time by a beginner, next step

2003-11-11 Thread oliver . matz
Hello Andre, > -Original Message- > From: A Leg [mailto:[EMAIL PROTECTED] > "org.apache.ojb.odmg.locking.InMemoryLockMapImpl" is > illegal for key "LockMapClass" (should be a class, using It seems that OJB does not find that class. Maybe you are using an old or corrupted version of OJ