Welcome to the Java Programming Forums


The professional, friendly Java community. 21,500 members and growing!


The Java Programming Forums are a community of Java programmers from all around the World. Our members have a wide range of skills and they all have one thing in common: A passion to learn and code Java. We invite beginner Java programmers right through to Java professionals to post here and share your knowledge. Become a part of the community, help others, expand your knowledge of Java and enjoy talking with like minded people. Registration is quick and best of all free. We look forward to meeting you.


>> REGISTER NOW TO START POSTING


Members have full access to the forums. Advertisements are removed for registered users.

Results 1 to 7 of 7

Thread: Receiving java.lang.RuntimeException error.

  1. #1
    Junior Member
    Join Date
    Oct 2017
    Posts
    4
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Exclamation Receiving java.lang.RuntimeException error.

    Hello everyone,

    I am part of the IT team for a medium sized company. We use an online based payroll management service called Unifocus. However a lot of times we will receive error messages on login and I am not sure how to combat them. The most recent one is "java.lang.runtimeException: incorrect syntax near ")". All of the user permissions are set up properly(I think) and I am not sure where to go from here. Any ideas or help would be greatly appreciated.


    Thanks

    John

  2. #2
    Member
    Join Date
    Apr 2014
    Posts
    93
    Thanks
    3
    Thanked 7 Times in 7 Posts

    Default Re: Receiving java.lang.RuntimeException error.

    Hi,

    That error appears to be coming from the database engine. If so, there may be character data in some of the fields which it doesn't like (newline characters, "smart" quotes, etc). It's trying to use the field value to build a query, but the illegal characters are resulting in a bad SQL statement. Did someone copy/paste from a web page, email, Word document, or any other rich text document when adding or editing values in the database? See this page for an example of what can happen:

    https://blogs.msdn.microsoft.com/old...25-00/?p=19033

  3. #3
    Junior Member
    Join Date
    Oct 2017
    Posts
    4
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Default Re: Receiving java.lang.RuntimeException error.

    Quote Originally Posted by BinaryDigit09 View Post
    Hi,

    That error appears to be coming from the database engine. If so, there may be character data in some of the fields which it doesn't like (newline characters, "smart" quotes, etc). It's trying to use the field value to build a query, but the illegal characters are resulting in a bad SQL statement. Did someone copy/paste from a web page, email, Word document, or any other rich text document when adding or editing values in the database? See this page for an example of what can happen:

    https://blogs.msdn.microsoft.com/old...25-00/?p=19033
    I don't believe anyone changed anything in any of the files Java downloaded automatically to the PC when he originally logged in. Is there a specific file I should be trying to edit, or perhaps just uninstalling and reinstalling java will fix it? I'm totally lost with this as I am not a programmer.

  4. #4
    Member
    Join Date
    Aug 2017
    Location
    Northern Ireland
    Posts
    59
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Default Re: Receiving java.lang.RuntimeException error.

    I'd recommend getting hold of the support team for that Unifocus product. They will likely be able to help you analyse the problem, seeing as it's their application.

    I agree with BinaryDigit09 that the root of the problem lies with some mis-formed SQL statement but that's not something you'll easily be able to solve without knowledge of the inner workings of the system.
    Tim Driven Development

  5. #5
    Junior Member
    Join Date
    Oct 2017
    Posts
    4
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Default Re: Receiving java.lang.RuntimeException error.

    Quote Originally Posted by trcooke View Post
    I'd recommend getting hold of the support team for that Unifocus product. They will likely be able to help you analyse the problem, seeing as it's their application.

    I agree with BinaryDigit09 that the root of the problem lies with some mis-formed SQL statement but that's not something you'll easily be able to solve without knowledge of the inner workings of the system.
    Thanks for the response. After reaching out to the support team they told me it is a "permissions issue" and that they can't troubleshoot that so it's really been no help what so ever. Any other ideas?

  6. #6
    Member
    Join Date
    Aug 2017
    Location
    Northern Ireland
    Posts
    59
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Default Re: Receiving java.lang.RuntimeException error.

    And you're going to accept that as their response? I'd recommend pushing them for better than that.
    Tim Driven Development

  7. #7
    Junior Member
    Join Date
    Oct 2017
    Posts
    4
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Default Re: Receiving java.lang.RuntimeException error.

    Quote Originally Posted by trcooke View Post
    And you're going to accept that as their response? I'd recommend pushing them for better than that.
    No, but I am still waiting on a response from the rep.

Similar Threads

  1. java.lang.ArrayIndexOutOfBoundsException error
    By incxx in forum What's Wrong With My Code?
    Replies: 4
    Last Post: October 30th, 2013, 04:45 PM
  2. Error message java.lang.ArrayIndexOutOfBoundsException: 0
    By EDale in forum What's Wrong With My Code?
    Replies: 7
    Last Post: March 27th, 2013, 08:16 PM
  3. Replies: 1
    Last Post: March 21st, 2011, 09:01 AM
  4. java.lang.numberformatexception error
    By natalie in forum What's Wrong With My Code?
    Replies: 3
    Last Post: February 19th, 2010, 04:16 AM
  5. Replies: 2
    Last Post: November 3rd, 2009, 06:28 AM