[GeoNetwork-devel] GAST setup for GN 2.1beta2 on Solaris 10 against oracle DB error

Hi Andrea and All,

Thanks for the CVS changes on the Jeeves project, got the fix in and
source seems to match well. Although I didn't get the rely message
below, not sure what the deal is with that, will check out my
registration again.

Anyway I'm investigating use of V2.1 and came across the following error
running GAST on Solaris 10 using JRE 1.5.0.12. There was no oracle
driver with this install so I pinched the oracle.jar from the GN V 2.0.3
install. Any thoughts on this one?

java.sql.SQLException: ORA-01401: inserted value too large for column

        at
oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:180)
        at oracle.jdbc.ttc7.TTIoer.processError(TTIoer.java:208)
        at oracle.jdbc.ttc7.Oall7.receive(Oall7.java:543)
        at oracle.jdbc.ttc7.TTC7Protocol.doOall7(TTC7Protocol.java:1451)
        at
oracle.jdbc.ttc7.TTC7Protocol.executeFetch(TTC7Protocol.java:753)
        at
oracle.jdbc.driver.OracleStatement.executeNonQuery(OracleStatement.java:
1845)
        at
oracle.jdbc.driver.OracleStatement.doExecuteOther(OracleStatement.java:1
764)
        at
oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.
java:2354)
        at
oracle.jdbc.driver.OraclePreparedStatement.executeUpdate(OraclePreparedS
tatement.java:421)
        at
org.fao.gast.lib.druid.ImportHandler.handleRow(Import.java:131)
        at
org.fao.gast.lib.druid.DdfLoader.handleRow(DdfLoader.java:117)
        at org.fao.gast.lib.druid.DdfLoader.load(DdfLoader.java:80)
        at org.fao.gast.lib.druid.Import.load(Import.java:34)
        at org.fao.gast.lib.DatabaseLib.fillTables(DatabaseLib.java:412)
        at org.fao.gast.lib.DatabaseLib.setup(DatabaseLib.java:107)
        at
org.fao.gast.gui.panels.database.setup.Worker.run(Worker.java:58)
        at java.lang.Thread.run(Thread.java:595)

Thanks,

Kevin Gunn
Software Engineer
Australian Institute of Marine Science
Ph: (07) 47534305
Fax: (07) 4772 5852
E-mail: k.gunn@anonymised.com
------------------------------------------------------------------------
|
The information contained in this communication is for the use of the
|
individual or entity to whom it is addressed, and may contain
|
information which is the subject of legal privilege and/or copyright.
|
If you have received this communication in error, please notify the
|
sender by return E-Mail and delete the transmission, together with any
|
attachments, from your system. Thank you.
|
------------------------------------------------------------------------
|

-----Original Message-----
From: Greg Coleman
Sent: Wednesday, 15 August 2007 11:27 AM
To: Kevin Gunn
Subject: RE: [GeoNetwork-devel] Chasing old Jeeves source code

-----Original Message-----
From: geonetwork-devel-bounces@lists.sourceforge.net
[mailto:geonetwork-devel-bounces@lists.sourceforge.net] On Behalf Of
Andrea Carboni
Sent: Monday, 13 August 2007 20:25 PM
To: geonetwork-devel@lists.sourceforge.net
Subject: Re: [GeoNetwork-devel] Chasing old Jeeves source code

Hi Kevin,

I see that some problems are happening because of the geonetwork-jeeves
dependancy, particularly the jeeves' version of a geonetwork version.

For the new geonetwork and jeeves versions, I will keep them aligned.
So, geonetwork 2.1 will use jeeves 2.1.

For old versions (like the one you are using) I have re-enabled CVS
access
for jeeves. As far as I remember, the jeeves code for geonetwork 2.0.3
should be in the branch V2_0_FIX3.

Cheers,
Andrea

Hi,

I working with geonetwork 2.0.3 (cause I have to and am not allowed to
upgrade to 2.1) and would like to get a hold of the Jeeves source code
for the version of Jeeves that was used in this geonetwork release

(the

one before Log4j). Can anyone provide me with a copy please?
Specifically I'm looking for a version of the ServiceManager class to
stop it from logging passwords, prefer one that has not been

decompiled

as I have tried a few de-compilers and their all churning out

different

code.

Thanks,

Kevin Gunn
Software Engineer
Australian Institute of Marine Science
Ph: (07) 47534305
Fax: (07) 4772 5852
E-mail: k.gunn@anonymised.com

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

|
The information contained in this communication is for the use of

