SapDB

2001-12-15 Thread Namor Taror

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

2001-12-15 Thread Thomas Sundberg


 -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

2001-05-14 Thread Joni Suominen

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)

2001-05-14 Thread Joni Suominen

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?

2001-04-05 Thread Peter Peltonen


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?

2001-04-05 Thread Randahl Fink Isaksen

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?

2001-04-05 Thread Ray Harrison

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

2001-04-05 Thread jthomas

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?

2001-04-05 Thread Peter Peltonen

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?

2001-04-05 Thread Kemp Randy-W18971

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?

2001-04-05 Thread Kiss Tibor

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?

2001-04-05 Thread Randahl Fink Isaksen

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?

2001-04-05 Thread elephantwalker

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

2001-02-23 Thread Robert Krueger

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

2001-02-22 Thread Christian Billen

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