on 06-14-2012 11:16 AM
Hello
I'm trying to use JBoss 5.1 JNDI datasources in Crystal Reports 2011. My point of focus is hiding database credentials from the end user behind JBoss. After some struggle I managed to make my datasource visible in Crystal Reports
my configuration looks like this:
CRConfig.xml
<JNDIURL>localhost:1099</JNDIURL>
<JNDIConnectionFactory>org.jboss.naming.NamingContextFactory</JNDIConnectionFactory>
<JNDIInitContext>/</JNDIInitContext>
datasources on JBoss
<datasources>
<local-tx-datasource>
<jndi-name>MSAccessDS</jndi-name>
<use-java-context>false</use-java-context>
<!-- format of URL is "jdbc:odbc:DSNNAME" -->
<connection-url>jdbc:odbc:Xtreme Sample
</connection-url>
<driver-class>sun.jdbc.odbc.JdbcOdbcDriver
</driver-class>
<user-name></user-name>
<password></password>
</local-tx-datasource>
<local-tx-datasource>
<jndi-name>OracleDS</jndi-name>
<!-- format of URL is "jdbc:odbc:DSNNAME" -->
<use-java-context>false</use-java-context>
<connection-url>jdbc:oracle:thin:@localhost:1521:mydb
</connection-url>
<driver-class>oracle.jdbc.driver.OracleDriver
</driver-class>
<user-name>username</user-name>
<password>password</password>
<exception-sorter-class-name>org.jboss.resource.adapter.jdbc.vendor.OracleExceptionSorter
</exception-sorter-class-name>
<metadata>
<type-mapping>Oracle9i</type-mapping>
</metadata>
</local-tx-datasource>
</datasources>
After selecting one of my sources in Crystal Reports
this is what happens
Has anyone had any success with jndi datasource for design time ? I haven't be able to find any example of JNDI connectivity, can anyone provide me with one ? All I've found on community site are examples of replacing jdbc connection with jndi connection during runtime. This is not acceptable for my purpose, because I need the data available for preview during design time.
Is there any other connectivity I can use ? (data available for preview, hidden db credentials)
Hi Greg,
While in the Report Designer click on the F1 or Help key and then search on JNDI, it will explain how to configure the various parts.
Thank you
Don
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
84 | |
10 | |
10 | |
10 | |
7 | |
6 | |
6 | |
5 | |
4 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.