Razorsql dynamodb driver#
Export Tool: Added an option to not halt on errors when exporting multiple tablesAdded UCanAccess JDBC driver supportAllow user to change the location of the built in databaseCommand Line Interface all to pass all information to connect to the databaseon the command lineExample:java -Xms64M -Xmx1200M -jar razorsql.jar -export "jdbc:mysql://192.168.1.11:3307/sample?noDatetimeStringSync=true||/Users/user/Library/RazorSQL/mysql/mysql-connector-java-5.0.8-bin.jar|testuser|testpass" "select * from department" csv "/Users/user/Desktop/export.txt" NO NO NO "DEFAULT" "DEFAULT"Upgraded internal database from HSQLDB 1.8 to HSQLDB 2.3Database conversion: When converting from a database with default upper caseto a database with default lower case or vice versa, no longer wrap generatedcolumn names in quotes if they are not in the default casePostgreSQL function names not displaying in the database browserfor certain PostgreSQL databasesDynamoDB: Errors occur if attributes are not present near the beginningof the table, but do have values later in the tableQuery scheduler does not work with SalesforceGenerate SQL from query results with table name witha space not generating correct SQLSalesforce - unable to query Case table due to SQL syntax errorDatabase Conversion: Boolean types getting converted to Oracle failing on insert
DynamoDB: Enhanced logic to determine when to execute a query request and when to execute a scanrequest when query or scan is not indicated in select queryDynamoDB: added support for in clauses in SQL statementsDynamoDB: Import Tool: Added a checkbox for skipping columns / attributes in generatedinserts when the value is null / emptyAdded ability to set connection properties when using the MS SQL Server JDBC driver from MicrosoftDynamoDB: support beginning comments in queriesDynamoDB: A non-descriptive error is thrown when referencing an attribute in an SQLstatement that does not exist in the tableIf SQL Server jtds connection fails for SSL reasons, and MS SQL Server driver is installed,try connecting with the SQL Server driverChanged the formatting of the query error text to handle line wrapping betterFaster scroll speed on Explain Plan windowIf result columns are moved and put back in the same place - results editor throws errorpreventing changes due to columns being re-arrangedPostgreSQL: editing views taking a long time in certain situationsQuery Builder: add table button window appearing behind the query builder on MacQuery results edit table button not always appearing for supported queries when the querieshave comments in them DynamoDB: Added ability to force a query or scan operation using the select_query or select_scansyntax instead of just selectselect_query * from employee where id = 1DynamoDB: Added ability to specify an index to use for a query operation using a query hintselect_query /*index_name*/ * from table_name where.
Razorsql dynamodb windows#
Added support for the Cassandra databaseAdded an Edit -> Delete Lines Containing optionSalesforce: Added the ability to connect to a Salesforce sandbox environmentFunction Navigator / Function Selector: Now shows both procedures and functionsin Oracle PL/SQL packagesQuery Scheduler: Added option to set start timein seconds from current timeQuery Scheduler: Added option to set the title of the query schedulerwindowQuery Scheduler: Added option to determine whether to overwriteor append to the output file if it already existsQuery Scheduler: Added option to load query text from a fileQuery Scheduler: Added option to load query text from the SQL favorites listQuery Scheduler: Added file name, interval, executions, and query tostatus field of query scheduler windowContinue should be the default button on the Add Connection Wizard screenAdded additional error notifications for the Export toolIf a maximum rows value is set in the preferences, that valuewill get set on the JDBC driver's statement object for each querySalesforce: Using TableName.ColumnName syntax in queries returns nullvaluesSalesforce: Relationship queries using join tables via dot notation columns(example: ) returning nullvalues for columns from the joined tablesSalesforce queries not always returning rows above initial salesforcerequest limitsMac 64-bit: Various focus issues where windows / dialogs are not gettingfocus when appearing
0 kommentar(er)
