multiple JDBC datasources & fields not showing in synonyms tables (1 Viewer)

shels5

New member
Local time
Yesterday, 20:55
Joined
Jun 16, 2008
Messages
1
Hi, I am trying to create a report within Crystal Reports XI using JDBC datasources and I have two problems;

First of all, when I run a report with two JDBC datasources, with separate tables, the whole program freezes. But when i run the datasources individually they work fine, and it returns all the data that i want. The only problem is, when i link the two datasources together within Crystal Reports, it freezes. Why is that?

Second problem, within Crystal Reports, when I connect to a new JDBC(JNDI) datasource, it would not display the fields of the synonyms tables.

If I start a new Standard Report, connections to the JDBC datasource works fine, but i cannot expand the synonym tables to show the fields.

Similarly, if I try to change the location of a datasource of a report by 'Set Datasource Location', when i update the datasource, the Map Fields dialog appears but there are no fields in the right boxes.

I dont know if this is because of Crystal Reports (XI Release 1), the driver or the CRConfig.xml file.

At the moment, this is how part of my CRConfig.xml file looks like:

<JDBC>

<CacheRowSetSize>100</CacheRowSetSize>

<JDBCURL>jdbc:eek:racle:thin:mad:156.78.96.12:1522://serverID</JDBCURL>

<JDBCClassName>oracle.jdbc.driver.OracleDriver</JDBCClassName>

<JDBCUserName>User</JDBCUserName>

<JNDIURL></JNDIURL>

<JNDIConnectionFactory></JNDIConnectionFactory>

<JNDIInitContext>/</JNDIInitContext>

<JNDIUserName>weblogic</JNDIUserName>

<GenericJDBCDriver>

<Option>No</Option>

<DatabaseStructure>catalogs,tables</DatabaseStructure>

<StoredProcType>Standard</StoredProcType>

<LogonStyle>Oracle</LogonStyle>

</GenericJDBCDriver>

</JDBC>

What may be the probable causes of my problem? And how can i solve it?
It should not be a permissions problem because it is set at a user level.

Thank You in advance.
 

Users who are viewing this thread

Top Bottom