sql « ODBC « Java Database Q&A





1. Prevent jdbc from padding strings on sql insert and update    stackoverflow.com

We are using the jdbc-odbc bridge to connect to an MS SQL database. When perform inserts or updates, strings are put into the database padded to the length of the ...

2. String to Integer with JDBC /ODBC sql     stackoverflow.com

I am facing severe problem with JDBC ,converting string to integer.

String query = "Select F2, F3, F4 from myTable ORDER BY {fn  CONVERT(INT,F4)}" ;
error: Syntax error in ORDER By ...

3. [Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified - works fine in IDE - not once exported    stackoverflow.com

I am developing a Java app (with ODBC bridge - forgive me - the only paradox driver I have been able to obtain is the Microsoft ODBC driver) which works fine ...

4. FileMaker Pro 10 - ODBC/JDBC - Query Parse Error that doesn't make sense    stackoverflow.com

I'm trying to run this simple query over a JDBC connection:

select _fk_DeptBillTo from WorkOrder
And I'm getting back this error:
 09:31:39  [SELECT - 0 row(s), 0.000 secs]  [Error Code: -201, ...

5. How to get lotus db column names for a view using ODBC    stackoverflow.com

I currently have an ODBC connection setup to a lotus notes db using the NotesSQL Driver which is used to create reports in Cognos BI 8.4. I need to query for the ...