Re: Interfaces and xdoclet

2007-06-27 Thread [EMAIL PROTECTED]
Hi Tom,
thank you very much, now it works!
Best regards,
Marco


Hi Marco,

On 6/20/07, [EMAIL PROTECTED] <[EMAIL PROTECTED]> wrote:

> I am developing a project using OJB with the xdoclet module as
> persistance layer.
> In my project I need to use interfaces, but I have a problem in the
> xdoclet annotation of the interfaces.
> For example, if I write:
>
> /**
>  * Interface describing a resource
>  *
>  * @ojb.class
>  *
>  *
>  * @ojb.field name="description"
>  *  jdbc-type="VARCHAR"
>  *  length="300"
>  *
>  */
>
> public interface Resource..
>
>
> The field "description" is marked as anonymous and inherited as
> anonymous by all subclasses.
> Reading the OJB guide (section "Using interfaces with OJB") the
> interface fields are not anonymous.
> Where am I wrong?

If you put the ojb.field tag into the interface Javadoc, then they'll
be anonymous. If you want non-anonymous ones, then you need to create
declarations for the getters/setters for these fields in the interface
and tag them with ojb.field accordingly, if you want OJB to be able to
use them via the interface.

Tom




___
Naviga e telefona senza limiti con Tiscali 
Scopri le promozioni Tiscali Adsl: navighi e telefoni senza canone Telecom

http://abbonati.tiscali.it/adsl/


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



Interfaces and xdoclet

2007-06-20 Thread [EMAIL PROTECTED]
Hi list,
I am developing a project using OJB with the xdoclet module as 
persistance layer.
In my project I need to use interfaces, but I have a problem in the 
xdoclet annotation of the interfaces.
For example, if I write:

/**
 * Interface describing a resource 
 * 
 * @ojb.class
 * 
 *
 * @ojb.field name="description"
 *  jdbc-type="VARCHAR"
 *  length="300"
 *
 */

public interface Resource..


The field "description" is marked as anonymous and inherited as 
anonymous by all subclasses.
Reading the OJB guide (section "Using interfaces with OJB") the 
interface fields are not anonymous.
Where am I wrong?
Thank you in advance for your attention and best regards,
Marco




_
Naviga e telefona senza limiti con Tiscali 
Scopri le promozioni Tiscali Adsl: navighi e telefoni senza canone Telecom

http://abbonati.tiscali.it/adsl/


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



performance question

2007-03-23 Thread [EMAIL PROTECTED]
hi there,

assuming we need multiple lists of objects from the db.

which of the following solutions do perform better?

1)
1 db call using the ojb collection descriptor with retrieve = true
(multiple joins)
i heard about performance issues with too many joins ...

2)
multiple db calls in 1 transaction retrieving each of the lists
separately with broker.getCollectionByQuery calls

with best regards,
Björn




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



Re: inner join n:1 how to

2006-04-27 Thread [EMAIL PROTECTED]

Normally , if i use QueryByCriteria q =
QueryFactory.newQuery(ProductImpl.class, criteria); and criteria contained
some ProductGroup conditions ; and then i will retrieve all data of
ProductImpl that product table outter join with ProductGroup table . May be
in this case i HAVE to use ReportQuery ?

Thank in advanced ,
Regards 
--
View this message in context: 
http://www.nabble.com/inner-join-n%3A1-how-to-t1509312.html#a4133579
Sent from the Apache DB - ObjectRelationalBridge Users forum at Nabble.com.


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



inner join n:1 how to

2006-04-25 Thread [EMAIL PROTECTED]

I have two classes Product(table=product) and
ProductGroup(table=productgroup) ; these two tables are n:1 relationship
means 1 row on productgroup may has more than 1 rows on 'produc' table  .
I want to query to get all fields of product table and 2 field of
productgroup table with some conditions for example
select product.id , product.name, product.price , product.productgroupid ,
productgroup.name, productgroup.logo from product a inner join productgroup
b on a.productgroupid = b.id .
How can i do this with ojb 

