Error in Sender JDBC communication channel

[Former Member]

Hi All,

I configured my sender communication channel as follows

For SQL Server 2005 driver,

Driver class: com.microsoft.sqlserver.jdbc.SQLServerDriver

URL :jdbc:sqlserver://<db_Server>:port;databaseName=<db_name>

but I am getting error follows

Exception caught during JDBC adapter processing: java.lang.NullPointerException

what it is?

regards

Rams

[Former Member]

Thanks to all

agaian re installed drivers....

regards

rams

[Former Member]

This error could be because of wrong configuration. Check the Port, and DataBase name (this is case sensitive). Under URL use ip address rather using server name.

[Former Member]

Ya..sarvesh I used server ip address only instead of server name...

[Former Member]

I think apart from adapter configuration you should also chek if the firewall settings are open to allow the communication and also make sure that Database is up & running.

[Former Member]

HI,

Make sure your userName,password are correct.

Also check proper drivers for SQL Server is deployed in J2EE using SDM.

Thanks and regards,

Sasi

[Former Member]

Hi,

you have:

com.microsoft._sqlserver.jdbc_.SQLServerDriver

but it has to be:

com.microsoft._jdbc.sqlserver_.SQLServerDriver

edit:

and it has also to be like this, not like yours:

jdbc:microsoft:sqlserver://<host>:<port>;databaseName=<name>

see the difference?

try again and it should work.

let me know,

regards christian

[Former Member]

Hi christian

Ya..i tried in that way also... I followed SAP note for the same but i am getting same error.

Driver class names for SQL Server 2000 driver and SQL Server

2005 driver are different.

If you are using SQL Server 2005 driver, then class name should be

as follows:

Driver class: com.microsoft.sqlserver.jdbc.SQLServerDriver

URL :jdbc:sqlserver://<db_Server>:port;databaseName=<db_name>

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

as follows:

Driver class: com.microsoft.jdbc.sqlserver.SQLServerDriver

and URL is as follows:

jdbc:microsoft:sqlserver://<db_server>:port;databaseName=<db_name>

Regards

Rams

[Former Member]

Hi Rams,

try looking into the runtime workbench, check the adapters, if they fail.

there must be a log somewhere with detailed information why the adapter is crashing.

(if its a adapter problem)

Regards

chris