AW: ms access: sqlexception

2004-03-18 Thread Christian Eugster
hi Pedro in this case it is not a date or time problem, because there are no fields of such types. But thank you anyway! Christian - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]

AW: ms access: sqlexception

2004-03-18 Thread Christian Eugster
hi jakob i used the same attributenames in other databases as postgresql and mysql and it works fine there. How can i replace the ? with the desired values? (i just prepare an object - in this case an object of type productGroup with data and call the broker store() method. is there another opport

AW: ms access: sqlexception

2004-03-18 Thread Christian Eugster
Hi Raghu thank you for answering. My english is quit bad, but i try to translate the exception: Syntaxfehler in der INSERT INTO-Anweisung. syntax error in the INSERT INTO-statement. Christian - To unsubscribe, e-mail: [EMAIL

Re: 1 to 1 mapping

2004-03-18 Thread Edson Carlos Ericksson Richter
Use a reference-descriptor to make 1:1 mappings. If you are using 1:N mappings, use a collection-descriptor in the 1 side, and a reference-descriptor in the N side. Best regards, Edson Richter - Original Message - From: McCaffrey, John G. To: 'OJB Users List' Sent: Thursday,

1 to 1 mapping

2004-03-18 Thread McCaffrey, John G.
I am trying to join two tables A and B table A has three primary keys Main_ID Node_ID Process_Date table B has two primary keys Node_ID Process_Date my mapping has the Table A object containing a collection of B obj I want to join the collection using the Node_ID, because it is the only thing the

Re: ms access: sqlexception

2004-03-18 Thread salgado.pc
On MSSQL also appeared the same error. If you have DATE fields on the DAO to be made persistent, change the date field attributes to java.sql.Timestamp and do the same on the OJB repository, Pedro Salgado > hi raghu, > > welcome back ! > > Raghuram Rajah wrote: > >> Christian, >> >> The genera

Re: ms access: sqlexception

2004-03-18 Thread Jakob Braeuchi
hi raghu, welcome back ! Raghuram Rajah wrote: Christian, The generated statement is a PreparedStatement. PreparedStatements are parameterized and are far more efficient than NonPreparedStatements. The "?" refers to a parameter. As far as the exception is concerned, can you translate that to En

Fw: Help on cache mechanism when multiple classes sharing the same table

2004-03-18 Thread Hanmin_Wang
Hi, I have several classname, sharing the same table in the databse. For example, com.bp.accounting.user com.bp.market.user These two classes are using the same table S_USER in the database, using two classes instead of one is for the purpose of maintaince and performance. If I have updated a

RE: ms access: sqlexception

2004-03-18 Thread Raghuram Rajah
Christian, The generated statement is a PreparedStatement. PreparedStatements are parameterized and are far more efficient than NonPreparedStatements. The "?" refers to a parameter. As far as the exception is concerned, can you translate that to English? Thanks, Raghu. -Original Message---

OJB report query

2004-03-18 Thread Manukyan, Sergey
Folks, How can I specify expressions in OJB report query? I want it to select not a column but the sum of several columns, The code here doesn't work, it failes to recognize the names of field-descriptors. I use RC4. Thank you, -Sergey - ReportQueryByCriteria qry =

Re: JDO status for OJB 1.0 RC5

2004-03-18 Thread Brian McCallister
The OJB native JDO is both incomplete and undocumented. The backend necessary to support JDO is in place (via the OTM) but I think there just hasn't been enough demand for full JDO support, yet. It is my personal goal to get a solid implementation into 1.1, but for 1.0 the JDORI plugin is the o

JDO status for OJB 1.0 RC5

2004-03-18 Thread Angus Berry
I wonder if some could give me a little more in depth status of JDO in RC5. Specifically, from looking at the mail archives I understand that in addition to the JDO ref. mask, there is some native JDO already implemented. So I'm wondering if what's available is buggy or just incomplete and is this

Transaction Question

2004-03-18 Thread Ziv Yankowitz
Folks, We are using ODMG local transaction is there any way to set timeout on the transaction? thanks. - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]

RE: Primary Key from Insert-For John

2004-03-18 Thread Glenn Barnard
Yep, you're in the exact same boat as I am with MS SQL Server. The platform class is loaded by PlatformFactory and it uses the following statement to name the class.: return "org.apache.ojb.broker.platforms.Platform" + pf.substring(0, 1).toUpperCase() + pf.substring(1) + "Impl"; where t

Logger Error

2004-03-18 Thread Carles Duque
Hello, I'm using tomcat and ojb. I test an example of cocoon with ojb: PersistenceManager manager = factory.getPersistenceManager(); /* 2. Get current transaction */ Transaction tx = manager.currentTransaction(); /* 3. Start a Transaction */ tx.begin();

ms access: sqlexception

2004-03-18 Thread Christian Eugster
Hi there unfortunately i have to connect my application for a customer to an access database. I succeeded to connect but i always get exceptions while inserting or updating rows as follows: INTERESTING: the insertstatement shows instead of values just '?' what could this mean? Has anybody any ide