3:39 a.m.
Hi JBoss devs,
I'm testing Oracle connectivity using a 10.2 JDBC Driver (ojdbc14.jar).
Seems there are some issues- has anyone managed to connect to an Oracle
DB ?
This is what the server reports:
report
New missing/unsatisfied dependencies:
service jboss.jdbc-driver."oracle.jdbc.driver.OracleDriver".10.2
(missing)
And my configuration:
<datasource jndi-name="java:/OracleDS" pool-name="OracleDS"
enabled="true" use-java-context="true">
<connection-url>
jdbc:oracle:thin:@192.168.1.1:1530:ORACLESID
</connection-url>
<driver-class>
oracle.jdbc.driver.OracleDriver
</driver-class>
<driver>
oracle.jdbc.driver.OracleDriver#10.2
</driver>
<pool>
<prefill>
true
</prefill>
<use-strict-min>
false
</use-strict-min>
</pool>
<security>
<user-name>test</user-name>
<password>test</password>
</security>
<validation>
<validate-on-match>
false
</validate-on-match>
<background-validation>
false
</background-validation>
<useFastFail>
false
</useFastFail>
</validation>
<statement/>
</datasource>
I've chosen to install the JDBC driver as a module, so under the
"modules" folder I've added:
oracle
└───jdbc
└───main
module.xml
ojdbc14.jar
ojdbc14.jar.index
Last thing, the module.xml:
<module xmlns="urn:jboss:module:1.0" name="oracle.jdbc">
<resources>
<resource-root path="ojdbc14.jar"/>
<!-- Insert resources here -->
</resources>
<dependencies>
<module name="javax.api"/>
</dependencies>
</module>
Can you find any reason why the driver does not get deployed ?
(I've tried also adding META-INF/services/java.sql.Driver with the
driver class name- it didn't help however).
Thanks a lot
Paul
--
paulwerder(a)fastmail.co.uk
--
http://www.fastmail.fm - IMAP accessible web-mail
4:54 a.m.
do you have a
<drivers>
<driver module="oracle.jdbc"/>
</drivers>
in your configuration at datasources subsystem?
On Wed, May 4, 2011 at 11:39 AM, <paulwerder(a)fastmail.co.uk> wrote:
Hi JBoss devs,
I'm testing Oracle connectivity using a 10.2 JDBC Driver (ojdbc14.jar).
Seems there are some issues- has anyone managed to connect to an Oracle
DB ?
This is what the server reports:
report
New missing/unsatisfied dependencies:
service jboss.jdbc-driver."oracle.jdbc.driver.OracleDriver".10.2
(missing)
And my configuration:
<datasource jndi-name="java:/OracleDS" pool-name="OracleDS"
enabled="true" use-java-context="true">
<connection-url>
jdbc:oracle:thin:@192.168.1.1:1530:ORACLESID
</connection-url>
<driver-class>
oracle.jdbc.driver.OracleDriver
</driver-class>
<driver>
oracle.jdbc.driver.OracleDriver#10.2
</driver>
<pool>
<prefill>
true
</prefill>
<use-strict-min>
false
</use-strict-min>
</pool>
<security>
<user-name>test</user-name>
<password>test</password>
</security>
<validation>
<validate-on-match>
false
</validate-on-match>
<background-validation>
false
</background-validation>
<useFastFail>
false
</useFastFail>
</validation>
<statement/>
</datasource>
I've chosen to install the JDBC driver as a module, so under the
"modules" folder I've added:
oracle
└───jdbc
└───main
module.xml
ojdbc14.jar
ojdbc14.jar.index
Last thing, the module.xml:
<module xmlns="urn:jboss:module:1.0" name="oracle.jdbc">
<resources>
<resource-root path="ojdbc14.jar"/>
<!-- Insert resources here -->
</resources>
<dependencies>
<module name="javax.api"/>
</dependencies>
</module>
Can you find any reason why the driver does not get deployed ?
(I've tried also adding META-INF/services/java.sql.Driver with the
driver class name- it didn't help however).
Thanks a lot
Paul
--
paulwerder(a)fastmail.co.uk
--
http://www.fastmail.fm - IMAP accessible web-mail
_______________________________________________
jboss-as7-dev mailing list
jboss-as7-dev(a)lists.jboss.org
https://lists.jboss.org/mailman/listinfo/jboss-as7-dev
--
---
Nik
5:02 a.m.
Hello,
do you have a
<drivers>
<driver
module="oracle.jdbc"/>
</drivers>
in your configuration at datasources subsystem?
yes I have inserted it, exaclty as you typed it. (sorry I forgot
to mention it before.)
might it be a specific issue with this JDBC driver ?
regards
Paul
--
[1]paulwerder(a)fastmail.co.uk
On Wed, 04 May 2011 12:54 +0300, "Nicklas Karlsson"
<nickarls(a)gmail.com> wrote:
do you have a
<drivers>
<driver module="oracle.jdbc"/>
</drivers>
in your configuration at datasources subsystem?
On Wed, May 4, 2011 at 11:39 AM, <[2]paulwerder(a)fastmail.co.uk>
wrote:
Hi JBoss devs,
I'm testing Oracle connectivity using a 10.2 JDBC Driver
(ojdbc14.jar).
Seems there are some issues- has anyone managed to connect to
an Oracle
DB ?
This is what the server reports:
report
New missing/unsatisfied dependencies:
service
jboss.jdbc-driver."oracle.jdbc.driver.OracleDriver".10.2
(missing)
And my configuration:
<datasource jndi-name="java:/OracleDS" pool-name="OracleDS"
enabled="true" use-java-context="true">
<connection-url>
jdbc:oracle:thin:@192.168.1.1:1530:ORACLESID
</connection-url>
<driver-class>
oracle.jdbc.driver.OracleDriver
</driver-class>
<driver>
oracle.jdbc.driver.OracleDriver#10.2
</driver>
<pool>
<prefill>
true
</prefill>
<use-strict-min>
false
</use-strict-min>
</pool>
<security>
<user-name>test</user-name>
<password>test</password>
</security>
<validation>
<validate-on-match>
false
</validate-on-match>
<background-validation>
false
</background-validation>
<useFastFail>
false
</useFastFail>
</validation>
<statement/>
</datasource>
I've chosen to install the JDBC driver as a module, so under
the
"modules" folder I've added:
oracle
└───jdbc
└───main
module.xml
ojdbc14.jar
ojdbc14.jar.index
Last thing, the module.xml:
<module xmlns="urn:jboss:module:1.0" name="oracle.jdbc">
<resources>
<resource-root path="ojdbc14.jar"/>
<!-- Insert resources here -->
</resources>
<dependencies>
<module name="javax.api"/>
</dependencies>
</module>
Can you find any reason why the driver does not get deployed ?
(I've tried also adding META-INF/services/java.sql.Driver with
the
driver class name- it didn't help however).
Thanks a lot
Paul
--
[3]paulwerder(a)fastmail.co.uk
--
[4]http://www.fastmail.fm - IMAP accessible web-mail
_______________________________________________
jboss-as7-dev mailing list
[5]jboss-as7-dev(a)lists.jboss.org
[6]https://lists.jboss.org/mailman/listinfo/jboss-as7-dev
--
---
Nik
_______________________________________________
jboss-as7-dev mailing list
jboss-as7-dev(a)lists.jboss.org
https://lists.jboss.org/mailman/listinfo/jboss-as7-dev
References
1. mailto:paulwerder@fastmail.co.uk
2. mailto:paulwerder@fastmail.co.uk
3. mailto:paulwerder@fastmail.co.uk
4. http://www.fastmail.fm/
5. mailto:jboss-as7-dev@lists.jboss.org
6. https://lists.jboss.org/mailman/listinfo/jboss-as7-dev
--
http://www.fastmail.fm - mmm... Fastmail...
5:23 a.m.
This is just a vague guess, but there used to be an issue with the OSGI subsystem
involved.
What AS version are you using? The problem I am referring to should be solved in trunk.
But if you a running a previous release, then try commenting out the osgi subsystem .
Ike
On May 4, 2011, at 12:02 PM, paulwerder(a)fastmail.co.uk wrote:
Hello,
>do you have a
> <drivers>
<driver module="oracle.jdbc"/>
> </drivers>
>in your configuration at datasources subsystem?
yes I have inserted it, exaclty as you typed it. (sorry I forgot to mention it before.)
might it be a specific issue with this JDBC driver ?
regards
Paul
--
paulwerder(a)fastmail.co.uk
On Wed, 04 May 2011 12:54 +0300, "Nicklas Karlsson" <nickarls(a)gmail.com>
wrote:
> do you have a
>
> <drivers>
> <driver module="oracle.jdbc"/>
> </drivers>
>
> in your configuration at datasources subsystem?
>
> On Wed, May 4, 2011 at 11:39 AM, <paulwerder(a)fastmail.co.uk> wrote:
> Hi JBoss devs,
> I'm testing Oracle connectivity using a 10.2 JDBC Driver (ojdbc14.jar).
> Seems there are some issues- has anyone managed to connect to an Oracle
> DB ?
> This is what the server reports:
>
> report
> New missing/unsatisfied dependencies:
> service jboss.jdbc-driver."oracle.jdbc.driver.OracleDriver".10.2
> (missing)
>
> And my configuration:
>
> <datasource jndi-name="java:/OracleDS" pool-name="OracleDS"
> enabled="true" use-java-context="true">
> <connection-url>
> jdbc:oracle:thin:@192.168.1.1:1530:ORACLESID
> </connection-url>
> <driver-class>
> oracle.jdbc.driver.OracleDriver
> </driver-class>
> <driver>
> oracle.jdbc.driver.OracleDriver#10.2
> </driver>
> <pool>
> <prefill>
> true
> </prefill>
> <use-strict-min>
> false
> </use-strict-min>
> </pool>
> <security>
> <user-name>test</user-name>
> <password>test</password>
> </security>
> <validation>
> <validate-on-match>
> false
> </validate-on-match>
> <background-validation>
> false
> </background-validation>
> <useFastFail>
> false
> </useFastFail>
> </validation>
> <statement/>
> </datasource>
>
> I've chosen to install the JDBC driver as a module, so under the
> "modules" folder I've added:
> oracle
> └───jdbc
> └───main
> module.xml
> ojdbc14.jar
> ojdbc14.jar.index
>
> Last thing, the module.xml:
>
> <module xmlns="urn:jboss:module:1.0" name="oracle.jdbc">
> <resources>
> <resource-root path="ojdbc14.jar"/>
> <!-- Insert resources here -->
> </resources>
> <dependencies>
> <module name="javax.api"/>
> </dependencies>
> </module>
>
> Can you find any reason why the driver does not get deployed ?
> (I've tried also adding META-INF/services/java.sql.Driver with the
> driver class name- it didn't help however).
> Thanks a lot
> Paul
> --
>
> paulwerder(a)fastmail.co.uk
>
> --
> http://www.fastmail.fm - IMAP accessible web-mail
>
>
> _______________________________________________
> jboss-as7-dev mailing list
> jboss-as7-dev(a)lists.jboss.org
> https://lists.jboss.org/mailman/listinfo/jboss-as7-dev
>
>
>
> --
> ---
> Nik
> _______________________________________________
> jboss-as7-dev mailing list
> jboss-as7-dev(a)lists.jboss.org
> https://lists.jboss.org/mailman/listinfo/jboss-as7-dev
>
--
http://www.fastmail.fm - mmm... Fastmail...
_______________________________________________
jboss-as7-dev mailing list
jboss-as7-dev(a)lists.jboss.org
https://lists.jboss.org/mailman/listinfo/jboss-as7-dev
5:40 a.m.
Hello Ike,
This is just a vague guess, but there used to be an issue with
the OSGI subsystem involved.
What AS version are you using? The problem I am referring to
should be solved in trunk.
But if you a running a previous release, then try commenting out
the osgi subsystem .
I'm using Beta3 - no luck :-(
--
[1]paulwerder(a)fastmail.co.uk
On Wed, 04 May 2011 12:23 +0200, "Heiko Braun"
<hbraun(a)redhat.com> wrote:
This is just a vague guess, but there used to be an issue with
the OSGI subsystem involved.
What AS version are you using? The problem I am referring to
should be solved in trunk.
But if you a running a previous release, then try commenting out
the osgi subsystem .
Ike
On May 4, 2011, at 12:02 PM, [2]paulwerder(a)fastmail.co.uk wrote:
Hello,
do you have a
<drivers>
<driver
module="oracle.jdbc"/>
</drivers>
in your configuration at datasources subsystem?
yes I have inserted it, exaclty as you typed it. (sorry I forgot
to mention it before.)
might it be a specific issue with this JDBC driver ?
regards
Paul
--
[3]paulwerder(a)fastmail.co.uk
On Wed, 04 May 2011 12:54 +0300, "Nicklas Karlsson"
<[4]nickarls(a)gmail.com> wrote:
do you have a
<drivers>
<driver module="oracle.jdbc"/>
</drivers>
in your configuration at datasources subsystem?
On Wed, May 4, 2011 at 11:39
AM, <[5]paulwerder(a)fastmail.co.uk> wrote:
Hi JBoss devs,
I'm testing Oracle connectivity using a 10.2 JDBC Driver
(ojdbc14.jar).
Seems there are some issues- has anyone managed to connect to
an Oracle
DB ?
This is what the server reports:
report
New missing/unsatisfied dependencies:
service
jboss.jdbc-driver."oracle.jdbc.driver.OracleDriver".10.2
(missing)
And my configuration:
<datasource jndi-name="java:/OracleDS" pool-name="OracleDS"
enabled="true" use-java-context="true">
<connection-url>
jdbc:oracle:thin:@192.168.1.1:1530:ORACLESID
</connection-url>
<driver-class>
oracle.jdbc.driver.OracleDriver
</driver-class>
<driver>
oracle.jdbc.driver.OracleDriver#10.2
</driver>
<pool>
<prefill>
true
</prefill>
<use-strict-min>
false
</use-strict-min>
</pool>
<security>
<user-name>test</user-name>
<password>test</password>
</security>
<validation>
<validate-on-match>
false
</validate-on-match>
<background-validation>
false
</background-validation>
<useFastFail>
false
</useFastFail>
</validation>
<statement/>
</datasource>
I've chosen to install the JDBC driver as a module, so under
the
"modules" folder I've added:
oracle
└───jdbc
└───main
module.xml
ojdbc14.jar
ojdbc14.jar.index
Last thing, the module.xml:
<module xmlns="urn:jboss:module:1.0" name="oracle.jdbc">
<resources>
<resource-root path="ojdbc14.jar"/>
<!-- Insert resources here -->
</resources>
<dependencies>
<module name="javax.api"/>
</dependencies>
</module>
Can you find any reason why the driver does not get deployed ?
(I've tried also adding META-INF/services/java.sql.Driver with
the
driver class name- it didn't help however).
Thanks a lot
Paul
--
[6]paulwerder(a)fastmail.co.uk
--
[7]http://www.fastmail.fm - IMAP accessible web-mail
_______________________________________________
jboss-as7-dev mailing list
[8]jboss-as7-dev(a)lists.jboss.org
[9]https://lists.jboss.org/mailman/listinfo/jboss-as7-dev
--
---
Nik
_______________________________________________
jboss-as7-dev mailing list
[10]jboss-as7-dev(a)lists.jboss.org
[11]https://lists.jboss.org/mailman/listinfo/jboss-as7-dev
--
[12]http://www.fastmail.fm - mmm... Fastmail...
_______________________________________________
jboss-as7-dev mailing list
[13]jboss-as7-dev(a)lists.jboss.org
[14]https://lists.jboss.org/mailman/listinfo/jboss-as7-dev
References
1. mailto:paulwerder@fastmail.co.uk
2. mailto:paulwerder@fastmail.co.uk
3. mailto:paulwerder@fastmail.co.uk
4. mailto:nickarls@gmail.com
5. mailto:paulwerder@fastmail.co.uk
6. mailto:paulwerder@fastmail.co.uk
7. http://www.fastmail.fm/
8. mailto:jboss-as7-dev@lists.jboss.org
9. https://lists.jboss.org/mailman/listinfo/jboss-as7-dev
10. mailto:jboss-as7-dev@lists.jboss.org
11. https://lists.jboss.org/mailman/listinfo/jboss-as7-dev
12. http://www.fastmail.fm/
13. mailto:jboss-as7-dev@lists.jboss.org
14. https://lists.jboss.org/mailman/listinfo/jboss-as7-dev
--
http://www.fastmail.fm - Does exactly what it says on the tin
6:14 a.m.
And the version number is correct for the driver?
On Wed, May 4, 2011 at 1:40 PM, <paulwerder(a)fastmail.co.uk> wrote:
Hello Ike,
>This is just a vague guess, but there used to be an issue with the OSGI
subsystem involved.
>What AS version are you using? The problem I am referring to should be
solved in trunk.
>But if you a running a previous release, then try commenting out the osgi
subsystem .
I'm using Beta3 - no luck :-(
--
paulwerder(a)fastmail.co.uk
On Wed, 04 May 2011 12:23 +0200, "Heiko Braun" <hbraun(a)redhat.com>
wrote:
This is just a vague guess, but there used to be an issue with the OSGI
subsystem involved.
What AS version are you using? The problem I am referring to should be
solved in trunk.
But if you a running a previous release, then try commenting out the osgi
subsystem .
Ike
On May 4, 2011, at 12:02 PM, paulwerder(a)fastmail.co.uk wrote:
Hello,
>do you have a
> <drivers>
<driver module="oracle.jdbc"/>
> </drivers>
>in your configuration at datasources subsystem?
yes I have inserted it, exaclty as you typed it. (sorry I forgot to
mention it before.)
might it be a specific issue with this JDBC driver ?
regards
Paul
--
paulwerder(a)fastmail.co.uk
On Wed, 04 May 2011 12:54 +0300, "Nicklas Karlsson"
<nickarls(a)gmail.com>
wrote:
do you have a
<drivers>
<driver module="oracle.jdbc"/>
</drivers>
in your configuration at datasources subsystem?
On Wed, May 4, 2011 at 11:39 AM, <paulwerder(a)fastmail.co.uk> wrote:
Hi JBoss devs,
I'm testing Oracle connectivity using a 10.2 JDBC Driver (ojdbc14.jar).
Seems there are some issues- has anyone managed to connect to an Oracle
DB ?
This is what the server reports:
report
New missing/unsatisfied dependencies:
service jboss.jdbc-driver."oracle.jdbc.driver.OracleDriver".10.2
(missing)
And my configuration:
<datasource jndi-name="java:/OracleDS" pool-name="OracleDS"
enabled="true" use-java-context="true">
<connection-url>
jdbc:oracle:thin:@192.168.1.1:1530:ORACLESID
</connection-url>
<driver-class>
oracle.jdbc.driver.OracleDriver
</driver-class>
<driver>
oracle.jdbc.driver.OracleDriver#10.2
</driver>
<pool>
<prefill>
true
</prefill>
<use-strict-min>
false
</use-strict-min>
</pool>
<security>
<user-name>test</user-name>
<password>test</password>
</security>
<validation>
<validate-on-match>
false
</validate-on-match>
<background-validation>
false
</background-validation>
<useFastFail>
false
</useFastFail>
</validation>
<statement/>
</datasource>
I've chosen to install the JDBC driver as a module, so under the
"modules" folder I've added:
oracle
└───jdbc
└───main
module.xml
ojdbc14.jar
ojdbc14.jar.index
Last thing, the module.xml:
<module xmlns="urn:jboss:module:1.0" name="oracle.jdbc">
<resources>
<resource-root path="ojdbc14.jar"/>
<!-- Insert resources here -->
</resources>
<dependencies>
<module name="javax.api"/>
</dependencies>
</module>
Can you find any reason why the driver does not get deployed ?
(I've tried also adding META-INF/services/java.sql.Driver with the
driver class name- it didn't help however).
Thanks a lot
Paul
--
paulwerder(a)fastmail.co.uk
--
http://www.fastmail.fm - IMAP accessible web-mail
_______________________________________________
jboss-as7-dev mailing list
jboss-as7-dev(a)lists.jboss.org
https://lists.jboss.org/mailman/listinfo/jboss-as7-dev
--
---
Nik
_______________________________________________
jboss-as7-dev mailing
listjboss-as7-dev@lists.jboss.orghttps://lists.jboss.org/mailman/listinfo/jboss-as7-dev
-- http://www.fastmail.fm - mmm... Fastmail...
_______________________________________________
jboss-as7-dev mailing list
jboss-as7-dev(a)lists.jboss.org
https://lists.jboss.org/mailman/listinfo/jboss-as7-dev
-- http://www.fastmail.fm - Does exactly what it says on the tin
_______________________________________________
jboss-as7-dev mailing list
jboss-as7-dev(a)lists.jboss.org
https://lists.jboss.org/mailman/listinfo/jboss-as7-dev
--
---
Nik
7:54 a.m.
The problem is the driver itself.
Oracle 10.2 jdbc driver is type 3 driver and it can't be loaded by
java.util.ServiceLoader using the META-INF/services directory in the jar.
And it's the only way we are supporting jdbc as module or deployment.
IOW we are just supporting type 4 driver.
Use Oracle 11g driver, I've tested it and it's working.
regards
S.
On 05/04/2011 01:14 PM, Nicklas Karlsson wrote:
And the version number is correct for the driver?
On Wed, May 4, 2011 at 1:40 PM, <paulwerder(a)fastmail.co.uk
<mailto:paulwerder@fastmail.co.uk>> wrote:
Hello Ike,
>This is just a vague guess, but there used to be an issue with
the OSGI subsystem involved.
>What AS version are you using? The problem I am referring to
should be solved in trunk.
>But if you a running a previous release, then try commenting out
the osgi subsystem .
I'm using Beta3 - no luck :-(
--
paulwerder(a)fastmail.co.uk <mailto:paulwerder@fastmail.co.uk>
On Wed, 04 May 2011 12:23 +0200, "Heiko Braun" <hbraun(a)redhat.com
<mailto:hbraun@redhat.com>> wrote:
> This is just a vague guess, but there used to be an issue with
> the OSGI subsystem involved.
> What AS version are you using? The problem I am referring to
> should be solved in trunk.
> But if you a running a previous release, then try commenting out
> the osgi subsystem .
> Ike
>
> On May 4, 2011, at 12:02 PM, paulwerder(a)fastmail.co.uk
> <mailto:paulwerder@fastmail.co.uk> wrote:
>
>> Hello,
>> >do you have a
>> > <drivers>
>> <driver module="oracle.jdbc"/>
>> > </drivers>
>> >in your configuration at datasources subsystem?
>> yes I have inserted it, exaclty as you typed it. (sorry I forgot
>> to mention it before.)
>> might it be a specific issue with this JDBC driver ?
>> regards
>> Paul
>> --
>> paulwerder(a)fastmail.co.uk <mailto:paulwerder@fastmail.co.uk>
>> On Wed, 04 May 2011 12:54 +0300, "Nicklas Karlsson"
>> <nickarls(a)gmail.com <mailto:nickarls@gmail.com>> wrote:
>>> do you have a
>>> <drivers>
>>> <driver module="oracle.jdbc"/>
>>> </drivers>
>>> in your configuration at datasources subsystem?
>>>
>>> On Wed, May 4, 2011 at 11:39 AM,<paulwerder(a)fastmail.co.uk
>>> <mailto:paulwerder@fastmail.co.uk>>wrote:
>>>
>>> Hi JBoss devs,
>>> I'm testing Oracle connectivity using a 10.2 JDBC Driver
>>> (ojdbc14.jar).
>>> Seems there are some issues- has anyone managed to connect
>>> to an Oracle
>>> DB ?
>>> This is what the server reports:
>>>
>>> report
>>> New missing/unsatisfied dependencies:
>>> service
>>> jboss.jdbc-driver."oracle.jdbc.driver.OracleDriver".10.2
>>> (missing)
>>>
>>> And my configuration:
>>>
>>> <datasource jndi-name="java:/OracleDS"
pool-name="OracleDS"
>>> enabled="true" use-java-context="true">
>>> <connection-url>
>>>
>>> jdbc:oracle:thin:@192.168.1.1:1530:ORACLESID
>>> </connection-url>
>>> <driver-class>
>>> oracle.jdbc.driver.OracleDriver
>>> </driver-class>
>>> <driver>
>>> oracle.jdbc.driver.OracleDriver#10.2
>>> </driver>
>>> <pool>
>>> <prefill>
>>> true
>>> </prefill>
>>> <use-strict-min>
>>> false
>>> </use-strict-min>
>>> </pool>
>>> <security>
>>> <user-name>test</user-name>
>>> <password>test</password>
>>> </security>
>>> <validation>
>>> <validate-on-match>
>>> false
>>> </validate-on-match>
>>> <background-validation>
>>> false
>>> </background-validation>
>>> <useFastFail>
>>> false
>>> </useFastFail>
>>> </validation>
>>> <statement/>
>>> </datasource>
>>>
>>> I've chosen to install the JDBC driver as a module, so
>>> under the
>>> "modules" folder I've added:
>>> oracle
>>> └───jdbc
>>> └───main
>>> module.xml
>>> ojdbc14.jar
>>> ojdbc14.jar.index
>>>
>>> Last thing, the module.xml:
>>>
>>> <module xmlns="urn:jboss:module:1.0"
name="oracle.jdbc">
>>> <resources>
>>> <resource-root path="ojdbc14.jar"/>
>>> <!-- Insert resources here -->
>>> </resources>
>>> <dependencies>
>>> <module name="javax.api"/>
>>> </dependencies>
>>> </module>
>>>
>>> Can you find any reason why the driver does not get deployed ?
>>> (I've tried also adding META-INF/services/java.sql.Driver
>>> with the
>>> driver class name- it didn't help however).
>>> Thanks a lot
>>> Paul
>>> --
>>>
>>> paulwerder(a)fastmail.co.uk <mailto:paulwerder@fastmail.co.uk>
>>>
>>> --
>>> http://www.fastmail.fm- IMAP accessible web-mail
>>>
>>>
>>> _______________________________________________
>>> jboss-as7-dev mailing list
>>> jboss-as7-dev(a)lists.jboss.org
>>> <mailto:jboss-as7-dev@lists.jboss.org>
>>> https://lists.jboss.org/mailman/listinfo/jboss-as7-dev
>>>
>>>
>>>
>>>
>>> --
>>> ---
>>> Nik
>>> _______________________________________________
>>> jboss-as7-dev mailing list
>>> jboss-as7-dev(a)lists.jboss.org
<mailto:jboss-as7-dev@lists.jboss.org>
>>> https://lists.jboss.org/mailman/listinfo/jboss-as7-dev
>>>
>> --
>> http://www.fastmail.fm - mmm... Fastmail...
>> _______________________________________________
>> jboss-as7-dev mailing list
>> jboss-as7-dev(a)lists.jboss.org <mailto:jboss-as7-dev@lists.jboss.org>
>> https://lists.jboss.org/mailman/listinfo/jboss-as7-dev
--
http://www.fastmail.fm - Does exactly what it says on the tin
_______________________________________________
jboss-as7-dev mailing list
jboss-as7-dev(a)lists.jboss.org <mailto:jboss-as7-dev@lists.jboss.org>
https://lists.jboss.org/mailman/listinfo/jboss-as7-dev
--
---
Nik
_______________________________________________
jboss-as7-dev mailing list
jboss-as7-dev(a)lists.jboss.org
https://lists.jboss.org/mailman/listinfo/jboss-as7-dev
8:43 a.m.
New subject: Special content overlays (Was: Re: Oracle datasource missing dependencies)
On 05/04/2011 07:54 AM, Stefano Maestri wrote:
The problem is the driver itself.
Oracle 10.2 jdbc driver is type 3 driver and it can't be loaded by
java.util.ServiceLoader using the META-INF/services directory in the jar.
And it's the only way we are supporting jdbc as module or deployment.
IOW we are just supporting type 4 driver.
Use Oracle 11g driver, I've tested it and it's working.
Exactly right. We do need an easier way to support JDBC 3 drivers
though. Once https://issues.jboss.org/browse/AS7-431 is merged we
should have more options though.
First option would be to deploy a neighboring content root which
includes the requisite META-INF/services file alongside the JDBC driver
JAR like this:
<deployment name="my-driver.jar">
<fs-archive path="deployments/my-driver.jar"
relative-to="jboss.server.deploy.dir"/>
<fs-exploded path="user-stuff/my-driver-overlay"
relative-to="jboss.server.base.dir"/>
</deployment>
Where user-stuff/my-driver-overlay contains the
META-INF/services/java.sql.Driver file.
Or, we could introduce a new content type just for services:
<deployment name="my-driver.jar">
<fs-archive path="deployments/my-driver.jar"
relative-to="jboss.server.deploy.dir"/>
<service type="java.sql.Driver">
<class name="com.foo.blah.SomeDriver"/>
</service>
</deployment>
Granted opens a door to a whole new concept: including deployment
description in the management model.
--
- DML
8:41 a.m.
New subject: Special content overlays (Was: Re: Oracle datasource missing dependencies)
On 05/04/2011 03:43 PM, David M. Lloyd wrote:
On 05/04/2011 07:54 AM, Stefano Maestri wrote:
> The problem is the driver itself.
> Oracle 10.2 jdbc driver is type 3 driver and it can't be loaded by
> java.util.ServiceLoader using the META-INF/services directory in the jar.
> And it's the only way we are supporting jdbc as module or deployment.
> IOW we are just supporting type 4 driver.
>
> Use Oracle 11g driver, I've tested it and it's working.
Exactly right. We do need an easier way to support JDBC 3 drivers
though. Once https://issues.jboss.org/browse/AS7-431 is merged we
should have more options though.
Yup, and it's good to discuss the design. When
we all agree I'll open an
issue and I'll take care of implement it (after 431 of course)
Or, we could introduce a new content type just for services:
<deployment name="my-driver.jar">
<fs-archive path="deployments/my-driver.jar"
relative-to="jboss.server.deploy.dir"/>
<service type="java.sql.Driver">
<class name="com.foo.blah.SomeDriver"/>
</service>
</deployment>
I like this one. Other opinions?
regards
S.
9:50 a.m.
Oracle 10.2 jdbc driver is type 3 driver and it can't be loaded
by java.util.ServiceLoader using the >META-INF/services directory
in the jar.
And it's the only way we are supporting jdbc as module or
deployment. IOW we are just supporting type 4 >driver.
Use Oracle 11g driver, I've tested it and it's working.
Hello Stefano, which .jar have you used for testing connectivity
?
I've used ojdbc5.jar but I still get the same error.....
--
[1]paulwerder(a)fastmail.co.uk
On Wed, 04 May 2011 14:54 +0200, "Stefano Maestri"
<smaestri(a)redhat.com> wrote:
The problem is the driver itself.
Oracle 10.2 jdbc driver is type 3 driver and it can't be loaded
by java.util.ServiceLoader using the META-INF/services directory
in the jar.
And it's the only way we are supporting jdbc as module or
deployment. IOW we are just supporting type 4 driver.
Use Oracle 11g driver, I've tested it and it's working.
regards
S.
On 05/04/2011 01:14 PM, Nicklas Karlsson wrote:
And the version number is correct for the driver?
On Wed, May 4, 2011 at 1:40 PM, <[2]paulwerder(a)fastmail.co.uk>
wrote:
Hello Ike,
This is just a vague guess, but there used to be an issue with
the OSGI subsystem involved.
What AS version are you using? The problem I am referring to
should be solved in trunk.
But if you a running a previous release, then try commenting out
the osgi subsystem .
I'm using Beta3 - no luck :-(
--
[3]paulwerder(a)fastmail.co.uk
On Wed, 04 May 2011 12:23 +0200, "Heiko Braun"
<[4]hbraun(a)redhat.com> wrote:
This is just a vague guess, but there used to be an issue with
the OSGI subsystem involved.
What AS version are you using? The problem I am referring to
should be solved in trunk.
But if you a running a previous release, then try commenting out
the osgi subsystem .
Ike
On May 4, 2011, at 12:02 PM, [5]paulwerder(a)fastmail.co.uk wrote:
Hello,
do you have a
<drivers>
<driver
module="oracle.jdbc"/>
</drivers>
in your configuration at datasources subsystem?
yes I have inserted it, exaclty as you typed it. (sorry I forgot
to mention it before.)
might it be a specific issue with this JDBC driver ?
regards
Paul
--
[6]paulwerder(a)fastmail.co.uk
On Wed, 04 May 2011 12:54 +0300, "Nicklas Karlsson"
<[7]nickarls(a)gmail.com> wrote:
do you have a
<drivers>
<driver module="oracle.jdbc"/>
</drivers>
in your configuration at datasources subsystem?
On Wed, May 4, 2011 at 11:39
AM, <[8]paulwerder(a)fastmail.co.uk> wrote:
Hi JBoss devs,
I'm testing Oracle connectivity using a 10.2 JDBC Driver
(ojdbc14.jar).
Seems there are some issues- has anyone managed to connect to
an Oracle
DB ?
This is what the server reports:
report
New missing/unsatisfied dependencies:
service
jboss.jdbc-driver."oracle.jdbc.driver.OracleDriver".10.2
(missing)
And my configuration:
<datasource jndi-name="java:/OracleDS" pool-name="OracleDS"
enabled="true" use-java-context="true">
<connection-url>
[9]jdbc:oracle:thin:@192.168.1.1:1530:ORACLESID
</connection-url>
<driver-class>
oracle.jdbc.driver.OracleDriver
</driver-class>
<driver>
oracle.jdbc.driver.OracleDriver#10.2
</driver>
<pool>
<prefill>
true
</prefill>
<use-strict-min>
false
</use-strict-min>
</pool>
<security>
<user-name>test</user-name>
<password>test</password>
</security>
<validation>
<validate-on-match>
false
</validate-on-match>
<background-validation>
false
</background-validation>
<useFastFail>
false
</useFastFail>
</validation>
<statement/>
</datasource>
I've chosen to install the JDBC driver as a module, so under
the
"modules" folder I've added:
oracle
└───jdbc
└───main
module.xml
ojdbc14.jar
ojdbc14.jar.index
Last thing, the module.xml:
<module xmlns="urn:jboss:module:1.0" name="oracle.jdbc">
<resources>
<resource-root path="ojdbc14.jar"/>
<!-- Insert resources here -->
</resources>
<dependencies>
<module name="javax.api"/>
</dependencies>
</module>
Can you find any reason why the driver does not get deployed ?
(I've tried also adding META-INF/services/java.sql.Driver with
the
driver class name- it didn't help however).
Thanks a lot
Paul
--
[10]paulwerder(a)fastmail.co.uk
--
[11]http://www.fastmail.fm - IMAP accessible web-mail
_______________________________________________
jboss-as7-dev mailing list
[12]jboss-as7-dev(a)lists.jboss.org
[13]https://lists.jboss.org/mailman/listinfo/jboss-as7-dev
--
---
Nik
_______________________________________________
jboss-as7-dev mailing list
[14]jboss-as7-dev(a)lists.jboss.org
[15]https://lists.jboss.org/mailman/listinfo/jboss-as7-dev
--
[16]http://www.fastmail.fm - mmm... Fastmail...
_______________________________________________
jboss-as7-dev mailing list
[17]jboss-as7-dev(a)lists.jboss.org
[18]https://lists.jboss.org/mailman/listinfo/jboss-as7-dev
--
[19]http://www.fastmail.fm - Does exactly what it says on the tin
_______________________________________________
jboss-as7-dev mailing list
[20]jboss-as7-dev(a)lists.jboss.org
[21]https://lists.jboss.org/mailman/listinfo/jboss-as7-dev
--
---
Nik
_______________________________________________
jboss-as7-dev mailing list
[22]jboss-as7-dev(a)lists.jboss.org
[23]https://lists.jboss.org/mailman/listinfo/jboss-as7-dev
_______________________________________________
jboss-as7-dev mailing list
jboss-as7-dev(a)lists.jboss.org
https://lists.jboss.org/mailman/listinfo/jboss-as7-dev
References
1. mailto:paulwerder@fastmail.co.uk
2. mailto:paulwerder@fastmail.co.uk
3. mailto:paulwerder@fastmail.co.uk
4. mailto:hbraun@redhat.com
5. mailto:paulwerder@fastmail.co.uk
6. mailto:paulwerder@fastmail.co.uk
7. mailto:nickarls@gmail.com
8. mailto:paulwerder@fastmail.co.uk
9. mailto:jdbc:oracle:thin:@192.168.1.1:1530:ORACLESID
10. mailto:paulwerder@fastmail.co.uk
11. http://www.fastmail.fm/
12. mailto:jboss-as7-dev@lists.jboss.org
13. https://lists.jboss.org/mailman/listinfo/jboss-as7-dev
14. mailto:jboss-as7-dev@lists.jboss.org
15. https://lists.jboss.org/mailman/listinfo/jboss-as7-dev
16. http://www.fastmail.fm/
17. mailto:jboss-as7-dev@lists.jboss.org
18. https://lists.jboss.org/mailman/listinfo/jboss-as7-dev
19. http://www.fastmail.fm/
20. mailto:jboss-as7-dev@lists.jboss.org
21. https://lists.jboss.org/mailman/listinfo/jboss-as7-dev
22. mailto:jboss-as7-dev@lists.jboss.org
23. https://lists.jboss.org/mailman/listinfo/jboss-as7-dev
--
http://www.fastmail.fm - Email service worth paying for. Try it for free
8:02 a.m.
And the version number is correct for the driver?
It should
be...in the META-INF folder of the driver I've found:
Specification-Version: Oracle JDBC Driver version - "10.2.0.4.0"
Implementation-Version: Oracle JDBC Driver version - "10.2.0.4.0"
I haven't tried with a 11.x driver yet...............
--
[1]paulwerder(a)fastmail.co.uk
On Wed, 04 May 2011 14:14 +0300, "Nicklas Karlsson"
<nickarls(a)gmail.com> wrote:
And the version number is correct for the driver?
On Wed, May 4, 2011 at 1:40 PM, <[2]paulwerder(a)fastmail.co.uk>
wrote:
Hello Ike,
This is just a vague guess, but there used to be an issue with
the OSGI subsystem involved.
What AS version are you using? The problem I am referring to
should be solved in trunk.
But if you a running a previous release, then try commenting out
the osgi subsystem .
I'm using Beta3 - no luck :-(
--
[3]paulwerder(a)fastmail.co.uk
On Wed, 04 May 2011 12:23 +0200, "Heiko Braun"
<[4]hbraun(a)redhat.com> wrote:
This is just a vague guess, but there used to be an issue with
the OSGI subsystem involved.
What AS version are you using? The problem I am referring to
should be solved in trunk.
But if you a running a previous release, then try commenting out
the osgi subsystem .
Ike
On May 4, 2011, at 12:02 PM, [5]paulwerder(a)fastmail.co.uk wrote:
Hello,
do you have a
<drivers>
<driver
module="oracle.jdbc"/>
</drivers>
in your configuration at datasources subsystem?
yes I have inserted it, exaclty as you typed it. (sorry I forgot
to mention it before.)
might it be a specific issue with this JDBC driver ?
regards
Paul
--
[6]paulwerder(a)fastmail.co.uk
On Wed, 04 May 2011 12:54 +0300, "Nicklas Karlsson"
<[7]nickarls(a)gmail.com> wrote:
do you have a
<drivers>
<driver module="oracle.jdbc"/>
</drivers>
in your configuration at datasources subsystem?
On Wed, May 4, 2011 at 11:39
AM, <[8]paulwerder(a)fastmail.co.uk> wrote:
Hi JBoss devs,
I'm testing Oracle connectivity using a 10.2 JDBC Driver
(ojdbc14.jar).
Seems there are some issues- has anyone managed to connect to
an Oracle
DB ?
This is what the server reports:
report
New missing/unsatisfied dependencies:
service
jboss.jdbc-driver."oracle.jdbc.driver.OracleDriver".10.2
(missing)
And my configuration:
<datasource jndi-name="java:/OracleDS" pool-name="OracleDS"
enabled="true" use-java-context="true">
<connection-url>
jdbc:oracle:thin:@192.168.1.1:1530:ORACLESID
</connection-url>
<driver-class>
oracle.jdbc.driver.OracleDriver
</driver-class>
<driver>
oracle.jdbc.driver.OracleDriver#10.2
</driver>
<pool>
<prefill>
true
</prefill>
<use-strict-min>
false
</use-strict-min>
</pool>
<security>
<user-name>test</user-name>
<password>test</password>
</security>
<validation>
<validate-on-match>
false
</validate-on-match>
<background-validation>
false
</background-validation>
<useFastFail>
false
</useFastFail>
</validation>
<statement/>
</datasource>
I've chosen to install the JDBC driver as a module, so under
the
"modules" folder I've added:
oracle
└───jdbc
└───main
module.xml
ojdbc14.jar
ojdbc14.jar.index
Last thing, the module.xml:
<module xmlns="urn:jboss:module:1.0" name="oracle.jdbc">
<resources>
<resource-root path="ojdbc14.jar"/>
<!-- Insert resources here -->
</resources>
<dependencies>
<module name="javax.api"/>
</dependencies>
</module>
Can you find any reason why the driver does not get deployed ?
(I've tried also adding META-INF/services/java.sql.Driver with
the
driver class name- it didn't help however).
Thanks a lot
Paul
--
[9]paulwerder(a)fastmail.co.uk
--
[10]http://www.fastmail.fm - IMAP accessible web-mail
_______________________________________________
jboss-as7-dev mailing list
[11]jboss-as7-dev(a)lists.jboss.org
[12]https://lists.jboss.org/mailman/listinfo/jboss-as7-dev
--
---
Nik
_______________________________________________
jboss-as7-dev mailing list
[13]jboss-as7-dev(a)lists.jboss.org
[14]https://lists.jboss.org/mailman/listinfo/jboss-as7-dev
--
[15]http://www.fastmail.fm - mmm... Fastmail...
_______________________________________________
jboss-as7-dev mailing list
[16]jboss-as7-dev(a)lists.jboss.org
[17]https://lists.jboss.org/mailman/listinfo/jboss-as7-dev
--
[18]http://www.fastmail.fm - Does exactly what it says on the tin
_______________________________________________
jboss-as7-dev mailing list
[19]jboss-as7-dev(a)lists.jboss.org
[20]https://lists.jboss.org/mailman/listinfo/jboss-as7-dev
--
---
Nik
_______________________________________________
jboss-as7-dev mailing list
jboss-as7-dev(a)lists.jboss.org
https://lists.jboss.org/mailman/listinfo/jboss-as7-dev
References
1. mailto:paulwerder@fastmail.co.uk
2. mailto:paulwerder@fastmail.co.uk
3. mailto:paulwerder@fastmail.co.uk
4. mailto:hbraun@redhat.com
5. mailto:paulwerder@fastmail.co.uk
6. mailto:paulwerder@fastmail.co.uk
7. mailto:nickarls@gmail.com
8. mailto:paulwerder@fastmail.co.uk
9. mailto:paulwerder@fastmail.co.uk
10. http://www.fastmail.fm/
11. mailto:jboss-as7-dev@lists.jboss.org
12. https://lists.jboss.org/mailman/listinfo/jboss-as7-dev
13. mailto:jboss-as7-dev@lists.jboss.org
14. https://lists.jboss.org/mailman/listinfo/jboss-as7-dev
15. http://www.fastmail.fm/
16. mailto:jboss-as7-dev@lists.jboss.org
17. https://lists.jboss.org/mailman/listinfo/jboss-as7-dev
18. http://www.fastmail.fm/
19. mailto:jboss-as7-dev@lists.jboss.org
20. https://lists.jboss.org/mailman/listinfo/jboss-as7-dev
--
http://www.fastmail.fm - IMAP accessible web-mail
5267
days inactive
5267
days old
10 comments
5 participants
participants (5)
-
David M. Lloyd -
Heiko Braun -
Nicklas Karlsson -
paulwerder＠fastmail.co.uk -
Stefano Maestri