on 06-26-2008 6:40 AM
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
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi,
did you restart the server after change?
also check Note 719778 - DataSource fails to return connection
regards,
kaushal
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
User | Count |
---|---|
85 | |
23 | |
11 | |
9 | |
8 | |
5 | |
5 | |
5 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.