You are viewing a plain text version of this content. The canonical link for it is here.
Posted to users@maven.apache.org by "Jerrold E. Eads" <je...@enterrasolutions.com> on 2007/10/25 17:30:17 UTC
Issues with connecting to Oracle database when running schema
generator via AndroMDA
Team,
I am new to both AndroMDA and Maven. I have setup an Oracle database to be used for the Timetracker AndroMDA example. After setting up the database I started the Oracle service and listener and I can invoke SQLPlus from the command line with:
sqlplus timetracker/timetracker@TIME
My root/pom.xml information is setup thus:
<dependency>
<groupId>com.oracle</groupId>
<artifactId>ojdbc14</artifactId>
<version>10.2.0.2.0</version>
</dependency>
<sql.mappings>
Oracle9i
</sql.mappings>
<hibernate.dialect>
org.hibernate.dialect.Oracle9Dialect
</hibernate.dialect>
<jdbc.driver>
oracle.jdbc.driver.OracleDriver
</jdbc.driver>
<jdbc.url>
jdbc:oracle:thin:@localhost:1521:TIME
</jdbc.url>
<jdbc.username>Timetracker</jdbc.username>
<jdbc.password>Timetracker</jdbc.password>
<jdbc.exception.sorter>
org.jboss.resource.adapter.jdbc.vendor.OracleExceptionSorter
</jdbc.exception.sorter>
When I run mvn install everything builds successfully. When I look at my local Maven repository I have the following structure:
C:\Documents and Settings\jeads\.m2\repository\com\oracle\ojdbc14\10.2.0.2.0\
ojdbc14-10.2.0.2.0.pom.sha1
ojdbc14-10.2.0.2.0.pom
ojdbc14-10.2.0.2.0.jar
But when I run, mvn -e -f core/pom.xml andromdapp:schema -Dtasks=create, I get:
+ Error stacktraces are turned on.
[INFO] Scanning for projects...
[INFO] Searching repository for plugin with prefix: 'andromdapp'.
[INFO] ----------------------------------------------------------------------------
[INFO] Building TimeTracker Core Business Tier
[INFO] task-segment: [andromdapp:schema]
[INFO] ----------------------------------------------------------------------------
[INFO] [andromdapp:schema]
[INFO] ------------------------------------------------------------------------
[ERROR] BUILD ERROR
[INFO] ------------------------------------------------------------------------
[INFO] An error occured while attempting to create the schema
Embedded error: Io exception: The Network Adapter could not establish the connection
[INFO] ------------------------------------------------------------------------
[INFO] Trace
org.apache.maven.lifecycle.LifecycleExecutionException: An error occured while attempting to create the schema
at org.apache.maven.lifecycle.DefaultLifecycleExecutor.executeGoals(DefaultLifecycleExecutor.java:564)
at org.apache.maven.lifecycle.DefaultLifecycleExecutor.executeStandaloneGoal(DefaultLifecycleExecutor.java:493)
at org.apache.maven.lifecycle.DefaultLifecycleExecutor.executeGoal(DefaultLifecycleExecutor.java:463)
at org.apache.maven.lifecycle.DefaultLifecycleExecutor.executeGoalAndHandleFailures(DefaultLifecycleExecutor.java:311)
at org.apache.maven.lifecycle.DefaultLifecycleExecutor.executeTaskSegments(DefaultLifecycleExecutor.java:278)
at org.apache.maven.lifecycle.DefaultLifecycleExecutor.execute(DefaultLifecycleExecutor.java:143)
at org.apache.maven.DefaultMaven.doExecute(DefaultMaven.java:334)
at org.apache.maven.DefaultMaven.execute(DefaultMaven.java:125)
at org.apache.maven.cli.MavenCli.main(MavenCli.java:280)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
at java.lang.reflect.Method.invoke(Method.java:597)
at org.codehaus.classworlds.Launcher.launchEnhanced(Launcher.java:315)
at org.codehaus.classworlds.Launcher.launch(Launcher.java:255)
at org.codehaus.classworlds.Launcher.mainWithExitCode(Launcher.java:430)
at org.codehaus.classworlds.Launcher.main(Launcher.java:375)
Caused by: org.apache.maven.plugin.MojoExecutionException: An error occured while attempting to create the schema
at org.andromda.maven.plugin.andromdapp.SchemaMojo.execute(SchemaMojo.java:266)
at org.apache.maven.plugin.DefaultPluginManager.executeMojo(DefaultPluginManager.java:443)
at org.apache.maven.lifecycle.DefaultLifecycleExecutor.executeGoals(DefaultLifecycleExecutor.java:539)
... 16 more
Caused by: java.sql.SQLException: Io exception: The Network Adapter could not establish the connection
at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:112)
at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:146)
at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:255)
at oracle.jdbc.driver.T4CConnection.logon(T4CConnection.java:387)
at oracle.jdbc.driver.PhysicalConnection.<init>(PhysicalConnection.java:439)
at oracle.jdbc.driver.T4CConnection.<init>(T4CConnection.java:165)
at oracle.jdbc.driver.T4CDriverExtension.getConnection(T4CDriverExtension.java:35)
at oracle.jdbc.driver.OracleDriver.connect(OracleDriver.java:801)
at org.andromda.maven.plugin.andromdapp.JdbcDriverWrapper.connect(JdbcDriverWrapper.java:44)
at java.sql.DriverManager.getConnection(DriverManager.java:582)
at java.sql.DriverManager.getConnection(DriverManager.java:185)
at org.andromda.maven.plugin.andromdapp.SchemaMojo.getConnection(SchemaMojo.java:463)
at org.andromda.maven.plugin.andromdapp.SchemaMojo.execute(SchemaMojo.java:252)
... 18 more
[INFO] ------------------------------------------------------------------------
[INFO] Total time: 4 seconds
[INFO] Finished at: Thu Oct 25 11:22:07 EDT 2007
[INFO] Final Memory: 6M/12M
[INFO] ------------------------------------------------------------------------
Does anyone have any ideas on what may be causing this?
Thanks
Jerry
Re: Issues with connecting to Oracle database when running schema generator via AndroMDA
Posted by Wayne Fay <wa...@gmail.com>.
Also, I looked at the AndroMDA plugin documentation and it seems to be
a Maven1 plugin. Are you sure this plugin works in M2 at all? You
should probably talk to the AndroMDA people about your issues and make
sure you haven't made any incorrect assumptions...
For the future benefit of others, please post your findings back to
this list, too.
Wayne
On 10/25/07, Wayne Fay <wa...@gmail.com> wrote:
> The stacktrace makes it very clear that the AndroMDA plugin can't get
> a connection to your database.
>
> Make sure you have configured things properly per the plugin docs. It
> doesn't seem to be picking up your jdbc.url etc properties.
>
> Wayne
>
> On 10/25/07, Jerrold E. Eads <je...@enterrasolutions.com> wrote:
> > Team,
> > I am new to both AndroMDA and Maven. I have setup an Oracle database to be used for the Timetracker AndroMDA example. After setting up the database I started the Oracle service and listener and I can invoke SQLPlus from the command line with:
> > sqlplus timetracker/timetracker@TIME
> >
> > My root/pom.xml information is setup thus:
> > <dependency>
> > <groupId>com.oracle</groupId>
> > <artifactId>ojdbc14</artifactId>
> > <version>10.2.0.2.0</version>
> > </dependency>
> >
> > <sql.mappings>
> > Oracle9i
> > </sql.mappings>
> >
> > <hibernate.dialect>
> > org.hibernate.dialect.Oracle9Dialect
> > </hibernate.dialect>
> >
> > <jdbc.driver>
> > oracle.jdbc.driver.OracleDriver
> > </jdbc.driver>
> >
> > <jdbc.url>
> > jdbc:oracle:thin:@localhost:1521:TIME
> > </jdbc.url>
> > <jdbc.username>Timetracker</jdbc.username>
> > <jdbc.password>Timetracker</jdbc.password>
> >
> > <jdbc.exception.sorter>
> > org.jboss.resource.adapter.jdbc.vendor.OracleExceptionSorter
> > </jdbc.exception.sorter>
> >
> > When I run mvn install everything builds successfully. When I look at my local Maven repository I have the following structure:
> > C:\Documents and Settings\jeads\.m2\repository\com\oracle\ojdbc14\10.2.0.2.0\
> > ojdbc14-10.2.0.2.0.pom.sha1
> > ojdbc14-10.2.0.2.0.pom
> > ojdbc14-10.2.0.2.0.jar
> >
> > But when I run, mvn -e -f core/pom.xml andromdapp:schema -Dtasks=create, I get:
> > + Error stacktraces are turned on.
> > [INFO] Scanning for projects...
> > [INFO] Searching repository for plugin with prefix: 'andromdapp'.
> > [INFO] ----------------------------------------------------------------------------
> > [INFO] Building TimeTracker Core Business Tier
> > [INFO] task-segment: [andromdapp:schema]
> > [INFO] ----------------------------------------------------------------------------
> > [INFO] [andromdapp:schema]
> > [INFO] ------------------------------------------------------------------------
> > [ERROR] BUILD ERROR
> > [INFO] ------------------------------------------------------------------------
> > [INFO] An error occured while attempting to create the schema
> >
> > Embedded error: Io exception: The Network Adapter could not establish the connection
> > [INFO] ------------------------------------------------------------------------
> > [INFO] Trace
> > org.apache.maven.lifecycle.LifecycleExecutionException: An error occured while attempting to create the schema
> > at org.apache.maven.lifecycle.DefaultLifecycleExecutor.executeGoals(DefaultLifecycleExecutor.java:564)
> > at org.apache.maven.lifecycle.DefaultLifecycleExecutor.executeStandaloneGoal(DefaultLifecycleExecutor.java:493)
> > at org.apache.maven.lifecycle.DefaultLifecycleExecutor.executeGoal(DefaultLifecycleExecutor.java:463)
> > at org.apache.maven.lifecycle.DefaultLifecycleExecutor.executeGoalAndHandleFailures(DefaultLifecycleExecutor.java:311)
> > at org.apache.maven.lifecycle.DefaultLifecycleExecutor.executeTaskSegments(DefaultLifecycleExecutor.java:278)
> > at org.apache.maven.lifecycle.DefaultLifecycleExecutor.execute(DefaultLifecycleExecutor.java:143)
> > at org.apache.maven.DefaultMaven.doExecute(DefaultMaven.java:334)
> > at org.apache.maven.DefaultMaven.execute(DefaultMaven.java:125)
> > at org.apache.maven.cli.MavenCli.main(MavenCli.java:280)
> > at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
> > at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
> > at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
> > at java.lang.reflect.Method.invoke(Method.java:597)
> > at org.codehaus.classworlds.Launcher.launchEnhanced(Launcher.java:315)
> > at org.codehaus.classworlds.Launcher.launch(Launcher.java:255)
> > at org.codehaus.classworlds.Launcher.mainWithExitCode(Launcher.java:430)
> > at org.codehaus.classworlds.Launcher.main(Launcher.java:375)
> > Caused by: org.apache.maven.plugin.MojoExecutionException: An error occured while attempting to create the schema
> > at org.andromda.maven.plugin.andromdapp.SchemaMojo.execute(SchemaMojo.java:266)
> > at org.apache.maven.plugin.DefaultPluginManager.executeMojo(DefaultPluginManager.java:443)
> > at org.apache.maven.lifecycle.DefaultLifecycleExecutor.executeGoals(DefaultLifecycleExecutor.java:539)
> > ... 16 more
> > Caused by: java.sql.SQLException: Io exception: The Network Adapter could not establish the connection
> > at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:112)
> > at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:146)
> > at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:255)
> > at oracle.jdbc.driver.T4CConnection.logon(T4CConnection.java:387)
> > at oracle.jdbc.driver.PhysicalConnection.<init>(PhysicalConnection.java:439)
> > at oracle.jdbc.driver.T4CConnection.<init>(T4CConnection.java:165)
> > at oracle.jdbc.driver.T4CDriverExtension.getConnection(T4CDriverExtension.java:35)
> > at oracle.jdbc.driver.OracleDriver.connect(OracleDriver.java:801)
> > at org.andromda.maven.plugin.andromdapp.JdbcDriverWrapper.connect(JdbcDriverWrapper.java:44)
> > at java.sql.DriverManager.getConnection(DriverManager.java:582)
> > at java.sql.DriverManager.getConnection(DriverManager.java:185)
> > at org.andromda.maven.plugin.andromdapp.SchemaMojo.getConnection(SchemaMojo.java:463)
> > at org.andromda.maven.plugin.andromdapp.SchemaMojo.execute(SchemaMojo.java:252)
> > ... 18 more
> > [INFO] ------------------------------------------------------------------------
> > [INFO] Total time: 4 seconds
> > [INFO] Finished at: Thu Oct 25 11:22:07 EDT 2007
> > [INFO] Final Memory: 6M/12M
> > [INFO] ------------------------------------------------------------------------
> >
> > Does anyone have any ideas on what may be causing this?
> >
> > Thanks
> > Jerry
> >
>
---------------------------------------------------------------------
To unsubscribe, e-mail: users-unsubscribe@maven.apache.org
For additional commands, e-mail: users-help@maven.apache.org
Re: Issues with connecting to Oracle database when running schema generator via AndroMDA
Posted by Wayne Fay <wa...@gmail.com>.
The stacktrace makes it very clear that the AndroMDA plugin can't get
a connection to your database.
Make sure you have configured things properly per the plugin docs. It
doesn't seem to be picking up your jdbc.url etc properties.
Wayne
On 10/25/07, Jerrold E. Eads <je...@enterrasolutions.com> wrote:
> Team,
> I am new to both AndroMDA and Maven. I have setup an Oracle database to be used for the Timetracker AndroMDA example. After setting up the database I started the Oracle service and listener and I can invoke SQLPlus from the command line with:
> sqlplus timetracker/timetracker@TIME
>
> My root/pom.xml information is setup thus:
> <dependency>
> <groupId>com.oracle</groupId>
> <artifactId>ojdbc14</artifactId>
> <version>10.2.0.2.0</version>
> </dependency>
>
> <sql.mappings>
> Oracle9i
> </sql.mappings>
>
> <hibernate.dialect>
> org.hibernate.dialect.Oracle9Dialect
> </hibernate.dialect>
>
> <jdbc.driver>
> oracle.jdbc.driver.OracleDriver
> </jdbc.driver>
>
> <jdbc.url>
> jdbc:oracle:thin:@localhost:1521:TIME
> </jdbc.url>
> <jdbc.username>Timetracker</jdbc.username>
> <jdbc.password>Timetracker</jdbc.password>
>
> <jdbc.exception.sorter>
> org.jboss.resource.adapter.jdbc.vendor.OracleExceptionSorter
> </jdbc.exception.sorter>
>
> When I run mvn install everything builds successfully. When I look at my local Maven repository I have the following structure:
> C:\Documents and Settings\jeads\.m2\repository\com\oracle\ojdbc14\10.2.0.2.0\
> ojdbc14-10.2.0.2.0.pom.sha1
> ojdbc14-10.2.0.2.0.pom
> ojdbc14-10.2.0.2.0.jar
>
> But when I run, mvn -e -f core/pom.xml andromdapp:schema -Dtasks=create, I get:
> + Error stacktraces are turned on.
> [INFO] Scanning for projects...
> [INFO] Searching repository for plugin with prefix: 'andromdapp'.
> [INFO] ----------------------------------------------------------------------------
> [INFO] Building TimeTracker Core Business Tier
> [INFO] task-segment: [andromdapp:schema]
> [INFO] ----------------------------------------------------------------------------
> [INFO] [andromdapp:schema]
> [INFO] ------------------------------------------------------------------------
> [ERROR] BUILD ERROR
> [INFO] ------------------------------------------------------------------------
> [INFO] An error occured while attempting to create the schema
>
> Embedded error: Io exception: The Network Adapter could not establish the connection
> [INFO] ------------------------------------------------------------------------
> [INFO] Trace
> org.apache.maven.lifecycle.LifecycleExecutionException: An error occured while attempting to create the schema
> at org.apache.maven.lifecycle.DefaultLifecycleExecutor.executeGoals(DefaultLifecycleExecutor.java:564)
> at org.apache.maven.lifecycle.DefaultLifecycleExecutor.executeStandaloneGoal(DefaultLifecycleExecutor.java:493)
> at org.apache.maven.lifecycle.DefaultLifecycleExecutor.executeGoal(DefaultLifecycleExecutor.java:463)
> at org.apache.maven.lifecycle.DefaultLifecycleExecutor.executeGoalAndHandleFailures(DefaultLifecycleExecutor.java:311)
> at org.apache.maven.lifecycle.DefaultLifecycleExecutor.executeTaskSegments(DefaultLifecycleExecutor.java:278)
> at org.apache.maven.lifecycle.DefaultLifecycleExecutor.execute(DefaultLifecycleExecutor.java:143)
> at org.apache.maven.DefaultMaven.doExecute(DefaultMaven.java:334)
> at org.apache.maven.DefaultMaven.execute(DefaultMaven.java:125)
> at org.apache.maven.cli.MavenCli.main(MavenCli.java:280)
> at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
> at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
> at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
> at java.lang.reflect.Method.invoke(Method.java:597)
> at org.codehaus.classworlds.Launcher.launchEnhanced(Launcher.java:315)
> at org.codehaus.classworlds.Launcher.launch(Launcher.java:255)
> at org.codehaus.classworlds.Launcher.mainWithExitCode(Launcher.java:430)
> at org.codehaus.classworlds.Launcher.main(Launcher.java:375)
> Caused by: org.apache.maven.plugin.MojoExecutionException: An error occured while attempting to create the schema
> at org.andromda.maven.plugin.andromdapp.SchemaMojo.execute(SchemaMojo.java:266)
> at org.apache.maven.plugin.DefaultPluginManager.executeMojo(DefaultPluginManager.java:443)
> at org.apache.maven.lifecycle.DefaultLifecycleExecutor.executeGoals(DefaultLifecycleExecutor.java:539)
> ... 16 more
> Caused by: java.sql.SQLException: Io exception: The Network Adapter could not establish the connection
> at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:112)
> at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:146)
> at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:255)
> at oracle.jdbc.driver.T4CConnection.logon(T4CConnection.java:387)
> at oracle.jdbc.driver.PhysicalConnection.<init>(PhysicalConnection.java:439)
> at oracle.jdbc.driver.T4CConnection.<init>(T4CConnection.java:165)
> at oracle.jdbc.driver.T4CDriverExtension.getConnection(T4CDriverExtension.java:35)
> at oracle.jdbc.driver.OracleDriver.connect(OracleDriver.java:801)
> at org.andromda.maven.plugin.andromdapp.JdbcDriverWrapper.connect(JdbcDriverWrapper.java:44)
> at java.sql.DriverManager.getConnection(DriverManager.java:582)
> at java.sql.DriverManager.getConnection(DriverManager.java:185)
> at org.andromda.maven.plugin.andromdapp.SchemaMojo.getConnection(SchemaMojo.java:463)
> at org.andromda.maven.plugin.andromdapp.SchemaMojo.execute(SchemaMojo.java:252)
> ... 18 more
> [INFO] ------------------------------------------------------------------------
> [INFO] Total time: 4 seconds
> [INFO] Finished at: Thu Oct 25 11:22:07 EDT 2007
> [INFO] Final Memory: 6M/12M
> [INFO] ------------------------------------------------------------------------
>
> Does anyone have any ideas on what may be causing this?
>
> Thanks
> Jerry
>
---------------------------------------------------------------------
To unsubscribe, e-mail: users-unsubscribe@maven.apache.org
For additional commands, e-mail: users-help@maven.apache.org