|
Home > Archive > WebSphere Portal Server > March 2004 > SQL Server
You are viewing an archived Text-only version of the thread.
To view this thread in it's original format and/or if you want to reply to
this thread please [click here]
|
|
|
| I have a Linux Portal v5 server that I have installed and configured for
LDAP -- Now I want to connect to a database. Unfotunately the company
standard is MS SQL Server. SO I got the jdbc drivers and put them in
/opt/mssql. I Went about editing the wpsconfig.properties but when I
validate-database-connection-wps it says:
[java] Exception in thread "main" java.lang.NoClassDefFoundError:
com/microsoft/util/UtilLocalMessages
I verified all of the settings in the properties file and I even added
/opt/mssql to the system PATH and CLASSPATH variables.
Any suggestions?
| |
| jrauch67 2004-03-23, 8:35 am |
| > I have a Linux Portal v5 server that I have installed
> and configured for
> LDAP -- Now I want to connect to a database.
> Unfotunately the company
> standard is MS SQL Server. SO I got the jdbc drivers
> and put them in
> /opt/mssql. I Went about editing the
> wpsconfig.properties but when I
> validate-database-connection-wps it says:
>
> [java] Exception in thread "main"
> " java.lang.NoClassDefFoundError:
> com/microsoft/util/UtilLocalMessages
>
> I verified all of the settings in the properties file
> and I even added
> /opt/mssql to the system PATH and CLASSPATH
> variables.
>
> Any suggestions?
We had the same issue.
You need to edit a file called "<WPS_ROOT>/config/actions/validation.xml" and go to the target : <target name="validate-database-connection-wps">.
Check that you have this as classpath :
<classpath>
<pathelement path="${DbLibrary}" />
<pathelement location="${WpsInstallLocation}/bin/tools.jar" />
</classpath>
I think you should remplace the first "location" with "path" like above.
We have reported this issue to the IBM Support.
Best regards.
| |
| jrauch67 2004-03-23, 8:36 am |
| Sorry for the 1st answer, here is the correct classpath tags in text form, not xml :
classpath
pathelement path="${DbLibrary}" /
pathelement location="${WpsInstallLocation}/bin/tools.jar" /
/classpath
|
|
|
|
|