Cannot load JDBC driver class 'org.hsqldb.jdbcDriver' or 'SQLServerDriver'

[Former Member]

HI ALL:

I am got jdbc driver class error for OData SMP 3.0 sp3  please give me a hand！more information,check attached  screenshot .

Thanks & Regards

log.txt.zip

[Jitendra_Kansal]

Can you confirm?

1. Jar file you have deployed is OSGi enabled?

2. Have you created destination for HSQLDB as mentioned in this blog

3. What is id =  slick_uniqueid in service document?

Rgrds

JK

[Former Member]

HI jitendra kansal：

1. Jar file you have deployed is OSGi enabled?

     Yes，MSSQL ServerDriver.

2. Have you created destination for HSQLDB as mentioned in this blog ?

      Yes. follow the guide re-do,the error same as.

3. What is id =  slick_uniqueid in service document?

    The reason may be the chrome browser。

[midhun_vp]

Hi,

When you are creating destination in SMP Management cockpit (Integration Gateway) make sure the database driver name is org.hsqldb.jdbc.Driver not org.hsqldb.jdbcDriver. I think it is resulting this issue.

Regards,

Midhun VP

[Jitendra_Kansal]

That should not be a problem. He must have defined org.hsqldb.jdbcDriver (as Driver name) while connecting to backend HSQLDB at the starting.

check few more things:

1. Make sure DB is open and running while opening service document.

2. All entityset parameter should map table's columns name. (case sensitive)

3. Entityset name should be same as table name. (case sensitive)

4. Can you check if you have created  system variable classpath in environment variable and set it value as

classpath: C:\hsqldb-2.3.2\lib\hsqldb.jar;%JAVA_HOME%\bin