Hi Andrew and John!
I think you don't need to do this. At least I don't need it for a
working connection to mySQL. This might be, because jBoss uses minerva
by default now.
You need to do some work in:
jboss.properties, jboss.conf, jboss.jcml and just copy the jar to
lib/ext in the jBoss dir.
All jars in this dir are automatically added to the classpath, which you
can check when jBoss starts.
Good luck,
Tobias
"Nortje, Andrew" wrote:
>
> John
>
> I know you said you updated jboss.conf but just make sure you have
> j2conn.jar mentioned in jboss.conf, something like this...
>
> <MLET CODE="org.jboss.jdbc.XADataSourceLoader"
> ARCHIVE="jboss.jar,j2conn.jar" CODEBASE="../lib/ext/">
> <ARG TYPE="java.lang.String" VALUE="MyDataSource">
> <ARG TYPE="java.lang.String"
> VALUE="org.jboss.minerva.xa.XADataSourceImpl">
> </MLET>
>
> -----Original Message-----
> From: Dubchak, John [mailto:[EMAIL PROTECTED]]
> Sent: Wednesday, November 08, 2000 12:45 PM
> To: 'jBoss'
> Subject: RE: [jBoss-User] No Suitable Driver exception with Sybase
>
> I have added the following lines to jboss.properties:
>
> jdbc.drivers=com.sybase.jdbc2.jdbc.SybDriver
>
> and I am fairly confident that the URL to the database is correct, since I
> have used it in an actual java application to access that database prior to
> this.
>
> Do I need to do anything in addition to just adding the j2conn.jar to
> ../lib/ext, like add it in the run.bat file?
>
> Thanks for your help.
>
> John
>
> >> what is the db url you have supplied in .jcml file ?
>
> >> maybe you have syntax error/spelling mistake ?
>
> >> I have once spent 10 hours with this exception just to find
>
> >> out i missed a ":" in the url string
>
> -----Original Message-----
>
> From: [EMAIL PROTECTED]
>
> [mailto:[EMAIL PROTECTED]]On Behalf Of Dubchak, John
>
> Sent: Wednesday, November 08, 2000 5:42 PM
>
> To: '[EMAIL PROTECTED]'
>
> Subject: [jBoss-User] No Suitable Driver exception with Sybase
>
> Hello,
>
> I am attempting to configure our Sybase Database with JBoss BETA-PROD4. I
>
> have added the j2conn.jar file to the JBOSS_HOME\lib\ext subdirectory and
>
> modified jboss.jcml, jboss.properties and jboss.conf files to add the driver
>
> and XADataSource information.
>
> When I start JBoss (from a command line on NT4) I get the following
>
> exception:
>
> [SybaseDB] java.sql.SQLException: No suitable driver
>
> [SybaseDB] at java.sql.DriverManager.getConnection(Unknown Source)
>
> [SybaseDB] at java.sql.DriverManager.getConnection(Unknown Source)
>
> [SybaseDB] at
>
> org.jboss.minerva.xa.XADataSourceImpl.getXAConnection(XADataSourceImpl.java:
>
> 121)
>
> [SybaseDB] at
>
> org.jboss.minerva.xa.XADataSourceImpl.getXAConnection(XADataSourceImpl.java:
>
> 155)
>
> [SybaseDB] at
>
> org.jboss.minerva.factories.XAConnectionFactory.createObject(XAConnectionFac
>
> tory.java:232)
>
> [SybaseDB] at
>
> org.jboss.minerva.pools.ObjectPool.createNewObject(ObjectPool.java:801)
>
> [SybaseDB] at
>
> org.jboss.minerva.pools.ObjectPool.getObject(ObjectPool.java:549)
>
> [SybaseDB] at
>
> org.jboss.minerva.datasource.XAPoolDataSource.getConnection(XAPoolDataSource
>
> .java:169)
>
> [SybaseDB] at
>
> org.jboss.jdbc.XADataSourceLoader.initializePool(XADataSourceLoader.java:288
>
> )
>
> [SybaseDB] at
>
> org.jboss.jdbc.XADataSourceLoader.startService(XADataSourceLoader.java:252)
>
> [SybaseDB] at
>
> org.jboss.util.ServiceMBeanSupport.start(ServiceMBeanSupport.java:92)
>
> [SybaseDB] at java.lang.reflect.Method.invoke(Native Method)
>
> [SybaseDB] at
>
> com.sun.management.jmx.MBeanServerImpl.invoke(MBeanServerImpl.java:1628)
>
> [SybaseDB] at
>
> com.sun.management.jmx.MBeanServerImpl.invoke(MBeanServerImpl.java:1523)
>
> [SybaseDB] at
>
> org.jboss.dependencies.DependencyManager.startMBean(DependencyManager.java:2
>
> 84)
>
> [SybaseDB] at
>
> org.jboss.dependencies.DependencyManager.loadService(DependencyManager.java:
>
> 261)
>
> [SybaseDB] at
>
> org.jboss.dependencies.DependencyManager.processService(DependencyManager.ja
>
> va:243)
>
> [SybaseDB] at
>
> org.jboss.dependencies.DependencyManager.processService(DependencyManager.ja
>
> va:238)
>
> [SybaseDB] at
>
> org.jboss.dependencies.DependencyManager.processService(DependencyManager.ja
>
> va:238)
>
> [SybaseDB] at
>
> org.jboss.dependencies.DependencyManager.processService(DependencyManager.ja
>
> va:238)
>
> [SybaseDB] at
>
> org.jboss.dependencies.DependencyManager.startMBeans(DependencyManager.java:
>
> 117)
>
> [SybaseDB] at org.jboss.Main.<init>(Main.java:162)
>
> [SybaseDB] at org.jboss.Main$1.run(Main.java:87)
>
> [SybaseDB] at java.security.AccessController.doPrivileged(Native
>
> Method)
>
> [SybaseDB] at org.jboss.Main.main(Main.java:83)
>
> Any assistance is greatly appreciated.
>
> Thanks,
>
> John
>
> --
--
--------------------------------------------------------------
To subscribe: [EMAIL PROTECTED]
To unsubscribe: [EMAIL PROTECTED]
Problems?: [EMAIL PROTECTED]
