RFC- JDBC error

[former_member869]

Hello Experts,

My Scenario is RFC-JDBC where I am getting an error in RWB as

:Error when executing statement for table/stored proc. 'GRN_Header' (structure 'Statement_1'):

java.sql.SQLException: [Microsoft][SQLServer 2000 Driver for JDBC][SQLServer]Invalid object name 'GRN_Header'..

DB team are maintaining two tables which is Header and Item.

GRN_Header is the table name which i have maintained in PI 7.1.

Please Suggest.

[former_member184720 · Accepted solution]

If you are sure that the table is available then i would suggest you cross check your channel configuration. Especially the database name.

If you are using SQL Server 2000 driver , then class name should be as follows:

Driver class	:	com.microsoft.jdbc.sqlserver.SQLServerDriver
URL	:	jdbc:microsoft:sqlserver://<db_server>:port;databaseName=<db_name>

Also you can even check if the table is available or not from ESR.

Importing Table Structures from a Database - Enterprise Services Repository - SAP Library

Message was edited by: Hareesh Gampa

[nabendu_sen]

Hi,

Check the suggestion from Anshul:

The connection string looks like: jdbc:microsoft:sqlserver://XXXXXX:PortNo;DatabaseName=XYZ

Also check if your table is associated with a schema name. In this case it will be like <Table>SchemaName.TableName</Table>

If you want to try:

Regards,

Nabendu.

[former_member869]

Hi All,

Thanks for your reply,as Hareesh said the problem was due to incorrect database name.

Regards,

Rama

[iaki_vila]

Hi Ramashis,

Are you sure that the DB table doesn't have a schema?,to make the call like myschema.GRN_Header.

Regards.

[former_member869]

Hi Inaki,

DB team are maintaining a schema called dbo.GRN_Header.

Regards,

Rama