部署环境:win10+tomcat8+jdk1.8+oracle11g(当然jdk版本不是必须这么高,1.6以上就行)
1、将自己报表 H:\润乾报表2018\report\web路径下的demo复制到tomcat目录H:\Tomcat\apache-tomcat-8.5.34-windows-x64\apache-tomcat-8.5.34\webapps下(此处我并重命名为vdemo2018)。
2、配置数据库连接池(此处选用 JNDI 的连接方式)
1)确定报表中数据源的名称(此处我数据源名为 orcl);
2)再tomcat该目录:H:\Tomcat\apache-tomcat-8.5.34-windows-x64\apache-tomcat-8.5.34\conf\Catalina\localhost下建立和1处相同名的xml文件。(此次我的为v2018demo.xml)。
3)再改xml中添加如下内容:
4)修改该文件中的内容:H:\Tomcat\apache-tomcat-8.5.34-windows-x64\apache-tomcat-8.5.34\webapps\v2018demo\WEB-INF下的raqsoftConfig.xml
<?xml version="1.0" encoding="UTF-8"?>
<!--注意:为避免程序使用异常,raqsoftConfig.xml文件的编码格式必须设置为UTF-8 --><Config Version="1">
<Runtime>
<DBList>
<!-- 数据库类型编号,UNKNOWN:0; ORACLE:1; SQLSVR:2; SYBASE:3; SQLANY:4; INFMIX:5; FOXPRO:6; ACCESS:7; FOXBAS:8; DB2:9; MYSQL:10; KINGBASE:11; DERBY:12; HSQL:13; TERADATA:14;POSTGRES:15; DATALOGIC:16; IMPALA:17; ESSBASE:101; -->
<DB name="demo">
<property name="url" value="jdbc:hsqldb:hsql://127.0.0.1/demo" />
<property name="driver" value="org.hsqldb.jdbcDriver" />
<property name="type" value="13" />
<property name="user" value="sa" />
<property name="password" />
<property name="batchSize" value="1000" />
<property name="autoConnect" value="false" />
<property name="useSchema" value="false" />
<property name="addTilde" value="false" />
<property name="dbCharset" value="UTF-8" />
<property name="clientCharset" value="UTF-8" />
<property name="needTransContent" value="false" />
<property name="needTransSentence" value="false" />
<property name="caseSentence" value="false" />
</DB>
<DB name="orcl">
<property name="url" value="jdbc:oracle:thin:@127.0.0.1:1521:ORCL" />
<property name="driver" value="oracle.jdbc.OracleDriver" />
<property name="type" value="1" />
<property name="user" value="scott" />
<property name="password" value="123456"/>
<property name="batchSize" value="1000" />
<property name="autoConnect" value="false" />
<property name="useSchema" value="false" />
<property name="addTilde" value="false" />
<property name="dbCharset" value="UTF-8" />
<property name="clientCharset" value="UTF-8" />
<property name="needTransContent" value="false" />
<property name="needTransSentence" value="false" />
<property name="caseSentence" value="false" />
</DB>
<DB name="DataLogic">
<property name="url" value="jdbc:datalogic://127.0.0.1:3366/datalogic" />
<property name="driver" value="com.datalogic.jdbc.LogicDriver" />
<property name="type" value="16" />
<property name="user" value="root" />
<property name="password" value="root" />
<property name="batchSize" value="1000" />
<property name="autoConnect" value="false" />
<property name="useSchema" value="false" />
<property name="addTilde" value="false" />
<property name="dbCharset" value="UTF-8" />
<property name="clientCharset" value="UTF-8" />
<property name="needTransContent" value="false" />
<property name="needTransSentence" value="false" />
<property name="caseSentence" value="false" />
</DB>
</DBList>
<Esproc>
<license>H:\润乾报表2018\授权文件\qd13501242027-1.xml</license>
<charSet>UTF-8</charSet>
<dfxPathList>
<dfxPath>WEB-INF/reportFiles</dfxPath>
</dfxPathList>
<dateFormat>yyyy-MM-dd</dateFormat>
<timeFormat>HH:mm:ss</timeFormat>
<dateTimeFormat>yyyy-MM-dd HH:mm:ss</dateTimeFormat>
<mainPath />
<tempPath />
<bufSize>65536</bufSize>
<localHost />
<localPort>0</localPort>
<!--在独立启动的tomcat中部署demo应用时,当raqsoftReportLog.properties文件定义的日志输出级别与logLevel的交集时才会输出日志。比如logLevel为INFO级别,raqsoftReportLog.properties文件里的日志级别为DEBUG,那么web端日志则只会输出INFO级别的日志。-->
<logLevel>DEBUG</logLevel>
<callxParallel>1</callxParallel>
<nodeParallel>1</nodeParallel>
<zoneLockTryTime>3600</zoneLockTryTime>
</Esproc>
<Report>
<license>H:\润乾报表2018\授权文件\qd13501242027-1.xml</license>
<home>WEB-INF/reportFiles</home>
<styleConfig>tmp/reportStyleConfig.xml</styleConfig>
</Report>
<Input>
<home>WEB-INF/reportFiles</home>
</Input>
</Runtime>
<Server>
<JNDIList>
<JNDI name="orcl">
<property name="type" value="1"/>
<property name="batchSize" value="1000"/>
<property name="lookup" value="java:comp/env/orcl"/>
</JNDI>
</JNDIList>
<property name="raqsoftDir" value="raqsoft" />
<property name="jspCharset" value="UTF-8" />
<property name="cachedReportDir" value="cache/report" />
<property name="jreInstallName" value="/jre-6u45-windows-i586.exe#Version=1,6,0,0" />
<property name="cachedIdPrefix" value="A" />
<property name="maxWaitTimeForReport" value="9999" />
<property name="inputCachePath" value="cache/input" />
<property name="alwaysReloadDefine" value="yes" />
<property name="maxConcurrentForReport" value="9999" />
<property name="cachedReportTimeout" value="120" />
<property name="picFileExistTime" value="60" />
<property name="maxWaitForReport" value="9999" />
<property name="defDataSource" value="orcl" />
<property name="maxDatasetValueNum" value="-1" />
<property name="logConfig" value="WEB-INF/raqsoftReportLog.properties" />
<property name="cachedParamsTimeout" value="120" />
<property name="theme" value="default" />
</Server>
</Config>
这里主要该一下三处地方:
3、 放置数据库的驱动包值 tomcat/lib 目录下
4.重启tomcat,再点击url: http://localhost:8080/v2018demo/reportJsp/showReport.jsp?rpx=orcl.rpx