Actualy the windows version of the Sybase database is just as pleasant to
work with as SQL server when you use the gui tools. And a biiiig advantage
is that the jdbc driver that is made for the database is very pleasant to
work with :), and when you need extra performance you can set the server on
a Solaris machine and still use the windows admin tool against it for easy
administration. ASE12 allso supports java in the database something that can
be quite usefull if you have some routines that is neaded when you import
data to make sure things are allright and so on.
But don't missunderstand me, i allso use MS but not in a java environment
(if I can get around it)
Have fun!
Klaus
Prefers Sybase database :)
-----Opprinnelig melding-----
Fra: Jeff Schnitzer [mailto:[EMAIL PROTECTED]]
Sendt: 25. oktober 2000 09:34
Til: Orion-Interest
Emne: RE: Ok. I feel dumb. Data Sources and MS SQL.
Hey, there is nothing wrong with MS SQL Server and Win2K. As someone
who is not a professional DBA and has no desire to become one (I like
building things, not maintaining tempermenal third-party software
systems), I find that SQL Server is by far the most pleasant of the big
relational databases (Oracle, Sybase, DB2, Informix) to work with. The
GUI tools work well, and most tuning is done automagically.
The JDBC driver support is a bit of a problem, though. Conventional
wisdom 'round here is that the JDBC-ODBC bridge is trouble and should be
avoided in a production environment. It has native code and it will
lock up the JVM periodically under heavy load.
Someone on this list suggested this type IV driver:
http://www.inetsoftware.de/English/Produkte/JDBC2/Default.htm
The most basic license is $250, limited to 20 connections, and "may not
be used with the Internet", whatever that means. Dunno if this
restriction includes code running in an app server.
Here is my data source:
<data-source
class="com.evermind.sql.DriverManagerDataSource"
name="Similarity"
location="jdbc/SimilarityCoreDS"
xa-location="jdbc/xa/SimilarityXADS"
ejb-location="jdbc/SimilarityDS"
connection-driver="com.inet.tds.TdsDriver"
username="sa"
password="your_password_here"
url="jdbc:inetdae7:localhost:1433?database=Similarity"
inactivity-timeout="30"
schema="database-schemas/ms-sql.xml"
/>
Make sure you put SQL Server in Mixed Authentication Mode.
And take a vacation already!
Jeff
> -----Original Message-----
> From: Kimberley Scott [mailto:[EMAIL PROTECTED]]
> Sent: Tuesday, October 24, 2000 6:16 PM
> To: Orion-Interest
> Subject: Ok. I feel dumb. Data Sources and MS SQL.
>
>
> Hiya,
>
> Feeling real stupid here. I'm examining data sources and
> getting totally
> confused. Maybe I'm just burnt out. Haven't had a holiday in
> five years.
> Sigh.
>
> Back to business. We're *forced* to use Microsoft SQL 7 and
> Win2K. How do I
> set up the datasource xml file to handle this? I can't seem
> to find anything
> on this in the email lists on in the docs. The only drivers I
> have are the
> ODBC bridges (The invisible hidden MS one and the standard
> Sun one) and I'm
> not paying for a Type IV driver at the outrageous prices I've
> been presented
> with from BEA and the like. Has anyone done this before or
> can point me in
> the right direction?
>
> A tired developer who's feeling very old and dim...
>
> Kimberley Scott
> Senior Web Developer
> Peakhour Pty Ltd
> http://smartoffice.com.au <<- just built. needs work. ASP/COM
> Sigh. What can
> I say?
> http://peakhour.com.au <<- corporate site
> http://www.geocities.com/kimmie_scott <<-me
>
>
>
>
