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(CommandMana
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".
