Hi,

I use JConnect 5.2.  My setup's pretty simple, I have this in my
data-sources.xml:

 <data-source
  class="com.evermind.sql.DriverManagerDataSource"
  name="Sybase Adaptive Server on Luge"
  location="jdbc/SybaseCoreDS"
  xa-location="jdbc/xa/SybaseXADS"
  ejb-location="jdbc/SybaseDS"
  connection-driver="com.sybase.jdbc2.jdbc.SybDriver"
  username="sa"
  password="root123"
  url="jdbc:sybase:Tds:168.178.125.37:4100/ETSTest_SLCDevComp5?CHARSET=utf8"
  inactivity-timeout="30"
 />

(I beleive you can leave the CHARSET out of the URL.)  I pretty much mimicd
the default Hypersonic configuration, replacing my JDBC driver name and
"Hypersonic" with "Sybase".

Then I have this in my server.xml to get the JConnect jar in my classpath:

 <library path="C:\jdk1.3\lib;C:\JConnect-5_2\classes\jconn2.jar" />

I'm afraid I never did any direct JDBC access with this, so I couldn't tell
you about "pooled-location".  However, I thought the "ejb-location" was a
connection pool?

Mike

----- Original Message -----
From: "Boris Erukhimov" <[EMAIL PROTECTED]>
To: "Orion-Interest" <[EMAIL PROTECTED]>
Sent: Wednesday, July 04, 2001 1:50 AM
Subject: Data source for Sybase with Jconnect 5.2


> I'm trying to ask it second time.
>
> Does anyone use Jconnect 5.2 ?
> If so could you please share your data-source.xml and access code.
> I'm particularly interested to see how "pooled-location" works, not
> "ejb-location".
>
> Thanks
> ~boris
>


Reply via email to