date:20030613



JORGE IVAN MARMOLEJO wrote:
Hi
I have a problem with an autoincrement field with SQL server database, 
table is the follow:
create table Person(
id int  primary key  IDENTITY (1, 1) NOT NULL ,
nombre varchar(30));
in this case OJB  intents to insert the id, which generates an error :
[Microsoft][SQLServer 2000 Driver for JDBC][SQLServer]Cannot insert 
explicit value for identity column in table 'test' when IDENTITY_INSERT 
is set to OFF

the same problem occurs with autoincrement fields of  Mysql
is there away to tell OJB, not to insert id in the test table, because 
it's an autoincrement??
you can set access="readonly" in the fielddescriptor.
cheers,
 
how  can I  solve this problem?
 
thanks

*
Jorge Ivan Marmolejo H.
Ingeniero Java
Universidad de San Buenaventura
[EMAIL PROTECTED]
[EMAIL PROTECTED]

Do you Yahoo!?
Free online calendar 
 with 
sync to Outlook(TM).


-
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]

Re: OQL Bind Causes a NullPointerException

Hi Eric,

Eric Northam wrote:
The following causes a NullPointerException

OQLQuery query = odmg.newOQLQuery();

query.create("select notifications from $1 where type=\"lead\"");

Is it valid to pass the class name as a parameter? 
AFAIK parameters work only in the where clause...

Either way throwing a
NullPointerException in this case isn't too friendly.
I agree. We work hard to make our NPEs behave better ;-)

cheers,
Thomas
 
Eric





DISCLAIMER: The information contained in this e-mail is, unless otherwise
indicated, confidential and is intended solely for the use of the named
addressee. Access, copying or re-use of the e-mail or any information
contained therein by any other person is not authorized. If you are not the
intended recipient please notify us immediately by returning the e-mail to
the originator.


-
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]

OQL Bind Causes a NullPointerException

2003-06-13 Thread Eric Northam

The following causes a NullPointerException

OQLQuery query = odmg.newOQLQuery();

query.create("select notifications from $1 where type=\"lead\"");

Is it valid to pass the class name as a parameter? Either way throwing a
NullPointerException in this case isn't too friendly.
 
Eric





DISCLAIMER: The information contained in this e-mail is, unless otherwise
indicated, confidential and is intended solely for the use of the named
addressee. Access, copying or re-use of the e-mail or any information
contained therein by any other person is not authorized. If you are not the
intended recipient please notify us immediately by returning the e-mail to
the originator.

Re: javaone presentation

Craig Russel talking about OJB! I'm impressed.

Ian Holsman wrote:
http://servlet.java.sun.com/javaone/sf2003/conf/sessions/display-3368.en-81967.jsp 

the name of it was Applying Open Source Web Technologies Together: 
Struts and OJB

It was being done by... Craig McClanahan
Senior Staff Engineer
Sun Microsystems, Inc.
Craig Russell
Architect
Sun Microsystems Inc.
Amy Roh
Software Engineer
Sun Microsystems, Inc.


Thomas Mahler wrote:

There was a presentation on OJB at JavaOne ? cool!
Who held it?
I'd also like to see the slides!
cheers,
Thomas
Ian Holsman wrote:

seeing how the room was full, and that was 10 minutes BEFORE the
presenentation started, is it possible to post a link to the 
presentation.

TIA
Ian


-
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: Possible CollectionProxy bug?

Hi Edson,
It still on my todo list (but quite close to the top now!)
Edson Carlos Ericksson Richter wrote:
Anyone can confirm that this is a bug or not?

Thanks,

Edson Richter
- Original Message - 
From: "Edson Carlos Ericksson Richter" <[EMAIL PROTECTED]>
To: "OJB Users List" <[EMAIL PROTECTED]>
Sent: Thursday, June 12, 2003 11:13 AM
Subject: Possible CollectionProxy bug?

I think I get RemovalAwareCollection working with proxied classes.

The method afterStore in CollectionProxy should not be:

public void afterStore(PersistenceBroker broker) throws
PersistenceBrokerException
{
  Collection c = getData();
  if( c instanceof ManageableCollection )
( ( ManageableCollection )c ).afterStore( broker );
}

Thomas, can you confirm this?

Thanks,

Edson Richter



- Original Message - 
From: "onno" <[EMAIL PROTECTED]>
To: "OJB Users List" <[EMAIL PROTECTED]>
Sent: Thursday, June 12, 2003 9:22 AM
Subject: Auto-delete woes

Long time no post but we found a strange behaviour in our app which
otherwise has been running fine.
it involves the auto-delete

we use

Broker.deleteByQuery(aQuery); //where the Query is just a 1 Primary Key from
an object.
This however doesn't seem to delete any linked objects (ie per defined in
auto-delete)
eg:

  Request (auto-everything == true ;)
 1-1 with a Interaction  (auto-everything == true ;)
   1-1 with a (Temp User) (auto-everything == true
;)
when we delete a request it gets deleted however the Interaction Object
sticks around and
needless to say also the Temp User.
Any logic error we do?

Greetz

Onno

-
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
---
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.488 / Virus Database: 287 - Release Date: 5/6/2003


-
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]


---
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.489 / Virus Database: 288 - Release Date: 10/6/2003


-
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: junit test fails

Hi Mete,
The error tells you that the junit.jar is not visible to ant.
Make sure you have a correct version of this file in your ojb/lib directory.
You can also try to install ANT on you machine, copy junit.jsr to the 
ant/lib directory and execute ant junit within the ojb directory.

cheers,
thomas
Mete Kural wrote:
Hi all,
I'm trying to run the junit tests on DB2. I get this error. What do you think it could 
be?
Thanks,
Mete
Output:

C:\Software\ojb\db-ojb-1.0.rc3>build junit-no-compile-no-prepare
Buildfile: build.xml
junit-no-compile-no-prepare:

BUILD FAILED
file:C:/Software/ojb/db-ojb-1.0.rc3/build.xml:734: Could not create task or type
 of type: junit.
Ant could not find the task or a class this task relies upon.

This is common and has a number of causes; the usual
solutions are to read the manual pages then download and
install needed JAR files, or fix the build file:
 - You have misspelt 'junit'.
   Fix: check your spelling.
 - The task needs an external JAR file to execute
   and this is not found at the right place in the classpath.
   Fix: check the documentation for dependencies.
   Fix: declare the task.
 - The task is an Ant optional task and optional.jar is absent
   Fix: look for optional.jar in ANT_HOME/lib, download if needed
 - The task was not built into optional.jar as dependent
   libraries were not found at build time.
   Fix: look in the JAR to verify, then rebuild with the needed
   libraries, or download a release version from apache.org
 - The build file was written for a later version of Ant
   Fix: upgrade to at least the latest release version of Ant
 - The task is not an Ant core or optional task
   and needs to be declared using .
Remember that for JAR files to be visible to Ant tasks implemented
in ANT_HOME/lib, the files must be in the same directory or on the
classpath
Please neither file bug reports on this problem, nor email the
Ant mailing lists, until all of these causes have been explored,
as this is not an Ant bug.
Total time: 1 second

C:\Software\ojb\db-ojb-1.0.rc3>echo %CLASSPATH%
C:\Java\jdk1.4\demo\jfc\SampleTree\SampleTree.jar;C:\Software\ojb\db-ojb-1.0.rc3
\lib\ant.jar;C:\Software\ojb\db-ojb-1.0.rc3\lib\optional.jar
-
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: javaone presentation

2003-06-13 Thread Ian Holsman

http://servlet.java.sun.com/javaone/sf2003/conf/sessions/display-3368.en-81967.jsp

the name of it was Applying Open Source Web Technologies Together: 
Struts and OJB

It was being done by... 
Craig McClanahan
Senior Staff Engineer
Sun Microsystems, Inc.

Craig Russell
Architect
Sun Microsystems Inc.
Amy Roh
Software Engineer
Sun Microsystems, Inc.


Thomas Mahler wrote:
There was a presentation on OJB at JavaOne ? cool!
Who held it?
I'd also like to see the slides!
cheers,
Thomas
Ian Holsman wrote:

seeing how the room was full, and that was 10 minutes BEFORE the
presenentation started, is it possible to post a link to the 
presentation.

TIA
Ian


-
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]

RE: about field autoincrement

2003-06-13 Thread Shannon Ewing

See: http://www.mail-archive.com/ojb-user%40db.apache.org/msg02021.html


-Original Message-
From: jorge ivan marmolejo [mailto:[EMAIL PROTECTED]
Sent: Friday, June 13, 2003 3:53 PM
To: [EMAIL PROTECTED]; [EMAIL PROTECTED]
Subject: about field autoincrement





Hi

I have a problem with an autoincrement field with SQL server database, table

is the follow:

create table Person(
id int  primary key  IDENTITY (1, 1) NOT NULL ,
nombre varchar(30));

in this case OJB  intents to insert the id, which generates an error :

[Microsoft][SQLServer 2000 Driver for JDBC][SQLServer]Cannot insert explicit

value for identity column in table 'test' when IDENTITY_INSERT is set to OFF


the same problem occurs with autoincrement fields of  Mysql

is there away to tell OJB, not to insert id in the test table, because it's 
an autoincrement??





Jorge ivan  Marmolejo
Java Engineer
Universidad de San Buenaventura


[EMAIL PROTECTED]
[EMAIL PROTECTED]
[EMAIL PROTECTED]

_
Charla con tus amigos en línea mediante MSN Messenger: 
http://messenger.yupimsn.com/


-
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]


+-+ 
This message may contain confidential and/or privileged information.  If you
are not the addressee or authorized to receive this for the addressee, you
must not use, copy, disclose or take any action based on this message or any
information herein.  If you have received this message in error, please
advise the sender immediately by reply e-mail and delete this message.
Thank you for your cooperation.
+-+

-
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]

Re: My Ojb cache doesn't work ??

Hi Emmanuel,

OJB *must* lookup the db during the second query because:
- there could be new data matching the query!
- Maybe the user removed some objects from the cache
- Maybe the Garbage collector or some cache mechanism emptied the cache
But the good news: If there are objects found in query, that are already 
in the cache, OJB does not materialize them from the DB (unless you set 
refresh="true"), but looks them up from the cache.

Try to measure the execution time of both queries. You'll see the second 
execution will be faster due to the cache!

cheers,
Thomas
Emmanuel Dupont wrote:
All,

 

 

Here is my code

 

// Criterias...

Criteria crit = new Criteria();

crit.addEqualTo(Alt_log.LOG_ID_PK,"Essai" );

Query q = QueryFactory.newQuery(Alt_log.class, crit);

  

// Start the Db transaction

broker.beginTransaction();

 

altLogEdited  = (IAlt_log)broker.getObjectByQuery(q);

tx.lock(altLogEdited, JwtTransaction.READ);

 

altLogEdited  = (IAlt_log)broker.getObjectByQuery(q);

 

// Release the db connection to PoolConnection manager

broker.commitTransaction();

  

tx.commit();

 

 

 

The getObjectByQuery method execute on the both calls a Select in the
Database.
 

I don't put "true" in the class_descriptor "refresh" option

 

For me, OJB should'nt look to the database on the second call ...isn't it

 

 

Tx !

 




-
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]

Re: Experience in High-Load Environments

2003-06-13 Thread Aaron Longwell

Thomas,

Thanks for the info. You've answered my questions. I was just curious to 
hear some info on the impact of OJB's O/R mapping on 
speed/performance/capacity. I've heard from several people that OJB is 
efficient enough to use in very high-load situations... and you're very 
helpful to point out that the performance limits of OJB (however 
minimal) can be overcome by adding machines to the business tier.

Thanks again,
Aaron
Thomas Mahler wrote:

Hi again Aaron,

I'm not exactly sure what you expect from the figures that other 
people provide?
Maybe I tell you we once stresstested a Struts/OJB based system with 
200 concurrent users firing requests and a sub-second average response 
time.
It was a Tandem Nonstop system with 2 300 Mhz CPU, each equipped with 
512MB of Ram. We used the Tandem Nonstop SQL database.
This test was helpful for our project, because we got clear figures 
about our then target environment.

But how can such figures be of any help for you? I don't expect that 
you are running on an environment as exotic as Tandem Nonstop Server :-)

By running a Struts/OJB based applications on clustered J2EE Server 
you will be able to achieve *any* request per minute rate that you 
want to see. Just add more machines into the cluster.

This is possible because J2EE container provide the infrastructure for 
scalibility and frameworks like STruts and OJB are carefully designed 
for scalability and not to produce any bottlenecks.

So IMO the real question is: how much throughput do you need? And how 
must your system be sized to give you this throughput.
This depends on *many* factors, and OJB is only one of them.
So IMO you have to perform such a test on your own!

DId you execute our perfoemance testsuite against your target system 
already? This tool will give you a first impression how OJB APIs 
compare to native JDBC programming.

