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]
