IDBC connector error

[former_member624280]

Hi,

I want to connect to Oracle Server by JDBC on xMII 12.

So I made IDBC Connector by using Data Service >Data Server.

I select IDBC,then input a name, JDBC Driver, Password, ServerURL, UserName, ValidationQuery.

JDBC Driver:oracle.jdbc.driver.OracleDriver

ServerURL:jdbc:oracle:thin:@<server name>:1521:<instance>

ValidationQuery:SELECT SYSDATE FROM DUAL

Next save the setting, then I push the Status button.

But there is ERROR Status on the Connection Sattus Window.

Do you know what happened?

PING to Oracle Server is good, Port 1521 is open.

Thanks

[salvatore_castro · Accepted solution]

Hiromitsu,

Have you uploaded your JDBC driver into xMII? What is the error message associated with the connection attempt (Hint: In the NetWeaver Logs)?

Sam

[former_member624280 · Accepted solution]

Thank you, Salvatore

First, I use <b>Oracle</b> on <b>xMII 12</b>. Do I need to upload JDBC driver?

Next, I recently use xMII. So I'm sorry I don't know the way to show a NetWeaver Logs.

Please tell me how to show the logs.

Thanks

[salvatore_castro · Accepted solution]

Hiromitsu,

You can check, <a href="http://help.sap.com">http://help.sap.com</a> in the future...

For now the NW logs are located here:

http://<Server><:Port>/nwa

Monitoring -> Logs and Traces

OR

On the NW server there is a LogViewer.bat which will open up a stand alone log viewer.

As for the JDBC driver, v12 of xMII does not come with any drivers pre-loaded so you have to upload the corresponding driver yourself.

Sam

[former_member624280 · Accepted solution]

Thanks, Salvatore

I understand that driver is needed.

First I recognize the driver to xMII. Then I do this process.

Please wait for a while.

[former_member624280 · Accepted solution]

Hi Salvatore,

I could set up JDBC driver, then I checked the "Status", it's OK.

I can use my "DataServer".

Thank you.

Regards

[Former Member · Accepted solution]

Salvatore,

In reference to "v12 does not come with any drivers pre-loaded". Are any of them part of the install, is it just that you have to upload/deploy them? Or do you need to go out and download them?

I'm a bit confused given that the v12 help file states.

"The JDBC drivers included with SAP xMII are the following:

· Oracle

You must use Oracle 7.3.4 or newer (oracle.jdbc.driver.OracleDriver).

· SQL Server

You must use SQL Server 6.X, 7.X or 2000 (com.inet.tds.TdsDriver).

Is this maybe a cut and paste error from the 11.5 docs?

Your help is appreciated, we just got 12 up and running and are trying to get our Oracle and MSSQL datasources connected.

Regards,

Rod Hoffman

[Former Member · Accepted solution]

This

might give you a better understanding on JDBC drivers & xMII 12.0

[salvatore_castro · Accepted solution]

Rod,

Must be a copy/paste error from the 11.5 docs, can you post the URL where it states that and I'll have it updated accordingly.

In System Administration upload your JDBC driver, download it from the DB vendor, once it is deployed the classpath to use for your driver should be on the vendor's site. Configure the JDBC Server URL and parameters accordingly and enable the connection. View the logs for errors if the connection fails. That's it....

Sam

[Former Member · Accepted solution]

Hello,

I have the JDBC driver for SQLServer 2005 uploaded and deployed. I'm on xMII V12.0.2, Windows2003Server.

I've tried to setup an xMII Data Server of ConnectorType = SQL. But I am not having any luck with defining the Datasource value. Could you further explain your statement in the previous thread - "....Configure the JDBC Server URL and parameters accordingly and enable the connection."? How is this done?

Thanks -

Chuck

[salvatore_castro · Accepted solution]

Chuck,

Please see this page for connection setup details:

[http://msdn2.microsoft.com/en-us/library/ms378428.aspx|http://msdn2.microsoft.com/en-us/library/ms378428.aspx]

Also, check the NW Logs for the error message if you still cannot connect and then repost with the configuration settings and error message.

Thanks.

Sam

[Former Member · Accepted solution]

Sam,

Okay - I have the following in the Datasource value for the DataServer definition:

jdbc:sqlserver://192.168.200.237:1433;databaseName=xmii_test;user=xmii_test;password=*****

The Status shows as Running - but with no connections available. When I open Workbench, I see the Dataserver named xmii_test but the dropdown for Modes only lists: com.sap.xmii.system.ServiceLocatorException:. And at the bottom of the screen is shown "Cannot Load Parameter Mode".

I'm Not exactly sure which is considered the NW Log but I believe it is this one:

E:\usr\sap\N7J\JC00\j2ee\cluster\server0\log\applications.0.log. If it is, then, the last entry is: I starred out the password -

---

#1.5 #000C2992F2B5007600000018000003CC000448B9D00330C6#1205862803257#/Applications/LHCommon#sap.com/xapps_xmiiear#com.sap.lhcommon.localization.MessageCatalog#egadmin#74##n/a##fb9741d0f51311dcb644000c2992f2b5#SAPEngine_Application_Thread[impl:3]_19##0#0#Warning#1#com.sap.lhcommon.localization.MessageCatalog#Plain###*** MISSING RESOURCE: Unable to localize com.sap.xmii.system.ServiceLocatorException: com.sap.engine.services.jndi.persistent.exceptions.InvalidNameException: Incorrect name parameter jdbc:sqlserver://192.168.200.237:1433;databaseName=xmii_test;user=xmii_test;password=**** in naming operation.#

Thanks for any help...

Chuck

[salvatore_castro · Accepted solution]

Chuck,

The username and password need to be entered in the dataserver configuration fields and not in the ServerURL textbox. Please revise your configuration. Thanks.

Sam

[Former Member]

Sam,

Ok - once I chose the correct connector (IDBC) and I fixed the JDBCDriver to be com.microsoft.sqlserver.jdbc.SQLServerDriver,

all went well. Evidently the default JDBCDriver setting is only for SQLServer 2000. There definitely needs to be some additional info in the help files around these settings because if you can't get Data Servers configured none of the rest really matters.

Thanks for your help!

Chuck

[jcgood25]

https://service.sap.com/sap/support/notes/990322

[Former Member]

Sam,

That may be part of the problem - those configuration parameter names are not listed in the Data Server dialog box. I think I was using the wrong Connector - I was using DataSource and I think I should have been using IDBC.....

I'll let you know.

Chuck