RE: SapDB

[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 

Re: too many clients error

[Thomas Sundberg]

Hi!

How many simultanious clients are you allowed to have connected to you
database? The error you are receiving hints about a problem like that.

/Thomas

Seung Bang wrote:
 
 Hello!
 
 I am having a SQLException with an orion message saying "Sorry, too many
 clients already."
 What on earth is that supposed to mean
 The beans work for the first several times and stop working all of a
 sudden, producing the error.
 I was testing the beans with PostgreSQL on Linux.
 Any clue? Here is the portion of the error message:
 Thank you very much.
 
 Seung
 
 Something unusual has occured to cause the driver to fail. Please report
 this exception: java.sql.SQLException: Sorry, too many clients already
  at org.postgresql.Driver.connect(Driver.java:125)
  at com.evermind.sql.DriverManagerDataSource.getConnection(JAX)
  at
 com.evermind.sql.DriverManagerConnectionPoolDataSource.getPooledConnection(JAX)
 
  at com.evermind.sql.OrionPooledDataSource.eh(JAX)
  at com.evermind.sql.OrionPooledDataSource.d3(JAX)
  at com.evermind.sql.OrionPooledDataSource.getConnection(JAX)
  at com.evermind.sql.DriverManagerXADataSource.ep(JAX)
  at com.evermind.sql.aj.em(JAX)
  at com.evermind.sql.an.prepareStatement(JAX)
  at com.evermind.sql.an.prepareStatement(JAX)
  at
 com.freightstream.ejb.BookingStatusBean.ejbCreate(BookingStatusBean.java:159)
 
  at
 
BookingStatusHome_EntityHomeWrapper19.create(BookingStatusHome_EntityHomeWrapper19.java:289)
 
  at
 com.freightstream.ejb.EJBManagerBean.addBookingStatus(EJBManagerBean.java:150)
 
  at
 
EJBManager_StatelessSessionBeanWrapper11.addBookingStatus(EJBManager_StatelessSessionBeanWrapper11.java:858)
 
  at
 com.freightstream.servlet.BookingStatusAdd.service(BookingStatusAdd.java:40)
 
  at javax.servlet.http.HttpServlet.service(HttpServlet.java)
  at com.evermind.server.http.d1.si(JAX)
  at com.evermind.server.http.d1.forward(JAX)
  at com.evermind.server.http.ed.sp(JAX)
  at com.evermind.server.http.ed.so(JAX)
  at com.evermind.util.f.run(JAX)
 ..
 ...

-- 
Thomas Sundberg
Goyada AB
Kontoret: 08 - 555 17 200  Office:   +46 8 555 17 200
Direkt:   08 - 555 17 232  Direct:   +46 8 555 17 232
Mobil:070 - 453 11 36  Cellular: +46 70 453 11 36  
mailto:[EMAIL PROTECTED]
http://www.goyada.com