Aaron Longwell wrote:

Jason,

Thanks for the feedback. I understand you're probably killing these 
servers doing this intense processing... but what about # users? Is 
it one guy running intense simulations... I'm curious about # 
requests per minute type of loads.

Thanks,
Aaron
Jason McKerr wrote:

I've also worked with OJB on high-load situations in J2EE 
environments. We're using JRun and/or Orion with OJB in a 
clustered/distributed
environment. This is a National Science Foundation project called the
Network for Earthquake Engineering Simulation (NEES). The only major 
problem that we ran into was the cache.  JCS just isn't
good, and hasn't seemed to get much better over the last year.  We 
ended
up plugging in Tangosol's Coherence Clustered Cache into the 
system.  We
can also do write-behinds, and buffered data caching that is queued for
transaction.  That's important to us because we're dealing with very
expensive scientific data that _can't_ get lost if a db goes down. Some
of these Tsunami experiments can get pretty expensive.

Otherwise, we use mostly the PersistenceBroker, and a little of the
ODMG.  Performance seems better on PB, but less functional.  It's not
really that much of a problem anyway, because we can cheaply and 
quickly
add app-servers to the cluster.

Jason

On Thu, 2003-06-12 at 22:14, Aaron Longwell wrote:
 

I realize I may be comparing Apples to Enterprise Applications 
here, but I'd like to hear some feedback about using OJB in 
high-load (load balanced?) environments.

On an OJB web application, how many requests have you seen an 
application handle? Would anyone be concerned about using OJB on an 
enormous e-commerce site? (EBay, Amazon, etc)?

Thanks for the input,
Aaron
-
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: New to OJB --> Should We Use IT ?

Hi Ben

BEN BOOKEY wrote:
Dear List,

I am not sure if this is the correct email address to post but here
goes.
no problem!
In my company we are deciding on what technology to use for a web
based database entry tool. The application will store simple text in
most cases, but there is also a picture (BLOB) as well. This will be
a multi-user application, and should consider other changes made by
others i.e. CREATE, READ ,UPDATE, and DELETE. i.e. a normal OLTP
system. Perhaps someone could send a sample project which works with
ORACLE or another DB ?
Good books covering STruts + OJB. Both contain sample projects ready for
download:

http://www.amazon.com/exec/obidos/ASIN/0596003285/qid=1054656123/sr=2-1/ref=sr_2_1/103-9325116-6675068";>
The O'Reilly book on Struts programming by Chuck Cavaness has a
whole chapter about how to build an applications model layers based
on OJB.
A must reading for everyone intending to use Struts and OJB.

All source code from the book can be found here:
http://examples.oreilly.com/jakarta/";>
Struts Programming sources.

http://www.amazon.com/exec/obidos/tg/detail/-/1861007817/qid=1054655953/sr=8-1/ref=sr_8_1/103-9325116-6675068?v=glance&s=books&n=507846";>
There's also a WROX book on Struts + OJB

All source code from the book can be found here:
http://web.wrox.com/download/code/professional/7817.zip";>
Professional Struts and OJB sources.

Somehow we have come up with the idea to do this using Apache Tomcat
JDO (Apache OJB came to our attention)for data persistance Struts.
We want to deploy to MySQL, Oracle and perhaps even later DB2.
Hopefully there will be no issues with this app. when using OJB(JDO
uses primative JDBC to accomplish this DB portability is this the
same with all JDO)
JDO is a generic persistence API. There are Implementations based on
Object databases and tools like OJB that provide an O/R mapping.

OJB works good with MySql, Oracle, DB2 (and many more)

There are 2 developers who can work on this, and we have been told we
should be finnished in 3 months..
I realise that this is still release candidate, but should we use OJB
or can someone recomend another free SUN JDO implementation?
There are no major issues with the current RC3. A lot of people use it
in production evironments.

But there is an issue that you should be aware of. The OJB JDO
implementation is not a standalone solution, but requires the SUN JDO
Reference Implementation as the toplevel implementation.
Unfortunately the license for the JDO RI does not allow to use it in
commercial applications (If I got the licence right, IANAL ;-))

I know there are other OSS JDO projects, like TJDO and XORM.
But I don't know much about them.
I do not
mean to insult anyone in this group, it would be great to get some
honest practial experience from commercial project developers who
have implemented this.
There are lots of people sucessfully using Struts + OJB! There are even
two books available that cover these tool and that will help you a lot
in properly designing your application.

But most of these user don't use the OJB JDO personality, but the simple
PersistenceBroker API, or the more sophisticated ODMG personality.

I hope these lines will help you to make your decision.

cheers,
Thomas

Kind regards

Ben Bookey,

-
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]

about field autoincrement

2003-06-13 Thread jorge ivan marmolejo



Hi

I have a problem with an autoincrement field with SQL server database, table 
is the follow:

create table Person(
id int  primary key  IDENTITY (1, 1) NOT NULL ,
nombre varchar(30));
in this case OJB  intents to insert the id, which generates an error :

[Microsoft][SQLServer 2000 Driver for JDBC][SQLServer]Cannot insert explicit 
value for identity column in table 'test' when IDENTITY_INSERT is set to OFF

the same problem occurs with autoincrement fields of  Mysql

is there away to tell OJB, not to insert id in the test table, because it's 
an autoincrement??





Jorge ivan  Marmolejo
Java Engineer
Universidad de San Buenaventura
[EMAIL PROTECTED]
[EMAIL PROTECTED]
[EMAIL PROTECTED]
_
Charla con tus amigos en línea mediante MSN Messenger: 
http://messenger.yupimsn.com/

-
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]

Re: Experience in High-Load Environments

Hi again Aaron,

I'm not exactly sure what you expect from the figures that other people 
provide?
Maybe I tell you we once stresstested a Struts/OJB based system with 200 
concurrent users firing requests and a sub-second average response time.
It was a Tandem Nonstop system with 2 300 Mhz CPU, each equipped with 
512MB of Ram. We used the Tandem Nonstop SQL database.
This test was helpful for our project, because we got clear figures 
about our then target environment.

But how can such figures be of any help for you? I don't expect that you 
are running on an environment as exotic as Tandem Nonstop Server :-)

By running a Struts/OJB based applications on clustered J2EE Server you 
will be able to achieve *any* request per minute rate that you want to 
see. Just add more machines into the cluster.

This is possible because J2EE container provide the infrastructure for 
scalibility and frameworks like STruts and OJB are carefully designed 
for scalability and not to produce any bottlenecks.

So IMO the real question is: how much throughput do you need? And how 
must your system be sized to give you this throughput.
This depends on *many* factors, and OJB is only one of them.
So IMO you have to perform such a test on your own!

DId you execute our perfoemance testsuite against your target system 
already? This tool will give you a first impression how OJB APIs compare 
to native JDBC programming.

Aaron Longwell wrote:
Jason,

Thanks for the feedback. I understand you're probably killing these 
servers doing this intense processing... but what about # users? Is it 
one guy running intense simulations... I'm curious about # requests per 
minute type of loads.

Thanks,
Aaron
Jason McKerr wrote:

I've also worked with OJB on high-load situations in J2EE 
environments. We're using JRun and/or Orion with OJB in a 
clustered/distributed
environment. This is a National Science Foundation project called the
Network for Earthquake Engineering Simulation (NEES). 
The only major problem that we ran into was the cache.  JCS just isn't
good, and hasn't seemed to get much better over the last year.  We ended
up plugging in Tangosol's Coherence Clustered Cache into the system.  We
can also do write-behinds, and buffered data caching that is queued for
transaction.  That's important to us because we're dealing with very
expensive scientific data that _can't_ get lost if a db goes down. Some
of these Tsunami experiments can get pretty expensive.

Otherwise, we use mostly the PersistenceBroker, and a little of the
ODMG.  Performance seems better on PB, but less functional.  It's not
really that much of a problem anyway, because we can cheaply and quickly
add app-servers to the cluster.
Jason

On Thu, 2003-06-12 at 22:14, Aaron Longwell wrote:
 

I realize I may be comparing Apples to Enterprise Applications here, 
but I'd like to hear some feedback about using OJB in high-load (load 
balanced?) environments.

On an OJB web application, how many requests have you seen an 
application handle? Would anyone be concerned about using OJB on an 
enormous e-commerce site? (EBay, Amazon, etc)?

Thanks for the input,
Aaron
-
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]

error - wrong foreign key generated

2003-06-13 Thread Bonnie MacKellar

I have two classes, PaymentTxn and Customer. PaymentTxn contains a foreign
key which points to Customer. When I create a new PaymentTxn, I set the
foreign key,
but the generated SQL gets the wrong value. Perhaps I am doing something
wrong in my sequence of code?

Here is the declaration for PaymentTxn :

-
public class PaymentTxn implements PaymentTxnInterface {
private int paymentTxnID;

  // some other fields

private int customerID;
private CustomerInterface issuingCustomer;

private int bankID;
private BankInterface bank;

  public void setIssuingCustomer(CustomerInterface customer) {
   this.issuingCustomer = customer;
}
--

Here is the code which creates the paymentTxn and attempts to
insert it
--
   PaymentTxn paymentTxn = new PaymentTxn();
   ...
   CustomerInterface customer = payer.getCustomer();
   System.out.println("customer id is " + customer.getID());
   paymentTxn.setIssuingCustomer(customer);
---
and the printout when this segment of code is run :

   customer id is 1

   801   ERROR [ExecuteThread: '13' for queue: 'default']
accesslayer.JdbcAccessIm
   l - SQLException during the execution of the insert (for a
com.mobius.activebil
  .persistentobjects.PaymentTxn): INSERT statement conflicted with
COLUMN FOREIGN
 KEY constraint 'FK_PaymentTxn_Customer'. The conflict occurred in
database 'Act
   veBill', table 'Customer', column 'customerID'.
   com.jnetdirect.jsql.w: INSERT statement conflicted with COLUMN
FOREIGN KEY cons
raint 'FK_PaymentTxn_Customer'. The conflict occurred in database
'ActiveBill',
   table 'Customer', column 'customerID'.
---
 
When I look at the generated SQL, I can see the error immediately - the
INSERT statement contains a value of 0 for customerID, even though the
correct customerID (as verified by the printout) is 1.

---
INSERT INTO PaymentTxn
(paymentTxnID,transactionNumber,amount,status,dateStatusChanged,payDate,conf
irmationNumber,bankVoidCode,bankVoidDesc,isPostedToICMS,customerID,bankID,pa
yerID) 
VALUES ( '1', '5', '300.35', 'completed', '', '2003-08-12 11:33:00.0',
'4566', 'xx', '', 'true', '0', '1', '1' ) 


(The customerID value is third from the end)
What is going on here? Has anyone else encountered this kind of problem?

For reference, here are the entries from database_user.xml for the two
classes.

---

Re: javaone presentation

There was a presentation on OJB at JavaOne ? cool!
Who held it?
I'd also like to see the slides!
cheers,
Thomas
Ian Holsman wrote:
seeing how the room was full, and that was 10 minutes BEFORE the
presenentation started, is it possible to post a link to the presentation.
TIA
Ian
-
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]

Special Characters in use with MySQL

2003-06-13 Thread Hinnerk Feldwisch

Hello,

I'm using OJB with the mm.mysql- driver (the latest stable release) to
store my objects in a mysql- database, which works quite fine; but I'm
having problems with special characters like the german umlaute
(äöüß). They are stored ok to data- fields with the type "VARCHAR",
but are mixed up when I use the mysql- type "TEXT" (and the jdbc- type
"LONGVARCHAR").

Where's the problem? Do I have to set the encoding up somewhere?

(OJB does retrieve the text and the special chars from the database
correctly, only the storing is a problem)

Thank you very much for any help,
Hinnerk


-
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]

Thanks Armin!

2003-06-13 Thread David C. Hicks

A couple of days ago you suggested to me a way to get multiple database 
connection descriptors to work in a single OJB environment, and I wanted 
to let you know that it has turned out successful.

For anyone else who might be interested, the procedure is something like 
this...

1) Load the repository descriptor information into MetadataManager.
2) Load the connection descriptor information into MM.  This connect 
descriptor needs to have a unique jcdAlias.
3) When asking for a PersistenceBroker be sure to use 
createPersistenceBroker() instead of defaultPersistenceBroker().

Here is a little sample code.  (jcdAlias is a String that is the name of 
the connection to the database.)

To load the new repository xml information:  (In our case, we decided on 
a convention to name the repository.xml files after the jcdAlias.)

   //see if we need to merge new connections and descriptors 
into the metadata manager
   if (!jcdAlias.equals("default"))
   {
   //make sure this connection hasn't already been loaded
   if 
(MetadataManager.getInstance().connectionRepository().getDescriptor(new 
PBKey(jcdAlias)) == null)
   {
   ConnectionRepository cr = 
MetadataManager.getInstance().readConnectionRepository(jcdAlias+"_repository.xml");
   MetadataManager.getInstance().mergeConnectionRepository(cr);
   DescriptorRepository dr = 
MetadataManager.getInstance().readDescriptorRepository(jcdAlias+"_repository.xml");
   MetadataManager.getInstance().mergeDescriptorRepository(dr);
   }
   }