thank in advanced ,
Regards 


--
View this message in context: 
http://www.nabble.com/inner-join-n%3A1-how-to-t1509312.html#a4094471
Sent from the Apache DB - ObjectRelationalBridge Users forum at Nabble.com.


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



Re: ojb start ?

2006-04-19 Thread [EMAIL PROTECTED]

Thank you so much !
You have analysised correctly . I will chose ojb . 

Regards
--
View this message in context: 
http://www.nabble.com/ojb-start--t1467235.html#a3984208
Sent from the Apache DB - ObjectRelationalBridge Users forum at Nabble.com.


ojb start ?

2006-04-18 Thread [EMAIL PROTECTED]

Hi ,
I am begining to study o/r mapping as database layer for j2ee application ;
so i decide to select between hibernate and ojb . Would you like to give me
some information to make my decision 

thank in advanced,
Regards ,

--
View this message in context: 
http://www.nabble.com/ojb-start--t1467235.html#a3965408
Sent from the Apache DB - ObjectRelationalBridge Users forum at Nabble.com.


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



RE: How to markup for xdoclet inheritance structure?

2004-11-16 Thread [EMAIL PROTECTED]
I haven't successfully used xdoclet, but if it is like javadoc, you need to
start the comments with double asterisk: /** not just /*.

my 2 cents
CQ

Original Message:
-
From: Gelhar, Wallace Joseph [EMAIL PROTECTED]
Date: Tue, 16 Nov 2004 10:56:09 -0600
To: [EMAIL PROTECTED]
Subject: RE: How to markup for xdoclet inheritance structure?


Actually this is the logger output as well.  Where do I start to debug
this?  

repository-files:
java.util.logging.ErrorManager: 2
java.lang.NullPointerException
at org.apache.tools.ant.Project.getThreadTask(Project.java:1985)
at org.apache.tools.ant.Project.demuxOutput(Project.java:1086)
at
org.apache.tools.ant.DemuxOutputStream.processBuffer(DemuxOutputStream.j
ava:172)
at
org.apache.tools.ant.DemuxOutputStream.write(DemuxOutputStream.java:147)
at
org.apache.tools.ant.DemuxOutputStream.write(DemuxOutputStream.java:241)
at java.io.PrintStream.write(PrintStream.java:258)
at
sun.nio.cs.StreamEncoder$CharsetSE.writeBytes(StreamEncoder.java:336)
at
sun.nio.cs.StreamEncoder$CharsetSE.implFlushBuffer(StreamEncoder.java:40
4)
at
sun.nio.cs.StreamEncoder$CharsetSE.implFlush(StreamEncoder.java:408)
at sun.nio.cs.StreamEncoder.flush(StreamEncoder.java:152)
at java.io.OutputStreamWriter.flush(OutputStreamWriter.java:213)
at java.util.logging.StreamHandler.flush(StreamHandler.java:224)
at
java.util.logging.ConsoleHandler.publish(ConsoleHandler.java:88)
at java.util.logging.Logger.log(Logger.java:424)
at java.util.logging.Logger.doLog(Logger.java:446)
at java.util.logging.Logger.logp(Logger.java:562)
at
org.apache.commons.logging.impl.Jdk14Logger.log(Jdk14Logger.java:91)
at
org.apache.commons.logging.impl.Jdk14Logger.info(Jdk14Logger.java:162)
at xdoclet.XDocletMain.start(XDocletMain.java:47)
at xdoclet.DocletTask.start(DocletTask.java:462)
at xjavadoc.ant.XJavadocTask.execute(XJavadocTask.java:110)
at
org.apache.tools.ant.UnknownElement.execute(UnknownElement.java:269)
at org.apache.tools.ant.Task.perform(Task.java:364)
at org.apache.tools.ant.Target.execute(Target.java:301)
at org.apache.tools.ant.Target.performTasks(Target.java:328)
at org.apache.tools.ant.Project.executeTarget(Project.java:1215)
at
org.apache.tools.ant.Project.executeTargets(Project.java:1063)
at
org.apache.tools.ant.module.bridge.impl.BridgeImpl.run(BridgeImpl.java:1
78)
at
org.apache.tools.ant.module.run.TargetExecutor.run(TargetExecutor.java:2
52)
at
org.netbeans.core.execution.RunClassThread.run(RunClassThread.java:125)
Generating ojb repository descriptor (repository_user.xml)
Type uwec.fpm.persistence.report.Report
Type uwec.fpm.persistence.report.ReportParameterValueImpl
Type uwec.fpm.persistence.report.ReportParameterValue
Type uwec.fpm.persistence.report.ReportField
Type uwec.fpm.persistence.report.ReportParameterImpl
Type uwec.fpm.persistence.PersistentObjectImpl
Type uwec.fpm.persistence.report.ReportFieldType
Type uwec.fpm.persistence.report.ReportParameter
Type uwec.fpm.persistence.PersistentObject
Processed 9 types
Warning: The class uwec.fpm.persistence.PersistentObject has no primary
key
Warning: The class uwec.fpm.persistence.PersistentObjectImpl has no
primary key
Warning: The class uwec.fpm.persistence.report.ReportParameterImpl has
no primary key
Warning: The class uwec.fpm.persistence.report.ReportParameterValue has
no primary key
Warning: The class uwec.fpm.persistence.report.ReportParameterValueImpl
has no primary key
Processed 9 types
 

-Original Message-
From: Gelhar, Wallace Joseph 
Sent: Tuesday, November 16, 2004 10:24 AM
To: OJB Users List

Subject: RE: How to markup for xdoclet inheritance structure?

What is wrong with this markup.  I've followed your advice and allowed
xdoclet to generate a table for the persistent base class (even though
the fields are in each concrete classes table), but this fails to
produce *any* fields in the repository.  Do I really have to duplicate
each @ojb.field tag FIVE times for each property?
 
BTW, I am using xdoclet-1.2.1, xdoclet-ojb-module-1.2.1, and
xjavadoc-1.0.3 from CVS.

Any other suggestions?

/**
 * @ojb.class
 */
