Cannot buil Web Dynpro DC with JDBC connection

[Former Member]

Hi,

I am working on the NWDS 7.2, trying to deploy my WDP DC on Netweaver CE 7.2. I have added my sqljdbc.jar driver to my build path in order to manage a SQL connection to my database.

When I try to build my project, here are the errors that occur:

-

---

[javac] ERROR: D:\Workspaces\Agora.jdi\LocalDevelopment\t\5174B44D6E83285F1B26D5FD421664E7\gen_wdp\packages\com\c10\testdbconnector\wd\comp\dbaccesscomp\DBAccessComp.java:23: package com.microsoft.sqlserver.jdbc does not exist

[javac] ERROR: import com.microsoft.sqlserver.jdbc.SQLServerConnection;

[javac] ERROR: ^

[javac] ERROR: D:\Workspaces\Agora.jdi\LocalDevelopment\t\5174B44D6E83285F1B26D5FD421664E7\gen_wdp\packages\com\c10\testdbconnector\wd\comp\dbaccesscomp\DBAccessComp.java:24: package com.microsoft.sqlserver.jdbc does not exist

[javac] ERROR: import com.microsoft.sqlserver.jdbc.SQLServerException;

[javac] ERROR: ^

[javac] ERROR: D:\Workspaces\Agora.jdi\LocalDevelopment\t\5174B44D6E83285F1B26D5FD421664E7\gen_wdp\packages\com\c10\testdbconnector\wd\comp\dbaccesscomp\DBAccessComp.java:25: package com.microsoft.sqlserver.jdbc does not exist

[javac] ERROR: import com.microsoft.sqlserver.jdbc.SQLServerPreparedStatement;

[javac] ERROR: ^

[javac] ERROR: D:\Workspaces\Agora.jdi\LocalDevelopment\t\5174B44D6E83285F1B26D5FD421664E7\gen_wdp\packages\com\c10\testdbconnector\wd\comp\dbaccesscomp\DBAccessComp.java:26: package com.microsoft.sqlserver.jdbc does not exist

[javac] ERROR: import com.microsoft.sqlserver.jdbc.SQLServerResultSet;

[javac] ERROR: ^

[javac] ERROR: D:\Workspaces\Agora.jdi\LocalDevelopment\t\5174B44D6E83285F1B26D5FD421664E7\gen_wdp\packages\com\c10\testdbconnector\wd\comp\dbaccesscomp\DBAccessComp.java:27: package com.microsoft.sqlserver.jdbc does not exist

[javac] ERROR: import com.microsoft.sqlserver.jdbc.SQLServerStatement;

[javac] ERROR: ^

[javac] ERROR: D:\Workspaces\Agora.jdi\LocalDevelopment\t\5174B44D6E83285F1B26D5FD421664E7\gen_wdp\packages\com\c10\testdbconnector\wd\comp\dbaccesscomp\DBAccessComp.java:241: package com.microsoft.sqlserver.jdbc does not exist

