|
|
|
CRConfig
|
|||
|---|---|---|---|
|
#18+
Господа подскажите как правильно необходимо отредактировать CRConfig.xml под Oracle,для того что бы можно было подключиться через JDBC. <?xml version="1.0" encoding="utf-8"?><CrystalReportEngine-configuration> <reportlocation>../..</reportlocation> <timeout>10</timeout> <ExternalFunctionLibraryClassNames> <classname> </classname> <classname> </classname> </ExternalFunctionLibraryClassNames> <keycode>Здесь прописан код</keycode> <Javaserver-configuration> <DataDriverCommon> <JavaDir>C:\Program Files\Business Objects\j2sdk1.4.2_08\bin</JavaDir> <Classpath>C:\Program Files\Business Objects\common\3.5\java/lib/crlovmanifest.jar;C:\Program Files\Business Objects\common\3.5\java/lib/CRLOVExternal.jar;C:\Program Files\Business Objects\common\3.5\java/lib/CRDBJavaServerCommon.jar;C:\Program Files\Business Objects\common\3.5\java/lib/CRDBJavaServer.jar;C:\Program Files\Business Objects\common\3.5\java/lib/CRDBJDBCServer.jar;C:\Program Files\Business Objects\common\3.5\java/lib/CRDBXMLServer.jar;C:\Program Files\Business Objects\common\3.5\java/lib/CRDBJavaBeansServer.jar;C:\Program Files\Business Objects\common\3.5\java/lib/external/CRDBXMLExternal.jar;C:\Program Files\Business Objects\common\3.5\java/lib/external/log4j.jar;C:\Program Files\Business Objects\common\3.5\java/lib/cecore.jar;C:\Program Files\Business Objects\common\3.5\java/lib/celib.jar;C:\Program Files\Business Objects\common\3.5\java/lib/ebus405.jar;C:\Program Files\Business Objects\common\3.5\java/lib/corbaidl.jar;C:\Program Files\Business Objects\common\3.5\java/lib/external/freessl201.jar;C:\Program Files\Business Objects\common\3.5\java/lib/external/asn1.jar;C:\Program Files\Business Objects\common\3.5\java/lib/external/certj.jar;C:\Program Files\Business Objects\common\3.5\java/lib/external/jsafe.jar;C:\Program Files\Business Objects\common\3.5\java/lib/external/sslj.jar;C:\oracle\ora92\jdbc/lib/ojdbc14.jar;${CLASSPATH}</Classpath> <IORFileLocation>${TEMP}</IORFileLocation> <JavaServerTimeout>1800</JavaServerTimeout> <JavaServerStartupTimeout>30</JavaServerStartupTimeout> <JVMMaxHeap>64000000</JVMMaxHeap> <JVMMinHeap>32000000</JVMMinHeap> <NumberOfThreads>100</NumberOfThreads> </DataDriverCommon> <JDBC> <CacheRowSetSize>100</CacheRowSetSize> <JDBCURL>jdbc:oracle:thin:@host:port:sid</JDBCURL> <JDBCClassName>oracle.jdbc.OracleDriver</JDBCClassName> <JDBCUserName>пароль</JDBCUserName> <JNDIURL></JNDIURL> <JNDIConnectionFactory></JNDIConnectionFactory> <JNDIInitContext>/</JNDIInitContext> <JNDIUserName>weblogic</JNDIUserName> <GenericJDBCDriver> <Default> <ServerType>UNKNOWN</ServerType> <QuoteIdentifierOnOff>ON</QuoteIdentifierOnOff> <StoredProcType>Standard</StoredProcType> <LogonStyle>Standard</LogonStyle> </Default> <Sybase> <ServerType>SYBASE</ServerType> <QuoteIdentifierOnOff>OFF</QuoteIdentifierOnOff> <DriverClassName>com.sybase.jdbc2.jdbc.SybDriver</DriverClassName> <StoredProcType>Standard</StoredProcType> <LogonStyle>MySQL</LogonStyle> </Sybase> </GenericJDBCDriver> </JDBC> <XML> <CacheRowSetSize>100</CacheRowSetSize> <PreReadNBytes>4096</PreReadNBytes> <XMLLocalURL></XMLLocalURL> <SchemaLocalURL></SchemaLocalURL> <XMLHttpURL></XMLHttpURL> <SchemaHttpURL></SchemaHttpURL> </XML> <JavaBeans> <CacheRowSetSize>100</CacheRowSetSize> <JavaBeansClassPath></JavaBeansClassPath> </JavaBeans> </Javaserver-configuration> </CrystalReportEngine-configuration> ... |
|||
|
:
Нравится:
Не нравится:
|
|||
| 24.10.2008, 10:18 |
|
||
|
CRConfig
|
|||
|---|---|---|---|
|
#18+
Как всегда отвечаю себе сам))) Необходимо было указать Classpath отвечающий за подключение. <?xml version="1.0" encoding="utf-8"?><CrystalReportEngine-configuration> <reportlocation>../..</reportlocation> <timeout>10</timeout> <ExternalFunctionLibraryClassNames> <classname> </classname> <classname> </classname> </ExternalFunctionLibraryClassNames> <keycode>Здесь прописан код</keycode> <Javaserver-configuration> <DataDriverCommon> <JavaDir>C:\Program Files\Business Objects\j2sdk1.4.2_08\bin</JavaDir> <Classpath>С:\oracle\ora92\jdbc\lid\ojdbc14.jar;C:\Program Files\Business Objects\common\3.5\java/lib/crlovmanifest.jar;C:\Program Files\Business Objects\common\3.5\java/lib/CRLOVExternal.jar;C:\Program Files\Business Objects\common\3.5\java/lib/CRDBJavaServerCommon.jar;C:\Program Files\Business Objects\common\3.5\java/lib/CRDBJavaServer.jar;C:\Program Files\Business Objects\common\3.5\java/lib/CRDBJDBCServer.jar;C:\Program Files\Business Objects\common\3.5\java/lib/CRDBXMLServer.jar;C:\Program Files\Business Objects\common\3.5\java/lib/CRDBJavaBeansServer.jar;C:\Program Files\Business Objects\common\3.5\java/lib/external/CRDBXMLExternal.jar;C:\Program Files\Business Objects\common\3.5\java/lib/external/log4j.jar;C:\Program Files\Business Objects\common\3.5\java/lib/cecore.jar;C:\Program Files\Business Objects\common\3.5\java/lib/celib.jar;C:\Program Files\Business Objects\common\3.5\java/lib/ebus405.jar;C:\Program Files\Business Objects\common\3.5\java/lib/corbaidl.jar;C:\Program Files\Business Objects\common\3.5\java/lib/external/freessl201.jar;C:\Program Files\Business Objects\common\3.5\java/lib/external/asn1.jar;C:\Program Files\Business Objects\common\3.5\java/lib/external/certj.jar;C:\Program Files\Business Objects\common\3.5\java/lib/external/jsafe.jar;C:\Program Files\Business Objects\common\3.5\java/lib/external/sslj.jar;${CLASSPATH}</Classpath> <IORFileLocation>${TEMP}</IORFileLocation> <JavaServerTimeout>1800</JavaServerTimeout> <JavaServerStartupTimeout>30</JavaServerStartupTimeout> <JVMMaxHeap>64000000</JVMMaxHeap> <JVMMinHeap>32000000</JVMMinHeap> <NumberOfThreads>100</NumberOfThreads> </DataDriverCommon> <JDBC> <CacheRowSetSize>100</CacheRowSetSize> <JDBCURL>jdbc:oracle:thin:@host:port:sid</JDBCURL> <JDBCClassName>oracle.jdbc.OracleDriver</JDBCClassName> <JDBCUserName>пароль</JDBCUserName> <JNDIURL></JNDIURL> <JNDIConnectionFactory></JNDIConnectionFactory> <JNDIInitContext>/</JNDIInitContext> <JNDIUserName>weblogic</JNDIUserName> <GenericJDBCDriver> <ServerType>UNKNOWN</ServerType> <QuoteIdentifierOnOff>ON</QuoteIdentifierOnOff> <StoredProcType>Standard</StoredProcType> <LogonStyle>Oracle</LogonStyle> </GenericJDBCDriver> </JDBC> <XML> <CacheRowSetSize>100</CacheRowSetSize> <PreReadNBytes>4096</PreReadNBytes> <XMLLocalURL></XMLLocalURL> <SchemaLocalURL></SchemaLocalURL> <XMLHttpURL></XMLHttpURL> <SchemaHttpURL></SchemaHttpURL> </XML> <JavaBeans> <CacheRowSetSize>100</CacheRowSetSize> <JavaBeansClassPath></JavaBeansClassPath> </JavaBeans> </Javaserver-configuration> </CrystalReportEngine-configuration> ... |
|||
|
:
Нравится:
Не нравится:
|
|||
| 24.10.2008, 12:01 |
|
||
|
CRConfig
|
|||
|---|---|---|---|
|
#18+
Может кому пригодиться как правильно необходимо отредактировать CRConfig.xml под SQLServer, для того что бы подключиться через jdbc. Необходимо сконфигурировать следующие элементы. <JavaDir> директория java.<JavaDir> Classpath>C:\Program Files\Common Files\Business Objects\3.0\java/lib/crlovmanifest.jar;C:\Program Files\Common Files\Business Objects\3.0\java/lib/CRLOVExternal.jar;C:\Program Files\Common Files\Business Objects\3.0\java/lib/CRDBJavaServerCommon.jar;C:\Program Files\Common Files\Business Objects\3.0\java/lib/CRDBJavaServer.jar;C:\Program Files\Common Files\Business Objects\3.0\java/lib/CRDBJDBCServer.jar;C:\Program Files\Common Files\Business Objects\3.0\java/lib/CRDBXMLServer.jar;C:\Program Files\Common Files\Business Objects\3.0\java/lib/CRDBJavaBeansServer.jar;C:\Program Files\Common Files\Business Objects\3.0\java/lib/external/CRDBXMLExternal.jar;C:\Program Files\Common Files\Business Objects\3.0\java/lib/external/log4j.jar;C:\Program Files\Common Files\Business Objects\3.0\java/lib/cecore.jar;C:\Program Files\Common Files\Business Objects\3.0\java/lib/celib.jar;C:\Program Files\Common Files\Business Objects\3.0\java/lib/ebus405.jar;C:\Program Files\Common Files\Business Objects\3.0\java/lib/corbaidl.jar;C:\Program Files\Common Files\Business Objects\3.0\java/lib/external/freessl201.jar;C:\Program Files\Common Files\Business Objects\3.0\java/lib/external/asn1.jar;C:\Program Files\Common Files\Business Objects\3.0\java/lib/external/certj.jar;C:\Program Files\Common Files\Business Objects\3.0\java/lib/external/jsafe.jar;C:\Program Files\Common Files\Business Objects\3.0\java/lib/external/sslj.jar; C:\Program Files\Microsoft SQL Server 2000 Driver for JDBC\lib\msbase.jar;C:\Program Files\Microsoft SQL Server 2000 Driver for JDBC\lib\mssqlserver.jar;C:\Program Files\Microsoft SQL Server 2000 Driver for JDBC\lib\msutil.jar;${ CLASSPATH}</Classpath> <JDBCURL>jdbc:microsoft:sqlserver://SERVERNAME:PORTNUMBER<JDBCURL> <JDBCClassName>com.microsoft.jdbc.sqlserver.SQLServerDriver<JDBCClassName> <JDBCUserName>ваш логин<JDBCUserName> <LogonStyle>SQLServer</LogonStyle> ... |
|||
|
:
Нравится:
Не нравится:
|
|||
| 11.03.2009, 08:36 |
|
||
|
|

start [/forum/topic.php?fid=31&fpage=90&tid=1536319]: |
0ms |
get settings: |
9ms |
get forum list: |
10ms |
check forum access: |
2ms |
check topic access: |
2ms |
track hit: |
43ms |
get topic data: |
7ms |
get forum data: |
2ms |
get page messages: |
31ms |
get tp. blocked users: |
1ms |
| others: | 205ms |
| total: | 312ms |

| 0 / 0 |
