You are viewing a plain text version of this content. The canonical link for it is here.
Posted to slide-user@jakarta.apache.org by Jacob Lund <ja...@qualiware.com> on 2001/08/02 13:34:18 UTC
Using at database (MSSQL 7)
Hi,
I have altered the HSQL example in the domain.xml file (slide server) in
order to connect to a MSSQL 7. I use sun JDBC.ODBC driver and it seems
to logon fine - but the Catalina returns an error:
02 Aug 2001 13:28:14 - slidestore.reference.JDBCContentStore - INFO -
Connecting to "jdbc:odbc:store" as user "AgLogin"
02 Aug 2001 13:28:14 - WARNING - Service
slidestore.reference.JDBCDescriptorsStore@22cdb6 access error :
ResultSet is closed
02 Aug 2001 13:28:14 - INFO - Namespace base configuration was already
done before
02 Aug 2001 13:28:14 - INFO - Loading namespace slide configuration
org.apache.slide.structure.ObjectNotFoundException: No object found at
/actions at
slidestore.reference.JDBCDescriptorsStore.retrieveObject(JDBCDescriptors
Store.java:560)
Do I have to move some information into the database. I ran the SQL
script from the documentation to create the tables.
What will end up in the database - is it only files and their revisions
or should the users also be defined here?
/Jacob
Re: Using at database (MSSQL 7)
Posted by Remy Maucherat <re...@betaversion.org>.
Quoting Jacob Lund <ja...@qualiware.com>:
> Hi,
>
> I have altered the HSQL example in the domain.xml file (slide server)
> in
> order to connect to a MSSQL 7. I use sun JDBC.ODBC driver and it seems
> to logon fine - but the Catalina returns an error:
>
> 02 Aug 2001 13:28:14 - slidestore.reference.JDBCContentStore - INFO -
> Connecting to "jdbc:odbc:store" as user "AgLogin"
> 02 Aug 2001 13:28:14 - WARNING - Service
> slidestore.reference.JDBCDescriptorsStore@22cdb6 access error :
> ResultSet is closed
> 02 Aug 2001 13:28:14 - INFO - Namespace base configuration was already
> done before
> 02 Aug 2001 13:28:14 - INFO - Loading namespace slide configuration
> org.apache.slide.structure.ObjectNotFoundException: No object found at
> /actions at
> slidestore.reference.JDBCDescriptorsStore.retrieveObject(JDBCDescriptors
> Store.java:560)
>
>
> Do I have to move some information into the database. I ran the SQL
> script from the documentation to create the tables.
>
> What will end up in the database - is it only files and their
> revisions
> or should the users also be defined here?
No, you didn't do anything wrong.
There was problems in the past with result sets and statements not being
closed, and we fixed these issues in the recent Slide releases. However, there
were some redundant ResultSet.close() being called, and apparenly
some JDBC drivers don't like that.
I've just committed a fix which should address the issue (although I wasn't
able to test it).
Remy