ojb Error in MySQL
Hello, i'm using obj-rc4 and MySQL4 whit tomcat 3.3 and when i start the server, everything goes right. The problem comes making a request 8 hours after the server is runnig, the applications wait a while and it seems it's making something, but then throws a java.lang.StackOverFlowException, and i can't see any log, here is the repository_database, jdbc-connection-descriptor jcd-alias=RuraliaMySQL default-connection=true platform=MySQL jdbc-level=2.0 driver=com.mysql.jdbc.Driver protocol=jdbc subprotocol=mysql dbalias=//localhost:3306/ruralia2?autoReconnect=true username=root password= batch-mode=false useAutoCommit=2 ignoreAutoCommitExceptions=false connection-pool maxActive=21 validationQuery= / perhaps is the version of the driver? anyone can help me?
warning a start
Hi I have some programm using ojb. It start good and works good now. I get a warning at start and I don't find where to manage it : [DEFAULT] WARN: [PlatformFactory] problems with platform [EMAIL PROTECTED]@Impl: org/apache/ojb/broker/platforms/[EMAIL PROTECTED]@Impl [DEFAULT] WARN: [PlatformFactory] OJB will use PlatformDefaultImpl instead I access the same database and the same tables than tutorial1 to validate my code with an existing one. tutorial1 example works good on it's side. Thank's for any help Andre - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
Re: Any body can help me?
Hi It was a classpath problem. Thanks your mail and Antonio mail help me a lot. Andre Kollivakkam R. Raghavan wrote: I have noticed that if you have some class files missing, the initialization fails with this exception. The way I debugged this was to (I use Jbuilder, although I suspect this will work with Eclipse as well) set an exception breakpoint and look at the trace file. It's probably a ClassNotFoundException (this is just a guess)- that's what it was for me. Putting the proper jar files in the class path fixed the problem for me Raghavan -Original Message- From: A Leg [mailto:[EMAIL PROTECTED] Sent: Tuesday, November 11, 2003 11:53 AM To: [EMAIL PROTECTED] Subject: Any body can help me? Hi When I start my application I get this error. It's probably a beginner error, but I get stuck Thank's for any help to enable me to go ahead with ojb. Andre [org.apache.ojb.broker.core.PersistenceBrokerFactoryDefaultImpl] ERROR: Creation of a new PB instance failed null java.lang.reflect.InvocationTargetException[org.apache.ojb.broker.core.P ersistenceBrokerFactoryDefaultImpl] ERROR: Creation of a new PB instance failed null 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) //ojb.broker.core.PersistenceBrokerFactoryDefaultImpl exist in classpath at org.apache.ojb.broker.core.PersistenceBrokerFactoryDefaultImpl$PBKeyedPo olableObjectFactory.makeObject(Unknown Source) at org.apache.commons.pool.impl.GenericKeyedObjectPool.borrowObject(Generic KeyedObjectPool.java:748) at org.apache.ojb.broker.core.PersistenceBrokerFactoryDefaultImpl.createPer sistenceBroker(Unknown Source) at org.apache.ojb.broker.core.PersistenceBrokerFactoryDefaultImpl.defaultPe rsistenceBroker(Unknown Source) at org.apache.ojb.broker.PersistenceBrokerFactory.defaultPersistenceBroker( Unknown Source) - 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: warning a start
Hi Andre, have a look in your used repository.xml / repository_database.xml file. Seems you use [EMAIL PROTECTED]@Impl as platform implementation class. This should be the name of the used platform. Normally OJB replace the @DBMS_NAME@ tag (ant replacement) when using clean OJB version. Please read http://db.apache.org/ojb/platforms.html (or in shipped docs) section setup process to get more information about setup the DB configuration. regards, Armin A Leg wrote: Hi I have some programm using ojb. It start good and works good now. I get a warning at start and I don't find where to manage it : [DEFAULT] WARN: [PlatformFactory] problems with platform [EMAIL PROTECTED]@Impl: org/apache/ojb/broker/platforms/[EMAIL PROTECTED]@Impl [DEFAULT] WARN: [PlatformFactory] OJB will use PlatformDefaultImpl instead I access the same database and the same tables than tutorial1 to validate my code with an existing one. tutorial1 example works good on it's side. Thank's for any help Andre - 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]
How could I know how many brokers are available in brokers pool
Just for stress testing. -- -- Ricardo Tercero Lozano iSOCO - Intelligent Software for the Networked Economy e-mail: [EMAIL PROTECTED] Web: http://www.isoco.com Francisca Delgado 11, 2nd floor 28108 Alcobendas Madrid (Spain) #T: +34 91 334 9750 +34 91 334 9797 (Switchboard) #F: +34 91 334 9799 - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
RE: Any body can help me?
I had my database descriptor wrong once in repository_database.xml and got that error. Maybe check there. I was using a JBoss Datasource for XXX and had OJB configured for YYY. HTH Tim -Original Message- From: A Leg [mailto:[EMAIL PROTECTED] Sent: Tuesday, November 11, 2003 4:20 PM To: OJB Users List Subject: Re: Any body can help me? Hi Antonio No it has no caused by nor nest exception. The rest of error was some list of application calling tree. I am creating som JINI service accessing the persistence layer. The way JINI services access class is particular, it use a class loader. I had first many errors, because it did'nt find the class. And with these errors I had a caused by message. With the help of these messages I progress untill now : no more caused by. And the class maks as unknown is in the classpath. (in fact in the jar of the appli). Thank's for your help. It is late here in cyprus now. We will see tomorrow. Andre Antonio Gallardo wrote: Can you send the full stack trace? Maybe you miss a caused by or a nested exception. Best Regards, Antonio Gallardo - 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: How could I know how many brokers are available in brokers pool
Hi, all configuration properties for the PB-pool you can find in OJB.properties file. Currently we have no 'official' api to get pb-pool information at runtime. But you can try int active = ((PersistenceBrokerFactoryIF) PersistenceBrokerFactoryFactory.instance()) .activePersistenceBroker(); This method returns common-pools active objects (PB instances) when PersistenceBrokerFactoryDefaultImpl was used as PBF implementation. regards, Armin Ricardo Tercero Lozano wrote: Just for stress testing. -- -- Ricardo Tercero Lozano iSOCO - Intelligent Software for the Networked Economy e-mail: [EMAIL PROTECTED] Web: http://www.isoco.com Francisca Delgado 11, 2nd floor 28108 Alcobendas Madrid (Spain) #T: +34 91 334 9750 +34 91 334 9797 (Switchboard) #F: +34 91 334 9799 - 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: ojb Error in MySQL
I think u should check the variable wait_timeout in my.cnf (or my.ini) it assigns how long the connection to the database is active in seconds Jim Theodoridis - Original Message - From: Ramon Cano Granizo [EMAIL PROTECTED] To: OJB Users List [EMAIL PROTECTED] Sent: Wednesday, November 12, 2003 10:59 AM Subject: ojb Error in MySQL Hello, i'm using obj-rc4 and MySQL4 whit tomcat 3.3 and when i start the server, everything goes right. The problem comes making a request 8 hours after the server is runnig, the applications wait a while and it seems it's making something, but then throws a java.lang.StackOverFlowException, and i can't see any log, here is the repository_database, jdbc-connection-descriptor jcd-alias=RuraliaMySQL default-connection=true platform=MySQL jdbc-level=2.0 driver=com.mysql.jdbc.Driver protocol=jdbc subprotocol=mysql dbalias=//localhost:3306/ruralia2?autoReconnect=true username=root password= batch-mode=false useAutoCommit=2 ignoreAutoCommitExceptions=false connection-pool maxActive=21 validationQuery= / perhaps is the version of the driver? anyone can help me? - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
Re: Mysql4.0?
Bob, Thanks for the reply :).
Do you get the same failures with the regression tests? I'm wondering if
it could have anything to do with my setup... If you
As for JDO I was afraid someone would say that Though I seem to have
picked yet another emerging technology that looked ready until I dug
into it. (The last one I tried to play with was RDF/OWL which featured a
bug a day for a week and a half... and sourceforge wouldn't let me into
the cvs to get the fixes anyway.). I should probably take these problems
to bugzilla and see if they have been reported... or the dev list I
suppose. Perhaps they are fixed in CVS.
-Gus
Robert J Celestino wrote:
Hello Gus,
As far as the newsgroup: its quality not quantity here :-)
I am using MySql4.0 with OJB. I am using the PersistenceBroker and ODMG APIs with good success. I am waiting until the JDO support is a little more solid before I switch over to that API.
Bob c
Bob Celestino
SAS Research and Development
919 - 531 - 9425
[EMAIL PROTECTED]
SAS - The Power to Know
-Original Message-
From: Gus Heck [mailto:[EMAIL PROTECTED]
Sent: Tuesday, November 11, 2003 2:44 PM
To: OJB Users List
Subject: Re: Mysql4.0?
Wow this list is quiet. I'm used to Ant lists that are
80+message a day
:)
Is anyone out there using MySQL 4.0 with OJB (particular for JDO) ?
-Gus
Gus Heck wrote:
Is MySQL 4.0 supported?
I ran the regression tests against my database
(/usr/sbin/mysqld Ver
4.0.14-standard for pc-linux on i686) and got the following:
junit-no-compile-no-prepare:
[junit] Running org.apache.ojb.broker.AllTests
[junit] Tests run: 247, Failures: 5, Errors: 2, Time elapsed:
41.511 sec
[junit] TEST org.apache.ojb.broker.AllTests FAILED
[junit] Running org.apache.ojb.odmg.AllTests
[junit] [BOOT] INFO: OJB.properties:
file:/home/gus/zip/db-ojb-1.0.rc4/target/test/ojb/OJB.properties
[junit] Tests run: 160, Failures: 2, Errors: 0, Time elapsed:
11.521 sec
[junit] TEST org.apache.ojb.odmg.AllTests FAILED
[junit] Running org.apache.ojb.soda.AllTests
[junit] [BOOT] INFO: OJB.properties:
file:/home/gus/zip/db-ojb-1.0.rc4/target/test/ojb/OJB.properties
[junit] Tests run: 3, Failures: 0, Errors: 0, Time
elapsed: 2.474
sec
[junit] Running org.apache.ojb.otm.AllTests
[junit] Tests run: 73, Failures: 0, Errors: 0, Time
elapsed: 14.209
sec
when I tracked down the failing tests they turned out to be:
in broker.AllTests:
Testcase: testSubQuery2 took 0.056 sec
Caused an ERROR
Syntax error or access violation, message from server:
You have an
error in your SQL syntax. Check the manual that
corresponds to your
MySQL server version for the right syntax to use near
'SELECT DISTINCT
A0.Kategorie_Nr FROM Artikel A0)' at line 1
Testcase: testSubQuery2Testcase: testSubQuery1 took 0.018 sec
Caused an ERROR
Syntax error or access violation, message from server:
You have an
error in your SQL syntax. Check the manual that
corresponds to your
MySQL server version for the right syntax to use near 'SELECT
avg(A0.Einzelpreis) FROM Artikel A0 WHERE A0.Artikelname
Testcase: testReportPathExpressionForExtents2 took 0.005 sec
FAILED
Testcase: testDeleteWithRemovalAwareCollection took 0.018 sec
FAILED
Testcase: testUserRollbackClearCache took 0.299 sec
FAILED
Testcase: testUserRollbackClearCacheTestcase:
testUserRollback took
0.198 sec
FAILED
Testcase: testUserRollbackTestcase: testRollback took 0.031 sec
FAILED
in odmg.AllTests:
Testcase: testStoreThreePersons took 0.017 sec
FAILED
Testcase: testUserRollbackWithCheckpoint took 0.1 sec
FAILED
Are these known problems? Are they known to be harmless?
or am I in
trouble here?
-Gus
-
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: Mysql4.0?
Hi Gus,
I have not run the unit tests in a while .. But I suspect you have a configuraton
problem .. Can you post your repository_database.xml?
I hear you about getting burned, but I have been very happy with OJB. The JDO stuff is
new but the rest seems very solid, and well supported here. I have been using OJB for
about 2 months now so I am still a newbie, but so far it has been able to do
everything I need it to do.
Bob c
Bob Celestino
SAS Research and Development
919 - 531 - 9425
[EMAIL PROTECTED]
SAS - The Power to Know
-Original Message-
From: Gus Heck [mailto:[EMAIL PROTECTED]
Sent: Wednesday, November 12, 2003 10:57 AM
To: OJB Users List
Subject: Re: Mysql4.0?
Bob, Thanks for the reply :).
Do you get the same failures with the regression tests? I'm
wondering if
it could have anything to do with my setup... If you
As for JDO I was afraid someone would say that Though I
seem to have
picked yet another emerging technology that looked ready
until I dug
into it. (The last one I tried to play with was RDF/OWL
which featured a
bug a day for a week and a half... and sourceforge wouldn't
let me into
the cvs to get the fixes anyway.). I should probably take
these problems
to bugzilla and see if they have been reported... or the
dev list I
suppose. Perhaps they are fixed in CVS.
-Gus
Robert J Celestino wrote:
Hello Gus,
As far as the newsgroup: its quality not quantity here :-)
I am using MySql4.0 with OJB. I am using the
PersistenceBroker and ODMG
APIs with good success. I am waiting until the JDO support
is a little more solid before I switch over to that API.
Bob c
Bob Celestino
SAS Research and Development
919 - 531 - 9425
[EMAIL PROTECTED]
SAS - The Power to Know
-Original Message-
From: Gus Heck [mailto:[EMAIL PROTECTED]
Sent: Tuesday, November 11, 2003 2:44 PM
To: OJB Users List
Subject: Re: Mysql4.0?
Wow this list is quiet. I'm used to Ant lists that are
80+message a day
:)
Is anyone out there using MySQL 4.0 with OJB
(particular for JDO) ?
-Gus
Gus Heck wrote:
Is MySQL 4.0 supported?
I ran the regression tests against my database
(/usr/sbin/mysqld Ver
4.0.14-standard for pc-linux on i686) and got the following:
junit-no-compile-no-prepare:
[junit] Running org.apache.ojb.broker.AllTests
[junit] Tests run: 247, Failures: 5, Errors: 2,
Time elapsed:
41.511 sec
[junit] TEST org.apache.ojb.broker.AllTests FAILED
[junit] Running org.apache.ojb.odmg.AllTests
[junit] [BOOT] INFO: OJB.properties:
file:/home/gus/zip/db-ojb-1.0.rc4/target/test/ojb/OJB.properties
[junit] Tests run: 160, Failures: 2, Errors: 0,
Time elapsed:
11.521 sec
[junit] TEST org.apache.ojb.odmg.AllTests FAILED
[junit] Running org.apache.ojb.soda.AllTests
[junit] [BOOT] INFO: OJB.properties:
file:/home/gus/zip/db-ojb-1.0.rc4/target/test/ojb/OJB.properties
[junit] Tests run: 3, Failures: 0, Errors: 0, Time
elapsed: 2.474
sec
[junit] Running org.apache.ojb.otm.AllTests
[junit] Tests run: 73, Failures: 0, Errors: 0, Time
elapsed: 14.209
sec
when I tracked down the failing tests they turned out to be:
in broker.AllTests:
Testcase: testSubQuery2 took 0.056 sec
Caused an ERROR
Syntax error or access violation, message from server:
You have an
error in your SQL syntax. Check the manual that
corresponds to your
MySQL server version for the right syntax to use near
'SELECT DISTINCT
A0.Kategorie_Nr FROM Artikel A0)' at line 1
Testcase: testSubQuery2Testcase: testSubQuery1 took 0.018 sec
Caused an ERROR
Syntax error or access violation, message from server:
You have an
error in your SQL syntax. Check the manual that
corresponds to your
MySQL server version for the right syntax to use near 'SELECT
avg(A0.Einzelpreis) FROM Artikel A0 WHERE A0.Artikelname
Testcase: testReportPathExpressionForExtents2 took 0.005 sec
FAILED
Testcase: testDeleteWithRemovalAwareCollection took 0.018 sec
FAILED
Testcase: testUserRollbackClearCache took 0.299 sec
FAILED
Testcase: testUserRollbackClearCacheTestcase:
testUserRollback took
0.198 sec
Re: with-jdori broken?
Antonio Gallardo wrote: Hi Gus: First, you dont need to said: I am getting the feeling that the JDO implementation here is sketchy and really very beta or alpha, not so RC ish... But I am probably doing something very wrong. Please remember: You will find help on the list without making this type of comments. Yes I appologize, I was feeling rather frustrated, and not being very fair when I wrote that... I've recently been burned by another technology so my fuse is a little short. I should get a new fuse :) Now to the things: Are you using JDO 1.00 or JDO 1.01? You need JDO 1.00. OJB does NOT work with JDO 1.01. Ah this appears to have been the problem. How strange that a maintainance release (by number at least) would be backwards incompatible. That must irritate the JDO implementors to no end. Thanks for your help. -Gus - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
Re: with-jdori broken?
Hi Gus, sorry for your hassle, but I think we never said that the current JDO implementation (prototype) is full JDO 1.0 compatible or a rc. See docs for JDO: snip from http://db.apache.org/ojb/tutorial4.html temporary note: OJB does not provide it's own JDO implementation yet. A full JDO implementation is in the scope of the 2.0 release. For the time being we provide a plugin to the JDO reference implementation called OjbStore . The OjbStore plugin resides in the package org.apache.ojb.jdori.sql . /snip PB-api and ODMG-api implementations are stable and used in production. The real work of the JDO implementation (backed by the OTM-api) will be start after the 1.0/1.1 release. regards, Armin Gus Heck wrote: Antonio Gallardo wrote: Hi Gus: First, you dont need to said: I am getting the feeling that the JDO implementation here is sketchy and really very beta or alpha, not so RC ish... But I am probably doing something very wrong. Please remember: You will find help on the list without making this type of comments. Yes I appologize, I was feeling rather frustrated, and not being very fair when I wrote that... I've recently been burned by another technology so my fuse is a little short. I should get a new fuse :) Now to the things: Are you using JDO 1.00 or JDO 1.01? You need JDO 1.00. OJB does NOT work with JDO 1.01. Ah this appears to have been the problem. How strange that a maintainance release (by number at least) would be backwards incompatible. That must irritate the JDO implementors to no end. Thanks for your help. -Gus - 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: with-jdori broken?
Armin Waibel dijo: PB-api and ODMG-api implementations are stable and used in production. The real work of the JDO implementation (backed by the OTM-api) will be start after the 1.0/1.1 release. hmm...?!. I am already using OJB with JDO. Sometimes we need to loan some API from PB. But all the rest works fine. ;-D Best Regards, Antonio Gallardo - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
Re: Mysql4.0?
Hi Bob, Nothing in the setup instructions on http://db.apache.org/ojb/platforms.html seemed to indicate that I should touch repository_database.xml for testing purposes but there do appear to be several of them in the distro [EMAIL PROTECTED] db-ojb-1.0.rc4]$ find . -name repository_database.xml ./doc/repository_database.xml ./src/test/org/apache/ojb/repository_database.xml ./target/srctest/org/apache/ojb/repository_database.xml ./target/doc/repository_database.xml ./target/db-ojb-1.0.rc4/doc/repository_database.xml ./target/db-ojb-1.0.rc4/src/test/org/apache/ojb/repository_database.xml I'm not sure which one you want. I suspect they won't be of much use since I havn't touched any of them. Was I supposed to? did I miss something? I did notice that something seems awry in the build.sh prepare-testdb: [torque-create-db] (transform.DTDResolver 128 ) Resolver: used database.dtd from org.apache.torque.engine.database.transform package [sql] Executing file: /home/gus/zip/db-ojb-1.0.rc4/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 SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use 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 SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near '@DATABASE_DEFAULT@' at line 1 [sql] 0 of 2 SQL statements executed successfully I suspect that this is a tag that didn't get properly replaced somewhere, but the build completes saying build-successful anyway. -Gus Robert J Celestino wrote: Hi Gus, I have not run the unit tests in a while .. But I suspect you have a configuraton problem .. Can you post your repository_database.xml? I hear you about getting burned, but I have been very happy with OJB. The JDO stuff is new but the rest seems very solid, and well supported here. I have been using OJB for about 2 months now so I am still a newbie, but so far it has been able to do everything I need it to do. Bob c Bob Celestino SAS Research and Development 919 - 531 - 9425 [EMAIL PROTECTED] SAS - The Power to Know -Original Message- From: Gus Heck [mailto:[EMAIL PROTECTED] Sent: Wednesday, November 12, 2003 10:57 AM To: OJB Users List Subject: Re: Mysql4.0? Bob, Thanks for the reply :). Do you get the same failures with the regression tests? I'm wondering if it could have anything to do with my setup... If you As for JDO I was afraid someone would say that Though I seem to have picked yet another emerging technology that looked ready until I dug into it. (The last one I tried to play with was RDF/OWL which featured a bug a day for a week and a half... and sourceforge wouldn't let me into the cvs to get the fixes anyway.). I should probably take these problems to bugzilla and see if they have been reported... or the dev list I suppose. Perhaps they are fixed in CVS. -Gus Robert J Celestino wrote: Hello Gus, As far as the newsgroup: its quality not quantity here :-) I am using MySql4.0 with OJB. I am using the PersistenceBroker and ODMG APIs with good success. I am waiting until the JDO support is a little more solid before I switch over to that API. Bob c - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
Re: with-jdori broken?
Armin Waibel wrote: Hi Gus, sorry for your hassle, but I think we never said that the current JDO implementation (prototype) is full JDO 1.0 compatible or a rc. See docs for JDO: Ah hmm well it is distributed in the RC :), and it seems that Core Java Data Objects - the Sun Microsystems Press book on JDO lists you as the 3rd most mature Open Source implementation (behind the Sun RI and Triactive JDO)... Summary: O/R-mapping. Feature rich and actively maintained. JDO-compliant in combination with Sun RI. Full inedependent JDO implementation being worked on for 2.0 so others have been claiming it on your behalf it seems. snip from http://db.apache.org/ojb/tutorial4.html temporary note: OJB does not provide it's own JDO implementation yet. A full JDO implementation is in the scope of the 2.0 release. For the time being we provide a plugin to the JDO reference implementation called OjbStore . The OjbStore plugin resides in the package org.apache.ojb.jdori.sql . /snip I saw this, but I don't care for my purposes if it is independant of the RI. A plugin would be just fine with me, so this seemed pretty positive. At this point it seems that mostly the only JDO problem so far is that either I missed where you said 1.0.1 doesn't work in the docs or you havn't specified that yet. That and the general OJB junit tests don't seem to be passing for me, but I am trying to figure out if I have done something wrong in my config there since others seem to be using OJB with 4.0. In other feedback: I tried to put a bug in scarab to report this, but scarab seems to have defeated my attempts to do so. It first confused me by putting up a text box for comments, on some other bug it thought was a duplicat (I entered my entire description there) and it was lost when I went on to the next page where it asked for the description for real. Then I tried again and it claimed I hadn't filled out all the required fields (or something the actual error message was truely cryptic, and looked like it might have been truncated or mangled somewhere) and it refused all attempts to convince it that the fields really were full. I gave up and tried again with a bug complaining about scarab and that seemed to work, which figures since I rather expected it wouldn't work and I should have been more polite about it. I'm a bit Mystified. I almost wonder if it blew up on some portion of the pasted build output or something like that. Though scarab is definately prettier, I have to say bugzilla is quite a bit easier to use (though that may be because I am much more used to it and run one of my own). It definately needs more what is this? type links. -Gus PB-api and ODMG-api implementations are stable and used in production. The real work of the JDO implementation (backed by the OTM-api) will be start after the 1.0/1.1 release. regards, Armin Gus Heck wrote: Antonio Gallardo wrote: Hi Gus: First, you dont need to said: I am getting the feeling that the JDO implementation here is sketchy and really very beta or alpha, not so RC ish... But I am probably doing something very wrong. Please remember: You will find help on the list without making this type of comments. Yes I appologize, I was feeling rather frustrated, and not being very fair when I wrote that... I've recently been burned by another technology so my fuse is a little short. I should get a new fuse :) Now to the things: Are you using JDO 1.00 or JDO 1.01? You need JDO 1.00. OJB does NOT work with JDO 1.01. Ah this appears to have been the problem. How strange that a maintainance release (by number at least) would be backwards incompatible. That must irritate the JDO implementors to no end. Thanks for your help. -Gus - 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: Mysql4.0?
Hi Gus, seems something wrong with your build.properties file or used version is a little bit corrupted (after playing around with files ;-)) syntax to use near '@DATABASE_DEFAULT@' at line 1 This tag should be replaced by an ant target with the name of the used database declared in build.properties. (Maybe I'm wrong, see this error first time today) Gus Heck wrote: Hi Bob, Nothing in the setup instructions on http://db.apache.org/ojb/platforms.html seemed to indicate that I should touch repository_database.xml for testing purposes but there do appear to be several of them in the distro [EMAIL PROTECTED] db-ojb-1.0.rc4]$ find . -name repository_database.xml ./doc/repository_database.xml ./src/test/org/apache/ojb/repository_database.xml orginal source file with @xyz@ ant replace tags ./target/srctest/org/apache/ojb/repository_database.xml this is the important file to run the junit target. @xyz@ tags should be replaced by your declared database (see build.prperties and profile files) regards, Armin ./target/doc/repository_database.xml ./target/db-ojb-1.0.rc4/doc/repository_database.xml ./target/db-ojb-1.0.rc4/src/test/org/apache/ojb/repository_database.xml I'm not sure which one you want. I suspect they won't be of much use since I havn't touched any of them. Was I supposed to? did I miss something? I did notice that something seems awry in the build.sh prepare-testdb: [torque-create-db] (transform.DTDResolver 128 ) Resolver: used database.dtd from org.apache.torque.engine.database.transform package [sql] Executing file: /home/gus/zip/db-ojb-1.0.rc4/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 SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use 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 SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near '@DATABASE_DEFAULT@' at line 1 [sql] 0 of 2 SQL statements executed successfully I suspect that this is a tag that didn't get properly replaced somewhere, but the build completes saying build-successful anyway. -Gus Robert J Celestino wrote: Hi Gus, I have not run the unit tests in a while .. But I suspect you have a configuraton problem .. Can you post your repository_database.xml? I hear you about getting burned, but I have been very happy with OJB. The JDO stuff is new but the rest seems very solid, and well supported here. I have been using OJB for about 2 months now so I am still a newbie, but so far it has been able to do everything I need it to do. Bob c Bob Celestino SAS Research and Development 919 - 531 - 9425 [EMAIL PROTECTED] SAS - The Power to Know -Original Message- From: Gus Heck [mailto:[EMAIL PROTECTED] Sent: Wednesday, November 12, 2003 10:57 AM To: OJB Users List Subject: Re: Mysql4.0? Bob, Thanks for the reply :). Do you get the same failures with the regression tests? I'm wondering if it could have anything to do with my setup... If you As for JDO I was afraid someone would say that Though I seem to have picked yet another emerging technology that looked ready until I dug into it. (The last one I tried to play with was RDF/OWL which featured a bug a day for a week and a half... and sourceforge wouldn't let me into the cvs to get the fixes anyway.). I should probably take these problems to bugzilla and see if they have been reported... or the dev list I suppose. Perhaps they are fixed in CVS. -Gus Robert J Celestino wrote: Hello Gus, As far as the newsgroup: its quality not quantity here :-) I am using MySql4.0 with OJB. I am using the PersistenceBroker and ODMG APIs with good success. I am waiting until the JDO support is a little more solid before I switch over to that API. Bob c - 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: with-jdori broken?
Hi Antonio, Antonio Gallardo wrote: Armin Waibel dijo: PB-api and ODMG-api implementations are stable and used in production. The real work of the JDO implementation (backed by the OTM-api) will be start after the 1.0/1.1 release. hmm...?!. I am already using OJB with JDO. Sometimes we need to loan some API from PB. But all the rest works fine. ;-D that's great! I don't want to bash our JDO implementation, I only want to annotate that it's not perfect ;-) regards, Armin Best Regards, Antonio Gallardo - 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: only grab 10 records
hi andy, have you tried using query.setStartIndex(), setEndIndex() ? it's not as elegant as paging and you also need to keep track of the index yourself. jakob Andy Czerwonka wrote: Does anyone know if its possible to do something like this in OJB: select * from table where criteria but only return me a maximum of 10 records. Is this possible? - 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: only grab 10 records
well sorry, posetd without reading the whole thread :( jakob Jakob Braeuchi wrote: hi andy, have you tried using query.setStartIndex(), setEndIndex() ? it's not as elegant as paging and you also need to keep track of the index yourself. jakob Andy Czerwonka wrote: Does anyone know if its possible to do something like this in OJB: select * from table where criteria but only return me a maximum of 10 records. Is this possible? - 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: Mysql4.0?
Hi Armin,
Actually a little grepping leads me to beleive that something is missing
from build.xml
[EMAIL PROTECTED] db-ojb-1.0.rc4]$ grep -ri 'token=DRIVER_NAME' *
build.xml:filter token=DRIVER_NAME
value=${jdbcRuntimeDriver} /
[EMAIL PROTECTED] db-ojb-1.0.rc4]$ grep -ri 'token=DATABASE_DEFAULT' *
[EMAIL PROTECTED] db-ojb-1.0.rc4]$]
It looks like there is no filter for DATABASE_DEFAULT so it probably
won't matter what properties I set ;)
-Gus
Armin Waibel wrote:
Hi Gus,
seems something wrong with your build.properties file
or used version is a little bit corrupted (after playing
around with files ;-))
syntax to use near '@DATABASE_DEFAULT@' at line 1
This tag should be replaced by an ant target with the
name of the used database declared in build.properties.
(Maybe I'm wrong, see this error first time today)
Gus Heck wrote:
Hi Bob,
Nothing in the setup instructions on
http://db.apache.org/ojb/platforms.html seemed to indicate that I
should touch repository_database.xml for testing purposes but there
do appear to be several of them in the distro
[EMAIL PROTECTED] db-ojb-1.0.rc4]$ find . -name repository_database.xml
./doc/repository_database.xml
./src/test/org/apache/ojb/repository_database.xml
orginal source file with @xyz@ ant replace tags
./target/srctest/org/apache/ojb/repository_database.xml
this is the important file to run the junit target.
@xyz@ tags should be replaced by your declared database
(see build.prperties and profile files)
regards,
Armin
./target/doc/repository_database.xml
./target/db-ojb-1.0.rc4/doc/repository_database.xml
./target/db-ojb-1.0.rc4/src/test/org/apache/ojb/repository_database.xml
I'm not sure which one you want. I suspect they won't be of much use
since I havn't touched any of them. Was I supposed to? did I miss
something? I did notice that something seems awry in the build.sh
prepare-testdb:
[torque-create-db] (transform.DTDResolver 128 )
Resolver: used database.dtd from
org.apache.torque.engine.database.transform package
[sql] Executing file:
/home/gus/zip/db-ojb-1.0.rc4/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 SQL syntax. Check
the manual that corresponds to your MySQL server version for the
right syntax to use 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 SQL syntax. Check
the manual that corresponds to your MySQL server version for the
right syntax to use near '@DATABASE_DEFAULT@' at line 1
[sql] 0 of 2 SQL statements executed successfully
I suspect that this is a tag that didn't get properly replaced
somewhere, but the build completes saying build-successful anyway.
-Gus
Robert J Celestino wrote:
Hi Gus,
I have not run the unit tests in a while .. But I suspect you have a
configuraton problem .. Can you post your repository_database.xml?
I hear you about getting burned, but I have been very happy with
OJB. The JDO stuff is new but the rest seems very solid, and well
supported here. I have been using OJB for about 2 months now so I am
still a newbie, but so far it has been able to do everything I need
it to do.
Bob c
Bob Celestino
SAS Research and Development
919 - 531 - 9425
[EMAIL PROTECTED]
SAS - The Power to Know
-Original Message-
From: Gus Heck [mailto:[EMAIL PROTECTED] Sent: Wednesday,
November 12, 2003 10:57 AM
To: OJB Users List
Subject: Re: Mysql4.0?
Bob, Thanks for the reply :).
Do you get the same failures with the regression tests? I'm
wondering if it could have anything to do with my setup... If you
As for JDO I was afraid someone would say that Though I
seem to have picked yet another emerging technology that looked
ready until I dug into it. (The last one I tried to play with
was RDF/OWL which featured a bug a day for a week and a
half... and sourceforge wouldn't let me into the cvs to get
the fixes anyway.). I should probably take these problems to
bugzilla and see if they have been reported... or the dev list
I suppose. Perhaps they are fixed in CVS.
-Gus
Robert J Celestino wrote:
Hello Gus,
As far as the newsgroup: its quality not quantity here :-)
I am using MySql4.0 with OJB. I am using the
PersistenceBroker and ODMG APIs with good success. I am waiting
until the JDO support is a little more solid before I switch over
to that API.
Bob c
-
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
Re: only grab 10 records
hi all, here's what i found regarding SAPDB http://www.sapdb.org/htmhelp/8c/ccce30c71c11d2a97100a0c9449261/content.htm jakob Charles Anthony wrote: Hi, It is not possible to do this in a cross platform way, so No, currently this is not possible in OJB. For an explanation of the reasons why, see http://article.gmane.org/gmane.comp.jakarta.ojb.user/10065/match=paging+perf ormance+issues Cheers, Charles. -Original Message- From: Andy Czerwonka [mailto:[EMAIL PROTECTED] Sent: 11 November 2003 13:35 To: 'OJB Users List' Subject: only grab 10 records Does anyone know if its possible to do something like this in OJB: select * from table where criteria but only return me a maximum of 10 records. Is this possible? - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] ___ HPD Software Ltd. - Helping Business Finance Business Email terms and conditions: www.hpdsoftware.com/disclaimer - 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]
Reposit
This is probably a terribly noob question, but is there a good way to generate my object mappings for the repository.xml? Seems like a lot of tedium to do it for more than one or two classes. -Gus - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
repository.xml
Wait... Do I need to do this to use JDO... or is this covered by the .jdo files? The tutorial has this line that says: TODO: Put information about the .jdo files Unfortunately by the time the tutorial gets to JDO it has implemented all the other API's so I am having difficulty figuring out what parts of the previous work are required to use JDO. Also I notice that the tutorial section on JDO has this line: PersistenceBrokerFactory.defaultPersistenceBroker().clearCache(); Which is clearly not part of the JDO API. This appears to mean that I will depend on the non-JDO OJB persistance framework. Is there a way around this? -Gus Gus Heck wrote: This is probably a terribly noob question, but is there a good way to generate my object mappings for the repository.xml? Seems like a lot of tedium to do it for more than one or two classes. -Gus - 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: Reposit
I really like using the xdoclet module in the contrib/ directory. The ant reversedb tool works well too. Thomas wrote up a nice article looking at different options at http://db.apache.org/ojb/howto-build-mappings.html -Brian On Wednesday, November 12, 2003, at 04:25 PM, Gus Heck wrote: This is probably a terribly noob question, but is there a good way to generate my object mappings for the repository.xml? Seems like a lot of tedium to do it for more than one or two classes. -Gus - 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: repository.xml
Right now you need to have both the jdo and the repository.xml mappings. It is a pain =/ A cleaner JDO implementation based around the OTM is under development, but won't be advertised in a release until post 1.0. It is probably the highest priority post-1.0 objective and stubs and partial implementations are in place now. the PersistenceBrokerFactory.defaultPersistenceBroker().clearCache(); call just flushes the cache for demonstration purposes. There is no JDO api specification for clearing the cache =) -Brian On Wednesday, November 12, 2003, at 05:05 PM, Gus Heck wrote: Wait... Do I need to do this to use JDO... or is this covered by the .jdo files? The tutorial has this line that says: TODO: Put information about the .jdo files Unfortunately by the time the tutorial gets to JDO it has implemented all the other API's so I am having difficulty figuring out what parts of the previous work are required to use JDO. Also I notice that the tutorial section on JDO has this line: Which is clearly not part of the JDO API. This appears to mean that I will depend on the non-JDO OJB persistance framework. Is there a way around this? -Gus Gus Heck wrote: This is probably a terribly noob question, but is there a good way to generate my object mappings for the repository.xml? Seems like a lot of tedium to do it for more than one or two classes. -Gus - 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: Reposit
Gus Heck dijo: This is probably a terribly noob question, but is there a good way to generate my object mappings for the repository.xml? Seems like a lot of tedium to do it for more than one or two classes. Hi Gus: Druid - http:// druid.sf.net/ - Please, download it from the CVS. Best Regards, Antonio Gallardo - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
PB vs ODMG
Hello, My understanding that the ODMG API is preferred over the PersistenceBroker in production. To that end I have been converting a fair amount of code (that is currently working using the PersistenceBroker API) to the ODMG API. The code works perfectly using the PB API. So I assume that the mappings and configurations are correct. The simplest case that I can describe is this: omdg = OJB.getInstance() ; db = _omdg.newDatabase() ; db.open( default, Database.OPEN_READ_WRITE); Transaction tx = omdg.newTransaction() ; Person person = new Person() ; // creates default with default addr, etc tx.begin() ; tx.lock( person, Transaction.WRITE ) ; tx.commit() ; throws SQL Exception The exception that is thrown is duplicate entry for key (note the table is empty) I did write my own SequenceManger. But it works flawlessly using the PB API. The corresponding code (that works) is here: // include the user and password here: PBKey pbKey = new PBKey( default ) ; broker = PersistenceBrokerFactory.createPersistenceBroker(pbKey); // 1. open transaction broker.beginTransaction(); // 2. make the new object persistent broker.store( person ) ; broker.commitTransaction(); More information: If I comment out the reference-descriptor and collection-descriptor in the repository_user.xml the store works (but of course I get no relationships). However the update does not work. If I change the name of the person and store it again the database is not updated. I must be missing something ... Thanks Bob c Bob Celestino SAS Research and Development 919 - 531 - 9425 [EMAIL PROTECTED] SAS - The Power to Know - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
Druid, was: Re: Reposit
Druid is really cool, but I have never actually gotten the code generation to work. When I hook it to an existing DB, import the entities and go to code generation and I get an error saying datatypes are set on all of my foreign keys =/ -Brian On Wednesday, November 12, 2003, at 05:19 PM, Antonio Gallardo wrote: Gus Heck dijo: This is probably a terribly noob question, but is there a good way to generate my object mappings for the repository.xml? Seems like a lot of tedium to do it for more than one or two classes. Hi Gus: Druid - http:// druid.sf.net/ - Please, download it from the CVS. Best Regards, Antonio Gallardo - 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: Any body can help me? : Solved
Tim Thank's, I had effectively a mistake in my repository_database.xml. I still have some difficulties to understand all configuration. So now it is starting good withour errors. I still have to put in and out datas but it is another story ! Best regards Andre Cobble, Tim wrote: I had my database descriptor wrong once in repository_database.xml and got that error. Maybe check there. I was using a JBoss Datasource for XXX and had OJB configured for YYY. HTH Tim -Original Message- From: A Leg [mailto:[EMAIL PROTECTED] Sent: Tuesday, November 11, 2003 4:20 PM To: OJB Users List Subject: Re: Any body can help me? Hi Antonio No it has no caused by nor nest exception. The rest of error was some list of application calling tree. I am creating som JINI service accessing the persistence layer. The way JINI services access class is particular, it use a class loader. I had first many errors, because it did'nt find the class. And with these errors I had a caused by message. With the help of these messages I progress untill now : no more caused by. And the class maks as unknown is in the classpath. (in fact in the jar of the appli). Thank's for your help. It is late here in cyprus now. We will see tomorrow. Andre Antonio Gallardo wrote: Can you send the full stack trace? Maybe you miss a caused by or a nested exception. Best Regards, Antonio Gallardo - 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]
