Skip to Content
avatar image
Former Member

New JDBC Connection issue

Hi All,

I was able to add my new JDBC connection with no problems but I think I left something out. Here's the issue:

I can access the database until I try to put in a where clause or filter. When I look at Show Query, I should see thisin my where clause:

AND "tickets"."ticket_type"='IM'

I get this:

AND "tickets"."ticket_type"=N'IM'

I didn't put that into the select expert criteria so I'm not sure how it is being added into the query. Anyone have any ideas?

Thanks in advance,

Sandie

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

2 Answers

  • avatar image
    Former Member
    Sep 29, 2008 at 08:52 PM

    Hi there,

    There are a couple of things that were not indicated in your question

    1. What kind of database are you using?

    2. What version of Java are you using?

    As for suggestions, what happens if you use a Command Object to explicitly state the SQL that you would like to use? Does it illustrate the same behavior?

    Add comment
    10|10000 characters needed characters exceeded

  • Nov 05, 2009 at 09:47 PM

    Please re-post if this is still an issue to the Data Connectivity - Crystal Reports Forum or purchase a case and have a dedicated support engineer work with you directly

    Add comment
    10|10000 characters needed characters exceeded