Hi Dirk
Please Igonore the below pasted query in making JDBC store working with
Sql Server.
As per the JDBC how to documentation we have to create
EXEC sp_addtype N'uri', N'varchar (800)', N'not null'
create table objects(uri uri primary key, classname text);
........
And this was giving the below pasted error. So I replaced the uri
datatype creation and usage and straight away used the varchar 800 and
it worked fine. For Information I used JSQLConnect.jar.
Now it is all fine
Ashok Kumar@Metatomix
-----Original Message-----
From: Kumar, Ashok
Sent: Thursday, August 16, 2001 5:22 PM
To: '[EMAIL PROTECTED]'
Subject: Slide with Tomcat/4.0-b7-dev USING JDBC STORE
Hi
I activated the JDBCStore and am getting the following error
16 Aug 2001 17:19:44 - slidestore.reference.JDBCContentStore - INFO -
Connecting
to "jdbc:JSQLConnect://AKUMAR/database=myDBASE" as user "ask"
16 Aug 2001 17:19:44 - slidestore.reference.JDBCDescriptorsStore - ERROR
- com.j
netdirect.jsql.o: SELECT permission denied on object 'objects', database
'myDBASE', owner 'dbo'.
com.jnetdirect.jsql.o: SELECT permission denied on object 'objects',
database 'm
yDBRDF', owner 'dbo'.
at com.jnetdirect.jsql.af.a(Unknown Source)
Is it the problem with the table objects. THe user ID I am using has the
maximum access.
Any Idea
Ashok@metatomix
