cancel
Showing results for 
Search instead for 
Did you mean: 

Initial configurations MII (Deploy JDBC)

Former Member
0 Kudos

Hi, i just installed MII and i have tried to deploy the JDBC driver 4.0 for SQL but when i load sqljdbc4.jar the button that deploy the driver still disabled.

The log error is:

#2.0 #2012 05 18 12:05:21:909#0-500#Warning#/Applications/XMII#

##sap.com/xapps~xmii~ear#C000C0A801B471D50000000200001704#8814250000000004#sap.com/xapps~xmii~ear#com.sap.xmii.util.VirusChecker#valtamirano#1452##82591F10A10B11E1C9C2000000867EAA#89fba9faa10b11e1c259000000867eaa#89fba9faa10b11e1c259000000867eaa#0#Thread[HTTP Worker [@1283269603],5,Dedicated_Application_Thread]#Plain##

Unable to scan file com.sap.xmii.temp.upload.61714.jar: com.sap.security.core.server.vsi.api.exception.VSIServiceException: No default virus scan profile available.#

#2.0 #2012 05 18 12:05:51:673#0-500#Info#/System/UserInterface#

#BC-WD-JAV#tc~wd~webdynpro#C000C0A801B471D60000000000001704#8814250000000004#sap.com/tc~lm~itsam~ui~lv~client_ui#com.sap.tc.webdynpro.services.session.SynchronizedScopeMaintainer#valtamirano#1452##82591F10A10B11E1C9C2000000867EAA#9a39cd53a10b11e18ea3000000867eaa#9a39cd53a10b11e18ea3000000867eaa#0#Thread[HTTP Worker [@1566962689],5,Dedicated_Application_Thread]#Plain##

Deprecated scope of type SERVERSESSION_AT_LEAST_ONE_APP_SCOPE is used! Please replace the usage of scopes with new mechanism based on "Cross application session communication API".#

Regards.

Accepted Solutions (1)

Accepted Solutions (1)

Former Member
0 Kudos

Hi Victor,

Be sure about if your Netweaver version supports JDBC driver 4.0 for SQL, also you can try a different driver such as http://jtds.sourceforge.net/  

Regards,

Former Member
0 Kudos

Thanks Turan, i just deployed de JDBC Driver, what do i have to do next in order to connect a SQL data base? do i have to create a data source in NWA? how can i know the DataBase URL?

Regards, Victor

Former Member
0 Kudos

Next steps for SQL Server are:

   Select Data Services->Data Servers link from MII administration menu.

  • Connector type should be IDBC.
  • Check "Enabled" checkbox on Settings tab.
  • Select Connection tab.
  • Date Prefix and Date Suffix should be a single quote '.
  • Fill Username and Password.
  • Set validation query SELECT GETDATE()
  • JDBC Driver depends on your uploaded driver, if you uploaded sourceforge jtds driver you can set your JDBC Driver like net.sourceforge.jtds.jdbc.Driver
  • Server URL also depends on uploaded driver, if you uploaded sourceforge jtds driver you can use like jdbc:jtds:sqlserver://servername:port/databasename 
  • Leave other fields with default values.
aravinth_anandhan
Active Participant
0 Kudos

Hi,

Check this link for more information about IDBC connector

http://help.sap.com/saphelp_xmii115/helpdata/en/Connectors/IDBCConnector.htm

Regards,

Aravinth A

Former Member
0 Kudos

Thanks Aravinth

Regards, Victor

Answers (0)