on 10-16-2008 1:25 PM
Hello,
I have an error when sending data to MySql database. JDBC receiver adapter is used.
Error during database connection to the database URL 'jdbc:mysql://172.22.1.76/myschema' using the JDBC driver 'org.gjt.mysql.Driver': 'com.sap.aii.adapter.jdbc.sql.DriverManagerException: Cannot establish connection to URL 'jdbc:mysql://172.22.1.76/myschema': SQLException: Server configuration denies access to data source'
I have given the right username and password in that CC. Firewall is turned OFF. What might cause this problem?
Cheers,
Deepak
Plaase check the port number, username, password.
If you are calling a stored procedure, even your userbane should have permission to execute that, Please check with Database Administrator all these details.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
3306 is default port and it is optional if the port is default..
check with sample java code to test the conn string..
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi,
I think there should be a port:
JDBC URL --- jdbc:mysql://host_name:port/dbname
JDBC driver - com.mysql.jdbc.Driver
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
The connection URL could be incorrect. Are u sure there is no port information required? e.g. 172.22.1.76:xxxx
Regards,
Prateek
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Prateek,
I tried with n without port infact:
Error during database connection to the database URL 'jdbc:mysql://172.22.1.166:3306/test' using the JDBC driver 'org.gjt.mysql.Driver': 'com.sap.aii.adapter.jdbc.sql.DriverManagerException: Cannot establish connection to URL 'jdbc:mysql://172.22.1.166:3306/test': SQLException: Server configuration denies access to data source'
URL is correct.......
User | Count |
---|---|
96 | |
11 | |
11 | |
10 | |
9 | |
7 | |
6 | |
5 | |
4 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.