can we document this somewhere?
marc
> -----Original Message-----
> From: [EMAIL PROTECTED]
> [mailto:[EMAIL PROTECTED]]On Behalf Of PHIPPS MARK
> Sent: Friday, September 15, 2000 7:52 AM
> To: jBoss
> Subject: RE: [jBoss-User] Sybase connectivity problems
>
>
> 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]
>
>
--
--------------------------------------------------------------
To subscribe: [EMAIL PROTECTED]
To unsubscribe: [EMAIL PROTECTED]
Problems?: [EMAIL PROTECTED]
