objectbridge-developers Mailing List for ObJectRelationalBridge (Page 18)
Brought to you by:
thma
Menu
▾
▴
objectbridge-developers — public list for developer issues
You can subscribe to this list here.
| 2000 |
Jan
|
Feb
|
Mar
|
Apr
|
May
|
Jun
|
Jul
|
Aug
|
Sep
|
Oct
|
Nov
(14) |
Dec
(20) |
|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 2001 |
Jan
(33) |
Feb
(8) |
Mar
(3) |
Apr
(1) |
May
(18) |
Jun
(6) |
Jul
(15) |
Aug
(71) |
Sep
(29) |
Oct
(43) |
Nov
(77) |
Dec
(54) |
| 2002 |
Jan
(54) |
Feb
(147) |
Mar
(144) |
Apr
(163) |
May
(307) |
Jun
(240) |
Jul
|
Aug
|
Sep
(1) |
Oct
|
Nov
|
Dec
|
|
From: Jakob B. <jbr...@ho...> - 2002-05-12 19:21:26
|
hi travis, yes this is the .400 download and new stuff from cvs. i'll try to run the ant scripts from eclipse, junit already works fine. jakob ----- Original Message ----- From: <tr...@th...> To: <obj...@li...> Sent: Saturday, May 11, 2002 11:08 PM Subject: RE: [OJB-developers] cant' build target junit > is this the .400 download? The directory structure in this download seems to have changed and messed things up. I would get the .375 download. > > Travis > > ---- Original Message ---- > From: Jakob Braeuchi <jbr...@ho...> > Sent: 2002-05-11 > To: obj...@li... > Subject: [OJB-developers] cant' build target junit > > hi, > > i'm using the current version from repository, and i can no longer run the > junit-testcases from the console: > > D:\Java\eclipse_0502\workspace\ojb-1-0>build junit > Buildfile: build.xml > > init: > > prepare: > > main: > [javac] Compiling 7 source files to > D:\Java\eclipse_0502\workspace\ojb-1-0\target\classes > > prepare-tests: > [copy] Copying 1 file to > D:\Java\eclipse_0502\workspace\ojb-1-0\target\src\test\setup > > tests: > [echo] using > switches: -HSQLDB, -ORACLE, -MS_ACCESS, -INSTANTDB, -DB2, -POSTGRESQL, > +MYSQL, -INFORMIX, -MSSQLSERVER > 2000 > [java] . > [move] Moving 1 files to > D:\Java\eclipse_0502\workspace\ojb-1-0\target\src\test\setup > [copy] Copying 1 file to > D:\Java\eclipse_0502\workspace\ojb-1-0\target\test\setup > [delete] Deleting: > D:\Java\eclipse_0502\workspace\ojb-1-0\target\src\test\setup\database-setup. > sql > [java] [BOOT] INFO: process db-setup.sql > [java] [BOOT] INFO: DB url: jdbc:mysql://localhost/ojbtest > [java] [BOOT] INFO: Driver: Mark Matthews' MySQL Driver > [java] [BOOT] INFO: Version: 2.0.13 > > junit: > > BUILD FAILED > > D:\Java\eclipse_0502\workspace\ojb-1-0\build.xml:456: Could not create task > of type: junit. Common solutions are to use > taskdef to declare your task, or, if this is an optional task, to put the > optional.jar in the lib directory of your ant > installation (ANT_HOME). > > Total time: 6 seconds > > thanks > jakob > > _______________________________________________________________ > > Have big pipes? SourceForge.net is looking for download mirrors. We supply > the hardware. You get the recognition. Email Us: ban...@so... > _______________________________________________ > Objectbridge-developers mailing list > Obj...@li... > https://lists.sourceforge.net/lists/listinfo/objectbridge-developers > > > > _______________________________________________________________ > > Have big pipes? SourceForge.net is looking for download mirrors. We supply > the hardware. You get the recognition. Email Us: ban...@so... > _______________________________________________ > Objectbridge-developers mailing list > Obj...@li... > https://lists.sourceforge.net/lists/listinfo/objectbridge-developers > |
|
From: Matthew B. <ma...@so...> - 2002-05-12 18:42:28
|
My very first checkin :) I fixed it. -----Original Message----- From: Matthew Baird [mailto:ma...@so...] Sent: Sunday, May 12, 2002 11:06 AM To: obj...@li... Subject: [OJB-developers] CVS busted? All the new torque stuff is causing havoc, is someone fixing this? _______________________________________________________________ Have big pipes? SourceForge.net is looking for download mirrors. We supply the hardware. You get the recognition. Email Us: ban...@so... _______________________________________________ Objectbridge-developers mailing list Obj...@li... https://lists.sourceforge.net/lists/listinfo/objectbridge-developers |
|
From: Matthew B. <ma...@so...> - 2002-05-12 18:05:39
|
All the new torque stuff is causing havoc, is someone fixing this? |
|
From: Thomas M. <tho...@ho...> - 2002-05-12 15:38:29
|
Hi Chris, Chris Greenlee wrote: > I have a question about unit testing for ObjectBridge. > > As it stands, the test files are segregated by (1) location and (2) > packaging from the production files. The location is understandable, > although having ant as a build tool really makes it unnecessary. But the > packaging -- having a "test." package prefix for tests -- makes it > impossible to test protected methods. > In the "early days" we were completely happy with black-box tests against public interfaces only. I know that the Unit testing folks say it's best practise to have a unit test even for getters and setters... > If your protected methods happen to be in a base class with several > descendants that use those methods frequently, I feel that it's critical to > test the methods. But if they're methods that shouldn't be used anywhere > outside the base class or its children, then there is no good design reason > to make them public -- in fact it really clutters up the public interface of > the class. > > So what is the approach people have taken in the past? Is there a good > reason for me not to test protected methods? Is there a compelling reason > to put test classes in a different package? > I started to develop OJB with VisualAge for Java. With VAJ it was not possible to have different physical locations for the same package structure. That's why I was urged to use a "test." prefix to avoid mixing test and production code. Of course this is not a compelling reason now, as VAJ is dead and modern tools can handle split-up classpaths well. So imho it's ok to eleminate the "test." prefix now! AFAIK the build tool MAVEN requires to separate the physical location for test and production code as Martin setup subfolders "src/java" and "src/test". > As it is, I'll leave out the unit tests I have that test protected methods > for the moment. I'd like to commit them, though. > feel free to rename the package names of the test cases! cheers, Thomas > Regards, > > Chris Greenlee > > > > _______________________________________________________________ > > Have big pipes? SourceForge.net is looking for download mirrors. We supply > the hardware. You get the recognition. Email Us: ban...@so... > _______________________________________________ > Objectbridge-developers mailing list > Obj...@li... > https://lists.sourceforge.net/lists/listinfo/objectbridge-developers > > > > |
|
From: Thomas M. <tho...@ho...> - 2002-05-12 08:21:54
|
Hi Travis, tr...@th... wrote: > just curious > OJB uses a slightly different approach: it caches prepared Statements and not Connections. In order to allow reuse of cached prepared statements the underlying connections must not be closed. Thus OJB currently does not close Connections and using a connection pool won't be effective in this setup. In the future we will also properly support collaboration with connection pools. OJB will not provide yet another pool, but we will provide a plugin mechanism. cheers, Thomas > Travis > > _______________________________________________________________ > > Have big pipes? SourceForge.net is looking for download mirrors. We supply > the hardware. You get the recognition. Email Us: ban...@so... > _______________________________________________ > Objectbridge-developers mailing list > Obj...@li... > https://lists.sourceforge.net/lists/listinfo/objectbridge-developers > > > > |
|
From: Matthew B. <ma...@so...> - 2002-05-11 21:33:32
|
Connections are closed never. That should, in theory, be faster than using a connection pool, as you always have a live connection. It's not scalable, and it doesn't work in managed environment, however. -----Original Message----- From: tr...@th... [mailto:tr...@th...] Sent: Saturday, May 11, 2002 2:15 PM To: Matthew Baird Cc: obj...@so... Subject: RE: RE: [OJB-developers] Does ojb use a connection pool? Ok, thanks. Now do the persistencebrokers keep the connection open until the broker is cleaned up? Or is a connection made each time? Just curious because the tutorial applications seem really slow to do lookups, but maybe that's just hsqldb? Travis ---- Original Message ---- From: Matthew Baird <ma...@so...> Sent: 2002-05-11 To: "'tr...@th...'" <tr...@th...> Subject: RE: [OJB-developers] Does ojb use a connection pool? Currently, the design can be thought of as: persistencebroker==connection. In a couple weeks I'm checking in a refactoring to the architecture that will allow connections to be shared among persistencebrokers. Then, connection pooling will be supported. If you are asking if OJB implements a connection pool internally, I guess you could say a qualified yes, as persistencebroker's are pooled. There is, however, no code that pools connections explicitly. m -----Original Message----- From: tr...@th... [mailto:tr...@th...] Sent: Thursday, May 09, 2002 4:20 PM To: obj...@so... Subject: [OJB-developers] Does ojb use a connection pool? just curious Travis _______________________________________________________________ Have big pipes? SourceForge.net is looking for download mirrors. We supply the hardware. You get the recognition. Email Us: ban...@so... _______________________________________________ Objectbridge-developers mailing list Obj...@li... https://lists.sourceforge.net/lists/listinfo/objectbridge-developers _______________________________________________________________ Have big pipes? SourceForge.net is looking for download mirrors. We supply the hardware. You get the recognition. Email Us: ban...@so... _______________________________________________ Objectbridge-developers mailing list Obj...@li... https://lists.sourceforge.net/lists/listinfo/objectbridge-developers |
|
From: <tr...@th...> - 2002-05-11 21:20:41
|
Ok, thanks. Now do the persistencebrokers keep the connection open until the broker is cleaned up? Or is a connection made each time? Just curious because the tutorial applications seem really slow to do lookups, but maybe that's just hsqldb? Travis ---- Original Message ---- From: Matthew Baird <ma...@so...> Sent: 2002-05-11 To: "'tr...@th...'" <tr...@th...> Subject: RE: [OJB-developers] Does ojb use a connection pool? Currently, the design can be thought of as: persistencebroker==connection. In a couple weeks I'm checking in a refactoring to the architecture that will allow connections to be shared among persistencebrokers. Then, connection pooling will be supported. If you are asking if OJB implements a connection pool internally, I guess you could say a qualified yes, as persistencebroker's are pooled. There is, however, no code that pools connections explicitly. m -----Original Message----- From: tr...@th... [mailto:tr...@th...] Sent: Thursday, May 09, 2002 4:20 PM To: obj...@so... Subject: [OJB-developers] Does ojb use a connection pool? just curious Travis _______________________________________________________________ Have big pipes? SourceForge.net is looking for download mirrors. We supply the hardware. You get the recognition. Email Us: ban...@so... _______________________________________________ Objectbridge-developers mailing list Obj...@li... https://lists.sourceforge.net/lists/listinfo/objectbridge-developers |
|
From: <tr...@th...> - 2002-05-11 21:14:23
|
is this the .400 download? The directory structure in this download seems to have changed and messed things up. I would get the .375 download.
Travis
---- Original Message ----
From: Jakob Braeuchi <jbr...@ho...>
Sent: 2002-05-11
To: obj...@li...
Subject: [OJB-developers] cant' build target junit
hi,
i'm using the current version from repository, and i can no longer run the
junit-testcases from the console:
D:\Java\eclipse_0502\workspace\ojb-1-0>build junit
Buildfile: build.xml
init:
prepare:
main:
[javac] Compiling 7 source files to
D:\Java\eclipse_0502\workspace\ojb-1-0\target\classes
prepare-tests:
[copy] Copying 1 file to
D:\Java\eclipse_0502\workspace\ojb-1-0\target\src\test\setup
tests:
[echo] using
switches: -HSQLDB, -ORACLE, -MS_ACCESS, -INSTANTDB, -DB2, -POSTGRESQL,
+MYSQL, -INFORMIX, -MSSQLSERVER
2000
[java] .
[move] Moving 1 files to
D:\Java\eclipse_0502\workspace\ojb-1-0\target\src\test\setup
[copy] Copying 1 file to
D:\Java\eclipse_0502\workspace\ojb-1-0\target\test\setup
[delete] Deleting:
D:\Java\eclipse_0502\workspace\ojb-1-0\target\src\test\setup\database-setup.
sql
[java] [BOOT] INFO: process db-setup.sql
[java] [BOOT] INFO: DB url: jdbc:mysql://localhost/ojbtest
[java] [BOOT] INFO: Driver: Mark Matthews' MySQL Driver
[java] [BOOT] INFO: Version: 2.0.13
junit:
BUILD FAILED
D:\Java\eclipse_0502\workspace\ojb-1-0\build.xml:456: Could not create task
of type: junit. Common solutions are to use
taskdef to declare your task, or, if this is an optional task, to put the
optional.jar in the lib directory of your ant
installation (ANT_HOME).
Total time: 6 seconds
thanks
jakob
_______________________________________________________________
Have big pipes? SourceForge.net is looking for download mirrors. We supply
the hardware. You get the recognition. Email Us: ban...@so...
_______________________________________________
Objectbridge-developers mailing list
Obj...@li...
https://lists.sourceforge.net/lists/listinfo/objectbridge-developers
|
|
From: Matthew B. <ma...@so...> - 2002-05-11 19:48:36
|
Currently, the design can be thought of as: persistencebroker==connection. In a couple weeks I'm checking in a refactoring to the architecture that will allow connections to be shared among persistencebrokers. Then, connection pooling will be supported. If you are asking if OJB implements a connection pool internally, I guess you could say a qualified yes, as persistencebroker's are pooled. There is, however, no code that pools connections explicitly. m -----Original Message----- From: tr...@th... [mailto:tr...@th...] Sent: Thursday, May 09, 2002 4:20 PM To: obj...@so... Subject: [OJB-developers] Does ojb use a connection pool? just curious Travis _______________________________________________________________ Have big pipes? SourceForge.net is looking for download mirrors. We supply the hardware. You get the recognition. Email Us: ban...@so... _______________________________________________ Objectbridge-developers mailing list Obj...@li... https://lists.sourceforge.net/lists/listinfo/objectbridge-developers |
|
From: Oleg N. <on...@uk...> - 2002-05-11 09:38:51
|
Ville Skytt wrote: > Florian Bruckner wrote: > > reversedb currently uses the gnu-regexp library, therefore these files > > are under GPL. As soon as I have the dependency removed, I can relicense > > the files in the reversdb package. Problem is, I'm rather busy right now, > > so I do not know when I can do these changes. > > Maybe a dumb question, but gnu.regexp is under LGPL (since version 1.02a > from June 1998), does that really imply GPL for derivative/linked > software? Of course not. And of course other libraries used in OJB are LGPL, not GPL. Martin Poeschl wrote: > i found some files taken from other projects using the GPL > the GPL is not compatible to the Apache license, so these file couldn't be > placed on the apache server!!! Why? Let's explicitly state that these files are under LGPL. Does the problem really exist? Oleg |
|
From: Jakob B. <jbr...@ho...> - 2002-05-11 09:30:16
|
hi,
i'm using the current version from repository, and i can no longer run the
junit-testcases from the console:
D:\Java\eclipse_0502\workspace\ojb-1-0>build junit
Buildfile: build.xml
init:
prepare:
main:
[javac] Compiling 7 source files to
D:\Java\eclipse_0502\workspace\ojb-1-0\target\classes
prepare-tests:
[copy] Copying 1 file to
D:\Java\eclipse_0502\workspace\ojb-1-0\target\src\test\setup
tests:
[echo] using
switches: -HSQLDB, -ORACLE, -MS_ACCESS, -INSTANTDB, -DB2, -POSTGRESQL,
+MYSQL, -INFORMIX, -MSSQLSERVER
2000
[java] .
[move] Moving 1 files to
D:\Java\eclipse_0502\workspace\ojb-1-0\target\src\test\setup
[copy] Copying 1 file to
D:\Java\eclipse_0502\workspace\ojb-1-0\target\test\setup
[delete] Deleting:
D:\Java\eclipse_0502\workspace\ojb-1-0\target\src\test\setup\database-setup.
sql
[java] [BOOT] INFO: process db-setup.sql
[java] [BOOT] INFO: DB url: jdbc:mysql://localhost/ojbtest
[java] [BOOT] INFO: Driver: Mark Matthews' MySQL Driver
[java] [BOOT] INFO: Version: 2.0.13
junit:
BUILD FAILED
D:\Java\eclipse_0502\workspace\ojb-1-0\build.xml:456: Could not create task
of type: junit. Common solutions are to use
taskdef to declare your task, or, if this is an optional task, to put the
optional.jar in the lib directory of your ant
installation (ANT_HOME).
Total time: 6 seconds
thanks
jakob
|
|
From: Georg S. <ge...@me...> - 2002-05-10 16:46:21
|
Hi, I have been thinking about the following for a while, but I don't seem to understand it. Why is it necessary for the Identity objects to store the class of the extent it is contained in, instead of the class of the object itself. // identities must be unique accross extents ! this.objectsClass = broker.getExtentClass(objectToIdentitify.getClass()); The reason I am asking this, is that when one is loading an object by its identity, which forms part of an extent with lots of concrete classes, there is a lookup in each of the concrete classes tables (until the object is found), which can take quite a bit of time. If for some reason the "extent-Identity" is necessary (it probably is, but I am too tired to see it) wouldn't it be a good idea to include a further field in Identity which holds the concrete class and can then be used to directly home in on the right table in the getDBObject method in PersistenceBrokerImpl. Thanks for your help in advance Georg |
|
From: Ville <vil...@ik...> - 2002-05-10 16:08:39
|
On Fri, 2002-05-10 at 18:53, Florian Bruckner wrote: > reversedb currently uses the gnu-regexp library, therefore these files ar= e > under GPL. As soon as I have the dependency removed, I can relicense the > files in the reversdb package. Problem is, I'm rather busy right now, so = I > do not know when I can do these changes. Maybe a dumb question, but gnu.regexp is under LGPL (since version 1.02a from June 1998), does that really imply GPL for derivative/linked software? --=20 Ville Skytt=E4 vil...@ik... |
|
From: Florian B. <bf...@fl...> - 2002-05-10 15:53:19
|
Hi Martin, reversedb currently uses the gnu-regexp library, therefore these files are under GPL. As soon as I have the dependency removed, I can relicense the files in the reversdb package. Problem is, I'm rather busy right now, so I do not know when I can do these changes. best regards, Florian > -----Original Message----- > From: obj...@li... > [mailto:obj...@li...]On Behalf Of > Martin Poeschl > Sent: Friday, May 10, 2002 5:25 PM > To: obj...@li... > Subject: [OJB-developers] news > > > the maven generated site can be found at: > > http://www.apache.org/~mpoeschl/ojb/ > > i added a new target junit2 > this target uses torque to create the test-database > > i found some files taken from other projects using the GPL > the GPL is not compatible to the Apache license, so these file > couldn't be placed on the apache > server!!! > > after moving to apache many people will look at ojb . so it is > very important to make the code more > readable as it is today. there are many files without any > comments and javadocs!! > > martin > > > _______________________________________________________________ > > Have big pipes? SourceForge.net is looking for download mirrors. We supply > the hardware. You get the recognition. Email Us: ban...@so... > _______________________________________________ > Objectbridge-developers mailing list > Obj...@li... > https://lists.sourceforge.net/lists/listinfo/objectbridge-developers > |
|
From: Martin P. <mpo...@ma...> - 2002-05-10 15:25:03
|
the maven generated site can be found at: http://www.apache.org/~mpoeschl/ojb/ i added a new target junit2 this target uses torque to create the test-database i found some files taken from other projects using the GPL the GPL is not compatible to the Apache license, so these file couldn't be placed on the apache server!!! after moving to apache many people will look at ojb . so it is very important to make the code more readable as it is today. there are many files without any comments and javadocs!! martin |
|
From: <tr...@th...> - 2002-05-09 23:25:09
|
just curious Travis |
|
From: Matthew B. <ma...@so...> - 2002-05-09 03:09:58
|
Is there any reason the ODMG API should try to commit objects that don't have primary keys? I'd like to change this behaviour to this: - if object has a defined primary key field(s) - and that (those) field(s) are null - then do not commit the object, as it is invalid. Do people rely on the old behaviour which tries to commit all objects regardless? I figure if people don't want primary keys to be required, don't mark them as primary! m |
|
From: Matthew B. <ma...@so...> - 2002-05-09 00:40:57
|
I'm not sure the JTA J2EE persistence manager is implemented correctly (that is PersistenceBrokerJ2EEImpl.java) Is the assumption that the PersistenceBroker will participate in JTA Transactions, but the Datasource will not? That's currently how it's implemented. The PersistenceBrokerJ2EEImpl calls super.commit which goes through connections and calls .commit, .begin, etc. In the appserver environment, we're not supposed to do that. On a related note, the PersistenceBrokerJ2EEImpl can never work given the current architecture of OJB. Connections are cached and re-used via the connection manager. In the J2EE environment, we should not cache connections, as the app server hands us a connection and associates the proper transaction with it (you aren't even getting a raw connection, just a wrapper). We SHOULD, however cache the datasource we looked up. Then, anywhere we use the connection, we should close it and "release' the resources. it's not really going to release the resources, just let the app server know you are done. Also, give the current design, we'd never be able to make OJB work with XA transactions. Anyway, I've made these changes, but they are quite extensive (28 classes changed, several added). I'm going to be testing over the next week, and hopefully reduce the number of classes changed by making new implementations that are pluggable. For big changes like this, what is the protocol? Whoever wrote the JTA peice, please contact me personally so we can work out some issues. cheers, Matthew |
|
From: Leandro R. S. C. <le...@ib...> - 2002-05-08 21:40:41
|
-- Leandro Rodrigo Saad Cruz IT - Inter Business Tecnologia e Servicos (IB) http://www.ibnetwork.com.br |
|
From: Chris G. <CGr...@de...> - 2002-05-08 16:44:36
|
;) I think a little coordination would be a good idea. I'll try to get onto that IRC channel soon. :) C. > -----Original Message----- > From: Martin Poeschl [mailto:mpo...@ma...] > Sent: Wednesday, May 08, 2002 11:43 AM > To: Chris Greenlee > Cc: Bram Meijboom; Joa...@tp...; > obj...@li... > Subject: Re: [OJB-developers] Vendor neutral DDL scripting Tool >=20 >=20 > Chris Greenlee wrote: >=20 > >We've already got a tool that will generate a torque=20 > db-schema.xml from > >a Repository.xml and use that to generate your DDL. :) I'm in the > >process of incorporating the appropriate ant tasks into the OJB > >build.xml, and then you won't need to use db-setup.sql ever again. ;) > > > >It has the added advantage that you won't have to re-write your > >repository.xml in Torque's format. > > > we should merge this with the existing torque generator, than=20 > we could=20 > transform in any direction: >=20 > schema -> repository > repository -> schema > schema -> db > db -> schema > db -> repository (reversedb) > schema -> doc >=20 > i think we should coordinate our work ;-) > there is an irc channel we can use for ojb discussions >=20 > irc.whichever.com #ojb >=20 > you can reach me there every day (and night ;-) >=20 > martin >=20 > > > >Regards, > > > >Chris > > > > =20 > > > >>-----Original Message----- > >>From: Bram Meijboom [mailto:br...@in...] > >>Sent: Wednesday, May 08, 2002 4:48 AM > >>To: 'Joa...@tp...'; > >>obj...@li... > >>Subject: RE: [OJB-developers] Vendor neutral DDL scripting Tool > >> > >> > >>My idea exactly,=20 > >> > >>I also have been looking around and came up with zip/zilch in the=20 > >>open source projects... > >>mainly it it takes a sqlgenerator that is database dependant,=20 > >>takes care of > >>vendor types > >>and weird (read oracle 8) jdbc drivers/databases(in oracle 8=20 > >>a "", empty > >>string, is a null ??? ). > >> > >> > >>-----Original Message----- > >>From: Joa...@tp... [mailto:Joa...@tp...] > >>Sent: Wednesday, May 08, 2002 10:49 AM > >>To: obj...@li... > >>Subject: [OJB-developers] Vendor neutral DDL scripting Tool > >> > >> > >>Hy, > >> > >>you all probably know about the problem with different SQL=20 > >>dialects for=20 > >>different Databases. The Query part is actually quite ok, but=20 > >>DDLs just=20 > >>won't work on more than one Database, when any advanced=20 > >>feature is used=20 > >>(and sometimes "advanced features" are things like text that=20 > >>is longer=20 > >>than 255 characters). Most of this differences are just=20 > >>different names=20 > >>for a data type (example from db-setup.sql: LONGVARBINARY, BLOB,=20 > >>BLOB(32k), LONGBLOB, IMAGE). What I think would be great is a=20 > >>tool that=20 > >>takes ANSI SQL DDL and executes it on different database,=20 > >>after modifing=20 > >>the data types to fit the DB vendors idea of the name. While=20 > >>converting it=20 > >>could output warnings about changed behaviour (for example=20 > MySQL not=20 > >>handling spaces at the end of CLOBs correctly). I think=20 > >>writing such a=20 > >>tool once is less work than modfing db-setup.sql for each=20 > >>change and it=20 > >>would be easier to maintain ("Super-DB v36 does support the new=20 > >>HYPER_GROOVY_BLOB instead of the old PLAIN_BLOB").=20 > >>Additionally it would=20 > >>be a great for us, as our product should run on quite some=20 > different=20 > >>databases ;-) > >> > >>I would be willing to write such a tool, but I almost can't=20 > >>believe that=20 > >>there is no such thing out there ('though I didn't find it).=20 > >>Does anybody=20 > >>know if there are simillar tools somewhere? And if not does=20 > >>anyone know if=20 > >>there is a nice overview about the DDL of some databases?=20 > >>Especially the=20 > >>ANSI SQL Datatypes? > >> > >>regards > >>Joachim Sauer > >> > >>_ > >> >=20 >=20 >=20 |
|
From: Martin P. <mpo...@ma...> - 2002-05-08 16:42:41
|
Chris Greenlee wrote: >We've already got a tool that will generate a torque db-schema.xml from >a Repository.xml and use that to generate your DDL. :) I'm in the >process of incorporating the appropriate ant tasks into the OJB >build.xml, and then you won't need to use db-setup.sql ever again. ;) > >It has the added advantage that you won't have to re-write your >repository.xml in Torque's format. > we should merge this with the existing torque generator, than we could transform in any direction: schema -> repository repository -> schema schema -> db db -> schema db -> repository (reversedb) schema -> doc i think we should coordinate our work ;-) there is an irc channel we can use for ojb discussions irc.whichever.com #ojb you can reach me there every day (and night ;-) martin > >Regards, > >Chris > > > >>-----Original Message----- >>From: Bram Meijboom [mailto:br...@in...] >>Sent: Wednesday, May 08, 2002 4:48 AM >>To: 'Joa...@tp...'; >>obj...@li... >>Subject: RE: [OJB-developers] Vendor neutral DDL scripting Tool >> >> >>My idea exactly, >> >>I also have been looking around and came up with zip/zilch in the >>open source projects... >>mainly it it takes a sqlgenerator that is database dependant, >>takes care of >>vendor types >>and weird (read oracle 8) jdbc drivers/databases(in oracle 8 >>a "", empty >>string, is a null ??? ). >> >> >>-----Original Message----- >>From: Joa...@tp... [mailto:Joa...@tp...] >>Sent: Wednesday, May 08, 2002 10:49 AM >>To: obj...@li... >>Subject: [OJB-developers] Vendor neutral DDL scripting Tool >> >> >>Hy, >> >>you all probably know about the problem with different SQL >>dialects for >>different Databases. The Query part is actually quite ok, but >>DDLs just >>won't work on more than one Database, when any advanced >>feature is used >>(and sometimes "advanced features" are things like text that >>is longer >>than 255 characters). Most of this differences are just >>different names >>for a data type (example from db-setup.sql: LONGVARBINARY, BLOB, >>BLOB(32k), LONGBLOB, IMAGE). What I think would be great is a >>tool that >>takes ANSI SQL DDL and executes it on different database, >>after modifing >>the data types to fit the DB vendors idea of the name. While >>converting it >>could output warnings about changed behaviour (for example MySQL not >>handling spaces at the end of CLOBs correctly). I think >>writing such a >>tool once is less work than modfing db-setup.sql for each >>change and it >>would be easier to maintain ("Super-DB v36 does support the new >>HYPER_GROOVY_BLOB instead of the old PLAIN_BLOB"). >>Additionally it would >>be a great for us, as our product should run on quite some different >>databases ;-) >> >>I would be willing to write such a tool, but I almost can't >>believe that >>there is no such thing out there ('though I didn't find it). >>Does anybody >>know if there are simillar tools somewhere? And if not does >>anyone know if >>there is a nice overview about the DDL of some databases? >>Especially the >>ANSI SQL Datatypes? >> >>regards >>Joachim Sauer >> >>_ >> |
|
From: Leandro R. S. C. <le...@ib...> - 2002-05-08 16:01:39
|
Hi all. I noticed that Log4jLoggerImpl is configured for every instace that it's created at LoggerFactory. Is it the intended behavior or can I change that and submit some patches to configure Log4J only once and use the same configuration for every instance of Log4JLoggerImpl ? -- Leandro Rodrigo Saad Cruz IT - Inter Business Tecnologia e Servicos (IB) http://www.ibnetwork.com.br |
|
From: Chris G. <CGr...@de...> - 2002-05-08 15:15:04
|
We've already got a tool that will generate a torque db-schema.xml from
a Repository.xml and use that to generate your DDL. :) I'm in the
process of incorporating the appropriate ant tasks into the OJB
build.xml, and then you won't need to use db-setup.sql ever again. ;)
It has the added advantage that you won't have to re-write your
repository.xml in Torque's format.
Regards,
Chris
> -----Original Message-----
> From: Bram Meijboom [mailto:br...@in...]
> Sent: Wednesday, May 08, 2002 4:48 AM
> To: 'Joa...@tp...';
> obj...@li...
> Subject: RE: [OJB-developers] Vendor neutral DDL scripting Tool
>=20
>=20
> My idea exactly,=20
>=20
> I also have been looking around and came up with zip/zilch in the=20
> open source projects...
> mainly it it takes a sqlgenerator that is database dependant,=20
> takes care of
> vendor types
> and weird (read oracle 8) jdbc drivers/databases(in oracle 8=20
> a "", empty
> string, is a null ??? ).
>=20
>=20
> -----Original Message-----
> From: Joa...@tp... [mailto:Joa...@tp...]
> Sent: Wednesday, May 08, 2002 10:49 AM
> To: obj...@li...
> Subject: [OJB-developers] Vendor neutral DDL scripting Tool
>=20
>=20
> Hy,
>=20
> you all probably know about the problem with different SQL=20
> dialects for=20
> different Databases. The Query part is actually quite ok, but=20
> DDLs just=20
> won't work on more than one Database, when any advanced=20
> feature is used=20
> (and sometimes "advanced features" are things like text that=20
> is longer=20
> than 255 characters). Most of this differences are just=20
> different names=20
> for a data type (example from db-setup.sql: LONGVARBINARY, BLOB,=20
> BLOB(32k), LONGBLOB, IMAGE). What I think would be great is a=20
> tool that=20
> takes ANSI SQL DDL and executes it on different database,=20
> after modifing=20
> the data types to fit the DB vendors idea of the name. While=20
> converting it=20
> could output warnings about changed behaviour (for example MySQL not=20
> handling spaces at the end of CLOBs correctly). I think=20
> writing such a=20
> tool once is less work than modfing db-setup.sql for each=20
> change and it=20
> would be easier to maintain ("Super-DB v36 does support the new=20
> HYPER_GROOVY_BLOB instead of the old PLAIN_BLOB").=20
> Additionally it would=20
> be a great for us, as our product should run on quite some different=20
> databases ;-)
>=20
> I would be willing to write such a tool, but I almost can't=20
> believe that=20
> there is no such thing out there ('though I didn't find it).=20
> Does anybody=20
> know if there are simillar tools somewhere? And if not does=20
> anyone know if=20
> there is a nice overview about the DDL of some databases?=20
> Especially the=20
> ANSI SQL Datatypes?
>=20
> regards
> Joachim Sauer
>=20
> _______________________________________________________________
>=20
> Have big pipes? SourceForge.net is looking for download=20
> mirrors. We supply
> the hardware. You get the recognition. Email Us:=20
> ban...@so...
> _______________________________________________
> Objectbridge-developers mailing list
> Obj...@li...
> https://lists.sourceforge.net/lists/listinfo/objectbridge-developers
>=20
> _______________________________________________________________
>=20
> Have big pipes? SourceForge.net is looking for download=20
> mirrors. We supply
> the hardware. You get the recognition. Email Us:=20
> ban...@so...
> _______________________________________________
> Objectbridge-developers mailing list
> Obj...@li...
> https://lists.sourceforge.net/lists/listinfo/objectbridge-developers
>=20
|
|
From: Bram M. <br...@in...> - 2002-05-08 09:48:35
|
My idea exactly,
I also have been looking around and came up with zip/zilch in the
open source projects...
mainly it it takes a sqlgenerator that is database dependant, takes care of
vendor types
and weird (read oracle 8) jdbc drivers/databases(in oracle 8 a "", empty
string, is a null ??? ).
-----Original Message-----
From: Joa...@tp... [mailto:Joa...@tp...]
Sent: Wednesday, May 08, 2002 10:49 AM
To: obj...@li...
Subject: [OJB-developers] Vendor neutral DDL scripting Tool
Hy,
you all probably know about the problem with different SQL dialects for
different Databases. The Query part is actually quite ok, but DDLs just
won't work on more than one Database, when any advanced feature is used
(and sometimes "advanced features" are things like text that is longer
than 255 characters). Most of this differences are just different names
for a data type (example from db-setup.sql: LONGVARBINARY, BLOB,
BLOB(32k), LONGBLOB, IMAGE). What I think would be great is a tool that
takes ANSI SQL DDL and executes it on different database, after modifing
the data types to fit the DB vendors idea of the name. While converting it
could output warnings about changed behaviour (for example MySQL not
handling spaces at the end of CLOBs correctly). I think writing such a
tool once is less work than modfing db-setup.sql for each change and it
would be easier to maintain ("Super-DB v36 does support the new
HYPER_GROOVY_BLOB instead of the old PLAIN_BLOB"). Additionally it would
be a great for us, as our product should run on quite some different
databases ;-)
I would be willing to write such a tool, but I almost can't believe that
there is no such thing out there ('though I didn't find it). Does anybody
know if there are simillar tools somewhere? And if not does anyone know if
there is a nice overview about the DDL of some databases? Especially the
ANSI SQL Datatypes?
regards
Joachim Sauer
_______________________________________________________________
Have big pipes? SourceForge.net is looking for download mirrors. We supply
the hardware. You get the recognition. Email Us: ban...@so...
_______________________________________________
Objectbridge-developers mailing list
Obj...@li...
https://lists.sourceforge.net/lists/listinfo/objectbridge-developers
|
|
From: Martin P. <mpo...@ma...> - 2002-05-08 09:08:19
|
Joa...@tp... wrote:
>Hy,
>
>you all probably know about the problem with different SQL dialects for
>different Databases. The Query part is actually quite ok, but DDLs just
>won't work on more than one Database, when any advanced feature is used
>(and sometimes "advanced features" are things like text that is longer
>than 255 characters). Most of this differences are just different names
>for a data type (example from db-setup.sql: LONGVARBINARY, BLOB,
>BLOB(32k), LONGBLOB, IMAGE). What I think would be great is a tool that
>takes ANSI SQL DDL and executes it on different database, after modifing
>the data types to fit the DB vendors idea of the name. While converting it
>could output warnings about changed behaviour (for example MySQL not
>handling spaces at the end of CLOBs correctly). I think writing such a
>tool once is less work than modfing db-setup.sql for each change and it
>would be easier to maintain ("Super-DB v36 does support the new
>HYPER_GROOVY_BLOB instead of the old PLAIN_BLOB"). Additionally it would
>be a great for us, as our product should run on quite some different
>databases ;-)
>
in the near future we will use the database creator from torque.
http://jakarta.apache.org/turbine/torque
so you'll have to write a db-schema.xml and torque will create the db
and the repository.xml for you :-)
i'm working on a demo ... will be available shortly
btw. the ScriptTool which is currently used is under the Enhydra license
(i'm not sure if it is compatible to the Apache license, so the
replacement should happen before the movement to apache)
>
>I would be willing to write such a tool, but I almost can't believe that
>there is no such thing out there ('though I didn't find it). Does anybody
>know if there are simillar tools somewhere? And if not does anyone know if
>there is a nice overview about the DDL of some databases? Especially the
>ANSI SQL Datatypes?
>
that would be nice!!
if you find a page with this info, please send the link!!
martin
|
9 messages has been excluded from this view by a project administrator.
