Rajesh,
After extractint the jConnect zip file you should
have an 'sp' directory. Run sp_SQLServer.sql against
your database while logged in as sa. Some thing like
isql -S <server-name> -D <database-name> -U sa -P
<password> sp_sqlserver.sql
If you don't have sa rights have your dba run it for
you.
--- Rajesh Jha <[EMAIL PROTECTED]> wrote:
> Help
>
> Hi All
>
> Again i have the same problem. I have downloaded
> jconnect4-2/5-2 and
> installed properly. When i am trying to install
> stored procedure it gives
> error.
> <"Comamnd and Output">
>
> C:\jConnect-4_2\classes>java IsqlApp -U webLogic -P
> weblogic -S
> jdbc:syabse:Tds:10.100.11.32:5000 -I
> ..\sp\sql_server.sql -c go
> Unexpected exception : SqlState: 08001
> java.sql.SQLException: No suitable
> driver, ErrorCode: 0
>
> <"Command and output">
>
> When i am trying to invoke finderMethods it gives
> the following error in
> console.
>
> javax.ejb.FinderException: Exception preparing or
> executing statement:
> 'select HUserKeyValue, HUserId, HCreateDt,
> HLastChangeDt, HLastArchivedDt,
> HNewUser, HEnableUser, HContact from HLoginUser
> where (HUserId = ?)'
> java.sql.SQLException: JZ0SJ: Metadata accessor
> information was not found on
> this database. Please install the required tables as
> mentioned in the
> jConnect documentation.
>
> In the above select statement where (HUserId=?)
>
> why it is showing '?' I am passing HUserId
> Correctly.
>
> Thanx
> Rajesh
>
>
===========================================================================
> 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".
>
__________________________________________________
Do You Yahoo!?
Send instant messages with Yahoo! Messenger.
http://im.yahoo.com/
===========================================================================
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".
