Hmm, looks like the dirver is being found but it cant access the table > -----Original Message----- > From: [EMAIL PROTECTED] > [mailto:[EMAIL PROTECTED]] > Sent: 15 April 2002 09:37 > To: James Users List > Subject: RE: MS SQL Server 2000 JDBC Driver configuration > > > 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]>
-- To unsubscribe, e-mail: <mailto:[EMAIL PROTECTED]> For additional commands, e-mail: <mailto:[EMAIL PROTECTED]>
