JNDI connectivity

[Former Member]

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)

[former_member11696]

Hi Greg,

Please read the rules of engagement, DO NOT post the same question in multiple forums.

I answered your question in the Db Connectivity forum

Thank you

Don

[Former Member]

Hi Greg,

Connectivity issues are answered by Crystal Reports-Data Connectivity forum members. Please move this thread or repost to:  http://scn.sap.com/community/crystal-reports/data-connectivity

Also, if you are looking for database / database credentials abstraction then a wrapper such as WCF Data Services (.NET 4.0 framework) could be a better option.

WCF data services will create a common platform that can be used by any application apart from just Crystal Reports.

Thanks,

Prathamesh