"Halas, Miroslav" wrote:
>
> (Pardon my inexperience with databases 8-)
> What is a good value for
> jdbc.connteststmt
> in datasource definition file for DB2 (IBM DB2 UDB 7.1). The default "select
> 1" doesn't work.
> I haven't tested Sybase yet but I ask now in case it doesn't work 8-). How
> about Sybase 12 ASE (if I ever get past install, it already crashed on me
> twice).
>
> Thanks in advance,
>
> Miro Halas
> ----
> To unsubscribe, send email to [EMAIL PROTECTED] and
> include in the body of the message "unsubscribe jonas-users".
> For general help, send email to [EMAIL PROTECTED] and
> include in the body of the message "help".
There is an easy way to bypass this problem:
Choose
jdbc.connchecklevel 0
in your .properties file: In that case, the "select 1" will not be used.
The idea behind jdbc.connteststmt is to give a statement as simple as
possible that does nothing on your database, but that can check that the
connection is still OK. Refer to the Sybase manual to find an SQL
statement
more appropriate.
As exemples, you have for
Oracle: select * from dual
InstantDB: set date format "yyyy/mm/dd"
Postgres: select 1
Sybase: ???
DB2: ???
If you find something smart to do in these 2 cases, I'm interested.
Actually, this statement is used only if jdbc.connchecklevel > 1.
Thanks in advance.
--
Philippe Durieux ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Bull - 1 rue de Provence - 38432 Echirolles Cedex France
[EMAIL PROTECTED]
-> Download our EJBServer at http://www.evidian.com/ejb <-
----
To unsubscribe, send email to [EMAIL PROTECTED] and
include in the body of the message "unsubscribe jonas-users".
For general help, send email to [EMAIL PROTECTED] and
include in the body of the message "help".
