Error while trying to get data out of SQL-Server

[c_moeller]

Hello everybody,

I developed a GUI using Java to enter some data into a SQL-Database using Netbeans 6.5. When opening the project with Netbeans 6.7.1, the connection will be established, however my SELECT-statements are not being executed, the SQL-Exception tells me there is a syntax-error near '?' - but there is no questionmark in the select-statement I create.
Reopening and running with Netbeans 6.5 everything works fine. What's the solution to this problem?

Thanks for every help - and please apologize my bad English...
Christian

[ChristianFilippi]

I suggest to try to print out your query and check it carefully.

[c_moeller]

This is the java-code:

rs = stmt.executeQuery(("SELECT Nr, Kürzel, Kfz1 from LehrerTable order by Nr"));

Running under Netbeans 6.5 everything is fine, running with Netbeans 6.7.1 I get this Exception:

java.sql.SQLException: [Microsoft][ODBC SQL Server Driver][SQL Server]Falsche Syntax in der N?he von '?'.
at sun.jdbc.odbc.JdbcOdbc.standardError(JdbcOdbc.java:7114)
at sun.jdbc.odbc.JdbcOdbc.SQLExecDirect(JdbcOdbc.java:3110)
at sun.jdbc.odbc.JdbcOdbcStatement.execute(JdbcOdbcStatement.java:338)
at sun.jdbc.odbc.JdbcOdbcStatement.executeQuery(JdbcOdbcStatement.java:253)
at zisch.Start.kollegenEinlesen(ZISCHView.java:2018)
at zisch.Start.doInBackground(ZISCHView.java:1582)
at zisch.Start.doInBackground(ZISCHView.java:1562)
at javax.swing.SwingWorker$1.call(SwingWorker.java:278)
at java.util.concurrent.FutureTask$Sync.innerRun(FutureTask.java:303)
at java.util.concurrent.FutureTask.run(FutureTask.java:138)
at javax.swing.SwingWorker.run(SwingWorker.java:317)
at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoolExecutor.java:886)
at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:908)
at java.lang.Thread.run(Thread.java:619)

"Falsche Syntax in der N?he von '?'." means syntax-error near by '?'. But there is no '?' in my request.

[Andy Knight]

Letter

[ChristianFilippi]

I'm not sure, but i think that is better to pay attention to case sensitive keywords

original:

[Andy Knight]

In the Sources category of your Project's properties, change the
Encoding to ISO-8859-1

Andy Knight
Principal Engineer,
Sun Microsystems, Inc.
Java House, Guillemont Park, Minley Road,
Camberley, Surrey GU17 9QG United Kingdom
Home office: +44 1494 462438
Mobile: +44 7775 583415
Skype: aprknight
Email: address-removed
Blog: http://blogs.sun.com/andky

On 1 Oct 2009, at 12:53, c_moeller wrote: