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

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();

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 the

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]

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

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

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 =

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

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

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

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,

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:

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

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]