LAE

Note: This was originally posted by an inactive account. Content was preserved by moving under an admin account.

Originally posted by: michael_teter

I'm trying to use the SQL Server jdbc driver from lae server 4.5.1, but I can't find the right place to put the driver so the server will see it.

I have updated .profile to include a CLASSPATH that points to the directory containing the jdbc driver, but the server still isn't able to load the driver. I'm unclear the exact reason for the failure, but I assume it's a matter of the server not finding the driver.

I have sqljdbc4.jar and sqljdbc.jar located under my installation path:
/opt/lavastorm/lae/4.5.1/ (and also copied under the java/lib as well as java/lib/ext directories).

Can anyone recommend a solution?

Note: This was originally posted by an inactive account. Content was preserved by moving under an admin account.

Originally posted by: michael_teter

Here are a few notes on the solution.

1. LAE 4.5.1 uses Java 1.6, so only the sqljdbc4.jar driver should be present on the server. It should be located under <installation_dir>/lib/java/ext

2. Configuration of JDBC Query node is as follows
DbUrl = jdbc:sqlserver://<hostname or IP of db server>
DbDriver = com.microsoft.sqlserver.jdbc.SQLServerDriver

3. It does not appear necessary to set CLASSPATH if the driver file is located under the lib/java/ext path

Note: This was originally posted by an inactive account. Content was preserved by moving under an admin account.

Originally posted by: dwong80

Here's a great resource for setting up JDBC connections (not only for use with Lavastorm). I wish I found this earlier:

http://www.instantolap.com/howtos/jdbc-drivers

Note: This was originally posted by an inactive account. Content was preserved by moving under an admin account.

Originally posted by: dwong80

Hrm .. I thought I had resolved this problem. It works well using the 4.1.9 server. However using 4.5 server (same graph but using 4.5 JDBC query node), I get errors with the exact some node trying to retrieve the SQL query:

com.microsoft.sqlserver.jdbc.SQLServerException: The statement did not return a result set.

Normally, I would think the query just doesn't return any results. But if I run the exact same query under 4.1.9 I get many rows returns.

Anybody else having this issue?

Note: This was originally posted by an inactive account. Content was preserved by moving under an admin account.

Originally posted by: Tim Meagher

Hi,

A little bit more information is required to figure this out I think....

What version of the SQL Server driver are you using and is this the same version as that which you were using for LAE 4.1.9 - if not, what version were you using against LAE 4.1.9?
Is this attempting to connect to the same database as in LAE 4.1.9?
Assuming that this is an enterprise installation, what JDK version are you using on LAE 4.1.9 and LAE 4.5.

Which version of LAE 4.5 are you using (4.5.0, 4.5.1, 4.5.2, ...)?

Tim.