MSSQL JBDC Files?

Check whether classpath is correctly set.

Where would i check that? Please excuse m, I'm fairly new to the F5's.

 

 

Thanks

Use echo $CLASSPATH command to check whether the driver is in the CLASSPATH. If it's not set correctly then you'll need to set using this command:

 

 

export CLASSPATH=$CLASSPATH:

 

 

Remember to change with the actual path to your JDBC driver.

 

 

Btw, Where did you see that message? Can you tell us what steps you have done?

 

 

I'm not familiar with Java and MSSQL so pardon me if my comments are not helping.

I did what you suggested and re-booted the box, It is still showing the right directory for the JAR files, but the SQL monitor is still not working. I am getting the error from the logfile generated from the "debug" mode on the mssql monitor.

 

 

Total output of the debug log:

 

 

********** Debugging session beginning at: Thu Mar 25 15:07:40 2010

 

 

Arguments 1-2:

 

::ffff:10.22.231.190

 

1433

 

 

Environment variables:

 

COUNT=0

 

DATABASE=***EDITED***

 

DEBUG=yes

 

MON_TMPL_NAME=DB_TEST

 

NODE_IP=::ffff:10.22.231.190

 

NODE_PORT=1433

 

PASSWORD=***EDITED***

 

RECVCOLUMN=1

 

RECVROW=2

 

RECV_I=Appling

 

SEND=select County_Name from County where County_ID = 1

 

USERNAME=coreadmin

 

count='0' converts to '0'

 

pidfile exists -- checking for correctness of pid...

 

DBDaemon says its pid is 16226

 

pid of 16226 is correct!

 

Recvd: 'com.microsoft.jdbc.sqlserver.SQLServerDriver

 

'

 

Recvd: 'jdbc:microsoft:sqlserver://10.22.231.190:1433;databaseName=***EDITED***;

 

'

 

Recvd: '***EDITED***

 

'

 

Recvd: '***EDITED***

 

'

 

Recvd: '0

 

'

 

Recvd: 'select County_Name from County where County_ID = 1

 

'

 

Recvd: 'Appling

 

'

 

Recvd: '2

 

'

 

Recvd: '1

 

'

 

Recvd: 'debug

 

'

 

Recvd: 'Loading database driver com.microsoft.jdbc.sqlserver.SQLServerDriver

 

'

 

Recvd: 'Error loading driver 'com.microsoft.jdbc.sqlserver.SQLServerDriver': java.lang.ClassNotFoundException: com.microsoft.jdbc.sqlserver.SQLServerDriver!Down!

 

'

 

Error receiving up/down message