This is the console output: ('Ung�ltiger Objektname' (-> german) means
'invalid objectname')
D:\james\bin>run
Avalon runner
parser : org.apache.xerces.parsers.SAXParser
configurationPath : ../conf/
logFile : ../logs/avalon.log
libPath : ../lib/
blockPath : ./blocks/
Scanning jars for new Blocks...
Reading configuration
Avalon 2.2-dev
2002.04.15 10:28:31 562 Channel default opened
loading broker properties from file:/d:/james/var/maildatabase
-------------
1: SELECT message_name FROM MESSAGE WHERE repository_name =
'mail-outgoing' ORDE
R BY last_updated
-------------
[Microsoft][SQLServer JDBC Driver][SQLServer]Ung�ltiger Objektname
'MESSAGE'.
-------------
java.sql.SQLException: [Microsoft][SQLServer JDBC
Driver][SQLServer]Ung�ltiger O
bjektname 'MESSAGE'.
at com.microsoft.jdbc.base.BaseExceptions.createException(Unknown
Source
)
at com.microsoft.jdbc.base.BaseExceptions.getException(Unknown
Source)
at
com.microsoft.jdbc.sqlserver.tds.TDSRequest.processErrorToken(Unknown
Source)
at
com.microsoft.jdbc.sqlserver.tds.TDSRequest.processReplyToken(Unknown
Source)
at
com.microsoft.jdbc.sqlserver.tds.TDSExecuteRequest.processReplyToken(
Unknown Source)
at
com.microsoft.jdbc.sqlserver.tds.TDSRequest.processReply(Unknown Sour
ce)
at
com.microsoft.jdbc.sqlserver.SQLServerImplStatement.getNextResultType
(Unknown Source)
at com.microsoft.jdbc.base.BaseStatement.commonExecute(Unknown
Source)
at
com.microsoft.jdbc.base.BaseStatement.executeQueryInternal(Unknown So
urce)
at com.microsoft.jdbc.base.BaseStatement.executeQuery(Unknown
Source)
at com.workingdogs.town.DataSet.fetchRecords(DataSet.java:484)
at com.workingdogs.town.DataSet.fetchRecords(DataSet.java:429)
at com.workingdogs.town.DataSet.fetchRecords(DataSet.java:382)
at com.workingdogs.town.DataSet.size(DataSet.java:976)
at
org.apache.james.mailrepository.TownSpoolRepository.list(TownSpoolRep
ository.java:258)
at
org.apache.james.mailrepository.TownSpoolRepository.accept(TownSpoolR
epository.java:288)
at
org.apache.james.transport.mailets.RemoteDelivery.run(RemoteDelivery.
java:271)
at java.lang.Thread.run(Unknown Source)
================================================================
If a use a wrong databasename, I receive this error:
D:\james\bin>run
Avalon runner
parser : org.apache.xerces.parsers.SAXParser
configurationPath : ../conf/
logFile : ../logs/avalon.log
libPath : ../lib/
blockPath : ./blocks/
Scanning jars for new Blocks...
Reading configuration
Avalon 2.2-dev
2002.04.15 10:30:06 421 Channel default opened
loading broker properties from file:/d:/james/var/maildatabase
-------------
1: SELECT message_name FROM MESSAGE WHERE repository_name = 'mainspool'
ORDER BY
last_updated
-------------
null
-------------
java.lang.NullPointerException
at com.workingdogs.town.DataSet.fetchRecords(DataSet.java:476)
at com.workingdogs.town.DataSet.fetchRecords(DataSet.java:429)
at com.workingdogs.town.DataSet.fetchRecords(DataSet.java:382)
at com.workingdogs.town.DataSet.size(DataSet.java:976)
at
org.apache.james.mailrepository.TownSpoolRepository.list(TownSpoolRep
ository.java:258)
at
org.apache.james.mailrepository.TownSpoolRepository.accept(TownSpoolR
epository.java:271)
at
org.apache.james.transport.JamesSpoolManager.run(JamesSpoolManager.ja
va:139)
at
org.apache.avalon.utils.recycle.pool.Worker.run(Worker.java:113)
"Danny Angus" <[EMAIL PROTECTED]>
15.04.2002 09:57
Please respond to "James Users List"
To: "James Users List" <[EMAIL PROTECTED]>
cc:
Subject: RE: MS SQL Server 2000 JDBC Driver configuration
Hi,
were there any log messages or exceptions on the console when you started
up
James?
It might be worth trying "standard" URL syntax like .. (I assume
"jdbc:microsoft:sqlserver:" is correct)
jdbcURL=jdbc:microsoft:sqlserver://192.168.1.1:1433/abc
or
jdbcURL=jdbc:microsoft:sqlserver://192.168.1.1:1433/?DatabaseName=abc
.. if you havent already.
d.
> -----Original Message-----
> Subject: MS SQL Server 2000 JDBC Driver configuration
>
>
> I'm looking for a '/var/maildatabase' configuration for the new MS SQL
> Server 2000 JDBC Driver (Beta 2).
>
> I tried this, but it doesn't work:
>
>
> jdbcDriver=com.microsoft.jdbc.sqlserver.SQLServerDriver
> jdbcURL=jdbc:microsoft:sqlserver://192.168.1.1:1433;DatabaseName=abc
> jdbcUsername=abcd
> jdbcPassword=abcde
> minconn=1
> maxconn=2
>
>
> Thank you.
--
To unsubscribe, e-mail: <mailto:[EMAIL PROTECTED]>
For additional commands, e-mail: <mailto:[EMAIL PROTECTED]>