[javac] ERROR: public void readDataBase( ) throws com.microsoft.sqlserver.jdbc.SQLServerException {

[javac] ERROR: ^

[javac] ERROR: D:\Workspaces\Agora.jdi\LocalDevelopment\t\5174B44D6E83285F1B26D5FD421664E7\gen_wdp\packages\com\c10\testdbconnector\wd\comp\dbaccesscomp\DBAccessComp.java:300: package com.microsoft.sqlserver.jdbc does not exist

[javac] ERROR: public void writeMetaData( com.microsoft.sqlserver.jdbc.SQLServerResultSet resultSet ) throws com.microsoft.sqlserver.jdbc.SQLServerException {

[javac] ERROR: ^

[javac] ERROR: D:\Workspaces\Agora.jdi\LocalDevelopment\t\5174B44D6E83285F1B26D5FD421664E7\gen_wdp\packages\com\c10\testdbconnector\wd\comp\dbaccesscomp\DBAccessComp.java:300: package com.microsoft.sqlserver.jdbc does not exist

[javac] ERROR: public void writeMetaData( com.microsoft.sqlserver.jdbc.SQLServerResultSet resultSet ) throws com.microsoft.sqlserver.jdbc.SQLServerException {

[javac] ERROR: ^

[javac] ERROR: D:\Workspaces\Agora.jdi\LocalDevelopment\t\5174B44D6E83285F1B26D5FD421664E7\gen_wdp\packages\com\c10\testdbconnector\wd\comp\dbaccesscomp\DBAccessComp.java:310: package com.microsoft.sqlserver.jdbc does not exist

[javac] ERROR: public void writeResultSet( com.microsoft.sqlserver.jdbc.SQLServerResultSet resultSet ) throws com.microsoft.sqlserver.jdbc.SQLServerException {

[javac] ERROR: ^

[javac] ERROR: D:\Workspaces\Agora.jdi\LocalDevelopment\t\5174B44D6E83285F1B26D5FD421664E7\gen_wdp\packages\com\c10\testdbconnector\wd\comp\dbaccesscomp\DBAccessComp.java:310: package com.microsoft.sqlserver.jdbc does not exist

[javac] ERROR: public void writeResultSet( com.microsoft.sqlserver.jdbc.SQLServerResultSet resultSet ) throws com.microsoft.sqlserver.jdbc.SQLServerException {

[javac] ERROR: ^

[javac] ERROR: D:\Workspaces\Agora.jdi\LocalDevelopment\t\5174B44D6E83285F1B26D5FD421664E7\gen_wdp\packages\com\c10\testdbconnector\wd\comp\dbaccesscomp\DBAccessComp.java:356: cannot find symbol

[javac] ERROR: symbol : class SQLServerConnection

[javac] ERROR: location: class com.c10.testdbconnector.wd.comp.dbaccesscomp.DBAccessComp

[javac] ERROR: private SQLServerConnection connect = null;

[javac] ERROR: ^

[javac] ERROR: D:\Workspaces\Agora.jdi\LocalDevelopment\t\5174B44D6E83285F1B26D5FD421664E7\gen_wdp\packages\com\c10\testdbconnector\wd\comp\dbaccesscomp\DBAccessComp.java:357: cannot find symbol

[javac] ERROR: symbol : class SQLServerStatement

[javac] ERROR: location: class com.c10.testdbconnector.wd.comp.dbaccesscomp.DBAccessComp

[javac] ERROR: private SQLServerStatement statement = null;

[javac] ERROR: ^

[javac] ERROR: D:\Workspaces\Agora.jdi\LocalDevelopment\t\5174B44D6E83285F1B26D5FD421664E7\gen_wdp\packages\com\c10\testdbconnector\wd\comp\dbaccesscomp\DBAccessComp.java:358: cannot find symbol

[javac] ERROR: symbol : class SQLServerPreparedStatement

[javac] ERROR: location: class com.c10.testdbconnector.wd.comp.dbaccesscomp.DBAccessComp

[javac] ERROR: private SQLServerPreparedStatement preparedStatement = null;

[javac] ERROR: ^

[javac] ERROR: D:\Workspaces\Agora.jdi\LocalDevelopment\t\5174B44D6E83285F1B26D5FD421664E7\gen_wdp\packages\com\c10\testdbconnector\wd\comp\dbaccesscomp\DBAccessComp.java:359: cannot find symbol

[javac] ERROR: symbol : class SQLServerResultSet

[javac] ERROR: location: class com.c10.testdbconnector.wd.comp.dbaccesscomp.DBAccessComp

[javac] ERROR: private SQLServerResultSet resultSet = null;

[javac] ERROR: ^

[javac] ERROR: D:\Workspaces\Agora.jdi\LocalDevelopment\t\5174B44D6E83285F1B26D5FD421664E7\gen_wdp\packages\com\c10\testdbconnector\wd\comp\dbaccesscomp\wdp\IPublicDBAccessComp.java:127: package com.microsoft.sqlserver.jdbc does not exist

[javac] ERROR: void readDataBase( ) throws com.microsoft.sqlserver.jdbc.SQLServerException;

[javac] ERROR: ^

[javac] ERROR: D:\Workspaces\Agora.jdi\LocalDevelopment\t\5174B44D6E83285F1B26D5FD421664E7\gen_wdp\packages\com\c10\testdbconnector\wd\comp\dbaccesscomp\wdp\IPublicDBAccessComp.java:132: package com.microsoft.sqlserver.jdbc does not exist

[javac] ERROR: void writeMetaData( com.microsoft.sqlserver.jdbc.SQLServerResultSet resultSet ) throws com.microsoft.sqlserver.jdbc.SQLServerException;

[javac] ERROR: ^

[javac] ERROR: D:\Workspaces\Agora.jdi\LocalDevelopment\t\5174B44D6E83285F1B26D5FD421664E7\gen_wdp\packages\com\c10\testdbconnector\wd\comp\dbaccesscomp\wdp\IPublicDBAccessComp.java:132: package com.microsoft.sqlserver.jdbc does not exist

[javac] ERROR: void writeMetaData( com.microsoft.sqlserver.jdbc.SQLServerResultSet resultSet ) throws com.microsoft.sqlserver.jdbc.SQLServerException;

[javac] ERROR: ^

[javac] ERROR: D:\Workspaces\Agora.jdi\LocalDevelopment\t\5174B44D6E83285F1B26D5FD421664E7\gen_wdp\packages\com\c10\testdbconnector\wd\comp\dbaccesscomp\wdp\IPublicDBAccessComp.java:137: package com.microsoft.sqlserver.jdbc does not exist

[javac] ERROR: void writeResultSet( com.microsoft.sqlserver.jdbc.SQLServerResultSet resultSet ) throws com.microsoft.sqlserver.jdbc.SQLServerException;

[javac] ERROR: ^

[javac] ERROR: D:\Workspaces\Agora.jdi\LocalDevelopment\t\5174B44D6E83285F1B26D5FD421664E7\gen_wdp\packages\com\c10\testdbconnector\wd\comp\dbaccesscomp\wdp\IPublicDBAccessComp.java:137: package com.microsoft.sqlserver.jdbc does not exist

[javac] ERROR: void writeResultSet( com.microsoft.sqlserver.jdbc.SQLServerResultSet resultSet ) throws com.microsoft.sqlserver.jdbc.SQLServerException;

[javac] ERROR: ^

[javac] ERROR: D:\Workspaces\Agora.jdi\LocalDevelopment\t\5174B44D6E83285F1B26D5FD421664E7\gen_wdp\packages\com\c10\testdbconnector\wd\comp\dbaccesscomp\wdp\InternalDBAccessComp.java:137: package com.microsoft.sqlserver.jdbc does not exist

[javac] ERROR: public void readDataBase( ) throws com.microsoft.sqlserver.jdbc.SQLServerException {

[javac] ERROR: ^

[javac] ERROR: D:\Workspaces\Agora.jdi\LocalDevelopment\t\5174B44D6E83285F1B26D5FD421664E7\gen_wdp\packages\com\c10\testdbconnector\wd\comp\dbaccesscomp\wdp\InternalDBAccessComp.java:141: package com.microsoft.sqlserver.jdbc does not exist

[javac] ERROR: public void writeMetaData( com.microsoft.sqlserver.jdbc.SQLServerResultSet _resultSet ) throws com.microsoft.sqlserver.jdbc.SQLServerException {

[javac] ERROR: ^

[javac] ERROR: D:\Workspaces\Agora.jdi\LocalDevelopment\t\5174B44D6E83285F1B26D5FD421664E7\gen_wdp\packages\com\c10\testdbconnector\wd\comp\dbaccesscomp\wdp\InternalDBAccessComp.java:141: package com.microsoft.sqlserver.jdbc does not exist

[javac] ERROR: public void writeMetaData( com.microsoft.sqlserver.jdbc.SQLServerResultSet _resultSet ) throws com.microsoft.sqlserver.jdbc.SQLServerException {

[javac] ERROR: ^

[javac] ERROR: D:\Workspaces\Agora.jdi\LocalDevelopment\t\5174B44D6E83285F1B26D5FD421664E7\gen_wdp\packages\com\c10\testdbconnector\wd\comp\dbaccesscomp\wdp\InternalDBAccessComp.java:145: package com.microsoft.sqlserver.jdbc does not exist

[javac] ERROR: public void writeResultSet( com.microsoft.sqlserver.jdbc.SQLServerResultSet _resultSet ) throws com.microsoft.sqlserver.jdbc.SQLServerException {

[javac] ERROR: ^

[javac] ERROR: D:\Workspaces\Agora.jdi\LocalDevelopment\t\5174B44D6E83285F1B26D5FD421664E7\gen_wdp\packages\com\c10\testdbconnector\wd\comp\dbaccesscomp\wdp\InternalDBAccessComp.java:145: package com.microsoft.sqlserver.jdbc does not exist

[javac] ERROR: public void writeResultSet( com.microsoft.sqlserver.jdbc.SQLServerResultSet _resultSet ) throws com.microsoft.sqlserver.jdbc.SQLServerException {

[javac] ERROR: ^

[javac] ERROR: D:\Workspaces\Agora.jdi\LocalDevelopment\t\5174B44D6E83285F1B26D5FD421664E7\gen_wdp\packages\com\c10\testdbconnector\wd\comp\dbaccesscomp\DBAccessComp.java:122: cannot find symbol

[javac] ERROR: symbol : class SQLServerException

[javac] ERROR: location: class com.c10.testdbconnector.wd.comp.dbaccesscomp.DBAccessComp

[javac] ERROR: } catch (SQLServerException e) {

[javac] ERROR: ^

[javac] ERROR: D:\Workspaces\Agora.jdi\LocalDevelopment\t\5174B44D6E83285F1B26D5FD421664E7\gen_wdp\packages\com\c10\testdbconnector\wd\comp\dbaccesscomp\DBAccessComp.java:247: cannot find symbol

[javac] ERROR: symbol : class SQLServerConnection

[javac] ERROR: location: class com.c10.testdbconnector.wd.comp.dbaccesscomp.DBAccessComp

[javac] ERROR: connect = (SQLServerConnection) DriverManager.getConnection(

[javac] ERROR: ^

[javac] ERROR: D:\Workspaces\Agora.jdi\LocalDevelopment\t\5174B44D6E83285F1B26D5FD421664E7\gen_wdp\packages\com\c10\testdbconnector\wd\comp\dbaccesscomp\DBAccessComp.java:251: cannot find symbol

[javac] ERROR: symbol : class SQLServerStatement

[javac] ERROR: location: class com.c10.testdbconnector.wd.comp.dbaccesscomp.DBAccessComp

[javac] ERROR: statement = (SQLServerStatement) connect.createStatement();

[javac] ERROR: ^

[javac] ERROR: D:\Workspaces\Agora.jdi\LocalDevelopment\t\5174B44D6E83285F1B26D5FD421664E7\gen_wdp\packages\com\c10\testdbconnector\wd\comp\dbaccesscomp\DBAccessComp.java:253: cannot find symbol

[javac] ERROR: symbol : class SQLServerResultSet

[javac] ERROR: location: class com.c10.testdbconnector.wd.comp.dbaccesscomp.DBAccessComp

[javac] ERROR: resultSet = (SQLServerResultSet) statement

[javac] ERROR: ^

[javac] ERROR: D:\Workspaces\Agora.jdi\LocalDevelopment\t\5174B44D6E83285F1B26D5FD421664E7\gen_wdp\packages\com\c10\testdbconnector\wd\comp\dbaccesscomp\wdp\InternalDBAccessComp.java:180: package com.microsoft.sqlserver.jdbc does not exist

[javac] ERROR: delegate.writeMetaData((com.microsoft.sqlserver.jdbc.SQLServerResultSet)args[0]);

[javac] ERROR: ^

[javac] ERROR: D:\Workspaces\Agora.jdi\LocalDevelopment\t\5174B44D6E83285F1B26D5FD421664E7\gen_wdp\packages\com\c10\testdbconnector\wd\comp\dbaccesscomp\wdp\InternalDBAccessComp.java:183: package com.microsoft.sqlserver.jdbc does not exist

[javac] ERROR: delegate.writeResultSet((com.microsoft.sqlserver.jdbc.SQLServerResultSet)args[0]);

[javac] ERROR: ^

[javac] 30 errors

-

---

I used to do the same when I was developing on NWDS 7.0 and it was working fine. Why isn't it working now ?

Thanks in advance for your help.

Thibault

Edited by: Thibault Schalck on Dec 7, 2010 11:27 AM

[junwu · Accepted solution]

you can search in sdn regarding how to use external jar in sap java development.

[Former Member · Accepted solution]

This is a great help, thank you. Now I know which way I have to start seeking for the answer.

Thibault

[Former Member · Accepted solution]

Hi,

Close the Question if its answered.

I believe that you have found that you have to use library dc to add external jar file in a DC.

Regards

Deepak

[Former Member · Accepted solution]

I have seen a few post on SDN, and it seems that working on NWDI is necessary to create such a DC. I am not working on NWDI.

Is it still THE solution to use my external Jar ?

[Former Member · Accepted solution]

And the answer to my last question is what ever. I am now able to deploy my Web Dynpro Application !!

Thanks for your help.

Thibault

[Former Member]

Hi,Thibault Schalck

Even i am facing the same issue can u tell me how can it be fixed..!

Rajnikanth