All,
We have been using Orion & MS-SQL server successfully in a project.
The JDBC driver we are using is called Opta2000 (see
http://www.inetsoftware.de).
Here's an excerpt from our data-sources.xml:
<data-source
class="com.evermind.sql.DriverManagerDataSource"
name="NBWO_BACKEND"
location="core/NBWO_BACKEND"
xa-location="xa/NBWO_BACKEND"
ejb-location="NBWO_BACKEND"
connection-driver="com.inet.tds.TdsDriver"
username="sa"
password="sa"
url="jdbc:inetdae7:nbtodev:1433?database=nbwo_backend"
inactivity-timeout="120"
/>
We've had no troubles so far.
Regards,
Arjen Schoneveld
--
Dexels BV
The Netherlands
-----Oorspronkelijk bericht----- Van: Mitesh Pancholy
Verzonden: za 17-11-2001 0:29
Aan: Orion-Interest
CC:
Onderwerp: Re: Microsoft JDBC Driver - Issues w/ Data Source
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=dbVoicenetDevG
eoff
> ;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.
>
>
>
>
winmail.dat
Description: application/ms-tnef