To get a PersistenceBroker object:

   PBKey pbk = new PBKey(jcdAlias);
   PersistenceBroker broker = 
PersistenceBrokerFactory.createPersistenceBroker(pbk);

Armin also suggested that if you need to know which objects belong to 
which database, you can use an Attribute construct in each of your 
persistent objects:

  

While we didn't need this because of our particular components, it's an 
easy change to make to each object descriptor and the information is 
readily available in MetadataManager after it gets loaded.

Thanks again, Armin!
Dave


-
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]

RE: RC3 Test Failures with MySQL

2003-06-13 Thread Eric Northam

I'll try it for you again when I get a chance. I didn't run any of the .sh
scripts at first. I just ran 'ant junit' after configuring OJB for MySQL. I
did run the .sh scripts at one point in time and I seem to recall having the
path problem you mentioned with the binary tar, but I believed it worked in
the source tar. 

I also used MySQL 3.23.

Eric

-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] 
Sent: Friday, June 13, 2003 5:08 AM
To: [EMAIL PROTECTED]
Subject: RE: RC3 Test Failures with MySQL



I think the problem is on the ant build.xml ... like someone said (on
another reply), there should be a filter somewhere... the problem is: it
doesnt exist. Modifying the @---@ parameters it will work only in your
environment... the next time someone else install OJB (and use it with
MySQL), it has to figure out what has happened and do it all over again. Ant
should do everything by itself... you should one only have to say what you
want ant to do (prepare-tutorials, compile,...).

Even though, these errors occur, the schema is written to the database, the
data also and the tutorial works (at least in my case). I had to change all
of the bin scripts because they were missing some ../ on some paths ( BUG )
to run the tutorials with:

cd bin
./tutorialX.sh (maybe if you do this, you will see that you can run the
tutorials, even with the error messages)

The unique message could be because of the MySQL database version... i am
using 3.23 ... maybe in 4.XX? or the mapping isnt correct (it makes sense
that all parts of a primary key must be not null). (assuming that the
tutorial preparation with MySQL has worked, at least once, without giving
any error messages) I used the root mysql account to run the ant command and
it still gave me the same messages. (no problem with user database
permissions)

Pedro Salgado
---
P&G

-Message d'origine-
First modify @DATABASE_DEFAULT@ by a name (objtest) I don't remember where u
modify this :P When you configure your connection, try to give the login and
pass to the root(if u have not modify Login:root and they have no pass). It
should work better. If it didnt work better add another user to your
database,then grant him with all create, delete insert, drop for each table.
it should work a few :-)


-Message d'origine-
De : Eric Northam [mailto:[EMAIL PROTECTED]
Envoye : vendredi 6 juin 2003 15:41
A : '[EMAIL PROTECTED]'
Objet : RC3 Test Failures with MySQL


 
I grabbed the source RC3 distro and ran the the unit tests under MySQL and
received the following errors were printed out:

[torque-create-db] Resolver: used database.dtd from
org.apache.torque.engine.database.transform package
  [sql] Executing file:
C:\jakarta\db-ojb-1.0.rc3.src\target\src\sql\create-db.sql
  [sql] Failed to execute: drop database if exists @DATABASE_DEFAULT@
  [sql] java.sql.SQLException: Syntax error or access violation, message
from server: "You have an error in your SQ L syntax near
'@DATABASE_DEFAULT@'   at line 1"
  [sql] Failed to execute: create database @DATABASE_DEFAULT@
  [sql] java.sql.SQLException: Syntax error or access violation, message
from server: "You have an error in your SQ L syntax near
'@DATABASE_DEFAULT@'   at line 1"
  [sql] 0 of 2 SQL statements executed successfully

...

[torque-insert-sql] Failed to execute: CREATE TABLE REF_REPOSITORY_FK (
REP_ID INTEGER NOT NULL, REF_FK INTEGER, REFA_FK  INTEGER, REFB_FK INTEGER,
NAME VARCHAR (100), PRIMARY
KEY(REP_ID,REF_FK,REFA_FK,REFB_FK) )
[torque-insert-sql] java.sql.SQLException: General error,  message from
server: "All parts of a PRIMARY KEY must be NOT
NULL;  If you need NULL in a key, use UNIQUE instead"

Here's the summary:

junit-no-compile-no-prepare:
[junit] Running org.apache.ojb.broker.AllTests
[junit] Tests run: 209, Failures: 4, Errors: 4, Time elapsed: 95.652 sec
[junit] TEST org.apache.ojb.broker.AllTests FAILED
[junit] Running org.apache.ojb.odmg.AllTests
[junit] [BOOT] INFO: OJB.properties:
file:/C:/jakarta/db-ojb-1.0.rc3.src/target/test/ojb/OJB.properties
[junit] Tests run: 156, Failures: 3, Errors: 1, Time elapsed: 25.426 sec
[junit] TEST org.apache.ojb.odmg.AllTests FAILED
[junit] Running org.apache.ojb.soda.AllTests
[junit] [BOOT] INFO: OJB.properties:
file:/C:/jakarta/db-ojb-1.0.rc3.src/target/test/ojb/OJB.properties
[junit] Tests run: 3, Failures: 0, Errors: 0, Time elapsed: 6.649 sec
[junit] Running org.apache.ojb.otm.AllTests
[junit] Tests run: 1, Failures: 0, Errors: 0, Time elapsed: 7.17 sec

I didn't see anything posted on the todo.html page so I assume they
shouldn't occur.





DISCLAIMER: The information contained in this e-mail is, unless otherwise
indicated, confidential and is intended solely for the use of the named
addressee. Access, copying or re-use of the e-mail or any information
contained therein by any other person is not authorized. If you are not th

junit test fails

2003-06-13 Thread Mete Kural

Hi all,
I'm trying to run the junit tests on DB2. I get this error. What do you think it could 
be?
Thanks,
Mete

Output:

C:\Software\ojb\db-ojb-1.0.rc3>build junit-no-compile-no-prepare
Buildfile: build.xml

junit-no-compile-no-prepare:

BUILD FAILED
file:C:/Software/ojb/db-ojb-1.0.rc3/build.xml:734: Could not create task or type
 of type: junit.

Ant could not find the task or a class this task relies upon.

This is common and has a number of causes; the usual
solutions are to read the manual pages then download and
install needed JAR files, or fix the build file:
 - You have misspelt 'junit'.
   Fix: check your spelling.
 - The task needs an external JAR file to execute
   and this is not found at the right place in the classpath.
   Fix: check the documentation for dependencies.
   Fix: declare the task.
 - The task is an Ant optional task and optional.jar is absent
   Fix: look for optional.jar in ANT_HOME/lib, download if needed
 - The task was not built into optional.jar as dependent
   libraries were not found at build time.
   Fix: look in the JAR to verify, then rebuild with the needed
   libraries, or download a release version from apache.org
 - The build file was written for a later version of Ant
   Fix: upgrade to at least the latest release version of Ant
 - The task is not an Ant core or optional task
   and needs to be declared using .

Remember that for JAR files to be visible to Ant tasks implemented
in ANT_HOME/lib, the files must be in the same directory or on the
classpath

Please neither file bug reports on this problem, nor email the
Ant mailing lists, until all of these causes have been explored,
as this is not an Ant bug.

Total time: 1 second

C:\Software\ojb\db-ojb-1.0.rc3>echo %CLASSPATH%
C:\Java\jdk1.4\demo\jfc\SampleTree\SampleTree.jar;C:\Software\ojb\db-ojb-1.0.rc3
\lib\ant.jar;C:\Software\ojb\db-ojb-1.0.rc3\lib\optional.jar

-
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]

Re: HSQLDB problems

2003-06-13 Thread Glauber Andrade

Thanks,
I changed it already.
And I found the critical error. It was on the DATE field. I wasn't using
the "conversion" (and it works with mysql)


conversion="org.apache.ojb.broker.accesslayer.conversions.JavaDate2SqlDateFi
eldConversion"

Now its fine.

Glauber

- Original Message -
From: "Jakob Braeuchi" <[EMAIL PROTECTED]>
To: "OJB Users List" <[EMAIL PROTECTED]>
Sent: Friday, June 13, 2003 4:24 PM
Subject: Re: HSQLDB problems


> hi glauber,
>
> imo the columns defined as int(7) are the problem. according to hsqldb
> doc BIGINT is used for long.
>
> hth
> jakob
>
> Glauber Andrade wrote:
>
> >Hi,
> >
> >I was using Mysql and everything works fine.
> >Now i am changing to Hsqldb and i got some problems.
> >When I try to get the object "NotaRecibo" i got the exception:
java.sql.SQLException: Wrong data type
> >What could be wrong ?  "create table"?  "class-descriptor" ? "object
definition" ?
> >PLEASE
> >
> >Thanks,
> >
> >Glauber
> >
>
>---
--
> >>  class="c.m.s.d.NotaRecibo"
> >  table="notasrecibos"
> >   >
> >   > name="id"
> > column="id"
> > jdbc-type="BIGINT"
> > primarykey="true"
> > autoincrement="true"
> >  />
> >   > name="id_prestador"
> > column="prestador"
> > jdbc-type="BIGINT"
> >  />
> >   > name="prestador"
> > class-ref="c.m.s.d.Prestador"
> >  >
> > 
> >  
> >   > name="id_servico"
> > column="servico"
> > jdbc-type="INTEGER"
> >  />
> >   > name="servico"
> > class-ref="c.m.s.d.ServicoJuridico"
> >  >
> > 
> >  
> >   > name="data"
> > column="DATA"
> > jdbc-type="DATE"
> >  />
> >   > name="valor"
> > column="VALOR"
> > jdbc-type="DOUBLE"
> >  />
> >  > name="excessoes"
> > element-class-ref="c.m.s.d.NotaRecibo_Excessao"
> > auto-retrieve="true"
> > auto-update="true"
> > auto-delete="true"
> > refresh="true"
> >  >
> > 
> >  
> >   
>
>---
--
> >public class NotaRecibo {
> >   private long id;
> >   private Prestador prestador;
> >   private ServicoJuridico servico;
> >   private Date data;
> >   private double valor;
> >   private long id_prestador;
> >   private int id_servico;
> >   private Vector excessoes;
>
>---
--
> >CREATE TABLE notasrecibos (" +
> >  "id   INTEGER IDENTITY," +
> >  "prestadorINT(7) NOT NULL," +
> >  "servico  INT(7) NOT NULL," +
> >  "valor FLOAT(8,2) NOT NULL," +
> >  "data  DATE NOT NULL," +
> >  "FOREIGN KEY (prestador) REFERENCES Prestadores(id),"+
> >  "FOREIGN KEY (servico) REFERENCES
ServicosJuridico(id))"
> >);
>
>---
--
> >
> >
> >
>
>
> -
> 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: RC3 Test Failures with MySQL


I think the problem is on the ant build.xml ... like someone said (on another reply), 
there should be a filter somewhere...
the problem is: it doesnt exist.
Modifying the @---@ parameters it will work only in your environment... the next time 
someone else install OJB (and use it with MySQL), it has to figure out
what has happened and do it all over again.
Ant should do everything by itself... you should one only have to say what you want 
ant to do (prepare-tutorials, compile,...).

Even though, these errors occur, the schema is written to the database, the data also
and the tutorial works (at least in my case).
I had to change all of the bin scripts because they were missing some ../ on some 
paths ( BUG ) to run the tutorials with:

cd bin
./tutorialX.sh (maybe if you do this, you will see that you can run the tutorials, 
even with the error messages)

The unique message could be because of the MySQL database version... i am using 3.23 
... maybe in 4.XX? or
the mapping isnt correct (it makes sense that all parts of a primary key must be not 
null).
(assuming that the tutorial preparation with MySQL has worked, at least once, without 
giving any error messages)
I used the root mysql account to run the ant command and it still gave me the same 
messages. (no problem with user database permissions)

Pedro Salgado
---
P&G

-Message d'origine-
First modify @DATABASE_DEFAULT@ by a name (objtest) I don't remember
where u modify this :P
When you configure your connection, try to give the login and pass to
the root(if u have not modify Login:root and they have no pass). It
should work better.
If it didnt work better add another user to your database,then grant him
with all create, delete insert, drop for each table. it should work a
few :-)


