gmane.comp.lang.jruby.extras.devel

[ jruby-extras-Bugs-29237 ] massive "WARNING:nonstandard use of \ in a string literal at character"entries in postgresql server log

2011-05-30T19:26:58

Bugs item #29237, was opened at 2011-05-30 21:26
You can respond by visiting: 
http://rubyforge.org/tracker/?func=detail&atid=7857&aid=29237&group_id=2014

Category: AR-JDBC
Group: None
Status: Open
Resolution: None
Priority: 3
Submitted By: Xuân Baldauf (mediumnet)
Assigned to: Nobody (None)
Summary: massive "WARNING:  nonstandard use of \ in a string literal at character" entries in postgresql server log

Initial Comment:
When effectively using the arjdbc postgresql adapter's escape_bytea() or maybe also quote_string() method, postgresql complains like this:

WARNING:  nonstandard use of \ in a string literal at character 798
HINT:  Use the escape string syntax for backslashes, e.g., E'\'.


These complaints could be turned off, however, then many other relevant log entries of the postgresql log file would also be turned off, too.

The solution is to properly use postgresql's escape mechanisms, e.g. http://www.postgresql.org/docs/9.0/static/datatype-binary.html#AEN5037 or http://www.postgresql.org/docs/9.0/static/datatype-binary.html#AEN5046 for bytea-data or just as postgresql itself suggests the E''-string escape format.


----------------------------------------------------------------------

You can respond by visiting: 
http://rubyforge.org/tracker/?func=detail&atid=7857&aid=29237&group_id=2014
_______________________________________________
Jruby-extras-devel mailing list
Jruby-extras-devel< at >rubyforge.org
http://rubyforge.org/mailman/listinfo/jruby-extras-devel

activerecord-jdbcmssql-adapter

Justin Kay — 2010-05-14T16:03:13

I just installed the AR jdbcmssql adapter for use on a rails app that connects to a MS Sql server 2000.  I am having issues with Object.first.  I'm getting an error about ROW_NUMBER not being a recognized as a valid function name.  I found this patch http://permalink.gmane.org/gmane.comp.lang.jruby.extras.devel/1049.  My question is can I specify that I'm using sql server 2000 somehow?

Justin

[ jruby-extras-Bugs-18604 ] activerecord-jdbcdoes not handle schemaname.tablename naming construct with mysql

2010-05-13T14:03:54

Bugs item #18604, was opened at 2008-03-04 22:05
You can respond by visiting: 
http://rubyforge.org/tracker/?func=detail&atid=7857&aid=18604&group_id=2014

Category: AR-JDBC
Group: 0.2.3
Status: Closed
Resolution: None
Priority: 3
Submitted By: Greg Orlowski (gregorlowski)
Assigned to: Nobody (None)
Summary: activerecord-jdbc does not handle schemaname.tablename naming construct with mysql

Initial Comment:
In rails with MRI + MySQL, we are able to use the following construct for setting table names in our model classes:

set_table_name "#{databasename}.tablename"

where databasename represents a MySQL database (schema). We need to do this because our app spans multiple databases (legacy db), and different model classes reference different schemas (effectively databases in MySQL).

In JRuby with activerecord-jdbcmysql-adapter-0.7.2, (warbler deployed on tomcat), we get the error (as a rails error page):

Table databasename. does not exist

(where databasename is the name of our dbschema).

I confirmed that if I remove the schema name, I can run a subset of our app with the model classes that use the schema named as the default schema in database.yml (in the database: section).

Rails version: 1.2.6

Gems Versions:
activerecord-jdbc-adapter-0.7.2
activerecord-jdbcmysql-adapter-0.7.2

Jars:
mysql-connector-java-5.0.4-bin.jar
jruby-complete-1.1RC2.jar
goldspike-1.5.jar

database.yml

development:
  adapter: jdbcmysql
  database: ourdbname
  username: ouruser
  password: ourpass
  host: 127.0.0.1


I do have this in my environment.rb:

if RUBY_PLATFORM =~ /java/
   require 'rubygems'
   RAILS_CONNECTION_ADAPTERS = %w(jdbcmysql)
   require 'active_record'
   gem 'activerecord-jdbcmysql-adapter'
   require 'active_record/connection_adapters/jdbcmysql_adapter'
end

----------------------------------------------------------------------

Date: 2010-05-13 09:03

Message:
Whoops, didn't mean to use the canned message. Meant to say that I think this is fixed now:

http://kenai.com/jira/browse/ACTIVERECORD_JDBC-116

----------------------------------------------------------------------

Comment By: Nick Sieger (nicksieger)
Date: 2010-05-13 09:03

Message:
Hi, we no longer use this tracker to track bugs here. Can you
please file a copy of this bug at
http://kenai.com/jira/browse/ACTIVERECORD_JDBC ?

Thanks!


----------------------------------------------------------------------

Comment By: Dilshod Mukhtarov (dilshodm)
Date: 2010-03-07 04:29

Message:
I faced same problem with activerecord-jdbc-adapter-0.9.3
The following is a patch that solves problem.

diff -Nru activerecord-jdbc-adapter-0.9.3/src/java/jdbc_adapter/RubyJdbcConnection.java activerecord-jdbc-adapter-0.9.3.new/src/java/jdbc_adapter/RubyJdbcConnection.java
--- activerecord-jdbc-adapter-0.9.3/src/java/jdbc_adapter/RubyJdbcConnection.java2009-10-26 23:25:01.000000000 +0300
+++ activerecord-jdbc-adapter-0.9.3.new/src/java/jdbc_adapter/RubyJdbcConnection.java2010-03-07 10:35:12.000000000 +0300
< at >< at > -135,14 +135,17 < at >< at >
                     if (schemaName != null) schemaName = caseConvertIdentifierForJdbc(metadata, schemaName);
                     table_name = caseConvertIdentifierForJdbc(metadata, table_name);
 
+                    String catalog = c.getCatalog();
+                    if (schemaName != null) { catalog = schemaName; }
+
                     String[] tableTypes = new String[]{"TABLE","VIEW","SYNONYM"};
                     RubyArray matchingTables = (RubyArray) tableLookupBlock(context.getRuntime(),
-                            c.getCatalog(), schemaName, table_name, tableTypes, false).call(c);
+                            catalog, schemaName, table_name, tableTypes, false).call(c);
                     if (matchingTables.isEmpty()) {
                         throw new SQLException("Table " + table_name + " does not exist");
                     }
 
-                    results = metadata.getColumns(c.getCatalog(),schemaName,table_name,null);
+                    results = metadata.getColumns(catalog,schemaName,table_name,null);
                     return unmarshal_columns(context, metadata, results);
                 } finally {
                     close(results); 

----------------------------------------------------------------------

You can respond by visiting: 
http://rubyforge.org/tracker/?func=detail&atid=7857&aid=18604&group_id=2014

[ jruby-extras-Bugs-18604 ] activerecord-jdbcdoes not handle schemaname.tablename naming construct with mysql

2010-05-13T14:03:18

Bugs item #18604, was opened at 2008-03-04 22:05
You can respond by visiting: 
http://rubyforge.org/tracker/?func=detail&atid=7857&aid=18604&group_id=2014

Category: AR-JDBC
Group: 0.2.3
Resolution: None
Priority: 3
Submitted By: Greg Orlowski (gregorlowski)
Assigned to: Nobody (None)
Summary: activerecord-jdbc does not handle schemaname.tablename naming construct with mysql

Initial Comment:
In rails with MRI + MySQL, we are able to use the following construct for setting table names in our model classes:

set_table_name "#{databasename}.tablename"

where databasename represents a MySQL database (schema). We need to do this because our app spans multiple databases (legacy db), and different model classes reference different schemas (effectively databases in MySQL).

In JRuby with activerecord-jdbcmysql-adapter-0.7.2, (warbler deployed on tomcat), we get the error (as a rails error page):

Table databasename. does not exist

(where databasename is the name of our dbschema).

I confirmed that if I remove the schema name, I can run a subset of our app with the model classes that use the schema named as the default schema in database.yml (in the database: section).

Rails version: 1.2.6

Gems Versions:
activerecord-jdbc-adapter-0.7.2
activerecord-jdbcmysql-adapter-0.7.2

Jars:
mysql-connector-java-5.0.4-bin.jar
jruby-complete-1.1RC2.jar
goldspike-1.5.jar

database.yml

development:
  adapter: jdbcmysql
  database: ourdbname
  username: ouruser
  password: ourpass
  host: 127.0.0.1


I do have this in my environment.rb:

if RUBY_PLATFORM =~ /java/
   require 'rubygems'
   RAILS_CONNECTION_ADAPTERS = %w(jdbcmysql)
   require 'active_record'
   gem 'activerecord-jdbcmysql-adapter'
   require 'active_record/connection_adapters/jdbcmysql_adapter'
end

----------------------------------------------------------------------

Comment By: Nick Sieger (nicksieger)
Date: 2010-05-13 09:03

Message:
Hi, we no longer use this tracker to track bugs here. Can you
please file a copy of this bug at
http://kenai.com/jira/browse/ACTIVERECORD_JDBC ?

Thanks!


----------------------------------------------------------------------

Comment By: Dilshod Mukhtarov (dilshodm)
Date: 2010-03-07 04:29

Message:
I faced same problem with activerecord-jdbc-adapter-0.9.3
The following is a patch that solves problem.

diff -Nru activerecord-jdbc-adapter-0.9.3/src/java/jdbc_adapter/RubyJdbcConnection.java activerecord-jdbc-adapter-0.9.3.new/src/java/jdbc_adapter/RubyJdbcConnection.java
--- activerecord-jdbc-adapter-0.9.3/src/java/jdbc_adapter/RubyJdbcConnection.java2009-10-26 23:25:01.000000000 +0300
+++ activerecord-jdbc-adapter-0.9.3.new/src/java/jdbc_adapter/RubyJdbcConnection.java2010-03-07 10:35:12.000000000 +0300
< at >< at > -135,14 +135,17 < at >< at >
                     if (schemaName != null) schemaName = caseConvertIdentifierForJdbc(metadata, schemaName);
                     table_name = caseConvertIdentifierForJdbc(metadata, table_name);
 
+                    String catalog = c.getCatalog();
+                    if (schemaName != null) { catalog = schemaName; }
+
                     String[] tableTypes = new String[]{"TABLE","VIEW","SYNONYM"};
                     RubyArray matchingTables = (RubyArray) tableLookupBlock(context.getRuntime(),
-                            c.getCatalog(), schemaName, table_name, tableTypes, false).call(c);
+                            catalog, schemaName, table_name, tableTypes, false).call(c);
                     if (matchingTables.isEmpty()) {
                         throw new SQLException("Table " + table_name + " does not exist");
                     }
 
