Thread View: borland.public.cppbuilder.database.multi-tier
4 messages
4 total messages
Started by fang
Tue, 21 Sep 1999 00:00
Multi connection to database
Author: fang
Date: Tue, 21 Sep 1999 00:00
Date: Tue, 21 Sep 1999 00:00
4 lines
715 bytes
715 bytes
I met problems when I dynamiliclly create TSessions and TDatabase to query one database. The first database works well, but when set Connected = true for second database, it does not work. So what should I do?
Re: Multi connection to database
Author: J�r�me Piquot
Date: Tue, 21 Sep 1999 00:00
Date: Tue, 21 Sep 1999 00:00
22 lines
1243 bytes
1243 bytes
what do you mean by do not work? do you have an error message? -- ----------------------------------------------------------------- PIQUOT J�r�me A. WOLFF SA 6, rue de la Gare 67120 ERNOLSHEIM/BRUCHE FRANCE e-mail: wolff@media-net.fr http://www.media-net.fr/wolff ----------------------------------------------------------------- fang <fang@singstar.com.sg> a �crit dans le message : 7s7kt8$nru8@forums.borland.com... > I met problems when I dynamiliclly create TSessions and TDatabase to query > one database. The first database works well, > but when set Connected = true for second database, it does not work. So what > should I do? > >
Re: Multi connection to database
Author: fang
Date: Wed, 22 Sep 1999 00:00
Date: Wed, 22 Sep 1999 00:00
42 lines
1913 bytes
1913 bytes
I can make the database connections work now. But other problems arrise: The program act as a server to listen connection from remote senders. For each seperate connection, at start time, the program create a new thread which then creates a new database and asession, then update database according to the received data. Then disconnect from the database and destory the session. The problem is, the program can not responsible in time because create and connect database and session is quite slow. Fang J�r�me Piquot <wolff@media-net.fr> wrote in message news:7s7u54$rkr4@forums.borland.com... > what do you mean by do not work? do you have an error message? > > -- > > ----------------------------------------------------------------- > PIQUOT J�r�me > A. WOLFF SA > 6, rue de la Gare > 67120 ERNOLSHEIM/BRUCHE > FRANCE > e-mail: wolff@media-net.fr > http://www.media-net.fr/wolff > ----------------------------------------------------------------- > fang <fang@singstar.com.sg> a �crit dans le message : > 7s7kt8$nru8@forums.borland.com... > > I met problems when I dynamiliclly create TSessions and TDatabase to query > > one database. The first database works well, > > but when set Connected = true for second database, it does not work. So > what > > should I do? > > > > > >
Re: Multi connection to database
Author: J�r�me Piquot
Date: Wed, 22 Sep 1999 00:00
Date: Wed, 22 Sep 1999 00:00
61 lines
2558 bytes
2558 bytes
dont create TDatabase for each thread then, create the connection in main thread and share it for child threads. -- ----------------------------------------------------------------- PIQUOT J�r�me A. WOLFF SA 6, rue de la Gare 67120 ERNOLSHEIM/BRUCHE FRANCE e-mail: wolff@media-net.fr http://www.media-net.fr/wolff ----------------------------------------------------------------- fang <fang@singstar.com.sg> a �crit dans le message : 7s9iki$bvs2@forums.borland.com... > I can make the database connections work now. But other problems arrise: > > The program act as a server to listen connection from remote senders. For > each seperate connection, at start time, the program create a new thread > which then creates a new database and asession, then update database > according to the received data. Then disconnect from the database and > destory the session. > > The problem is, the program can not responsible in time because create and > connect database and session is quite slow. > > Fang > > > > J�r�me Piquot <wolff@media-net.fr> wrote in message > news:7s7u54$rkr4@forums.borland.com... > > what do you mean by do not work? do you have an error message? > > > > -- > > > > ----------------------------------------------------------------- > > PIQUOT J�r�me > > A. WOLFF SA > > 6, rue de la Gare > > 67120 ERNOLSHEIM/BRUCHE > > FRANCE > > e-mail: wolff@media-net.fr > > http://www.media-net.fr/wolff > > ----------------------------------------------------------------- > > fang <fang@singstar.com.sg> a �crit dans le message : > > 7s7kt8$nru8@forums.borland.com... > > > I met problems when I dynamiliclly create TSessions and TDatabase to > query > > > one database. The first database works well, > > > but when set Connected = true for second database, it does not work. So > > what > > > should I do? > > > > > > > > > > > >
Thread Navigation
This is a paginated view of messages in the thread with full content displayed inline.
Messages are displayed in chronological order, with the original post highlighted in green.
Use pagination controls to navigate through all messages in large threads.
Back to All Threads