This discussion is archived
1 Reply Latest reply: Oct 28, 2009 7:03 AM by user109227 RSS

Smart Space 9.3.1 Verifying JDBC Drivers

user109227 Newbie
Currently Being Moderated
The instructions tell me to verify my JDBC Drivers.

I am on SQL Server and the instructions tell me this:

Optional: Verify the SQL Server JDBC Drivers
The free TDS JDBC driver, is installed with Smart Space. These values are setup in
Hyperion_Home\SmartSpace\9.3\Collaborator\conf\wildfire.xml:
● driver: net.sourceforge.jtds.jdbc.Driver
● serverURL: jdbc:jtds:sqlserver://
host:port:database/ ;appName=Collaborator



When I look at the wildfire.xml document it has this (it was installed this way):

<database>
- <defaultProvider>
<driver>net.sourceforge.jtds.jdbc.Driver</driver>
<serverURL>jdbc:jtds:sqlserver://hscuschlws00045.harsco.com/HFM_SmartSpace;appName=jive</serverURL>

hsc....45.harsco.com is the host and HFM_SmartSpace is the database name.

Do I need to add the port and remove the / in front of HFM_SmartSpace and replace it with a :

Should the appName=jive be Collaborator instead?

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points