hi georgi,
you would get this in case of the following
1) Check your driver can connect from the prompt by using a normal jdbc test
kind of a program
2) Make sure you have your ORACLE_HOME set and the TNS entry is correct in
the tnsnames.ora
i hv got this error with Weblogic several times and most cases it is one of
the above two !!
Hope this helps
cheers
krishna
----- Original Message -----
From: "Georgi Kostadinov" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Friday, November 03, 2000 11:16 PM
Subject: [jBoss-User] weblogic, oci, jDriver, ORA-24327 (need
explicitattach...)
> 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(XAConnectionFac
tory.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:2
84)
> [XADataSource] at
>
org.jboss.dependencies.DependencyManager.loadService(DependencyManager.java:
261)
> [XADataSource] at
>
org.jboss.dependencies.DependencyManager.processService(DependencyManager.ja
va:243)
> [XADataSource] at
>
org.jboss.dependencies.DependencyManager.processService(DependencyManager.ja
va:238)
> [XADataSource] at
>
org.jboss.dependencies.DependencyManager.processService(DependencyManager.ja
va:238)
> [XADataSource] at
>
org.jboss.dependencies.DependencyManager.processService(DependencyManager.ja
va: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]
