글쓴이 :강신동 1998년 9월 09일 08:59:35
In Reply to: Connetion POOL로 해결합니다. posted by 윤지수 on 1998년 9월 08일 22:19:21:
안녕하세요 강신동입니다.
아래는 sybase에서 온 답변입니다.
multithread를 지원한다고 합니다.
Pool을 사용하지 않더라도 가능한 일이라고 합니다.
아래의 글은 sybase의 JDBC driver인 jConnect4.0에 대한
글입니다. 관심있으신분께서는 참고하시기 바랍니다.
Yes, this is a very good example of how JDBC can be used in a
web-server. You mentioned the work Transaction - as long as you
understand that every query executed on this connection shares
the same transaction context then this is fine.
By default JDBC starts in AUTOCOMMIT mode, so every query you
execute is committed immediately. If you change the transaction
mode to CHAINED, or if one of the queries does a "BEGIN TRANSACTION"
command, then you will have problems where queries executed on
one statement for one http request may interfer with queries
executed on other statements - because they all share the same
transaction.
dave
Kahng Shin Dong wrote:
>
> Hi.
>
> Example code is below:
> public SQLServlet extends HttpServlet
> {
> public static Connection con = null;
> static
> {
> con =
> DriverManager.getConnection("jdbc:sybase:Tds:sqlserver:port","user","password");
>
> }
> public void doGet(HttpServletRequest req, HttpServletResponse res)
> throws .....Exception
> {
> Statement stmt = con.createStatement();
> // query sql and execute sql using already created connection,
> }
> }
>
> This is possible, but has no problem ?
>
> Then , has no problem for Statement ?
>
> If possible and no problem, sql tranaction processes with high
> performance.....
>
> Thanks a lot. happy day to you.