-Message d'origine-
De : Eric Northam [mailto:[EMAIL PROTECTED]
Envoye : vendredi 6 juin 2003 15:41
A : '[EMAIL PROTECTED]'
Objet : RC3 Test Failures with MySQL


 
I grabbed the source RC3 distro and ran the the unit tests under MySQL
and
received the following errors were printed out:

[torque-create-db] Resolver: used database.dtd from
org.apache.torque.engine.database.transform package
  [sql] Executing file:
C:\jakarta\db-ojb-1.0.rc3.src\target\src\sql\create-db.sql
  [sql] Failed to execute: drop database if exists
@DATABASE_DEFAULT@
  [sql] java.sql.SQLException: Syntax error or access violation,
message from server: "You have an error in your SQ
L syntax near '@DATABASE_DEFAULT@'   at
line 1"
  [sql] Failed to execute: create database @DATABASE_DEFAULT@
  [sql] java.sql.SQLException: Syntax error or access violation,
message from server: "You have an error in your SQ
L syntax near '@DATABASE_DEFAULT@'   at
line 1"
  [sql] 0 of 2 SQL statements executed successfully

...

[torque-insert-sql] Failed to execute: CREATE TABLE REF_REPOSITORY_FK (
REP_ID INTEGER NOT NULL, REF_FK INTEGER, REFA_FK
 INTEGER, REFB_FK INTEGER, NAME VARCHAR (100), PRIMARY
KEY(REP_ID,REF_FK,REFA_FK,REFB_FK) )
[torque-insert-sql] java.sql.SQLException: General error,  message from
server: "All parts of a PRIMARY KEY must be NOT
NULL;  If you need NULL in a key, use UNIQUE instead"

Here's the summary:

junit-no-compile-no-prepare:
[junit] Running org.apache.ojb.broker.AllTests
[junit] Tests run: 209, Failures: 4, Errors: 4, Time elapsed: 95.652
sec
[junit] TEST org.apache.ojb.broker.AllTests FAILED
[junit] Running org.apache.ojb.odmg.AllTests
[junit] [BOOT] INFO: OJB.properties:
file:/C:/jakarta/db-ojb-1.0.rc3.src/target/test/ojb/OJB.properties
[junit] Tests run: 156, Failures: 3, Errors: 1, Time elapsed: 25.426
sec
[junit] TEST org.apache.ojb.odmg.AllTests FAILED
[junit] Running org.apache.ojb.soda.AllTests
[junit] [BOOT] INFO: OJB.properties:
file:/C:/jakarta/db-ojb-1.0.rc3.src/target/test/ojb/OJB.properties
[junit] Tests run: 3, Failures: 0, Errors: 0, Time elapsed: 6.649
sec
[junit] Running org.apache.ojb.otm.AllTests
[junit] Tests run: 1, Failures: 0, Errors: 0, Time elapsed: 7.17 sec

I didn't see anything posted on the todo.html page so I assume they
shouldn't occur.





DISCLAIMER: The information contained in this e-mail is, unless
otherwise
indicated, confidential and is intended solely for the use of the named
addressee. Access, copying or re-use of the e-mail or any information
contained therein by any other person is not authorized. If you are not
the
intended recipient please notify us immediately by returning the e-mail
to
the originator.

-
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: HSQLDB problems

2003-06-13 Thread Jakob Braeuchi

hi glauber,

imo the columns defined as int(7) are the problem. according to hsqldb 
doc BIGINT is used for long.

hth
jakob
Glauber Andrade wrote:

Hi,

I was using Mysql and everything works fine. 
Now i am changing to Hsqldb and i got some problems.
When I try to get the object "NotaRecibo" i got the exception: java.sql.SQLException: Wrong data type
What could be wrong ?  "create table"?  "class-descriptor" ? "object definition" ?
PLEASE

Thanks,

Glauber

-
  
 class="c.m.s.d.NotaRecibo"
 table="notasrecibos"
  >
 
name="id"
column="id"
jdbc-type="BIGINT"
primarykey="true"
autoincrement="true"
 />
 
name="id_prestador"
column="prestador"
jdbc-type="BIGINT"
 />
 
name="prestador"
class-ref="c.m.s.d.Prestador"
 >

 
 
name="id_servico"
column="servico"
jdbc-type="INTEGER"
 />
 
name="servico"
class-ref="c.m.s.d.ServicoJuridico"
 >

 
 
name="data"
column="DATA"
jdbc-type="DATE"
 />
 
name="valor"
column="VALOR"
jdbc-type="DOUBLE"
 />

name="excessoes"
element-class-ref="c.m.s.d.NotaRecibo_Excessao"
auto-retrieve="true"
auto-update="true"
auto-delete="true"
refresh="true"  
 >

 
  
-
public class NotaRecibo {
  private long id;
  private Prestador prestador;
  private ServicoJuridico servico;
  private Date data;
  private double valor;
  private long id_prestador;
  private int id_servico;
  private Vector excessoes;
-
CREATE TABLE notasrecibos (" +
 "id   INTEGER IDENTITY," +
 "prestadorINT(7) NOT NULL," +
 "servico  INT(7) NOT NULL," +
 "valor FLOAT(8,2) NOT NULL," +
 "data  DATE NOT NULL," +
 "FOREIGN KEY (prestador) REFERENCES Prestadores(id),"+
 "FOREIGN KEY (servico) REFERENCES ServicosJuridico(id))"
);
-

 



-
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]

javaone presentation

2003-06-13 Thread Ian Holsman

seeing how the room was full, and that was 10 minutes BEFORE the
presenentation started, is it possible to post a link to the presentation.
TIA
Ian
-
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]

Re: My Ojb cache doesn't work ??

2003-06-13 Thread Ron Gallagher

Emmanuel -- 

If I remember correctly, the only query operations that look at the cache first, 
before executing the query against the db, are those that operations that involve 
queries that incorporate Identity objects.  These are 
pb::getObjectByIdentity(Identity) and pb::getObjectByQuery(Query).  The 
getObjectByQuery method will look in the cache first only if the Query object that's 
passed in is an instance of QueryByIdentity.  For both of these methods, if the object 
isn't in the cache, the database will be queried, and, if a record is found, an object 
will be materialized, put in the cache and returned to the caller.

In all other cases, the query will be run against the database and object(s) 
representing the contents of the result set will be returned to the caller.  However, 
before the PB materializes a new object, it will look in the cache to see if there's 
an entry with the same identity.  If one is found, then another won't be materialized. 
 The object that's in the cache will be used.  If there's no matching entry in the 
cache, a new object will be materialized, put in the cache and returned to the user.

Bottom line...If the query you're running includes an Identity, the database will be 
queried only if there's no object in the cache with the same identity.  If the query 
doesn't include an Identity, then the database will be queried each time.

HTH

Ron Gallagher
Atlanta, GA
[EMAIL PROTECTED]


database will be
> 
> From: "Emmanuel Dupont" <[EMAIL PROTECTED]>
> Date: 2003/06/13 Fri PM 12:28:44 EDT
> To: "OJB Users List" <[EMAIL PROTECTED]>
> Subject: My Ojb cache doesn't work ??
> 
> All,
> 
>  
> 
>  
> 
> Here is my code
> 
>  
> 
> // Criterias...
> 
> Criteria crit = new Criteria();
> 
> crit.addEqualTo(Alt_log.LOG_ID_PK,"Essai" );
> 
> Query q = QueryFactory.newQuery(Alt_log.class, crit);
> 
>   
> 
> // Start the Db transaction
> 
> broker.beginTransaction();
> 
>  
> 
> altLogEdited  = (IAlt_log)broker.getObjectByQuery(q);
> 
> tx.lock(altLogEdited, JwtTransaction.READ);
> 
>  
> 
> altLogEdited  = (IAlt_log)broker.getObjectByQuery(q);
> 
> 
>  
> 
> // Release the db connection to PoolConnection manager
> 
> broker.commitTransaction();
> 
>   
> 
> tx.commit();
> 
>  
> 
>  
> 
>  
> 
> The getObjectByQuery method execute on the both calls a Select in the
> Database.
> 
>  
> 
> I don't put "true" in the class_descriptor "refresh" option
> 
>  
> 
> For me, OJB should'nt look to the database on the second call ...isn't it
> 
> 
>  
> 
>  
> 
> Tx !
> 
>  
> 
> 
> 


-
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]

New to OJB --> Should We Use IT ?

2003-06-13 Thread BEN BOOKEY

Dear List,

I am not sure if this is the correct email address to post but here goes.

In my company we are deciding on what technology to use for a web based database entry 
tool. The application will store simple text in most cases, but there is also a 
picture (BLOB) as well. This will be a multi-user application, and should consider 
other changes made by others i.e. CREATE, READ ,UPDATE, and DELETE. i.e. a normal OLTP 
system. Perhaps someone could send a sample project which works with ORACLE or another 
DB ?

Somehow we have come up with the idea to do this using 
Apache Tomcat 
JDO (Apache OJB came to our attention)for data persistance
Struts. 

We want to deploy to  MySQL, Oracle and perhaps even later DB2. Hopefully there will 
be no issues with this app. when using OJB(JDO uses primative JDBC to accomplish this 
DB portability is this the same with all JDO)

There are 2 developers who can work on this, and we have been told we should be 
finnished in 3 months..

I realise that this is still release candidate, but should we use OJB or can someone 
recomend another free SUN JDO implementation? I do not mean to insult anyone in this 
group, it would be great to get some honest practial experience from commercial 
project developers who have implemented this.


Kind regards

Ben Bookey,

Re: Experience in High-Load Environments

2003-06-13 Thread Aaron Longwell

Jason,

Thanks for the feedback. I understand you're probably killing these 
servers doing this intense processing... but what about # users? Is it 
one guy running intense simulations... I'm curious about # requests per 
minute type of loads.

Thanks,
Aaron
Jason McKerr wrote:

I've also worked with OJB on high-load situations in J2EE environments. 
We're using JRun and/or Orion with OJB in a clustered/distributed
environment. This is a National Science Foundation project called the
Network for Earthquake Engineering Simulation (NEES).  

The only major problem that we ran into was the cache.  JCS just isn't
good, and hasn't seemed to get much better over the last year.  We ended
up plugging in Tangosol's Coherence Clustered Cache into the system.  We
can also do write-behinds, and buffered data caching that is queued for
transaction.  That's important to us because we're dealing with very
expensive scientific data that _can't_ get lost if a db goes down. Some
of these Tsunami experiments can get pretty expensive.
Otherwise, we use mostly the PersistenceBroker, and a little of the
ODMG.  Performance seems better on PB, but less functional.  It's not
really that much of a problem anyway, because we can cheaply and quickly
add app-servers to the cluster.
Jason

On Thu, 2003-06-12 at 22:14, Aaron Longwell wrote:
 

I realize I may be comparing Apples to Enterprise Applications here, but 
I'd like to hear some feedback about using OJB in high-load (load 
balanced?) environments.

On an OJB web application, how many requests have you seen an 
application handle? Would anyone be concerned about using OJB on an 
enormous e-commerce site? (EBay, Amazon, etc)?

Thanks for the input,
Aaron
-
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]

HSQLDB problems

2003-06-13 Thread Glauber Andrade

Hi,

I was using Mysql and everything works fine. 
Now i am changing to Hsqldb and i got some problems.
When I try to get the object "NotaRecibo" i got the exception: java.sql.SQLException: 
Wrong data type
What could be wrong ?  "create table"?  "class-descriptor" ? "object definition" ?
PLEASE

Thanks,

Glauber

-
   
  
  
  
 
  
  
  
 
  
  
  
 
 
  
   
-
public class NotaRecibo {
   private long id;
   private Prestador prestador;
   private ServicoJuridico servico;
   private Date data;
   private double valor;
   private long id_prestador;
   private int id_servico;
   private Vector excessoes;
-
CREATE TABLE notasrecibos (" +
  "id   INTEGER IDENTITY," +
  "prestadorINT(7) NOT NULL," +
  "servico  INT(7) NOT NULL," +
  "valor FLOAT(8,2) NOT NULL," +
  "data  DATE NOT NULL," +
  "FOREIGN KEY (prestador) REFERENCES Prestadores(id),"+
  "FOREIGN KEY (servico) REFERENCES ServicosJuridico(id))"
);
-

My Ojb cache doesn't work ??

2003-06-13 Thread Emmanuel Dupont

All,

 

 

Here is my code

 

// Criterias...

Criteria crit = new Criteria();

crit.addEqualTo(Alt_log.LOG_ID_PK,"Essai" );

Query q = QueryFactory.newQuery(Alt_log.class, crit);

  

// Start the Db transaction

broker.beginTransaction();

 

altLogEdited  = (IAlt_log)broker.getObjectByQuery(q);

tx.lock(altLogEdited, JwtTransaction.READ);

 

altLogEdited  = (IAlt_log)broker.getObjectByQuery(q);


 

// Release the db connection to PoolConnection manager

broker.commitTransaction();

  

tx.commit();

 

 

 

The getObjectByQuery method execute on the both calls a Select in the
Database.

 

I don't put "true" in the class_descriptor "refresh" option

 

For me, OJB should'nt look to the database on the second call ...isn't it


 

 

Tx !

Re: Experience in High-Load Environments

2003-06-13 Thread Jason McKerr

I've also worked with OJB on high-load situations in J2EE environments. 
We're using JRun and/or Orion with OJB in a clustered/distributed
environment. This is a National Science Foundation project called the
Network for Earthquake Engineering Simulation (NEES).  

The only major problem that we ran into was the cache.  JCS just isn't
good, and hasn't seemed to get much better over the last year.  We ended
up plugging in Tangosol's Coherence Clustered Cache into the system.  We
can also do write-behinds, and buffered data caching that is queued for
transaction.  That's important to us because we're dealing with very
expensive scientific data that _can't_ get lost if a db goes down. Some
of these Tsunami experiments can get pretty expensive.

Otherwise, we use mostly the PersistenceBroker, and a little of the
ODMG.  Performance seems better on PB, but less functional.  It's not
really that much of a problem anyway, because we can cheaply and quickly
add app-servers to the cluster.

Jason

On Thu, 2003-06-12 at 22:14, Aaron Longwell wrote:
> I realize I may be comparing Apples to Enterprise Applications here, but 
> I'd like to hear some feedback about using OJB in high-load (load 
> balanced?) environments.
> 
> On an OJB web application, how many requests have you seen an 
> application handle? Would anyone be concerned about using OJB on an 
> enormous e-commerce site? (EBay, Amazon, etc)?
> 
> Thanks for the input,
> Aaron
> 
> 
> -
> 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: Database Lifecycle

