Hi All,
I am using livesite 2.2.1 and I am trying to generate the HTML using the livesite_java.bat which works fine for the normal static page without the DB connection but when i am try to generate the html page which has DB connection is throwing the below exception:
*****Error****
Error in getMultipleJDBCXML.java.lang.NullPointerException
java.lang.NullPointerException
at com.interwoven.livesite.external.BaseExternal.getConnection(BaseExter
nal.java:289)
at com.interwoven.livesite.external.impl.SQL.getJDBCXML(SQL.java:166)
at com.interwoven.emea.livesite.common.utilities.Sql.getMultipleJDBCXML(
Unknown Source)
at com.interwoven.emea.livesite.common.utilities.Sql.execute(Unknown Sou
rce)
at com.interwoven.livesite.model.page.enduser.EndUserComponent.getDataDO
M(EndUserComponent.java:385)
at com.interwoven.livesite.model.page.enduser.EndUserComponent.transform
(EndUserComponent.java:262)
at com.interwoven.livesite.model.page.PreviewPage.getRenderedComponent(P
reviewPage.java:180)
at com.interwoven.livesite.model.page.enduser.EndUserPage.transform(EndU
serPage.java:303)
at com.interwoven.livesite.model.page.PreRenderedPage.transform(PreRende
redPage.java:156)
at com.interwoven.livesite.business.BusinessPageGenerator.generatePages(
BusinessPageGenerator.java:224)
at com.interwoven.livesite.tools.PageGenerator.generate(PageGenerator.ja
va:190)
at com.interwoven.livesite.tools.PageGenerator.main(PageGenerator.java:3
02)
Saving pages.
Y:/default/main/Eversheds/Internet/WORKAREA/Home/html/uk/home/CLTTest.html
Done.
***********
However page generated but there is no content generated from the DB component.
Please help me to resolve this.
***livesite_java.bat*****
@echo off
setlocal
REM INTERWOVEN, INC. PROPRIETARY AND CONFIDENTIAL
REM
REM
REM Copyright 2005 Interwoven, Inc. All rights reserved.
REM
REM Use of this product is subject to license terms. If this product
REM is acquired by the United States Government or any contractor
REM therefor, then the Government's rights in this product and related
REM documentation, which are "commercial computer software" and
REM "commercial computer documentation", respectively, will be only as
REM set forth in such license terms as specified in: (i) for
REM acquisitions by or on behalf of civilian agencies, 48 C.F.R. 12.212
REM of the Federal Acquisition Regulations and its successors; and (ii)
REM for acquisition by or on behalf of units of the Department of
REM Defense ("DoD"), in 48 C.F.R. 227.7202-1 through 227.7202-4 of the
REM DoD F.A.R. Supplement and its successors. All United States
REM Government end users acquire this product with only those rights
REM set forth in such license terms.
REM =======================================
REM livesite_java.bat
REM =======================================
REM
REM This batch file sets up the environment for accessing the
REM LiveSite business layer from a command line program. A
REM command line Java class that accesses the LiveSite business
REM layer needs a specific set of jars in its classpath and
REM properties defined, as specified in this file.
REM
REM Usage:
REM livesite_java.bat [jvm arguments]
[class arguments]
REM (This usage mirrors the use of java.exe, since this batch
REM file is just a wrapper around java.exe. Do NOT pass
REM any classpath information with -cp argument, as it will
REM conflict with the -cp passed in this file.)
REM =====================================================================
REM Modify the following variables before running this program:
REM This is the directory where LiveSite is installed.
set IW_HOME=C:\Interwoven\TeamSite
REM This is the LiveSite 2.2.1 jar file, containing all of the
REM LiveSite 2.2.1 classes.
set LIVESITE_JAR=%IW_HOME%\httpd\webapps\content_center\WEB-INF\lib\livesite.jar
REM Classes used by LiveSite which are not in the jar.
set LIVESITE_CLASSES=%IW_HOME%\httpd\webapps\content_center\WEB-INF\classes
REM Interwoven dependencies.
set DEPEND_JARS=%IW_HOME%\httpd\webapps\content_center\WEB-INF\lib\base.jar
set DEPEND_JARS=%DEPEND_JARS%;%IW_HOME%\httpd\webapps\content_center\WEB-INF\lib\serverutils100.jar
set DEPEND_JARS=%DEPEND_JARS%;%IW_HOME%\httpd\webapps\content_center\WEB-INF\lib\sharedutils100.jar
set DEPEND_JARS=%DEPEND_JARS%;%IW_HOME%\httpd\webapps\content_center\WEB-INF\lib\log100.jar
set DEPEND_JARS=%DEPEND_JARS%;%IW_HOME%\httpd\webapps\content_center\WEB-INF\lib\teamsite_admin.jar
set DEPEND_JARS=%DEPEND_JARS%;%IW_HOME%\cssdk\cssdkiface.jar
set DEPEND_JARS=%DEPEND_JARS%;%IW_HOME%\cssdk\cssdkjni.jar
set DEPEND_JARS=%DEPEND_JARS%;%IW_HOME%\httpd\webapps\content_center\WEB-INF\lib\msbase.jar
set DEPEND_JARS=%DEPEND_JARS%;%IW_HOME%\httpd\webapps\content_center\WEB-INF\lib\msutil.jar
set DEPEND_JARS=%DEPEND_JARS%;%IW_HOME%\httpd\webapps\content_center\WEB-INF\lib\mssqlserver.jar
REM Third-party dependencies.
set EXTERNAL_JARS=%IW_HOME%\httpd\webapps\content_center\WEB-INF\lib\log4j.jar
set EXTERNAL_JARS=%EXTERNAL_JARS%;%IW_HOME%\httpd\webapps\content_center\WEB-INF\lib\mail.jar
set EXTERNAL_JARS=%EXTERNAL_JARS%;%IW_HOME%\httpd\webapps\content_center\WEB-INF\lib\commons-lang.jar
set EXTERNAL_JARS=%EXTERNAL_JARS%;%IW_HOME%\httpd\webapps\content_center\WEB-INF\lib\customer.jar
REM The endorsed dir holds jars used by the runtime.
set ENDORSED_DIR=%IW_HOME%\servletd\common\endorsed
REM Java runtime dependencies.
set JAVA_JARS=%IW_HOME%\servletd\common\lib\servlet-api.jar
REM =====================================================================
REM Do NOT modify:
REM This variable is the java executable used to run the program.
set LIVESITE_JAVA=%IW_HOME%\tools\java\bin\java
REM The path needs to include cssdk and config info.
set PATH=%PATH%;%IW_HOME%\cssdk;%IW_HOME%\lib;%IW_HOME%\httpd\webapps\content_center\WEB-INF\lib;
REM Run the command
set COMMAND="%LIVESITE_JAVA%"
set COMMAND=%COMMAND% -cp "%LIVESITE_JAR%";"%LIVESITE_CLASSES%";"%DEPEND_JARS%";"%EXTERNAL_JARS%";"%JAVA_JARS%";
set COMMAND=%COMMAND% -Djava.endorsed.dirs=%ENDORSED_DIR%
set COMMAND=%COMMAND% -Dcssdk.cfg.path=%IW_HOME%\cssdk\cssdk.cfg
set COMMAND=%COMMAND% %*
echo %COMMAND%
%COMMAND%
endlocal
*******
Cheers
