Geoff, Orion & SQLServer = = bad combo, you will learn through suffering as we have :) What you need to do is to unzip the contents of the jar file under the lib folder, and you did reference all 3 files in the class path right. Also use the orion data source, don't use the msft source. So your data-source.xml should look like this. <data-source class="com.evermind.sql.DriverManagerDataSource" schema="database-schemas/ms-sql.xml" xa-location="XADS" location="DS" ejb-location="poolname" name="poolname" connection-driver="com.microsoft.jdbc.sqlserver.SQLServerDriver" url="jdbc:microsoft:sqlserver://servername:1433;DatabaseName=dbname" username="username" password="password" />
RANT: The people who are using Orion & Ms SQL Server need to start putting more knowledge on the list. I'll take the lead with some stuff, but people also need to contribute :) ----- Original Message ----- From: <[EMAIL PROTECTED]> To: "Orion-Interest" <[EMAIL PROTECTED]> Sent: Friday, November 16, 2001 8:25 AM 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. > > > >