2003-06-13 Thread Armin Waibel

Hi Eric,

currently OJB isn't a singleton (was a singleton before 0.9.4).
OJB.getInstance returns a new Implementation instance
on each call. So get the references to Implementation
and Database from ContextIntializer (or a class
encapsulate this stuff) instead of
doing
OJB.getInstance();
in your action class

> Where and when should I be opening and closing the database. I assumed
I
> would only have to open it once on application startup and close it on
> shutdown.
yes

> Is this assumption incorrect? If so what are the performance
> consequences of opening and closing the Database object?
open/close database isn't a big performance impact

regards,
Armin

- Original Message -
From: "Eric Northam" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Friday, June 13, 2003 4:41 PM
Subject: Database Lifecycle


> I'm using OJB in Tomcat and I couldn't seem to locate any information
about
> where and when to open and close the Database object. I assumed that
> OJB.getInstance would return a reference to a singleton object so that
if I
> created a new database in one place that would be sufficient. I wrote
a
> ContextIntializer which is a class that has a contextInitialized
method that
> gets called on webapp deployment and put the following code in it:
>
> -
> Implementation odmg = OJB.getInstance();
>
> database = odmg.newDatabase();
>
> try {
>
> database.open(null, Database.OPEN_READ_WRITE);
>
> }
>
> catch (ODMGException e) {
>
> log.fatal("Error initializing the database", e);
>
> throw new InitializationException("Error initializing the database",
e);
>
> }
>
> --
>
> I then put then put the following code in a Struts action:
>
> -
>
> Implementation odmg = OJB.getInstance();
>
> Transaction tx = odmg.newTransaction();
>
> -
>
> I know that the datbase is opened because of the log messages I print
out,
> but later when the action is called I get:
>
> org.odmg.DatabaseClosedException: Database is NULL, must have a DB in
order
> to create a transaction
>
>
>
> Where and when should I be opening and closing the database. I assumed
I
> would only have to open it once on application startup and close it on
> shutdown. Is this assumption incorrect? If so what are the performance
> consequences of opening and closing the Database object?
>
> Eric
>
>
>
>
>
>
>
>
> DISCLAIMER: The information contained in this e-mail is, unless
otherwise
> indicated, confidential and is intended solely for the use of the
named
> addressee. Access, copying or re-use of the e-mail or any information
> contained therein by any other person is not authorized. If you are
not the
> intended recipient please notify us immediately by returning the
e-mail to
> the originator.
>



-
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]

Database Lifecycle

2003-06-13 Thread Eric Northam

I'm using OJB in Tomcat and I couldn't seem to locate any information about
where and when to open and close the Database object. I assumed that
OJB.getInstance would return a reference to a singleton object so that if I
created a new database in one place that would be sufficient. I wrote a
ContextIntializer which is a class that has a contextInitialized method that
gets called on webapp deployment and put the following code in it:
 
-
Implementation odmg = OJB.getInstance();

database = odmg.newDatabase();

try {

database.open(null, Database.OPEN_READ_WRITE);

}

catch (ODMGException e) {

log.fatal("Error initializing the database", e);

throw new InitializationException("Error initializing the database", e);

}

--

I then put then put the following code in a Struts action:

-

Implementation odmg = OJB.getInstance();

Transaction tx = odmg.newTransaction();

-

I know that the datbase is opened because of the log messages I print out,
but later when the action is called I get:

org.odmg.DatabaseClosedException: Database is NULL, must have a DB in order
to create a transaction

 

Where and when should I be opening and closing the database. I assumed I
would only have to open it once on application startup and close it on
shutdown. Is this assumption incorrect? If so what are the performance
consequences of opening and closing the Database object?

Eric

 






DISCLAIMER: The information contained in this e-mail is, unless otherwise
indicated, confidential and is intended solely for the use of the named
addressee. Access, copying or re-use of the e-mail or any information
contained therein by any other person is not authorized. If you are not the
intended recipient please notify us immediately by returning the e-mail to
the originator.

Re: ERROR: ConfigurableFactory instantiation failed

Got the new OJB.properties (doesnt seem different of the one shipped with
OJB1.0rc3, though).

Changed the jcdalias (this really made some difference), but now:

java.lang.NoSuchMethodError:
org.apache.commons.dbcp.PoolableConnectionFactory.(Lorg/apache/commons/dbcp/ConnectionFactory;Lorg/apache/commons/pool/ObjectPool;Lorg/apache/commons/pool/KeyedObjectPoolFactory;Ljava/lang/String;ZZLorg/apache/commons/dbcp/AbandonedConfig;)

I will post my conf files (for the my test web app) as an attachment... maybe
that will help...

Thanks for the help

Pedro Salgado

(See attached file: OJB_properties)(See attached file: repository_user.xml)(See
attached file: repository_internal.xml)(See attached file: repository.xml)




Hi,

in earlier versions of OJB the path to the
repository file was used to open the Database (ODMG-api)
or lookup a PersistenceBroker (PB-api).

Now we use an alias name, defined in the repository
file. Each jdbc-connection-descriptor now has an
unique jcd-alias name.

If you don't want to change the lookup in your
'old' code, set the the repository
path as jcd-alias as  e.g
jcd-alias="repository.xml"
Then the database open method works
as in further OJB versions.

HTH
regards,
Armin

- Original Message -
From: <[EMAIL PROTECTED]>
To: "OJB Users List" <[EMAIL PROTECTED]>
Sent: Friday, June 13, 2003 2:09 PM
Subject: Re: ERROR: ConfigurableFactory instantiation failed


>
>
> I ve found the cause of the problem and possible solution at:
>
>  http://dbforums.com/t704806.html
>
> org.apache.ojb.broker.TestHelper I've found that the first argument of
db.open is NOT repository.xml but a string containing the
jcdAlias#user#passwd
> ie: default#oleg#oleg
>
>
> but i still dont know how to solve it... do i need to change and
recompile the source?
>
> Pedro Salgado
>
>
>
> -
> 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: Possible CollectionProxy bug?

2003-06-13 Thread Edson Carlos Ericksson Richter

Anyone can confirm that this is a bug or not?

Thanks,

Edson Richter
- Original Message - 
From: "Edson Carlos Ericksson Richter" <[EMAIL PROTECTED]>
To: "OJB Users List" <[EMAIL PROTECTED]>
Sent: Thursday, June 12, 2003 11:13 AM
Subject: Possible CollectionProxy bug?


I think I get RemovalAwareCollection working with proxied classes.

The method afterStore in CollectionProxy should not be:


public void afterStore(PersistenceBroker broker) throws
PersistenceBrokerException
{
  Collection c = getData();

  if( c instanceof ManageableCollection )
( ( ManageableCollection )c ).afterStore( broker );

}


Thomas, can you confirm this?

Thanks,

Edson Richter




- Original Message - 
From: "onno" <[EMAIL PROTECTED]>
To: "OJB Users List" <[EMAIL PROTECTED]>
Sent: Thursday, June 12, 2003 9:22 AM
Subject: Auto-delete woes


Long time no post but we found a strange behaviour in our app which
otherwise has been running fine.

it involves the auto-delete

we use

Broker.deleteByQuery(aQuery); //where the Query is just a 1 Primary Key from
an object.

This however doesn't seem to delete any linked objects (ie per defined in
auto-delete)

eg:

  Request (auto-everything == true ;)
 1-1 with a Interaction  (auto-everything == true ;)
   1-1 with a (Temp User) (auto-everything == true
;)

when we delete a request it gets deleted however the Interaction Object
sticks around and
needless to say also the Temp User.

Any logic error we do?

Greetz

Onno


-
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]


---
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.488 / Virus Database: 287 - Release Date: 5/6/2003



-
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]




---
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.489 / Virus Database: 288 - Release Date: 10/6/2003



-
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]

RE: Problem with junit testing on Oracle 8.1.7

2003-06-13 Thread PWorth

Looks like I got around the class not found problem by converting the zip 
file into a jar and then putting it in the lib directory.  Now my junit 
output looks like:

junit-no-compile-no-prepare:
[junit] Running org.apache.ojb.broker.AllTests
[junit] Tests run: 209, Failures: 12, Errors: 66, Time elapsed: 97.977 
sec
[junit] TEST org.apache.ojb.broker.AllTests FAILED
[junit] Running org.apache.ojb.odmg.AllTests
[junit] [BOOT] INFO: OJB.properties: 
file:/C:/db-ojb-1.0.rc3/target/test/ojb/OJB.properties
[junit] Tests run: 156, Failures: 12, Errors: 57, Time elapsed: 16.604 
sec
[junit] TEST org.apache.ojb.odmg.AllTests FAILED
[junit] Running org.apache.ojb.soda.AllTests
[junit] [BOOT] INFO: OJB.properties: 
file:/C:/db-ojb-1.0.rc3/target/test/ojb/OJB.properties
[junit] Tests run: 3, Failures: 0, Errors: 0, Time elapsed: 5.758 sec
[junit] Running org.apache.ojb.otm.AllTests
[junit] Tests run: 1, Failures: 0, Errors: 0, Time elapsed: 5.859 sec


Doesn't give me a warm and fuzzy that this package is ready for prime time 
on Oracle 8i.

Peter






[EMAIL PROTECTED]
06/13/2003 07:55 AM
Please respond to "OJB Users List"

 
To: "OJB Users List" <[EMAIL PROTECTED]>
cc: 
Subject:RE: Problem with junit testing on Oracle 8.1.7


Thanks for the response Mahler.

There's the rub, its a zip file actually.  I have modified the build.bat 
script to incorporate the zip file in the JVM classpath argument as 
follows:

@echo off
REM Please let JAVA_HOME point to your JDK base directory
if "%JAVA_HOME%" == "" set JAVA_HOME=C:\jdk1.3.1_08

set JAVA=%JAVA_HOME%\bin\java
set cp=
for %%i in (lib\*.jar) do call bin\cp.bat %%i
set 
CP=..\target\classes;..\target\classestest;%JAVA_HOME%\lib\tools.jar;%CP%

set 
local_cp=c:\ora8i\jdbc\lib\classes12.zip;c:\websphere\appserver\lib\j2ee.jar;%CP%
echo JVM classpath is %local_cp%...

"%JAVA%" -classpath "%local_cp%" -Dant.home=lib org.apache.tools.ant.Main 
%1 %2 %3 %4 %5 %6 -buildfile build.xml

This seemed to work fine when I built the test db (bin\build 
prepare-testdb) but does not seem to work when I run the unit tests 
(bin\build junit)???  I'm a bit stumped.

Peter





Mahler Thomas <[EMAIL PROTECTED]>
06/13/2003 03:20 AM
Please respond to "OJB Users List"

 
To: "'OJB Users List'" <[EMAIL PROTECTED]>
cc: 
Subject:RE: Problem with junit testing on Oracle 8.1.7


Just place the drivers jar file in the OJB lib directory.