public interface PersistentObject {

/*
 * @ojb.field column="ID"
 *jdbc-type="INTEGER"
 *primarykey="true"
 */
public Integer getId();
/*
 * @ojb.field column="ID"
 *jdbc-type="INTEGER"
 *primarykey="true"
 */
public void setId(Integer id);
...
}

/**
 * @ojb.class
 */
public abstract class PersistentObjectImpl implements PersistentObject {

/*
 * @ojb.field column="ID"
 *jdbc-type="INTEGER"
 *prima

RE: [SUGGESTION] - S01 - Website.MainPage & QuickStarts

2004-11-16 Thread [EMAIL PROTECTED]
Thanks for proposing this!
I have been lurking here for quite a while and now I am actually writing my
web app.  I seem to get stuck on creating the repository.  I go to look at
the test source and can't find it, I run the junit tests and it takes 2
hours to finally use all the memory on my computer and give up, ...

OJBC has been a help to ease into this.

I like the idea of working only in my java class and being able to create
sql for creating my backend and the repository file (and documentation)
from the one source.

It is pretty easy to find out how to include @ojb tags, but not so clear
how to get my sql and repository from there.

I have given a few small suggestions inline below.

clq

Original Message:
-
From: Ilias Lazaridis [EMAIL PROTECTED]
Date: Mon, 15 Nov 2004 20:18:08 +0200
To: [EMAIL PROTECTED]
Subject: [SUGGESTION] - S01 - Website.MainPage & QuickStarts


[please, if you like to comment on this, write inline within the contex]

-

The below document is a draft-version proposal for the main-page of the 
OJB website.

It focuses on two points:
   - getting visitors to try it!
   - pointing out OJB's major top-level strenghts!

The suggested quick-starts would allow:
   - newcomers : to use OJB to quickly explore real JAVA OOAD
 in conjunction with IDE's like NetBeans.
   - evaluators: to check OJB quickly without [** affection 
 of   do you mean affecting? **] the running developement
system

I can create those quick-start-projects. Assistance from OJB-team 
needed: mostly a few answers to questions which I raise during the 
creation process [within the user list].

The main goal is to make the tutorials modular (stepwise increase of 
complexity), transparent (newcomer-safe, e.g. no domain-knowledge 
necessary) and efficient (quick introduction).

-

[A question: is it possible to retrieve older versions of the OJB 
website, e.g. to track changes?]

-

OJB
ObJectRelationalBridge - Scalable Transparent Persistence for Java Objects

OJB is easy:
   - Don't read documentations - start with trying it:

   - The OJB team cares about your time

 - 5 min: download 
   - self-contained: everything needed within one folder
 - no affection on current development system
   - evaluate OJB without risk
   - run the samples and explore its sources
 - netbeans 4.0 project included
 - eclipse 3.0 project included

 - 10min: create your first real application
   - define a java class
   - declare it as persistent
   - build *everything*, including database, with a single command
 - within your IDE
 - or from the command line
   - run your first application
 - create, retrieve, update, erase objects

 - 20min: extend your first app with relations (1:1, n:1, 1:n, m:n)
   - explore real OOAD with JAVA & OJB
   - stepwise define 4 more java classes
   - attach them to the first class
   - explore incremental design capabilities of OJB
 - watch OJB's schema update mechanisms do the work for you

 - 10min: migrate you first app to another database (MySQL)
   - watch OJB's schema migration mechanisms work for you

OJB is pure:
   - pure java
   - enables pure OOAD

OJB is scalable:
   - use it within[g] embedded applications
   - up to enterprise scale distributed applications

OJB is powerfull:
   - fine-tune your application, with high detail grade of control
   - field proven Cache & distributed systems

OJB is flexible in RDBMS
   - HSQL (already bundled), MySQL, ...

OJB is flexible in API's [does not bind you to proprietary technology]:
- full ODMG 3.0 compliant API
   - later migration to ODMG driven OODBMS systems is possible
- full ODMG 3.0 standard OQL (Object Query Language)
   - later migration to major OODBMS systems, without change of OQL code
   - ODMG available for other OO languages, too (e.g. C++)
 - allows design of highly speed-critical code with C++/ASM bridge
   - [disclosure: ]
- full JDO 1.0 compliant API
   - later migration to JDO (RDBMS/OODBMS) systems is possible
   - based on JDO Reference Implementation
 - highest compatibility
   - [disclosure: performancy penalty of ~XX%, see performance notes]
   - native implementations sheduled for OJB 2.0
- an OTM [** spell it out, please.  I already have trouble with ODMG and
JDO, what is OTM? **] API (ODMG / JDO common functionality)
   - if you are still undecided which one to use
- a low-level OJB API (PersistenceBroker)
   - all other api's are based on this
   - allows definition of your in-house API's
 - e.g. when creating specific Frameworks.

.
[how about some thoughts on using with struts?
 Seems my comments are fewer and farther between than I thought.  I want to
help make this useful and popular project. I hope this made sense.]

-- 
http://lazaridis.com


---

PlatformOracleImpl too restrictive

2004-05-19 Thread [EMAIL PROTECTED]
Hi,
we are using Oracle 8.1.7 with thin drivers. We found that for sql types 
VARBINARY, LONGVARBINARY and BLOB PlatformOracleImpl doesn't want to 
handle byte arrays with length more than 2000 bytes. We've heard about 
all the problems with Oracle thin drivers and handling large data sets.

Here I want to describe solution that works for us.
We have persistent class with the following attribute:
--
/**
 * @ojb.field jdbc-type="LONGVARBINARY"
 */
private byte[] contents;
--
JDBC type LONGVARBINARY maps to Oracle LONG RAW column type.
To experiment a little we have changed PlatformOracleImpl to ignore 
LONGVARBINARY type completely in the first if-statement of method 
setObjectForStatement. After compiling this change we've got it working. 
Byte arrays of any size are now saved to declared column with no problem.

May be this little change could be included in CVS? What do developers 
think?

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


Re: null FK handling in QueryReferenceBroker is BROKEN?

2004-05-13 Thread [EMAIL PROTECTED]
Armin, Andrews thank you! :-)

