Problem at JDBC driver installation

[Former Member]

Hi,

In a scenario File&HTTP&mail to JDBC scenario, am getting Error at JDBC adapter.If i see the status of the adapter in the adapter monitoring,it is showing as.... "Receiver Adapter v1027 for Party '', Service 'MSR_SQLSERVER_BS':

Configured at 06:57:35 2006-05-16

Last message processing started 07:00:55 2006-05-16, Error: Accessing database connection 'jdbc:microsft:sqlserver://igtehyd511531:1433;tempdb' failed: java.sql.SQLException: No suitable driver

Addtional information: JDBC driver 'com.microsoft.jdbc.sqlserver.SQLServerDriver' loaded successfully, additional driver information:

Available JDBC drivers:

No deployed JDBC Drivers found

"........

we are using SQL server.For the abopve problem i have installed or deployed SQL server drivers in the sda file aii_af_jmsproviderlib and updated provider.xml file.It was shown a message 3 jar files deployed succesfully.I restarted the server too...

can any body help me in this regard, why it is showing No deployed JDBC drivers found..

Rgds

MSR

[Former Member]

Hi Shridhar,

Please can you have a look at this thread.

Please check on your connection parameter.

Regards

Vijaya

[Former Member]

Hi,

I have already deployed these drivers (msbase.jar, mssqlserver.jar, msutil.jar) and provider.xml file.

Rgds

MSR

[bhavesh_kantilal]

Sridhar,

The error clearly states that the driver has not been found whicbh implies XI is not able to detect the driver even if it has been installed.

just ccheck the intallation procedure against this guide and see if this is what you have done,

https://www.sdn.sap.com/irj/servlet/prt/portal/prtroot/docs/library/uuid/3867a582-0401-0010-6cbf-964...

Regards,

Bhavesh

[Former Member]

Hi bhavesh,

The same document i have followed to install external drivers.Is there any other document for the same.

Rgds

MSR

[bhavesh_kantilal]

Sridhar,

That is an official SAP document and is perfectly correct. Would suggest you try to do this same procedure again. Might have missed something.

Regards,

Bhavesh

[Former Member]

Hi,

Now it is showing the Message... "Processing Error: Accessing database connection 'jdbc:microsft:sqlserver://192.168.239.99:1433;tempdb' failed: java.sql.SQLException: No suitable driver

Addtional information: JDBC driver 'com.microsoft.jdbc.sqlserver.SQLServerDriver' loaded successfully, additional driver information:

Available JDBC drivers:

com.microsoft.jdbc.sqlserver.SQLServerDriver, 2.2 JDBC compliant"....

can any body suggest me ,is there any version issues.In visual admin log it is showing as

.....

"Accessing database connection 'jdbc:microsft:sqlserver://192.168.239.99:1433;tempdb' failed:

java.sql.SQLException: No suitable driver

at java.sql.DriverManager.getConnection(DriverManager.java:532)

at java.sql.DriverManager.getConnection(DriverManager.java:171)

at com.sap.aii.adapter.jdbc.XI2JDBC.connectDB(XI2JDBC.java:482)

at com.sap.aii.adapter.jdbc.XI2JDBC.init(XI2JDBC.java:451)

at com.sap.aii.adapter.jdbc.AdminAdapter.addAdapter(AdminAdapter.java:95)

at com.sap.aii.adapter.jdbc.AdminAdapter.channelAdded(AdminAdapter.java:167)

at com.sap.aii.af.service.cpa.impl.callback.CallbackManager.performChannelCallback(CallbackManager.java:217)

at com.sap.aii.af.service.cpa.impl.cache.directory.DirectoryDataSAXHandler.endDocument(DirectoryDataSAXHandler.java:1136)

at com.sap.engine.lib.xml.parser.handlers.SAXDocHandler.endDocument(SAXDocHandler.java:236)

at com.sap.engine.lib.xml.parser.XMLParser.scanDocument(XMLParser.java:2713)

at com.sap.engine.lib.xml.parser.XMLParser.parse0(XMLParser.java:162)

at com.sap.engine.lib.xml.parser.AbstractXMLParser.parseAndCatchException(AbstractXMLParser.java:126)

at com.sap.engine.lib.xml.parser.AbstractXMLParser.parse(AbstractXMLParser.java:136)

at com.sap.engine.lib.xml.parser.AbstractXMLParser.parse(AbstractXMLParser.java:209)

at com.sap.engine.lib.xml.parser.Parser.parseWithoutSchemaValidationProcessing(Parser.java:270)

at com.sap.engine.lib.xml.parser.Parser.parse(Parser.java:331)

at com.sap.engine.lib.xml.parser.SAXParser.parse(SAXParser.java:125)

at javax.xml.parsers.SAXParser.parse(SAXParser.java:345)

at javax.xml.parsers.SAXParser.parse(SAXParser.java:143)

at com.sap.aii.af.service.cpa.impl.cache.directory.DirectoryDataParser.updateCentralCache(DirectoryDataParser.java:54)

at com.sap.aii.af.service.cpa.impl.cache.CacheManager.updateCacheWithDirectoryData(CacheManager.java:713)

at com.sap.aii.af.service.cpa.impl.cache.CacheManager.performCacheUpdate(CacheManager.java:595)

at com.sap.aii.af.service.cpa.impl.cache.CacheManager$CacheUpdateRunnable.run(CacheManager.java:440)

at com.sap.engine.frame.core.thread.Task.run(Task.java:60)

at com.sap.engine.core.thread.impl5.SingleThread.execute(SingleThread.java:73)

at com.sap.engine.core.thread.impl5.SingleThread.run(SingleThread.java:145)

Additional information: JDBC driver 'com.microsoft.jdbc.sqlserver.SQLServerDriver' loaded successfully, additional driver information:

Available JDBC drivers:

com.microsoft.jdbc.sqlserver.SQLServerDriver, 2.2 JDBC compliant"......

I have installed all drivers msbase.jar;mssqlserver.jar;msutil.jar; on XI server.

Note:-with the help of these jar file i have tested in java.

Message was edited by: sridhar raju

[Former Member]

Hi Sridhar,

For incompatibility refer to notes: 831162 Q18

and then note: 941317

Regards

Vijaya