> -Original Message-
> From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]
> Sent: Friday, June 13, 2003 12:13 AM
> To: OJB Users List
> Subject: Re: Problem with junit testing on Oracle 8.1.7
> 
> 
> It looks like the JVM that is executing the tests can't find 
> my driver 
> class, even though classes12.zip (the Oracle driver library) 
> is on the JVM 
> classpath when it executes.  Is there a specific 
> modification/configuration I need to make to force junit to 
> find my driver 
> class?
> 
> Here is a sample of the errors I am getting in target\test
> 
> thx in advance
> 
> Peter
> 
> 
> 
> Testsuite: org.apache.ojb.broker.AllTests
> Tests run: 209, Failures: 20, Errors: 150, Time elapsed: 60.805 sec
> - Standard Output ---
> [BOOT] INFO: OJB.properties: 
> file:/C:/db-ojb-1.0.rc3/target/test/ojb/OJB.properties
> [org.apache.ojb.broker.accesslayer.ConnectionFactoryPooledImpl] INFO: 
> Create new connection 
> pool:[EMAIL PROTECTED]
>   jcd-alias=default
>   default-connection=true
>   dbms=Oracle
>   jdbc-level=1.0
>   driver=oracle.jdbc.driver.OracleDriver
>   protocol=jdbc
>   sub-protocol=oracle
>   db-alias=oci8:@WBSP.WORLD
>   user=storefront
>   password=*
>   eager-release=false
>   ConnectionPoolDescriptor={whenExhaustedAction=0, maxIdle=-1, 
> maxActive=21, maxWait=5000, removeAbandoned=false, 
> numTestsPerEvictionRun=10, testWhileIdle=false, 
> minEvictableIdleTimeMillis=60, testOnReturn=false, 
> logAbandoned=false, 
> removeAbandonedTimeout=300, timeBetweenEvictionRunsMillis=-1, 
> testOnBorrow=true}
>   batchMode=false
>   useAutoCommit=AUTO_COMMIT_SET_TRUE_AND_TEMPORARY_FALSE
>   ignoreAutoCommitExceptions=false
> 
> sequenceDescriptor=org.apache.ojb.broker.metadata.SequenceDesc
> [EMAIL PROTECTED]
>  sequenceManagerClass=class 
> org.apache.ojb.broker.util.sequence.SequenceManagerHighLowImpl
>  Properties={autoNaming=true, globalSequenceId=false, 
> globalSequenceStart=1, grabSize=20}
> ]
> ]
> [org.apache.ojb.broker.accesslayer.ConnectionFactoryAbstractIm
> pl] ERROR: 
> oracle.jdbc.driver.OracleDriver
> [org.apache.ojb.broker.accesslayer.JdbcAccessImpl] ERROR: 
> PersistenceBrokerException during the execution of 
> materializeObject: Used 
> ConnectionManager instance could not obtain a connection: 
> Could not borrow 
> connection from pool - 
> org.apache.ojb.broker.metadata.JdbcConnectionDescriptor: 
> [EMAIL PROTECTED]
>   jcd-alias=default
>   default-connection=tru

Re: ERROR: ConfigurableFactory instantiation failed

2003-06-13 Thread Armin Waibel

Hi,

in earlier versions of OJB the path to the
repository file was used to open the Database (ODMG-api)
or lookup a PersistenceBroker (PB-api).

Now we use an alias name, defined in the repository
file. Each jdbc-connection-descriptor now has an
unique jcd-alias name.

If you don't want to change the lookup in your
'old' code, set the the repository
path as jcd-alias as  e.g
jcd-alias="repository.xml"
Then the database open method works
as in further OJB versions.

HTH
regards,
Armin

- Original Message -
From: <[EMAIL PROTECTED]>
To: "OJB Users List" <[EMAIL PROTECTED]>
Sent: Friday, June 13, 2003 2:09 PM
Subject: Re: ERROR: ConfigurableFactory instantiation failed


>
>
> I ve found the cause of the problem and possible solution at:
>
>  http://dbforums.com/t704806.html
>
> org.apache.ojb.broker.TestHelper I've found that the first argument of
db.open is NOT repository.xml but a string containing the
jcdAlias#user#passwd
> ie: default#oleg#oleg
>
>
> but i still dont know how to solve it... do i need to change and
recompile the source?
>
> Pedro Salgado
>
>
>
> -
> 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: ERROR: ConfigurableFactory instantiation failed

2003-06-13 Thread Armin Waibel

It seems like a configuration error.

- Check if OJB.properties can be found
info see
http://db.apache.org/ojb/ojb-properties.html

- Check version (only use shipped OJB.properties
don't use OJB.properties from further versions in new one)

regards,
Armin

- Original Message -
From: <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Friday, June 13, 2003 1:14 PM
Subject: ERROR: ConfigurableFactory instantiation failed


>
> I am building a Struts+OJB webapp and when getting an extent of a
class (very
> simple case) i get the error below.
>
> I am using OJB 1.0rc3 and MySQL 3.23
> The tutorial worked fine so i used the same OJB.properties and changed
> repository xml files to include correct mappings (just one class, one
table, one
> mapping - it is just to put everything to work).
>
> I didnt define any jdbc connection on my web.xml (do i need to?)...
>
> Can anyone help me to figure out what is happening?
>
> Thank you...
>
> Pedro Salgado
>
> ---
> [org.apache.ojb.broker.metadata.ConnectionRepository] INFO: Could not
found
> org.apache.ojb.broker.metadata.JdbcConnectionDescriptor for PBKey
> org.apache.ojb.broker.PBKey: repository=repository.xml, user=null,
password=null
> [org.apache.ojb.broker.accesslayer.ConnectionManagerFactory] ERROR:
> ConfigurableFactory instantiation failed for class class
> org.apache.ojb.broker.accesslayer.ConnectionManagerImpl
> * Factory types:
> 1 - Type: org.apache.ojb.broker.PersistenceBroker
> * Factory arguments:
> 1 - Argument: [EMAIL PROTECTED]
> null
> java.lang.reflect.InvocationTargetException
>  at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native
Method)
>  at
>
sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorA
ccessorImpl.java:39)
>  at
>
sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingCons
tructorAccessorImpl.java:27)
>  at
java.lang.reflect.Constructor.newInstance(Constructor.java:274)
>  at org.apache.ojb.broker.util.ClassHelper.newInstance(Unknown
Source)
>  at
>
org.apache.ojb.broker.util.factory.ConfigurableFactory.createNewInstance
(Unknown
> Source)
>  at
>
org.apache.ojb.broker.util.factory.ConfigurableFactory.createNewInstance
(Unknown
> Source)
>  at
>
org.apache.ojb.broker.accesslayer.ConnectionManagerFactory.createConnect
ionManager(Unknown
>
> Source)
>  at
org.apache.ojb.broker.core.PersistenceBrokerImpl.(Unknown Source)
>  at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native
Method)
>  at
>
sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorA
ccessorImpl.java:39)
>  at
>
sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingCons
tructorAccessorImpl.java:27)
>  at
java.lang.reflect.Constructor.newInstance(Constructor.java:274)
>  at org.apache.ojb.broker.util.ClassHelper.newInstance(Unknown
Source)
>  at
>
org.apache.ojb.broker.core.PersistenceBrokerFactoryDefaultImpl.createNew
BrokerInstance(Unknown
>
> Source)
>  at
>
org.apache.ojb.broker.core.PersistenceBrokerFactoryDefaultImpl$PBKeyedPo
olableObjectFactory.makeObject(Unknown
>
> Source)
>  at
org.apache.commons.pool.impl.GenericKeyedObjectPool.borrowObject(Unknown
> Source)
>  at
>
org.apache.ojb.broker.core.PersistenceBrokerFactoryDefaultImpl.createPer
sistenceBroker(Unknown
>
> Source)
>  at
>
org.apache.ojb.broker.PersistenceBrokerFactory.createPersistenceBroker(U
nknown
> Source)
>  at org.apache.ojb.odmg.DatabaseImpl.open(Unknown Source)
>  at portoonline.services.BaseService.init(BaseService.java:38)
>  at portoonline.framework.actions.DoOJB.execute(DoOJB.java:32)
>  at
>
org.apache.struts.action.RequestProcessor.processActionPerform(RequestPr
ocessor.java:484)
>  at
>
org.apache.struts.action.RequestProcessor.process(RequestProcessor.java:
274)
>  at
org.apache.struts.action.ActionServlet.process(ActionServlet.java:1480)
>  at
org.apache.struts.action.ActionServlet.doGet(ActionServlet.java:506)
>  at javax.servlet.http.HttpServlet.service(HttpServlet.java:740)
>  at javax.servlet.http.HttpServlet.service(HttpServlet.java:853)
>  at
>
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(Applica
tionFilterChain.java:247)
>  at
>
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilt
erChain.java:193)
>  at
>
org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValv
e.java:260)
>  at
>
org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.i
nvokeNext(StandardPipeline.java:646)
>  at
>
org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:4
83)
>  at
org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:995)
>  at
>
org.apache.catalina.core.StandardContextValve.invoke(StandardContextValv
e.java:191)
>  at
>
org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.i
nvokeNext(StandardPipeline.java:646)
>  at
>
org.apache.catalina.authenti

Re: ERROR: ConfigurableFactory instantiation failed



I ve found the cause of the problem and possible solution at:

 http://dbforums.com/t704806.html

org.apache.ojb.broker.TestHelper I've found that the first argument of db.open is NOT 
repository.xml but a string containing the jcdAlias#user#passwd
ie: default#oleg#oleg


but i still dont know how to solve it... do i need to change and recompile the source?

Pedro Salgado



-
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]

RE: Problem with junit testing on Oracle 8.1.7

2003-06-13 Thread PWorth

Thanks for the response Mahler.

There's the rub, its a zip file actually.  I have modified the build.bat 
script to incorporate the zip file in the JVM classpath argument as 
follows:

@echo off
REM Please let JAVA_HOME point to your JDK base directory
if "%JAVA_HOME%" == "" set JAVA_HOME=C:\jdk1.3.1_08

set JAVA=%JAVA_HOME%\bin\java
set cp=
for %%i in (lib\*.jar) do call bin\cp.bat %%i
set 
CP=..\target\classes;..\target\classestest;%JAVA_HOME%\lib\tools.jar;%CP%

set 
local_cp=c:\ora8i\jdbc\lib\classes12.zip;c:\websphere\appserver\lib\j2ee.jar;%CP%
echo JVM classpath is %local_cp%...

"%JAVA%" -classpath "%local_cp%" -Dant.home=lib org.apache.tools.ant.Main 
%1 %2 %3 %4 %5 %6 -buildfile build.xml

This seemed to work fine when I built the test db (bin\build 
prepare-testdb) but does not seem to work when I run the unit tests 
(bin\build junit)???  I'm a bit stumped.

Peter





Mahler Thomas <[EMAIL PROTECTED]>
06/13/2003 03:20 AM
Please respond to "OJB Users List"

 
To: "'OJB Users List'" <[EMAIL PROTECTED]>
cc: 
Subject:RE: Problem with junit testing on Oracle 8.1.7


Just place the drivers jar file in the OJB lib directory.