-                    results = metadata.getColumns(c.getCatalog(),schemaName,table_name,null);
+                    results = metadata.getColumns(catalog,schemaName,table_name,null);
                     return unmarshal_columns(context, metadata, results);
                 } finally {
                     close(results); 

----------------------------------------------------------------------

You can respond by visiting: 
http://rubyforge.org/tracker/?func=detail&atid=7857&aid=18604&group_id=2014

[ jruby-extras-Bugs-27921 ] Error: caused byundefined method `jdbc_oracle_insert' for class`ActiveRecord::ConnectionAdapters::JdbcAdapter'

2010-03-12T00:28:17

Bugs item #27921, was opened at 2010-03-03 21:30
You can respond by visiting: 
http://rubyforge.org/tracker/?func=detail&atid=7857&aid=27921&group_id=2014

Category: AR-JDBC
Group: None
Status: Open
Resolution: None
Priority: 3
Submitted By: Mathew Duafala (mduafala)
Assigned to: Nobody (None)
Summary: Error: caused by undefined method `jdbc_oracle_insert' for class `ActiveRecord::ConnectionAdapters::JdbcAdapter'

Initial Comment:
0.9.3 appears to be broken for oracle connections (We're using rails 2.2.2 and jruby)

Error: caused by undefined method `jdbc_oracle_insert' for class `ActiveRecord::ConnectionAdapters::JdbcAdapter'
      /local/home/xncore/deploy/97/jetty/webapps/root/WEB-INF/gems/gems/activerecord-jdbc-adapter-0.9.3-java/lib/active_record/connection_adapters/jdbc_adapter.rb:197:in `alias_chained_method'
/local/home/xncore/deploy/97/jetty/webapps/root/WEB-INF/gems/gems/activerecord-jdbc-adapter-0.9.3-java/lib/jdbc_adapter/jdbc_oracle.rb:30:in `extended'
/local/home/xncore/deploy/97/jetty/webapps/root/WEB-INF/gems/gems/activerecord-jdbc-adapter-0.9.3-java/lib/jdbc_adapter/jdbc_oracle.rb:29:in `class_eval'
/local/home/xncore/deploy/97/jetty/webapps/root/WEB-INF/gems/gems/activerecord-jdbc-adapter-0.9.3-java/lib/jdbc_adapter/jdbc_oracle.rb:29:in `extended'
/local/home/xncore/deploy/97/jetty/webapps/root/WEB-INF/gems/gems/activerecord-jdbc-adapter-0.9.3-java/lib/active_record/connection_adapters/jdbc_adapter.rb:461:in `initialize'
/local/home/xncore/deploy/97/jetty/webapps/root/WEB-INF/gems/gems/activerecord-jdbc-adapter-0.9.3-java/lib/active_record/connection_adapters/jdbc_adapter.rb:49:in `new'
/local/home/xncore/deploy/97/jetty/webapps/root/WEB-INF/gems/gems/activerecord-jdbc-adapter-0.9.3-java/lib/active_record/connection_adapters/jdbc_adapter.rb:49:in `jdbc_connection'
/local/home/xncore/deploy/97/jetty/webapps/root/WEB-INF/gems/gems/activerecord-jdbc-adapter-0.9.3-java/lib/jdbc_adapter/jdbc_oracle.rb:7:in `oracle_connection'

----------------------------------------------------------------------

Date: 2010-03-12 00:28

Message:
I have upgraded to rails 2.3.4 and the problem persists.  
The workaround for now was to fix the versions of the two 
gems in question in my warble.rb config

  config.gems << Gem::Dependency.new("activerecord-
jdbc-adapter", " = 0.9.2")
  config.gems << Gem::Dependency.new("activerecord-
jdbcmysql-adapter", " = 0.9.2") 

----------------------------------------------------------------------

You can respond by visiting: 
http://rubyforge.org/tracker/?func=detail&atid=7857&aid=27921&group_id=2014

[ jruby-extras-Bugs-18604 ] activerecord-jdbcdoes not handle schemaname.tablename naming construct with mysql

2010-03-07T10:29:00

Bugs item #18604, was opened at 2008-03-05 07:05
You can respond by visiting: 
http://rubyforge.org/tracker/?func=detail&atid=7857&aid=18604&group_id=2014

Category: AR-JDBC
Group: 0.2.3
Status: Open
Resolution: None
Priority: 3
Submitted By: Greg Orlowski (gregorlowski)
Assigned to: Nobody (None)
Summary: activerecord-jdbc does not handle schemaname.tablename naming construct with mysql

Initial Comment:
In rails with MRI + MySQL, we are able to use the following construct for setting table names in our model classes:

set_table_name "#{databasename}.tablename"

where databasename represents a MySQL database (schema). We need to do this because our app spans multiple databases (legacy db), and different model classes reference different schemas (effectively databases in MySQL).

In JRuby with activerecord-jdbcmysql-adapter-0.7.2, (warbler deployed on tomcat), we get the error (as a rails error page):

Table databasename. does not exist

(where databasename is the name of our dbschema).

I confirmed that if I remove the schema name, I can run a subset of our app with the model classes that use the schema named as the default schema in database.yml (in the database: section).

Rails version: 1.2.6

Gems Versions:
activerecord-jdbc-adapter-0.7.2
activerecord-jdbcmysql-adapter-0.7.2

Jars:
mysql-connector-java-5.0.4-bin.jar
jruby-complete-1.1RC2.jar
goldspike-1.5.jar

database.yml

development:
  adapter: jdbcmysql
  database: ourdbname
  username: ouruser
  password: ourpass
  host: 127.0.0.1


I do have this in my environment.rb:

if RUBY_PLATFORM =~ /java/
   require 'rubygems'
   RAILS_CONNECTION_ADAPTERS = %w(jdbcmysql)
   require 'active_record'
   gem 'activerecord-jdbcmysql-adapter'
   require 'active_record/connection_adapters/jdbcmysql_adapter'
end

----------------------------------------------------------------------

Comment By: Dilshod Mukhtarov (dilshodm)
Date: 2010-03-07 13:29

Message:
I faced same problem with activerecord-jdbc-adapter-0.9.3
The following is a patch that solves problem.

diff -Nru activerecord-jdbc-adapter-0.9.3/src/java/jdbc_adapter/RubyJdbcConnection.java activerecord-jdbc-adapter-0.9.3.new/src/java/jdbc_adapter/RubyJdbcConnection.java
--- activerecord-jdbc-adapter-0.9.3/src/java/jdbc_adapter/RubyJdbcConnection.java2009-10-26 23:25:01.000000000 +0300
+++ activerecord-jdbc-adapter-0.9.3.new/src/java/jdbc_adapter/RubyJdbcConnection.java2010-03-07 10:35:12.000000000 +0300
< at >< at > -135,14 +135,17 < at >< at >
                     if (schemaName != null) schemaName = caseConvertIdentifierForJdbc(metadata, schemaName);
                     table_name = caseConvertIdentifierForJdbc(metadata, table_name);
 
+                    String catalog = c.getCatalog();
+                    if (schemaName != null) { catalog = schemaName; }
+
                     String[] tableTypes = new String[]{"TABLE","VIEW","SYNONYM"};
                     RubyArray matchingTables = (RubyArray) tableLookupBlock(context.getRuntime(),
-                            c.getCatalog(), schemaName, table_name, tableTypes, false).call(c);
+                            catalog, schemaName, table_name, tableTypes, false).call(c);
                     if (matchingTables.isEmpty()) {
                         throw new SQLException("Table " + table_name + " does not exist");
                     }
 
-                    results = metadata.getColumns(c.getCatalog(),schemaName,table_name,null);
+                    results = metadata.getColumns(catalog,schemaName,table_name,null);
                     return unmarshal_columns(context, metadata, results);
                 } finally {
                     close(results); 

----------------------------------------------------------------------

You can respond by visiting: 
http://rubyforge.org/tracker/?func=detail&atid=7857&aid=18604&group_id=2014

[ jruby-extras-Bugs-27921 ] Error: caused byundefined method `jdbc_oracle_insert' for class`ActiveRecord::ConnectionAdapters::JdbcAdapter'

2010-03-03T21:30:30

Bugs item #27921, was opened at 2010-03-03 21:30
You can respond by visiting: 
http://rubyforge.org/tracker/?func=detail&atid=7857&aid=27921&group_id=2014

Category: AR-JDBC
Group: None
Status: Open
Resolution: None
Priority: 3
Submitted By: Mathew Duafala (mduafala)
Assigned to: Nobody (None)
Summary: Error: caused by undefined method `jdbc_oracle_insert' for class `ActiveRecord::ConnectionAdapters::JdbcAdapter'

Initial Comment:
0.9.3 appears to be broken for oracle connections (We're using rails 2.2.2 and jruby)

Error: caused by undefined method `jdbc_oracle_insert' for class `ActiveRecord::ConnectionAdapters::JdbcAdapter'
      /local/home/xncore/deploy/97/jetty/webapps/root/WEB-INF/gems/gems/activerecord-jdbc-adapter-0.9.3-java/lib/active_record/connection_adapters/jdbc_adapter.rb:197:in `alias_chained_method'
/local/home/xncore/deploy/97/jetty/webapps/root/WEB-INF/gems/gems/activerecord-jdbc-adapter-0.9.3-java/lib/jdbc_adapter/jdbc_oracle.rb:30:in `extended'
/local/home/xncore/deploy/97/jetty/webapps/root/WEB-INF/gems/gems/activerecord-jdbc-adapter-0.9.3-java/lib/jdbc_adapter/jdbc_oracle.rb:29:in `class_eval'
/local/home/xncore/deploy/97/jetty/webapps/root/WEB-INF/gems/gems/activerecord-jdbc-adapter-0.9.3-java/lib/jdbc_adapter/jdbc_oracle.rb:29:in `extended'
/local/home/xncore/deploy/97/jetty/webapps/root/WEB-INF/gems/gems/activerecord-jdbc-adapter-0.9.3-java/lib/active_record/connection_adapters/jdbc_adapter.rb:461:in `initialize'
/local/home/xncore/deploy/97/jetty/webapps/root/WEB-INF/gems/gems/activerecord-jdbc-adapter-0.9.3-java/lib/active_record/connection_adapters/jdbc_adapter.rb:49:in `new'
/local/home/xncore/deploy/97/jetty/webapps/root/WEB-INF/gems/gems/activerecord-jdbc-adapter-0.9.3-java/lib/active_record/connection_adapters/jdbc_adapter.rb:49:in `jdbc_connection'
/local/home/xncore/deploy/97/jetty/webapps/root/WEB-INF/gems/gems/activerecord-jdbc-adapter-0.9.3-java/lib/jdbc_adapter/jdbc_oracle.rb:7:in `oracle_connection'

----------------------------------------------------------------------

You can respond by visiting: 
http://rubyforge.org/tracker/?func=detail&atid=7857&aid=27921&group_id=2014

Re: Easy syntax highlighting of Ruby within aJava editor?

Charles Oliver Nutter — 2010-02-18T08:04:16

2010/2/17 Raphaël Valyi <rvalyi< at >gmail.com>:

That's great...I'm glad you found what you needed!


Sure, I think it would be a great JavaOne topic, though who knows how
many talks will get in and how large the event will actually be. I'd
say you should at least submit it and see what happens.

Got any summary blogs about your work I could tweet?

- Charlie
_______________________________________________
Jruby-extras-devel mailing list
Jruby-extras-devel< at >rubyforge.org
http://rubyforge.org/mailman/listinfo/jruby-extras-devel

Re: Easy syntax highlighting of Ruby within aJava editor?

Raphaël Valyi — 2010-02-18T01:49:10

_______________________________________________
Jruby-extras-devel mailing list
Jruby-extras-devel-GrnCvJ7WPxnNLxjTenLetw< at >public.gmane.org
http://rubyforge.org/mailman/listinfo/jruby-extras-devel

Re: Easy syntax highlighting of Ruby within aJava editor?

Charles Oliver Nutter — 2010-02-13T18:18:57

Well, I'm glad I didn't shut this list down after all :) A real post!!
Comments below...

2010/2/13 Raphaël Valyi <rvalyi< at >gmail.com>:

Sounds like you're on a good track. The 223 interfaces provided
everything you needed?


We'll definitely look forward to that bug report.


You might want to look at RedCar's codebase. RedCar is a Textmate
clone for other platforms which is now based on JRuby. I'm not sure
what parser they're using, or how cleanly componentized the syntax
highlighting logic is, but since it's now JRuby-based, you know it
will work for you.

http://github.com/danlucraft/redcar


That sounds excellent, and it would help focus some attention on
another success story, the RedCar editor. Reuse is good!

- Charlie
_______________________________________________
Jruby-extras-devel mailing list
Jruby-extras-devel< at >rubyforge.org
http://rubyforge.org/mailman/listinfo/jruby-extras-devel

Easy syntax highlighting of Ruby within a Javaeditor?

Raphaël Valyi — 2010-02-13T18:13:56

_______________________________________________
Jruby-extras-devel mailing list
Jruby-extras-devel-GrnCvJ7WPxnNLxjTenLetw< at >public.gmane.org
http://rubyforge.org/mailman/listinfo/jruby-extras-devel

Shutting this list down

Charles Oliver Nutter — 2010-02-11T17:48:46

I'm going to shut this list down. There's no traffic, other than
blocked spam posts I have to ignore, and there's better lists for
JRuby and JRuby-related projects.

- Charlie

[1151] trunk/dbd-jdbc/PROJECT_HAS_MOVED: KenaiI hardly knew ye

2010-01-31T17:06:48

_______________________________________________
Jruby-extras-devel mailing list
Jruby-extras-devel-GrnCvJ7WPxnNLxjTenLetw< at >public.gmane.org
http://rubyforge.org/mailman/listinfo/jruby-extras-devel

[ jruby-extras-Bugs-22018 ]db:test:clone_structure task sends illegal character to Oracle

2010-01-12T19:34:48

Bugs item #22018, was opened at 2008-09-18 22:00
You can respond by visiting: 
http://rubyforge.org/tracker/?func=detail&atid=7857&aid=22018&group_id=2014

Category: AR-JDBC
Group: None
Status: Closed
Resolution: None
Priority: 3
Submitted By: Nigel Ramsay (nigelramsay)
Assigned to: Nobody (None)
Summary: db:test:clone_structure task sends illegal character to Oracle

Initial Comment:
When running "rake db:test:clone_structure", I get the following error:

ActiveRecord::ActiveRecordError: ORA-00911: invalid character:
INSERT INTO schema_migrations (version) VALUES ('20080915031553');

The illegal character that Oracle is complaining about is the trailing semi-colon. The log file shows the preceding statements executing successfully. Note there do not have a tailing semi-colon: 

[...snip]
INSERT INTO schema_migrations (version) VALUES ('20080724033916')
INSERT INTO schema_migrations (version) VALUES ('20080901223816')
INSERT INTO schema_migrations (version) VALUES ('20080903231452')
INSERT INTO schema_migrations (version) VALUES ('20080909235955')
ActiveRecord::ActiveRecordError: ORA-00911: invalid character:
INSERT INTO schema_migrations (version) VALUES ('20080915031553');

The bug appears to originate in the "lib/jdbc_adapter/jdbc.rake" file. The db:test:clone_structure task reads in the development_struture.sql file, and performs a split(";\n\n"). This results in an array of statements, where each statement does not have a trailing semi-colon - EXCEPT for the last statement.

So the last statement is executed, including the trailing semi-colon. And this final statement is the cause of the "ORA-00911: invalid character" error.

This bug can be fixed by ensuring that the final semi-colon is removed before "execute" is called.

----------------------------------------------------------------------

Comment By: Kurt Werle (kwerle)
Date: 2010-01-12 11:34

Message:
It looks to me like this same problem now exists in the standard databases.rake file for Oracle:

      when "oci", "oracle"
        ActiveRecord::Base.establish_connection(:test)
        IO.readlines("#{RAILS_ROOT}/db/#{RAILS_ENV}_structure.sql").join.split(";\n\n").each do |ddl|
          ActiveRecord::Base.connection.execute(ddl)
        end

(rails 2.3.5)

----------------------------------------------------------------------

Comment By: Nick Sieger (nicksieger)
Date: 2008-09-19 05:34

Message:
Thanks for the report, fixed in trunk.

----------------------------------------------------------------------

You can respond by visiting: 
http://rubyforge.org/tracker/?func=detail&atid=7857&aid=22018&group_id=2014

Re: jdbc postgres INSERT RETURNING

Nick Sieger — 2009-11-02T20:19:18

This looks like a PostgreSQL/JDBC issue. Which version of ar-jdbc are
you using? It looks like some code in #insert has been disabled that
is supposed to deal with this issue. I'll have to look into it for the
next release. Would you mind filing a bug [1] with further details?

Thanks,

/Nick

[1]: http://kenai.com/jira/browse/ACTIVERECORD_JDBC

jdbc postgres INSERT RETURNING

Monroe, Grant — 2009-10-30T23:39:41

Running execute with the postgres jdbc driver like so

  def self.up
    execute('INSERT INTO foo (a,b) VALUES (1,2) RETURNING (id)')
  end

results in the following error

    ActiveRecord::ActiveRecordError: A result was returned when none
was expected.: INSERT INTO foo (a,b) VALUES (1,2) RETURNING (id)

Any suggestions?

[ jruby-extras-Bugs-27151 ] Rcov-java bugFix

2009-09-20T17:13:43

Bugs item #27151, was opened at 20/09/2009 17:13
You can respond by visiting: 
http://rubyforge.org/tracker/?func=detail&atid=7857&aid=27151&group_id=2014

Category: None
Group: None
Status: Open
Resolution: None
Priority: 3
Submitted By:   (anoiaque)
Assigned to: Nobody (None)
Summary: Rcov-java bugFix

Initial Comment:
Hey,

First , thanks for rcov for jruby. 
I 've fixed a bug on it ,perhaps it hides a more large problem, but now i get my rcov reports for my jruby app.

Bug : When you lauch rcov($ rcov test/test_*.rb), you get :
rcov.rb:654:in `aggregate_data': NilClass can't be coerced into Fixnum (TypeError)"

An array contains nil values (normal?) , so +=nil give this error

I've fixed it like that :

line 654 : cov_arr.each_with_index{|x,i| dest[i] += x} 
replaced by :  cov_arr.each_with_index{|x,i| dest[i] += x if x }  


About : I work on active-record jdbc adapter for Progress OpenEdge Databases.
The beta version is released. It will be on Kenai Project.
If you are interested in ..

Bye
Best Regards

anoiaque



----------------------------------------------------------------------

You can respond by visiting: 
http://rubyforge.org/tracker/?func=detail&atid=7857&aid=27151&group_id=2014

[ jruby-extras-Bugs-27115 ] NativeExceptionthrown by jruby-ldap when run in a servlet container

2009-09-16T16:53:38

Bugs item #27115, was opened at 2009-09-16 12:53
You can respond by visiting: 
http://rubyforge.org/tracker/?func=detail&atid=7857&aid=27115&group_id=2014

Category: None
Group: None
Status: Open
Resolution: None
Priority: 3
Submitted By: Jesse Rankin (jvr)
Assigned to: Nobody (None)
Summary: NativeException thrown by jruby-ldap when run in a servlet container

Initial Comment:
There is a bug in jruby-ldap that causes a NativeException when connecting if your app is running in a servlet container (tomcat and glassfish at least).  I ran into this problem and eventually found a patch here that resolves the problem:

http://archive.codehaus.org/lists/org.codehaus.jruby.user/msg/4921724F.9060104-a1OEOm8ubKQ< at >public.gmane.org

http://pastie.org/316793

Here is the top of my stack trace on glassfish:

NativeException (javax.naming.NotContextException: Not an instance of DirContext):
  javax/naming/directory/InitialDirContext.java:92:in `getURLOrDefaultInitDirCtx'
  javax/naming/directory/InitialDirContext.java:248:in `search'
  sun/reflect/NativeMethodAccessorImpl.java:-2:in `invoke0'
  sun/reflect/NativeMethodAccessorImpl.java:39:in `invoke'
  sun/reflect/DelegatingMethodAccessorImpl.java:25:in `invoke'
  java/lang/reflect/Method.java:585:in `invoke'
  org/jruby/javasupport/JavaMethod.java:302:in `invokeWithExceptionHandling'
  org/jruby/javasupport/JavaMethod.java:263:in `invoke'
  org/jruby/java/invokers/InstanceMethodInvoker.java:72:in `call'
  org/jruby/runtime/callsite/CachingCallSite.java:318:in `cacheAndCall'
  org/jruby/runtime/callsite/CachingCallSite.java:197:in `call'
  org/jruby/ast/CallThreeArgNode.java:61:in `interpret'
  org/jruby/ast/CallNoArgBlockNode.java:60:in `interpret'
  org/jruby/ast/NewlineNode.java:104:in `interpret'
  org/jruby/ast/BlockNode.java:71:in `interpret'

----------------------------------------------------------------------

You can respond by visiting: 
http://rubyforge.org/tracker/?func=detail&atid=7857&aid=27115&group_id=2014

[ jruby-extras-Bugs-27067 ]validates_uniqueness_of broken

2009-09-08T19:02:38

Bugs item #27067, was opened at 2009-09-08 10:23
You can respond by visiting: 
http://rubyforge.org/tracker/?func=detail&atid=7857&aid=27067&group_id=2014

Category: AR-JDBC
Group: None
Resolution: None
Priority: 3
Submitted By: Michael Hier (tamaloa)
Assigned to: Nobody (None)
Summary: validates_uniqueness_of broken

Initial Comment:
Hope this is the right place :)

Using jRuby and jdbcsqlite3:
Trying to use validates_uniqueness_of :name in a model has no effect at all. It is possible to create and save several records with the same name! Seems as if the constructed sql-queries do not contain the actual field-string.
Example:
A query to a user model with unique :name would look like this
user_one.save
SELECT users.id FROM users WHERE (users.name = '')
INSERT INTO users (name, created_at, updated_at) VALUES('one', '2009-09-08 15:04:00', '2009-09-08 15:04:00')

----------------------------------------------------------------------

Comment By: Nick Sieger (nicksieger)
Date: 2009-09-08 14:02

Message:
Hi, we no longer use this tracker to track bugs here. Can you
please file a copy of this bug at
http://kenai.com/jira/browse/ACTIVERECORD_JDBC ?

Thanks!


----------------------------------------------------------------------

You can respond by visiting: 
http://rubyforge.org/tracker/?func=detail&atid=7857&aid=27067&group_id=2014

[ jruby-extras-Bugs-27067 ]validates_uniqueness_of broken

2009-09-08T15:23:58

Bugs item #27067, was opened at 2009-09-08 15:23
You can respond by visiting: 
http://rubyforge.org/tracker/?func=detail&atid=7857&aid=27067&group_id=2014

Category: AR-JDBC
Group: None
Status: Open
Resolution: None
Priority: 3
Submitted By: Michael Hier (tamaloa)
Assigned to: Nobody (None)
Summary: validates_uniqueness_of broken

Initial Comment:
Hope this is the right place :)

Using jRuby and jdbcsqlite3:
Trying to use validates_uniqueness_of :name in a model has no effect at all. It is possible to create and save several records with the same name! Seems as if the constructed sql-queries do not contain the actual field-string.
Example:
A query to a user model with unique :name would look like this
user_one.save
SELECT users.id FROM users WHERE (users.name = '')
INSERT INTO users (name, created_at, updated_at) VALUES('one', '2009-09-08 15:04:00', '2009-09-08 15:04:00')

----------------------------------------------------------------------

You can respond by visiting: 
http://rubyforge.org/tracker/?func=detail&atid=7857&aid=27067&group_id=2014

Re: Using PostgreSQL with JRuby and Rails

Ryan Bell — 2009-08-27T18:50:28

_______________________________________________
Jruby-extras-devel mailing list
Jruby-extras-devel-GrnCvJ7WPxnNLxjTenLetw< at >public.gmane.org
http://rubyforge.org/mailman/listinfo/jruby-extras-devel