Efren Lugo
|
| Posted: 06/19/2002, 7:49 AM |
|
i dont know want to insert into Database URL:
i had been trying this sintaxis:
Database URL: jdbc:oracle:oci8:@host:port:service
Database URL: jdbc:oracle:thin:@host:port:service
Database URL: jdbc:oracle:oci7:service
Database URL: jdbc:odbc:localhost/service
none of this works!! on CC2.0 the thin driver works! but in CCS dont work!
i got:
java.lang.NullPointerException
at com.codecharge.db.JDBCConnection.createPreparedStatement(JDBCConnection.java:728)
at com.codecharge.db.SqlCommand.prepareCommand(SqlCommand.java:155)
at com.codecharge.db.SqlCommand.count(SqlCommand.java:102)
at com.codecharge.PageController.processGrid(PageController.java:822)
at com.codecharge.PageController.process(PageController.java:229)
at org.apache.jsp.EMP$jsp._jspService(EMP$jsp.java:86)
at org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:107)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:853)
at org.apache.jasper.servlet.JspServlet$JspServletWrapper.service(JspServlet.java:202)
at org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:382)
at org.apache.jasper.servlet.JspServlet.service(JspServlet.java:474)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:853)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:247)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:193)
at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:243)
at org.apache.catalina.core.StandardPipeline.invokeNext(StandardPipeline.java:566)
at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:472)
at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:943)
at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:190)
at org.apache.catalina.core.StandardPipeline.invokeNext(StandardPipeline.java:566)
at org.apache.catalina.valves.CertificatesValve.invoke(CertificatesValve.java:246)
at org.apache.catalina.core.StandardPipeline.invokeNext(StandardPipeline.java:564)
at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:472)
at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:943)
at org.apache.catalina.core.StandardContext.invoke(StandardContext.java:2343)
at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:180)
at org.apache.catalina.core.StandardPipeline.invokeNext(StandardPipeline.java:566)
at org.apache.catalina.valves.ErrorDispatcherValve.invoke(ErrorDispatcherValve.java:170)
at org.apache.catalina.core.StandardPipeline.invokeNext(StandardPipeline.java:564)
at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:170)
at org.apache.catalina.core.StandardPipeline.invokeNext(StandardPipeline.java:564)
at org.apache.catalina.valves.AccessLogValve.invoke(AccessLogValve.java:468)
at org.apache.catalina.core.StandardPipeline.invokeNext(StandardPipeline.java:564)
at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:472)
at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:943)
at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:174)
at org.apache.catalina.core.StandardPipeline.invokeNext(StandardPipeline.java:566)
at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:472)
at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:943)
at org.apache.catalina.connector.http.HttpProcessor.process(HttpProcessor.java:1012)
at org.apache.catalina.connector.http.HttpProcessor.run(HttpProcessor.java:1107)
at java.lang.Thread.run(Thread.java:536)
what can be happen, some one has a success history on JSPs???
i had TOMCAT,Oracle8i,Windows2000
all works fine on CC2.0 but in CCS1.0 dont work nothing!
|
|
|
 |