> -Original Message-
> From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]
> Sent: Friday, June 13, 2003 12:13 AM
> To: OJB Users List
> Subject: Re: Problem with junit testing on Oracle 8.1.7
> 
> 
> It looks like the JVM that is executing the tests can't find 
> my driver 
> class, even though classes12.zip (the Oracle driver library) 
> is on the JVM 
> classpath when it executes.  Is there a specific 
> modification/configuration I need to make to force junit to 
> find my driver 
> class?
> 
> Here is a sample of the errors I am getting in target\test
> 
> thx in advance
> 
> Peter
> 
> 
> 
> Testsuite: org.apache.ojb.broker.AllTests
> Tests run: 209, Failures: 20, Errors: 150, Time elapsed: 60.805 sec
> - Standard Output ---
> [BOOT] INFO: OJB.properties: 
> file:/C:/db-ojb-1.0.rc3/target/test/ojb/OJB.properties
> [org.apache.ojb.broker.accesslayer.ConnectionFactoryPooledImpl] INFO: 
> Create new connection 
> pool:[EMAIL PROTECTED]
>   jcd-alias=default
>   default-connection=true
>   dbms=Oracle
>   jdbc-level=1.0
>   driver=oracle.jdbc.driver.OracleDriver
>   protocol=jdbc
>   sub-protocol=oracle
>   db-alias=oci8:@WBSP.WORLD
>   user=storefront
>   password=*
>   eager-release=false
>   ConnectionPoolDescriptor={whenExhaustedAction=0, maxIdle=-1, 
> maxActive=21, maxWait=5000, removeAbandoned=false, 
> numTestsPerEvictionRun=10, testWhileIdle=false, 
> minEvictableIdleTimeMillis=60, testOnReturn=false, 
> logAbandoned=false, 
> removeAbandonedTimeout=300, timeBetweenEvictionRunsMillis=-1, 
> testOnBorrow=true}
>   batchMode=false
>   useAutoCommit=AUTO_COMMIT_SET_TRUE_AND_TEMPORARY_FALSE
>   ignoreAutoCommitExceptions=false
> 
> sequenceDescriptor=org.apache.ojb.broker.metadata.SequenceDesc
> [EMAIL PROTECTED]
>  sequenceManagerClass=class 
> org.apache.ojb.broker.util.sequence.SequenceManagerHighLowImpl
>  Properties={autoNaming=true, globalSequenceId=false, 
> globalSequenceStart=1, grabSize=20}
> ]
> ]
> [org.apache.ojb.broker.accesslayer.ConnectionFactoryAbstractIm
> pl] ERROR: 
> oracle.jdbc.driver.OracleDriver
> [org.apache.ojb.broker.accesslayer.JdbcAccessImpl] ERROR: 
> PersistenceBrokerException during the execution of 
> materializeObject: Used 
> ConnectionManager instance could not obtain a connection: 
> Could not borrow 
> connection from pool - 
> org.apache.ojb.broker.metadata.JdbcConnectionDescriptor: 
> [EMAIL PROTECTED]
>   jcd-alias=default
>   default-connection=true
>   dbms=Oracle
>   jdbc-level=1.0
>   driver=oracle.jdbc.driver.OracleDriver
>   protocol=jdbc
>   sub-protocol=oracle
>   db-alias=oci8:@WBSP.WORLD
>   user=storefront
>   password=*
>   eager-release=false
>   ConnectionPoolDescriptor={whenExhaustedAction=0, maxIdle=-1, 
> maxActive=21, maxWait=5000, removeAbandoned=false, 
> numTestsPerEvictionRun=10, testWhileIdle=false, 
> minEvictableIdleTimeMillis=60, testOnReturn=false, 
> logAbandoned=false, 
> removeAbandonedTimeout=300, timeBetweenEvictionRunsMillis=-1, 
> testOnBorrow=true}
>   batchMode=false
>   useAutoCommit=AUTO_COMMIT_SET_TRUE_AND_TEMPORARY_FALSE
>   ignoreAutoCommitExceptions=false
> 
> sequenceDescriptor=org.apache.ojb.broker.metadata.SequenceDesc
> [EMAIL PROTECTED]
>  sequenceManagerClass=class 
> org.apache.ojb.broker.util.sequence.SequenceManagerHighLowImpl
>  Properties={autoNaming=true, globalSequenceId=false, 
> globalSequenceStart=1, grabSize=20}
> ]
> ]: A class was not found: oracle.jdbc.driver.OracleDriver
> Used ConnectionManager instance could not obtain a 
> connection: Could not 
> borrow connection from pool - 
> org.apache.ojb.broker.metadata.JdbcConnectionDescriptor: 
> [EMAIL PROTECTED]
>   jcd-alias=default
>   default-connection=true
>   dbms=Oracle
>   jdbc-level=1.0
>   driver=oracle.jdbc.

RE: RC3 Test Failures with MySQL

From
I think the problem is on the ant build.xml ... like someone said (on another reply), 
there should be a filter somewhere...
the problem is: it doesnt exist.
Modifying the @---@ parameters it will work only in your environment... the next time 
someone else install OJB (and use it with MySQL), it has to figure out
what has happened and do it all over again.
Ant should do everything by itself... you should one only have to say what you want 
ant to do (prepare-tutorials, compile,...).

Even though, these errors occur, the schema is written to the database, the data also
and the tutorial works (at least in my case).
I had to change all of the bin scripts because they were missing some ../ on some 
paths ( BUG ) to run the tutorials with:

cd bin
./tutorialX.sh (maybe if you do this, you will see that you can run the tutorials, 
even with the error messages)

The unique message could be because of the MySQL database version... i am using 3.23 
... maybe in 4.XX? or
the mapping isnt correct (it makes sense that all parts of a primary key must be not 
null).
(assuming that the tutorial preparation with MySQL has worked, at least once, without 
giving any error messages)
I used the root mysql account to run the ant command and it still gave me the same 
messages. (no problem with user database permissions)

Pedro Salgado
---
P&G

-Message d'origine-
First modify @DATABASE_DEFAULT@ by a name (objtest) I don't remember
where u modify this :P
When you configure your connection, try to give the login and pass to
the root(if u have not modify Login:root and they have no pass). It
should work better.
If it didnt work better add another user to your database,then grant him
with all create, delete insert, drop for each table. it should work a
few :-)


-Message d'origine-
De : Eric Northam [mailto:[EMAIL PROTECTED]
Envoye : vendredi 6 juin 2003 15:41
A : '[EMAIL PROTECTED]'
Objet : RC3 Test Failures with MySQL


 
I grabbed the source RC3 distro and ran the the unit tests under MySQL
and
received the following errors were printed out:

[torque-create-db] Resolver: used database.dtd from
org.apache.torque.engine.database.transform package
  [sql] Executing file:
C:\jakarta\db-ojb-1.0.rc3.src\target\src\sql\create-db.sql
  [sql] Failed to execute: drop database if exists
@DATABASE_DEFAULT@
  [sql] java.sql.SQLException: Syntax error or access violation,
message from server: "You have an error in your SQ
L syntax near '@DATABASE_DEFAULT@'   at
line 1"
  [sql] Failed to execute: create database @DATABASE_DEFAULT@
  [sql] java.sql.SQLException: Syntax error or access violation,
message from server: "You have an error in your SQ
L syntax near '@DATABASE_DEFAULT@'   at
line 1"
  [sql] 0 of 2 SQL statements executed successfully

...

[torque-insert-sql] Failed to execute: CREATE TABLE REF_REPOSITORY_FK (
REP_ID INTEGER NOT NULL, REF_FK INTEGER, REFA_FK
 INTEGER, REFB_FK INTEGER, NAME VARCHAR (100), PRIMARY
KEY(REP_ID,REF_FK,REFA_FK,REFB_FK) )
[torque-insert-sql] java.sql.SQLException: General error,  message from
server: "All parts of a PRIMARY KEY must be NOT
NULL;  If you need NULL in a key, use UNIQUE instead"

Here's the summary:

junit-no-compile-no-prepare:
[junit] Running org.apache.ojb.broker.AllTests
[junit] Tests run: 209, Failures: 4, Errors: 4, Time elapsed: 95.652
sec
[junit] TEST org.apache.ojb.broker.AllTests FAILED
[junit] Running org.apache.ojb.odmg.AllTests
[junit] [BOOT] INFO: OJB.properties:
file:/C:/jakarta/db-ojb-1.0.rc3.src/target/test/ojb/OJB.properties
[junit] Tests run: 156, Failures: 3, Errors: 1, Time elapsed: 25.426
sec
[junit] TEST org.apache.ojb.odmg.AllTests FAILED
[junit] Running org.apache.ojb.soda.AllTests
[junit] [BOOT] INFO: OJB.properties:
file:/C:/jakarta/db-ojb-1.0.rc3.src/target/test/ojb/OJB.properties
[junit] Tests run: 3, Failures: 0, Errors: 0, Time elapsed: 6.649
sec
[junit] Running org.apache.ojb.otm.AllTests
[junit] Tests run: 1, Failures: 0, Errors: 0, Time elapsed: 7.17 sec

I didn't see anything posted on the todo.html page so I assume they
shouldn't occur.



-
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]

ERROR: ConfigurableFactory instantiation failed


I am building a Struts+OJB webapp and when getting an extent of a class (very
simple case) i get the error below.

I am using OJB 1.0rc3 and MySQL 3.23
The tutorial worked fine so i used the same OJB.properties and changed
repository xml files to include correct mappings (just one class, one table, one
mapping - it is just to put everything to work).

I didnt define any jdbc connection on my web.xml (do i need to?)...

Can anyone help me to figure out what is happening?

Thank you...

Pedro Salgado

---
[org.apache.ojb.broker.metadata.ConnectionRepository] INFO: Could not found
org.apache.ojb.broker.metadata.JdbcConnectionDescriptor for PBKey
org.apache.ojb.broker.PBKey: repository=repository.xml, user=null, password=null
[org.apache.ojb.broker.accesslayer.ConnectionManagerFactory] ERROR:
ConfigurableFactory instantiation failed for class class
org.apache.ojb.broker.accesslayer.ConnectionManagerImpl
* Factory types:
1 - Type: org.apache.ojb.broker.PersistenceBroker
* Factory arguments:
1 - Argument: [EMAIL PROTECTED]
null
java.lang.reflect.InvocationTargetException
 at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
 at
sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:39)
 at
sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:27)
 at java.lang.reflect.Constructor.newInstance(Constructor.java:274)
 at org.apache.ojb.broker.util.ClassHelper.newInstance(Unknown Source)
 at
org.apache.ojb.broker.util.factory.ConfigurableFactory.createNewInstance(Unknown
Source)
 at
org.apache.ojb.broker.util.factory.ConfigurableFactory.createNewInstance(Unknown
Source)
 at
org.apache.ojb.broker.accesslayer.ConnectionManagerFactory.createConnectionManager(Unknown

Source)
 at org.apache.ojb.broker.core.PersistenceBrokerImpl.(Unknown Source)
 at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
 at
sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:39)
 at
sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:27)
 at java.lang.reflect.Constructor.newInstance(Constructor.java:274)
 at org.apache.ojb.broker.util.ClassHelper.newInstance(Unknown Source)
 at
org.apache.ojb.broker.core.PersistenceBrokerFactoryDefaultImpl.createNewBrokerInstance(Unknown

Source)
 at
org.apache.ojb.broker.core.PersistenceBrokerFactoryDefaultImpl$PBKeyedPoolableObjectFactory.makeObject(Unknown

Source)
 at org.apache.commons.pool.impl.GenericKeyedObjectPool.borrowObject(Unknown
Source)
 at
org.apache.ojb.broker.core.PersistenceBrokerFactoryDefaultImpl.createPersistenceBroker(Unknown

Source)
 at
org.apache.ojb.broker.PersistenceBrokerFactory.createPersistenceBroker(Unknown
Source)
 at org.apache.ojb.odmg.DatabaseImpl.open(Unknown Source)
 at portoonline.services.BaseService.init(BaseService.java:38)
 at portoonline.framework.actions.DoOJB.execute(DoOJB.java:32)
 at
org.apache.struts.action.RequestProcessor.processActionPerform(RequestProcessor.java:484)
 at
org.apache.struts.action.RequestProcessor.process(RequestProcessor.java:274)
 at org.apache.struts.action.ActionServlet.process(ActionServlet.java:1480)
 at org.apache.struts.action.ActionServlet.doGet(ActionServlet.java:506)
 at javax.servlet.http.HttpServlet.service(HttpServlet.java:740)
 at javax.servlet.http.HttpServlet.service(HttpServlet.java:853)
 at
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:247)
 at
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:193)
 at
org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:260)
 at
org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:646)
 at
org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:483)
 at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:995)
 at
org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:191)
 at
org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:646)
 at
org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:471)
 at
org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:644)
 at
org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:483)
 at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:995)
 at
org.apache.catalina.core.StandardContext.invoke(StandardContext.java:2349)
 at
org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:180)
 at
org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:646)
 at
org.apac

RE: ODMG locking

use UPGRADE to ugrade from an existing READ lock to a WRITE-lock.

there is no semantic difference between UPGRADE and WRITE locks.

> -Original Message-
> From: Henrik Berg [mailto:[EMAIL PROTECTED]
> Sent: Friday, June 13, 2003 12:55 PM
> To: [EMAIL PROTECTED]
> Subject: ODMG locking
> 
> 
> When should I use the Transaction.UPGRADE-lock instead of the
> WRITE-lock?  What's the difference between them? 
> -- 
> Henrik
> 
> -
> 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]

ODMG locking

2003-06-13 Thread Henrik Berg

When should I use the Transaction.UPGRADE-lock instead of the
WRITE-lock?  What's the difference between them? 
-- 
Henrik

-
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]

RE: RC3 Test Failures with MySQL


I think the problem is on the ant build.xml ... like someone said (on another reply), 
there should be a filter somewhere...
the problem is: it doesnt exist.
Modifying the @---@ parameters it will work only in your environment... the next time 
someone else install OJB (and use it with MySQL), it has to figure out
what has happened and do it all over again.
Ant should do everything by itself... you should one only have to say what you want 
ant to do (prepare-tutorials, compile,...).

Even though, these errors occur, the schema is written to the database, the data also
and the tutorial works (at least in my case).
I had to change all of the bin scripts because they were missing some ../ on some 
paths ( BUG ) to run the tutorials with:

cd bin
./tutorialX.sh (maybe if you do this, you will see that you can run the tutorials, 
even with the error messages)

The unique message could be because of the MySQL database version... i am using 3.23 
... maybe in 4.XX? or
the mapping isnt correct (it makes sense that all parts of a primary key must be not 
null).
(assuming that the tutorial preparation with MySQL has worked, at least once, without 
giving any error messages)
I used the root mysql account to run the ant command and it still gave me the same 
messages. (no problem with user database permissions)

Pedro Salgado
---
P&G

-Message d'origine-
First modify @DATABASE_DEFAULT@ by a name (objtest) I don't remember
where u modify this :P
When you configure your connection, try to give the login and pass to
the root(if u have not modify Login:root and they have no pass). It
should work better.
If it didnt work better add another user to your database,then grant him
with all create, delete insert, drop for each table. it should work a
few :-)