Andrew Shevel

Armin Waibel wrote:

Hi Andrew,

this sounds similar to a problem posted by Andrew Clute

http://nagoya.apache.org/eyebrowse/[EMAIL PROTECTED]&msgNo=12802 

Seems this bug was "Andrew specific" ;-)

Checked in  a fix in CVS.
Sorry for the hassle!
regards
Armin
[EMAIL PROTECTED] wrote:

Hi, all.

We've discovered the following strange issue:

if method QueryReferenceBroker.getReferencedObjectIdentity(obj, 
ObjectReferenceDescriptor, ClassDescriptor) is called with obj = null 
then non null Identity object is returned. In this Identity object 
array m_pkValues has 1 element with value null.
Such Identity object drives crazy every other component. We can see 
funny debug messages in our logs:

CORE3282: stdout: [org.apache.ojb.broker.core.PersistenceBrokerImpl] 
DEBUG: getObjectByIdentity 
ru.lma.seals.SealsManagementService.po.Seal{null}

Of course this ends with throwing NullPointerException in our case 
somewhere in ConcreteEditiongContext.

Armin, what do you think?

Andrew Shevel

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


null FK handling in QueryReferenceBroker is BROKEN?

2004-05-13 Thread [EMAIL PROTECTED]
Hi, all.

