title: Jaybird 3 and default codepage via properties
body: <p>I continue to dig (or play) with jaybird 3 and got known error "Caused by: java.sql.SQLNonTransientConnectionException: Connection rejected: No connection character set specified (property lc_ctype, encoding, charSet or localEncoding). Please specify a connection character set (eg property charSet=utf-8) or consult the Jaybird documentation for more information."</p>
  
  <p>So, please help me what I do wrong and what I must to do.</p>
  
  <ol>
  <li><p>First try</p>
  
  <pre><code>final Connection conn = DriverManager.getConnection(
          "jdbc:firebirdsql:localhost/3050:g:\\Databases\\EMPLOYEE255.FDB?lc_ctype=utf8",
          "sysdba",
          "masterkey"
  );
  </code></pre>
  
  <p>That works fine. But what if I do not want (or cant) change the connection string?</p></li>
  <li><p>As I see in faq: <a href="https://www.firebirdsql.org/file/documentation/drivers_documentation/java/faq.html" rel="nofollow noreferrer">https://www.firebirdsql.org/file/documentation/drivers_documentation/java/faq.html</a> I run my java application (from netbeans) with option       </p>
  
  <pre><code>-Dorg.firebirdsql.jdbc.defaultConnectionEncoding=NONE
  </code></pre></li>
  </ol>
  
  <p>but got same error. So ok. May be I do something wrong here in netbeans...</p>
  
  <ol start="3">
  <li><p>I try to use connection options via Properties. So. I change my code:</p>
  
  <pre><code>public DataSource createDataSource(){
      final DriverManagerDataSource ds = new DriverManagerDataSource();
      ds.setDriverClassName( "org.firebirdsql.jdbc.FBDriver" );
      ds.setUrl( getConnectionURL( )); //here no appended "?lc_type...."
      ds.setUsername( getLogin() );
      ds.setPassword( getPassword() );
      //from here---&gt;
      Properties pr = new Properties();
      pr.setProperty("lc_ctype", "utf8");
      ds.setConnectionProperties(pr);
      //&lt;---to here
      return ds;
  }
  </code></pre></li>
  </ol>
  
  <p>Run application - and got same error.... I can't pass "lc_ctype" from property? Or I did not understand something?</p>