[Opensource] SQL Server 2000 configuration
xiang zhang
seanzhanglink at yahoo.com
Tue Sep 10 08:48:12 PDT 2002
Hi,
Do does anyone really use MS JDBC driver to configue
expresso.xml?
I test posted message regarding of MSSql server
configuration, seems that no one can works in the
right way (see)
http://mail.jcorporate.com/pipermail/opensource/2002-June/011192.html
here is my MSSql configuration:
<context name="default">
<description>ms Database</description>
<jdbc
driver="com.microsoft.jdbc.sqlserver.SQLServerDriver"
url="jdbc:microsoft:sqlserver://192.168.0.10:1433;databaseName=v2k"
connectFormat="1"
login="sa"
password=""
dateSelectFormat="dd-MM-yyyy"
dateUpdateFormat="dd-MM-yyyy"
dateTimeSelectFormat="yyyy-MM-dd"
dateTimeUpdateFormat="yyyy-MM-dd"
createTableIndicies="true"
cache="y">
<dbWildcard>%</dbWildcard>
<dbWildcard>*</dbWildcard>
</jdbc>
<type-mapping>
<java-type>LONGVARCHAR</java-type>
<expresso-type>text</expresso-type>
<db-type>text</db-type>
</type-mapping>
<type-mapping>
<java-type>DATE</java-type>
<db-type>datetime</db-type>
</type-mapping>
<type-mapping>
<java-type>TIMESTAMP</java-type>
<db-type>smalldatetime</db-type>
</type-mapping>
<type-mapping>
<java-type>DOUBLE</java-type>
<db-type>NUMERIC</db-type>
</type-mapping>
<type-mapping>
<java-type>LONGVARCHAR</java-type>
<db-type>VARCHAR(1024)</db-type>
</type-mapping>
<type-mapping>
<java-type>INTEGER</java-type>
<db-type>int</db-type>
</type-mapping>
<type-mapping>
<java-type>NUMERIC</java-type>
<db-type>NUMERIC</db-type>
</type-mapping>
<images>%context%/%expresso-dir%/images</images>
<startJobHandler>y</startJobHandler>
<showStackTrace>y</showStackTrace>
<mailDebug>n</mailDebug>
</context>
I successfully finish setup operation, but when I try
to login , it throws folowing exception:
Thanks in advance
I'm trying to figure out the type mapping for SQL
Server 2000.
I'm using the MS JDBC driver
Apache Tomcat/4.0.4
java.lang.NullPointerException
at
java.util.Calendar.setTime(Calendar.java:902)
at
java.text.SimpleDateFormat.format(SimpleDateFormat.java:780)
at
java.text.SimpleDateFormat.format(SimpleDateFormat.java:773)
at
java.text.DateFormat.format(DateFormat.java:314)
at
com.jcorporate.expresso.core.misc.DateTime.getDateForDB(DateTime.java
:360)
at
com.jcorporate.expresso.core.dbobj.DBObject.getCustomStringFieldValue
(DBObject.java:3378)
at
com.jcorporate.expresso.core.dbobj.DBObject.searchAndRetrieveList(DBO
bject.java:5761)
at
com.jcorporate.expresso.core.dbobj.SecuredDBObject.searchAndRetrieveL
ist(SecuredDBObject.java:635)
at
com.jcorporate.expresso.services.dbobj.DefaultUserInfo.getGroups(Defa
ultUserInfo.java:276)
at
com.jcorporate.expresso.core.security.User.getGroups(User.java:433)
at
com.jcorporate.expresso.core.security.User.postLogin(User.java:765)
at
com.jcorporate.expresso.core.servlet.CheckLogin.loginViaCookie(CheckL
ogin.java:437)
at
com.jcorporate.expresso.core.servlet.CheckLogin.check(CheckLogin.java
:201)
at
com.jcorporate.expresso.core.servlet.CheckLogin.checkLogin(CheckLogin
.java:123)
at
org.apache.jsp.frame$jsp._jspService(frame$jsp.java:164)
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(JspSer
vlet.java:201)
at
org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:3
81)
at
org.apache.jasper.servlet.JspServlet.service(JspServlet.java:473)
at
javax.servlet.http.HttpServlet.service(HttpServlet.java:853)
at
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(Appl
icationFilterChain.java:247)
at
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationF
ilterChain.java:193)
at
org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperV
alve.java:243)
at
org.apache.catalina.core.StandardPipeline.invokeNext(StandardPipeline
.java:566)
at
org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.jav
a:472)
at
org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:943)
at
org.apache.catalina.core.StandardContextValve.invoke(StandardContextV
alve.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.jav
a:472)
at
org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:943)
at
org.apache.catalina.core.StandardContext.invoke(StandardContext.java:
2347)
at
org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.j
ava:180)
at
org.apache.catalina.core.StandardPipeline.invokeNext(StandardPipeline
.java:566)
at
org.apache.catalina.valves.ErrorDispatcherValve.invoke(ErrorDispatche
rValve.java:170)
at
org.apache.catalina.core.StandardPipeline.invokeNext(StandardPipeline
.java:564)
at
org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.j
ava: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.jav
a:472)
at
org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:943)
at
org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineVal
ve.java:174)
at
org.apache.catalina.core.StandardPipeline.invokeNext(StandardPipeline
.java:566)
at
org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.jav
a:472)
at
org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:943)
at
org.apache.catalina.connector.http.HttpProcessor.process(HttpProcesso
r.java:1027)
at
org.apache.catalina.connector.http.HttpProcessor.run(HttpProcessor.ja
va:1125)
at java.lang.Thread.run(Thread.java:536)
2002-09-10 11:32:23,079 ERROR [HttpProcessor[8080][4]]
servlet.CheckLogin (Check
Login.java:208) - java.lang.NullPointerException
__________________________________________________
Yahoo! - We Remember
9-11: A tribute to the more than 3,000 lives lost
http://dir.remember.yahoo.com/tribute
More information about the Opensource
mailing list