The result of the query is "INTERNAL", as I suposed. We don�t use
DriverManager directly, because the url connection is defined in the JNDI
space of WebSphere. This url contains "...?sqlmode=oracle", but may
WebSphere cuts this piece of the url ?.
I think, fixing this property in the url connection is the only way to set
the desired sqlmode, is it correct?
Ignacio Lacosta.
"Schroeder, Alexander" <[EMAIL PROTECTED]> con fecha 01/12/2003
16.23.54
Destinatarios: Ignacio Lacosta/RIU/ES, [EMAIL PROTECTED]
CC:
Asunto: RE: Setup SAPDB as DB for WebSphere
If you use the JDBC 2.0 interfaces (DriverManager, with connect URL),
this should work. Are you sure that the option comes through to the
driver? You may do a
SELECT A.SQLMODE AS SQLMODE
FROM SHOW_CONNECT_PARAM A, SHOW_USER_CONNECTED B, SHOW_USER_CURRENT C
WHERE A.SESSION=B.SESSION AND B.USERNAME=C.USERNAME
from your application and it should say "ORACLE". If not it maybe lost
somewhere in the web sphere :-)
Regards
Alexander Schr�der
SAP DB, SAP Labs Berlin
> -----Original Message-----
> From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]
> Sent: Monday, December 01, 2003 2:58 PM
> To: [EMAIL PROTECTED]
> Subject: Setup SAPDB as DB for WebSphere
>
>
> Hello,
>
> we are building an web application for WebSphere and SAP DB. Our first
> version did not use connection pool.
>
> Now, we are triying to setup WebSphere for this. We defined the DB in
> WebSphere (i think correctly and in "custom properties" fro
> the DataSource
> we wrote some like this:
> "jdbc:sapdb://192.168.244.6/webrpc?sqlmode=oracle".
>
> The problem is when the applicatio uses some function of ORACLE, like
> TO_CHAR... It seems that the connection does not use the property
> "sqlmode".
>
> Any experience with this issue ?
>
> Thanks
>
> Ignacio Lacosta
>
>
>
> --
> MaxDB Discussion Mailing List
> For list archives: http://lists.mysql.com/maxdb
> To unsubscribe:
http://lists.mysql.com/[EMAIL PROTECTED]
--
MaxDB Discussion Mailing List
For list archives: http://lists.mysql.com/maxdb
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
