It looks like the driver you're using is a Type 2 driver, so you
need to get the native libraries configured properly. Frankly, I've never
tried this with an all-Java server - but it may work if they're on your
PATH or something.
I suspect the easier solution would be for you to use a Type
3/4 driver like the "thin" driver that Oracle distributes. If for some
reason you feel compelled to use an OCI driver, see what you have to do to
get them running in a "plain" Java program first (PATH, LD_LIBRARY_PATH,
etc.). Then you should be able to get that going in jBoss.
I suspect WebLogic just has the hooks in their scripts or code
already, since it sounds like they distribute the native library.
Finally, is there a reason why you prefer WebLogic's driver to
Oracle's? Oracle has both an OCI and a pure Java driver...
Aaron
On Fri, 3 Nov 2000, Georgi Kostadinov wrote:
> Hello folks!
>
> First. I would like to say that jBOSS is the easiest app server
> to set up and work with! Great job folks! Thank you!
>
> I've been usinf jBOSS for EJB development and testing. I certainly
> think that I'll be able to use it for production too!
>
>
> I got the following problem when I tried to use WebLogic's jDriver
> (former JDBC Kona drivers) with jBOSS. I have an Oracle 8.1.5 db.
> I downloaded the latest jDriver pack and jarred it's classes dir.
> Here's it's content:
>
>=======================================================================================
> 0 Fri Nov 03 21:43:18 PST 2000 META-INF/
> 68 Fri Nov 03 21:43:18 PST 2000 META-INF/MANIFEST.MF
> 0 Fri Nov 03 21:40:50 PST 2000 weblogic/
> 0 Fri Nov 03 21:40:50 PST 2000 weblogic/boot/
> 278 Fri Apr 14 13:46:02 PDT 2000 weblogic/boot/ClassFinder.class
> 372 Fri Apr 14 13:46:02 PDT 2000 weblogic/boot/Source.class
> 2162 Fri Apr 14 13:46:02 PDT 2000 weblogic/boot/ZipSource.class
> 0 Fri Nov 03 21:40:50 PST 2000 weblogic/common/
> 0 Fri Nov 03 21:40:50 PST 2000 weblogic/common/internal/
> 694 Fri Apr 14 13:46:00 PDT 2000
> weblogic/common/internal/FileInfo$MakeNevDate.class
> 9211 Fri Apr 14 13:46:00 PDT 2000
> weblogic/common/internal/FileInfo.class
> 6586 Fri Apr 14 13:46:02 PDT 2000
> weblogic/common/internal/FileManager.class
> 785 Fri Apr 14 13:46:02 PDT 2000
> weblogic/common/internal/FileManagerRecord.class
> 5373 Fri Apr 14 13:46:02 PDT 2000
> weblogic/common/internal/LicenseInfo.class
> 2682 Fri Apr 14 13:46:02 PDT 2000 weblogic/common/internal/Misc.class
> 8374 Fri Apr 14 13:46:02 PDT 2000
> weblogic/common/internal/ServerUtil.class
> 4902 Fri Apr 14 13:46:02 PDT 2000
> weblogic/common/internal/VectorTable.class
> 406 Fri Apr 14 13:46:02 PDT 2000
> weblogic/common/LicenseCorruptException.class
> 443 Fri Apr 14 13:46:00 PDT 2000
> weblogic/common/LicenseException.class
> 384 Fri Apr 14 13:46:02 PDT 2000
> weblogic/common/LicenseInvalidException.class
> 390 Fri Apr 14 13:46:02 PDT 2000
> weblogic/common/LicenseKeyExpiredException.class
> 390 Fri Apr 14 13:46:02 PDT 2000
> weblogic/common/LicenseKeyInvalidException.class
> 380 Fri Apr 14 13:46:02 PDT 2000
> weblogic/common/LicenseKeyIpException.class
> 392 Fri Apr 14 13:46:02 PDT 2000
> weblogic/common/LicenseKeyNotFoundException.class
> 1769 Fri Apr 14 13:46:02 PDT 2000
> weblogic/common/LicenseNotFoundException.class
> 9000 Fri Apr 14 13:46:02 PDT 2000 weblogic/common/ParamSet.class
> 538 Fri Apr 14 13:46:02 PDT 2000
> weblogic/common/ParamSetException.class
> 1412 Fri Apr 14 13:46:02 PDT 2000 weblogic/common/ParamTypes.class
> 18949 Fri Apr 14 13:46:02 PDT 2000 weblogic/common/ParamValue.class
> 1870 Fri Apr 14 13:46:00 PDT 2000 weblogic/common/T3Exception.class
> 1711 Fri Apr 14 13:46:00 PDT 2000 weblogic/common/WLObjectInput.class
> 1690 Fri Apr 14 13:46:00 PDT 2000 weblogic/common/WLObjectOutput.class
> 427 Fri Apr 14 13:46:00 PDT 2000 weblogic/common/WLSerializable.class
> 0 Fri Nov 03 21:40:50 PST 2000 weblogic/db/
> 0 Fri Nov 03 21:40:50 PST 2000 weblogic/db/oci/
> 572 Fri Apr 14 13:46:02 PDT 2000 weblogic/db/oci/DateHolder.class
> 1874 Fri Apr 14 13:46:02 PDT 2000
> weblogic/db/oci/OciBlobInputStream.class
> 1280 Fri Apr 14 13:46:02 PDT 2000
> weblogic/db/oci/OciCharInputStream.class
> 2589 Fri Apr 14 13:46:02 PDT 2000
> weblogic/db/oci/OciClobCharStream.class
> 5659 Fri Apr 14 13:46:00 PDT 2000 weblogic/db/oci/OciColumn.class
> 24481 Fri Apr 14 13:46:02 PDT 2000 weblogic/db/oci/OciConnection.class
> 28320 Fri Apr 14 13:46:00 PDT 2000 weblogic/db/oci/OciCursor.class
> 2349 Fri Apr 14 13:46:02 PDT 2000 weblogic/db/oci/OciInputStream.class
> 8820 Fri Apr 14 13:46:02 PDT 2000 weblogic/db/oci/OciLob.class
> 4043 Fri Apr 14 13:46:02 PDT 2000
> weblogic/db/oci/OciLobInputStream.class
> 3244 Fri Apr 14 13:46:02 PDT 2000 weblogic/db/oci/OciLobReader.class
> 3242 Fri Apr 14 13:46:36 PDT 2000
> weblogic/db/oci/OciOutputStream.class
> 2444 Fri Apr 14 13:46:36 PDT 2000 weblogic/db/oci/OciReader.class
> 2698 Fri Apr 14 13:46:02 PDT 2000 weblogic/db/oci/OciSchema.class
> 7682 Fri Apr 14 13:46:02 PDT 2000 weblogic/db/oci/OciValue.class
> 3263 Fri Apr 14 13:46:36 PDT 2000 weblogic/db/oci/OciWriter.class
> 1738 Fri Apr 14 13:46:02 PDT 2000 weblogic/db/oci/PCUtils.class
> 0 Fri Nov 03 21:40:50 PST 2000 weblogic/jdbc/
> 0 Fri Nov 03 21:40:50 PST 2000 weblogic/jdbc/common/
> 0 Fri Nov 03 21:40:50 PST 2000 weblogic/jdbc/common/internal/
> 262 Fri Apr 14 13:46:02 PDT 2000
> weblogic/jdbc/common/internal/Cancelable.class
> 892 Fri Apr 14 13:46:02 PDT 2000
> weblogic/jdbc/common/internal/ConnectionID.class
> 422 Fri Apr 14 13:46:00 PDT 2000
> weblogic/jdbc/common/internal/EventClient.class
> 280 Fri Apr 14 13:46:02 PDT 2000
> weblogic/jdbc/common/internal/FetchSizeSettable.class
> 11771 Fri Apr 14 13:46:02 PDT 2000
> weblogic/jdbc/common/internal/JdbcExpandedSqlParser.class
> 2666 Fri Apr 14 13:46:02 PDT 2000
> weblogic/jdbc/common/internal/JdbcSqlExpander.class
> 277 Fri Apr 14 13:46:02 PDT 2000
> weblogic/jdbc/common/internal/Parseable.class
> 231 Fri Apr 14 13:46:00 PDT 2000
> weblogic/jdbc/common/internal/Waitable.class
> 591 Fri Apr 14 13:46:00 PDT 2000
> weblogic/jdbc/common/internal/WLConnectionInfo.class
> 408 Fri Apr 14 13:46:02 PDT 2000
> weblogic/jdbc/common/internal/WLDriverInfo.class
> 339 Fri Apr 14 13:46:02 PDT 2000
> weblogic/jdbc/common/OracleCallableStatement.class
> 265 Fri Apr 14 13:46:00 PDT 2000
> weblogic/jdbc/common/OracleConnection.class
> 228 Fri Apr 14 13:46:00 PDT 2000
> weblogic/jdbc/common/OracleLobCloser.class
> 0 Fri Nov 03 21:40:50 PST 2000 weblogic/jdbc/oci/
> 546 Fri Apr 14 13:46:04 PDT 2000
> weblogic/jdbc/oci/CallableStatement.class
> 1763 Fri Apr 14 13:46:04 PDT 2000 weblogic/jdbc/oci/Connection.class
> 292 Fri Apr 14 13:46:04 PDT 2000
> weblogic/jdbc/oci/DatabaseMetaData.class
> 1724 Fri Apr 14 13:46:04 PDT 2000 weblogic/jdbc/oci/Driver.class
> 317 Fri Apr 14 13:46:04 PDT 2000
> weblogic/jdbc/oci/PreparedStatement.class
> 777 Fri Apr 14 13:46:04 PDT 2000 weblogic/jdbc/oci/ResultSet.class
> 295 Fri Apr 14 13:46:04 PDT 2000
> weblogic/jdbc/oci/ResultSetMetaData.class
> 539 Fri Apr 14 13:46:04 PDT 2000 weblogic/jdbc/oci/Statement.class
> 394 Fri Apr 14 13:46:04 PDT 2000 weblogic/jdbc/oci/version.class
> 1607 Fri Apr 14 13:46:04 PDT 2000 weblogic/jdbc/oci/XADriver.class
> 0 Fri Nov 03 21:40:50 PST 2000 weblogic/jdbc20/
> 0 Fri Nov 03 21:40:50 PST 2000 weblogic/jdbc20/common/
> 258 Fri Apr 14 13:46:36 PDT 2000
> weblogic/jdbc20/common/OracleBlob.class
> 323 Fri Apr 14 13:46:36 PDT 2000
> weblogic/jdbc20/common/OracleClob.class
> 0 Fri Nov 03 21:40:50 PST 2000 weblogic/jdbc20/oci/
> 3718 Fri Apr 14 13:46:34 PDT 2000 weblogic/jdbc20/oci/Blob.class
> 4709 Fri Apr 14 13:46:34 PDT 2000
> weblogic/jdbc20/oci/CallableStatement.class
> 4731 Fri Apr 14 13:46:34 PDT 2000 weblogic/jdbc20/oci/Clob.class
> 2285 Fri Apr 14 13:46:34 PDT 2000 weblogic/jdbc20/oci/Connection.class
> 1591 Fri Apr 14 13:46:34 PDT 2000
> weblogic/jdbc20/oci/DatabaseMetaData.class
> 1217 Fri Apr 14 13:46:34 PDT 2000 weblogic/jdbc20/oci/Driver.class
> 2917 Fri Apr 14 13:46:34 PDT 2000
> weblogic/jdbc20/oci/PreparedStatement.class
> 11443 Fri Apr 14 13:46:34 PDT 2000 weblogic/jdbc20/oci/ResultSet.class
> 1086 Fri Apr 14 13:46:36 PDT 2000
> weblogic/jdbc20/oci/ResultSetMetaData.class
> 2365 Fri Apr 14 13:46:36 PDT 2000 weblogic/jdbc20/oci/Statement.class
> 366 Fri Apr 14 13:46:36 PDT 2000 weblogic/jdbc20/oci/version.class
> 0 Fri Nov 03 21:40:50 PST 2000 weblogic/jdbcbase/
> 0 Fri Nov 03 21:40:50 PST 2000 weblogic/jdbcbase/oci/
> 13899 Fri Apr 14 13:46:20 PDT 2000
> weblogic/jdbcbase/oci/Connection.class
> 29891 Fri Apr 14 13:46:20 PDT 2000
> weblogic/jdbcbase/oci/DatabaseMetaData.class
> 8042 Fri Apr 14 13:46:26 PDT 2000 weblogic/jdbcbase/oci/Driver.class
> 17651 Fri Apr 14 13:46:28 PDT 2000
> weblogic/jdbcbase/oci/ResultSet.class
> 3549 Fri Apr 14 13:46:28 PDT 2000
> weblogic/jdbcbase/oci/ResultSetMetaData.class
> 26116 Fri Apr 14 13:46:30 PDT 2000
> weblogic/jdbcbase/oci/Statement.class
> 5558 Fri Apr 14 13:46:30 PDT 2000 weblogic/jdbcbase/oci/XADriver.class
> 0 Fri Nov 03 21:40:50 PST 2000 weblogic/rmi/
> 634 Fri Apr 14 13:46:00 PDT 2000 weblogic/rmi/RemoteException.class
> 0 Fri Nov 03 21:40:50 PST 2000 weblogic/utils/
> 1281 Fri Apr 14 13:46:02 PDT 2000 weblogic/utils/AssertionError.class
> 0 Fri Nov 03 21:40:50 PST 2000 weblogic/utils/classloaders/
> 3044 Fri Apr 14 13:46:02 PDT 2000
> weblogic/utils/classloaders/ClasspathClassFinder.class
> 1467 Fri Apr 14 13:46:02 PDT 2000
> weblogic/utils/classloaders/FileSource.class
> 422 Fri Apr 14 13:46:02 PDT 2000 weblogic/utils/Counter.class
> 3281 Fri Apr 14 13:46:02 PDT 2000 weblogic/utils/Debug.class
> 3125 Fri Apr 14 13:46:02 PDT 2000 weblogic/utils/Hex.class
> 1381 Fri Apr 14 13:46:02 PDT 2000 weblogic/utils/I18nDescriptor.class
> 2879 Fri Apr 14 13:46:00 PDT 2000 weblogic/utils/I18nException.class
> 3537 Fri Apr 14 13:46:00 PDT 2000 weblogic/utils/I18nString.class
> 428 Fri Apr 14 13:46:00 PDT 2000
> weblogic/utils/InconsistentStructureException.class
> 0 Fri Nov 03 21:40:50 PST 2000 weblogic/utils/io/
> 414 Fri Apr 14 13:46:02 PDT 2000
> weblogic/utils/io/FilenameEncoder$UnsafeFilenameException.class
> 2639 Fri Apr 14 13:46:02 PDT 2000
> weblogic/utils/io/FilenameEncoder.class
> 2513 Fri Apr 14 13:46:02 PDT 2000 weblogic/utils/Location.class
> 0 Fri Nov 03 21:40:50 PST 2000 weblogic/utils/model/
> 276 Fri Apr 14 13:46:00 PDT 2000 weblogic/utils/model/I18nDef.class
> 333 Fri Apr 14 13:46:00 PDT 2000
> weblogic/utils/model/I18nExceptionDef.class
> 337 Fri Apr 14 13:46:00 PDT 2000
> weblogic/utils/model/I18nStringDef.class
> 1400 Fri Apr 14 13:46:02 PDT 2000 weblogic/utils/NestedError.class
> 1651 Fri Apr 14 13:46:00 PDT 2000
> weblogic/utils/NestedThrowable$Util.class
> 427 Fri Apr 14 13:46:00 PDT 2000 weblogic/utils/NestedThrowable.class
> 987 Fri Apr 14 13:46:00 PDT 2000
> weblogic/utils/ObjectNotFoundException.class
> 543 Fri Apr 14 13:46:02 PDT 2000
> weblogic/utils/PlatformConstants.class
> 2836 Fri Apr 14 13:46:02 PDT 2000 weblogic/utils/RfcUtils.class
> 1536 Fri Apr 14 13:46:02 PDT 2000 weblogic/utils/StackTrace.class
> 754 Fri Apr 14 13:46:00 PDT 2000 weblogic/utils/StackTraceUtils.class
> 6077 Fri Apr 14 13:46:00 PDT 2000 weblogic/utils/StringUtils.class
> 4503 Fri Apr 14 13:46:02 PDT 2000
> weblogic/utils/UnsyncStringBuffer.class
> 0 Fri Nov 03 21:40:50 PST 2000 weblogic/utils/zip/
> 1192 Fri Apr 14 13:46:02 PDT 2000 weblogic/utils/zip/Handler.class
> 799 Fri Apr 14 13:46:02 PDT 2000
> weblogic/utils/zip/SafeZipFileInputStream.class
> 969 Fri Apr 14 13:46:02 PDT 2000 weblogic/utils/zip/ZipFactory.class
> 1182 Fri Apr 14 13:46:02 PDT 2000
> weblogic/utils/zip/ZipURLConnection.class
> 0 Fri Nov 03 21:40:50 PST 2000 weblogic/xml/
> 0 Fri Nov 03 21:40:50 PST 2000 weblogic/xml/license/
> 361 Fri Apr 14 13:46:02 PDT 2000
> weblogic/xml/license/AttributeList.class
> 6434 Fri Apr 14 13:46:02 PDT 2000
> weblogic/xml/license/BaseParser.class
> 507 Fri Apr 14 13:46:02 PDT 2000
> weblogic/xml/license/Handler$NameValuePair.class
> 4906 Fri Apr 14 13:46:02 PDT 2000 weblogic/xml/license/Handler.class
> 2959 Fri Apr 14 13:46:02 PDT 2000 weblogic/xml/license/LICENSE.class
> 2168 Fri Apr 14 13:46:02 PDT 2000
> weblogic/xml/license/NameMangler.class
> 1745 Fri Apr 14 13:46:02 PDT 2000
> weblogic/xml/license/WEBLOGICLICENSES.class
> 4709 Fri Apr 14 13:46:02 PDT 2000
> weblogic/xml/license/WEBLOGICLICENSESParser.class
> 2419 Fri Apr 14 13:46:02 PDT 2000
> weblogic/xml/license/XmlElement.class
>
>=======================================================================================
> Here's what I got, when I ran jBOSS:
>
>=======================================================================================
> F:\programs\jboss\bin>run
> [Console logging] Logging started
> [File logging] Logging started
> [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 2000 5.0,x86
> [JDBC] Loaded JDBC-driver:org.hsql.jdbcDriver
> [JDBC] Loaded JDBC-driver:jdbc.idbDriver
> [JDBC] Loaded JDBC-driver:oracle.jdbc.driver.OracleDriver
> [JDBC] Loaded JDBC-driver:weblogic.jdbc20.oci.Driver
> [Webserver] Initializing
> [Webserver] Initialized
> [Hypersonic] Initializing
> [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
> [XADataSource] Initializing
> [XADataSource] Initialized
> [XADataSource] Initializing
> [XADataSource] Initialized
> [XADataSource] Initializing
> [XADataSource] Initialized
> [XADataSource] Initializing
> [XADataSource] Initialized
> [Container factory] Initializing
> [Container factory] Initialized
> [Auto deploy] Watching F:\programs\jboss\deploy
> [Auto deployer] Initializing
> [Auto deployer] Initialized
> [JMX RMI Adaptor] Initializing
> [JMX RMI Adaptor] Initialized
> [JMX RMI Connector] Initializing
> [JMX RMI Connector] Initialized
> [Configuration] Initializing
> [Configuration] Initialized
> [J2ee deployer] Initializing
> [J2ee deployer] no config file found...
> [J2ee deployer] Initialized
> [EmbeddedTomcat] Initializing
> [EmbeddedTomcat] Initialized
> [EmbeddedTomcat] Starting
> [EmbeddedTomcat] Testing if Tomcat is present....
> [EmbeddedTomcat] OK
> [EmbeddedTomcat] ContextManager: Adding context Ctx( )
> [EmbeddedTomcat] path="" :jsp: init
> [EmbeddedTomcat] PoolTcpConnector: Starting HttpConnectionHandler on
> 8080
> [EmbeddedTomcat] Started
> [Simple Realm Mapping] Starting
> [Simple Realm Mapping] Started
> [Webserver] Starting
> [Webserver] Codebase set to http://asparuh:8083/
> [Webserver] Started webserver on port 8083
> [Webserver] Started
> [Transaction manager] Starting
> [Transaction manager] Started
> [Hypersonic] Starting
> [Hypersonic] Started
> [Naming] Starting
> [Naming] Started
> [XADataSource] Starting
> [XADataSource] XA Connection pool Hypersonic bound to Hypersonic
> [XADataSource] Started
> [XADataSource] Starting
> [XADataSource] XA Connection pool WeblogicORCL bound to WeblogicORCL
> +++ WebLogic Native Layer for OCI 8.x (BETA-2)
> ---------- LOGIN ERROR CODE: 24327
> [XADataSource] java.sql.SQLException: ORA-24327: need explicit attach
> before authenticating a user - (SCOTT/********@@asparuh:1521:ORCL)
> [XADataSource] at
> weblogic.db.oci.OciConnection.getLDAException(OciConnection.java:143)
> [XADataSource] at weblogic.jdbcbase.oci.Driver.connect(Driver.java:157)
> [XADataSource] at java.sql.DriverManager.getConnection(Unknown Source)
> [XADataSource] at java.sql.DriverManager.getConnection(Unknown Source)
> [XADataSource] at
> org.jboss.minerva.xa.XADataSourceImpl.getXAConnection(XADataSourceImpl.java:121)
> [XADataSource] at
> org.jboss.minerva.xa.XADataSourceImpl.getXAConnection(XADataSourceImpl.java:155)
> [XADataSource] at
>
>org.jboss.minerva.factories.XAConnectionFactory.createObject(XAConnectionFactory.java:216)
> [XADataSource] at
> org.jboss.minerva.pools.ObjectPool.createNewObject(ObjectPool.java:790)
> [XADataSource] at
> org.jboss.minerva.pools.ObjectPool.getObject(ObjectPool.java:548)
> [XADataSource] at
>
>org.jboss.minerva.datasource.XAPoolDataSource.getConnection(XAPoolDataSource.java:169)
> [XADataSource] at
> org.jboss.jdbc.XADataSourceLoader.initializePool(XADataSourceLoader.java:284)
> [XADataSource] at
> org.jboss.jdbc.XADataSourceLoader.startService(XADataSourceLoader.java:248)
> [XADataSource] at
> org.jboss.util.ServiceMBeanSupport.start(ServiceMBeanSupport.java:90)
> [XADataSource] at java.lang.reflect.Method.invoke(Native Method)
> [XADataSource] at
> com.sun.management.jmx.MBeanServerImpl.invoke(MBeanServerImpl.java:1628)
> [XADataSource] at
> com.sun.management.jmx.MBeanServerImpl.invoke(MBeanServerImpl.java:1523)
> [XADataSource] at
> org.jboss.dependencies.DependencyManager.startMBean(DependencyManager.java:284)
> [XADataSource] at
> org.jboss.dependencies.DependencyManager.loadService(DependencyManager.java:261)
> [XADataSource] at
> org.jboss.dependencies.DependencyManager.processService(DependencyManager.java:243)
> [XADataSource] at
> org.jboss.dependencies.DependencyManager.processService(DependencyManager.java:238)
> [XADataSource] at
> org.jboss.dependencies.DependencyManager.processService(DependencyManager.java:238)
> [XADataSource] at
> org.jboss.dependencies.DependencyManager.processService(DependencyManager.java:238)
> [XADataSource] at
> org.jboss.dependencies.DependencyManager.startMBeans(DependencyManager.java:117)
> [XADataSource] at org.jboss.Main.<init>(Main.java:166)
> [XADataSource] at org.jboss.Main.<init>(Main.java:98)
> [XADataSource] at org.jboss.Main$1.run(Main.java:88)
> [XADataSource] at java.security.AccessController.doPrivileged(Native
> Method)
> [XADataSource] at org.jboss.Main.main(Main.java:79)
> Terminate batch job (Y/N)? y
>
>=======================================================================================
> Note: I do have f:\weblogic\license in my classpath as well as
> f:\weblogic\classes.
> I do have f:\weblogic\bin\oci815_8 in my PATH.
>
> My ORCL is runnig fine. Here's how the TNS listener is configured:
>
>=======================================================================================
> # TNSNAMES.ORA Network Configuration File:
> F:\Oracle\Ora81\network\admin\tnsnames.ora
> # Generated by Oracle configuration tools.
>
> ORCL =
> (DESCRIPTION =
> (ADDRESS_LIST =
> (ADDRESS = (PROTOCOL = TCP)(HOST = asparuh)(PORT = 1521))
> )
> (CONNECT_DATA =
> (SERVICE_NAME = ORCL)
> )
> )
>
> EXTPROC_CONNECTION_DATA =
> (DESCRIPTION =
> (ADDRESS_LIST =
> (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC0))
> )
> (CONNECT_DATA =
> (SID = PLSExtProc)
> (PRESENTATION = RO)
> )
> )
>
>=======================================================================================
> If I try to obtain the Connection with this code:
>
>=======================================================================================
> Properties props = new Properties();
> props.put("user", "scott");
> props.put("password", "tiger");
> props.put("server", "ORCL");
> props.put ("weblobic.oci.selectBlobChunkSize","1024");
> Driver driver = (Driver)
> Class.forName("weblogic.jdbc20.oci.Driver").newInstance();
> Connection conn =
> driver.connect("jdbc20:weblogic:oracle:@localhost:1521:ORCL", props);
>
>=======================================================================================
> ...it works, and I can access my DB.
>
> I have the suspicion that I have to explicitly specify parameters in my
> MBean DataSource
> configuration:
>
>=======================================================================================
> <mbean name="DefaultDomain:service=XADataSource,name=WeblogicORCL">
> <attribute name="Properties"></attribute>
> <attribute
> name="URL">jdbc20:weblogic:oracle:@asparuh:1521:ORCL</attribute>
> <attribute name="GCMinIdleTime">1200000</attribute>
> <attribute name="JDBCUser">SCOTT</attribute>
> <attribute name="MaxSize">10</attribute>
> <attribute name="Password">TIGER</attribute>
> <attribute name="GCEnabled">false</attribute>
> <attribute name="InvalidateOnError">false</attribute>
> <attribute name="TimestampUsed">false</attribute>
> <attribute name="Blocking">true</attribute>
> <attribute name="GCInterval">120000</attribute>
> <attribute name="IdleTimeout">1800000</attribute>
> <attribute name="IdleTimeoutEnabled">false</attribute>
> <attribute name="LoggingEnabled">false</attribute>
> <attribute name="MaxIdleTimeoutPercent">1.0</attribute>
> <attribute name="MinSize">0</attribute>
> </mbean>
>
>=======================================================================================
> What is the definition (DTD) of the jboss.jcml file?
> How do I specify params. with <attribute name="Properties"></attribute>
> attribute?
>
> Please share your experience. Thank you!
>
>
> Georgi
>
>
> --
> --------------------------------------------------------------
> To subscribe: [EMAIL PROTECTED]
> To unsubscribe: [EMAIL PROTECTED]
> Problems?: [EMAIL PROTECTED]
>
--
--------------------------------------------------------------
To subscribe: [EMAIL PROTECTED]
To unsubscribe: [EMAIL PROTECTED]
Problems?: [EMAIL PROTECTED]
