Sql server is MyServer
Database Name is test
Username is test
Password is test
In normal jsp my connection string is:
Class.forName("com.microsoft.jdbc.sqlserver.SQLServerDriver");
con =
DriverManager.getConnection("jdbc:microsoft:sqlserver://MyServer;dbname=test
","test","test");
This works fine.
In JSTL my connection string is:
<sql:setDataSource
driver="com.microsoft.jdbc.sqlserver.SQLServerDriver"
url="jdbc:microsoft:sqlserver://MyServer;DbName=test"
user="test"
password="test"
/>
I get a null pointer exception. I've tried many variations. 'DatabaseName'
instead of 'DbName'. I've explicitly used port 1433. Different orders,
everything. Any ideas on what I am doing wrong?