the

|
individual or entity to whom it is addressed, and may

contain

|
information which is the subject of legal privilege and/or

copyright.

|
If you have received this communication in error, please notify

the

|
sender by return E-Mail and delete the transmission, together with

any

|
attachments, from your system. Thank you.
|

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

|

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

The information contained in this communication is for the use of

the

individual or entity to whom it is addressed, and may

contain

information which is the subject of legal privilege and/or

copyright.

If you have received this communication in error, please notify

the

sender by return E-Mail and delete the transmission, together with

any

attachments, from your system. Thank you.

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

------------------------------------------------------------------------
-
This SF.net email is sponsored by: Splunk Inc.
Still grepping through log files to find problems? Stop.
Now Search log events and configuration files using AJAX and a browser.
Download your FREE copy of Splunk now >> http://get.splunk.com/
_______________________________________________
GeoNetwork-devel mailing list
GeoNetwork-devel@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/geonetwork-devel
GeoNetwork OpenSource is maintained at
http://sourceforge.net/projects/geonetwork

------------------------------------------------------------------------
The information contained in this communication is for the use of the
individual or entity to whom it is addressed, and may contain
information which is the subject of legal privilege and/or copyright.
If you have received this communication in error, please notify the
sender by return E-Mail and delete the transmission, together with any
attachments, from your system. Thank you.
-------------------------------------------------------------------------

Hi,

Some more intel on this.

The table in question is ISOLANGUAGEDES

The desc column is a VAR CHAR 64

But the following have insert attempted. There may be others but looks
like this VAR CHAR needs to be bigger.

"
86 en Church Slavic; Old Slavonic; Church Slavonic; Old
Bulgarian; Old Church Slavonic
86 es Church Slavic; Old Slavonic; Church Slavonic; Old
Bulgarian; Old Church Slavonic
86 cn Church Slavic; Old Slavonic; Church Slavonic; Old
Bulgarian; Old Church Slavonic
86 fr Slavon d'~00E9glise; vieux slave; slavon liturgique;
vieux bulgare
"

Kevin Gunn
Software Engineer
Australian Institute of Marine Science
Ph: (07) 47534305
Fax: (07) 4772 5852
E-mail: k.gunn@anonymised.com
------------------------------------------------------------------------
|
The information contained in this communication is for the use of the
|
individual or entity to whom it is addressed, and may contain
|
information which is the subject of legal privilege and/or copyright.
|
If you have received this communication in error, please notify the
|
sender by return E-Mail and delete the transmission, together with any
|
attachments, from your system. Thank you.
|
------------------------------------------------------------------------
|

-----Original Message-----
From: Kevin Gunn
Sent: Thursday, 16 August 2007 11:18 AM
To: geonetwork-devel@lists.sourceforge.net
Subject: [GeoNetwork-devel] GAST setup for GN 2.1beta2 on Solaris 10
againstoracle DB error

Hi Andrea and All,

Thanks for the CVS changes on the Jeeves project, got the fix in and
source seems to match well. Although I didn't get the rely message
below, not sure what the deal is with that, will check out my
registration again.

Anyway I'm investigating use of V2.1 and came across the following error
running GAST on Solaris 10 using JRE 1.5.0.12. There was no oracle
driver with this install so I pinched the oracle.jar from the GN V 2.0.3
install. Any thoughts on this one?

java.sql.SQLException: ORA-01401: inserted value too large for column

        at
oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:180)
        at oracle.jdbc.ttc7.TTIoer.processError(TTIoer.java:208)
        at oracle.jdbc.ttc7.Oall7.receive(Oall7.java:543)
        at oracle.jdbc.ttc7.TTC7Protocol.doOall7(TTC7Protocol.java:1451)
        at
oracle.jdbc.ttc7.TTC7Protocol.executeFetch(TTC7Protocol.java:753)
        at
oracle.jdbc.driver.OracleStatement.executeNonQuery(OracleStatement.java:
1845)
        at
oracle.jdbc.driver.OracleStatement.doExecuteOther(OracleStatement.java:1
764)
        at
oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.
java:2354)
        at
oracle.jdbc.driver.OraclePreparedStatement.executeUpdate(OraclePreparedS
tatement.java:421)
        at
org.fao.gast.lib.druid.ImportHandler.handleRow(Import.java:131)
        at
