[Opensource] Mysql problem
Masoud Mirmoeini
mmoeini at hotmail.com
Thu Dec 5 18:17:29 PST 2002
Hello there,
I had no problem using expresso 4.+, accessing MYSQL database, I
installed Expresso 5.02 but I have following error accessing MYSQL
could you please help and tell me what could be the cause?
here is my expresso config file:
<?xml version="1.0" encoding="ISO-8859-1"?>
<!DOCTYPE expresso-config PUBLIC "-//Jcorporate Ltd//DTD Expresso
Configuration 4.0//EN"
"http://www.jcorporate.com/dtds/expresso-config_4_0.dtd">
<expresso-config>
<logDirectory>%web-app%WEB-INF/log</logDirectory>
<strongCrypto>n</strongCrypto>
<servletAPI>2_3</servletAPI>
<cryptoKey>Sample Test Key - Change for serious
deployment</cryptoKey>
<encryptMode>AES</encryptMode>
<class-handlers>
<class-handler name="userInfo"
classHandler="com.jcorporate.expresso.services.dbobj.DefaultUserInfo"/>
<class-handler name="orderedCache"
classHandler="com.jcorporate.expresso.core.cache.OrderedCache"/>
<class-handler name="unorderedCache"
classHandler="com.jcorporate.expresso.core.cache.UnOrderedCache"/>
<!-- Others are:
<class-handler name="nextNumber"
classHandler="com.centercomp.clustering.ClusterNextNumber"/>
<class-handler name="cacheSynchronizer"
classHandler="com.centercomp.clustering.ClusteredCacheSync"/>
-->
</class-handlers>
<context name="default">
<description>Hypersonic Database</description>
<jdbc driver="org.gjt.mm.mysql.Driver"
url="jdbc:mysql://localhost:3306/sprout"
connectFormat="1"
login="root"
password=""
cache="true"
limitationPosition="LIMITATION_AFTER_ORDER_BY"
limitationSyntax="LIMIT %offset% , %maxrecords%"
createTableIndicies="true"
hasBooleanType="false"
skipText="true"/>
<type-mapping>
<java-type>LONGVARCHAR</java-type>
<expresso-type>text</expresso-type>
<db-type>text</db-type>
</type-mapping>
<type-mapping>
<java-type>BIT</java-type>
<db-type>CHAR</db-type>
</type-mapping>
<type-mapping>
<java-type>REAL</java-type>
<db-type>DECIMAL</db-type>
</type-mapping>
<type-mapping>
<java-type>BINARY</java-type>
<db-type>LONGBLOB</db-type>
</type-mapping>
<type-mapping>
<java-type>VARCHAR</java-type>
<db-type>varchar</db-type>
</type-mapping>
<images>%context%/%expresso-dir%/images</images>
<startJobHandler>n</startJobHandler>
<showStackTrace>y</showStackTrace>
<mailDebug>n</mailDebug>
</context>
</expresso-config>
and the error:
javax.servlet.ServletException
at
com.jcorporate.expresso.core.servlet.StdServlet.showError(StdServlet.jav
a:281)
at
com.jcorporate.expresso.services.servlet.DBCreate.doPost(DBCreate.java:3
16)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:760)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:853)
at
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(Applica
tionFilterChain.java:247)
at
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilt
erChain.java:193)
at
org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValv
e.java:260)
at
org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.i
nvokeNext(StandardPipeline.java:643)
at
org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:4
80)
at
org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:995)
at
org.apache.catalina.core.StandardContextValve.invoke(StandardContextValv
e.java:191)
at
org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.i
nvokeNext(StandardPipeline.java:643)
at
org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:4
80)
at
org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:995)
at
org.apache.catalina.core.StandardContext.invoke(StandardContext.java:239
6)
at
org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java
:180)
at
org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.i
nvokeNext(StandardPipeline.java:643)
at
org.apache.catalina.valves.ErrorDispatcherValve.invoke(ErrorDispatcherVa
lve.java:170)
at
org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.i
nvokeNext(StandardPipeline.java:641)
at
org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java
:172)
at
org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.i
nvokeNext(StandardPipeline.java:641)
at
org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:4
80)
at
org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:995)
at
org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.
java:174)
at
org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.i
nvokeNext(StandardPipeline.java:643)
at
org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:4
80)
at
org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:995)
at
org.apache.coyote.tomcat4.CoyoteAdapter.service(CoyoteAdapter.java:223)
at
org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:40
5)
at
org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.processC
onnection(Http11Protocol.java:380)
at
org.apache.tomcat.util.net.TcpWorkerThread.runIt(PoolTcpEndpoint.java:50
8)
at
org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool
.java:533)
at java.lang.Thread.run(Thread.java:536)
root cause
java.lang.NullPointerException
at
com.jcorporate.expresso.core.dbobj.Schema.typeForDB(Schema.java:1622)
at
com.jcorporate.expresso.core.dbobj.Schema.createTable(Schema.java:1134)
at
com.jcorporate.expresso.core.dbobj.Schema.createAsNeeded(Schema.java:600
)
at
com.jcorporate.expresso.core.utility.DBTool.createTables(DBTool.java:212
1)
at
com.jcorporate.expresso.services.servlet.DBCreate.doPost(DBCreate.java:2
86)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:760)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:853)
at
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(Applica
tionFilterChain.java:247)
at
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilt
erChain.java:193)
at
org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValv
e.java:260)
at
org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.i
nvokeNext(StandardPipeline.java:643)
at
org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:4
80)
at
org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:995)
at
org.apache.catalina.core.StandardContextValve.invoke(StandardContextValv
e.java:191)
at
org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.i
nvokeNext(StandardPipeline.java:643)
at
org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:4
80)
at
org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:995)
at
org.apache.catalina.core.StandardContext.invoke(StandardContext.java:239
6)
at
org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java
:180)
at
org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.i
nvokeNext(StandardPipeline.java:643)
at
org.apache.catalina.valves.ErrorDispatcherValve.invoke(ErrorDispatcherVa
lve.java:170)
at
org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.i
nvokeNext(StandardPipeline.java:641)
at
org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java
:172)
at
org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.i
nvokeNext(StandardPipeline.java:641)
at
org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:4
80)
at
org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:995)
at
org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.
java:174)
at
org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.i
nvokeNext(StandardPipeline.java:643)
at
org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:4
80)
at
org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:995)
at
org.apache.coyote.tomcat4.CoyoteAdapter.service(CoyoteAdapter.java:223)
at
org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:40
5)
at
org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.processC
onnection(Http11Protocol.java:380)
at
org.apache.tomcat.util.net.TcpWorkerThread.runIt(PoolTcpEndpoint.java:50
8)
at
org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool
.java:533)
at java.lang.Thread.run(Thread.java:536)
Thanks
Masoud
_________________________________________________________________
The new MSN 8: advanced junk mail protection and 2 months FREE*
http://join.msn.com/?page=features/junkmail
More information about the Opensource
mailing list