error / fails to connect Oracle data source using deploy tool

[Former Member]

Hi,

I want to deploy SAP AS on my company's J2EE application. I deployed the application using Deploy Tool successfully. The application is started without error.

When I tried connecting the log on page. I got error in LogViewer:

Error while accessing porting layer for ORACLE database via getDatabaseHost().

Relatives : com.sap.sql.jdbc.direct.DirectConnectionFactory

Resource Bundlename : com.sap.sql.log.OpenSQLResourceBundle

Source : /System/Database/sql/jdbc/direct

Argument Objs : ORACLE,getDatabaseHost(),

Where to look for debugging errors?

-- Joe

[Former Member · Accepted solution]

Hi Joe,

i guess this due to the fact that you configured your datasource to be "Native SQL". This involves a sap porting layer (com.sap.sql.jdbc.direct.*) that wrappes the oracle driver.

If you want to work with the plain oracle datasource, switch to "Vendor SQL".

Best Regards,

Markus

[Former Member]

Hi Markus,

I changed to Vendor SQL and set Initial Connection to 1.

On Monitor tab, I see a green line running across the screen.

I believe this proves that the connection has been established.

Thanks a lot!

-- Joe

[Benny]

Hi Joe,

what did you do <i>exactly</i>?

Regards,

Benny