local + remote access simultaneously

[James]

I'm connecting to a db locally.

The user has the choice to start the TCPJDBCServer, so that other users can
connect remotely. The TCPJDBCServer is started with the session from the
local connection.



My Question: Is it safe, to keep on using the local connection
simultaneously or do I have to close the local connection and start a
TCP-connection via localhost?



Thank you in advance



James

[Tobias Downer]

Hi James,

It is safe to continue using the local connection simultaneously with
the remote server function. However, there are differences between
using the local connection and the remote connection. Specifically, the
limitation on the number of concurrent requests does not apply to the
local connection. I would recommended the local connection only be used
for managing the setup, initialization and shutdown of the database in
this sort of setup, and unify everything else through the JDBC TCP
connection. This will avoid any potential problems that arise out of
the differences.

However, ultimately all the requests end up going through the same code
regardless of whether it is via the local or network connection when
using the Control API like this.

Toby.

Post by James
I'm connecting to a db locally.
The user has the choice to start the TCPJDBCServer, so that other users
can connect remotely. The TCPJDBCServer is started with the session from
the local connection.
My Question: Is it safe, to keep on using the local connection
simultaneously or do I have to close the local connection and start a
TCP-connection via localhost?

---------------------------------------------------------------
Mckoi SQL Database mailing list http://www.mckoi.com/database/
To unsubscribe, send a message to mckoidb-***@mckoi.com