UD Connect : Class DriverName is not found

[Former Member]

Hi,

We have configued to connect MSSQL DB which is on windows machine from our BI application which is running on AS400 box using UD connect.

We have completed all the steps but when we do the connection test using http://<server>:<port>/TestJDBC_Web/TestJDBCPage.jsp we are facing Class driver not found error.

Caused by: com.sap.ip.bi.sdk.exception.BIResourceException: Class DriverName is not found

at java.lang.Throwable.(Throwable.java:194)

at java.lang.Exception.(Exception.java:41)

at javax.resource.ResourceException.(ResourceException.java:73)

at com.sap.ip.bi.sdk.exception.BIResourceException.(BIResourceException.java:86)

at com.sap.ip.bi.sdk.dac.connector.jdbc.impl.Connection.connectDB(Connection.java:314)

at com.sap.ip.bi.sdk.dac.connector.jdbc.impl.Connection.connect(Connection.java:99)

at com.sap.ip.bi.sdk.dac.connector.jdbc.JdbcManagedConnection.(JdbcManagedConnection.java:118)

... 22 more

Caused by: java.lang.ClassNotFoundException: com.microsoft.sqlserver.jdbc.SQLServerDriver

Found in negative cache

I have few doubts here, after we configured the jdbc type 4 driver in visual admin, we could see sqljdbc.jar(driver file) being copied to two locations - 1. \usr\sap\<SID>\DVEBMGSXX\j2ee\cluster\server0\temp\dbpool

2. \usr\sap\<SID>\DVEBMGSXX\j2ee\cluster\server0\bin\ext\MSSQL

The file t location is hs size equl to original driver file but the file at location 2 is of size zero.

I want to get clarified wht is the significance of these two locations and if we have to set CLASSPATH on as400 server which patch from the above needs to be considered.

COuld you kindly help us in resolving this isse

regards,

Brahmeshwar

Edited by: Poloju on Aug 19, 2010 1:02 PM

[Former Member]

Gurus,

Any suggestions, pls

Regards,

Brahmeshwar

[former_member208578]

hello Brahmeshwar,

i am faced to the same problem.

how did you solve?

regards ingo