We've discovered the following strange issue:

if method QueryReferenceBroker.getReferencedObjectIdentity(obj, 
ObjectReferenceDescriptor, ClassDescriptor) is called with obj = null 
then non null Identity object is returned. In this Identity object array 
m_pkValues has 1 element with value null.
Such Identity object drives crazy every other component. We can see 
funny debug messages in our logs:

CORE3282: stdout: [org.apache.ojb.broker.core.PersistenceBrokerImpl] 
DEBUG: getObjectByIdentity ru.lma.seals.SealsManagementService.po.Seal{null}

Of course this ends with throwing NullPointerException in our case 
somewhere in ConcreteEditiongContext.

Armin, what do you think?

Andrew Shevel

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


Optimistic locking applied to collection changes

2004-05-07 Thread [EMAIL PROTECTED]
Greetings, everyone!

While using OTM we've found the following issue:

we have object type Doc and a collection Doc.relatedDocs with elements 
of type Doc (M-to-N association with indirection table).

Two threads load the same object D of type Doc into their contexts.

The first thread successfully adds instance D1 to D.relatedDocs. We see 
appropriate changes in DB after committing a transaction.

After that having old version of D in it's context second thread tries 
to add another instance D2 to D.relatedDocs. Transaction succefully 
commits and we see that link between D and D1 in indirection table has 
gone (method PersistentBrokerImpl.storeAndLinkMtoN deletes all entries 
in indirection table which are not part of referenced objects), and link 
between D and D2 is present. That is we have just overwritten new data 
with old data.

It seems that this situation should be treated just like a normal 
optimistic locking and second thread shouldn't succeed.

Could someone please clarify this issue? Thanks in advance.

Andrew Shevel

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


mapping classes on multiple joined tables

2004-04-03 Thread [EMAIL PROTECTED]
Hello,

I'm trying to map classes on multiple joined tables as described in OJB tutorial.
This is my situation: I have a class A that extends a class B that in turn extends a 
class C that extends a fourth class D. In the classes A, B and C there is an attribute 
referring to the super class's primary key. The referene descriptor look like:





