[Dspace-tech] Another Ant fresh_install error: Bad Packet Type

[Rebekah Burke]

Hi all,

I am on step 7, the ant fresh_install step, of installing Dspace 1.5 from the PDF manual, using Oracle 11g on Debian Linux.

I am receiving this Bad Packet Type java error when I run ant fresh_install..




dspace@na-vm-1fv:/home/rburke/dspace-1.5.0-release/dspace/target/dspace-1.5.0-build.dir$ ant fr
esh_install
Buildfile: build.xml

init_installation:

init_configs:
     [copy] Copying 1 file to /usr/local/apache-tomcat-6.0.16/webapps/dspace/config

setup_database:
     [java] 2008-07-21 15:21:06,909 INFO  org.dspace.core.ConfigurationManager @ Loading system provided config property (-Ddspace.configuration): config/dspace.cfg
     [java] 2008-07-21 15:21:06,915 INFO  org.dspace.core.ConfigurationManager @ Using default log4j provided log configuration,if uninitended, check your dspace.cfg for (log.init.config)
     [java] 2008-07-21 15:21:06,915 INFO  org.dspace.storage.rdbms.InitializeDatabase @ Initializing Database
     [java] 2008-07-21 15:21:07,098 FATAL org.dspace.storage.rdbms.InitializeDatabase @ Caught exception:
     [java] java.sql.SQLException: Io exception: Bad packet type
     [java]     at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:112)
     [java]     at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:146)
     [java]     at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:255)
     [java]     at oracle.jdbc.driver.T4CConnection.logon(T4CConnection.java:387)
     [java]     at oracle.jdbc.driver.PhysicalConnection.<init>(PhysicalConnection.java:420)
     [java]     at oracle.jdbc.driver.T4CConnection.<init>(T4CConnection.java:165)
     [java]     at oracle.jdbc.driver.T4CDriverExtension.getConnection(T4CDriverExtension.java:35)
     [java]     at oracle.jdbc.driver.OracleDriver.connect(OracleDriver.java:801)
     [java]     at java.sql.DriverManager.getConnection(DriverManager.java:582)
     [java]     at java.sql.DriverManager.getConnection(DriverManager.java:185)
     [java]     at org.apache.commons.dbcp.DriverManagerConnectionFactory.createConnection(DriverManagerConnectionFactory.java:48)
     [java]     at org.apache.commons.dbcp.PoolableConnectionFactory.makeObject(PoolableConnectionFactory.java:290)
     [java]     at org.apache.commons.pool.impl.GenericObjectPool.borrowObject(GenericObjectPool.java:840)
     [java]     at org.apache.commons.dbcp.PoolingDriver.connect(PoolingDriver.java:175)
     [java]     at java.sql.DriverManager.getConnection(DriverManager.java:582)
     [java]     at java.sql.DriverManager.getConnection(DriverManager.java:207)
     [java]     at org.dspace.storage.rdbms.DatabaseManager.getConnection(DatabaseManager.java:514)
     [java]     at org.dspace.storage.rdbms.DatabaseManager.loadSql(DatabaseManager.java:869)
     [java]     at org.dspace.storage.rdbms.InitializeDatabase.main(InitializeDatabase.java:100)

BUILD FAILED
/home/rburke/dspace-1.5.0-release/dspace/target/dspace-1.5.0-build.dir/build.xml:380: Java returned: 1



I can't find anything about this in relation to Dspace online. It seems to be something to do with the OJDBC drivers. Can anybody help?

Regards,
Rebekah

[Rebekah Burke]

Thanks for that Graham. I took away the ojdbc14.jar, used install-file on ojdb6, changed the pom.xml file to have ojdbc6 instead of 14, but got a Maven error like this when building dspace:

