| BIRT and MSSQL: No suitable driver found for jdbc: [message #840299] |
Mon, 09 April 2012 19:24  |
 andrew smith
Messages: 43
Registered: February 2012 |
Member |
|
|
Hello, all:
Could someone help me with best way to have BIRT see the JDBC drivers...
I wrote a java class that connects to the msSQL, performs calculations and returns some numbers. This class has been tested in pure java and matlab. In both cases the code works without the glitch. For clarity let's call the class "ZZZ" and the package "com.mypackage"
I load the .jar file that contains the class via the "external jar" option and then use the ZZZ class from within BIRT via importPackage(Packages.com.mypackage) command.
Intantiation goes smoothly ie
var aaa = new ZZZ();
executes without problems.
when I call the methods, something like:
aaa.doDBthings();
I get the following error message:
java.sql.SQLException: No suitable driver found for jdbc:sqlserver://myServer;databaseName = wines;integratedSecurity=true;
at java.sql.DriverManager.getConnection(Unknown Source)
at java.sql.DriverManager.getConnection(Unknown Source)
....etc....etc....
Couple questions come to my mind.
1) Why does BIRT not see the jdbc drivers?
2) what should I do so that BIRT can see the suitable JDBC driver?
3) how can I set up my path if I do not have administator rights on a computer?
4) do I need to place sqljdbc4.jar (MSSQL jdbc driver) into a certain directory?
5) is this a BIRT problem or is this an ECLIPSE problem?
Thank you in advance,
Andrew
[Updated on: Mon, 09 April 2012 19:57] Report message to a moderator |
|
|
] 
Search
Help
Register
Login
Home