my application correctly saves the data on the database, but when querying for read, I 
get a NullPointerException. I don't understand why Any help would be very 
appreciated.

Best regards,
Ilaria.


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



Re:unable to connect to hsqldb

2004-03-29 Thread [EMAIL PROTECTED]
hi, i can't connect to hsqldb.

I'm using hsqldb 1.7.1 and ojb 1.0.

My db is Almayer, this is my :



 and this is the error (from tomcat's log):

at 
org.apache.ojb.broker.accesslayer.ConnectionFactoryPooledImpl.getConnectionFromPool(Unknown
 Source)
at 
org.apache.ojb.broker.accesslayer.ConnectionFactoryAbstractImpl.lookupConnection(Unknown
 Source)
at org.apache.ojb.broker.accesslayer.ConnectionManagerImpl.getConnection(Unknown 
Source)
... 50 more
Caused by: org.apache.ojb.broker.accesslayer.LookupException: Error getting Connection 
from DriverManager with url (jdbc:hsqldb:hsql://localhost/almayer) and driver 
(org.hsqldb.jdbcDriver)
at 
org.apache.ojb.broker.accesslayer.ConnectionFactoryAbstractImpl.newConnectionFromDriverManager(Unknown
 Source)
at 
org.apache.ojb.broker.accesslayer.ConnectionFactoryPooledImpl$ConPoolFactory.makeObject(Unknown
 Source)
at 
org.apache.commons.pool.impl.GenericObjectPool.borrowObject(GenericObjectPool.java:816)
... 53 more
Caused by: java.sql.SQLException: Connection is broken: localhost/almayer
at org.hsqldb.Trace.getError(Unknown Source)
at org.hsqldb.Trace.error(Unknown Source)
at org.hsqldb.jdbcConnection.reconnectHSQL(Unknown Source)
at org.hsqldb.jdbcConnection.openHSQL(Unknown Source)
at org.hsqldb.jdbcConnection.(Unknown Source)
at org.hsqldb.jdbcDriver.connect(Unknown Source)
at java.sql.DriverManager.getConnection(DriverManager.java:512)
at java.sql.DriverManager.getConnection(DriverManager.java:171)
... 56 more

That's all. Can somebody help me?
Thanks in advance
Gianluca



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



Re:unable to connect to hsqldb

2004-03-29 Thread [EMAIL PROTECTED]
hi, i can't connect to hsqldb, please save my family!

I'm using hsqldb 1.7.1 and ojb 1.0.

My db is Almayer, this is my :



 and this is the error (from tomcat's log):

at 
org.apache.ojb.broker.accesslayer.ConnectionFactoryPooledImpl.getConnectionFromPool(Unknown
 Source)
at 
org.apache.ojb.broker.accesslayer.ConnectionFactoryAbstractImpl.lookupConnection(Unknown
 Source)
at org.apache.ojb.broker.accesslayer.ConnectionManagerImpl.getConnection(Unknown 
Source)
... 50 more
Caused by: org.apache.ojb.broker.accesslayer.LookupException: Error getting Connection 
from DriverManager with url (jdbc:hsqldb:hsql://localhost/almayer) and driver 
(org.hsqldb.jdbcDriver)
at 
org.apache.ojb.broker.accesslayer.ConnectionFactoryAbstractImpl.newConnectionFromDriverManager(Unknown
 Source)
at 
org.apache.ojb.broker.accesslayer.ConnectionFactoryPooledImpl$ConPoolFactory.makeObject(Unknown
 Source)
at 
org.apache.commons.pool.impl.GenericObjectPool.borrowObject(GenericObjectPool.java:816)
... 53 more
Caused by: java.sql.SQLException: Connection is broken: localhost/almayer
at org.hsqldb.Trace.getError(Unknown Source)
at org.hsqldb.Trace.error(Unknown Source)
at org.hsqldb.jdbcConnection.reconnectHSQL(Unknown Source)
at org.hsqldb.jdbcConnection.openHSQL(Unknown Source)
at org.hsqldb.jdbcConnection.(Unknown Source)
at org.hsqldb.jdbcDriver.connect(Unknown Source)
at java.sql.DriverManager.getConnection(DriverManager.java:512)
at java.sql.DriverManager.getConnection(DriverManager.java:171)
... 56 more

That's all. Can somebody help me?
Thanks in advance
Gianluca



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



Re: Inner Join and Informix

2004-03-15 Thread [EMAIL PROTECTED]
So, OJB don't support Informix ?
Is there any way that OJB builds SQL that Informix support ? 
Are there somebody that is working with Informix and OJB ?

thanks.

- Mensaje Original -
De: Jakob Braeuchi <[EMAIL PROTECTED]>
Fecha: Miercoles, Marzo 10, 2004 7:29 pm
Asunto: Re: Inner Join and Informix

> hi ?
> 
> looks like informix does not like the sql92 syntax for joining.
> 
> btw. p6spy is better suited to log the sqls.
> 
> jakob
> 
> 
> [EMAIL PROTECTED] wrote:
> 
> > Hi,
> > I'm building an application with Informix 7.25 and RedHat 9.0
> > I have 2 tables : ventas and articulos, and I need make a 
> ReportQuery 
> > that execute a similar SQL to "select sum(ventas) from ventas 
> inner 
> > join articulos on ventas.idarticulo = articulos.id group by 
> > ventas.idarticulo".
> > 
> > I see in the log4j that the SQL is correct, but Informix fire a 
> "Syntax 
> > Error" Exception. The correct syntax for Informix is similar to 
> "select 
> > sum(ventas) from ventas, articulos where ventas.idarticulo = 
> > articulos.id"
> > 
> > 
> > Any idea ?
> > 
> > Thanks.
> > 
> > 
> > 
> > 
> > -
> ----
> > 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]



Inner Join and Informix

2004-03-10 Thread [EMAIL PROTECTED]
Hi,
I'm building an application with Informix 7.25 and RedHat 9.0
I have 2 tables : ventas and articulos, and I need make a ReportQuery 
that execute a similar SQL to "select sum(ventas) from ventas inner 
join articulos on ventas.idarticulo = articulos.id group by 
ventas.idarticulo".

I see in the log4j that the SQL is correct, but Informix fire a "Syntax 
Error" Exception. The correct syntax for Informix is similar to "select 
sum(ventas) from ventas, articulos where ventas.idarticulo = 
articulos.id"


Any idea ?

Thanks.




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



Re: Current OTM and JCA Adapter usability

2003-08-26 Thread [EMAIL PROTECTED]
Matthew,

I'll try to describe my thoughts about distributed transaction support 
in OJB adapter. Tell me what do you think.

Consider this architecture: OJB adapter doesn't use it's internal jdbc 
stuff but instead uses JDBC resource declared in EJB container. If 
declared resource implements XAResource then OJB adapter could easily 
implement this interface by invoking XAResource implementation provided 
by JDBC driver. This architecture assumes one to one relationship 
between OJB adapter and JDBC resource instances. This architecture also 
gives possibility for OJB to rely on EJB container specific connection 
pooling.

Seems to be too simple, doesn't it? Do you think XAResource 
implementation inside OJB adapter needs to be smarter? Can OJB adapter 
make a decision it is not ready to commit (during 2-phase commit) based 
on it's internal state exclusively in some cases?

Andrew Shevel



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


Current OTM and JCA Adapter usability

2003-08-18 Thread [EMAIL PROTECTED]
Greetings to everyone.

Is it possible to rely on current JCA adapter and OTM implementations in 
  commercial projects? We've done some research and it seems that 
transaction stuff inside JCA adapter is unusable.
Can someone acknowledge it or provide any comments on this issue?
Thanks in advance.

Andrew Shevel
[EMAIL PROTECTED]


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


Need Direction or Instruction

2003-06-26 Thread [EMAIL PROTECTED]
Can anyone show me how to deploy db-ojb-1.0.rc3.tgz on windows tomcat4.1.4?
I was using the previous version and didn't notice this latest version.

Thanks in advance.

Wai Kit.


mail2web - Check your email from the web at
http://mail2web.com/ .



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



Re: DMapImpl

2003-06-12 Thread [EMAIL PROTECTED]
Sorry, it's the key of the map which can't be a java type.
So what is the solution ? I can't find nothing about DMapImpl in the tutorial.


Selon "[EMAIL PROTECTED]" <[EMAIL PROTECTED]>:

> Hello,
> 
> I'm trying to use the DMapImpl class to store java Map objects, but this
> exception is thrown :
> 
> org.apache.ojb.broker.metadata.ClassNotPersistenceCapableException: Could
> not
> init Identity for given object class java.lang.String: java.lang.String not
> found in OJB Repository
> 
> Does this mean I can't store String objects as Map values ? Must I extend
> the
> String class to add an identifier ? Isn't there any other solution ?
> 
> Regards,
> Cedric
> 
> -- 
> 
> ---------
> 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]



DMapImpl

2003-06-12 Thread [EMAIL PROTECTED]
Hello,

I'm trying to use the DMapImpl class to store java Map objects, but this
exception is thrown :

org.apache.ojb.broker.metadata.ClassNotPersistenceCapableException: Could not
init Identity for given object class java.lang.String: java.lang.String not
found in OJB Repository

Does this mean I can't store String objects as Map values ? Must I extend the
String class to add an identifier ? Isn't there any other solution ?

Regards,
Cedric

-- 

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



storing maps

2003-06-10 Thread [EMAIL PROTECTED]
Hello,

How can I proceed to store java Map objects ?

Thanks

-- 

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



map mapping

2003-06-05 Thread [EMAIL PROTECTED]
Hello,

I have a class with a map type attribute. I've try to store it using object to
byte array conversion but it seems to not work.
There are no errors during the storage, but when I list rows from the table, the
corresponding column is empty whereas when debugging the converter it returns a
byte array.

What the problem ?

This is the java declaration :
Map dataType = new HashMap();

This is the reposity part :

conversion="org.apache.ojb.broker.accesslayer.conversions.Object2ByteArrFieldConversion"
/>

-- 

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



Re: AutoBuildDB

2003-04-02 Thread [EMAIL PROTECTED]
So, where can I find a good tutorial explaining how to use torque in order to
create my database from the repository.xml

Selon Geoff Gerrietts <[EMAIL PROTECTED]>:

> Quoting Mahler Thomas ([EMAIL PROTECTED]):
> > AutobuildDB was an undocumented, experimental feature.
> > We decided to remove it as it did not use Torque and did not support
> > all db platforms that OJB is meant to work with.
> 
> Ug. It was "documented" in that the tutorials suggested experimenting
> with it. Consequently, that's how I implemented my
> forward-engineering build targets.
> 
> Torque is the recommended solution, then? Guess I need to go learn
> Torque
> 
> --G.
> 
> -- 
> Geoff Gerrietts"Democracy is a form of government that
> substitutes 
> geoff at gerrietts dot net  election by the incompetant many for appointment
> 
> http://www.gerrietts.net/   by the corrupt few." --George Bernard Shaw
> 
> ---------
> 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]



AutoBuildDB

2003-04-01 Thread [EMAIL PROTECTED]
Hello,

Why has been removed the forward-db task from the rc2 release ?
I can't find the AutoBuildDB class in jar files.

-- 

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



jaxb

2003-03-27 Thread [EMAIL PROTECTED]
Hi,

I generated classes using sun jaxb mapping.

I would like to know which is the easiest way to map these classes with ojb in
order to store them in database.

Thanks
Cédric Grun

-- 

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