[INFO] Error building POM (may not be this project's POM).

Project ID: org.dspace:dspace
POM Location: /home/rburke/dspace-1.5.0-release/dspace/pom.xml
Validation Messages:

    [0]  'dependencies.dependency.version' is missing for com.oracle:ojdbc6


So, in the pom.xml file, inside this block:

            <dependency>
               <groupId>com.oracle</groupId>
               <artifactId>ojdbc6</artifactId> 
            </dependency>

I added this:
   
               <version>11.1.0.6.0</version>.


This worked. Now when I use ant fresh_install, I'm still getting a similar, but slightly different error to before:

setup_database:
     [java] 2008-07-21 16:29:29,642 INFO  org.dspace.core.ConfigurationManager @ Loading system provided config property (-Ddspace.configuration): config/dspace.cfg
     [java] 2008-07-21 16:29:29,648 INFO  org.dspace.core.ConfigurationManager @ Using default log4j provided log configuration,if uninitended, check your dspace.cfg for (log.init.config)
     [java] 2008-07-21 16:29:29,648 INFO  org.dspace.storage.rdbms.InitializeDatabase @ Initializing Database
     [java] 2008-07-21 16:29:29,920 FATAL org.dspace.storage.rdbms.InitializeDatabase @ Caught exception:
     [java] java.sql.SQLRecoverableException: Io exception: Bad packet type
     [java]     at oracle.jdbc.driver.SQLStateMapping.newSQLException(SQLStateMapping.java:101)
     [java]     at oracle.jdbc.driver.DatabaseError.newSQLException(DatabaseError.java:112)
     [java]     at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:173)
     [java]     at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:229)
     [java]     at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:458)
     [java]     at oracle.jdbc.driver.T4CConnection.logon(T4CConnection.java:411)
     [java]     at oracle.jdbc.driver.PhysicalConnection.<init>(PhysicalConnection.java:490)
     [java]     at oracle.jdbc.driver.T4CConnection.<init>(T4CConnection.java:202)
     [java]     at oracle.jdbc.driver.T4CDriverExtension.getConnection(T4CDriverExtension.java:33)
     [java]     at oracle.jdbc.driver.OracleDriver.connect(OracleDriver.java:465)

     [java]     at java.sql.DriverManager.getConnection(DriverManager.java:582)
     [java]     at java.sql.DriverManager.getConnection(DriverManager.java:185)
     [java]     at org.apache.commons.dbcp.DriverManagerConnectionFactory.createConnection(DriverManagerConnectionFactory.java:48)
     [java]     at org.apache.commons.dbcp.PoolableConnectionFactory.makeObject(PoolableConnectionFactory.java:290)
     [java]     at org.apache.commons.pool.impl.GenericObjectPool.borrowObject(GenericObjectPool.java:840)
     [java]     at org.apache.commons.dbcp.PoolingDriver.connect(PoolingDriver.java:175)
     [java]     at java.sql.DriverManager.getConnection(DriverManager.java:582)
     [java]     at java.sql.DriverManager.getConnection(DriverManager.java:207)
     [java]     at org.dspace.storage.rdbms.DatabaseManager.getConnection(DatabaseManager.java:514)
     [java]     at org.dspace.storage.rdbms.DatabaseManager.loadSql(DatabaseManager.java:869)
     [java]     at org.dspace.storage.rdbms.InitializeDatabase.main(InitializeDatabase.java:100)

On Mon, Jul 21, 2008 at 3:54 PM, Graham Triggs <gra...@biomedcentral.com> wrote:

You need to remove the ojdbc14 jar, and only have the ojdbc6 jar.

The best thing to do is to edit the dspace-parent pom.xml, and change the version number on the ojdbc dependency.

Oracle drivers aren't distributed as part of the Maven repo normally, so you will likely have to manually 'install' it into your local Maven using the install:install-file command:

http://maven.apache.org/plugins/maven-install-plugin/usage.html

Rebekah Burke wrote:

I've got ojbc6.jar, to correspond with my java version.

While building the project with Maven I got an error saying that I'd need to manually download ojdbc14.jar too, so I did that, and stuck it in my dspace-source/lib folder.

However, looking at my [dspace-source]/dspace/target/dspace-1.5.0-build.dir/ directory, in the lib folder there it only shows ojdbc14-10.2.0.2.0.jar ... So I copied ojdbc6.jar in there to see if it would fix the error, but got nothing.

I know that's a bit of a messy explanation, let me know if I can clarify anything. Any ideas?

Thanks,
Rebekah

On Mon, Jul 21, 2008 at 3:29 PM, Graham Triggs <gra...@biomedcentral.com <mailto:gra...@biomedcentral.com>> wrote:

   Sounds like you might have a wonky ojdbc jar.

   What version is it?

   Can you try replacing it with the latest version downloaded from Oracle?

   G

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

       -------------------------------------------------------------------------
       This SF.Net email is sponsored by the Moblin Your Move
       Developer's challenge
       Build the coolest Linux based applications with Moblin SDK & win
       great prizes
       Grand prize is a trip for two to an Open Source event anywhere
       in the world
       http://moblin-contest.org/redirect.php?banner_id=100&url=/
       <http://moblin-contest.org/redirect.php?banner_id=100&url=/>


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

       _______________________________________________
       DSpace-tech mailing list
       DSpac...@lists.sourceforge.net

       <mailto:DSpac...@lists.sourceforge.net>

       https://lists.sourceforge.net/lists/listinfo/dspace-tech


   This email has been scanned by Postini.
   For more information please visit http://www.postini.com

This email has been scanned by Postini.
For more information please visit http://www.postini.com

[Graham Triggs]

Sounds like you might have a wonky ojdbc jar.

What version is it?

Can you try replacing it with the latest version downloaded from Oracle?

G

Rebekah Burke wrote:

