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.SybDri
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:154)
[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:154)
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]
