Connecting to external database

2 years ago • updated 2 years ago • 6

I am trying to connect to a database to call data from it using java syntax and it works fine on my machine but gives me " Invalid database address " when I try to use the same code in my macro in XTRF , what possibly could be the problem ? the code seems fine as it works on my machine but gives me errors on XTRF, does XTRF have special syntax I will have to follow in order to connect to a database ?

Thanks in advance

Vote

Replies 6
Oldest first
- Newest first
- Oldest first

2 years ago

It could be that your database is not publicly accessible? Could you maybe share the code?

2 years ago

import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.SQLException;
import java.sql.Statement;
import java.sql.Driver; 


String url = "jdbc:mysql://myip/mydatabasename"
 
String userName = "username" 

String password = "password"

Connection conn = DriverManager.getConnection(url,userName,password)

thank you for the quick reply

this works fine on my machine and the IP is publicly accessible yes

2 years ago

Nothing strange to see here indeed. @XTRF team, you probably know the insights of such specific. I'm very interested in what makes this code fail as well.

2 years ago

سلام من با یه بلاگر یا بد افزار طرفم کل سرمایه رفته چطور میتونید کمکم کنید

2 years ago

متأسفانه ما اینجا فارسی صحبت نمی کنیم.

2 years ago

I still didnt find what's wrong, is there anyone who is able to help please? It will be greatly appreciated

Customer support service by UserEcho