memory leak

2004-07-29 Thread ZZZ Liu
Hi, I am writing a tool to import data into database and I am using OJB 1.0 as the persistence layer to do the actual insertion/update into database. I found that I will get OutOfMemoryError problem if I load a large number (over 100, will commit for each file) of files' data. It works fine if I

Found unclosed resources while finalize

2004-07-29 Thread ZZZ Liu
Hi, I am using OJB 1.0. I found following message appeared a lot of times in my log file. Could anybody tell me what does that mean and what would cause that problem? 29 Jul 2004 20:27:43 5408 INFO [Finalizer] accesslayer.ReportQueryRsIterator - Found unclosed resources while finalize (causer

Re: FW: save point support

2004-07-12 Thread ZZZ Liu
eckpoint() > > cheers, > Thomas > > > -Original Message- > > From: ZZZ Liu [mailto:[EMAIL PROTECTED] > > Sent: Friday, July 09, 2004 6:52 PM > > To: [EMAIL PROTECTED] > > Subject: save point support > > > > > > Hi, > > &

save point support

2004-07-11 Thread ZZZ Liu
Hi, Just wondering that whether OJB has save point support so that partial transaction can be rolled back? Thanks, Zhe __ Do you Yahoo!? New and Improved Yahoo! Mail - Send 10MB messages! http://promotions.yahoo.com/new_mail ---

Does OJB support FK on UK?

2004-06-10 Thread ZZZ Liu
In Oracle, we can create a foreign key reference to a unique constraint instead of the primary key. Could anybody tell me that whether OJB supports that? I tried but looks like OJB always tries to find the primary key columns of the parent table, even though the foreign key actually is setup on a u

Is it platform independant if I use upper() and like '%'?

2004-04-01 Thread ZZZ Liu
Hi All, I am using ojb as the persistence layer and assume that I don't need to re-write my code if I need to switch to a different database. However, if I use Criteria crit = new Criteria(); crit.addEqualTo("upper(firstname)", "TOM"); crit.addLike("firstname", "T%"); Is it still platform indep

Re: FW: FW: setStartAtIndex/setEndAtIndex for a very large result set

2004-02-04 Thread ZZZ Liu
Hi, This is a repost. Could anybody help me on that? Thanks, Zhe --- Zhe Liu <[EMAIL PROTECTED]> wrote: > > > -Original Message----- > From: ZZZ Liu [mailto:[EMAIL PROTECTED] > Sent: Tuesday, February 03, 2004 3:46 PM > To: [EMAIL PROTECTED] > Subje

Re: FW: How to set null for a column for which the corresponding java type is long

2004-02-03 Thread ZZZ Liu
Thanks a lot for all of your answers. I just realized that OJB can convert from JDBC types to Number (Integer, Long, BigInteger,BigDecimal) automatically. For example, JDBC type BIGINT can be converted to either primitive long or Object Long without any FieldConversion. In this case, I can just use

Re: FW: setStartAtIndex/setEndAtIndex for a very large result set

2004-02-03 Thread ZZZ Liu
> > -Original Message- > From: ZZZ Liu [mailto:[EMAIL PROTECTED] > Sent: Monday, February 02, 2004 9:01 PM > To: [EMAIL PROTECTED] > Subject: setStartAtIndex/setEndAtIndex for a very > large result set > > > Hi, All > > I am trying to do a simple query aga

setStartAtIndex/setEndAtIndex for a very large result set

2004-02-02 Thread ZZZ Liu
Hi, All I am trying to do a simple query against a very large table with over 200,000 records. I use QueryByCriteria without any criteria, but settiing setStartAtIndex(1) and setEndAtIndex(2). Then I use getIteratorByQuery to get the result. However, I got OutOfMemory error. I tried the same thin

Performance difference between mapping number column to long vs BigDecimal

2004-01-27 Thread ZZZ Liu
Hi, all I am trying to know the performance difference between mapping number column to long vs BigDecimal. I did following test. 1) I loaded over 200k records in the table. 2) I ran a test to retrieve all records in the table as an iterator and then loop over the iterator to get each element and

How to set null for a column for which the corresponding java type is long

2004-01-27 Thread ZZZ Liu
Hi, All I have a data base column. The data type is number (10). It is nullable. The JDBC type defined in repository is BIGINT and the corresponding java type is long (default). Can anybody tell me how to save a record so that the value of that column is null instead of zero? Thanks, Zhe ___

Re: FW: deploy OJB with web application

2004-01-25 Thread ZZZ Liu
classpath. Thanks, Zhe > > > -Original Message- > From: Armin Waibel [mailto:[EMAIL PROTECTED] > Sent: Thursday, January 22, 2004 3:28 AM > To: OJB Users List > Subject: Re: deploy OJB with web application > > > Hi, > > ZZZ Liu wrote: > > I

Re: FW: FW: FW: Cannot retrieve back just saved objects without committing transaction

2004-01-22 Thread ZZZ Liu
transaction > > > Hi Zhe, > > ZZZ Liu wrote: > > Hi, Armin > > > > Thank you very much for the fixing. But I have one > > more question. If the batch mode is turned on by > > calling > > > broker.getConnectionManager().setBatchMode("true&

Re: FW: deploy OJB with web application

2004-01-22 Thread ZZZ Liu
aibel [mailto:[EMAIL PROTECTED] > Sent: Thursday, January 22, 2004 3:28 AM > To: OJB Users List > Subject: Re: deploy OJB with web application > > > Hi, > > ZZZ Liu wrote: > > I am using OJB rc5. Everything is fine when I use > it > > for stand alone p

deploy OJB with web application

2004-01-22 Thread ZZZ Liu
I am using OJB rc5. Everything is fine when I use it for stand alone program. But when I try to use it in a web application (applciation server is resin 2.1.10), I got following error. From the log, we can see that there is a NullPointerException at org.apache.ojb.broker.metadata.RepositoryXmlHand

broker.commitTransaction and broker.abortTransaction for PB query

2004-01-21 Thread ZZZ Liu
Hi, I am using PB api. I am wondering when I use PB query, do I need to worry about transaction. I remember I read a article saying that there is a difference with/without transaction, something related to cache, but I could not find the source any more. If I still need to deal with transaction, d

Re: FW: FW: Cannot retrieve back just saved objects without committing transaction

2004-01-21 Thread ZZZ Liu
abled and > after use of a PB >+instance, before instance was returned > to pool, batch mode >+was set to false again (PB > implementation close method) >+Be carefully in modify this behaviour, > changes could cause >+u

RE: FW: Cannot retrieve back just saved objects without committing transaction

2004-01-17 Thread ZZZ Liu
W: Cannot retrieve back just saved objects without committing transaction Hi Zhe, ZZZ Liu wrote: > Hi, Armin > > Thanks a lot for your reply. I am using PB-api and the > batch mode is turned on (in repository_database.xml, > batch-mode="true" for jdbc-connection-descriptor). I &g

Re: FW: Cannot retrieve back just saved objects without committing transaction

2004-01-16 Thread ZZZ Liu
t; To: OJB Users List > Subject: Re: Cannot retrieve back just saved objects > without committing > transaction > > > Hi Zhe, > > ZZZ Liu wrote: > > Hi, all > > > > I have a problem when I try to insert an object in > a > > data base table and t

Cannot retrieve back just saved objects without committing transaction

2004-01-15 Thread ZZZ Liu
Hi, all I have a problem when I try to insert an object in a data base table and then try to retrieve all records from that table. I use the same persistence broker for the above two operations. I found that if I don't commit the transaction after save, the retrieved records won't include the new

QueryBySQL and bind variables

2003-12-13 Thread ZZZ Liu
Hi, Could anybody tell me that whether QueryBySQL supports bind variables and how to do that? Thanks in advance! Z __ Do you Yahoo!? New Yahoo! Photos - easier uploading and sharing. http://photos.yahoo.com/ --