SQL Error in web app
1 posts in topic
Flat View  Flat View
TOPIC ACTIONS:
 

Posted By:   Florin_Pop
Posted On:   Sunday, January 28, 2007 05:35 AM

I made a connection to the Oracle XE thru the wizard... everything is fine.Then I made this CRUD web application based on the connection and got this error: "javax.servlet.ServletException: Error in allocating a connection. Cause: Class name is wrong or classpath is not set for : oracle.jdbc.pool.OracleDataSource root cause java.sql.SQLException: Error in allocating a connection. Cause: Class name is wrong or classpath is not set for : oracle.jdbc.pool.OracleDataSource" WHAT DO I MUST DO? HOW DO I SET THE PROPER CLASSPATH? I added into Tools>Library Manager>Java DB Driver those: /usr/lib/oracle/xe/app/oracle/product/10.2.0/server/jdbc/lib/ojdbc.jar and /usr/lib   More>>
			
I made a connection to the Oracle XE thru the wizard...
everything is fine.Then I made this CRUD web application
based on the connection and got this error:
"javax.servlet.ServletException: Error in allocating a connection. Cause: Class name is wrong or classpath is not set for : oracle.jdbc.pool.OracleDataSource
root cause
java.sql.SQLException: Error in allocating a connection. Cause: Class name is wrong or classpath is not set for : oracle.jdbc.pool.OracleDataSource"
WHAT DO I MUST DO? HOW DO I SET THE PROPER CLASSPATH?

I added into Tools>Library Manager>Java DB Driver those:
/usr/lib/oracle/xe/app/oracle/product/10.2.0/server/jdbc/lib/ojdbc.jar
and
/usr/lib/oracle/xe/app/oracle/product/10.2.0/server/jdbc/lib/ojdbc_14g.jar

but still the same...
ps:I am a newbie, pls don't be hash with me

   <<Less

Re: SQL Error in web app

Posted By:   Florin_Pop  
Posted On:   Sunday, January 28, 2007 05:50 AM


found it...


right click on Libraries(Project views)->add library->Java DB Driver



thanks
About | Sitemap | Contact