i tried a lot of methods, i read an lot of post here and in other pages, but i cant resolve why i getting this error, we dont want to use jndi because every connection data are stored at the master database, want to do a programatically connection, please help me dont know what to do.

You are confuzing module names and class names. looking more closly on what you have posted so far...

given the fact that you have allready created module which has oracle driver (jar) in it.

You can trim the jboss-deployment-structure.xml even more. it should be just this:

<?xml version="1.0" encoding="UTF-8"?>

<jboss-deployment-structure>

<deployment>

<dependencies>

<module name="com.oracle.ojdbc6" />

</dependencies>

</deployment>

</jboss-deployment-structure>

and this "com.oracle.ojdbc6" is name of module you have created for oracle jdbc driver, it is same module you use when defining datasource and lookup it trough jndi. also you do *not* need ojdbc6.jar to be part of your application it is enough for it just to be in module you defined.