How can I make OJB to create a "select" on a select statement, not on a table?

Hi, I'm using "ReportQueryByCriteria" of the PB API in OJB 1.0.3. What I'm trying to do is to create a statement like this: SELECT columnA, columnB, columnC FROM ( select ... from tableName where ...) OJB always creates a statement like this: SELECT A0.columnA, A0.columnB, A0.columnC FROM tableN

How to hide database user and password

I'm using PB version 1.0.3. Database user and password are in repository_database.xml. How can one hide usr + pwd? I'd prefer to have placeholders there and set both in source code. Thanks...Frank

RE: Is not allowed to use "0" in an INTEGER filed that is part of a primary key?

if you are using a primitive 'int' in your java class, int 0 is considered as NULL and interpreted as 'undefined' primary key which will cause an insert instead of an update. you can use a (java.lang.)Integer in your class. hopefully this helps you further danilo Hiller,

RE: Is not allowed to use "0" in an INTEGER filed that is part of a primary key?

key which will cause an insert instead of an update. you can use a (java.lang.)Integer in your class. hopefully this helps you further danilo Hiller, Frank RD-PT31 wrote: > Hi all, > > I'm using OJB 1.0.3. > I defined a primary key in respository descriptor consisting o

Is not allowed to use "0" in an INTEGER filed that is part of a primary key?

Hi all, I'm using OJB 1.0.3. I defined a primary key in respository descriptor consisting of three fields. Two fields are "VARCHAR", one is "INTEGER". When I try to insert multiple objects with identical values in the VARCHAR fields and a value of "0" in the INTEGER field, then multiple records a

Does "Calendar2TimestampFieldConversion" always return a GregorianCalendar with TimeZone "GMT"?

Hi, short question: Does "org.apache.ojb.broker.accesslayer.conversions.Calendar2TimestampFieldCo nversion" always return a GregorianCalendar with TimeZone "GMT"? Thank you..Frank Confidentiality note: The information in this email and any attachment may contain confidential and pr

RE: PersistenceBroker.deleteByQuery(QueryByCriteria q) does not delete objects referenced by a collection-descriptor?

same, but "true" and "false" are deprecated . Best regards Alessandro On 12/13/07, Hiller, Frank RD-PT31 <[EMAIL PROTECTED]> wrote: > > Hi Alessandro, > > thank you for the quick response. > > auto-delete is set to "true". > > Otherwise

RE: PersistenceBroker.deleteByQuery(QueryByCriteria q) does not delete objects referenced by a collection-descriptor?

nique.html#1%3A1+auto-xxx +setting http://db.apache.org/ojb/docu/guides/basic-technique.html#1%3An+auto-xxx +setting http://db.apache.org/ojb/docu/guides/basic-technique.html#m%3An+auto-xxx +setting regards Alessandro On 12/13/07, Hiller, Frank RD-PT31 <[EMAIL PROTECTED]> wrote:

PersistenceBroker.deleteByQuery(QueryByCriteria q) does not delete objects referenced by a collection-descriptor?

Hi community, I'm using PersistenceBroker of OJB1.0.3. Is it correct that "PersistenceBroker.deleteByQuery(QueryByCriteria q)" does not delete objects referenced by a collection-descriptor? Whene I use (1) Object obj = PersistenceBroker.getObjectByQuery(QueryByCriteria q) (2) PersistenceBroker.

How to save java.awt.Color within another object

Hi list, I've got an object that has a java.awt.Color object in it. I'd like to store the value of Color.getRGB() of the Color object in the database. And I'd like get a java.awt.Color object back when loading it from DB. How can I do that? Thank you, Frank Confidentiality note: The informat

Connection to Oracle without listener?

Is there a way to configure jdbc-connection-descriptor in repository_database.xml in a way that it connects directly to a local Oracle database (without using the oracle listener)? I'm using OJB1.0.3, PB in Tomcat. Thanks, Frank Confidentiality note: The information in this email and any attachm