Actually, it was only one of the 3 jars (why do they need 3?!) that was 'corrupt', the msjdbc.jar I think. I unzipped the contents, then used Winzip to recreate the jar and it works fine.
----- Original Message ----- From: "Morten Wilken" <[EMAIL PROTECTED]> To: "Orion-Interest" <[EMAIL PROTECTED]> Sent: Saturday, November 17, 2001 4:23 AM Subject: Re: Microsoft JDBC Driver - Issues w/ Data Source > hi geoff... i think that the jar files for the driver is corrupt somehow... > i solved the problem by unzipping them and voila it worked > > also remember to set the correct database schema in the datasource > > sincerely > morten wilken > ----- Original Message ----- > From: <[EMAIL PROTECTED]> > To: "Orion-Interest" <[EMAIL PROTECTED]> > Sent: 16. november 2001 17:25 > Subject: Microsoft JDBC Driver - Issues w/ Data Source > > > > I'm having some issues with using the Microsoft SQL Server JDBC Driver > with > > Orion. > > > > Let me give you some context: > > > > Although I have some past experience with Orion (servlets, beans, jsp), > I've > > never used its Data Sources, so I know next to nothing about them. And, > > although the community and documentation have improved of late, Orion's > > documentation is still pretty sparse. When it came time to spend some > time > > with EJB, I moved over to JBoss, which has stronger documentation, for a > > while, and while on JBoss, I started making use of the Microsoft SQL > Server > > driver beta, which has proved to be quite reasonable (which is not too > > surprising, since it's the Merant driver). > > > > Due to some performance issues, I wanted to see how the application we're > > working on would run under Orion, so I downloaded the latest, and started > to > > try and configure it. The basic steps were still pretty easy, but now I'm > > stuck on the data source - no matter what I do, I can't seem to get Orion > to > > recognize the SQL Server driver. > > > > Has anyone tried it yet? Am I missing something obvious? > > > > I put the driver JARs (three of them: msbase, msutil, mssqlserver) in > > orion/lib. I modified the data-sources.xml to use the driver, as follows: > > <data-source > > > > name="MicrosoftSqlServer" > > > > location="jdbc/SqlServerDS" > > > > > > connection-driver="com.microsoft.jdbc.sqlserver.SQLServerDriver" > > > > > url="jdbc:microsoft:sqlserver://panthro:1433;DatabaseName=dbVoicenetDevGeoff > > ;SelectMethod=cursor" > > username="user" > > password="password" > > > > inactivity-timeout="30" > > class="com.evermind.sql.DriverManagerDataSource" > > > > /> > > > > When orion starts, it says the following: > > Error initializing data-source 'jdbc/SqlServerDS': DriverManagerDataSource > > driver 'com.microsoft.jdbc.sqlserver.SQLServerDriver' not found > > > > What does this mean? It can't find the driver? The JARs are in orion > lib, > > I've checked that several times, including that the driver name is right, > > and the class is in the JAR. I can't swear that Orion is loading the > JARs, > > because it doesn't put that out to the console or log files, so I don't > > really know that it's doing that, but I'm assuming it is. > > > > It does say 'DriverManagerdataSource driver', so perhaps the driver isn't > > what it's expecting. Should I be using another class? Based on the > > descriptions in the API docs and the Hypersonic example, this seems like a > > reasonable class to use. > > > > Suggestions? Anyone know where I can go from here? > > > > Thanks, > > > > - Geoffrey Wiseman > > > > __________________________________________________________ > > Geoffrey Wiseman: Internet Applications Manager > > Medium One > > t. 416.977.2101 x. 529 > > http://www.mediumone.com/ > > __________________________________________________________ > > Think it. Build it. Work it. > > > > > > > > > > > > >
