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
>