> ------------------------------------------------------------------------
>
> -------------------------------------------------------------------------
> This SF.Net email is sponsored by the Moblin Your Move Developer's challenge
> Build the coolest Linux based applications with Moblin SDK & win great prizes
> Grand prize is a trip for two to an Open Source event anywhere in the world
> http://moblin-contest.org/redirect.php?banner_id=100&url=/
>
>

> ------------------------------------------------------------------------
>
> _______________________________________________
> DSpace-tech mailing list
> DSpac...@lists.sourceforge.net

[Rebekah Burke]

I've got ojbc6.jar, to correspond with my java version.

While building the project with Maven I got an error saying that I'd need to manually download ojdbc14.jar too, so I did that, and stuck it in my dspace-source/lib folder.

However, looking at my [dspace-source]/dspace/target/

dspace-1.5.0-build.dir/ directory, in the lib folder there it only shows ojdbc14-10.2.0.2.0.jar ... So I copied ojdbc6.jar in there to see if it would fix the error, but got nothing.

I know that's a bit of a messy explanation, let me know if I can clarify anything. Any ideas?

Thanks,
Rebekah

[Rebekah Burke]

Ok, I'm still having problems..

It turned out that my network admin had installed Oracle 10.2.0.1.0 but told me he'd installed the latest 11g.

I amended my dspace source to suit - edited back the pom.xml file to look for 10g drivers by default, downloaded the oracle 10g ojdbc14.jar. During this I had to download JDK1.5 to replace my 1.6 as ojdbc14 doesn't work with 1.6.

All was going well - the maven installation went fine, though I had to manually install:install-file ojdbc14.jar.

Then onto the ant fresh_install.. and AGAIN I get this error.

Can anybody help? At this stage I am having so much trouble with Dspace that I am considering just abandoning the project.

dspace@na-vm-1fv:/home/rburke/dspace-1.5.0-release/dspace/target/dspace-1.5.0-build
.dir$ ant fresh_install
Buildfile: build.xml

init_installation:

init_configs:

     [copy] Copying 42 files to /usr/local/apache-tomcat-6.0.16/webapps/dspace/config

setup_database:
     [java] 2008-07-23 16:42:04,719 INFO  org.dspace.core.ConfigurationManager @ Loading system provided config property (-Ddspace.configuration): config/dspace.cfg
     [java] 2008-07-23 16:42:04,728 INFO  org.dspace.core.ConfigurationManager @ Using default log4j provided log configuration,if uninitended, check your dspace.cfg for (log.init.config)
     [java] 2008-07-23 16:42:04,729 INFO  org.dspace.storage.rdbms.InitializeDatabase @ Initializing Database
     [java] 2008-07-23 16:42:04,907 FATAL org.dspace.storage.rdbms.InitializeDatabase @ Caught exception:

     [java] java.sql.SQLException: Io exception: Bad packet type
     [java]     at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:112)
     [java]     at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:146)
     [java]     at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:255)
     [java]     at oracle.jdbc.driver.T4CConnection.logon(T4CConnection.java:387)
     [java]     at oracle.jdbc.driver.PhysicalConnection.<init>(PhysicalConnection.java:420)
     [java]     at oracle.jdbc.driver.T4CConnection.<init>(T4CConnection.java:165)
     [java]     at oracle.jdbc.driver.T4CDriverExtension.getConnection(T4CDriverExtension.java:35)
     [java]     at oracle.jdbc.driver.OracleDriver.connect(OracleDriver.java:801)

     [java]     at java.sql.DriverManager.getConnection(DriverManager.java:525)
     [java]     at java.sql.DriverManager.getConnection(DriverManager.java:171)

     [java]     at org.apache.commons.dbcp.DriverManagerConnectionFactory.createConnection(DriverManagerConnectionFactory.java:48)
     [java]     at org.apache.commons.dbcp.PoolableConnectionFactory.makeObject(PoolableConnectionFactory.java:290)
     [java]     at org.apache.commons.pool.impl.GenericObjectPool.borrowObject(GenericObjectPool.java:840)
     [java]     at org.apache.commons.dbcp.PoolingDriver.connect(PoolingDriver.java:175)

     [java]     at java.sql.DriverManager.getConnection(DriverManager.java:525)
     [java]     at java.sql.DriverManager.getConnection(DriverManager.java:193)

     [java]     at org.dspace.storage.rdbms.DatabaseManager.getConnection(DatabaseManager.java:514)
     [java]     at org.dspace.storage.rdbms.DatabaseManager.loadSql(DatabaseManager.java:869)
     [java]     at org.dspace.storage.rdbms.InitializeDatabase.main(InitializeDatabase.java:100)

BUILD FAILED
/home/rburke/dspace-1.5.0-release/dspace/target/dspace-1.5.0-build.dir/build.xml:380: Java returned: 1

Total time: 1 second