Example/help Connecting JBoss 3.0 alpha to sybase

[bchand]

All,

I am having a heck of a time trying to connect JBoss 3.0 alpha to Sybase vi JConnect 5.2.

Does anyone have an example of such configuration. I tried mimicking the oracle/mysql/hqsl configurations to no avail. I can provide the example if someone needs it but I would perfer if someone could share a template. (ips and password removed to protect the innocent)

Thanks In advance for your assistance.

Brian

[jbossuser]

There's not enought detail in your message to help figure out your trouble. However, here's a suggestion.

Make sure you can connect to one of the other db's (mysql for instance, which is free and a relatively small download compared to oracle).

Then you'll know your problem is connecting to Sybase and not more general.

[l.g.]

Make sure to add jconn2.jar to classpath.

Connection parms:
com.sybase.jdbc2.jdbc.SybDriver
jdbc:sybase:Tds::/DBName

[bchand]

After Much fighting I "finally" got it to work. Perhaps this file below can make it onto the CVS area where the other examples are?

Thanks for the help

Brian



<?xml version="1.0" encoding="UTF-8"?>







ConnectionURL=jdbc:sybase:Tds:<ip.addr.x.x>:/
DriverClass=com.sybase.jdbc2.jdbc.SybDriver
UserName=
Password=

SybaseDS
java:/TransactionManager
<mbean-ref name="ResourceAdapterName">JCA:service=RARDeployment,name=Minerva JDBC LocalTransaction ResourceAdapter</mbean-ref>
<mbean-ref name="ConnectionManagerFactoryLoaderName">JCA:service=ConnectionManagerFactoryLoader,name=MinervaSharedLocalCMFactory</mbean-ref>
#
#Wed Aug 15 16:17:29 EDT 2001
BlockingTimeoutMillis=50000
IdleTimeoutMinutes=30
MaxSize=100
CleanupIntervalMinutes=10
MinSize=10
MaxIdleTimeoutPercent=1.0


org.jboss.resource.security.ManyToOnePrincipalMapping