cannot load jdbc oracle driver

[mrafalo]

Hi

 

I am strugling with this problem almost 2 days. I have installed jasper-server and oracle XE. I need to access oracle database from jasper but I keep getting: "cannot load jdbc class oracle.jdbc.driver.OracleDriver" error. I put ojdbc14.jar into my classpath and into [tomcat]commonlib. It did not help. Then I tried to install jasper oracle patch. I did all the steps according to instruction and now jasper-server cannot start..;) The problem is still :"cannot load jdbc class oracle.jdbc.driver.OracleDriver". My context.xml is:

-----

<Resource name="jdbc/jasperserver" auth="Container" type="javax.sql.DataSource" maxActive="100" maxIdle="30" maxWait="10000"

username="ji" password="ji" driverClassName="oracle.jdbc.driver.OracleDriver"

url="jdbc:oracle:oci:@xe" validationQuery="select 1 from dual"/>

------

If anyone can help me, I would be really gratetful.

Thanks,

 

Mario

[swood]

I am not an Oracle expert, but I think you have a error in the Tomcat JNDI config for Oracle.

Use either:

Code:

or

Code:

Notice the difference in the type, driverClassName and factory settings.

Here is a more detailed explanation: http://www.microdeveloper.com/html/JNDI_Orcl_Tomcat.html

Sherman
JasperSoft

[martynhiemstra]

You need to add this to your web.xml

 

Code:

<resource-ref>
  <description>Oracle datasource</description>
  <res-ref-name>jdbc/jasperserver</res-ref-name>
  <res-type>javax.sql.DataSource</res-type>
  <res-auth>Container</res-auth>
</resource-ref>

[mrafalo]

I have made changes in context.xml and web.xml and now the connection apears to be working fine.

 

Thanks!

 

Mario

[mhamlett]

can you post the same fix for ms sql

i am trying to get my jasper server to work with this data base and all i get is classpath not found

 

michael

[prashanth_89]

Hi mario,

Could you please let me know what are the changes or the patch files that you uploaded in order to make the jasperserver interact with the oracle database.I use the jasperserver ce 3.7 and Oracle 10G.Thanks in advance.

You could mail me to padmaprashanth.r@gmail.com

 

Regards,

Prashanth R