java.sql.sqlexception: the url cannot be null

Error loading a stored procedure.

java.sql.sqlexception: the url cannot be null

at java.sql.DriverManager.getConnection

How should I fix it?


The code did not has thrown such exception on the server. When I deploy it on another machine, it has that error. I think I missed something in elipse.

Any advice?

String driver = "com.microsoft.sqlserver.jdbc.SQLServerDriver";	             
Properties configFile = new Properties();
configFile.load(this.getClass().getClassLoader().getResourceAsStream("config.properties"));
String connectionstring =configFile.getProperty("CONN_STRING"); 
Class.forName(driver).newInstance();            
Connection conn = null;
conn = DriverManager.getConnection(connectionstring);  
CallableStatement SP_Get_ID = null;	
 
 CONN_STRING=jdbc:sqlserver://127.0.0.1;databaseName=Eidth;SendStringParametersAsUnicode=true;user=sa;password=ed1981

Select all Open in new window