Chris,
I included the changes in theoriginal mail, but....
This has been solved with help from Peter Jasko. My database url was
incorrect.. (doh!)
it was:
jdbc:sybase:tds:......
it should be
jdbc:sybaseTds:.....
i.e. Tds not tds. Sybase users beware.....
Cheers
Mark Phipps
> -----Original Message-----
> From: Chris Audley [SMTP:[EMAIL PROTECTED]]
> Sent: 15 September 2000 15:14
> To: 'jBoss'
> Subject: RE: [jBoss-User] Sybase connectivity problems
>
> You say you've edited the jboss.conf and jboss.properties as directed, but
> dont be shy, let us have a gander at what you added.
>
> -----Original Message-----
> From: PHIPPS MARK [mailto:[EMAIL PROTECTED]]
> Sent: Friday, September 15, 2000 4:53 AM
> To: jBoss
> Subject: [jBoss-User] Sybase connectivity problems
>
>
> Hi everyone,
>
> I have just started using jBoss and I need to set up a Sybase database
> connection.
> Following the tutorials, I have installed the sybase jConnect jdbc 2
> driver
> (v5.2) and edited the jboss.conf and jboss.properties files as directed.
> However, when I start jBoss, I get a stacktrace from an exception:
>
> java.sql.SQLException: JZ0D5: Error loading protocol
> com.sybase.jdbc2.tds.tds.
>
> I'm a long time user of sybase jConnect and I've never heard of the
> "com.sybase.jdbc2.tds.tds" protocol. It seems to me that some string
> concatenation is occuring inside jBoss but is coming up with something
> weird
> - I hope, because I've forgotten to set something else that's important.
>
> Can anyone give me definitive guidelines to set up jBoss for Sybase
> please?
> Please see below.
>
> Many many thanks in advance,
>
> Mark Phipps
>
> ******
> Part contents of jboss.conf (rest of file is unchanged from original):
>
> <MLET CODE = "org.jboss.jdbc.DataSourceImpl"
> ARCHIVE="jboss.jar,jconn2.jar"
> CODEBASE="../lib/ext/">
> <ARG TYPE="java.lang.String"
> VALUE="jdbc:sybase:tds:ibjidev2:4100/CustodyFee">
> <ARG TYPE="java.lang.String" VALUE="CustodyFee">
> <ARG TYPE="java.lang.String" VALUE="com.sybase.jdbc2.jdbc.SybDriver">
> <ARG TYPE="java.lang.String" VALUE="phipma">
> <ARG TYPE="java.lang.String" VALUE="phipma">
> </MLET>
>
> ******
> Part contents of jboss.properties (rest of file is unchanged from
> original):
>
> jdbc.drivers=org.hsql.jdbcDriver,jdbc.idbDriver,com.sybase.jdbc2.jdbc.SybD
> ri
> ver,oracle.jdbc.driver.OracleDriver
>
> ******
> Output from jBoss console:
>
> C:\jboss\bin>run.bat
> [Console logging] Logging started
> [Classpath] Added directory:file:/C:/jboss/log/
> [Info] Java version: 1.3.0,Sun Microsystems Inc.
> [Info] Java VM: Java HotSpot(TM) Client VM 1.3.0-C,Sun Microsystems Inc.
> [Info] System: Windows NT 4.0,x86
> [Classpath] Added directory:file:/C:/jboss/db/
> [Classpath] Added library:file:/C:/jboss/lib/ext/activation.jar
> [Classpath] Added library:file:/C:/jboss/lib/ext/awt.jar
> [Classpath] Added library:file:/C:/jboss/lib/ext/dynaserver.jar
> [Classpath] Added library:file:/C:/jboss/lib/ext/ejb.jar
> [Classpath] Added library:file:/C:/jboss/lib/ext/ejxeditor.jar
> [Classpath] Added library:file:/C:/jboss/lib/ext/ejxejb.jar
> [Classpath] Added library:file:/C:/jboss/lib/ext/ejxjaws.jar
> [Classpath] Added library:file:/C:/jboss/lib/ext/ejxjboss.jar
> [Classpath] Added library:file:/C:/jboss/lib/ext/hsql.jar
> [Classpath] Added library:file:/C:/jboss/lib/ext/idb.jar
> [Classpath] Added library:file:/C:/jboss/lib/ext/jboss.jar
> [Classpath] Added library:file:/C:/jboss/lib/ext/jdbc2_0-stdext.jar
> [Classpath] Added library:file:/C:/jboss/lib/ext/jmxtools.jar
> [Classpath] Added library:file:/C:/jboss/lib/ext/jndi.jar
> [Classpath] Added library:file:/C:/jboss/lib/ext/jnpserver.jar
> [Classpath] Added library:file:/C:/jboss/lib/ext/jpl-util-0_5b.jar
> [Classpath] Added library:file:/C:/jboss/lib/ext/jta-spec1_0_1.jar
> [Classpath] Added library:file:/C:/jboss/lib/ext/mail.jar
> [Classpath] Added library:file:/C:/jboss/lib/ext/xml.jar
> [Classpath] Added library:file:/C:/jboss/lib/ext/jconn2.jar
> [Classpath] Added library:file:/C:/jboss/lib/ext/classes12_01.jar
> [JDBC] Loaded JDBC-driver:org.hsql.jdbcDriver
> [JDBC] Loaded JDBC-driver:jdbc.idbDriver
> [JDBC] Loaded JDBC-driver:com.sybase.jdbc2.jdbc.SybDriver
> [JDBC] Loaded JDBC-driver:oracle.jdbc.driver.OracleDriver
> [Webserver] Initializing
> [Webserver] Initialized
> [Hypersonic] Initializing
> [Hypersonic] Server 1.4 is running
> [Hypersonic] Database started
> [Hypersonic] Initialized
> [Naming] Initializing
> [Naming] Naming started on port 1099
> [Naming] Initialized
> [Transaction manager] Initializing
> [Transaction manager] Initialized
> [Simple Realm Mapping] Initializing
> [Simple Realm Mapping] Initialized
> [Security manager] Initializing
> [Security manager] Initialized
> [DataSource] Initializing
> [DataSource] Connection pool for jdbc:idb:../conf/instantdb.properties
> bound
> to InstantDB
> InstantDB - Version 3.12
> [DataSource] Copyright (c) 1997-1999 Instant Computer Solutions Ltd.
> [DataSource] Initialized
> [DataSource] Initializing
> [DataSource] Connection pool for jdbc:HypersonicSQL:hsql://localhost bound
> to Hypersonic
> [DataSource] Initialized
> [DataSource] Initializing
> [DataSource] Connection pool for jdbc:sybase:tds:ibjidev2:4100/CustodyFee
> bound to CustodyFee
> [DataSource] Initialization failed
> [DataSource] java.sql.SQLException: JZ0D5: Error loading protocol
> com.sybase.jdbc2.tds.tds.
> [DataSource] at
> com.sybase.jdbc2.jdbc.ErrorMessage.raiseError(ErrorMessage.java:423)
> [DataSource] at
> com.sybase.jdbc2.jdbc.ProtocolManager.getProtocol(ProtocolManager.java:102
> )
> [DataSource] at
> com.sybase.jdbc2.jdbc.SybUrlManager.loadProtocol(SybUrlManager.java:191)
> [DataSource] at
> com.sybase.jdbc2.jdbc.SybUrlManager.init(SybUrlManager.java:133)
> [DataSource] at
> com.sybase.jdbc2.jdbc.SybUrlManager.getUrlProvider(SybUrlManager.java:110)
> [DataSource] at
> com.sybase.jdbc2.jdbc.SybDriver.connect(SybDriver.java:167)
> [DataSource] at java.sql.DriverManager.getConnection(Unknown Source)
> [DataSource] at java.sql.DriverManager.getConnection(Unknown Source)
> [DataSource] at
> org.jboss.jdbc.DataSourceImpl.getConnection(DataSourceImpl.java:134)
> [DataSource] at
> org.jboss.jdbc.DataSourceImpl.getConnection(DataSourceImpl.java:125)
> [DataSource] at
> org.jboss.jdbc.DataSourceImpl.initService(DataSourceImpl.java:105)
> [DataSource] at
> org.jboss.util.ServiceMBeanSupport.init(ServiceMBeanSupport.java:64)
> [DataSource] at
> org.jboss.util.ServiceMBeanSupport.preRegister(ServiceMBeanSupport.java:15
> 4)
> [DataSource] at java.lang.reflect.Method.invoke(Native Method)
> [DataSource] at
> javax.management.MBeanServer.preRegisterInvoker(MBeanServer.java:2253)
> [DataSource] at
> javax.management.MBeanServer.createMBean(MBeanServer.java:721)
> [DataSource] at
> javax.management.loading.MLet.getMBeansFromURL(MLet.java:385)
> [DataSource] at
> javax.management.loading.MLet.getMBeansFromURL(MLet.java:208)
> [DataSource] at org.jboss.Main.<init>(Main.java:111)
> [DataSource] at org.jboss.Main.<init>(Main.java:86)
> [DataSource] at org.jboss.Main$1.run(Main.java:76)
> [DataSource] at java.security.AccessController.doPrivileged(Native
> Method)
> [DataSource] at org.jboss.Main.main(Main.java:67)
> [Container factory] Initializing
> [Container factory] Initialized
> [Auto deploy] Watching C:\jboss\deploy
> [Auto deployer] Initializing
> [Auto deployer] Initialized
> [JMX RMI Adaptor] Initializing
> [JMX RMI Adaptor] Initialized
> java.sql.SQLException: JZ0D5: Error loading protocol
> com.sybase.jdbc2.tds.tds.
> at
> com.sybase.jdbc2.jdbc.ErrorMessage.raiseError(ErrorMessage.java:423)
> at
> com.sybase.jdbc2.jdbc.ProtocolManager.getProtocol(ProtocolManager.java:102
> )
> at
> com.sybase.jdbc2.jdbc.SybUrlManager.loadProtocol(SybUrlManager.java:191)
> at
> com.sybase.jdbc2.jdbc.SybUrlManager.init(SybUrlManager.java:133)
> at
> com.sybase.jdbc2.jdbc.SybUrlManager.getUrlProvider(SybUrlManager.java:110)
> at com.sybase.jdbc2.jdbc.SybDriver.connect(SybDriver.java:167)
> at java.sql.DriverManager.getConnection(Unknown
> Source)[Configuration] Initializing
> [Configuration] Initialized
>
> at java.sql.DriverManager.getConnection(Unknown Source)
> at
> org.jboss.jdbc.DataSourceImpl.getConnection(DataSourceImpl.java:134)
> at
> org.jboss.jdbc.DataSourceImpl.getConnection(DataSourceImpl.java:125)
> at
> org.jboss.jdbc.DataSourceImpl.initService(DataSourceImpl.java:105)
> at
> org.jboss.util.ServiceMBeanSupport.init(ServiceMBeanSupport.java:64)
> at
> org.jboss.util.ServiceMBeanSupport.preRegister(ServiceMBeanSupport.java:15
> 4)
> at java.lang.reflect.Method.invoke(Native Method)
> at
> javax.management.MBeanServer.preRegisterInvoker(MBeanServer.java:2253)
> at javax.management.MBeanServer.createMBean(MBeanServer.java:721)
> at javax.management.loading.MLet.getMBeansFromURL(MLet.java:385)
> at javax.management.loading.MLet.getMBeansFromURL(MLet.java:208)
> at org.jboss.Main.<init>(Main.java:111)
> at org.jboss.Main.<init>(Main.java:86)
> at org.jboss.Main$1.run(Main.java:76)
> at java.security.AccessController.doPrivileged(Native Method)
> at org.jboss.Main.main(Main.java:67)
> [Configuration] MaxActiveClientCount set to 10 in Adaptor:name=html
> [Configuration] Port set to 8082 in Adaptor:name=html
> at org.jboss.Main.<init>(Main.java:152)
> at org.jboss.Main.<init>(Main.java:86)
> at org.jboss.Main$1.run(Main.java:76)
> at java.security.AccessController.doPrivileged(Native Method)
> at org.jboss.Main.main(Main.java:67)
> [Configuration] LibraryDirectory set to C:\jboss\bin in
> DefaultDomain:service=MLet
> [Configuration] Format set to [{2}] {4} in
> DefaultDomain:service=Logging,type=Console
> [Configuration] Port set to 8083 in DefaultDomain:service=Webserver
> [Configuration] VerifyDeployments set to false in
> EJB:service=ContainerFactory
> [Simple Realm Mapping] Starting
> [Simple Realm Mapping] Started
> [Default] java.lang.ClassCastException:
> javax.management.MBeanRegistrationException
> [Default] jBoss 2.0 Started
>
>
>
> +----------------------------------------------------------------+
> This message and any files transmitted with it are confidential
> and intended solely for the use of the individual or entity to
> whom they are addressed. If you have received this message in
> error please delete it and any files transmitted with it, after
> notifying [EMAIL PROTECTED]
>
> Any opinions expressed in this message may be those of the author
> and not necessarily those of the Company. The Company accepts no
> responsibility for the accuracy or completeness of any information
> contained herein. This message is not intended to create legal
> relations between the Company and the recipient.
>
> Recipients should please note that messages sent via the internet
> may be intercepted and that caution should therefore be exercised
> before despatching to the Company any confidential or sensitive
> information.
> +----------------------------------------------------------------+
>
>
> --
> --------------------------------------------------------------
> To subscribe: [EMAIL PROTECTED]
> To unsubscribe: [EMAIL PROTECTED]
> Problems?: [EMAIL PROTECTED]
>
>
> --
> --------------------------------------------------------------
> To subscribe: [EMAIL PROTECTED]
> To unsubscribe: [EMAIL PROTECTED]
> Problems?: [EMAIL PROTECTED]
+----------------------------------------------------------------+
This message and any files transmitted with it are confidential
and intended solely for the use of the individual or entity to
whom they are addressed. If you have received this message in
error please delete it and any files transmitted with it, after
notifying [EMAIL PROTECTED]
Any opinions expressed in this message may be those of the author
and not necessarily those of the Company. The Company accepts no
responsibility for the accuracy or completeness of any information
contained herein. This message is not intended to create legal
relations between the Company and the recipient.
Recipients should please note that messages sent via the internet
may be intercepted and that caution should therefore be exercised
before despatching to the Company any confidential or sensitive
information.
+----------------------------------------------------------------+
--
--------------------------------------------------------------
To subscribe: [EMAIL PROTECTED]
To unsubscribe: [EMAIL PROTECTED]
Problems?: [EMAIL PROTECTED]
