cancel
Showing results for 
Search instead for 
Did you mean: 

new Datasource created is not accessible

nikhil_bose
Active Contributor
0 Kudos

hi all,

I have created a new database instance and put DataSource property in the visual administrator.

When I access from a simple dynpro application with a select query, it gives SQLException: ResourceException in method ConnectionFactoryImpl.getConnection(): com.sap.engine.services.dbpool.exceptions.BaseResourceException: SQLException thrown by the physical connection: com.sap.dbtech.jdbc.exceptions.JDBCDriverException: SAP DBTech JDBC: Cannot connect to jdbc:sapdb://dbserver56/TST [Restart required].

Please tell me if any missed anything whilst configuration

nikhil

Accepted Solutions (0)

Answers (2)

Answers (2)

nikhil_bose
Active Contributor
0 Kudos

I am not sure that it is jdbc:sapdb://host/SID?timeout=value.

But it worked for me with

jdbc:sapdb://host/<Database Name>?timeout=value

Former Member
0 Kudos

Hi,

SID = database name or ID in terms of SAP.

regards,

kaushal

Former Member
0 Kudos

Hi,

did you restart the server after change?

also check Note 719778 - DataSource fails to return connection

regards,

kaushal

nikhil_bose
Active Contributor
0 Kudos

yeah kaushal, i have restarted j2EE. But it still says to restart server.

i have done so far:

created datasource entry: jdbc 1.x and driver properties I got from documentation. And made Venor SQL.

nikhil

Former Member
0 Kudos

HI,

check following threads might helps you

JDBC Exception Restart required

seems that your database is shutting down while you were running the report.

check knldig.log would be very helpful to find out the reason for the kernel shut down.

also check http://www.sapdb.org/jdbcSapdbcEng.html

regards,

kaushal

Edited by: Kaushal Malavia on Jun 26, 2008 12:26 PM

nikhil_bose
Active Contributor
0 Kudos

what could be value of database URL in visual administrator?

from documentation: its jdbc:sapdb://localhost/TST?timeout=0

can anyone tell what is TST?Timeout=0 meant for?

nikhil

Former Member
0 Kudos

Hi,

URL should be jdbc:sapdb://host/SID?timeout=value

where host = host name

don't give timeout=0 (it's define time to connect in second i.e 30 or 50)

regards,

kaushal