It will not work.
WAS 3.0.2 & 3.0.2.1 will only support DB2 5.2 FP 10 and DB2 6.1 FP2 and
Oracle 8.0.5 with the specified Type 4 driver. It does NOT support SQL
Server for CMP beans.
Even with Oracle etc. it is very particular on the exact version of the JDBC
driver that is required.
-- Aravind
> -----Original Message-----
> From: A mailing list for Enterprise JavaBeans development
> [mailto:[EMAIL PROTECTED]]On Behalf Of Arul
> Sent: Tuesday, 8 August 2000 23:31
> To: [EMAIL PROTECTED]
> Subject: help needed from websphere xperts
>
>
> Hello
>
> I am now trying to connect Webpshere with Sql server .Ibm Book states that
> only BMP is possible..not CMP..
>
> I tried to connect CMP with SQL Server.
> everything went on fine..
>
> what i did was
> 1)As Websphere supports on jdk1.1.7 i downloaded a type IV driver
> which also
> supports jdk1.1.7
>
> 2)Create a JDBC Driver by providing the Implementation class and
> URL Prefix
> as given in the read me file of the driver
> 3)There was no prob in creating the driver
> 4)Then Create the datasource with this driver
> 5)Install the JDBC Driver in the toplogy of the default container and set
> the datasource of the container as the one which was installed now
> 6) Deploy the Increment CMP Bean in the default container
> 7)When the Container is started the following exception occured
>
> []Login failed for user '(null)'. Reason: Not associated with a
> trusted SQL
> Server connection.java.sql.SQLException: []Login failed for user '(null)'.
> Reason: Not associated with a trusted SQL Server connection.
>
> this gave the hope to me that some thing is cheeking for the
> username of sql
> server.
> 8)So in the user id column i gave as "sa" and when i again started the
> default container the error was
>
> Incorrect syntax near the keyword 'count'.java.sql.SQLException:
> [ARULKUMAR]Incorrect syntax near the keyword 'count'.
>
> --------
> com.ibm.ejs.sm.client.command.ExecutionException: Command default.start
> Sub-command Error.
>
> at com.ibm.ejs.sm.client.command.AbstractCommand.handleAct(Compiled Code)
>
> at
> com.ibm.ejs.sm.client.command.StartCommand.execute(StartCommand.java:93)
>
> at
> com.ibm.ejs.sm.client.command.CommandManager$ExecutionThread.run(C
> ommandMana
> ger.java:282)
>
>
> I havent used anything like count in my program .So wheres the
> error from???
> I believe that the StartCommand of websphere contains the java
> program which
> has something called a count and thats creating the error.
>
> any body knows How can that be rectified???
>
> Arul
>
> ==================================================================
> =========
> To unsubscribe, send email to [EMAIL PROTECTED] and include
> in the body
> of the message "signoff EJB-INTEREST". For general help, send email to
> [EMAIL PROTECTED] and include in the body of the message "help".
>
>
===========================================================================
To unsubscribe, send email to [EMAIL PROTECTED] and include in the body
of the message "signoff EJB-INTEREST". For general help, send email to
[EMAIL PROTECTED] and include in the body of the message "help".