-Message d'origine-
De : Eric Northam [mailto:[EMAIL PROTECTED]
Envoye : vendredi 6 juin 2003 15:41
A : '[EMAIL PROTECTED]'
Objet : RC3 Test Failures with MySQL


 
I grabbed the source RC3 distro and ran the the unit tests under MySQL
and
received the following errors were printed out:

[torque-create-db] Resolver: used database.dtd from
org.apache.torque.engine.database.transform package
  [sql] Executing file:
C:\jakarta\db-ojb-1.0.rc3.src\target\src\sql\create-db.sql
  [sql] Failed to execute: drop database if exists
@DATABASE_DEFAULT@
  [sql] java.sql.SQLException: Syntax error or access violation,
message from server: "You have an error in your SQ
L syntax near '@DATABASE_DEFAULT@'   at
line 1"
  [sql] Failed to execute: create database @DATABASE_DEFAULT@
  [sql] java.sql.SQLException: Syntax error or access violation,
message from server: "You have an error in your SQ
L syntax near '@DATABASE_DEFAULT@'   at
line 1"
  [sql] 0 of 2 SQL statements executed successfully

...

[torque-insert-sql] Failed to execute: CREATE TABLE REF_REPOSITORY_FK (
REP_ID INTEGER NOT NULL, REF_FK INTEGER, REFA_FK
 INTEGER, REFB_FK INTEGER, NAME VARCHAR (100), PRIMARY
KEY(REP_ID,REF_FK,REFA_FK,REFB_FK) )
[torque-insert-sql] java.sql.SQLException: General error,  message from
server: "All parts of a PRIMARY KEY must be NOT
NULL;  If you need NULL in a key, use UNIQUE instead"

Here's the summary:

junit-no-compile-no-prepare:
[junit] Running org.apache.ojb.broker.AllTests
[junit] Tests run: 209, Failures: 4, Errors: 4, Time elapsed: 95.652
sec
[junit] TEST org.apache.ojb.broker.AllTests FAILED
[junit] Running org.apache.ojb.odmg.AllTests
[junit] [BOOT] INFO: OJB.properties:
file:/C:/jakarta/db-ojb-1.0.rc3.src/target/test/ojb/OJB.properties
[junit] Tests run: 156, Failures: 3, Errors: 1, Time elapsed: 25.426
sec
[junit] TEST org.apache.ojb.odmg.AllTests FAILED
[junit] Running org.apache.ojb.soda.AllTests
[junit] [BOOT] INFO: OJB.properties:
file:/C:/jakarta/db-ojb-1.0.rc3.src/target/test/ojb/OJB.properties
[junit] Tests run: 3, Failures: 0, Errors: 0, Time elapsed: 6.649
sec
[junit] Running org.apache.ojb.otm.AllTests
[junit] Tests run: 1, Failures: 0, Errors: 0, Time elapsed: 7.17 sec

I didn't see anything posted on the todo.html page so I assume they
shouldn't occur.





DISCLAIMER: The information contained in this e-mail is, unless
otherwise
indicated, confidential and is intended solely for the use of the named
addressee. Access, copying or re-use of the e-mail or any information
contained therein by any other person is not authorized. If you are not
the
intended recipient please notify us immediately by returning the e-mail
to
the originator.

-
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]

Oracle

2003-06-13 Thread Alexander Prozor

Hello,
   Could you tell me,
   what version of Oracle ( drivers etc.) should I use with OJB rc3 to
   get all junit tests running?
   I use oracle 9i.

   thank you.
  

-- 
Best regards,
 Alexander  mailto:[EMAIL PROTECTED]


-
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]

RE: Problem with junit testing on Oracle 8.1.7

Just place the drivers jar file in the OJB lib directory.

> -Original Message-
> From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]
> Sent: Friday, June 13, 2003 12:13 AM
> To: OJB Users List
> Subject: Re: Problem with junit testing on Oracle 8.1.7
> 
> 
> It looks like the JVM that is executing the tests can't find 
> my driver 
> class, even though classes12.zip (the Oracle driver library) 
> is on the JVM 
> classpath when it executes.  Is there a specific 
> modification/configuration I need to make to force junit to 
> find my driver 
> class?
> 
> Here is a sample of the errors I am getting in target\test
> 
> thx in advance
> 
> Peter
> 
> 
> 
> Testsuite: org.apache.ojb.broker.AllTests
> Tests run: 209, Failures: 20, Errors: 150, Time elapsed: 60.805 sec
> - Standard Output ---
> [BOOT] INFO: OJB.properties: 
> file:/C:/db-ojb-1.0.rc3/target/test/ojb/OJB.properties
> [org.apache.ojb.broker.accesslayer.ConnectionFactoryPooledImpl] INFO: 
> Create new connection 
> pool:[EMAIL PROTECTED]
>   jcd-alias=default
>   default-connection=true
>   dbms=Oracle
>   jdbc-level=1.0
>   driver=oracle.jdbc.driver.OracleDriver
>   protocol=jdbc
>   sub-protocol=oracle
>   db-alias=oci8:@WBSP.WORLD
>   user=storefront
>   password=*
>   eager-release=false
>   ConnectionPoolDescriptor={whenExhaustedAction=0, maxIdle=-1, 
> maxActive=21, maxWait=5000, removeAbandoned=false, 
> numTestsPerEvictionRun=10, testWhileIdle=false, 
> minEvictableIdleTimeMillis=60, testOnReturn=false, 
> logAbandoned=false, 
> removeAbandonedTimeout=300, timeBetweenEvictionRunsMillis=-1, 
> testOnBorrow=true}
>   batchMode=false
>   useAutoCommit=AUTO_COMMIT_SET_TRUE_AND_TEMPORARY_FALSE
>   ignoreAutoCommitExceptions=false
>  
> sequenceDescriptor=org.apache.ojb.broker.metadata.SequenceDesc
> [EMAIL PROTECTED]
>  sequenceManagerClass=class 
> org.apache.ojb.broker.util.sequence.SequenceManagerHighLowImpl
>  Properties={autoNaming=true, globalSequenceId=false, 
> globalSequenceStart=1, grabSize=20}
> ]
> ]
> [org.apache.ojb.broker.accesslayer.ConnectionFactoryAbstractIm
> pl] ERROR: 
> oracle.jdbc.driver.OracleDriver
> [org.apache.ojb.broker.accesslayer.JdbcAccessImpl] ERROR: 
> PersistenceBrokerException during the execution of 
> materializeObject: Used 
> ConnectionManager instance could not obtain a connection: 
> Could not borrow 
> connection from pool - 
> org.apache.ojb.broker.metadata.JdbcConnectionDescriptor: 
> [EMAIL PROTECTED]
>   jcd-alias=default
>   default-connection=true
>   dbms=Oracle
>   jdbc-level=1.0
>   driver=oracle.jdbc.driver.OracleDriver
>   protocol=jdbc
>   sub-protocol=oracle
>   db-alias=oci8:@WBSP.WORLD
>   user=storefront
>   password=*
>   eager-release=false
>   ConnectionPoolDescriptor={whenExhaustedAction=0, maxIdle=-1, 
> maxActive=21, maxWait=5000, removeAbandoned=false, 
> numTestsPerEvictionRun=10, testWhileIdle=false, 
> minEvictableIdleTimeMillis=60, testOnReturn=false, 
> logAbandoned=false, 
> removeAbandonedTimeout=300, timeBetweenEvictionRunsMillis=-1, 
> testOnBorrow=true}
>   batchMode=false
>   useAutoCommit=AUTO_COMMIT_SET_TRUE_AND_TEMPORARY_FALSE
>   ignoreAutoCommitExceptions=false
>  
> sequenceDescriptor=org.apache.ojb.broker.metadata.SequenceDesc
> [EMAIL PROTECTED]
>  sequenceManagerClass=class 
> org.apache.ojb.broker.util.sequence.SequenceManagerHighLowImpl
>  Properties={autoNaming=true, globalSequenceId=false, 
> globalSequenceStart=1, grabSize=20}
> ]
> ]: A class was not found: oracle.jdbc.driver.OracleDriver
> Used ConnectionManager instance could not obtain a 
> connection: Could not 
> borrow connection from pool - 
> org.apache.ojb.broker.metadata.JdbcConnectionDescriptor: 
> [EMAIL PROTECTED]
>   jcd-alias=default
>   default-connection=true
>   dbms=Oracle
>   jdbc-level=1.0
>   driver=oracle.jdbc.driver.OracleDriver
>   protocol=jdbc
>   sub-protocol=oracle
>   db-alias=oci8:@WBSP.WORLD
>   user=storefront
>   password=*
>   eager-release=false
>   ConnectionPoolDescriptor={whenExhaustedAction=0, maxIdle=-1, 
> maxActive=21, maxWait=5000, removeAbandoned=false, 
> numTestsPerEvictionRun=10, testWhileIdle=false, 
> minEvictableIdleTimeMillis=60, testOnReturn=false, 
> logAbandoned=false, 
> removeAbandonedTimeout=300, timeBetweenEvictionRunsMillis=-1, 
> testOnBorrow=true}
>   batchMode=false
>   useAutoCommit=AUTO_COMMIT_SET_TRUE_AND_TEMPORARY_FALSE
>   ignoreAutoCommitExceptions=false
>  
> sequenceDescriptor=org.apache.ojb.broker.metadata.SequenceDesc
> [EMAIL PROTECTED]
>  sequenceManagerClass=class 
> org.apache.ojb.broker.util.sequence.SequenceManagerHighLowImpl
>  Properties={autoNaming=true, globalSequenceId=false, 
> globalSequenceStart=1, grabSize=20}
> ]
> ]: A class was not found: oracle.jdbc.driver.OracleDriver
> [org.apache.ojb.broker.accesslayer.ConnectionFactoryAbstractIm
> pl] ERROR: 
> oracle.jdbc.driver.OracleDriver
> [org.apache.ojb.broker.accesslayer.JdbcAccess

RE: Deleting Large Quantities

No thats not supported by ODMG / OQL (not an OJB problem !)

> -Original Message-
> From: Mauricio CASTRO [mailto:[EMAIL PROTECTED]
> Sent: Friday, June 13, 2003 2:04 AM
> To: OJB Users List
> Subject: Re: Deleting Large Quantities
> 
> 
> Hi all,
> 
> Does OJB supports update/delete objects via Object Query Language?
> 
> Mauricio Castro.
> 
> - Original Message - 
> From: "Eric Northam" <[EMAIL PROTECTED]>
> Subject: Deleting Large Quantities
> 
> 
> > I was wondering if this is the appropriate way to delete a 
> large number of
> > objects with ODMG:
> >
> > (taken from OQLOrOnForeignKeyTest)
> >
> > OQLQuery query = odmg.newOQLQuery();
> >   query.create("select person from " + PersonImpl.class.getName());
> >   List persons = (List) query.execute();
> >   Iterator it = persons.iterator();
> >   while (it.hasNext())
> >   {
> >db.deletePersistent(it.next());
> >   }
> >   tx.commit();
> >
> > Won't this load each object completely into memory?
> >
> > Eric
> 
> -
> 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: Deleting Large Quantities

Hi Eric,

Yes, that's the ODMG way of doing it.
And yes, it will load all objects into memory.
ODMG (and JDO as well !) was not designed with relational databases in mind.
So many things that are highly efficient with SQL are not available with
ODMG (JDO).

I usually recommed to bypass the ODMG (or JDO) layer in such cases and
directly use the PersistenceBroker API which allows to process
deleteByQuery(..) efficiently.

cheers,
Thomas

> -Original Message-
> From: Eric Northam [mailto:[EMAIL PROTECTED]
> Sent: Friday, June 13, 2003 1:11 AM
> To: '[EMAIL PROTECTED]'
> Subject: Deleting Large Quantities
> 
> 
> I was wondering if this is the appropriate way to delete a 
> large number of
> objects with ODMG:
>  
> (taken from OQLOrOnForeignKeyTest) 
>  
> OQLQuery query = odmg.newOQLQuery();
>   query.create("select person from " + PersonImpl.class.getName());
>   List persons = (List) query.execute();
>   Iterator it = persons.iterator();
>   while (it.hasNext())
>   {
>db.deletePersistent(it.next());
>   }
>   tx.commit();
>  
> Won't this load each object completely into memory?
>  
> Eric
> 
> 
> 
> 
> 
> DISCLAIMER: The information contained in this e-mail is, 
> unless otherwise
> indicated, confidential and is intended solely for the use of 
> the named
> addressee. Access, copying or re-use of the e-mail or any information
> contained therein by any other person is not authorized. If 
> you are not the
> intended recipient please notify us immediately by returning 
> the e-mail to
> the originator.
> 


-
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]

RE: MetadataException