org.fao.gast.lib.druid.DdfLoader.handleRow(DdfLoader.java:117)
        at org.fao.gast.lib.druid.DdfLoader.load(DdfLoader.java:80)
        at org.fao.gast.lib.druid.Import.load(Import.java:34)
        at org.fao.gast.lib.DatabaseLib.fillTables(DatabaseLib.java:412)
        at org.fao.gast.lib.DatabaseLib.setup(DatabaseLib.java:107)
        at
org.fao.gast.gui.panels.database.setup.Worker.run(Worker.java:58)
        at java.lang.Thread.run(Thread.java:595)

Thanks,

Kevin Gunn
Software Engineer
Australian Institute of Marine Science
Ph: (07) 47534305
Fax: (07) 4772 5852
E-mail: k.gunn@anonymised.com
------------------------------------------------------------------------
|
The information contained in this communication is for the use of the
|
individual or entity to whom it is addressed, and may contain
|
information which is the subject of legal privilege and/or copyright.
|
If you have received this communication in error, please notify the
|
sender by return E-Mail and delete the transmission, together with any
|
attachments, from your system. Thank you.
|
------------------------------------------------------------------------
|

-----Original Message-----
From: Greg Coleman
Sent: Wednesday, 15 August 2007 11:27 AM
To: Kevin Gunn
Subject: RE: [GeoNetwork-devel] Chasing old Jeeves source code

-----Original Message-----
From: geonetwork-devel-bounces@lists.sourceforge.net
[mailto:geonetwork-devel-bounces@lists.sourceforge.net] On Behalf Of
Andrea Carboni
Sent: Monday, 13 August 2007 20:25 PM
To: geonetwork-devel@lists.sourceforge.net
Subject: Re: [GeoNetwork-devel] Chasing old Jeeves source code

Hi Kevin,

I see that some problems are happening because of the geonetwork-jeeves
dependancy, particularly the jeeves' version of a geonetwork version.

For the new geonetwork and jeeves versions, I will keep them aligned.
So, geonetwork 2.1 will use jeeves 2.1.

For old versions (like the one you are using) I have re-enabled CVS
access
for jeeves. As far as I remember, the jeeves code for geonetwork 2.0.3
should be in the branch V2_0_FIX3.

Cheers,
Andrea

Hi,

I working with geonetwork 2.0.3 (cause I have to and am not allowed to
upgrade to 2.1) and would like to get a hold of the Jeeves source code
for the version of Jeeves that was used in this geonetwork release

(the

one before Log4j). Can anyone provide me with a copy please?
Specifically I'm looking for a version of the ServiceManager class to
stop it from logging passwords, prefer one that has not been

decompiled

as I have tried a few de-compilers and their all churning out

different

code.

Thanks,

Kevin Gunn
Software Engineer
Australian Institute of Marine Science
Ph: (07) 47534305
Fax: (07) 4772 5852
E-mail: k.gunn@anonymised.com

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

|
The information contained in this communication is for the use of

the

|
individual or entity to whom it is addressed, and may

contain

|
information which is the subject of legal privilege and/or

copyright.

|
If you have received this communication in error, please notify

the

|
sender by return E-Mail and delete the transmission, together with

any

|
attachments, from your system. Thank you.
|

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

|

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

The information contained in this communication is for the use of

the

individual or entity to whom it is addressed, and may

contain

information which is the subject of legal privilege and/or

copyright.

If you have received this communication in error, please notify

the

sender by return E-Mail and delete the transmission, together with

any

attachments, from your system. Thank you.

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

------------------------------------------------------------------------
-
This SF.net email is sponsored by: Splunk Inc.
Still grepping through log files to find problems? Stop.
Now Search log events and configuration files using AJAX and a browser.
Download your FREE copy of Splunk now >> http://get.splunk.com/
_______________________________________________
GeoNetwork-devel mailing list
GeoNetwork-devel@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/geonetwork-devel
GeoNetwork OpenSource is maintained at
http://sourceforge.net/projects/geonetwork

------------------------------------------------------------------------
The information contained in this communication is for the use of the
individual or entity to whom it is addressed, and may contain
information which is the subject of legal privilege and/or copyright.
If you have received this communication in error, please notify the
sender by return E-Mail and delete the transmission, together with any
attachments, from your system. Thank you.
------------------------------------------------------------------------
-

------------------------------------------------------------------------
The information contained in this communication is for the use of the
individual or entity to whom it is addressed, and may contain
information which is the subject of legal privilege and/or copyright.
If you have received this communication in error, please notify the
sender by return E-Mail and delete the transmission, together with any
attachments, from your system. Thank you.
-------------------------------------------------------------------------