Stano
|
| Posted: 06/20/2002, 3:31 AM |
|
what version tomcat you have?
i think that problem is library jdbc2_0-stdext.jar with
Data source extension. You should copy this to
WEB-INF\lib directory
|
|
|
|
Efren Lugo
|
| Posted: 06/20/2002, 6:37 AM |
|
I have
TOMCAT4.0.3
JDK 1.4.0
ANT from JavaTM Web Services Developer Pack 1.0
|
|
|
|
Efren Lugo
|
| Posted: 06/20/2002, 6:40 AM |
|
I also forget im using the Oracle Thin driver.
JDBC connection...
my Oracle ver 8.1
|
|
|
|
Efren Lugo
|
| Posted: 06/20/2002, 7:13 AM |
|
My lib directory contains the following jars... i think is complete...
classes12.jar
cos.jar
jasper-compiler.jar
jasper-runtime.jar
jdbc2_0-stdext.jar
jep.jar
msbase.jar
msutil.jar
naming-factory.jar
nls_charset12.jar
oscache.jar
rowset.jar
and i still having the same error!
|
|
|
|
Stano
|
| Posted: 06/20/2002, 7:15 AM |
|
on working directory ( with project.ccs file )
make subdirectories WEB-INF\lib
copy thin driver into lib directory
delete subdirectory CCSBuild
start CCS, deploy application, with publishing "All files excluding extensions"
(ccs, ccp)
it deploy xxxx.war file
on tomcat delete application directory xxxx (webapps\xxxx)
start tomcat - tomcat expand xxxx.war (only if directory xxxx not exist)
IT WORKS!
I have successfull test with postgress, oracle, and mysql
|
|
|
|
EMG
|
| Posted: 06/20/2002, 7:37 AM |
|
Try setting the project language settings to PHP 4.0. This should eleviate a lot of your headaches.
Har,Har, just little joke to keep things fun. JSP can be a real config pain!
|
|
|
|
stano
|
| Posted: 06/20/2002, 7:42 AM |
|
it works fine
CCS is great, but very young wayward teenager 
|
|
|
|
Dandavat
|
| Posted: 06/20/2002, 8:58 AM |
|
Efren,
You may want to share jdbc driver across different applications. Then it is simplier to copy driver jar to $CATALINA_HOME/lib directory.
|
|
|
|
Efren Lugo
|
| Posted: 06/20/2002, 9:15 AM |
|
Stano
I had set the WEB-INF\lib
with all jars...
and still the same problem i had deleted from work folder an webapps folder...
and i republish the file... but the problem still... do you have another customization could help me out???
Jakarta Tomcat 4.0.3
Oracle Enterprise 8i
J2SDK 1.4
ANT from JavaTM Web Services Developer Pack 1.0
CATALINA_HOME = C:\Oracle\ora81\Apache\Tomcat\
CLASSPATH = C:\oracle\ora81\Apache\Tomcat\lib;C:\oracle\ora81\Apache\Tomcat\common\lib;C:\oracle\ora81\Apache\Tomcat\server\lib
ANT_HOME = C:\WINDOWS\JAVAFramework\JavaAnt\
JAVA_HOME = C:\WINDOWS\JAVAFramework\JDK1.4.0.1
I'm confused why it don't work... there is a configuration on Tomcat /CONF/sever.xml or something like that???
My App location look like this:
C:\Oracle\ora81\Apache\Tomcat\webapps\scott
|
|-----\META-INF\
|
|-----\Themes\
|
|-----\WEB-INF
| |------lib
| |------classes
i access my app via : http://localhost:8080/scott
the values im using:
DATABASEURL:jdbc:oracle:thin:@192.168.0.55:1521:sintec
DRIVER:oracle.jdbc.driver.OracleDriver
do you have another recomendation???
|
|
|
|
stano
|
| Posted: 06/20/2002, 10:04 AM |
|
all sounds good 
if you has application scott
you must deploy scott.war into C:\Oracle\ora81\Apache\Tomcat\webapps
remove subdirectory scott on C:\Oracle\ora81\Apache\Tomcat\webapps\
after starting tomcat -
tomcat expands scott.war into C:\Oracle\ora81\Apache\Tomcat\webapps\scott
you must have WEB-INF ..... and all subdirectories
|
|
|
|
Efren Lugo
|
| Posted: 06/20/2002, 10:22 AM |
|
Exactly i had made that... also deleted data on work directory...
i got success the war and descompress good all files get success... i think there is an error on my connection string...
there is correct just like:
Database URL: jdbc:oracle:thin:@host:port:service
i think thin driver dont work on CCS or there is an error... how do you specified URL and Driver??? for Oracle
|
|
|
|
Efren
|
| Posted: 06/20/2002, 1:07 PM |
|
Works!!!
y remove all dirvers jars and place it on common/lib from tomcat server only...
maybe there was many copies from de files and dont load ....
now works!
|
|
|
|
