SapDB
How can I store a variable size string in sapdb. varchar has a limit of 8000 which is a limit of all varchars in the raw of the table. SapDb documentation says that varchar(n) defines a variable length but it doesn't seem to work. I am getting exception when i use it while creating a table. What gives? Roman _ MSN Photos is the easiest way to share and print your photos: http://photos.msn.com/support/worldwide.aspx
RE: SapDB
-Original Message- From: Namor Taror [mailto:[EMAIL PROTECTED]] Sent: Saturday, December 15, 2001 9:40 AM To: Orion-Interest Subject: SapDB How can I store a variable size string in sapdb. varchar has a limit of 8000 which is a limit of all varchars in the raw of the table. SapDb documentation says that varchar(n) defines a variable length but it doesn't seem to work. I am getting exception when i use it while creating a table. What gives? We found this ugly limitation this week. We tried to store an xml document that was larger then 8k and got the exception Not yet implemented. The solution we have implemented is to divide the xml documents in about 7k chunks and add them to another table. When they are needed later we have en entitiy bean that puts them together in the corrrect order. Pretty much the same thing as packets are handled in tcp/ip. /Thomas Thomas Sundberg MatchProvider Sergels Torg 14 111 57 Stockholm Tel: 08 - 555 16 308 Fax: 08 - 555 16 301 Mobil: 070 - 421 03 88 http://www.matchprovider.com
Problems with SAPDB
Hi! I am in a middle of changing our database from HypersonicSQL to SAPDB. In theory it should be easy ;) This is how I have proceeded: 1. I created a database-schema for SAPDB (actually I found a one from this mailing list and copied it). I put that file to $ORION_DIR/config/database-schemas/. The schema file being used: ?xml version=1.0? !DOCTYPE database-schema PUBLIC -//Evermind//- Database schema http://www.orionserver.com/dtds/database-schemas.dtd; database-schema name=SapDB not-null=not null null= primary-key=primary key max-table-name-length=32 type-mapping type=boolean name=boolean / type-mapping type=java.lang.Booleanname=boolean / type-mapping type=byte name=byte / type-mapping type=java.lang.Byte name=byte / type-mapping type=char name=char / type-mapping type=java.lang.Character name=char / type-mapping type=double name=double precision / type-mapping type=java.lang.Double name=double precision / type-mapping type=floatname=float / type-mapping type=java.lang.Float name=float / type-mapping type=int name=integer / type-mapping type=java.lang.Integername=integer / type-mapping type=long name=integer / type-mapping type=java.lang.Long name=integer / type-mapping type=shortname=smallint / type-mapping type=java.lang.Short name=smallint / type-mapping type=java.lang.String name=varchar(255) / type-mapping type=java.math.BigDecimal name=fixed(15,15) / type-mapping type=byte[] name=long byte / type-mapping type=java.sql.Datename=date / type-mapping type=java.sql.Timename=time / type-mapping type=java.sql.Timestamp name=timestamp / type-mapping type=java.util.Date name=timestamp / type-mapping type=java.io.Serializable name=long byte / disallowed-field name=key / disallowed-field name=date / disallowed-field name=timestamp / disallowed-field name=time / disallowed-field name=username / disallowed-field name=password / disallowed-field name=order / disallowed-field name=table / disallowed-field name=value / disallowed-field name=name / disallowed-field name=count / /database-schema 2. I created a data-source description for SAPDB and pointed my application to use it. The data-source description being used: data-sources data-source class=com.evermind.sql.ConnectionDataSource inactivity-timeout=120 location=jdbc/DefaultCoreDS pooled-location=jdbc/DefaultPooledDS name=SAPTest data-source schema=./database-schemas/sapdb.xml xa-location=jdbc/xa/DefaultXADS ejb-location=jdbc/DefaultDS url=jdbc:sapdb://localhost/testdb connection-driver=com.sap.dbtech.jdbc.DriverSapDB username=TEST password=TEST / /data-sources 3. I added the SAPDB JDBC driver to $ORION_DIR/lib 4. I restarted Orion I believe that in an ideal case these would be the required steps when database is changed. However, I encountered two problems: 1. Table auto-creation was not fully successful. All the other tables were correctly created but one. SAPDB has a limit for maximum lenght for table row names but I didn't find any way to specify this in schema definition. Maximum legth for table names are supported by the attribute max-table-name-length=32 and it works fine. Do you know if there's a similar way to restrict the length of a row? (I tried max-row-name-length but wasn't lucky :) 2. The following exception is thrown: com.evermind.server.rmi.OrionRemoteException: javax.ejb.EJBException: Error saving state: Connection was closed at com.evermind.server.ejb.EJBUtils.getUserException(JAX) at UserManager_StatelessSessionBeanWrapper14.getGroupNamesForUser(UserManager_StatelessSessionBeanWrapper14.java:1348) at org.shiftctrl.framework.security.authentication.DefaultLoginModule.commit(DefaultLoginModule.java:243) ... Nested exception is: javax.ejb.EJBException: Error saving state: Connection was closed at SCUser_EntityBeanWrapper5.saveState(SCUser_EntityBeanWrapper5.java:1057) at SCUser_EntityBeanWrapper5.getGroupNames(SCUser_EntityBeanWrapper5.java:712) at org.shiftctrl.user_management.service.UserManagerEJB.getGroupNamesForUser(UserManagerEJB.java:328) ... The control goes so that the user is first authenticated using a session bean + CMP entity bean. Then the user's login metadata (last login, num of logins et.) is correctly updated using a session bean + CMP entity bean. After that the intention is to initialize user's session by calling getGroupNamesForUser() on a session
Re: Problems with SAPDB (correction)
I meant column names when I wrote row names. As far as I know the row's usually don't have any names ;) Stupid me... Anyway, the problems remain... Joni [EMAIL PROTECTED]
orion + jbuilder4 -- sapdb?
Thank you for everyone answering my MySQL question. So, it appears that the situation is this, if I want to use Orion + JBuilder4: * PostgreSQL works fine except it isn't able to show tables in JBuilder * MySQL's EJB support doesn't work (and we need that!) * If we want to use Hypersonic we have to stop Orion while updating the db So, the question is, does SapDB work with our combination (has anyone used it with JBuilder and Orion)? I haven't really heard about it before, so how does it compare for example to MySQL and PostgreSQL? Regards, Peter
RE: orion + jbuilder4 -- sapdb?
Hi Peter I have not read your original post, nor the replies. However, I just wanted to recommend using Interbase. If you want to use Borland JBuilder, it seems obvious to use Borland Interbase aswell - I am not completely up to speed with JBuilder, but I would expect that their own database product would have the best integration with their IDE. We have chosen Interbase because it is an old, high quality, reliable product from Borland. I have absolutely nothing against Postgre or MySQL, but the fact that Borland has released Interbase as a free open source product gives you free access to a database which has been through 15 years of professional development. Now, if anyone can mention a product which beats that I am all ears... In hopes I have not mentioned something, someone else already posted Randahl -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of Peter Peltonen Sent: 5. april 2001 10:17 To: Orion-Interest Cc: Jukka-Pekka Naukkarinen; Ilkka Suvanto Subject: orion + jbuilder4 -- sapdb? Thank you for everyone answering my MySQL question. So, it appears that the situation is this, if I want to use Orion + JBuilder4: * PostgreSQL works fine except it isn't able to show tables in JBuilder * MySQL's EJB support doesn't work (and we need that!) * If we want to use Hypersonic we have to stop Orion while updating the db So, the question is, does SapDB work with our combination (has anyone used it with JBuilder and Orion)? I haven't really heard about it before, so how does it compare for example to MySQL and PostgreSQL? Regards, Peter
Re: orion + jbuilder4 -- sapdb?
I always like to pitch SapDB, because like Interbase, SAP DB, from the folks who brought us SAP R/3 etc has been around the block. Has a lot of good stuff: Referential Integrity, Triggers, Stored Procs, updateable views, subselects and outer joins, scrollable cursors, plus maintenance-wise it has online backup, online expansion of the db, a solid set of commandline and gui-based maintenance tools (some are available on Windows platforms only, for now) an active user community, an active and helpful news group, and active support from a reasonable-sized team of developers at SAP Labs in Berlin. The programming interfaces include ODBC, C/C++ precompiler, JDBC (the one I use - it has a type4 jdbc driver that is pretty solid), Perl DBI, Python, and PHP. Backup tools that can be used are: ADSM + adint2 Networker Netvault, HiBack (soon) Backint for Oracle Tools supporting this interface are: ARCserve, Backup Express, dbBRZ for R/3, DBVAULT, DoroStore, EASY_BASE, EMC, EPOCH, FDR/UPSTREAM, HIBACK, HSMS-CL Backint, NetBackup, NetVault, NetWorker, Omniback, Seagate Backup, SESAM, Solstice Backup, Sys-Save, TIME NAVIGATOR for R/3, Tivoli I believe they have something like 800 clients using it with an implementation of SAP R/3. It has its quirks, here and there, which you'll notice if you try and get the Petstore to work with it. But I think it is a great product, works well with Orion, handles CMP in a dandy fashion. Etc. I would encourage at least evaluating the product. However, I am forgetting about your question, and that is does it work with JBuilder4 and how does it compare to MySQL and postresql? I haven't worked with postgresql, perhaps another person can speak to that, but I have use MySQL. MySQL is unbelievably quick, and while there is now transaction support that is coming out of the mysql camp - we decided to look at databases that already had it and stumbled on this one (SAP DB). It is quick as well and does what we want. It has a larger footprint than MySQL, but that would be expected. It's a quick db as well and has a lot of configurable options to help out in that arena. Does it work with JBuilder4? Don't know! I don't see why it wouldn't, but I'm a UltraEdit/Vi-Ant guy so I can't speak for it - again perhaps someone else on the list can shed some light. There was another posting that suggested using Interbase with JBuilder4 - that is certainly a good idea since Borland and JBuilder have been so closely linked. I have used Interbase and JBuilder before but that was several years ago (They worked then!) Good luck Ray Harrison --- Peter Peltonen [EMAIL PROTECTED] wrote: Thank you for everyone answering my MySQL question. So, it appears that the situation is this, if I want to use Orion + JBuilder4: * PostgreSQL works fine except it isn't able to show tables in JBuilder * MySQL's EJB support doesn't work (and we need that!) * If we want to use Hypersonic we have to stop Orion while updating the db So, the question is, does SapDB work with our combination (has anyone used it with JBuilder and Orion)? I haven't really heard about it before, so how does it compare for example to MySQL and PostgreSQL? Regards, Peter __ Do You Yahoo!? Get email at your own domain with Yahoo! Mail. http://personal.mail.yahoo.com/
SAPdb
Hi all, Thank you all for ur advices on my RMI/IIOP support question... There is another area i need help... Assumption: we would have CMP beans I am reading about SAPdb, and since it claims to have transaction support and row level locking, (which some other open source databses seem to be lacking) i am inclined to show some interest in SAPdb. Now, has anyone here used SAPdb in any project environments? Is there any particular aspect(s) that i need to be wary of? PS: I am not considering oracle primarily because it's license fee... Any sort of comment on SAPdb or a viable alternative is highly appreciated. Thanks again, Jobin Thomas
Re: orion + jbuilder4 -- sapdb?
Randahl Fink Isaksen wrote: Thanks for your recommendation. We've thought about Interbase. I browsed through Borland's web pages which were really not that informative and I got an impression that *development* use with Interbase is free but *production* use would be under commercial license... That was why we didn't consider it at this time. Or was I totally wrong and Interbase is free for all uses? I am just exploring SapDB. Got the RPMs installed and I'm now browsing through the PDF documentation, which is a bit confusing (is there an HTML version somewhere of these docs? Acroread under Linux doesn't behave well with my Netscape). I cannot find a "beginner's tutorial" anywhere, I mean information like how to start / stop the service, how to start the gui and so on. Any help appreciated :) Cheers, Peter Hi Peter I have not read your original post, nor the replies. However, I just wanted to recommend using Interbase. If you want to use Borland JBuilder, it seems obvious to use Borland Interbase aswell - I am not completely up to speed with JBuilder, but I would expect that their own database product would have the best integration with their IDE. We have chosen Interbase because it is an old, high quality, reliable product from Borland. I have absolutely nothing against Postgre or MySQL, but the fact that Borland has released Interbase as a free open source product gives you free access to a database which has been through 15 years of professional development. Now, if anyone can mention a product which beats that I am all ears... In hopes I have not mentioned something, someone else already posted Randahl -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of Peter Peltonen Sent: 5. april 2001 10:17 To: Orion-Interest Cc: Jukka-Pekka Naukkarinen; Ilkka Suvanto Subject: orion + jbuilder4 -- sapdb? Thank you for everyone answering my MySQL question. So, it appears that the situation is this, if I want to use Orion + JBuilder4: * PostgreSQL works fine except it isn't able to show tables in JBuilder * MySQL's EJB support doesn't work (and we need that!) * If we want to use Hypersonic we have to stop Orion while updating the db So, the question is, does SapDB work with our combination (has anyone used it with JBuilder and Orion)? I haven't really heard about it before, so how does it compare for example to MySQL and PostgreSQL? Regards, Peter
RE: orion + jbuilder4 -- sapdb?
The only product that can beat it is Oracle, but that's not an option for everyone, because of the cost. Since there are so many good, free database products, such as Interbase, Postgresql, Mysql, SapDB, etc., you really can pick and choose. For the record, all of these databases have been around in some form or another for approximately fifteen years. Even mysql, which was formed as a company only five years ago, had the database product around ten years before that. Randy -Original Message- From: Randahl Fink Isaksen [mailto:[EMAIL PROTECTED]] Sent: Thursday, April 05, 2001 5:12 AM To: Orion-Interest Subject: RE: orion + jbuilder4 -- sapdb? Hi Peter I have not read your original post, nor the replies. However, I just wanted to recommend using Interbase. If you want to use Borland JBuilder, it seems obvious to use Borland Interbase aswell - I am not completely up to speed with JBuilder, but I would expect that their own database product would have the best integration with their IDE. We have chosen Interbase because it is an old, high quality, reliable product from Borland. I have absolutely nothing against Postgre or MySQL, but the fact that Borland has released Interbase as a free open source product gives you free access to a database which has been through 15 years of professional development. Now, if anyone can mention a product which beats that I am all ears... In hopes I have not mentioned something, someone else already posted Randahl -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of Peter Peltonen Sent: 5. april 2001 10:17 To: Orion-Interest Cc: Jukka-Pekka Naukkarinen; Ilkka Suvanto Subject: orion + jbuilder4 -- sapdb? Thank you for everyone answering my MySQL question. So, it appears that the situation is this, if I want to use Orion + JBuilder4: * PostgreSQL works fine except it isn't able to show tables in JBuilder * MySQL's EJB support doesn't work (and we need that!) * If we want to use Hypersonic we have to stop Orion while updating the db So, the question is, does SapDB work with our combination (has anyone used it with JBuilder and Orion)? I haven't really heard about it before, so how does it compare for example to MySQL and PostgreSQL? Regards, Peter
RE: orion + jbuilder4 -- sapdb?
No. AFAIK: Adabas belongs to Software AG, not to SAP. However, if you would say SapDB == Adabas D that would be correct. you can read more about it on www.sapdb.org -Original Message- From: Klaus Thiele [mailto:[EMAIL PROTECTED]] Sent: Thursday, April 05, 2001 2:46 PM To: Orion-Interest Subject: Re: orion + jbuilder4 -- sapdb? Hello, perhaps a little bit misplaced here... SAB DB == Adabas is this right? thanks klaus Am Donnerstag, 5. April 2001 14:01 schrieben Sie: I always like to pitch SapDB, because like Interbase, SAP DB, from [...] -- Klaus Thiele - Personal Informatik AG mailto:[EMAIL PROTECTED] "Your mouse has moved. Windows must be restarted for the change to take effect."
RE: orion + jbuilder4 -- sapdb?
I believe Interbase is totally free. For some reason Borland does not emphasize this very much - maybe to make sure people don't think it is a discount product. Interbase is released under a licence which besides the usual juristical mumbo jumbo says the following three important things: "grants You a world-wide, royalty-free, non-exclusive license" (...) "to use, reproduce, modify, display, perform, sublicense and distribute the Original Code (or portions thereof) with or without Modifications, and/or as part of a Larger Work;" (...) "under Patents Claims infringed by the making, using or selling of Original Code, to make, have made, use, practice, sell, and offer for sale, and/or otherwise dispose of the Original Code (or portions thereof)." And I feel sure that if it was not for these sentences there would not be an open source project based on Interbase called "Firebird" at http://firebird.sourceforge.net. - That's interesting by the way... when Interbase went open source Borland was slow on getting up to speed with the open source web community stuff, so the open source developers took the project elsewhere and renamed it "Firebird", which means that Borland has no control over what happens with the Firebird project. - Probably not what Borland expected at all. Now the developers at "Firebird" claim they have made a bunch of bug fixes which should be the reason to choose their product. Still, we are definately going to stick with Borland for now; after all they have many years of experience with developing the product, so having them control the open source effort somewhat might be a good thing. Hope this clarifies what Borland did not make obvious at their web site. Yours Randahl -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of Peter Peltonen Sent: 5. april 2001 15:05 To: Orion-Interest Subject: Re: orion + jbuilder4 -- sapdb? Randahl Fink Isaksen wrote: Thanks for your recommendation. We've thought about Interbase. I browsed through Borland's web pages which were really not that informative and I got an impression that *development* use with Interbase is free but *production* use would be under commercial license... That was why we didn't consider it at this time. Or was I totally wrong and Interbase is free for all uses? I am just exploring SapDB. Got the RPMs installed and I'm now browsing through the PDF documentation, which is a bit confusing (is there an HTML version somewhere of these docs? Acroread under Linux doesn't behave well with my Netscape). I cannot find a "beginner's tutorial" anywhere, I mean information like how to start / stop the service, how to start the gui and so on. Any help appreciated :) Cheers, Peter Hi Peter I have not read your original post, nor the replies. However, I just wanted to recommend using Interbase. If you want to use Borland JBuilder, it seems obvious to use Borland Interbase aswell - I am not completely up to speed with JBuilder, but I would expect that their own database product would have the best integration with their IDE. We have chosen Interbase because it is an old, high quality, reliable product from Borland. I have absolutely nothing against Postgre or MySQL, but the fact that Borland has released Interbase as a free open source product gives you free access to a database which has been through 15 years of professional development. Now, if anyone can mention a product which beats that I am all ears... In hopes I have not mentioned something, someone else already posted Randahl -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of Peter Peltonen Sent: 5. april 2001 10:17 To: Orion-Interest Cc: Jukka-Pekka Naukkarinen; Ilkka Suvanto Subject: orion + jbuilder4 -- sapdb? Thank you for everyone answering my MySQL question. So, it appears that the situation is this, if I want to use Orion + JBuilder4: * PostgreSQL works fine except it isn't able to show tables in JBuilder * MySQL's EJB support doesn't work (and we need that!) * If we want to use Hypersonic we have to stop Orion while updating the db So, the question is, does SapDB work with our combination (has anyone used it with JBuilder and Orion)? I haven't really heard about it before, so how does it compare for example to MySQL and PostgreSQL? Regards, Peter
RE: orion + jbuilder4 -- sapdb?
I just checked out the sourceforge site for interbase...there doesn't seem to be anything there. There are not files to download, nor is the cvs available. Firebird seems to be available, but is not the Borland distribution. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of Randahl Fink Isaksen Sent: Thursday, April 05, 2001 8:28 AM To: Orion-Interest Subject: RE: orion + jbuilder4 -- sapdb? I believe Interbase is totally free. For some reason Borland does not emphasize this very much - maybe to make sure people don't think it is a discount product. Interbase is released under a licence which besides the usual juristical mumbo jumbo says the following three important things: "grants You a world-wide, royalty-free, non-exclusive license" (...) "to use, reproduce, modify, display, perform, sublicense and distribute the Original Code (or portions thereof) with or without Modifications, and/or as part of a Larger Work;" (...) "under Patents Claims infringed by the making, using or selling of Original Code, to make, have made, use, practice, sell, and offer for sale, and/or otherwise dispose of the Original Code (or portions thereof)." And I feel sure that if it was not for these sentences there would not be an open source project based on Interbase called "Firebird" at http://firebird.sourceforge.net. - That's interesting by the way... when Interbase went open source Borland was slow on getting up to speed with the open source web community stuff, so the open source developers took the project elsewhere and renamed it "Firebird", which means that Borland has no control over what happens with the Firebird project. - Probably not what Borland expected at all. Now the developers at "Firebird" claim they have made a bunch of bug fixes which should be the reason to choose their product. Still, we are definately going to stick with Borland for now; after all they have many years of experience with developing the product, so having them control the open source effort somewhat might be a good thing. Hope this clarifies what Borland did not make obvious at their web site. Yours Randahl -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of Peter Peltonen Sent: 5. april 2001 15:05 To: Orion-Interest Subject: Re: orion + jbuilder4 -- sapdb? Randahl Fink Isaksen wrote: Thanks for your recommendation. We've thought about Interbase. I browsed through Borland's web pages which were really not that informative and I got an impression that *development* use with Interbase is free but *production* use would be under commercial license... That was why we didn't consider it at this time. Or was I totally wrong and Interbase is free for all uses? I am just exploring SapDB. Got the RPMs installed and I'm now browsing through the PDF documentation, which is a bit confusing (is there an HTML version somewhere of these docs? Acroread under Linux doesn't behave well with my Netscape). I cannot find a "beginner's tutorial" anywhere, I mean information like how to start / stop the service, how to start the gui and so on. Any help appreciated :) Cheers, Peter Hi Peter I have not read your original post, nor the replies. However, I just wanted to recommend using Interbase. If you want to use Borland JBuilder, it seems obvious to use Borland Interbase aswell - I am not completely up to speed with JBuilder, but I would expect that their own database product would have the best integration with their IDE. We have chosen Interbase because it is an old, high quality, reliable product from Borland. I have absolutely nothing against Postgre or MySQL, but the fact that Borland has released Interbase as a free open source product gives you free access to a database which has been through 15 years of professional development. Now, if anyone can mention a product which beats that I am all ears... In hopes I have not mentioned something, someone else already posted Randahl -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of Peter Peltonen Sent: 5. april 2001 10:17 To: Orion-Interest Cc: Jukka-Pekka Naukkarinen; Ilkka Suvanto Subject: orion + jbuilder4 -- sapdb? Thank you for everyone answering my MySQL question. So, it appears that the situation is this, if I want to use Orion + JBuilder4: * PostgreSQL works fine except it isn't able to show tables in JBuilder * MySQL's EJB support doesn't work (and we need that!) * If we want to use Hypersonic we have to stop Orion while updating the db So, the question is, does SapDB work with our combination (has anyone used it with JBuilder and Orion)? I haven't really heard about it before, so how does it compare for example to MySQL and PostgreSQL? Regards, Peter
Re: SAPDB experience and Datasource
At 00:44 23.02.2001 , you wrote: Hello, I'd be interested in hearing the experiences from people who used SAPDB with Orion CMP in terms of stability and performance on both linux and nt. SAPDB on linux in development for a little more than 3 months now and everything works fine. performance and stability is good. planning to go in production 4 weeks from now. data-source class="com.evermind.sql.ConnectionDataSource" inactivity-timeout="120" location="jdbc/SAPTestDBDS" name="SAPTest data-source" xa-location="jdbc/xa/SAPTestXADS" ejb-location="jdbc/SAPTestEJBDS" url="jdbc:sapdb://host/DBNAME" connection-driver="com.sap.dbtech.jdbc.DriverSapDB" username="SOMEUSER" password="SOMEPWD" / Also if you have them available, can you share your database-schema ? no special schema but we're not using the autocreate-tables feature anyway. Thanks, Christian (-) Robert Krger (-) SIGNAL 7 Gesellschaft fr Informationstechnologie mbH (-) Brder-Knau-Str. 79 - 64285 Darmstadt, (-) Tel: 06151 665401, Fax: 06151 665373 (-) [EMAIL PROTECTED], www.signal7.de
SAPDB experience and Datasource
Hello, I'd be interested in hearing the experiences from people who used SAPDB with Orion CMP in terms of stability and performance on both linux and nt. Also if you have them available, can you share your database-schema ? Thanks, Christian