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
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